驱动启动不起来

[laoxie]

驱动一直启动不了，停止然后重新启动了几次，都是显示等待重试，一直不能启动运行，请问好怎么才能启动起来？

[laoxie]

日志报这个错误：

2024/11/03 21:21:05 INFO 启动服务: 版本=v4.2.34
panic: 初始化消息队列错误: not Authorized

goroutine 1 [running]:
github.com/air-iot/sdk-go/v4/driver.NewApp()
/go/pkg/mod/github.com/air-iot/sdk-go/v4@v4.7.11/driver/app.go:136 +0x40e
main.main()
/builds/core/drivers/modbus-driver/cmd/modbus/main.go:15 +0x5f
{"time":"2024-11-03T21:21:05.180516+08:00","level":"INFO","msg":"启动配置={ServiceID:669493618a85cc2c6c09534d GroupID: Project:default Driver:{ID:modbus Name:Modbus-TCP} DriverGrpc:{Host:127.0.0.1 Port:9224 Health:{RequestTime:10s Retry:3} Stream:{Heartbeat:10s} WaitTime:5s Timeout:10m0s Limit:100} Log:{Level:4 Format:json Output:stdout OutputFile: MaxAge:0 RotationTime:0 RotationSize:0 RotationCount:0 Syslog:{ServiceName:default-669493618a85cc2c6c09534d-modbus ProjectId:default}} MQ:{Type:mqtt Timeout:1m0s MQTT:{Host:127.0.0.1 Port:1883 Username:admin Password:public KeepAlive:60 ConnectTimeout:20 ProtocolVersion:4} Rabbit:{Host:rabbit Port:5672 Username:admin Password:public VHost: Exchange: Queue:} Kafka:{Brokers:[kafka:9092] Version: GroupID: ClientID: MaxOpenRequests:0 Balancer: Partition:<nil> AutoCommit:<nil>}} Pprof:{Enable:false Host: Port:9002} EtcdConfig: Etcd:{Endpoints:[] DialTimeout:0 Username: Password: AutoSyncInterval:0s}}"}

[Yoki]

服务器内存够的吗，可以看看core的日志

[laoxie]

core日志：
{"time":"2024-11-04T14:33:35.7173747+08:00","level":"INFO","msg":"周期性更新授权缓存完成"}
{"time":"2024-11-04T14:33:36.2888943+08:00","level":"INFO","msg":"更新机器码缓存完成"}

2024/11/04 14:33:40 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:99 SLOW SQL >= 200ms
[288.771ms] [rows:1] SELECT count(*) FROM "default"."table" WHERE "id" = '制酒7车间'
{"time":"2024-11-04T14:34:05.717161+08:00","level":"INFO","msg":"周期性更新授权缓存完成"}
{"time":"2024-11-04T14:34:06.3127432+08:00","level":"INFO","msg":"更新机器码缓存完成"}
{"time":"2024-11-04T14:34:14.2339874+08:00","level":"INFO","msg":"查询项目[default]UsedLicense"}

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:99 SLOW SQL >= 200ms
[214.570ms] [rows:1] SELECT count(*) FROM "default"."table" WHERE "id" = '制酒5车间'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:99 SLOW SQL >= 200ms
[206.549ms] [rows:1] SELECT count(*) FROM "default"."table" WHERE "id" = '蒸汽数据不一致班组'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:99 SLOW SQL >= 200ms
[204.544ms] [rows:1] SELECT count(*) FROM "default"."table" WHERE "id" = '制酒4车间'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:99 SLOW SQL >= 200ms
[219.583ms] [rows:1] SELECT count(*) FROM "default"."table" WHERE "id" = '制酒6车间'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:180 SLOW SQL >= 200ms
[203.542ms] [rows:1] SELECT "showField","dataSource","permissions","id","title","schema","permission","function" FROM "default"."table" WHERE "id" = '制酒8车间'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:99 SLOW SQL >= 200ms
[411.093ms] [rows:1] SELECT count(*) FROM "default"."table" WHERE "id" = '制酒14车间'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:99 SLOW SQL >= 200ms
[435.156ms] [rows:1] SELECT count(*) FROM "default"."table" WHERE "id" = '制酒15车间'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:99 SLOW SQL >= 200ms
[254.677ms] [rows:1] SELECT count(*) FROM "default"."table" WHERE "id" = '制酒15车间'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[203.541ms] [rows:1] SELECT * FROM "default"."user" WHERE id='admin'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:99 SLOW SQL >= 200ms
[235.626ms] [rows:1] SELECT count(*) FROM "default"."制酒15车间" WHERE "id" = '制酒15_105'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[228.608ms] [rows:1] SELECT * FROM "default"."制酒15车间" WHERE id='制酒15_110'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[207.552ms] [rows:1] SELECT * FROM "default"."制酒5车间" WHERE id='制酒5_42'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:99 SLOW SQL >= 200ms
[456.212ms] [rows:1] SELECT count(*) FROM "default"."table" WHERE "id" = '制酒9车间'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:99 SLOW SQL >= 200ms
[450.196ms] [rows:1] SELECT count(*) FROM "default"."table" WHERE "id" = '制酒5车间'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:99 SLOW SQL >= 200ms
[253.675ms] [rows:1] SELECT count(*) FROM "default"."制酒8车间" WHERE "id" = '制酒8_90'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:99 SLOW SQL >= 200ms
[279.744ms] [rows:1] SELECT count(*) FROM "default"."制酒9车间" WHERE "id" = '制酒9_79'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:99 SLOW SQL >= 200ms
[205.547ms] [rows:1] SELECT count(*) FROM "default"."制酒10车间" WHERE "id" = '制酒10_97'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:180 SLOW SQL >= 200ms
[249.665ms] [rows:1] SELECT "dataSource","permissions","id","title","schema","permission","function","showField" FROM "default"."table" WHERE "id" = '制酒15车间'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:99 SLOW SQL >= 200ms
[456.212ms] [rows:1] SELECT count(*) FROM "default"."table" WHERE "id" = '制酒7车间'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[248.661ms] [rows:1] SELECT * FROM "default"."user" WHERE id='defaultApp'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[203.541ms] [rows:1] SELECT * FROM "default"."user" WHERE id='defaultApp'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:180 SLOW SQL >= 200ms
[259.691ms] [rows:1] SELECT "schema","permission","function","showField","dataSource","permissions","id","title" FROM "default"."table" WHERE "id" = '制酒15车间'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:99 SLOW SQL >= 200ms
[228.608ms] [rows:1] SELECT count(*) FROM "default"."制酒8车间" WHERE "id" = '制酒8_88'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[209.557ms] [rows:1] SELECT * FROM "default"."user" WHERE id='admin'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:180 SLOW SQL >= 200ms
[214.569ms] [rows:1] SELECT "tableData","formschema","device","computed","warning","table_params","id" FROM "default"."table_record" WHERE "tableData" = '制酒8_84' AND "tableInfo" = '制酒8车间'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[217.579ms] [rows:1] SELECT * FROM "default"."蒸汽数据不一致班组" WHERE id='制酒9_74'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:99 SLOW SQL >= 200ms
[254.678ms] [rows:1] SELECT count(*) FROM "default"."制酒6车间" WHERE "id" = '制酒6_52'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:180 SLOW SQL >= 200ms
[307.819ms] [rows:1] SELECT "schema","permission","function","showField","dataSource","permissions","id","title" FROM "default"."table" WHERE "id" = '制酒16车间'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:99 SLOW SQL >= 200ms
[224.596ms] [rows:1] SELECT count(*) FROM "default"."制酒14车间" WHERE "id" = '制酒14_3'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[257.685ms] [rows:1] SELECT * FROM "default"."user" WHERE id='admin'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:180 SLOW SQL >= 200ms
[320.853ms] [rows:1] SELECT "permission","function","showField","dataSource","permissions","id","title","schema" FROM "default"."table" WHERE "id" = '制酒8车间'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[264.704ms] [rows:1] SELECT * FROM "default"."user" WHERE id='defaultApp'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[219.583ms] [rows:1] SELECT * FROM "default"."user" WHERE id='admin'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[270.720ms] [rows:1] SELECT * FROM "default"."制酒5车间" WHERE id='制酒5_44'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[240.640ms] [rows:1] SELECT * FROM "default"."user" WHERE id='defaultApp'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[219.584ms] [rows:1] SELECT * FROM "default"."制酒5车间" WHERE id='制酒5_60'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:180 SLOW SQL >= 200ms
[327.872ms] [rows:1] SELECT "showField","dataSource","permissions","id","title","schema","permission","function" FROM "default"."table" WHERE "id" = '制酒6车间'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[211.562ms] [rows:1] SELECT * FROM "default"."user" WHERE id='defaultApp'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:99 SLOW SQL >= 200ms
[242.645ms] [rows:1] SELECT count(*) FROM "default"."制酒7车间" WHERE "id" = '制酒7_49'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:99 SLOW SQL >= 200ms
[235.626ms] [rows:1] SELECT count(*) FROM "default"."制酒4车间" WHERE "id" = '制酒4_38'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[243.648ms] [rows:1] SELECT * FROM "default"."user" WHERE id='defaultApp'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[222.592ms] [rows:1] SELECT * FROM "default"."制酒5车间" WHERE id='制酒5_45'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[250.666ms] [rows:1] SELECT * FROM "default"."user" WHERE id='defaultApp'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:99 SLOW SQL >= 200ms
[233.621ms] [rows:1] SELECT count(*) FROM "default"."制酒16车间" WHERE "id" = '制酒16_116'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[270.721ms] [rows:1] SELECT * FROM "default"."制酒10车间" WHERE id='制酒10_100'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[267.712ms] [rows:1] SELECT * FROM "default"."制酒4车间" WHERE id='制酒4_33'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:99 SLOW SQL >= 200ms
[259.690ms] [rows:1] SELECT count(*) FROM "default"."制酒10车间" WHERE "id" = '制酒10_96'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[323.861ms] [rows:1] SELECT * FROM "default"."user" WHERE id='defaultApp'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[353.941ms] [rows:1] SELECT * FROM "default"."user" WHERE id='defaultApp'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[283.755ms] [rows:1] SELECT * FROM "default"."user" WHERE id='defaultApp'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:99 SLOW SQL >= 200ms
[289.771ms] [rows:1] SELECT count(*) FROM "default"."制酒14车间" WHERE "id" = '制酒14_4'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:99 SLOW SQL >= 200ms
[336.897ms] [rows:1] SELECT count(*) FROM "default"."制酒10车间" WHERE "id" = '制酒10_98'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:180 SLOW SQL >= 200ms
[284.757ms] [rows:1] SELECT "title","schema","id" FROM "default"."table" WHERE "id" = '制酒10车间'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[312.832ms] [rows:1] SELECT * FROM "default"."制酒7车间" WHERE id='制酒7_48'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:180 SLOW SQL >= 200ms
[305.813ms] [rows:1] SELECT "tableData","formschema","device","computed","warning","table_params","id" FROM "default"."table_record" WHERE "tableData" = '制酒8_92' AND "tableInfo" = '制酒8车间'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:99 SLOW SQL >= 200ms
[352.939ms] [rows:1] SELECT count(*) FROM "default"."制酒6车间" WHERE "id" = '制酒6_57'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:180 SLOW SQL >= 200ms
[318.848ms] [rows:1] SELECT * FROM "default"."table" WHERE "id" = '茅台和义兴'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:180 SLOW SQL >= 200ms
[353.942ms] [rows:1] SELECT "id","title","schema","permission","function","showField","dataSource","permissions" FROM "default"."table" WHERE "id" = '制酒15车间'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:180 SLOW SQL >= 200ms
[282.751ms] [rows:1] SELECT "schema","id","title" FROM "default"."table" WHERE "function" like '%dataAuth%'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:180 SLOW SQL >= 200ms
[287.765ms] [rows:1] SELECT "id","title","schema" FROM "default"."table" WHERE "id" = '制酒10车间'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:180 SLOW SQL >= 200ms
[200.533ms] [rows:1] SELECT * FROM "default"."table" WHERE "id" = '茅台和义兴'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[367.978ms] [rows:1] SELECT * FROM "default"."user" WHERE id='defaultApp'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:180 SLOW SQL >= 200ms
[378.005ms] [rows:1] SELECT "permission","function","showField","dataSource","permissions","id","title","schema" FROM "default"."table" WHERE "id" = '制酒10车间'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[332.885ms] [rows:1] SELECT * FROM "default"."user" WHERE id='defaultApp'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:99 SLOW SQL >= 200ms
[393.044ms] [rows:1] SELECT count(*) FROM "default"."table" WHERE "id" = '制酒9车间'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:99 SLOW SQL >= 200ms
[398.057ms] [rows:1] SELECT count(*) FROM "default"."table" WHERE "id" = '制酒9车间'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[353.941ms] [rows:1] SELECT * FROM "default"."user" WHERE id='defaultApp'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:180 SLOW SQL >= 200ms
[317.846ms] [rows:1] SELECT * FROM "default"."table" WHERE "id" = '茅台和义兴'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:99 SLOW SQL >= 200ms
[362.965ms] [rows:1] SELECT count(*) FROM "default"."制酒9车间" WHERE "id" = '制酒9_71'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[394.048ms] [rows:1] SELECT * FROM "default"."user" WHERE id='defaultApp'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:99 SLOW SQL >= 200ms
[600.596ms] [rows:1] SELECT count(*) FROM "default"."table" WHERE "id" = '制酒15车间'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:180 SLOW SQL >= 200ms
[337.898ms] [rows:1] SELECT * FROM "default"."table" WHERE "id" = '茅台和义兴'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:99 SLOW SQL >= 200ms
[426.133ms] [rows:1] SELECT count(*) FROM "default"."table" WHERE "id" = '制酒6车间'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[366.976ms] [rows:1] SELECT * FROM "default"."制酒6车间" WHERE id='制酒6_58'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[399.061ms] [rows:1] SELECT * FROM "default"."制酒16车间" WHERE id='制酒16_121'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:180 SLOW SQL >= 200ms
[237.632ms] [rows:1] SELECT "schema","id","title" FROM "default"."table" WHERE "function" like '%dataAuth%'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:180 SLOW SQL >= 200ms
[393.045ms] [rows:1] SELECT * FROM "default"."table" WHERE "id" = '茅台和义兴'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:99 SLOW SQL >= 200ms
[464.234ms] [rows:1] SELECT count(*) FROM "default"."table" WHERE "id" = '制酒6车间'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[417.110ms] [rows:1] SELECT * FROM "default"."user" WHERE id='admin'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:99 SLOW SQL >= 200ms
[652.734ms] [rows:1] SELECT count(*) FROM "default"."table" WHERE "id" = '制酒7车间'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:180 SLOW SQL >= 200ms
[385.024ms] [rows:1] SELECT "title","schema","permission","function","showField","dataSource","permissions","id" FROM "default"."table" WHERE "id" = '制酒14车间'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[206.549ms] [rows:1] SELECT * FROM "default"."制酒9车间" WHERE id='制酒9_79'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:99 SLOW SQL >= 200ms
[279.744ms] [rows:1] SELECT count(*) FROM "default"."制酒14车间" WHERE "id" = '制酒14_3'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:180 SLOW SQL >= 200ms
[413.099ms] [rows:1] SELECT "warning","table_params","id","tableData","formschema","device","computed" FROM "default"."table_record" WHERE "tableData" = '制酒15_112' AND "tableInfo" = '制酒15车间'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:99 SLOW SQL >= 200ms
[270.720ms] [rows:1] SELECT count(*) FROM "default"."制酒7车间" WHERE "id" = '制酒7_50'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[211.562ms] [rows:1] SELECT * FROM "default"."user" WHERE id='defaultApp'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:180 SLOW SQL >= 200ms
[323.861ms] [rows:1] SELECT * FROM "default"."茅台和义兴" WHERE "id" in ('茅台和义兴','制酒16车间')

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[282.752ms] [rows:1] SELECT * FROM "default"."user" WHERE id='admin'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:180 SLOW SQL >= 200ms
[425.130ms] [rows:1] SELECT "computed","warning","table_params","id","tableData","formschema","device" FROM "default"."table_record" WHERE "tableData" = '制酒8_93' AND "tableInfo" = '制酒8车间'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:180 SLOW SQL >= 200ms
[261.695ms] [rows:1] SELECT * FROM "default"."table" WHERE "id" = '茅台和义兴'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:180 SLOW SQL >= 200ms
[201.536ms] [rows:1] SELECT "title","schema","id" FROM "default"."table" WHERE "id" = '蒸汽数据不一致班组'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:99 SLOW SQL >= 200ms
[669.780ms] [rows:1] SELECT count(*) FROM "default"."table" WHERE "id" = '制酒14车间'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[240.640ms] [rows:1] SELECT * FROM "default"."制酒14车间" WHERE id='制酒14_2'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:180 SLOW SQL >= 200ms
[408.085ms] [rows:1] SELECT * FROM "default"."table" WHERE "id" = '茅台和义兴'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[433.152ms] [rows:1] SELECT * FROM "default"."user" WHERE id='admin'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[459.222ms] [rows:1] SELECT * FROM "default"."制酒8车间" WHERE id='制酒8_89'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[219.584ms] [rows:1] SELECT * FROM "default"."制酒6车间" WHERE id='制酒6_55'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:180 SLOW SQL >= 200ms
[202.539ms] [rows:1] SELECT "id","tableData","formschema","device","computed","warning","table_params" FROM "default"."table_record" WHERE "tableData" = '制酒6_54' AND "tableInfo" = '制酒6车间'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:99 SLOW SQL >= 200ms
[250.666ms] [rows:1] SELECT count(*) FROM "default"."table" WHERE "id" = '制酒15车间'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[210.560ms] [rows:1] SELECT * FROM "default"."制酒4车间" WHERE id='制酒4_38'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:99 SLOW SQL >= 200ms
[241.643ms] [rows:1] SELECT count(*) FROM "default"."制酒8车间" WHERE "id" = '制酒8_90'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[239.637ms] [rows:1] SELECT * FROM "default"."user" WHERE id='admin'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[220.587ms] [rows:1] SELECT * FROM "default"."user" WHERE id='defaultApp'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[432.149ms] [rows:1] SELECT * FROM "default"."user" WHERE id='admin'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:180 SLOW SQL >= 200ms
[230.613ms] [rows:1] SELECT "schema","id","title" FROM "default"."table" WHERE "function" like '%dataAuth%'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:180 SLOW SQL >= 200ms
[242.645ms] [rows:1] SELECT * FROM "default"."茅台和义兴" WHERE "id" in ('制酒8车间')

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:99 SLOW SQL >= 200ms
[742.975ms] [rows:1] SELECT count(*) FROM "default"."table" WHERE "id" = '制酒9车间'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:99 SLOW SQL >= 200ms
[745.983ms] [rows:1] SELECT count(*) FROM "default"."table" WHERE "id" = '制酒9车间'
{"time":"2024-11-04T14:34:35.7171634+08:00","level":"INFO","msg":"周期性更新授权缓存完成"}
{"time":"2024-11-04T14:34:36.2064415+08:00","level":"INFO","msg":"更新机器码缓存完成"}

[admin]

@laoxie
1.浏览器输入ip:58080打开etcdkeeper
连接etcd，
用户名root
密码dell123
2.打开airiot/config/pro.json
查看mqtt的密码

复制ENC括号中的字符，使用base64解码获取mqtt的密码
然后使用mqttX或者mqttbox连接mqtt
端口默认1883，可以在运维查看mqtt的端口，用户名admin，密码就是解码之后的明文，看看能否连上
①如果可以连上，表示mqtt密码初始化没问题，这时找一个重启中的驱动，看一下驱动的日志，加载配置那一块儿的日志，找到mqtt的密码配置，查看是否和etcd配置中的相同
②如果连不上，表示mqtt密码初始化错误，需要重新初始化密码

[laoxie]

此回复已被删除！

[laoxie]

此回复已被删除！

[laoxie]

[laoxie]

密码不一致。怎么办呢？

[admin]

先看看core服务的日志有没有类似的mqtt连接失败的提示，没有的话说明mqtt密码初始化是对的，驱动的配置不读对，需要发一下驱动的配置截图
@laoxie