[MDEV-24063] Assertion during graceful shutdown with wsrep_on=OFF Created: 2020-10-30  Updated: 2020-12-22  Resolved: 2020-11-04

Status: Closed
Project: MariaDB Server
Component/s: Galera
Affects Version/s: 10.4, 10.5
Fix Version/s: 10.4.18, 10.5.9, 10.6.0

Type: Bug Priority: Major
Reporter: Daniele Sciascia Assignee: Jan Lindström (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-24475 galera.MDEV-24063 MTR failed: inline_... Open

 Description   

A graceful shutdown of a galera node may result in assertion:

mariadbd: /home/sciascid/Workspace/src/mariadb-server/sql/service_wsrep.cc:264: my_bool wsrep_thd_is_aborting(const THD*): Assertion `((&(&thd->LOCK_thd_data)->m_mutex)->count > 0 && pthread_equal(pthread_self(), (&(&thd->LOCK_thd_data)->m_mutex)->thread))' failed.

This issue was originally found in 10.5, on MTR test galera_3nodes.inconsistency_shutdown. A simpler test was devised that reproduces on 10.4 as well:

--source include/galera_cluster.inc
--connect node_2a, 127.0.0.1, root, , test, $NODE_MYPORT_2
--connection node_2a
CREATE TABLE t1 (f1 INTEGER PRIMARY KEY);
--connection node_2
SET GLOBAL wsrep_on=OFF;
--source include/shutdown_mysqld.inc


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