Skip to content
This repository was archived by the owner on Nov 19, 2025. It is now read-only.
This repository was archived by the owner on Nov 19, 2025. It is now read-only.

mysql数据库炸了喵 #51

Description

@songmingtiiiii

检查项

  • 我确认此问题在所有分支的最新版本中依旧存在
  • 我确认在 Issues 列表中并无其他人已经提出过与此问题相同或相似的问题
  • 我使用了 Docker

使用的分支

dev

具体版本号

0.11.1-alpha-1

遇到的问题

睡眠系统删掉的那个版本还可以,拉到最新的dev就出现了mysql数据库无法正常使用,不是不回复消息,问题体现于无法正常读到数据库的数据,控制台代码刷屏,但是数据库文件貌似并没有被更改?或者说改在了其他地方,但是我没有找到

Image

报错信息

{"logger_name": "MaiZone.SchedulerService", "event": "基于日程表的说说定时发送任务已启动。", "level": "info", "timestamp": "10-27 12:46:10", "color": "\u001b[38;5;134m", "alias": "Mai空间调度"}
{"logger_name": "MaiZone.MonitorService", "event": "好友动态监控任务已启动", "level": "info", "timestamp": "10-27 12:46:10", "color": "\u001b[38;5;104m", "alias": "Mai空间监控"}
{"logger_name": "connection_pool_manager", "event": "创建新连接 (活跃连接数: 6)", "level": "debug", "timestamp": "10-27 12:46:10"}
{"logger_name": "connection_pool_manager", "event": "创建新连接 (活跃连接数: 7)", "level": "debug", "timestamp": "10-27 12:46:10"}
{"logger_name": "connection_pool_manager", "event": "创建新连接 (活跃连接数: 8)", "level": "debug", "timestamp": "10-27 12:46:10"}
{"logger_name": "connection_pool_manager", "event": "创建新连接 (活跃连接数: 9)", "level": "debug", "timestamp": "10-27 12:46:10"}
{"logger_name": "connection_pool_manager", "event": "创建新连接 (活跃连接数: 10)", "level": "debug", "timestamp": "10-27 12:46:10"}
{"logger_name": "connection_pool_manager", "event": "连接验证失败,将移除: Textual SQL expression 'SELECT 1' should be explicitly declared as text('SELECT 1')", "level": "debug", "timestamp": "10-27 12:46:10"}
{"logger_name": "connection_pool_manager", "event": "连接已关闭", "level": "debug", "timestamp": "10-27 12:46:10"}
{"logger_name": "connection_pool_manager", "event": "创建新连接 (活跃连接数: 10)", "level": "debug", "timestamp": "10-27 12:46:10"}
{"logger_name": "src.common.message_repository", "event": "执行earliest查询失败: (pymysql.err.OperationalError) (1054, "Unknown column 'messages.is_public_notice' in 'field list'")\n[SQL: SELECT messages.id, messages.message_id, messages.time, messages.chat_id, messages.reply_to, messages.interest_value, messages.key_words, messages.key_words_lite, messages.is_mentioned, messages.chat_info_stream_id, messages.chat_info_platform, messages.chat_info_user_platform, messages.chat_info_user_id, messages.chat_info_user_nickname, messages.chat_info_user_cardname, messages.chat_info_group_platform, messages.chat_info_group_id, messages.chat_info_group_name, messages.chat_info_create_time, messages.chat_info_last_active_time, messages.user_platform, messages.user_id, messages.user_nickname, messages.user_cardname, messages.processed_plain_text, messages.display_message, messages.memorized_times, messages.priority_mode, messages.priority_info, messages.additional_config, messages.is_emoji, messages.is_picid, messages.is_command, messages.is_notify, messages.is_public_notice, messages.notice_type, messages.actions, messages.should_reply, messages.should_act \nFROM messages \nWHERE messages.time > %s AND messages.time < %s ORDER BY messages.time ASC \n LIMIT %s]\n[parameters: (1761356713.626304, 1761358195.626304, 1)]\n(Background on this error at: https://sqlalche.me/e/20/e3q8)", "level": "error", "timestamp": "10-27 12:46:10"}
{"logger_name": "connection_pool_manager", "event": "连接验证失败,将移除: Textual SQL expression 'SELECT 1' should be explicitly declared as text('SELECT 1')", "level": "debug", "timestamp": "10-27 12:46:10"}
{"logger_name": "src.common.message_repository", "event": "执行earliest查询失败: (pymysql.err.OperationalError) (1054, "Unknown column 'messages.is_public_notice' in 'field list'")\n[SQL: SELECT messages.id, messages.message_id, messages.time, messages.chat_id, messages.reply_to, messages.interest_value, messages.key_words, messages.key_words_lite, messages.is_mentioned, messages.chat_info_stream_id, messages.chat_info_platform, messages.chat_info_user_platform, messages.chat_info_user_id, messages.chat_info_user_nickname, messages.chat_info_user_cardname, messages.chat_info_group_platform, messages.chat_info_group_id, messages.chat_info_group_name, messages.chat_info_create_time, messages.chat_info_last_active_time, messages.user_platform, messages.user_id, messages.user_nickname, messages.user_cardname, messages.processed_plain_text, messages.display_message, messages.memorized_times, messages.priority_mode, messages.priority_info, messages.additional_config, messages.is_emoji, messages.is_picid, messages.is_command, messages.is_notify, messages.is_public_notice, messages.notice_type, messages.actions, messages.should_reply, messages.should_act \nFROM messages \nWHERE messages.time > %s AND messages.time < %s ORDER BY messages.time ASC \n LIMIT %s]\n[parameters: (1761241085.868052, 1761242447.868052, 1)]\n(Background on this error at: https://sqlalche.me/e/20/e3q8)", "level": "error", "timestamp": "10-27 12:46:10"}
{"logger_name": "src.common.message_repository", "event": "执行earliest查询失败: (pymysql.err.OperationalError) (1054, "Unknown column 'messages.is_public_notice' in 'field list'")\n[SQL: SELECT messages.id, messages.message_id, messages.time, messages.chat_id, messages.reply_to, messages.interest_value, messages.key_words, messages.key_words_lite, messages.is_mentioned, messages.chat_info_stream_id, messages.chat_info_platform, messages.chat_info_user_platform, messages.chat_info_user_id, messages.chat_info_user_nickname, messages.chat_info_user_cardname, messages.chat_info_group_platform, messages.chat_info_group_id, messages.chat_info_group_name, messages.chat_info_create_time, messages.chat_info_last_active_time, messages.user_platform, messages.user_id, messages.user_nickname, messages.user_cardname, messages.processed_plain_text, messages.display_message, messages.memorized_times, messages.priority_mode, messages.priority_info, messages.additional_config, messages.is_emoji, messages.is_picid, messages.is_command, messages.is_notify, messages.is_public_notice, messages.notice_type, messages.actions, messages.should_reply, messages.should_act \nFROM messages \nWHERE messages.time > %s AND messages.time < %s ORDER BY messages.time ASC \n LIMIT %s]\n[parameters: (1761373252.610701, 1761374022.610701, 1)]\n(Background on this error at: https://sqlalche.me/e/20/e3q8)", "level": "error", "timestamp": "10-27 12:46:10"}

如何重现此问题?

使用mysql作为数据库类型,然后使用最新的Dev运行

可能造成问题的原因

无法读取数据库,控制台报错刷屏,一点可读性都没有了喵

系统环境

Ubuntu21.04Server

Python 版本

Python 3.12.3

补充信息

No response

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions