Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.4.17, 10.4.18, 10.4.19, 10.4.20, 10.4.21, 10.4.22
-
Oracle Linux 8.4
Mariadb binary distribution x86_64 for systemd
Description
Mariadb stuck(hang) at shutdown approximately 1/3 times with active slave connection, execuiting STOP ALL SLAVES before shutdown helps.
Configuration and strace added to attachment.
Shutdown from error_log (i eventually killed with -9, nothing else works, you can wait for hours)
Nov 26 13:49:34 x1 systemd[1]: Stopping MariaDB 10.4.x database server...
Nov 26 13:49:34 x1 mysqld[3164320]: 2021-11-26 13:49:34 0 [Note] /usr/local/mysql/bin/mysqld (initiated by: unknown): Normal shutdown
Nov 26 13:49:34 x1 mysqld[3164320]: 2021-11-26 13:49:34 0 [Note] Event Scheduler: Purging the queue. 0 events
Nov 26 13:49:34 x1 mysqld[3164320]: 2021-11-26 13:49:34 0 [ERROR] InnoDB: (Duplicate key) writing word node to FTS auxiliary index table `d_8nkc96648k3uln`.`jos_vm_product_param_xref`
Nov 26 13:49:34 x1 mysqld[3164320]: 2021-11-26 13:49:34 0 [Note] InnoDB: FTS optimize thread exiting.
Nov 26 13:54:34 x1 systemd[1]: mariadb.service: State 'stop-sigterm' timed out. Skipping SIGKILL.
Nov 26 13:56:39 x1 mysqld[3164320]: 2021-11-26 13:56:39 24 [ERROR] Master 'x5': Error reading packet from server: Lost connection to MySQL server during query (server_errno=2013)
Nov 26 13:56:39 x1 mysqld[3164320]: 2021-11-26 13:56:39 24 [Note] Master 'x5': Slave I/O thread: Failed reading log event, reconnecting to retry, log 'binary_log.010514' at position 97604371; GTID position '1-13-2385195623,2-14-212>
Nov 26 13:56:39 x1 mysqld[3164320]: 2021-11-26 13:56:39 24 [ERROR] Master 'x5': Slave I/O: error reconnecting to master 'replicator@10.1.1.25:3306' - retry-time: 60 maximum-retries: 86400 message: Can't connect to MySQL server on>
Nov 26 13:57:24 x1 systemd[1]: mariadb.service: Main process exited, code=killed, status=9/KILL
Nov 26 13:57:24 x1 systemd[1]: mariadb.service: Failed with result 'timeout'.
Attachments
Issue Links
- relates to
-
MDEV-28948 FLUSH BINARY LOGS waits/hangs on mysql_mutex_unlock(&LOCK_index) forever
- Closed