Package: anope Version: 2.0.17-1 Severity: important Dear Maintainer,
The newer version of MariaDB that ships with Debian Trixie causes a regression in anope with db_sql_live based databases where Anope cannot access the database at all. There is a patch and this has been fixed upstream in anope. This is a pretty serious bug that causes Anope not to work and pull any user or channel data from the database. Here are my logs of this bug on anope version 2.0.17-1 on Debian Trixie. [Feb 22 16:43:36 2026] Loading databases... [Feb 22 16:43:36 2026] Databases loaded [Feb 22 16:43:36 2026] SQL-live got 0 rows for SELECT * FROM `anope_db_BotInfo` WHERE (`timestamp` >= FROM_UNIXTIME(0) OR `timestamp` IS NULL) [Feb 22 16:43:36 2026] SQL-live got 0 rows for SELECT * FROM `anope_db_AJoinEntry` WHERE (`timestamp` >= FROM_UNIXTIME(0) OR `timestamp` IS NULL) [Feb 22 16:43:36 2026] SQL-live got error Table 'obd_irc_anope.anope_db_AutoKick' doesn't exist for SELECT * FROM `anope_db_AutoKick` WHERE (`timestamp` >= FROM_UNIXTIME(0) OR `timestamp` IS NULL) [Feb 22 16:43:36 2026] SQL-live got error Table 'obd_irc_anope.anope_db_BadWord' doesn't exist for SELECT * FROM `anope_db_BadWord` WHERE (`timestamp` >= FROM_UNIXTIME(0) OR `timestamp` IS NULL) [Feb 22 16:43:36 2026] SQL-live got 0 rows for SELECT * FROM `anope_db_CSMiscData` WHERE (`timestamp` >= FROM_UNIXTIME(0) OR `timestamp` IS NULL) [Feb 22 16:43:36 2026] SQL-live got error Table 'obd_irc_anope.anope_db_CSSuspendInfo' doesn't exist for SELECT * FROM `anope_db_CSSuspendInfo` WHERE (`timestamp` >= FROM_UNIXTIME(0) OR `timestamp` IS NULL) [Feb 22 16:43:36 2026] SQL-live got 0 rows for SELECT * FROM `anope_db_ChanAccess` WHERE (`timestamp` >= FROM_UNIXTIME(0) OR `timestamp` IS NULL) [Feb 22 16:43:36 2026] SQL-live got 0 rows for SELECT * FROM `anope_db_ChannelInfo` WHERE (`timestamp` >= FROM_UNIXTIME(0) OR `timestamp` IS NULL) [Feb 22 16:43:36 2026] SQL-live got error Table 'obd_irc_anope.anope_db_EntryMsg' doesn't exist for SELECT * FROM `anope_db_EntryMsg` WHERE (`timestamp` >= FROM_UNIXTIME(0) OR `timestamp` IS NULL) [Feb 22 16:43:36 2026] SQL-live got error Table 'obd_irc_anope.anope_db_Exception' doesn't exist for SELECT * FROM `anope_db_Exception` WHERE (`timestamp` >= FROM_UNIXTIME(0) OR `timestamp` IS NULL) [Feb 22 16:43:36 2026] SQL-live got error Table 'obd_irc_anope.anope_db_ForbidData' doesn't exist for SELECT * FROM `anope_db_ForbidData` WHERE (`timestamp` >= FROM_UNIXTIME(0) OR `timestamp` IS NULL) [Feb 22 16:43:36 2026] SQL-live got error Table 'obd_irc_anope.anope_db_IgnoreData' doesn't exist for SELECT * FROM `anope_db_IgnoreData` WHERE (`timestamp` >= FROM_UNIXTIME(0) OR `timestamp` IS NULL) [Feb 22 16:43:36 2026] SQL-live got error Table 'obd_irc_anope.anope_db_LogSetting' doesn't exist for SELECT * FROM `anope_db_LogSetting` WHERE (`timestamp` >= FROM_UNIXTIME(0) OR `timestamp` IS NULL) [Feb 22 16:43:36 2026] SQL-live got 0 rows for SELECT * FROM `anope_db_Memo` WHERE (`timestamp` >= FROM_UNIXTIME(0) OR `timestamp` IS NULL) [Feb 22 16:43:36 2026] SQL-live got 0 rows for SELECT * FROM `anope_db_ModeLock` WHERE (`timestamp` >= FROM_UNIXTIME(0) OR `timestamp` IS NULL) [Feb 22 16:43:36 2026] SQL-live got 0 rows for SELECT * FROM `anope_db_NSMiscData` WHERE (`timestamp` >= FROM_UNIXTIME(0) OR `timestamp` IS NULL) [Feb 22 16:43:36 2026] SQL-live got error Table 'obd_irc_anope.anope_db_NSSuspendInfo' doesn't exist for SELECT * FROM `anope_db_NSSuspendInfo` WHERE (`timestamp` >= FROM_UNIXTIME(0) OR `timestamp` IS NULL) [Feb 22 16:43:36 2026] SQL-live got error Table 'obd_irc_anope.anope_db_NewsItem' doesn't exist for SELECT * FROM `anope_db_NewsItem` WHERE (`timestamp` >= FROM_UNIXTIME(0) OR `timestamp` IS NULL) [Feb 22 16:43:36 2026] SQL-live got 0 rows for SELECT * FROM `anope_db_NickAlias` WHERE (`timestamp` >= FROM_UNIXTIME(0) OR `timestamp` IS NULL) [Feb 22 16:43:36 2026] SQL-live got 0 rows for SELECT * FROM `anope_db_NickCore` WHERE (`timestamp` >= FROM_UNIXTIME(0) OR `timestamp` IS NULL) [Feb 22 16:43:36 2026] SQL-live got error Table 'obd_irc_anope.anope_db_OperInfo' doesn't exist for SELECT * FROM `anope_db_OperInfo` WHERE (`timestamp` >= FROM_UNIXTIME(0) OR `timestamp` IS NULL) [Feb 22 16:43:36 2026] SQL-live got 0 rows for SELECT * FROM `anope_db_SeenInfo` WHERE (`timestamp` >= FROM_UNIXTIME(0) OR `timestamp` IS NULL) [Feb 22 16:43:36 2026] SQL-live got 0 rows for SELECT * FROM `anope_db_Stats` WHERE (`timestamp` >= FROM_UNIXTIME(0) OR `timestamp` IS NULL) [Feb 22 16:43:36 2026] SQL-live got error Table 'obd_irc_anope.anope_db_XLine' doesn't exist for SELECT * FROM `anope_db_XLine` WHERE (`timestamp` >= FROM_UNIXTIME(0) OR `timestamp` IS NULL) [Feb 22 16:43:36 2026] Attempting to connect to uplink #1 127.0.0.1 (127.0.0.1/6698) with protocol InspIRCd 3 [Feb 22 16:43:36 2026] m_mysql: Fetching columns for anope_db_BotInfo [Feb 22 16:43:36 2026] m_mysql: Column #0 for anope_db_BotInfo: id [Feb 22 16:43:36 2026] m_mysql: Column #1 for anope_db_BotInfo: timestamp [Feb 22 16:43:36 2026] m_mysql: Column #2 for anope_db_BotInfo: created [Feb 22 16:43:36 2026] m_mysql: Column #3 for anope_db_BotInfo: host [Feb 22 16:43:36 2026] m_mysql: Column #4 for anope_db_BotInfo: nick [Feb 22 16:43:36 2026] m_mysql: Column #5 for anope_db_BotInfo: oper_only [Feb 22 16:43:36 2026] m_mysql: Column #6 for anope_db_BotInfo: realname [Feb 22 16:43:36 2026] m_mysql: Column #7 for anope_db_BotInfo: user [Feb 22 16:43:36 2026] SQL-live got 0 rows for INSERT INTO `anope_db_BotInfo` (`id`,`created`,`host`,`nick`,`oper_only`,`realname`,`user`) VALUES (0,'1771796616','openbackdoor.com','ChanServ','0','Open Backdoor IRC Services','irc') ON DUPLICATE KEY UPDATE `created`=VALUES(`created`),`host`=VALUES(`host`),`nick`=VALUES(`nick`),`oper_only`=VALUES(`oper_only`),`realname`=VALUES(`realname`),`user`=VALUES(`user`) [Feb 22 16:43:36 2026] Successfully connected to uplink #1 127.0.0.1:6698 MariaDB [obd_irc_anope]> SELECT * FROM `anope_db_BotInfo` WHERE (`timestamp` >= FROM_UNIXTIME(0) OR `timestamp` IS NULL); Empty set, 1 warning (0.001 sec) MariaDB [obd_irc_anope]> SHOW WARNINGS; +---------+------+-------------------------------------------+ | Level | Code | Message | +---------+------+-------------------------------------------+ | Warning | 1292 | Truncated incorrect unixtime value: '0.0' | +---------+------+-------------------------------------------+ 1 row in set (0.000 sec) See: https://github.com/anope/anope/issues/474 https://jira.mariadb.org/browse/MDEV-36126 Patch: https://github.com/anope/anope/commit/227caba7838f680c24e730ad3a4f534b59763dbc I would greatly appreciate it if you could upload a patch against the current stable version into proposed-updates on stable so we can get this fix asap on trixie. As it stands the only current workaround is export the SQL database into an anope flatfile, or use the non-live sql engine which is delayed. The patch is trivial and should have no issues getting this fixed in stable. Thank you, Victor Coss
