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

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Minor
    • Resolution: Duplicate
    • Affects Version/s: 10.3.26, 10.5.7
    • Fix Version/s: N/A
    • Component/s: Optimizer
    • Environment:
      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

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

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration