Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Duplicate
-
10.3.26, 10.5.7
-
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
- duplicates
-
MDEV-24117 Memory management problem in statistics state for queries that have a large field IN (values) part
- Closed