进退群通知会导致数据库报错

[HeiCreeper]

执行进退群通知后有概率出现该报错，清空redis数据库和删除yunzai数据以及重装yunzai无法解决该问题，禁用yunzai自带的进退群通知插件后不再出现该报错
错误日志如下
Error
at Database. (D:\Yunzai\node_modules.pnpm\sequelize@6.37.5_sqlite3@5.1.6_encoding@0.1.13_\node_modules\sequelize\lib\dialects\sqlite\query.js:185:27)
at D:\Yunzai\node_modules.pnpm\sequelize@6.37.5_sqlite3@5.1.6_encoding@0.1.13_\node_modules\sequelize\lib\dialects\sqlite\query.js:183:50
at new Promise ()
at Query.run (D:\Yunzai\node_modules.pnpm\sequelize@6.37.5_sqlite3@5.1.6_encoding@0.1.13_\node_modules\sequelize\lib\dialects\sqlite\query.js:183:12)
at D:\Yunzai\node_modules.pnpm\sequelize@6.37.5_sqlite3@5.1.6_encoding@0.1.13_\node_modules\sequelize\lib\sequelize.js:315:28
at async SQLiteQueryInterface.insert (D:\Yunzai\node_modules.pnpm\sequelize@6.37.5_sqlite3@5.1.6_encoding@0.1.13_\node_modules\sequelize\lib\dialects\abstract\query-interface.js:308:21)
at async UserDB.save (D:\Yunzai\node_modules.pnpm\sequelize@6.37.5_sqlite3@5.1.6_encoding@0.1.13_\node_modules\sequelize\lib\model.js:2490:35)
at async UserDB.saveDB (file:///D:/Yunzai/plugins/genshin/model/db/UserDB.js:94:5)
at async NoteUser.save (file:///D:/Yunzai/plugins/genshin/model/mys/NoteUser.js:144:5)
at async NoteUser.initDB (file:///D:/Yunzai/plugins/genshin/model/mys/NoteUser.js:128:5)
at async NoteUser.create (file:///D:/Yunzai/plugins/genshin/model/mys/NoteUser.js:102:5)
at async NoteUser.create (file:///D:/Yunzai/plugins/genshin/model/mys/NoteUser.js:96:18)
at async Runtime.initUser (file:///D:/Yunzai/lib/plugins/runtime.js:84:16)
at async Runtime.init (file:///D:/Yunzai/lib/plugins/runtime.js:241:5)
at async PluginsLoader.deal (file:///D:/Yunzai/lib/plugins/loader.js:195:5) {
name: 'SequelizeUniqueConstraintError',
errors: [
ValidationErrorItem {
message: 'id must be unique',
type: 'unique violation',
path: 'id',
value: '3983551740',
origin: 'DB',
instance: [UserDB],
validatorKey: 'not_unique',
validatorName: null,
validatorArgs: []
}
],
parent: [Error: SQLITE_CONSTRAINT: UNIQUE constraint failed: Users.id] {
errno: 19,
code: 'SQLITE_CONSTRAINT',
sql: 'INSERT INTO Users (id,type,ltuids,games,createdAt,updatedAt) VALUES ($1,$2,$3,$4,$5,$6);'
},
original: [Error: SQLITE_CONSTRAINT: UNIQUE constraint failed: Users.id] {
errno: 19,
code: 'SQLITE_CONSTRAINT',
sql: 'INSERT INTO Users (id,type,ltuids,games,createdAt,updatedAt) VALUES ($1,$2,$3,$4,$5,$6);'
},
fields: [ 'id' ],
sql: 'INSERT INTO Users (id,type,ltuids,games,createdAt,updatedAt) VALUES ($1,$2,$3,$4,$5,$6);'
}
(node:11664) [DEP0040] DeprecationWarning: The punycode module is deprecated. Please use a userland alternative instead.
(Use node --trace-deprecation ... to show where the warning was created)
Error
at Database. (D:\Yunzai\node_modules.pnpm\sequelize@6.37.5_sqlite3@5.1.6_encoding@0.1.13_\node_modules\sequelize\lib\dialects\sqlite\query.js:185:27)
at D:\Yunzai\node_modules.pnpm\sequelize@6.37.5_sqlite3@5.1.6_encoding@0.1.13_\node_modules\sequelize\lib\dialects\sqlite\query.js:183:50
at new Promise ()
at Query.run (D:\Yunzai\node_modules.pnpm\sequelize@6.37.5_sqlite3@5.1.6_encoding@0.1.13_\node_modules\sequelize\lib\dialects\sqlite\query.js:183:12)
at D:\Yunzai\node_modules.pnpm\sequelize@6.37.5_sqlite3@5.1.6_encoding@0.1.13_\node_modules\sequelize\lib\sequelize.js:315:28
at async SQLiteQueryInterface.insert (D:\Yunzai\node_modules.pnpm\sequelize@6.37.5_sqlite3@5.1.6_encoding@0.1.13_\node_modules\sequelize\lib\dialects\abstract\query-interface.js:308:21)
at async UserDB.save (D:\Yunzai\node_modules.pnpm\sequelize@6.37.5_sqlite3@5.1.6_encoding@0.1.13_\node_modules\sequelize\lib\model.js:2490:35)
at async UserDB.saveDB (file:///D:/Yunzai/plugins/genshin/model/db/UserDB.js:94:5)
at async NoteUser.save (file:///D:/Yunzai/plugins/genshin/model/mys/NoteUser.js:144:5)
at async NoteUser.initDB (file:///D:/Yunzai/plugins/genshin/model/mys/NoteUser.js:128:5)
at async NoteUser.create (file:///D:/Yunzai/plugins/genshin/model/mys/NoteUser.js:102:5)
at async NoteUser.create (file:///D:/Yunzai/plugins/genshin/model/mys/NoteUser.js:96:18)
at async Runtime.initUser (file:///D:/Yunzai/lib/plugins/runtime.js:84:16)
at async Runtime.init (file:///D:/Yunzai/lib/plugins/runtime.js:241:5)
at async PluginsLoader.deal (file:///D:/Yunzai/lib/plugins/loader.js:195:5) {
name: 'SequelizeUniqueConstraintError',
errors: [
ValidationErrorItem {
message: 'id must be unique',
type: 'unique violation',
path: 'id',
value: '3834313402',
origin: 'DB',
instance: [UserDB],
validatorKey: 'not_unique',
validatorName: null,
validatorArgs: []
}
],
parent: [Error: SQLITE_CONSTRAINT: UNIQUE constraint failed: Users.id] {
errno: 19,
code: 'SQLITE_CONSTRAINT',
sql: 'INSERT INTO Users (id,type,ltuids,games,createdAt,updatedAt) VALUES ($1,$2,$3,$4,$5,$6);'
},
original: [Error: SQLITE_CONSTRAINT: UNIQUE constraint failed: Users.id] {
errno: 19,
code: 'SQLITE_CONSTRAINT',
sql: 'INSERT INTO Users (id,type,ltuids,games,createdAt,updatedAt) VALUES ($1,$2,$3,$4,$5,$6);'
},
fields: [ 'id' ],
sql: 'INSERT INTO Users (id,type,ltuids,games,createdAt,updatedAt) VALUES ($1,$2,$3,$4,$5,$6);'
}
(node:6728) [DEP0040] DeprecationWarning: The punycode module is deprecated. Please use a userland alternative instead.
(Use node --trace-deprecation ... to show where the warning was created)
Error
at OneBotv11Adapter.sendApi (file:///D:/Yunzai/plugins/adapter/OneBotv11.js:21:19)
at OneBotv11Adapter.getMemberInfo (file:///D:/Yunzai/plugins/adapter/OneBotv11.js:328:34)
at OneBotv11Adapter.makeNotice (file:///D:/Yunzai/plugins/adapter/OneBotv11.js:922:58)
at OneBotv11Adapter.message (file:///D:/Yunzai/plugins/adapter/OneBotv11.js:1078:16)
at WebSocket. (file:///D:/Yunzai/plugins/adapter/OneBotv11.js:1113:39)
at WebSocket.emit (node:events:536:35)
at Receiver.receiverOnMessage (D:\Yunzai\node_modules.pnpm\ws@8.18.0\node_modules\ws\lib\websocket.js:1220:20)
at Receiver.emit (node:events:524:28)
at Receiver.dataMessage (D:\Yunzai\node_modules.pnpm\ws@8.18.0\node_modules\ws\lib\receiver.js:596:14)
at Receiver.getData (D:\Yunzai\node_modules.pnpm\ws@8.18.0\node_modules\ws\lib\receiver.js:496:10)
at Receiver.startLoop (D:\Yunzai\node_modules.pnpm\ws@8.18.0\node_modules\ws\lib\receiver.js:167:16)
at Receiver._write (D:\Yunzai\node_modules.pnpm\ws@8.18.0\node_modules\ws\lib\receiver.js:94:10)
at writeOrBuffer (node:internal/streams/writable:572:12)
at _write (node:internal/streams/writable:501:10)
at Writable.write (node:internal/streams/writable:510:10)
at Socket.socketOnData (D:\Yunzai\node_modules.pnpm\ws@8.18.0\node_modules\ws\lib\websocket.js:1355:35) {
action: 'get_group_member_info',
params: { group_id: 463040652, user_id: 0 },
echo: '01JM2BHEK404QH4538X21S4J8Q',
error: {
status: 'failed',
retcode: 1200,
data: null,
message: 'Uin2Uid Error: 用户ID 0 不存在',
wording: 'Uin2Uid Error: 用户ID 0 不存在',
echo: '01JM2BHEK404QH4538X21S4J8Q',
raw: '{"status":"failed","retcode":1200,"data":null,"message":"Uin2Uid Error: 用户ID 0 不存在","wording":"Uin2Uid Error: 用户ID 0 不存在","echo":"01JM2BHEK404QH4538X21S4J8Q"}'
}
}