[MDEV-26697] MariaDB keeps rebooting after upgrade from 10.3.23 to 10.3.31 Created: 2021-09-27  Updated: 2021-10-29  Resolved: 2021-10-29

Status: Closed
Project: MariaDB Server
Component/s: Galera
Affects Version/s: 10.3.31
Fix Version/s: N/A

Type: Bug Priority: Minor
Reporter: Franck Laprevote Assignee: Jan Lindström (Inactive)
Resolution: Duplicate Votes: 0
Labels: None
Environment:

Ubuntu server 20.04

Attachments: Text File mariadb_crashlog.txt     Text File my.cnf.txt     Text File mysql_backtrace.txt    
Issue Links:
Duplicate
duplicates MDEV-25835 mariadb 10.3.29 galera cluster crashe... Closed

 Description   

Hello,

I have a 3 nodes cluster. Everything is working fine in 10.3.23 version. When I upgrade a node to 10.3.31, MariaDB keeps restarting every 5 minutes approximatively. Do you know where this problem can come from? If I rollback to 10.3.23, everything is working fine.

 Comments   
Comment by Daniel Black [ 2021-09-30 ]

If you have the opportunity to install some debug symbols https://wiki.ubuntu.com/Debug%20Symbol%20Packages , package mariadb-server-core-10.3-dbg or mariadb-server-core-10.3-dbgsym and look at the backtrace again that would be greatly appreciated.

If a core file is generated or captured by apport, https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mysqld/#getting-backtraces-for-all-threads-from-a-core-file will greatly assist in diagnosing what might have gone wrong.

Comment by Franck Laprevote [ 2021-10-04 ]

Hello,
Thanks for your answer, I'll try again an update with these tools and update this ticket with more info.
Best regards.

Comment by Franck Laprevote [ 2021-10-11 ]

Hello,
I installed mariadb-server-core-10.3-dbgsym and did an update again, you can find attached the backtrace of the error.
Also, some information about my installation. I have 3 nodes on Ubuntu 20.04 in a cluster. You can find attached my.cnf config file.
Specs of the servers:

  • Intel Xeon-E 2274G - 4c/8t - 4 GHz/4.9 GHz
  • 32 GB ECC 2666 MHz
  • 2×960 GB SSD NVMe

If you need any other info feel free to ask.
Thanks for your help.
mysql_backtrace.txt my.cnf.txt

Comment by Franck Laprevote [ 2021-10-28 ]

Hello,
Any news on this subject? If you need more information, please feel free to ask.
Best regards.

Comment by Daniel Black [ 2021-10-29 ]

The stack trace assertion looks exactly like MDEV-25835

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