时序数据库查询错误
-
检查容器
检查
树状形式文档形式
{
"Id":"99cbca97239ae9d901e0fe7ef4f47f4356c8d69ec0899b81765e071f39231319",
"Created":"2025-04-10T05:23:25.055298757Z",
"Path":"/entrypoint.sh",
"Args":["influxd"],
"State":{
"Status":"restarting",
"Running":true,
"Paused":false,
"Restarting":true,
"OOMKilled":false,
"Dead":false,
"Pid":0,
"ExitCode":2,
"Error":"",
"StartedAt":"2026-01-21T06:07:44.066619948Z",
"FinishedAt":"2026-01-21T06:07:52.837423483Z"
},
"Image":"sha256:d918bc1feeef58203db58b5c00f0729fece29cbbb82b0381c1e8253c702c6737",
"ResolvConfPath":"/home/app/airiot/docker/containers/99cbca97239ae9d901e0fe7ef4f47f4356c8d69ec0899b81765e071f39231319/resolv.conf",
"HostnamePath":"/home/app/airiot/docker/containers/99cbca97239ae9d901e0fe7ef4f47f4356c8d69ec0899b81765e071f39231319/hostname",
"HostsPath":"/home/app/airiot/docker/containers/99cbca97239ae9d901e0fe7ef4f47f4356c8d69ec0899b81765e071f39231319/hosts",
"LogPath":"/home/app/airiot/docker/containers/99cbca97239ae9d901e0fe7ef4f47f4356c8d69ec0899b81765e071f39231319/99cbca97239ae9d901e0fe7ef4f47f4356c8d69ec0899b81765e071f39231319-json.log",
"Name":"/influx",
"RestartCount":422,
"Driver":"overlay2",
"Platform":"linux",
"MountLabel":"",
"ProcessLabel":"",
"AppArmorProfile":"",
"ExecIDs":null,
"HostConfig":{
"Binds":["/etc/localtime:/etc/localtime:ro",
"/home/app/airiot/influxdb.conf:/etc/influxdb/influxdb.conf:rw",
"/home/app/airiot/db/influxdb:/var/lib/influxdb:rw"],
"ContainerIDFile":"",
"LogConfig":{
"Type":"json-file",
"Config":{
"max-file":"1",
"max-size":"100m"}
},
"NetworkMode":"app_backend",
"PortBindings":{}, "RestartPolicy":{ "Name":"always", "MaximumRetryCount":0 }, "AutoRemove":false, "VolumeDriver":"", "VolumesFrom":null, "ConsoleSize":[0, 0], "CapAdd":null, "CapDrop":null, "CgroupnsMode":"", "Dns":[], "DnsOptions":[], "DnsSearch":[], "ExtraHosts":null, "GroupAdd":null, "IpcMode":"private", "Cgroup":"", "Links":null, "OomScoreAdj":0, "PidMode":"", "Privileged":false, "PublishAllPorts":false, "ReadonlyRootfs":false, "SecurityOpt":null, "UTSMode":"", "UsernsMode":"", "ShmSize":67108864, "Runtime":"runc", "Isolation":"", "CpuShares":0, "Memory":0, "NanoCpus":0, "CgroupParent":"", "BlkioWeight":0, "BlkioWeightDevice":null, "BlkioDeviceReadBps":null, "BlkioDeviceWriteBps":null, "BlkioDeviceReadIOps":null, "BlkioDeviceWriteIOps":null, "CpuPeriod":0, "CpuQuota":0, "CpuRealtimePeriod":0, "CpuRealtimeRuntime":0, "CpusetCpus":"", "CpusetMems":"", "Devices":null, "DeviceCgroupRules":null, "DeviceRequests":null, "MemoryReservation":0, "MemorySwap":0, "MemorySwappiness":null, "OomKillDisable":false, "PidsLimit":null, "Ulimits":[{ "Name":"nofile", "Hard":30720, "Soft":10240 }, { "Name":"nproc", "Hard":40960, "Soft":40960}], "CpuCount":0, "CpuPercent":0, "IOMaximumIOps":0, "IOMaximumBandwidth":0, "MaskedPaths":["/proc/asound", "/proc/acpi", "/proc/kcore", "/proc/keys", "/proc/latency_stats", "/proc/timer_list", "/proc/timer_stats", "/proc/sched_debug", "/proc/scsi", "/sys/firmware"], "ReadonlyPaths":["/proc/bus", "/proc/fs", "/proc/irq", "/proc/sys", "/proc/sysrq-trigger"] }, "GraphDriver":{ "Data":{ "LowerDir":"/home/app/airiot/docker/overlay2/159775c2d5ffbcc4febd19b20b8b1b96a3d56654beae1d3dd51eeb0b946ed96d-init/diff:/home/app/airiot/docker/overlay2/8f6721c6ed4c947f1de0c10f5bd9c822ace567b622f99c07e02c0c7c1a8855a3/diff:/home/app/airiot/docker/overlay2/ac27986bc9057820c03319680863f4a39df80a7efe0fbdb4c95e80860ea0a37a/diff:/home/app/airiot/docker/overlay2/53d2d0ada0bcfc3aed7218947a1b6d0bd54240257a29f8359d8055e0c040ae3f/diff:/home/app/airiot/docker/overlay2/08774460929f1109d6a650a655a31665a8550dc7e294a9e580012d23aeffa335/diff:/home/app/airiot/docker/overlay2/ac2a258a2658a00967bf11e588fce74ef9467fd152bde1b484f7d0224516eb58/diff:/home/app/airiot/docker/overlay2/5a33383a064853bf3e1d5e8a6ae496101fa56f84ae35a4a260e155b66756f7a8/diff:/home/app/airiot/docker/overlay2/20042e3a01fd5d0fdbe7101258b9d8be0096a664b4c7c3f611e5016bd1dc8609/diff", "MergedDir":"/home/app/airiot/docker/overlay2/159775c2d5ffbcc4febd19b20b8b1b96a3d56654beae1d3dd51eeb0b946ed96d/merged", "UpperDir":"/home/app/airiot/docker/overlay2/159775c2d5ffbcc4febd19b20b8b1b96a3d56654beae1d3dd51eeb0b946ed96d/diff", "WorkDir":"/home/app/airiot/docker/overlay2/159775c2d5ffbcc4febd19b20b8b1b96a3d56654beae1d3dd51eeb0b946ed96d/work" }, "Name":"overlay2" }, "Mounts":[{ "Type":"bind", "Source":"/home/app/airiot/influxdb.conf", "Destination":"/etc/influxdb/influxdb.conf", "Mode":"rw", "RW":true, "Propagation":"rprivate" }, { "Type":"bind", "Source":"/etc/localtime", "Destination":"/etc/localtime", "Mode":"ro", "RW":false, "Propagation":"rprivate" }, { "Type":"bind", "Source":"/home/app/airiot/db/influxdb", "Destination":"/var/lib/influxdb", "Mode":"rw", "RW":true, "Propagation":"rprivate"}], "Config":{ "Hostname":"99cbca97239a", "Domainname":"", "User":"", "AttachStdin":false, "AttachStdout":true, "AttachStderr":true, "ExposedPorts":{ "8086/tcp":{ } }, "Tty":false, "OpenStdin":false, "StdinOnce":false, "Env":["INFLUXDB_DB=tsdb", "INFLUXDB_HTTP_AUTH_ENABLED=true", "INFLUXDB_ADMIN_USER=admin", "INFLUXDB_ADMIN_PASSWORD=qVPWSP9zxv", "PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin", "INFLUXDB_VERSION=1.8.10"], "Cmd":["influxd"], "Image":"influxdb:1.8.10-alpine", "Volumes":{ "/etc/influxdb/influxdb.conf":{ }, "/etc/localtime":{ }, "/var/lib/influxdb":{ } }, "WorkingDir":"", "Entrypoint":["/entrypoint.sh"], "OnBuild":null, "Labels":{ "com.docker.compose.config-hash":"32b091278134a0c5c240f125023bf28f4356ea366f98c5c6e0bedc444a85d5d0", "com.docker.compose.container-number":"1", "com.docker.compose.depends_on":"", "com.docker.compose.image":"sha256:d918bc1feeef58203db58b5c00f0729fece29cbbb82b0381c1e8253c702c6737", "com.docker.compose.oneoff":"False", "com.docker.compose.project":"app", "com.docker.compose.project.config_files":"/home/app/docker-compose.yml", "com.docker.compose.project.working_dir":"/home/app", "com.docker.compose.service":"influx", "com.docker.compose.version":"2.2.2"} }, "NetworkSettings":{ "Bridge":"", "SandboxID":"2789b77ac50a32b6c4b7817754c3cd4470bcc15e43faf699baf8b43215a10c74", "SandboxKey":"/var/run/docker/netns/2789b77ac50a", "Ports":{ }, "HairpinMode":false, "LinkLocalIPv6Address":"", "LinkLocalIPv6PrefixLen":0, "SecondaryIPAddresses":null, "SecondaryIPv6Addresses":null, "EndpointID":"", "Gateway":"", "GlobalIPv6Address":"", "GlobalIPv6PrefixLen":0, "IPAddress":"", "IPPrefixLen":0, "IPv6Gateway":"", "MacAddress":"", "Networks":{ "app_backend":{ "IPAMConfig":null, "Links":null, "Aliases":["influx", "influx", "99cbca97239a"], "MacAddress":"", "DriverOpts":null, "NetworkID":"94c48086ea04993fe09fd01973b0dc02d13f8b8df0f27ec6cdae175eb847822c", "EndpointID":"", "Gateway":"", "IPAddress":"", "IPPrefixLen":0, "IPv6Gateway":"", "GlobalIPv6Address":"", "GlobalIPv6PrefixLen":0, "DNSNames":null }, "operation_backend":{ "IPAMConfig":null, "Links":null, "Aliases":["influx", "influx", "99cbca97239a"], "MacAddress":"", "DriverOpts":null, "NetworkID":"476c45fbca168af20dc819dacaaefada42858ab16fad177450a9ad5b85f0d4e4", "EndpointID":"", "Gateway":"", "IPAddress":"", "IPPrefixLen":0, "IPv6Gateway":"", "GlobalIPv6Address":"", "GlobalIPv6PrefixLen":0, "DNSNames":null}}}} -
发一下安装目录下的docker-compose.yml文件
可以通过这个在线传输上传 https://wormhole.app/ -
服务器root 密码进不去了，还有没有别的办法？
-
部署文件已经上传
-
时序数据库查询错误
Post "http://influx:8086/query?db=default¶ms=null&q=select++mean("D675")+from+"A油田抽油机"++where+id+%3D+'242'++++++and+time+>+'2026-01-22T00%3A51%3A00.000Z'+and+time+<%3D+'2026-01-22T00%3A51%3A38.676Z'+++order+by+time+asc++%3B": dial tcp 172.19.0.47:8086: connect: connection refused
不行，还是那样
-
-
此回复已被删除！
