Koishi在用户首次发送消息时出现数据库INSERT DUPLICATE ENTRY错误

[TimeBather]

不管是使用QQ频道Adapter还是Sandbox模拟都会有这个问题

复现方式

• yarn create koishi 创建koishi项目，开启git集成
• 安装 guild-adapter等插件，配置频道
• 用频道账号首次发送信息
• 问题出现

Environment

koishi start
[I] app Koishi/4.5.2
[I] app apply plugin console
[I] app apply plugin logger
[I] app apply plugin manager
[I] app apply plugin status
[I] app apply plugin database-mysql
[I] app apply plugin dataview
[I] app apply plugin chat
[I] app apply plugin adapter-onebot
[I] app apply plugin adapter-qqguild
[I] app apply plugin echo
[I] app apply plugin sandbox

"@koishijs/plugin-adapter-discord": "^2.0.8",
    "@koishijs/plugin-adapter-onebot": "^4.1.6",
    "@koishijs/plugin-adapter-qqguild": "1.1.2",
    "@koishijs/plugin-adapter-telegram": "^2.2.2",
    "@koishijs/plugin-auth": "1.1.2",
    "@koishijs/plugin-chat": "1.2.3",
    "@koishijs/plugin-console": "^3.2.5",
    "@koishijs/plugin-database-mysql": "4.2.0",
    "@koishijs/plugin-dataview": "^1.2.2",
    "@koishijs/plugin-echo": "1.1.0",
    "@koishijs/plugin-eval": "4.0.4",
    "@koishijs/plugin-logger": "^1.2.2",
    "@koishijs/plugin-manager": "^1.7.0",
    "@koishijs/plugin-sandbox": "1.1.0",
    "@koishijs/plugin-status": "^5.3.5",
    "koishi": "^4.5.2"

Log:

[W] mysql INSERT INTO `channel` (`flag`,`assignee`,`guildId`,`locale`,`name`,`activity`,`platform`,`id`) VALUES (0, '109*****', '210*******', '', '', '{}', 'qqguild', '541****')
[W] app ER_DUP_ENTRY: Duplicate entry '5413659-qqguild' for key 'PRIMARY'
        at MysqlDatabase.query (/www/wwwroot/two-dimension-bot/node_modules/@koishijs/plugin-database-mysql/lib/index.js:264:19)
        at MysqlDatabase.create (/www/wwwroot/two-dimension-bot/node_modules/@koishijs/plugin-database-mysql/lib/index.js:396:31)
        at processTicksAndRejections (internal/process/task_queues.js:95:5)
[W] mysql INSERT INTO `channel` (`flag`,`assignee`,`guildId`,`locale`,`name`,`activity`,`platform`,`id`) VALUES (0, '1094*****', '2101642******', '', '', '{}', 'qqguild', '21016*******')

[W] mysql INSERT INTO `channel` (`flag`,`assignee`,`guildId`,`locale`,`name`,`activity`,`platform`,`id`) VALUES (0, 'sandbox', '#', '', '', '{}', 'sandbox', '#')
[W] session /test
    ER_DUP_ENTRY: Duplicate entry '#-sandbox' for key 'PRIMARY'
        at MysqlDatabase.query (/www/wwwroot/two-dimension-bot/node_modules/@koishijs/plugin-database-mysql/lib/index.js:264:19)
        at MysqlDatabase.create (/www/wwwroot/two-dimension-bot/node_modules/@koishijs/plugin-database-mysql/lib/index.js:396:31)
        at processTicksAndRejections (internal/process/task_queues.js:95:5)
    Middleware stack:

[TimeBather]

这个似乎在多个平台上都有复现，可能和Koishi的用户系统实现有关?

[TimeBather]

证实这个bug是由于ObserveChannel函数被调用两次产生的,第一次是由App的Process函数调用,第二次是由chat插件调用,chat插件调用位置如下:
https://github.com/koishijs/koishi/blob/master/plugins/frontend/chat/src/index.ts#L71