## 5.6.36 release build [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.6.36/mysql-test: ./mtr 86607 Logging: ./mtr 86607 2017-06-12 07:30:44 0 [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path. 2017-06-12 07:30:44 0 [Note] /export/umesh/server/binaries/GABuilds/mysql-5.6.36/bin/mysqld (mysqld 5.6.36) starting as process 5857 ... 2017-06-12 07:30:44 5857 [Note] Plugin 'FEDERATED' is disabled. 2017-06-12 07:30:44 5857 [Note] Binlog end 2017-06-12 07:30:44 5857 [Note] Shutting down plugin 'CSV' 2017-06-12 07:30:44 5857 [Note] Shutting down plugin 'MyISAM' MySQL Version 5.6.36 Checking supported features... - SSL connections supported Collecting tests... Checking leftover processes... Removing old var directory... Creating var directory '/export/umesh/server/binaries/GABuilds/mysql-5.6.36/mysql-test/var'... Installing system database... Using parallel: 1 ============================================================================== TEST RESULT TIME (ms) or COMMENT -------------------------------------------------------------------------- worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009 set global table_definition_cache=400; set global table_open_cache= 1024; use test; create table t_bug(id int primary key, col1 int) engine=innodb; insert into t_bug values(1, 2); insert into t_bug values(2, 2); commit; alter table t_bug add unique key(col1); use test; select * from t_bug; id col1 1 2 2 2 insert into t_bug values(3, 2); commit; ERROR 23000: Duplicate entry '2' for key 'col1' select sleep(10); sleep(10) 0 flush tables; main.86607 [ fail ] Test ended at 2017-06-12 07:31:02 CURRENT_TEST: main.86607 mysqltest: At line 59: query 'select sleep(10)' failed: 2013: Lost connection to MySQL server during query Server [mysqld.1 - pid: 5882, winpid: 5882, exit: 256] failed during test run Server log from this test: ----------SERVER LOG START----------- 2017-06-12 08:30:47 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2017-06-12 08:30:47 0 [Warning] Insecure configuration for --secure-file-priv: Data directory is accessible through --secure-file-priv. Consider choosing a different directory. 2017-06-12 08:30:47 0 [Warning] Insecure configuration for --secure-file-priv: Location is accessible to all OS users. Consider choosing a different directory. 2017-06-12 08:30:47 0 [Note] /export/umesh/server/binaries/GABuilds/mysql-5.6.36/bin/mysqld (mysqld 5.6.36-log) starting as process 5883 ... 2017-06-12 08:30:47 5883 [Note] Plugin 'FEDERATED' is disabled. 2017-06-12 08:30:47 7f1cbd53d740 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator. 2017-06-12 08:30:47 5883 [Note] InnoDB: Using atomics to ref count buffer pool pages 2017-06-12 08:30:47 5883 [Note] InnoDB: The InnoDB memory heap is disabled 2017-06-12 08:30:47 5883 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-06-12 08:30:47 5883 [Note] InnoDB: Memory barrier is not used 2017-06-12 08:30:47 5883 [Note] InnoDB: Compressed tables use zlib 1.2.3 2017-06-12 08:30:47 5883 [Note] InnoDB: Using Linux native AIO 2017-06-12 08:30:47 5883 [Note] InnoDB: Using CPU crc32 instructions 2017-06-12 08:30:47 5883 [Note] InnoDB: Initializing buffer pool, size = 8.0M 2017-06-12 08:30:47 5883 [Note] InnoDB: Completed initialization of buffer pool 2017-06-12 08:30:47 5883 [Note] InnoDB: Highest supported file format is Barracuda. 2017-06-12 08:30:47 5883 [Note] InnoDB: 128 rollback segment(s) are active. 2017-06-12 08:30:47 5883 [Note] InnoDB: Waiting for purge to start 2017-06-12 08:30:47 5883 [Note] InnoDB: 5.6.36 started; log sequence number 1625977 2017-06-12 08:30:47 5883 [Warning] /export/umesh/server/binaries/GABuilds/mysql-5.6.36/bin/mysqld: unknown variable 'loose-debug-sync-timeout=600' 2017-06-12 08:30:47 5883 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 49aaced0-4f30-11e7-9c91-0010e05f3e06. 2017-06-12 08:30:47 5883 [Note] Server hostname (bind-address): '*'; port: 13000 2017-06-12 08:30:47 5883 [Note] IPv6 is available. 2017-06-12 08:30:47 5883 [Note] - '::' resolves to '::'; 2017-06-12 08:30:47 5883 [Note] Server socket created on IP: '::'. 2017-06-12 08:30:47 5883 [Note] Event Scheduler: Loaded 0 events 2017-06-12 08:30:47 5883 [Note] /export/umesh/server/binaries/GABuilds/mysql-5.6.36/bin/mysqld: ready for connections. Version: '5.6.36-log' socket: '/export/umesh/server/binaries/GABuilds/mysql-5.6.36/mysql-test/var/tmp/mysqld.1.sock' port: 13000 MySQL Community Server (GPL) 05:31:02 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=1048576 read_buffer_size=131072 max_used_connections=3 max_threads=151 thread_count=2 connection_count=2 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 60940 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 = 0 thread_stack 0x40000 /export/umesh/server/binaries/GABuilds/mysql-5.6.36/bin/mysqld(my_print_stacktrace+0x35)[0x9133a5] /export/umesh/server/binaries/GABuilds/mysql-5.6.36/bin/mysqld(handle_fatal_signal+0x3d8)[0x676458] /lib64/libpthread.so.0(+0xf130)[0x7f1cbd137130] /export/umesh/server/binaries/GABuilds/mysql-5.6.36/bin/mysqld[0xa3a7fd] /export/umesh/server/binaries/GABuilds/mysql-5.6.36/bin/mysqld[0xadef98] /export/umesh/server/binaries/GABuilds/mysql-5.6.36/bin/mysqld[0xadf1ed] /export/umesh/server/binaries/GABuilds/mysql-5.6.36/bin/mysqld[0xa67568] /export/umesh/server/binaries/GABuilds/mysql-5.6.36/bin/mysqld[0xa67bee] /lib64/libpthread.so.0(+0x7df5)[0x7f1cbd12fdf5] /lib64/libc.so.6(clone+0x6d)[0x7f1cbbdfb60d] 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. Writing a core file ----------SERVER LOG END------------- - saving '/export/umesh/server/binaries/GABuilds/mysql-5.6.36/mysql-test/var/log/main.86607/' to '/export/umesh/server/binaries/GABuilds/mysql-5.6.36/mysql-test/var/log/main.86607/' - found 'core.5883' (0/5) Trying 'dbx' to get a backtrace Trying 'gdb' to get a backtrace Core generated by '/export/umesh/server/binaries/GABuilds/mysql-5.6.36/bin/mysqld' Output from gdb follows. The first stack trace is from the failing thread. The following stack traces are from all threads (so the failing one is duplicated). -------------------------- [New LWP 5894] [New LWP 5906] [New LWP 5895] [New LWP 5886] [New LWP 5887] [New LWP 5898] [New LWP 5896] [New LWP 5897] [New LWP 5893] [New LWP 5899] [New LWP 5885] [New LWP 5900] [New LWP 5884] [New LWP 5903] [New LWP 5888] [New LWP 5907] [New LWP 5883] [New LWP 5889] [New LWP 5891] [New LWP 5892] [Thread debugging using libthread_db enabled] Using host libthread_db library "/lib64/libthread_db.so.1". Core was generated by `/export/umesh/server/binaries/GABuilds/mysql-5.6.36/bin/mysqld --defaults-group'. Program terminated with signal 11, Segmentation fault. #0 0x00007f1cbd134771 in pthread_kill () from /lib64/libpthread.so.0 #0 0x00007f1cbd134771 in pthread_kill () from /lib64/libpthread.so.0 #1 0x000000000067647a in handle_fatal_signal (sig=11) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/sql/signal_handler.cc:230 #2 #3 row_merge_drop_indexes (trx=0x7f1cac000a38, table=0x7f1c8400af58, locked=) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/row/row0merge.cc:2999 #4 0x0000000000adef98 in dict_table_remove_from_cache_low (table=0x7f1c8400af58, lru_evict=1) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/dict/dict0dict.cc:2105 #5 0x0000000000adf1ed in dict_make_room_in_cache (max_tables=400, pct_check=) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/dict/dict0dict.cc:1444 #6 0x0000000000a67568 in srv_master_evict_from_table_cache (pct_check=100) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/srv/srv0srv.cc:2012 #7 0x0000000000a67bee in srv_master_do_idle_tasks () at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/srv/srv0srv.cc:2207 #8 srv_master_thread (arg=) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/srv/srv0srv.cc:2357 #9 0x00007f1cbd12fdf5 in start_thread () from /lib64/libpthread.so.0 #10 0x00007f1cbbdfb60d in clone () from /lib64/libc.so.6 Thread 20 (Thread 0x7f1cb1c20700 (LWP 5892)): #0 0x00007f1cbd133ab2 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000a0611b in os_cond_wait_timed (abstime=, fast_mutex=, cond=) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/os/os0sync.cc:177 #2 os_event_wait_time_low (event=0x1c5e050, time_in_usec=, reset_sig_count=1) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/os/os0sync.cc:705 #3 0x0000000000a696ad in srv_error_monitor_thread (arg=) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/srv/srv0srv.cc:1772 #4 0x00007f1cbd12fdf5 in start_thread () from /lib64/libpthread.so.0 #5 0x00007f1cbbdfb60d in clone () from /lib64/libc.so.6 Thread 19 (Thread 0x7f1cb2621700 (LWP 5891)): #0 0x00007f1cbd133ab2 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000a0611b in os_cond_wait_timed (abstime=, fast_mutex=, cond=) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/os/os0sync.cc:177 #2 os_event_wait_time_low (event=0x1d48a70, time_in_usec=, reset_sig_count=1) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/os/os0sync.cc:705 #3 0x00000000009edba3 in lock_wait_timeout_thread (arg=) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/lock/lock0wait.cc:503 #4 0x00007f1cbd12fdf5 in start_thread () from /lib64/libpthread.so.0 #5 0x00007f1cbbdfb60d in clone () from /lib64/libc.so.6 Thread 18 (Thread 0x7f1cb3e4b700 (LWP 5889)): #0 0x00007f1cbcf26644 in __io_getevents_0_4 () from /lib64/libaio.so.1 #1 0x0000000000a030db in os_aio_linux_collect (seg_size=, segment=, array=) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/os/os0file.cc:4970 #2 os_aio_linux_handle (global_seg=5, message1=0x7f1cb3e4aec8, message2=0x7f1cb3e4aec0, type=0x7f1cb3e4aeb8) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/os/os0file.cc:5114 #3 0x0000000000b0dfe2 in fil_aio_wait (segment=5) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/fil/fil0fil.cc:5811 #4 0x0000000000a6bdb8 in io_handler_thread (arg=) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/srv/srv0start.cc:495 #5 0x00007f1cbd12fdf5 in start_thread () from /lib64/libpthread.so.0 #6 0x00007f1cbbdfb60d in clone () from /lib64/libc.so.6 Thread 17 (Thread 0x7f1cbd53d740 (LWP 5883)): #0 0x00007f1cbbdf100d in poll () from /lib64/libc.so.6 #1 0x000000000058150a in handle_connections_sockets () at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/sql/mysqld.cc:6311 #2 0x0000000000588287 in mysqld_main (argc=79, argv=0x1b365d8) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/sql/mysqld.cc:5728 #3 0x00007f1cbbd26af5 in __libc_start_main () from /lib64/libc.so.6 #4 0x000000000057b5a9 in _start () Thread 16 (Thread 0x7f1cb3387700 (LWP 5907)): #0 0x00007f1cbd133705 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000582d5b in block_until_new_connection () at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/include/mysql/psi/mysql_thread.h:1151 #2 one_thread_per_connection_end (thd=, block_pthread=) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/sql/mysqld.cc:2794 #3 0x00000000006c76d2 in do_handle_one_connection (thd_arg=0x1ecc960) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/sql/sql_connect.cc:989 #4 0x00000000006c7825 in handle_one_connection (arg=0x1ecc960) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/sql/sql_connect.cc:899 #5 0x00000000009a2236 in pfs_spawn_thread (arg=) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/perfschema/pfs.cc:1860 #6 0x00007f1cbd12fdf5 in start_thread () from /lib64/libpthread.so.0 #7 0x00007f1cbbdfb60d in clone () from /lib64/libc.so.6 Thread 15 (Thread 0x7f1cb484c700 (LWP 5888)): #0 0x00007f1cbcf26644 in __io_getevents_0_4 () from /lib64/libaio.so.1 #1 0x0000000000a030db in os_aio_linux_collect (seg_size=, segment=, array=) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/os/os0file.cc:4970 #2 os_aio_linux_handle (global_seg=4, message1=0x7f1cb484bec8, message2=0x7f1cb484bec0, type=0x7f1cb484beb8) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/os/os0file.cc:5114 #3 0x0000000000b0dfe2 in fil_aio_wait (segment=4) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/fil/fil0fil.cc:5811 #4 0x0000000000a6bdb8 in io_handler_thread (arg=) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/srv/srv0start.cc:495 #5 0x00007f1cbd12fdf5 in start_thread () from /lib64/libpthread.so.0 #6 0x00007f1cbbdfb60d in clone () from /lib64/libc.so.6 Thread 14 (Thread 0x7f1cb3409700 (LWP 5903)): #0 0x00007f1cbbdf100d in poll () from /lib64/libc.so.6 #1 0x0000000000b899f7 in vio_io_wait (vio=, event=, timeout=28800000) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/vio/viosocket.c:771 #2 0x0000000000b89ae3 in vio_socket_io_wait (vio=0x7f1cb3408ca0, event=VIO_IO_EVENT_WRITE) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/vio/viosocket.c:68 #3 0x0000000000b89cfc in vio_read (vio=0x1eba430, buf=0x1ec0650 "\a", size=4) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/vio/viosocket.c:123 #4 0x000000000066c1d2 in net_read_raw_loop (net=0x1defd38, count=4) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/sql/net_serv.cc:667 #5 0x000000000066c2b9 in net_read_packet_header (net=0x1defd38) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/sql/net_serv.cc:749 #6 0x000000000066cdd8 in net_read_packet (complen=, net=) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/sql/net_serv.cc:814 #7 my_net_read (net=0x7f1cb3408ca0) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/sql/net_serv.cc:892 #8 0x0000000000700bc0 in do_command (thd=0x1defb20) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/sql/sql_parse.cc:972 #9 0x00000000006c7746 in do_handle_one_connection (thd_arg=0x1defb20) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/sql/sql_connect.cc:982 #10 0x00000000006c7825 in handle_one_connection (arg=0x1defb20) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/sql/sql_connect.cc:899 #11 0x00000000009a2236 in pfs_spawn_thread (arg=) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/perfschema/pfs.cc:1860 #12 0x00007f1cbd12fdf5 in start_thread () from /lib64/libpthread.so.0 #13 0x00007f1cbbdfb60d in clone () from /lib64/libc.so.6 Thread 13 (Thread 0x7f1cb7050700 (LWP 5884)): #0 0x00007f1cbcf26644 in __io_getevents_0_4 () from /lib64/libaio.so.1 #1 0x0000000000a030db in os_aio_linux_collect (seg_size=, segment=, array=) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/os/os0file.cc:4970 #2 os_aio_linux_handle (global_seg=0, message1=0x7f1cb704fec8, message2=0x7f1cb704fec0, type=0x7f1cb704feb8) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/os/os0file.cc:5114 #3 0x0000000000b0dfe2 in fil_aio_wait (segment=0) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/fil/fil0fil.cc:5811 #4 0x0000000000a6bdb8 in io_handler_thread (arg=) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/srv/srv0start.cc:495 #5 0x00007f1cbd12fdf5 in start_thread () from /lib64/libpthread.so.0 #6 0x00007f1cbbdfb60d in clone () from /lib64/libc.so.6 Thread 12 (Thread 0x7f1cb344a700 (LWP 5900)): #0 0x00007f1cbd136ec1 in sigwait () from /lib64/libpthread.so.0 #1 0x00000000005826f0 in signal_hand (arg=) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/sql/mysqld.cc:3209 #2 0x00000000009a2236 in pfs_spawn_thread (arg=) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/perfschema/pfs.cc:1860 #3 0x00007f1cbd12fdf5 in start_thread () from /lib64/libpthread.so.0 #4 0x00007f1cbbdfb60d in clone () from /lib64/libc.so.6 Thread 11 (Thread 0x7f1cb664f700 (LWP 5885)): #0 0x00007f1cbcf26644 in __io_getevents_0_4 () from /lib64/libaio.so.1 #1 0x0000000000a030db in os_aio_linux_collect (seg_size=, segment=, array=) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/os/os0file.cc:4970 #2 os_aio_linux_handle (global_seg=1, message1=0x7f1cb664eec8, message2=0x7f1cb664eec0, type=0x7f1cb664eeb8) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/os/os0file.cc:5114 #3 0x0000000000b0dfe2 in fil_aio_wait (segment=1) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/fil/fil0fil.cc:5811 #4 0x0000000000a6bdb8 in io_handler_thread (arg=) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/srv/srv0start.cc:495 #5 0x00007f1cbd12fdf5 in start_thread () from /lib64/libpthread.so.0 #6 0x00007f1cbbdfb60d in clone () from /lib64/libc.so.6 Thread 10 (Thread 0x7f1ca97fb700 (LWP 5899)): #0 0x00007f1cbd133ab2 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000a0611b in os_cond_wait_timed (abstime=, fast_mutex=, cond=) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/os/os0sync.cc:177 #2 os_event_wait_time_low (event=0x1d82b50, time_in_usec=, reset_sig_count=1) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/os/os0sync.cc:705 #3 0x0000000000a92e64 in ib_wqueue_timedwait (wq=0x1d829c8, wait_in_usecs=5000000) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/ut/ut0wqueue.cc:154 #4 0x0000000000b30ed5 in fts_optimize_thread (arg=) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/fts/fts0opt.cc:3059 #5 0x00007f1cbd12fdf5 in start_thread () from /lib64/libpthread.so.0 #6 0x00007f1cbbdfb60d in clone () from /lib64/libc.so.6 Thread 9 (Thread 0x7f1cb121f700 (LWP 5893)): #0 0x00007f1cbd133ab2 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000a0611b in os_cond_wait_timed (abstime=, fast_mutex=, cond=) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/os/os0sync.cc:177 #2 os_event_wait_time_low (event=0x1c5e0e0, time_in_usec=, reset_sig_count=1) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/os/os0sync.cc:705 #3 0x0000000000a6902e in srv_monitor_thread (arg=) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/srv/srv0srv.cc:1539 #4 0x00007f1cbd12fdf5 in start_thread () from /lib64/libpthread.so.0 #5 0x00007f1cbbdfb60d in clone () from /lib64/libc.so.6 Thread 8 (Thread 0x7f1caabfd700 (LWP 5897)): #0 0x00007f1cbd133705 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000a062d2 in os_cond_wait (fast_mutex=, cond=) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/os/os0sync.cc:214 #2 os_event_wait_low (event=0x1c5e170, reset_sig_count=1) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/os/os0sync.cc:592 #3 0x0000000000ac9124 in buf_dump_thread (arg=) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/buf/buf0dump.cc:614 #4 0x00007f1cbd12fdf5 in start_thread () from /lib64/libpthread.so.0 #5 0x00007f1cbbdfb60d in clone () from /lib64/libc.so.6 Thread 7 (Thread 0x7f1cab5fe700 (LWP 5896)): #0 0x00007f1cbbdf2d83 in select () from /lib64/libc.so.6 #1 0x0000000000a064cf in os_thread_sleep (tm=) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/os/os0thread.cc:287 #2 0x0000000000ace15b in page_cleaner_sleep_if_needed (next_loop_time=) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/buf/buf0flu.cc:2375 #3 buf_flush_page_cleaner_thread (arg=) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/buf/buf0flu.cc:2417 #4 0x00007f1cbd12fdf5 in start_thread () from /lib64/libpthread.so.0 #5 0x00007f1cbbdfb60d in clone () from /lib64/libc.so.6 Thread 6 (Thread 0x7f1caa1fc700 (LWP 5898)): #0 0x00007f1cbd133ab2 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000a0611b in os_cond_wait_timed (abstime=, fast_mutex=, cond=) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/os/os0sync.cc:177 #2 os_event_wait_time_low (event=0x1d52e20, time_in_usec=, reset_sig_count=2) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/os/os0sync.cc:705 #3 0x0000000000afd4b4 in dict_stats_thread (arg=) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/dict/dict0stats_bg.cc:349 #4 0x00007f1cbd12fdf5 in start_thread () from /lib64/libpthread.so.0 #5 0x00007f1cbbdfb60d in clone () from /lib64/libc.so.6 Thread 5 (Thread 0x7f1cb524d700 (LWP 5887)): #0 0x00007f1cbcf26644 in __io_getevents_0_4 () from /lib64/libaio.so.1 #1 0x0000000000a030db in os_aio_linux_collect (seg_size=, segment=, array=) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/os/os0file.cc:4970 #2 os_aio_linux_handle (global_seg=3, message1=0x7f1cb524cec8, message2=0x7f1cb524cec0, type=0x7f1cb524ceb8) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/os/os0file.cc:5114 #3 0x0000000000b0dfe2 in fil_aio_wait (segment=3) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/fil/fil0fil.cc:5811 #4 0x0000000000a6bdb8 in io_handler_thread (arg=) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/srv/srv0start.cc:495 #5 0x00007f1cbd12fdf5 in start_thread () from /lib64/libpthread.so.0 #6 0x00007f1cbbdfb60d in clone () from /lib64/libc.so.6 Thread 4 (Thread 0x7f1cb5c4e700 (LWP 5886)): #0 0x00007f1cbcf26644 in __io_getevents_0_4 () from /lib64/libaio.so.1 #1 0x0000000000a030db in os_aio_linux_collect (seg_size=, segment=, array=) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/os/os0file.cc:4970 #2 os_aio_linux_handle (global_seg=2, message1=0x7f1cb5c4dec8, message2=0x7f1cb5c4dec0, type=0x7f1cb5c4deb8) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/os/os0file.cc:5114 #3 0x0000000000b0dfe2 in fil_aio_wait (segment=2) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/fil/fil0fil.cc:5811 #4 0x0000000000a6bdb8 in io_handler_thread (arg=) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/srv/srv0start.cc:495 #5 0x00007f1cbd12fdf5 in start_thread () from /lib64/libpthread.so.0 #6 0x00007f1cbbdfb60d in clone () from /lib64/libc.so.6 Thread 3 (Thread 0x7f1cabfff700 (LWP 5895)): #0 0x00007f1cbd133705 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000a062d2 in os_cond_wait (fast_mutex=, cond=) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/os/os0sync.cc:214 #2 os_event_wait_low (event=0x1c5dfc0, reset_sig_count=3) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/os/os0sync.cc:592 #3 0x0000000000a6aa0d in srv_purge_coordinator_suspend (rseg_history_len=, slot=) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/srv/srv0srv.cc:2643 #4 srv_purge_coordinator_thread (arg=) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/srv/srv0srv.cc:2764 #5 0x00007f1cbd12fdf5 in start_thread () from /lib64/libpthread.so.0 #6 0x00007f1cbbdfb60d in clone () from /lib64/libc.so.6 Thread 2 (Thread 0x7f1cb33c8700 (LWP 5906)): #0 0x00007f1cbd133ab2 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000005f48c2 in inline_mysql_cond_timedwait (src_line=, src_file=, abstime=, mutex=, that=) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/include/mysql/psi/mysql_thread.h:1188 #2 Interruptible_wait::wait (this=0x7f1cb33c5de0, cond=0x7f1cb33c5d70, mutex=0x135b240 ) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/sql/item_func.cc:4262 #3 0x000000000060131f in Item_func_sleep::val_int (this=) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/sql/item_func.cc:4594 #4 0x000000000059cfa1 in Item::send (this=0x7f1c84004d30, protocol=0x1ec4c70, buffer=0x7f1cb33c61b0) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/sql/item.cc:6933 #5 0x0000000000670632 in Protocol::send_result_set_row (this=0x1ec4c70, row_items=) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/sql/protocol.cc:844 #6 0x00000000006ba62c in select_send::send_data (this=0x7f1c84004ed0, items=...) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/sql/sql_class.cc:2541 #7 0x00000000006d2e8c in JOIN::exec (this=0x7f1c84004ef8) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/sql/sql_executor.cc:149 #8 0x000000000071a369 in mysql_execute_select (thd=0x1ec4790, select_lex=0x1ec6c40, free_join=true) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/sql/sql_select.cc:1101 #9 0x000000000071a69c in mysql_select (thd=0x1ec4790, tables=, wild_num=, fields=..., conds=, order=, group=0x1ec6d40, having=0x0, select_options=2147748608, result=0x7f1c84004ed0, unit=0x1ec65f8, select_lex=0x1ec6c40) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/sql/sql_select.cc:1222 #10 0x000000000071a8b4 in handle_select (thd=0x1ec4790, result=0x7f1c84004ed0, setup_tables_done_option=0) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/sql/sql_select.cc:110 #11 0x00000000006f4869 in execute_sqlcom_select (thd=0x1ec4790, all_tables=0x0) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/sql/sql_parse.cc:5182 #12 0x00000000006f9f27 in mysql_execute_command (thd=0x1ec4790) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/sql/sql_parse.cc:2690 #13 0x00000000006fd647 in mysql_parse (thd=0x1ec4790, rawbuf=, length=, parser_state=0x1ec47f8) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/sql/sql_parse.cc:6434 #14 0x00000000006ff76f in dispatch_command (command=COM_QUERY, thd=0x1ec4790, packet=0x1ec8821 "", packet_length=16) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/sql/sql_parse.cc:1372 #15 0x0000000000700c17 in do_command (thd=0x1ec4790) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/sql/sql_parse.cc:1039 #16 0x00000000006c7746 in do_handle_one_connection (thd_arg=0x1ec4790) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/sql/sql_connect.cc:982 #17 0x00000000006c7825 in handle_one_connection (arg=0x1ec4790) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/sql/sql_connect.cc:899 #18 0x00000000009a2236 in pfs_spawn_thread (arg=) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/perfschema/pfs.cc:1860 #19 0x00007f1cbd12fdf5 in start_thread () from /lib64/libpthread.so.0 #20 0x00007f1cbbdfb60d in clone () from /lib64/libc.so.6 Thread 1 (Thread 0x7f1cb3022700 (LWP 5894)): #0 0x00007f1cbd134771 in pthread_kill () from /lib64/libpthread.so.0 #1 0x000000000067647a in handle_fatal_signal (sig=11) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/sql/signal_handler.cc:230 #2 #3 row_merge_drop_indexes (trx=0x7f1cac000a38, table=0x7f1c8400af58, locked=) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/row/row0merge.cc:2999 #4 0x0000000000adef98 in dict_table_remove_from_cache_low (table=0x7f1c8400af58, lru_evict=1) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/dict/dict0dict.cc:2105 #5 0x0000000000adf1ed in dict_make_room_in_cache (max_tables=400, pct_check=) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/dict/dict0dict.cc:1444 #6 0x0000000000a67568 in srv_master_evict_from_table_cache (pct_check=100) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/srv/srv0srv.cc:2012 #7 0x0000000000a67bee in srv_master_do_idle_tasks () at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/srv/srv0srv.cc:2207 #8 srv_master_thread (arg=) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/srv/srv0srv.cc:2357 #9 0x00007f1cbd12fdf5 in start_thread () from /lib64/libpthread.so.0 #10 0x00007f1cbbdfb60d in clone () from /lib64/libc.so.6 -------------------------------------------------------------------------- The servers were restarted 0 times Spent 0.000 of 20 seconds executing testcases Completed: Failed 1/1 tests, 0.00% were successful. Failing test(s): main.86607 The log files in var/log may give you some hint of what went wrong. If you want to report this error, please read first the documentation at http://dev.mysql.com/doc/mysql/en/mysql-test-suite.html mysql-test-run: *** ERROR: there were failing test cases [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.6.36/mysql-test ## Debug build [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.6.36/mysql-test: ./mtr --debug 86607 [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.6.36/mysql-test: ./mtr --debug 86607 Logging: ./mtr --debug 86607 2017-06-12 07:34:26 0 [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path. 2017-06-12 07:34:26 0 [Note] /export/umesh/server/binaries/GABuilds/mysql-5.6.36/bin/mysqld-debug (mysqld 5.6.36-debug) starting as process 5941 ... 2017-06-12 07:34:26 5941 [Note] Plugin 'FEDERATED' is disabled. 2017-06-12 07:34:26 5941 [Note] Binlog end 2017-06-12 07:34:26 5941 [Note] Shutting down plugin 'CSV' 2017-06-12 07:34:26 5941 [Note] Shutting down plugin 'MyISAM' MySQL Version 5.6.36 Checking supported features... - SSL connections supported - binaries are debug compiled Collecting tests... Checking leftover processes... Removing old var directory... Creating var directory '/export/umesh/server/binaries/GABuilds/mysql-5.6.36/mysql-test/var'... Installing system database... Using parallel: 1 ============================================================================== TEST RESULT TIME (ms) or COMMENT -------------------------------------------------------------------------- worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009 set global table_definition_cache=400; set global table_open_cache= 1024; use test; create table t_bug(id int primary key, col1 int) engine=innodb; insert into t_bug values(1, 2); insert into t_bug values(2, 2); commit; alter table t_bug add unique key(col1); use test; select * from t_bug; id col1 1 2 2 2 insert into t_bug values(3, 2); commit; ERROR 23000: Duplicate entry '2' for key 'col1' select sleep(10); sleep(10) 0 flush tables; main.86607 [ fail ] Test ended at 2017-06-12 07:35:00 CURRENT_TEST: main.86607 /export/umesh/server/binaries/GABuilds/mysql-5.6.36/bin/mysqltest: WARNING: Option 'debug=d:t:A,/export/umesh/server/binaries/GABuilds/mysql-5.6.36/mysql-test/var/log/mysqltest.trace' used, but is disabled mysqltest: At line 59: query 'select sleep(10)' failed: 2013: Lost connection to MySQL server during query Server [mysqld.1 - pid: 5966, winpid: 5966, exit: 256] failed during test run Server log from this test: ----------SERVER LOG START----------- 2017-06-12 08:34:34 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2017-06-12 08:34:34 0 [Warning] Insecure configuration for --secure-file-priv: Data directory is accessible through --secure-file-priv. Consider choosing a different directory. 2017-06-12 08:34:34 0 [Warning] Insecure configuration for --secure-file-priv: Location is accessible to all OS users. Consider choosing a different directory. 2017-06-12 08:34:34 0 [Note] /export/umesh/server/binaries/GABuilds/mysql-5.6.36/bin/mysqld-debug (mysqld 5.6.36-debug-log) starting as process 5967 ... 2017-06-12 08:34:34 5967 [Note] Plugin 'FEDERATED' is disabled. 2017-06-12 08:34:34 7f1c47efc740 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator. 2017-06-12 08:34:34 5967 [Note] InnoDB: Using atomics to ref count buffer pool pages 2017-06-12 08:34:34 7f1c47efc740 InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! 2017-06-12 08:34:34 7f1c47efc740 InnoDB: !!!!!!!! UNIV_SYNC_DEBUG switched on !!!!!!!!! 2017-06-12 08:34:34 5967 [Note] InnoDB: The InnoDB memory heap is disabled 2017-06-12 08:34:34 5967 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-06-12 08:34:34 5967 [Note] InnoDB: Memory barrier is not used 2017-06-12 08:34:34 5967 [Note] InnoDB: Compressed tables use zlib 1.2.3 2017-06-12 08:34:34 5967 [Note] InnoDB: Using Linux native AIO 2017-06-12 08:34:34 5967 [Note] InnoDB: Using CPU crc32 instructions 2017-06-12 08:34:34 5967 [Note] InnoDB: Initializing buffer pool, size = 8.0M 2017-06-12 08:34:34 5967 [Note] InnoDB: Completed initialization of buffer pool 2017-06-12 08:34:34 5967 [Note] InnoDB: Highest supported file format is Barracuda. 2017-06-12 08:34:35 5967 [Note] InnoDB: 128 rollback segment(s) are active. 2017-06-12 08:34:35 5967 [Note] InnoDB: Waiting for purge to start 2017-06-12 08:34:35 5967 [Note] InnoDB: 5.6.36 started; log sequence number 1625977 2017-06-12 08:34:35 5967 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: d1ae2b00-4f30-11e7-9c94-0010e05f3e06. 2017-06-12 08:34:35 5967 [Note] Server hostname (bind-address): '*'; port: 13000 2017-06-12 08:34:35 5967 [Note] IPv6 is available. 2017-06-12 08:34:35 5967 [Note] - '::' resolves to '::'; 2017-06-12 08:34:35 5967 [Note] Server socket created on IP: '::'. 2017-06-12 08:34:35 5967 [Note] Event Scheduler: Loaded 0 events 2017-06-12 08:34:35 5967 [Note] /export/umesh/server/binaries/GABuilds/mysql-5.6.36/bin/mysqld-debug: ready for connections. Version: '5.6.36-debug-log' socket: '/export/umesh/server/binaries/GABuilds/mysql-5.6.36/mysql-test/var/tmp/mysqld.1.sock' port: 13000 MySQL Community Server - Debug (GPL) 2017-06-12 08:35:00 7f1c375fe700 InnoDB: Assertion failure in thread 139759164843776 in file dict0dict.ic line 269 InnoDB: Failing assertion: index InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html InnoDB: about forcing recovery. 05:35:00 UTC - mysqld got signal 6 ; 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=1048576 read_buffer_size=131072 max_used_connections=3 max_threads=151 thread_count=2 connection_count=2 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 60945 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 = 0 thread_stack 0x40000 /export/umesh/server/binaries/GABuilds/mysql-5.6.36/bin/mysqld-debug(my_print_stacktrace+0x32)[0xab78f0] /export/umesh/server/binaries/GABuilds/mysql-5.6.36/bin/mysqld-debug(handle_fatal_signal+0x47a)[0x718b4e] /lib64/libpthread.so.0(+0xf130)[0x7f1c47af6130] /lib64/libc.so.6(gsignal+0x37)[0x7f1c466f95d7] /lib64/libc.so.6(abort+0x148)[0x7f1c466facc8] /export/umesh/server/binaries/GABuilds/mysql-5.6.36/bin/mysqld-debug[0xc6daca] /export/umesh/server/binaries/GABuilds/mysql-5.6.36/bin/mysqld-debug[0xc72ce1] /export/umesh/server/binaries/GABuilds/mysql-5.6.36/bin/mysqld-debug[0xd7cb20] /export/umesh/server/binaries/GABuilds/mysql-5.6.36/bin/mysqld-debug[0xd7e833] /export/umesh/server/binaries/GABuilds/mysql-5.6.36/bin/mysqld-debug[0xcc6e79] /export/umesh/server/binaries/GABuilds/mysql-5.6.36/bin/mysqld-debug[0xcc7434] /export/umesh/server/binaries/GABuilds/mysql-5.6.36/bin/mysqld-debug[0xcc793c] /lib64/libpthread.so.0(+0x7df5)[0x7f1c47aeedf5] /lib64/libc.so.6(clone+0x6d)[0x7f1c467ba60d] 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. Writing a core file ----------SERVER LOG END------------- - saving '/export/umesh/server/binaries/GABuilds/mysql-5.6.36/mysql-test/var/log/main.86607/' to '/export/umesh/server/binaries/GABuilds/mysql-5.6.36/mysql-test/var/log/main.86607/' - found 'core.5967' (0/5) Trying 'dbx' to get a backtrace Trying 'gdb' to get a backtrace Core generated by '/export/umesh/server/binaries/GABuilds/mysql-5.6.36/bin/mysqld-debug' Output from gdb follows. The first stack trace is from the failing thread. The following stack traces are from all threads (so the failing one is duplicated). -------------------------- [New LWP 5979] [New LWP 5992] [New LWP 5981] [New LWP 5982] [New LWP 5978] [New LWP 5976] [New LWP 5991] [New LWP 5970] [New LWP 5967] [New LWP 5980] [New LWP 5977] [New LWP 5969] [New LWP 5985] [New LWP 5973] [New LWP 5983] [New LWP 5984] [New LWP 5968] [New LWP 5971] [New LWP 5972] [New LWP 5988] [Thread debugging using libthread_db enabled] Using host libthread_db library "/lib64/libthread_db.so.1". Core was generated by `/export/umesh/server/binaries/GABuilds/mysql-5.6.36/bin/mysqld-debug --defaults'. Program terminated with signal 6, Aborted. #0 0x00007f1c47af3771 in pthread_kill () from /lib64/libpthread.so.0 #0 0x00007f1c47af3771 in pthread_kill () from /lib64/libpthread.so.0 #1 0x0000000000ab7963 in my_write_core (sig=6) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/mysys/stacktrace.c:424 #2 0x0000000000718d4e in handle_fatal_signal (sig=6) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/sql/signal_handler.cc:230 #3 #4 0x00007f1c466f95d7 in raise () from /lib64/libc.so.6 #5 0x00007f1c466facc8 in abort () from /lib64/libc.so.6 #6 0x0000000000c6daca in dict_index_is_clust (index=0x0) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/include/dict0dict.ic:269 #7 0x0000000000c72ce1 in row_merge_drop_indexes (trx=0x7f1c30027c08, table=0x7f1c04032748, locked=1) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/row/row0merge.cc:2881 #8 0x0000000000d7cb20 in dict_table_remove_from_cache_low (table=0x7f1c04032748, lru_evict=1) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/dict/dict0dict.cc:2105 #9 0x0000000000d7e833 in dict_make_room_in_cache (max_tables=400, pct_check=100) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/dict/dict0dict.cc:1444 #10 0x0000000000cc6e79 in srv_master_evict_from_table_cache (pct_check=100) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/srv/srv0srv.cc:2012 #11 0x0000000000cc7434 in srv_master_do_idle_tasks () at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/srv/srv0srv.cc:2207 #12 0x0000000000cc793c in srv_master_thread (arg=0x0) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/srv/srv0srv.cc:2357 #13 0x00007f1c47aeedf5 in start_thread () from /lib64/libpthread.so.0 #14 0x00007f1c467ba60d in clone () from /lib64/libc.so.6 Thread 20 (Thread 0x7f1c3dda0700 (LWP 5988)): #0 0x00007f1c467b000d in poll () from /lib64/libc.so.6 #1 0x0000000000e591af in vio_io_wait (vio=0x2e46920, event=VIO_IO_EVENT_READ, timeout=28800000) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/vio/viosocket.c:771 #2 0x0000000000e57a98 in vio_socket_io_wait (vio=0x2e46920, event=VIO_IO_EVENT_READ) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/vio/viosocket.c:68 #3 0x0000000000e57b73 in vio_read (vio=0x2e46920, buf=0x2e46b10 "\a", size=4) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/vio/viosocket.c:123 #4 0x000000000070a70a in net_read_raw_loop (net=0x2d79040, count=4) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/sql/net_serv.cc:667 #5 0x000000000070a8c3 in net_read_packet_header (net=0x2d79040) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/sql/net_serv.cc:749 #6 0x000000000070b6a7 in net_read_packet (net=0x2d79040, complen=0x7f1c3dd9fd78) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/sql/net_serv.cc:814 #7 0x000000000070b824 in my_net_read (net=0x2d79040) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/sql/net_serv.cc:892 #8 0x00000000007d97ff in do_command (thd=0x2d78e30) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/sql/sql_parse.cc:972 #9 0x000000000078e40f in do_handle_one_connection (thd_arg=0x2d78e30) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/sql/sql_connect.cc:982 #10 0x000000000078e4d5 in handle_one_connection (arg=0x2d78e30) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/sql/sql_connect.cc:899 #11 0x0000000000b8a858 in pfs_spawn_thread (arg=0x2cc7790) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/perfschema/pfs.cc:1860 #12 0x00007f1c47aeedf5 in start_thread () from /lib64/libpthread.so.0 #13 0x00007f1c467ba60d in clone () from /lib64/libc.so.6 Thread 19 (Thread 0x7f1c3f1e3700 (LWP 5972)): #0 0x00007f1c478e5644 in __io_getevents_0_4 () from /lib64/libaio.so.1 #1 0x0000000000c10d60 in os_aio_linux_collect (array=0x2be7770, segment=0, seg_size=256) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/os/os0file.cc:4970 #2 0x0000000000c114d0 in os_aio_linux_handle (global_seg=4, message1=0x7f1c3f1e2ed0, message2=0x7f1c3f1e2ec8, type=0x7f1c3f1e2ec0) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/os/os0file.cc:5114 #3 0x0000000000da24f7 in fil_aio_wait (segment=4) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/fil/fil0fil.cc:5811 #4 0x0000000000cd0068 in io_handler_thread (arg=0x1816840 ) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/srv/srv0start.cc:495 #5 0x00007f1c47aeedf5 in start_thread () from /lib64/libpthread.so.0 #6 0x00007f1c467ba60d in clone () from /lib64/libc.so.6 Thread 18 (Thread 0x7f1c3fbe4700 (LWP 5971)): #0 0x00007f1c478e5644 in __io_getevents_0_4 () from /lib64/libaio.so.1 #1 0x0000000000c10d60 in os_aio_linux_collect (array=0x2b8c720, segment=1, seg_size=256) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/os/os0file.cc:4970 #2 0x0000000000c114d0 in os_aio_linux_handle (global_seg=3, message1=0x7f1c3fbe3ed0, message2=0x7f1c3fbe3ec8, type=0x7f1c3fbe3ec0) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/os/os0file.cc:5114 #3 0x0000000000da24f7 in fil_aio_wait (segment=3) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/fil/fil0fil.cc:5811 #4 0x0000000000cd0068 in io_handler_thread (arg=0x1816838 ) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/srv/srv0start.cc:495 #5 0x00007f1c47aeedf5 in start_thread () from /lib64/libpthread.so.0 #6 0x00007f1c467ba60d in clone () from /lib64/libc.so.6 Thread 17 (Thread 0x7f1c419e7700 (LWP 5968)): #0 0x00007f1c478e5644 in __io_getevents_0_4 () from /lib64/libaio.so.1 #1 0x0000000000c10d60 in os_aio_linux_collect (array=0x2bd9cb0, segment=0, seg_size=256) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/os/os0file.cc:4970 #2 0x0000000000c114d0 in os_aio_linux_handle (global_seg=0, message1=0x7f1c419e6ed0, message2=0x7f1c419e6ec8, type=0x7f1c419e6ec0) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/os/os0file.cc:5114 #3 0x0000000000da24f7 in fil_aio_wait (segment=0) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/fil/fil0fil.cc:5811 #4 0x0000000000cd0068 in io_handler_thread (arg=0x1816820 ) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/srv/srv0start.cc:495 #5 0x00007f1c47aeedf5 in start_thread () from /lib64/libpthread.so.0 #6 0x00007f1c467ba60d in clone () from /lib64/libc.so.6 Thread 16 (Thread 0x7f1c1bfff700 (LWP 5984)): #0 0x00007f1c47af2ab2 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000c16d5b in os_cond_wait_timed (cond=0x2cc3210, fast_mutex=0x2cc31d0, abstime=0x7f1c1bffee10) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/os/os0sync.cc:177 #2 0x0000000000c16f7e in os_event_wait_time_low (event=0x2cc31d0, time_in_usec=5000000, reset_sig_count=1) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/os/os0sync.cc:705 #3 0x0000000000d05a46 in ib_wqueue_timedwait (wq=0x2ccae98, wait_in_usecs=5000000) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/ut/ut0wqueue.cc:154 #4 0x0000000000dd459c in fts_optimize_thread (arg=0x2ccae98) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/fts/fts0opt.cc:3059 #5 0x00007f1c47aeedf5 in start_thread () from /lib64/libpthread.so.0 #6 0x00007f1c467ba60d in clone () from /lib64/libc.so.6 Thread 15 (Thread 0x7f1c34dfa700 (LWP 5983)): #0 0x00007f1c47af2ab2 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000c16d5b in os_cond_wait_timed (cond=0x2cafbc0, fast_mutex=0x2cafb80, abstime=0x7f1c34df9ed0) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/os/os0sync.cc:177 #2 0x0000000000c16f7e in os_event_wait_time_low (event=0x2cafb80, time_in_usec=10000000, reset_sig_count=2) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/os/os0sync.cc:705 #3 0x0000000000d99cb4 in dict_stats_thread (arg=0x0) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/dict/dict0stats_bg.cc:349 #4 0x00007f1c47aeedf5 in start_thread () from /lib64/libpthread.so.0 #5 0x00007f1c467ba60d in clone () from /lib64/libc.so.6 Thread 14 (Thread 0x7f1c3e7e2700 (LWP 5973)): #0 0x00007f1c478e5644 in __io_getevents_0_4 () from /lib64/libaio.so.1 #1 0x0000000000c10d60 in os_aio_linux_collect (array=0x2be7770, segment=1, seg_size=256) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/os/os0file.cc:4970 #2 0x0000000000c114d0 in os_aio_linux_handle (global_seg=5, message1=0x7f1c3e7e1ed0, message2=0x7f1c3e7e1ec8, type=0x7f1c3e7e1ec0) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/os/os0file.cc:5114 #3 0x0000000000da24f7 in fil_aio_wait (segment=5) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/fil/fil0fil.cc:5811 #4 0x0000000000cd0068 in io_handler_thread (arg=0x1816848 ) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/srv/srv0start.cc:495 #5 0x00007f1c47aeedf5 in start_thread () from /lib64/libpthread.so.0 #6 0x00007f1c467ba60d in clone () from /lib64/libc.so.6 Thread 13 (Thread 0x7f1c3dde1700 (LWP 5985)): #0 0x00007f1c47af5ec1 in sigwait () from /lib64/libpthread.so.0 #1 0x00000000006042ec in signal_hand (arg=0x0) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/sql/mysqld.cc:3209 #2 0x0000000000b8a858 in pfs_spawn_thread (arg=0x2cc5570) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/perfschema/pfs.cc:1860 #3 0x00007f1c47aeedf5 in start_thread () from /lib64/libpthread.so.0 #4 0x00007f1c467ba60d in clone () from /lib64/libc.so.6 Thread 12 (Thread 0x7f1c40fe6700 (LWP 5969)): #0 0x00007f1c478e5644 in __io_getevents_0_4 () from /lib64/libaio.so.1 #1 0x0000000000c10d60 in os_aio_linux_collect (array=0x2bcc210, segment=0, seg_size=256) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/os/os0file.cc:4970 #2 0x0000000000c114d0 in os_aio_linux_handle (global_seg=1, message1=0x7f1c40fe5ed0, message2=0x7f1c40fe5ec8, type=0x7f1c40fe5ec0) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/os/os0file.cc:5114 #3 0x0000000000da24f7 in fil_aio_wait (segment=1) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/fil/fil0fil.cc:5811 #4 0x0000000000cd0068 in io_handler_thread (arg=0x1816828 ) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/srv/srv0start.cc:495 #5 0x00007f1c47aeedf5 in start_thread () from /lib64/libpthread.so.0 #6 0x00007f1c467ba60d in clone () from /lib64/libc.so.6 Thread 11 (Thread 0x7f1c3cfb8700 (LWP 5977)): #0 0x00007f1c47af2ab2 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000c16d5b in os_cond_wait_timed (cond=0x2b8e280, fast_mutex=0x2b8e240, abstime=0x7f1c3cfb7e70) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/os/os0sync.cc:177 #2 0x0000000000c16f7e in os_event_wait_time_low (event=0x2b8e240, time_in_usec=1000000, reset_sig_count=1) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/os/os0sync.cc:705 #3 0x0000000000cc7d3b in srv_error_monitor_thread (arg=0x0) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/srv/srv0srv.cc:1772 #4 0x00007f1c47aeedf5 in start_thread () from /lib64/libpthread.so.0 #5 0x00007f1c467ba60d in clone () from /lib64/libc.so.6 Thread 10 (Thread 0x7f1c36bfd700 (LWP 5980)): #0 0x00007f1c47af2705 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000c1701f in os_cond_wait (cond=0x2b8e1f0, fast_mutex=0x2b8e1b0) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/os/os0sync.cc:214 #2 0x0000000000c17093 in os_event_wait_low (event=0x2b8e1b0, reset_sig_count=3) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/os/os0sync.cc:592 #3 0x0000000000cc6263 in srv_purge_coordinator_suspend (slot=0x2b8c6e0, rseg_history_len=3) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/srv/srv0srv.cc:2643 #4 0x0000000000cc6730 in srv_purge_coordinator_thread (arg=0x0) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/srv/srv0srv.cc:2764 #5 0x00007f1c47aeedf5 in start_thread () from /lib64/libpthread.so.0 #6 0x00007f1c467ba60d in clone () from /lib64/libc.so.6 Thread 9 (Thread 0x7f1c47efc740 (LWP 5967)): #0 0x00007f1c467b000d in poll () from /lib64/libc.so.6 #1 0x0000000000605449 in handle_connections_sockets () at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/sql/mysqld.cc:6311 #2 0x000000000060be04 in mysqld_main (argc=80, argv=0x2a64688) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/sql/mysqld.cc:5728 #3 0x00000000005fb353 in main (argc=10, argv=0x7ffe8647b8f8) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/sql/main.cc:25 Thread 8 (Thread 0x7f1c405e5700 (LWP 5970)): #0 0x00007f1c478e5644 in __io_getevents_0_4 () from /lib64/libaio.so.1 #1 0x0000000000c10d60 in os_aio_linux_collect (array=0x2b8c720, segment=0, seg_size=256) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/os/os0file.cc:4970 #2 0x0000000000c114d0 in os_aio_linux_handle (global_seg=2, message1=0x7f1c405e4ed0, message2=0x7f1c405e4ec8, type=0x7f1c405e4ec0) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/os/os0file.cc:5114 #3 0x0000000000da24f7 in fil_aio_wait (segment=2) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/fil/fil0fil.cc:5811 #4 0x0000000000cd0068 in io_handler_thread (arg=0x1816830 ) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/srv/srv0start.cc:495 #5 0x00007f1c47aeedf5 in start_thread () from /lib64/libpthread.so.0 #6 0x00007f1c467ba60d in clone () from /lib64/libc.so.6 Thread 7 (Thread 0x7f1c3dd5f700 (LWP 5991)): #0 0x00007f1c47af2ab2 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000000000069c4f1 in inline_mysql_cond_timedwait (that=0x7f1c3dd5c490, mutex=0x17dcfe0 , abstime=0x7f1c3dd5c410, src_file=0xed4548 "/export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/sql/item_func.cc", src_line=4262) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/include/mysql/psi/mysql_thread.h:1188 #2 0x000000000069c6ce in Interruptible_wait::wait (this=0x7f1c3dd5c4d0, cond=0x7f1c3dd5c490, mutex=0x17dcfe0 ) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/sql/item_func.cc:4262 #3 0x000000000069c967 in Item_func_sleep::val_int (this=0x7f1c04004db0) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/sql/item_func.cc:4594 #4 0x0000000000635204 in Item::send (this=0x7f1c04004db0, protocol=0x2e4b128, buffer=0x7f1c3dd5c950) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/sql/item.cc:6933 #5 0x000000000070fde0 in Protocol::send_result_set_row (this=0x2e4b128, row_items=0x2e4d240) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/sql/protocol.cc:844 #6 0x00000000007836ad in select_send::send_data (this=0x7f1c04004f50, items=...) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/sql/sql_class.cc:2541 #7 0x00000000007a3f88 in JOIN::exec (this=0x7f1c04004f78) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/sql/sql_executor.cc:149 #8 0x000000000080711c in mysql_execute_select (thd=0x2e4ac50, select_lex=0x2e4d120, free_join=true) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/sql/sql_select.cc:1101 #9 0x0000000000807adb in mysql_select (thd=0x2e4ac50, tables=0x0, wild_num=0, fields=..., conds=0x0, order=0x2e4d2e8, group=0x2e4d220, having=0x0, select_options=2147748608, result=0x7f1c04004f50, unit=0x2e4cad8, select_lex=0x2e4d120) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/sql/sql_select.cc:1222 #10 0x0000000000807cd7 in handle_select (thd=0x2e4ac50, result=0x7f1c04004f50, setup_tables_done_option=0) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/sql/sql_select.cc:110 #11 0x00000000007cd8be in execute_sqlcom_select (thd=0x2e4ac50, all_tables=0x0) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/sql/sql_parse.cc:5182 #12 0x00000000007cedd5 in mysql_execute_command (thd=0x2e4ac50) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/sql/sql_parse.cc:2690 #13 0x00000000007d64da in mysql_parse (thd=0x2e4ac50, rawbuf=0x7f1c04004c30 "select sleep(10)", length=16, parser_state=0x7f1c3dd5e6f0) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/sql/sql_parse.cc:6434 #14 0x00000000007d8188 in dispatch_command (command=COM_QUERY, thd=0x2e4ac50, packet=0x2e4ebf1 "", packet_length=16) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/sql/sql_parse.cc:1372 #15 0x00000000007d9a4f in do_command (thd=0x2e4ac50) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/sql/sql_parse.cc:1039 #16 0x000000000078e40f in do_handle_one_connection (thd_arg=0x2e4ac50) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/sql/sql_connect.cc:982 #17 0x000000000078e4d5 in handle_one_connection (arg=0x2e4ac50) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/sql/sql_connect.cc:899 #18 0x0000000000b8a858 in pfs_spawn_thread (arg=0x2ccdc00) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/perfschema/pfs.cc:1860 #19 0x00007f1c47aeedf5 in start_thread () from /lib64/libpthread.so.0 #20 0x00007f1c467ba60d in clone () from /lib64/libc.so.6 Thread 6 (Thread 0x7f1c3d9b9700 (LWP 5976)): #0 0x00007f1c47af2ab2 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000c16d5b in os_cond_wait_timed (cond=0x2ca55d0, fast_mutex=0x2ca5590, abstime=0x7f1c3d9b8eb0) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/os/os0sync.cc:177 #2 0x0000000000c16f7e in os_event_wait_time_low (event=0x2ca5590, time_in_usec=1000000, reset_sig_count=1) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/os/os0sync.cc:705 #3 0x0000000000bf68ae in lock_wait_timeout_thread (arg=0x0) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/lock/lock0wait.cc:503 #4 0x00007f1c47aeedf5 in start_thread () from /lib64/libpthread.so.0 #5 0x00007f1c467ba60d in clone () from /lib64/libc.so.6 Thread 5 (Thread 0x7f1c37fff700 (LWP 5978)): #0 0x00007f1c47af2ab2 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000c16d5b in os_cond_wait_timed (cond=0x2b8e310, fast_mutex=0x2b8e2d0, abstime=0x7f1c37ffee80) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/os/os0sync.cc:177 #2 0x0000000000c16f7e in os_event_wait_time_low (event=0x2b8e2d0, time_in_usec=5000000, reset_sig_count=1) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/os/os0sync.cc:705 #3 0x0000000000cc8e95 in srv_monitor_thread (arg=0x0) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/srv/srv0srv.cc:1539 #4 0x00007f1c47aeedf5 in start_thread () from /lib64/libpthread.so.0 #5 0x00007f1c467ba60d in clone () from /lib64/libc.so.6 Thread 4 (Thread 0x7f1c357fb700 (LWP 5982)): #0 0x00007f1c47af2705 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000c1701f in os_cond_wait (cond=0x2b8e3a0, fast_mutex=0x2b8e360) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/os/os0sync.cc:214 #2 0x0000000000c17093 in os_event_wait_low (event=0x2b8e360, reset_sig_count=1) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/os/os0sync.cc:592 #3 0x0000000000d50d95 in buf_dump_thread (arg=0x0) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/buf/buf0dump.cc:614 #4 0x00007f1c47aeedf5 in start_thread () from /lib64/libpthread.so.0 #5 0x00007f1c467ba60d in clone () from /lib64/libc.so.6 Thread 3 (Thread 0x7f1c361fc700 (LWP 5981)): #0 0x00007f1c467b1d83 in select () from /lib64/libc.so.6 #1 0x0000000000c17884 in os_thread_sleep (tm=1000000) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/os/os0thread.cc:287 #2 0x0000000000d52d27 in page_cleaner_sleep_if_needed (next_loop_time=1497245700746) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/buf/buf0flu.cc:2375 #3 0x0000000000d56eca in buf_flush_page_cleaner_thread (arg=0x0) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/buf/buf0flu.cc:2417 #4 0x00007f1c47aeedf5 in start_thread () from /lib64/libpthread.so.0 #5 0x00007f1c467ba60d in clone () from /lib64/libc.so.6 Thread 2 (Thread 0x7f1c3dd1e700 (LWP 5992)): #0 0x00007f1c47af2705 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000000000060149a in inline_mysql_cond_wait (that=0x17dbfa0 , mutex=0x17d9940 , src_file=0xebac70 "/export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/sql/mysqld.cc", src_line=2706) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/include/mysql/psi/mysql_thread.h:1151 #2 0x000000000060c8ab in block_until_new_connection () at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/sql/mysqld.cc:2706 #3 0x000000000060cb68 in one_thread_per_connection_end (thd=0x2e52d30, block_pthread=true) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/sql/mysqld.cc:2794 #4 0x000000000078e472 in do_handle_one_connection (thd_arg=0x2e52d30) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/sql/sql_connect.cc:989 #5 0x000000000078e4d5 in handle_one_connection (arg=0x2e52d30) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/sql/sql_connect.cc:899 #6 0x0000000000b8a858 in pfs_spawn_thread (arg=0x2e0fbc0) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/perfschema/pfs.cc:1860 #7 0x00007f1c47aeedf5 in start_thread () from /lib64/libpthread.so.0 #8 0x00007f1c467ba60d in clone () from /lib64/libc.so.6 Thread 1 (Thread 0x7f1c375fe700 (LWP 5979)): #0 0x00007f1c47af3771 in pthread_kill () from /lib64/libpthread.so.0 #1 0x0000000000ab7963 in my_write_core (sig=6) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/mysys/stacktrace.c:424 #2 0x0000000000718d4e in handle_fatal_signal (sig=6) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/sql/signal_handler.cc:230 #3 #4 0x00007f1c466f95d7 in raise () from /lib64/libc.so.6 #5 0x00007f1c466facc8 in abort () from /lib64/libc.so.6 #6 0x0000000000c6daca in dict_index_is_clust (index=0x0) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/include/dict0dict.ic:269 #7 0x0000000000c72ce1 in row_merge_drop_indexes (trx=0x7f1c30027c08, table=0x7f1c04032748, locked=1) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/row/row0merge.cc:2881 #8 0x0000000000d7cb20 in dict_table_remove_from_cache_low (table=0x7f1c04032748, lru_evict=1) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/dict/dict0dict.cc:2105 #9 0x0000000000d7e833 in dict_make_room_in_cache (max_tables=400, pct_check=100) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/dict/dict0dict.cc:1444 #10 0x0000000000cc6e79 in srv_master_evict_from_table_cache (pct_check=100) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/srv/srv0srv.cc:2012 #11 0x0000000000cc7434 in srv_master_do_idle_tasks () at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/srv/srv0srv.cc:2207 #12 0x0000000000cc793c in srv_master_thread (arg=0x0) at /export/home/pb2/build/sb_0-22757681-1489820628.27/mysql-5.6.36/storage/innobase/srv/srv0srv.cc:2357 #13 0x00007f1c47aeedf5 in start_thread () from /lib64/libpthread.so.0 #14 0x00007f1c467ba60d in clone () from /lib64/libc.so.6 -------------------------------------------------------------------------- The servers were restarted 0 times Spent 0.000 of 36 seconds executing testcases Completed: Failed 1/1 tests, 0.00% were successful. Failing test(s): main.86607 The log files in var/log may give you some hint of what went wrong. If you want to report this error, please read first the documentation at http://dev.mysql.com/doc/mysql/en/mysql-test-suite.html mysql-test-run: *** ERROR: there were failing test cases [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.6.36/mysql-test: