Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-24163

Mariadb is restarting after sending this message [Warning] Aborted connection 5889 to db: 'xxxx' user: 'xxxxx' host:

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Duplicate
    • 10.3.26, 10.5.7
    • N/A
    • Optimizer
    • PhpBB 3.3 interacting with mariadb

    Description

      After updating to either version from 10.5.x and 10.3.25 respectively, two different users of phpBB board started getting errors and journal registered mariadb restarting with the following message:

      [Warning] Aborted connection 5889 to db: 'xxxx' user: 'xxxxx' host:
      

      The backtrace in phpBB is:

       
      SQL ERROR [ mysqli ]
       
      MySQL server has gone away [2006]
       
      SQL
       
      DELETE FROM phpbb_notification_emails WHERE notification_type_id IN (40, 41) AND user_id = '4' AND item_id IN (1156688, 1156686, 1156682, 1156669, 1156668, 1156667, 1156660, 1156659, 1156654, 1156627, 1156624, 1156605, 1156592, 1156590, 1156581)
       
      BACKTRACE
       
      FILE: (not given by php)
      LINE: (not given by php)
      CALL: msg_handler()
       
      FILE: [ROOT]/phpbb/db/driver/driver.php
      LINE: 1023
      CALL: trigger_error()
       
      FILE: [ROOT]/phpbb/db/driver/mysqli.php
      LINE: 195
      CALL: phpbb\db\driver\driver->sql_error()
       
      FILE: [ROOT]/phpbb/db/driver/factory.php
      LINE: 345
      CALL: phpbb\db\driver\mysqli->sql_query()
       
      FILE: [ROOT]/phpbb/notification/method/email.php
      LINE: 132
      CALL: phpbb\db\driver\factory->sql_query()
       
      FILE: [ROOT]/phpbb/notification/manager.php
      LINE: 177
      CALL: phpbb\notification\method\email->mark_notifications()
       
      FILE: [ROOT]/phpbb/notification/manager.php
      LINE: 147
      CALL: phpbb\notification\manager->mark_notifications()
       
      FILE: [ROOT]/ext/gfksx/thanksforposts/core/helper.php
      LINE: 862
      CALL: phpbb\notification\manager->mark_notifications_read()
       
      FILE: [ROOT]/ext/gfksx/thanksforposts/event/listener.php
      LINE: 281
      CALL: gfksx\thanksforposts\core\helper->notification_markread()
       
      FILE: [ROOT]/vendor/symfony/event-dispatcher/EventDispatcher.php
      LINE: 214
      CALL: gfksx\thanksforposts\event\listener->markread()
       
      FILE: [ROOT]/vendor/symfony/event-dispatcher/EventDispatcher.php
      LINE: 44
      CALL: Symfony\Component\EventDispatcher\EventDispatcher->doDispatch()
       
      FILE: [ROOT]/phpbb/event/dispatcher.php
      LINE: 62
      CALL: Symfony\Component\EventDispatcher\EventDispatcher->dispatch()
       
      FILE: [ROOT]/phpbb/event/dispatcher.php
      LINE: 46
      CALL: phpbb\event\dispatcher->dispatch()
       
      FILE: [ROOT]/viewtopic.php
      LINE: 2417
      CALL: phpbb\event\dispatcher->trigger_event()
      
      

      This didn’t happened in previous versions of mariadb. I decided to keep 10.5.7 with email disabled and the other user downgraded to mariadb 10.3.25.

      This is the thread where we discussed it https://www.phpbb.com/community/viewtopic.php?f=661&t=2573166

      Attachments

        Issue Links

          Activity

            People

              danblack Daniel Black
              lbartolome Lucía
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.