Bug: onebot在同一群聊中非第一个使用但首次使用bot的用户创建mysql数据库失败

[KelaLeaf]

Describe the bug

没有与QQ机器人私聊过的用户在群聊中使用机器人无反应。

Steps to reproduce

1.使用adapter-onebot插件
2.未和bot私聊且也没有在群聊与bot交互过的用户
3.首次在群聊未at机器人直接使用指令，或首次at机器人聊天

Expected behavior

与用户正常交互

Screenshots

2025-05-14 14:51:05 [D] onebot [receive] { self_id: 161461357, user_id: 2961325048, time: 1747234264, message_id: 1884711052, message_seq: 174095, message_type: 'group', sender: { user_id: 2961325048, nickname: '不昧己心', card: '', role: 'member', title: '' }, raw_message: '/jrys', font: 14, sub_type: 'normal', message: [ { type: 'text', data: { text: '/jrys' } } ], message_format: 'array', post_type: 'message', group_id: 853402770 }
2025-05-14 14:51:05 [D] onebot [request] get_group_list { no_cache: undefined }
2025-05-14 14:51:05 [D] mysql > SELECT `flag`, `assignee`, `guildId`, `permissions`, `locales` FROM `channel` ljheswwd WHERE `platform` = 'onebot' AND `id` = '853402770'
2025-05-14 14:51:05 [D] mysql > SELECT `aid` FROM `binding` huwxrnsb WHERE `platform` = 'onebot' AND `pid` = '2961325048'
2025-05-14 14:51:05 [D] onebot [response] { status: 'ok', retcode: 0, data: [ { group_id: 1028779507, group_name: '樱色梦境Downloads', group_memo: '', group_create_time: 1578819850, member_count: 4, max_member_count: 200, remark_name: '' }, { group_id: 1130315677, group_name: '老八整活群 总群', group_memo: '', group_create_time: 1595858154, member_count: 55, max_member_count: 500, remark_name: '' }, { group_id: 199655755, group_name: 'wiyi修改群（1群）', group_memo: '', group_create_time: 1586029741, member_count: 1753, max_member_count: 200, remark_name: '' }, { group_id: 202457754, group_name: '游戏百草园', group_memo: '', group_create_time: 1579101087, member_count: 83, max_member_count: 500, remark_name: '' }, { group_id: 553857961, group_name: '机器人专用群.', group_memo: '', group_create_time: 1596276855, member_count: 33, max_member_count: 200, remark_name: '' }, { group_id: 611599486, group_name: '皇宫', group_memo: '', group_create_time: 1596950034, member_count: 25, max_member_count: 200, remark_name: '' }, { group_id: 656488911, group_name: '<$ǿĀD\x0E><$ÿĀ\x11\x10>一群冤种～～', group_memo: '', group_create_time: 1628643095, member_count: 18, max_member_count: 200, remark_name: '' }, { group_id: 746864964, group_name: '夢時🍁开发测试', group_memo: '', group_create_time: 1701172957, member_count: 6, max_member_count: 200, remark_name: '' }, { group_id: 778663382, group_name: '拦哑闻式体制化群聊', group_memo: '', group_create_time: 1562984879, member_count: 9, max_member_count: 200, remark_name: '' }, { group_id: 808618262, group_name: '半世倾城 ‖提前预热', group_memo: '', group_create_time: 1551106603, member_count: 36, max_member_count: 200, remark_name: '' }, { group_id: 853402770, group_name: '樱色梦境<$ǿĀD\x0E>​', group_memo: '', group_create_time: 1533175742, member_count: 126, max_member_count: 500, remark_name: '' }, { group_id: 854441706, group_name: '没妈阿伟一大堆', group_memo: '', group_create_time: 1553314783, member_count: 45, max_member_count: 500, remark_name: '' }, { group_id: 863515196, group_name: '马云vi p聚集群', group_memo: '', group_create_time: 1655125844, member_count: 19, max_member_count: 200, remark_name: '' }, { group_id: 876133405, group_name: '国服大军', group_memo: '', group_create_time: 1627281879, member_count: 8, max_member_count: 200, remark_name: '' } ], message: '', wording: '', echo: 6 }
2025-05-14 14:51:05 [D] mysql > UPDATE `message_counter_records` etdqtjer SET `channelName` = '樱色梦境<$ǿĀD�>​' WHERE `channelId` = '853402770'
2025-05-14 14:51:05 [D] mysql > INSERT INTO `user` (`flag`, `authority`, `locales`, `permissions`, `usage`, `timers`, `password`, `createdAt`) VALUES (0, 1, '', '', json_extract('{}', '$'), json_extract('{}', '$'), '', '2025-05-14 14:51:05.097')
2025-05-14 14:51:05 [D] mysql > SELECT `aid` FROM `binding` rlegwact WHERE `platform` = 'onebot' AND `pid` = '2961325048'
2025-05-14 14:51:05 [D] mysql > SELECT `id`, `channelId`, `channelName`, `userId`, `username`, `userAvatar`, `todayPostCount`, `thisWeekPostCount`, `thisMonthPostCount`, `thisYearPostCount`, `totalPostCount`, `yesterdayPostCount` FROM `message_counter_records` ykkotztk WHERE `channelId` = '853402770' AND `userId` = '2961325048'
2025-05-14 14:51:05 [D] mysql > INSERT INTO `message_counter_records` (`channelId`, `channelName`, `userId`, `username`, `userAvatar`, `todayPostCount`, `thisWeekPostCount`, `thisMonthPostCount`, `thisYearPostCount`, `totalPostCount`, `yesterdayPostCount`) VALUES ('853402770', '樱色梦境<$ǿĀD�>​', '2961325048', '不昧己心', 'http://q.qlogo.cn/headimg_dl?dst_uin=2961325048&spec=640', 1, 1, 1, 1, 1, 0)
2025-05-14 14:51:05 [D] mysql > INSERT INTO `binding` (`aid`, `bid`, `pid`, `platform`) VALUES (201, 201, '2961325048', 'onebot')
2025-05-14 14:51:05 [D] mysql > INSERT INTO `user` (`flag`, `authority`, `locales`, `permissions`, `usage`, `timers`, `password`, `createdAt`) VALUES (0, 1, '', '', json_extract('{}', '$'), json_extract('{}', '$'), '', '2025-05-14 14:51:05.122')
2025-05-14 14:51:05 [D] mysql > INSERT INTO `binding` (`aid`, `bid`, `pid`, `platform`) VALUES (202, 202, '2961325048', 'onebot')
2025-05-14 14:51:05 [W] mysql > INSERT INTO `binding` (`aid`, `bid`, `pid`, `platform`) VALUES (202, 202, '2961325048', 'onebot')
2025-05-14 14:51:05 [W] session /jrys
                        ER_DUP_ENTRY: Duplicate entry '2961325048-onebot' for key 'PRIMARY'
                            at MySQLDriver.query (/koishi/node_modules/@minatojs/driver-mysql/lib/index.cjs:484:19)
                            at MySQLDriver.create (/koishi/node_modules/@minatojs/driver-mysql/lib/index.cjs:598:31)
                            at Executable.execute (/koishi/node_modules/minato/lib/index.cjs:807:34)
                            at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
                            at async Proxy.createUser (/koishi/node_modules/@koishijs/core/lib/index.cjs:584:5)
                            at async Proxy.observeUser (/koishi/node_modules/@koishijs/core/lib/index.cjs:1958:18)
                            at async Processor.attach (/koishi/node_modules/@koishijs/core/lib/index.cjs:805:20)
                            at async next (/koishi/node_modules/@koishijs/core/lib/index.cjs:829:16)
                            at async next (/koishi/node_modules/@koishijs/core/lib/index.cjs:829:16)
                            at async next (/koishi/node_modules/@koishijs/core/lib/index.cjs:829:16)
2025-05-15 00:39:24 [D] onebot [receive] { self_id: 161461357, user_id: 2760260989, time: 1747269564, message_id: 594368385, message_seq: 174101, message_type: 'group', sender: { user_id: 2760260989, nickname: '仲夏二十', card: '两万只夜雨爱跳舞', role: 'admin', title: '鸽子🐦' }, raw_message: '[CQ:at,qq=161461357,name=凌梦] 复活吧老叶的爱人', font: 14, sub_type: 'normal', message: [ { type: 'at', data: { qq: '161461357', name: '凌梦' } }, { type: 'text', data: { text: ' 复活吧老叶的爱人' } } ], message_format: 'array', post_type: 'message', group_id: 853402770 }
2025-05-15 00:39:24 [D] onebot [request] get_group_list { no_cache: undefined }
2025-05-15 00:39:24 [D] mysql > SELECT `flag`, `assignee`, `guildId`, `permissions`, `locales` FROM `channel` xyxjdmkk WHERE `platform` = 'onebot' AND `id` = '853402770'
2025-05-15 00:39:24 [D] mysql > INSERT INTO `analytics.message` (`date`, `hour`, `type`, `selfId`, `platform`, `count`) VALUES (20222, 15, 'receive', '161461357', 'onebot', 1), (20222, 15, 'send', '161461357', 'onebot', 1), (20223, 0, 'receive', '161461357', 'onebot', 1) ON DUPLICATE KEY UPDATE `count` = (ifnull(`count`, 0) + 1)
2025-05-15 00:39:24 [D] mysql > INSERT INTO `analytics.command` (`date`, `hour`, `name`, `selfId`, `userId`, `channelId`, `platform`, `count`) VALUES (20222, 15, 'jrys', '161461357', 205, '853402770', 'onebot', 1) ON DUPLICATE KEY UPDATE `count` = (ifnull(`count`, 0) + 1)
2025-05-15 00:39:24 [D] mysql > SELECT `aid` FROM `binding` lcdxnmkh WHERE `platform` = 'onebot' AND `pid` = '2760260989'
2025-05-15 00:39:24 [D] onebot [response] { status: 'ok', retcode: 0, data: [ { group_id: 1028779507, group_name: '樱色梦境Downloads', group_memo: '', group_create_time: 1578819850, member_count: 4, max_member_count: 200, remark_name: '' }, { group_id: 1130315677, group_name: '老八整活群 总群', group_memo: '', group_create_time: 1595858154, member_count: 55, max_member_count: 500, remark_name: '' }, { group_id: 199655755, group_name: 'wiyi修改群（1群）', group_memo: '', group_create_time: 1586029741, member_count: 1753, max_member_count: 200, remark_name: '' }, { group_id: 202457754, group_name: '游戏百草园', group_memo: '', group_create_time: 1579101087, member_count: 83, max_member_count: 500, remark_name: '' }, { group_id: 553857961, group_name: '机器人专用群.', group_memo: '', group_create_time: 1596276855, member_count: 33, max_member_count: 200, remark_name: '' }, { group_id: 611599486, group_name: '皇宫', group_memo: '', group_create_time: 1596950034, member_count: 25, max_member_count: 200, remark_name: '' }, { group_id: 656488911, group_name: '<$ǿĀD\x0E><$ÿĀ\x11\x10>一群冤种～～', group_memo: '', group_create_time: 1628643095, member_count: 18, max_member_count: 200, remark_name: '' }, { group_id: 746864964, group_name: '夢時🍁开发测试', group_memo: '', group_create_time: 1701172957, member_count: 6, max_member_count: 200, remark_name: '' }, { group_id: 778663382, group_name: '拦哑闻式体制化群聊', group_memo: '', group_create_time: 1562984879, member_count: 9, max_member_count: 200, remark_name: '' }, { group_id: 808618262, group_name: '半世倾城 ‖提前预热', group_memo: '', group_create_time: 1551106603, member_count: 36, max_member_count: 200, remark_name: '' }, { group_id: 853402770, group_name: '樱色梦境<$ǿĀD\x0E>​', group_memo: '', group_create_time: 1533175742, member_count: 126, max_member_count: 500, remark_name: '' }, { group_id: 854441706, group_name: '没妈阿伟一大堆', group_memo: '', group_create_time: 1553314783, member_count: 45, max_member_count: 500, remark_name: '' }, { group_id: 863515196, group_name: '马云vi p聚集群', group_memo: '', group_create_time: 1655125844, member_count: 19, max_member_count: 200, remark_name: '' }, { group_id: 876133405, group_name: '国服大军', group_memo: '', group_create_time: 1627281879, member_count: 8, max_member_count: 200, remark_name: '' } ], message: '', wording: '', echo: 20 }
2025-05-15 00:39:24 [D] mysql > UPDATE `message_counter_records` bzchowcx SET `channelName` = '樱色梦境<$ǿĀD�>​' WHERE `channelId` = '853402770'
2025-05-15 00:39:24 [D] mysql > INSERT INTO `user` (`flag`, `authority`, `locales`, `permissions`, `usage`, `timers`, `password`, `createdAt`) VALUES (0, 1, '', '', json_extract('{}', '$'), json_extract('{}', '$'), '', '2025-05-15 00:39:24.473')
2025-05-15 00:39:24 [D] mysql > SELECT `aid` FROM `binding` wtbuilof WHERE `platform` = 'onebot' AND `pid` = '2760260989'
2025-05-15 00:39:24 [D] mysql > SELECT `id`, `channelId`, `channelName`, `userId`, `username`, `userAvatar`, `todayPostCount`, `thisWeekPostCount`, `thisMonthPostCount`, `thisYearPostCount`, `totalPostCount`, `yesterdayPostCount` FROM `message_counter_records` pixxxatn WHERE `channelId` = '853402770' AND `userId` = '2760260989'
2025-05-15 00:39:24 [D] analytics analytics updated
2025-05-15 00:39:24 [D] mysql > INSERT INTO `user` (`flag`, `authority`, `locales`, `permissions`, `usage`, `timers`, `password`, `createdAt`) VALUES (0, 1, '', '', json_extract('{}', '$'), json_extract('{}', '$'), '', '2025-05-15 00:39:24.487')
2025-05-15 00:39:24 [D] mysql > INSERT INTO `message_counter_records` (`channelId`, `channelName`, `userId`, `username`, `userAvatar`, `todayPostCount`, `thisWeekPostCount`, `thisMonthPostCount`, `thisYearPostCount`, `totalPostCount`, `yesterdayPostCount`) VALUES ('853402770', '樱色梦境<$ǿĀD�>​', '2760260989', '两万只夜雨爱跳舞', 'http://q.qlogo.cn/headimg_dl?dst_uin=2760260989&spec=640', 1, 1, 1, 1, 1, 0)
2025-05-15 00:39:24 [D] mysql > INSERT INTO `binding` (`aid`, `bid`, `pid`, `platform`) VALUES (207, 207, '2760260989', 'onebot')
2025-05-15 00:39:24 [D] mysql > INSERT INTO `binding` (`aid`, `bid`, `pid`, `platform`) VALUES (208, 208, '2760260989', 'onebot')
2025-05-15 00:39:24 [W] mysql > INSERT INTO `binding` (`aid`, `bid`, `pid`, `platform`) VALUES (208, 208, '2760260989', 'onebot')
2025-05-15 00:39:24 [W] session <at id="161461357" name="凌梦"/> 复活吧老叶的爱人
                        ER_DUP_ENTRY: Duplicate entry '2760260989-onebot' for key 'PRIMARY'
                            at MySQLDriver.query (/koishi/node_modules/@minatojs/driver-mysql/lib/index.cjs:484:19)
                            at MySQLDriver.create (/koishi/node_modules/@minatojs/driver-mysql/lib/index.cjs:598:31)
                            at Executable.execute (/koishi/node_modules/minato/lib/index.cjs:807:34)
                            at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
                            at async Proxy.createUser (/koishi/node_modules/@koishijs/core/lib/index.cjs:584:5)
                            at async Proxy.observeUser (/koishi/node_modules/@koishijs/core/lib/index.cjs:1958:18)
                            at async Processor.attach (/koishi/node_modules/@koishijs/core/lib/index.cjs:805:20)
                            at async next (/koishi/node_modules/@koishijs/core/lib/index.cjs:829:16)
                            at async next (/koishi/node_modules/@koishijs/core/lib/index.cjs:829:16)
                            at async next (/koishi/node_modules/@koishijs/core/lib/index.cjs:829:16)
2025-05-15 00:39:58 [D] onebot [receive] { time: 1747269598, self_id: 161461357, post_type: 'meta_event', meta_event_type: 'heartbeat', status: { online: true, good: true }, interval: 60000 }
2025-05-15 00:40:58 [D] onebot [receive] { time: 1747269658, self_id: 161461357, post_type: 'meta_event', meta_event_type: 'heartbeat', status: { online: true, good: true }, interval: 60000 }
2025-05-15 00:41:57 [D] mysql > DELETE FROM `cache` WHERE `expire` < '2025-05-15 00:41:57.930'
2025-05-15 00:41:58 [D] onebot [receive] { time: 1747269718, self_id: 161461357, post_type: 'meta_event', meta_event_type: 'heartbeat', status: { online: true, good: true }, interval: 60000 }
2025-05-15 00:41:58 [D] mysql > DELETE FROM `cache` WHERE `expire` < '2025-05-15 00:41:58.531'
2025-05-15 00:41:58 [D] onebot [receive] { self_id: 161461357, user_id: 2760260989, time: 1747269718, message_id: 327267877, message_seq: 174102, message_type: 'group', sender: { user_id: 2760260989, nickname: '仲夏二十', card: '两万只夜雨爱跳舞', role: 'admin', title: '鸽子🐦' }, raw_message: '/start', font: 14, sub_type: 'normal', message: [ { type: 'text', data: { text: '/start' } } ], message_format: 'array', post_type: 'message', group_id: 853402770 }
2025-05-15 00:41:58 [D] onebot [request] get_group_list { no_cache: undefined }
2025-05-15 00:41:58 [D] mysql > SELECT `flag`, `assignee`, `guildId`, `permissions`, `locales` FROM `channel` osustuuq WHERE `platform` = 'onebot' AND `id` = '853402770'
2025-05-15 00:41:58 [D] mysql > SELECT `aid` FROM `binding` fmmptfwl WHERE `platform` = 'onebot' AND `pid` = '2760260989'
2025-05-15 00:41:58 [D] mysql > SELECT `id`, `name`, `permissions` FROM `user` ifjtmzal WHERE `id` = 207
2025-05-15 00:41:58 [D] mysql > SELECT `aid` FROM `binding` xbpidgol WHERE `platform` = 'onebot' AND `pid` = '2760260989'
2025-05-15 00:41:58 [D] onebot [response] { status: 'ok', retcode: 0, data: [ { group_id: 1028779507, group_name: '樱色梦境Downloads', group_memo: '', group_create_time: 1578819850, member_count: 4, max_member_count: 200, remark_name: '' }, { group_id: 1130315677, group_name: '老八整活群 总群', group_memo: '', group_create_time: 1595858154, member_count: 55, max_member_count: 500, remark_name: '' }, { group_id: 199655755, group_name: 'wiyi修改群（1群）', group_memo: '', group_create_time: 1586029741, member_count: 1753, max_member_count: 200, remark_name: '' }, { group_id: 202457754, group_name: '游戏百草园', group_memo: '', group_create_time: 1579101087, member_count: 83, max_member_count: 500, remark_name: '' }, { group_id: 553857961, group_name: '机器人专用群.', group_memo: '', group_create_time: 1596276855, member_count: 33, max_member_count: 200, remark_name: '' }, { group_id: 611599486, group_name: '皇宫', group_memo: '', group_create_time: 1596950034, member_count: 25, max_member_count: 200, remark_name: '' }, { group_id: 656488911, group_name: '<$ǿĀD\x0E><$ÿĀ\x11\x10>一群冤种～～', group_memo: '', group_create_time: 1628643095, member_count: 18, max_member_count: 200, remark_name: '' }, { group_id: 746864964, group_name: '夢時🍁开发测试', group_memo: '', group_create_time: 1701172957, member_count: 6, max_member_count: 200, remark_name: '' }, { group_id: 778663382, group_name: '拦哑闻式体制化群聊', group_memo: '', group_create_time: 1562984879, member_count: 9, max_member_count: 200, remark_name: '' }, { group_id: 808618262, group_name: '半世倾城 ‖提前预热', group_memo: '', group_create_time: 1551106603, member_count: 36, max_member_count: 200, remark_name: '' }, { group_id: 853402770, group_name: '樱色梦境<$ǿĀD\x0E>​', group_memo: '', group_create_time: 1533175742, member_count: 126, max_member_count: 500, remark_name: '' }, { group_id: 854441706, group_name: '没妈阿伟一大堆', group_memo: '', group_create_time: 1553314783, member_count: 45, max_member_count: 500, remark_name: '' }, { group_id: 863515196, group_name: '马云vi p聚集群', group_memo: '', group_create_time: 1655125844, member_count: 19, max_member_count: 200, remark_name: '' }, { group_id: 876133405, group_name: '国服大军', group_memo: '', group_create_time: 1627281879, member_count: 8, max_member_count: 200, remark_name: '' } ], message: '', wording: '', echo: 22 }
2025-05-15 00:41:58 [D] mysql > UPDATE `message_counter_records` arkdkcyi SET `channelName` = '樱色梦境<$ǿĀD�>​' WHERE `channelId` = '853402770'
2025-05-15 00:41:58 [D] mysql > SELECT `id`, `flag`, `authority`, `permissions`, `locales` FROM `user` xmfgochq WHERE `id` = 207
2025-05-15 00:41:58 [D] mysql > SELECT `id`, `channelId`, `channelName`, `userId`, `username`, `userAvatar`, `todayPostCount`, `thisWeekPostCount`, `thisMonthPostCount`, `thisYearPostCount`, `totalPostCount`, `yesterdayPostCount` FROM `message_counter_records` avpumypw WHERE `channelId` = '853402770' AND `userId` = '2760260989'

Versions

• OS: Linux 6.6 Alpine Linux
• Platform: QQ
• Node version: v20.16.0
• Koishi version: 4.18.7

Additional context

No response

[itzdrli]

日志炸眼，帮你修改了
顺便有完整复现么，包括使用的插件，koishi各组件的版本

[Hieuzest]

你使用的 araea/koishi-plugin-message-counter 使用了 ctx.on('message') 配合 session.getUser 的方案，在当前架构下可能产生问题。建议改为前置中间件。cc @araea

[araea]

你使用的 araea/koishi-plugin-message-counter 使用了 ctx.on('message') 配合 session.getUser 的方案，在当前架构下可能产生问题。建议改为前置中间件。cc @araea

插件代码中没有使用 session.getUser

代码中的 getUser 含义如下

    const getUser = await ctx.database.get("message_counter_records", {
      channelId,
      userId,
    });