[MDEV-24113] InnoDB: Assertion failure in file /builddir/build/BUILD/mariadb-10.2.33/storage/innobase/include/ut0lst.h line 334 Created: 2020-11-03  Updated: 2021-01-04  Resolved: 2021-01-04

Status: Closed
Project: MariaDB Server
Component/s: OTHER
Affects Version/s: 10.2.33
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: F Adrian Assignee: Marko Mäkelä
Resolution: Incomplete Votes: 0
Labels: need_feedback
Environment:

CL 7 + cPanel + LiteSpeed WS on KVM vm


Attachments: Text File report.txt    

 Description   

In the last month this MariaDB server had 8-9 crashes for no obvious reason. Each time a report like the one attached is generated. Sometimes cPanel restarts MariaDB succesfully sometimes we have to kill the mysqld process because it is getting stuck; each time databases corruption is registered.

This server runs around 20 online shops, with large databases. We replaced our custom my.cnf with the default one but the issue remains.



 Comments   
Comment by Marko Mäkelä [ 2020-11-04 ]

Hi ffadrian, can you please try to resolve this part of the stack trace?

/usr/sbin/mysqld(+0x445838)[0x55b92ae19838]
/usr/sbin/mysqld(+0x9b55f0)[0x55b92b3895f0]
/usr/sbin/mysqld(+0xb3ba27)[0x55b92b50fa27]
/usr/sbin/mysqld(+0xad94c5)[0x55b92b4ad4c5]
/usr/sbin/mysqld(+0xb07703)[0x55b92b4db703]
/usr/sbin/mysqld(+0xb09500)[0x55b92b4dd500]
/usr/sbin/mysqld(+0xb09d89)[0x55b92b4ddd89]
/usr/sbin/mysqld(+0xae5161)[0x55b92b4b9161]
/usr/sbin/mysqld(+0xad5c9e)[0x55b92b4a9c9e]
/usr/sbin/mysqld(+0xadb177)[0x55b92b4af177]
/usr/sbin/mysqld(+0xacaa1d)[0x55b92b49ea1d]
/usr/sbin/mysqld(+0xa2f825)[0x55b92b403825]
/usr/sbin/mysqld(+0xa31e79)[0x55b92b405e79]
/usr/sbin/mysqld(+0x951ff2)[0x55b92b325ff2]

At https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mysqld/ you can find advice for doing this.

Generated at Thu Feb 08 09:27:32 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.