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

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
Labels:
- notifications
- phpbb
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

- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

mariadb_crash.txt
60 kB
2021-03-24 23:34

Issue Links

duplicates

MDEV-24117 Memory management problem in statistics state for queries that have a large field IN (values) part

Closed

Activity

Ascending order - Click to sort in descending order

Lucía created issue - 2020-11-08 14:04

Lucía made changes - 2020-11-08 14:04

Field	Original Value	New Value
Link		This issue blocks ~~MDEV-24155~~ [ ~~MDEV-24155~~ ]

Lucía made changes - 2020-11-08 14:07

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:

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

The backtrace in phpBB is:

{code:java}

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()

{code}
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

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:

{code:java}
[Warning] Aborted connection 5889 to db: 'xxxx' user: 'xxxxx' host:
{code}

The backtrace in phpBB is:

{code:java}

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()

{code}
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

Daniel Black made changes - 2020-11-11 02:32

Link

This issue blocks ~~MDEV-24155~~ [ ~~MDEV-24155~~ ]

Daniel Black made changes - 2020-11-11 03:09

Link

This issue duplicates ~~MDEV-24117~~ [ ~~MDEV-24117~~ ]

Daniel Black made changes - 2020-11-11 21:38

Component/s		Optimizer [ 10200 ]
Component/s	Storage Engine - Connect [ 10128 ]
Fix Version/s		N/A [ 14700 ]
Assignee		Daniel Black [ danblack ]
Resolution		Duplicate [ 3 ]
Status	Open [ 1 ]	Closed [ 6 ]

Charlie Ciccia made changes - 2021-03-24 23:34

Attachment

mariadb_crash.txt [ 56801 ]

Sergei Golubchik made changes - 2021-12-06 21:52

Workflow

MariaDB v3 [ 115546 ]

MariaDB v4 [ 158562 ]

People

Assignee:: Daniel Black

Reporter:: Lucía

Votes:: 0 Vote for this issue

Watchers:: 5 Start watching this issue

Dates

Created:: 2020-11-08 14:04

Updated:: 2021-03-25 04:16

Resolved:: 2020-11-11 21:38

Git Integration

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

MariaDB Server

Details

Description

Attachments

Attachments

Issue Links

Activity

People

Dates

Git Integration