Description:
when I manually shutdown mysql instance (compiled from source distribution), get the following error message in the error file.
2016-06-03 17:14:05 2014 [Note] /usr/local/onesql5631/bin/mysqld: Shutdown complete
09:14:05 UTC - mysqld got signal 11 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help
diagnose the problem, but since we have already crashed,
something is definitely wrong and this may fail.
key_buffer_size=171013648
read_buffer_size=131072
max_used_connections=0
max_threads=151
thread_count=0
connection_count=0
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 226858 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...
160603 17:14:05 mysqld_safe mysqld from pid file /data/mysqldata/mysql.pid ended
How to repeat:
service mysqld start
service mysqld stop
check the errof file.
Suggested fix:
debug with gdb I found the following trace info.
[root@rh4srv1 mysqldata]# gdb /usr/local/onesql5631/bin/mysqld
GNU gdb Fedora (6.8-37.el5)
Copyright (C) 2008 Free Software Foundation, Inc.
License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html>
This is free software: you are free to change and redistribute it.
There is NO WARRANTY, to the extent permitted by law. Type "show copying"
and "show warranty" for details.
This GDB was configured as "x86_64-redhat-linux-gnu"...
(gdb) r --basedir=/usr/local/onesql5631 --datadir=/data/mysqldata --plugin-dir=/usr/local/onesql5631/lib/plugin --user=mysql --log-error=/data/mysqldata/rh4srv1.err --pid-file=/data/mysqldata/mysql.pid
Starting program: /usr/local/onesql5631/bin/mysqld --basedir=/usr/local/onesql5631 --datadir=/data/mysqldata --plugin-dir=/usr/local/onesql5631/lib/plugin --user=mysql --log-error=/data/mysqldata/rh4srv1.err --pid-file=/data/mysqldata/mysql.pid
[Thread debugging using libthread_db enabled]
2016-06-03 17:22:12 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2016-06-03 17:22:12 0 [Note] /usr/local/onesql5631/bin/mysqld (mysqld 5.6.31) starting as process 2359 ...
[New Thread 0x2b236d9fee10 (LWP 2359)]
[New Thread 0x41f97940 (LWP 2362)]
[New Thread 0x42998940 (LWP 2363)]
[New Thread 0x43399940 (LWP 2364)]
[New Thread 0x43d9a940 (LWP 2366)]
[New Thread 0x4479b940 (LWP 2368)]
[New Thread 0x4519c940 (LWP 2369)]
[New Thread 0x45b9d940 (LWP 2370)]
[New Thread 0x4659e940 (LWP 2371)]
[New Thread 0x46f9f940 (LWP 2372)]
[New Thread 0x479a0940 (LWP 2373)]
[New Thread 0x41387940 (LWP 2374)]
[New Thread 0x483a1940 (LWP 2375)]
[New Thread 0x48da2940 (LWP 2376)]
[New Thread 0x497a3940 (LWP 2377)]
[New Thread 0x4a1a4940 (LWP 2378)]
[New Thread 0x4aba5940 (LWP 2379)]
[Thread 0x41387940 (LWP 2374) exited]
[New Thread 0x41387940 (LWP 2380)]
[New Thread 0x4b5a6940 (LWP 2381)]
[New Thread 0x4bfa7940 (LWP 2382)]
[New Thread 0x4c9a8940 (LWP 2383)]
[New Thread 0x413c8940 (LWP 2384)]
[New Thread 0x41409940 (LWP 2386)]
[New Thread 0x4144a940 (LWP 2387)]
[Thread 0x41409940 (LWP 2386) exited]
[Thread 0x4c9a8940 (LWP 2383) exited]
[Thread 0x48da2940 (LWP 2376) exited]
[Thread 0x497a3940 (LWP 2377) exited]
[Thread 0x4b5a6940 (LWP 2381) exited]
[Thread 0x483a1940 (LWP 2375) exited]
[Thread 0x4bfa7940 (LWP 2382) exited]
[Thread 0x4aba5940 (LWP 2379) exited]
[Thread 0x41387940 (LWP 2380) exited]
[Thread 0x43399940 (LWP 2364) exited]
[Thread 0x4a1a4940 (LWP 2378) exited]
[Thread 0x479a0940 (LWP 2373) exited]
[Thread 0x4659e940 (LWP 2371) exited]
[Thread 0x4479b940 (LWP 2368) exited]
[Thread 0x46f9f940 (LWP 2372) exited]
[Thread 0x43d9a940 (LWP 2366) exited]
[Thread 0x42998940 (LWP 2363) exited]
[Thread 0x4519c940 (LWP 2369) exited]
[Thread 0x41f97940 (LWP 2362) exited]
[Thread 0x45b9d940 (LWP 2370) exited]
Program received signal SIGSEGV, Segmentation fault.
[Switching to Thread 0x4144a940 (LWP 2387)]
0x0000003765a075c8 in ?? () from /lib64/libgcc_s.so.1
(gdb) where
#0 0x0000003765a075c8 in ?? () from /lib64/libgcc_s.so.1
#1 0x0000003765a0897e in ?? () from /lib64/libgcc_s.so.1
#2 0x0000003765a08d8b in _Unwind_ForcedUnwind () from /lib64/libgcc_s.so.1
#3 0x0000003763a0ce10 in __pthread_unwind () from /lib64/libpthread.so.0
#4 0x0000003763a07635 in pthread_exit () from /lib64/libpthread.so.0
#5 0x0000000000555c5a in unireg_end () at /data/mysql-5.6.31/sql/mysqld.cc:1775
#6 0x0000000000558c7d in kill_server () at /data/mysql-5.6.31/sql/mysqld.cc:1698
#7 0x0000000000041000 in ?? ()
#8 0x000000000089b8ea in my_thread_init () at /data/mysql-5.6.31/include/mysql/psi/mysql_thread.h:762
#9 0x0000000000000000 in ?? ()
problems on
void unireg_end(void)
{
clean_up(1);
my_thread_end();
#if defined(SIGNALS_DONT_BREAK_READ)
exit(0);
#else
pthread_exit(0); // Exit is in main thread
#endif
}
call of pthread_exit(0) on main thread caused signal 11 on RHEL 5
