不上数报警配置后在设备离线时不产生报警

[yfyfzw]

如题，

现场用的是LINUX服务器，连接的是AP PLC

[yfyfzw]

请复现问题，及时修复更新版本，谢谢

[核桃酥]

你配置的什么报警规则

[yfyfzw]

在变量配置中做的不上数报警

[核桃酥]

warning 日志有什么报错

[yfyfzw]

现在生产了，没法做实验了，当前没发现啥异常

[yfyfzw]

�time=2024-01-11T15:57:12.506+08:00 level=ERROR msg="ERROR: time zone displacement out of range: "now - 24h" (SQLSTATE 22009)" logType=syslog service=warning



�2024/01/11 15:58:05 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.2.80/gormdb/gorm.go:159 ERROR: time zone displacement out of range: "now - 24h" (SQLSTATE 22009)


�[1.183ms] [rows:0] SELECT count() FROM "default"."warning" WHERE ((("time" = 'now - 24h' AND "tableData" = 'PSZ_2') OR ("time" = 'now - 24h' AND "tableData" = '二破破碎下料口1') OR ("time" = 'now - 24h' AND "tableData" = '二号破碎站破碎机监控') OR "desc" like '%二破小时量起始计量%') AND ("table" = '实时监控' OR "table" = 'httpserver' OR "table" = 'PLCAB' OR "table" = 'ISC'))

�time=2024-01-11T15:58:05.148+08:00 level=ERROR msg="ERROR: time zone displacement out of range: "now - 24h" (SQLSTATE 22009)" logType=syslog service=warning



�2024/01/11 15:58:05 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.2.80/gormdb/gorm.go:159 ERROR: time zone displacement out of range: "now - 24h" (SQLSTATE 22009)


�[0.513ms] [rows:0] SELECT count() FROM "default"."warning" WHERE ((("time" = 'now - 24h' AND "tableData" = 'PSZ_2') OR ("time" = 'now - 24h' AND "tableData" = '二破破碎下料口1') OR ("time" = 'now - 24h' AND "tableData" = '二号破碎站破碎机监控') OR "desc" like '%二破小时量起始计量%') AND ("table" = '实时监控' OR "table" = 'httpserver' OR "table" = 'PLCAB' OR "table" = 'ISC'))

�time=2024-01-11T15:58:05.263+08:00 level=ERROR msg="ERROR: time zone displacement out of range: "now - 24h" (SQLSTATE 22009)" logType=syslog service=warning



�2024/01/11 16:40:30 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.2.80/gormdb/gorm.go:159 ERROR: time zone displacement out of range: "now - 24h" (SQLSTATE 22009)


�[20.081ms] [rows:0] SELECT count() FROM "default"."warning" WHERE ((("time" = 'now - 24h' AND "tableData" = 'PSZ_2') OR ("time" = 'now - 24h' AND "tableData" = '二破破碎下料口1') OR ("time" = 'now - 24h' AND "tableData" = '二号破碎站破碎机监控') OR "desc" like '%二破小时量起始计量%') AND ("table" = '实时监控' OR "table" = 'httpserver' OR "table" = 'PLCAB' OR "table" = 'ISC'))

�time=2024-01-11T16:40:30.729+08:00 level=ERROR msg="ERROR: time zone displacement out of range: "now - 24h" (SQLSTATE 22009)" logType=syslog service=warning



�2024/01/11 16:40:30 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.2.80/gormdb/gorm.go:159 ERROR: time zone displacement out of range: "now - 24h" (SQLSTATE 22009)


�[20.554ms] [rows:0] SELECT count() FROM "default"."warning" WHERE ((("time" = 'now - 24h' AND "tableData" = 'PSZ_2') OR ("time" = 'now - 24h' AND "tableData" = '二破破碎下料口1') OR ("time" = 'now - 24h' AND "tableData" = '二号破碎站破碎机监控') OR "desc" like '%二破小时量起始计量%') AND ("table" = '实时监控' OR "table" = 'httpserver' OR "table" = 'PLCAB' OR "table" = 'ISC'))

�time=2024-01-11T16:40:30.890+08:00 level=ERROR msg="ERROR: time zone displacement out of range: "now - 24h" (SQLSTATE 22009)" logType=syslog service=warning



�2024/01/12 17:13:26 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.2.80/gormdb/gorm.go:159 ERROR: time zone displacement out of range: "now - 24h" (SQLSTATE 22009)


�[2.919ms] [rows:0] SELECT count() FROM "default"."warning" WHERE ((("time" = 'now - 24h' AND "tableData" = 'PSZ_2') OR ("time" = 'now - 24h' AND "tableData" = '二破破碎下料口1') OR ("tableData" = '二号破碎站破碎机监控' AND "time" = 'now - 24h') OR "desc" like '%二破小时量起始计量%') AND ("table" = '实时监控' OR "table" = 'httpserver' OR "table" = 'PLCAB' OR "table" = 'ISC'))

�time=2024-01-12T17:13:26.474+08:00 level=ERROR msg="ERROR: time zone displacement out of range: "now - 24h" (SQLSTATE 22009)" logType=syslog service=warning



�2024/01/12 17:13:26 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.2.80/gormdb/gorm.go:159 ERROR: time zone displacement out of range: "now - 24h" (SQLSTATE 22009)


�[0.862ms] [rows:0] SELECT count() FROM "default"."warning" WHERE ((("time" = 'now - 24h' AND "tableData" = 'PSZ_2') OR ("time" = 'now - 24h' AND "tableData" = '二破破碎下料口1') OR ("time" = 'now - 24h' AND "tableData" = '二号破碎站破碎机监控') OR "desc" like '%二破小时量起始计量%') AND ("table" = '实时监控' OR "table" = 'httpserver' OR "table" = 'PLCAB' OR "table" = 'ISC'))

�time=2024-01-12T17:13:26.633+08:00 level=ERROR msg="ERROR: time zone displacement out of range: "now - 24h" (SQLSTATE 22009)" logType=syslog service=warning



�2024/01/13 16:36:50 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.2.80/gormdb/gorm.go:159 ERROR: time zone displacement out of range: "now - 24h" (SQLSTATE 22009)


�[1.515ms] [rows:0] SELECT count() FROM "default"."warning" WHERE ((("time" = 'now - 24h' AND "tableData" = 'PSZ_2') OR ("time" = 'now - 24h' AND "tableData" = '二破破碎下料口1') OR ("time" = 'now - 24h' AND "tableData" = '二号破碎站破碎机监控') OR "desc" like '%二破小时量起始计量%') AND ("table" = '实时监控' OR "table" = 'httpserver' OR "table" = 'PLCAB' OR "table" = 'ISC'))

�time=2024-01-13T16:36:50.002+08:00 level=ERROR msg="ERROR: time zone displacement out of range: "now - 24h" (SQLSTATE 22009)" logType=syslog service=warning



�2024/01/13 16:36:50 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.2.80/gormdb/gorm.go:159 ERROR: time zone displacement out of range: "now - 24h" (SQLSTATE 22009)


�[20.371ms] [rows:0] SELECT count() FROM "default"."warning" WHERE ((("time" = 'now - 24h' AND "tableData" = 'PSZ_2') OR ("time" = 'now - 24h' AND "tableData" = '二破破碎下料口1') OR ("tableData" = '二号破碎站破碎机监控' AND "time" = 'now - 24h') OR "desc" like '%二破小时量起始计量%') AND ("table" = '实时监控' OR "table" = 'httpserver' OR "table" = 'PLCAB' OR "table" = 'ISC'))

�time=2024-01-13T16:36:50.280+08:00 level=ERROR msg="ERROR: time zone displacement out of range: "now - 24h" (SQLSTATE 22009)" logType=syslog service=warning



�2024/01/13 16:37:34 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.2.80/gormdb/gorm.go:159 ERROR: time zone displacement out of range: "now - 24h" (SQLSTATE 22009)


�[1.410ms] [rows:0] SELECT count() FROM "default"."warning" WHERE ((("time" = 'now - 24h' AND "tableData" = 'PSZ_2') OR ("time" = 'now - 24h' AND "tableData" = '二破破碎下料口1') OR ("time" = 'now - 24h' AND "tableData" = '二号破碎站破碎机监控') OR "desc" like '%二破小时量起始计量%') AND ("table" = '实时监控' OR "table" = 'httpserver' OR "table" = 'PLCAB' OR "table" = 'ISC'))

�time=2024-01-13T16:37:34.378+08:00 level=ERROR msg="ERROR: time zone displacement out of range: "now - 24h" (SQLSTATE 22009)" logType=syslog service=warning



�2024/01/13 16:37:34 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.2.80/gormdb/gorm.go:159 ERROR: time zone displacement out of range: "now - 24h" (SQLSTATE 22009)


�[0.628ms] [rows:0] SELECT count() FROM "default"."warning" WHERE ((("time" = 'now - 24h' AND "tableData" = 'PSZ_2') OR ("time" = 'now - 24h' AND "tableData" = '二破破碎下料口1') OR ("time" = 'now - 24h' AND "tableData" = '二号破碎站破碎机监控') OR "desc" like '%二破小时量起始计量%') AND ("table" = '实时监控' OR "table" = 'httpserver' OR "table" = 'PLCAB' OR "table" = 'ISC'))

�time=2024-01-13T16:37:34.394+08:00 level=ERROR msg="ERROR: time zone displacement out of range: "now - 24h" (SQLSTATE 22009)" logType=syslog service=warning



�2024/01/15 09:21:09 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.2.80/gormdb/gorm.go:159 timeout: context canceled

�[75.247ms] [rows:0] SELECT count() FROM "default"."warning" WHERE "recoveryTime" IS NULL AND "tableData" in ('PSZ_3') AND "status" in ('未确认')



�2024/01/15 09:21:09 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.2.80/gormdb/gorm.go:159 timeout: context canceled

�[73.142ms] [rows:0] SELECT count() FROM "default"."warning" WHERE "recoveryTime" IS NULL AND "tableData" in ('PSZ_2') AND "status" in ('未确认')

rtime=2024-01-15T09:21:09.662+08:00 level=ERROR msg="timeout: context canceled" logType=syslog service=warning

rtime=2024-01-15T09:21:09.662+08:00 level=ERROR msg="timeout: context canceled" logType=syslog service=warning



�2024/01/15 17:36:13 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.2.80/gormdb/gorm.go:162 timeout: context canceled

�[31.779ms] [rows:0] SELECT "fields","id","status","tableData","processed","handle" FROM "default"."warning" WHERE "tableData" in ('PSZ_3') AND "status" in ('未确认') AND "recoveryTime" IS NULL ORDER BY "time" desc LIMIT 15

rtime=2024-01-15T17:36:13.473+08:00 level=ERROR msg="timeout: context canceled" logType=syslog service=warning



�2024/01/16 22:49:48 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.2.80/gormdb/gorm.go:159 timeout: context canceled

�[48.872ms] [rows:0] SELECT count() FROM "default"."warning" WHERE "status" in ('未确认') AND "recoveryTime" IS NULL AND "tableData" in ('PSZ_2')

�time=2024-01-16T22:49:48.172+08:00 level=ERROR msg="请求错误, rpc error: code = Canceled desc = context canceled" logType=syslog service=warning

�time=2024-01-16T22:49:48.172+08:00 level=ERROR msg="请求错误, rpc error: code = Canceled desc = context canceled" logType=syslog service=warning

rtime=2024-01-16T22:49:48.172+08:00 level=ERROR msg="timeout: context canceled" logType=syslog service=warning

�time=2024-01-17T16:24:49.784+08:00 level=ERROR msg="请求错误, rpc error: code = Canceled desc = context canceled" logType=syslog service=warning

�time=2024-01-17T16:24:49.784+08:00 level=ERROR msg="请求错误, rpc error: code = Canceled desc = context canceled" logType=syslog service=warning

7{"level":"warn","ts":"2024-01-17T16:57:45.187784+0800","logger":"etcd-client","caller":"v3@v3.5.11/retry_interceptor.go:62","msg":"retrying of unary invoker failed","target":"etcd-endpoints://0xc0007aa540/etcd:2379","attempt":0,"error":"rpc error: code = Unauthenticated desc = etcdserver: invalid auth token"}
HWARN msg=[resolver] Zero endpoint found,refused to write, instances: []


time=2024-01-17T16:57:46.585+08:00 level=ERROR msg="请求错误, rpc error: code = Unavailable desc = last connection error: connection error: desc = "transport: Error while dialing: dial tcp 172.18.0.23:9223: connect: connection refused"" logType=syslog service=warning


time=2024-01-17T16:57:46.612+08:00 level=ERROR msg="请求错误, rpc error: code = Unavailable desc = last connection error: connection error: desc = "transport: Error while dialing: dial tcp 172.18.0.23:9223: connect: connection refused"" logType=syslog service=warning


time=2024-01-17T16:57:46.743+08:00 level=ERROR msg="请求错误, rpc error: code = Unavailable desc = last connection error: connection error: desc = "transport: Error while dialing: dial tcp 172.18.0.23:9223: connect: connection refused"" logType=syslog service=warning


time=2024-01-17T16:57:46.781+08:00 level=ERROR msg="请求错误, rpc error: code = Unavailable desc = last connection error: connection error: desc = "transport: Error while dialing: dial tcp 172.18.0.23:9223: connect: connection refused"" logType=syslog service=warning


time=2024-01-17T16:57:46.784+08:00 level=ERROR msg="请求错误, rpc error: code = Unavailable desc = last connection error: connection error: desc = "transport: Error while dialing: dial tcp 172.18.0.23:9223: connect: connection refused"" logType=syslog service=warning


time=2024-01-17T16:57:46.786+08:00 level=ERROR msg="请求错误, rpc error: code = Unavailable desc = last connection error: connection error: desc = "transport: Error while dialing: dial tcp 172.18.0.23:9223: connect: connection refused"" logType=syslog service=warning


"time=2024-01-17T16:57:47.413+08:00 level=ERROR msg="更新国际化配置错误:查询授权错误:请求错误, rpc error: code = Unavailable desc = last connection error: connection error: desc = "transport: Error while dialing: dial tcp 172.18.0.23:9223: connect: connection refused""


time=2024-01-17T16:57:47.869+08:00 level=ERROR msg="请求错误, rpc error: code = Unavailable desc = last connection error: connection error: desc = "transport: Error while dialing: dial tcp 172.18.0.23:9223: connect: connection refused"" logType=syslog service=warning


time=2024-01-17T16:57:47.870+08:00 level=ERROR msg="请求错误, rpc error: code = Unavailable desc = last connection error: connection error: desc = "transport: Error while dialing: dial tcp 172.18.0.23:9223: connect: connection refused"" logType=syslog service=warning


time=2024-01-17T16:57:47.872+08:00 level=ERROR msg="请求错误, rpc error: code = Unavailable desc = last connection error: connection error: desc = "transport: Error while dialing: dial tcp 172.18.0.23:9223: connect: connection refused"" logType=syslog service=warning



�2024/01/17 17:36:46 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.2.80/gormdb/gorm.go:159 timeout: context canceled

�[104.357ms] [rows:0] SELECT count() FROM "default"."warning" WHERE "status" in ('未确认') AND "recoveryTime" IS NULL AND "tableData" in ('PSZ_3')

rtime=2024-01-17T17:36:46.723+08:00 level=ERROR msg="timeout: context canceled" logType=syslog service=warning



�2024/01/17 17:48:09 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.2.80/gormdb/gorm.go:159 timeout: context canceled

�[68.865ms] [rows:0] SELECT count() FROM "default"."warning" WHERE "status" in ('未确认') AND "recoveryTime" IS NULL AND "tableData" in ('PSZ_2')

rtime=2024-01-17T17:48:09.596+08:00 level=ERROR msg="timeout: context canceled" logType=syslog service=warning



�2024/01/17 17:48:09 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.2.80/gormdb/gorm.go:162 timeout: context canceled

�[33.203ms] [rows:0] SELECT "handle","fields","processed","id","status","tableData" FROM "default"."warning" WHERE "status" in ('未确认') AND "recoveryTime" IS NULL AND "tableData" in ('PSZ_3') ORDER BY "time" desc LIMIT 15

rtime=2024-01-17T17:48:09.596+08:00 level=ERROR msg="timeout: context canceled" logType=syslog service=warning



�2024/01/17 17:48:09 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.2.80/gormdb/gorm.go:162 timeout: context canceled

�[16.853ms] [rows:0] SELECT "id","status","tableData","processed","handle","fields" FROM "default"."warning" WHERE "status" in ('未确认') AND "recoveryTime" IS NULL AND "tableData" in ('PSZ_1') ORDER BY "time" desc LIMIT 15

rtime=2024-01-17T17:48:09.596+08:00 level=ERROR msg="timeout: context canceled" logType=syslog service=warning



{2024/01/17 18:40:17 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.2.80/gormdb/gorm.go:159 SLOW SQL >= 200ms

�[204.575ms] [rows:1] SELECT count() FROM "default"."warning" WHERE "status" in ('未确认') AND "recoveryTime" IS NULL AND "tableData" in ('PSZ_3')



�2024/01/18 00:05:34 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.2.80/gormdb/gorm.go:159 timeout: context canceled

�[32.742ms] [rows:0] SELECT count() FROM "default"."warning" WHERE "tableData" in ('PSZ_2') AND "status" in ('未确认') AND "recoveryTime" IS NULL



�2024/01/18 00:05:34 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.2.80/gormdb/gorm.go:159 failed to connect to host=postgres user=root database=postgres: failed SASL auth (read tcp 172.19.0.7:55644->172.19.0.5:5432: i/o timeout)

�[15.804ms] [rows:0] SELECT count() FROM "default"."warning" WHERE "status" in ('未确认') AND "recoveryTime" IS NULL AND "tableData" in ('PSZ_3')

rtime=2024-01-18T00:05:34.481+08:00 level=ERROR msg="timeout: context canceled" logType=syslog service=warning

�time=2024-01-18T00:05:34.481+08:00 level=ERROR msg="failed to connect to host=postgres user=root database=postgres: failed SASL auth (read tcp 172.19.0.7:55644->172.19.0.5:5432: i/o timeout)" logType=syslog service=warning

[yfyfzw]

请问这个问题是否已经修复？

[核桃酥]

这周会进行发版，问题已经修复测试了，发版后会反馈消息

[核桃酥]

更新最新版dashboard 和warning 模块