Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Incomplete
-
5.5.65
-
CentOS Linux 7.8.2003
Server version: 5.5.65-MariaDB
Description
Warning: 1 threads created by InnoDB had not exited at shutdown! InnoDB: error: return value 16 when calling pthread_mutex_destroy().
Server version: 5.5.65-MariaDB
key_buffer_size=2147483648
read_buffer_size=131072
max_used_connections=3
max_threads=153
thread_count=0
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 2432799 K bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
Thread pointer: 0x0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0x0 thread_stack 0x48000
/usr/libexec/mysqld(my_print_stacktrace+0x3d)[0x55c4f8930efd]
/usr/libexec/mysqld(handle_fatal_signal+0x515)[0x55c4f8544805]
sigaction.c:0(__restore_rt)[0x7f481b382630]
:0(__GI_raise)[0x7f4819aaa387]
:0(__GI_abort)[0x7f4819aaba78]
/usr/libexec/mysqld(+0x2d4898)[0x55c4f8375898]
/usr/libexec/mysqld(+0x71c9f5)[0x55c4f87bd9f5]
/usr/libexec/mysqld(+0x63279f)[0x55c4f86d379f]
/usr/libexec/mysqld(+0x5e8b65)[0x55c4f8689b65]
/usr/libexec/mysqld(_Z22ha_finalize_handlertonP13st_plugin_int+0x2c)[0x55c4f85467dc]
/usr/libexec/mysqld(+0x37b43f)[0x55c4f841c43f]
/usr/libexec/mysqld(+0x37f8d6)[0x55c4f84208d6]
/usr/libexec/mysqld(_Z15plugin_shutdownv+0x1e5)[0x55c4f8421de5]
/usr/libexec/mysqld(+0x2e8ef5)[0x55c4f8389ef5]
/usr/libexec/mysqld(_Z10unireg_endv+0x2d)[0x55c4f838b5fd]
/usr/libexec/mysqld(+0x2eccbc)[0x55c4f838dcbc]
/usr/libexec/mysqld(kill_server_thread+0xe)[0x55c4f838dd0e]
pthread_create.c:0(start_thread)[0x7f481b37aea5]
/lib64/libc.so.6(clone+0x6d)[0x7f4819b728dd]
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
200528 10:44:17 mysqld_safe Number of processes running now: 0
200528 10:44:17 mysqld_safe mysqld restarted
200528 10:44:17 [Note] /usr/libexec/mysqld (mysqld 5.5.65-MariaDB) starting as process 18886 ...
200528 10:44:17 [Warning] Changed limits: max_open_files: 1024 max_connections: 151 table_cache: 431
200528 10:44:17 InnoDB: The InnoDB memory heap is disabled
200528 10:44:17 InnoDB: Mutexes and rw_locks use GCC atomic builtins
200528 10:44:17 InnoDB: Compressed tables use zlib 1.2.7
200528 10:44:17 InnoDB: Using Linux native AIO
200528 10:44:17 InnoDB: Initializing buffer pool, size = 8.0G
200528 10:44:18 InnoDB: Completed initialization of buffer pool
200528 10:44:18 InnoDB: highest supported file format is Barracuda.
200528 10:44:18 InnoDB: Waiting for the background threads to start
200528 10:44:19 Percona XtraDB (http://www.percona.com) 5.5.61-MariaDB-38.13 started; log sequence number 2782470
200528 10:44:19 [Note] Plugin 'FEEDBACK' is disabled.
200528 10:44:19 [Note] Server socket created on IP: '0.0.0.0'.
200528 10:44:19 [Note] Event Scheduler: Loaded 0 events
200528 10:44:19 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.65-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server
200528 20:47:33 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
200528 20:47:34 [Note] /usr/libexec/mysqld (mysqld 5.5.65-MariaDB) starting as process 1339 ...
200528 20:47:34 [Warning] Changed limits: max_open_files: 1024 max_connections: 151 table_cache: 431
200528 20:47:34 InnoDB: The InnoDB memory heap is disabled
200528 20:47:34 InnoDB: Mutexes and rw_locks use GCC atomic builtins
200528 20:47:34 InnoDB: Compressed tables use zlib 1.2.7
200528 20:47:34 InnoDB: Using Linux native AIO
200528 20:47:34 InnoDB: Initializing buffer pool, size = 8.0G
200528 20:47:35 InnoDB: Completed initialization of buffer pool
200528 20:47:35 InnoDB: highest supported file format is Barracuda.
200528 20:47:36 InnoDB: Waiting for the background threads to start
200528 20:47:37 Percona XtraDB (http://www.percona.com) 5.5.61-MariaDB-38.13 started; log sequence number 2782470
200528 20:47:37 [Note] Plugin 'FEEDBACK' is disabled.
200528 20:47:37 [Note] Server socket created on IP: '0.0.0.0'.
200528 20:47:37 [Note] Event Scheduler: Loaded 0 events
200528 20:47:37 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.65-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server
200529 3:55:10 [Warning] IP address '45.93.83.211' could not be resolved: Name or service not known
200529 18:16:14 [Note] /usr/libexec/mysqld: Normal shutdown
200529 18:16:14 [Note] Event Scheduler: Purging the queue. 0 events
200529 18:16:14 InnoDB: Starting shutdown...
200529 18:16:17 InnoDB: Shutdown completed; log sequence number 28276485
200529 18:16:17 [Note] /usr/libexec/mysqld: Shutdown complete