From: gtaxl@gtaxl.net   
      
   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 `an   
   pe_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 `an   
   pe_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.a   
   ope_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.a   
   ope_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 `an   
   pe_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.a   
   ope_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 `an   
   pe_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 `an   
   pe_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.a   
   ope_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.a   
   ope_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.a   
   ope_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.a   
   ope_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.a   
   ope_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 `an   
   pe_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 `an   
   pe_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.a   
   ope_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.a   
   ope_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 `an   
   pe_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 `an   
   pe_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.a   
   ope_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 `an   
   pe_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`=   
   ALUES(`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   
      
      
   [continued in next message]   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)