Bug#51391 - Deadlock involving events during rqg_info_schema test Solaris SPARC 32-bit, 2010-02-22. Stacktraces from all threads, generated by dbx. # 03:09:27 t@1 (l@1) terminated by signal SEGV (Segmentation Fault) # 03:09:27 0xfee4c714: __lwp_kill+0x0008: bcc,a,pt %icc,__lwp_kill+0x18 ! 0xfee4c724 # 03:09:27 Current function is my_write_core # 03:09:27 current thread: t@1 # 03:09:27 [1] __lwp_kill(0x0, 0xb, 0xfeeb5800, 0x4, 0xff2d2a00, 0xb), at 0xfee4c714 # 03:09:27 =>[2] my_write_core(sig = 11), line 326 in "stacktrace.c" # 03:09:27 [3] handle_segfault(sig = 11), line 2745 in "mysqld.cc" # 03:09:27 [4] __sighndlr(0xb, 0x0, 0xffbfbea0, 0x326b40, 0x0, 0x0), at 0xfee48b4c # 03:09:27 ---- called from signal handler with signal 11 (SIGSEGV) ------ # 03:09:27 [5] __lwp_park(0x4, 0x0, 0x0, 0x0, 0xff36e000, 0x1), at 0xfee48ac4 # 03:09:27 [6] mutex_lock_queue(0xff2d2a00, 0x0, 0x14e6588, 0x0, 0x1c00, 0x1d3c), at 0xfee40df4 # 03:09:27 [7] safe_mutex_lock(mp = 0x14e6570, try_lock = '\0', file = 0x107bf56 "sql_class.cc", line = 892U), line 152 in "thr_mutex.c" # 03:09:27 [8] THD::init(this = 0x332dc90), line 892 in "sql_class.cc" # 03:09:27 [9] THD::THD(this = 0x332dc90), line 553 in "sql_class.cc" # 03:09:27 [10] handle_connections_sockets(), line 5553 in "mysqld.cc" # 03:09:27 [11] main(argc = 45, argv = 0x150a070), line 4860 in "mysqld.cc" # 03:09:27 current thread: t@1 # 03:09:27 [1] __lwp_kill(0x0, 0xb, 0xfeeb5800, 0x4, 0xff2d2a00, 0xb), at 0xfee4c714 # 03:09:27 =>[2] my_write_core(sig = 11), line 326 in "stacktrace.c" # 03:09:27 [3] handle_segfault(sig = 11), line 2745 in "mysqld.cc" # 03:09:27 [4] __sighndlr(0xb, 0x0, 0xffbfbea0, 0x326b40, 0x0, 0x0), at 0xfee48b4c # 03:09:27 ---- called from signal handler with signal 11 (SIGSEGV) ------ # 03:09:27 [5] __lwp_park(0x4, 0x0, 0x0, 0x0, 0xff36e000, 0x1), at 0xfee48ac4 # 03:09:27 [6] mutex_lock_queue(0xff2d2a00, 0x0, 0x14e6588, 0x0, 0x1c00, 0x1d3c), at 0xfee40df4 # 03:09:27 [7] safe_mutex_lock(mp = 0x14e6570, try_lock = '\0', file = 0x107bf56 "sql_class.cc", line = 892U), line 152 in "thr_mutex.c" # 03:09:27 [8] THD::init(this = 0x332dc90), line 892 in "sql_class.cc" # 03:09:27 [9] THD::THD(this = 0x332dc90), line 553 in "sql_class.cc" # 03:09:27 [10] handle_connections_sockets(), line 5553 in "mysqld.cc" # 03:09:27 [11] main(argc = 45, argv = 0x150a070), line 4860 in "mysqld.cc" # 03:09:27 current thread: t@2 # 03:09:27 =>[1] __lwp_park(0x4, 0x0, 0x0, 0x0, 0xff36e010, 0x1), at 0xfee48ac4 # 03:09:27 [2] cond_sleep_queue(0x0, 0x1ac39c0, 0x0, 0x0, 0x6dbb0, 0x0), at 0xfee42910 # 03:09:27 [3] cond_wait_queue(0x1ac39f8, 0x1ac39c0, 0x0, 0x0, 0x1c00, 0x0), at 0xfee42ad4 # 03:09:27 [4] cond_wait(0x1ac39f8, 0x1ac39c0, 0x0, 0x1c00, 0xfed20200, 0x1ac39a8), at 0xfee4301c # 03:09:27 [5] _pthread_cond_wait(0x1ac39f8, 0x1ac39c0, 0xfeeb5800, 0x0, 0xfed20200, 0x0), at 0xfee43058 # 03:09:27 [6] safe_cond_wait(cond = 0x1ac39f8, mp = 0x1ac39a8, file = 0x114ad8c "os/os0sync.c", line = 399U), line 240 in "thr_mutex.c" # 03:09:27 [7] os_event_wait_low(event = 0x1ac39a8, reset_sig_count = 0), line 399 in "os0sync.c" # 03:09:27 [8] os_aio_simulated_handle(global_segment = 0, message1 = 0xfecfbf28, message2 = 0xfecfbf24, type = 0xfecfbf20), line 4197 in "os0file.c" # 03:09:27 [9] fil_aio_wait(segment = 0), line 4451 in "fil0fil.c" # 03:09:27 [10] io_handler_thread(arg = 0x14e1010), line 492 in "srv0start.c" # 03:09:27 current thread: t@3 # 03:09:27 =>[1] __lwp_park(0x4, 0x0, 0x0, 0x0, 0xff36e020, 0x1), at 0xfee48ac4 # 03:09:27 [2] cond_sleep_queue(0x0, 0x1ac3a30, 0x0, 0x0, 0x6dbb0, 0x0), at 0xfee42910 # 03:09:27 [3] cond_wait_queue(0x1ac3a68, 0x1ac3a30, 0x0, 0x0, 0x1c00, 0x0), at 0xfee42ad4 # 03:09:27 [4] cond_wait(0x1ac3a68, 0x1ac3a30, 0x0, 0x1c00, 0xfed20a00, 0x1ac3a18), at 0xfee4301c # 03:09:27 [5] _pthread_cond_wait(0x1ac3a68, 0x1ac3a30, 0xfeeb5800, 0x0, 0xfed20a00, 0x0), at 0xfee43058 # 03:09:27 [6] safe_cond_wait(cond = 0x1ac3a68, mp = 0x1ac3a18, file = 0x114ad8c "os/os0sync.c", line = 399U), line 240 in "thr_mutex.c" # 03:09:27 [7] os_event_wait_low(event = 0x1ac3a18, reset_sig_count = 0), line 399 in "os0sync.c" # 03:09:27 [8] os_aio_simulated_handle(global_segment = 1U, message1 = 0xfebfbf28, message2 = 0xfebfbf24, type = 0xfebfbf20), line 4197 in "os0file.c" # 03:09:27 [9] fil_aio_wait(segment = 1U), line 4451 in "fil0fil.c" # 03:09:27 [10] io_handler_thread(arg = 0x14e1014), line 492 in "srv0start.c" # 03:09:27 current thread: t@4 # 03:09:27 =>[1] __lwp_park(0x4, 0x0, 0x0, 0x0, 0xff36e090, 0x1), at 0xfee48ac4 # 03:09:27 [2] cond_sleep_queue(0x0, 0x1ac3aa0, 0x0, 0x0, 0x6dbb0, 0x0), at 0xfee42910 # 03:09:27 [3] cond_wait_queue(0x1ac3ad8, 0x1ac3aa0, 0x0, 0x0, 0x1c00, 0x0), at 0xfee42ad4 # 03:09:27 [4] cond_wait(0x1ac3ad8, 0x1ac3aa0, 0x0, 0x1c00, 0xfed21200, 0x1ac3a88), at 0xfee4301c # 03:09:27 [5] _pthread_cond_wait(0x1ac3ad8, 0x1ac3aa0, 0xfeeb5800, 0x0, 0xfed21200, 0x0), at 0xfee43058 # 03:09:27 [6] safe_cond_wait(cond = 0x1ac3ad8, mp = 0x1ac3a88, file = 0x114ad8c "os/os0sync.c", line = 399U), line 240 in "thr_mutex.c" # 03:09:27 [7] os_event_wait_low(event = 0x1ac3a88, reset_sig_count = 0), line 399 in "os0sync.c" # 03:09:27 [8] os_aio_simulated_handle(global_segment = 2U, message1 = 0xfeafbf28, message2 = 0xfeafbf24, type = 0xfeafbf20), line 4197 in "os0file.c" # 03:09:27 [9] fil_aio_wait(segment = 2U), line 4451 in "fil0fil.c" # 03:09:27 [10] io_handler_thread(arg = 0x14e1018), line 492 in "srv0start.c" # 03:09:27 current thread: t@5 # 03:09:27 =>[1] __lwp_park(0x4, 0x0, 0x0, 0x0, 0xff36e030, 0x1), at 0xfee48ac4 # 03:09:27 [2] cond_sleep_queue(0x0, 0x1ac3b10, 0x0, 0x0, 0x6dbb0, 0x0), at 0xfee42910 # 03:09:27 [3] cond_wait_queue(0x1ac3b48, 0x1ac3b10, 0x0, 0x0, 0x1c00, 0x0), at 0xfee42ad4 # 03:09:27 [4] cond_wait(0x1ac3b48, 0x1ac3b10, 0x0, 0x1c00, 0xfed21a00, 0x1ac3af8), at 0xfee4301c # 03:09:27 [5] _pthread_cond_wait(0x1ac3b48, 0x1ac3b10, 0xfeeb5800, 0x0, 0xfed21a00, 0x0), at 0xfee43058 # 03:09:27 [6] safe_cond_wait(cond = 0x1ac3b48, mp = 0x1ac3af8, file = 0x114ad8c "os/os0sync.c", line = 399U), line 240 in "thr_mutex.c" # 03:09:27 [7] os_event_wait_low(event = 0x1ac3af8, reset_sig_count = 0), line 399 in "os0sync.c" # 03:09:27 [8] os_aio_simulated_handle(global_segment = 3U, message1 = 0xf67fbf28, message2 = 0xf67fbf24, type = 0xf67fbf20), line 4197 in "os0file.c" # 03:09:27 [9] fil_aio_wait(segment = 3U), line 4451 in "fil0fil.c" # 03:09:27 [10] io_handler_thread(arg = 0x14e101c), line 492 in "srv0start.c" # 03:09:27 current thread: t@6 # 03:09:27 =>[1] __lwp_park(0x4, 0x0, 0x0, 0x0, 0xff36e040, 0x1), at 0xfee48ac4 # 03:09:27 [2] cond_sleep_queue(0x0, 0x1ac3b80, 0x0, 0x0, 0x6dbb0, 0x0), at 0xfee42910 # 03:09:27 [3] cond_wait_queue(0x1ac3bb8, 0x1ac3b80, 0x0, 0x0, 0x1c00, 0x0), at 0xfee42ad4 # 03:09:27 [4] cond_wait(0x1ac3bb8, 0x1ac3b80, 0x0, 0x1c00, 0xfed22200, 0x1ac3b68), at 0xfee4301c # 03:09:27 [5] _pthread_cond_wait(0x1ac3bb8, 0x1ac3b80, 0xfeeb5800, 0x0, 0xfed22200, 0x0), at 0xfee43058 # 03:09:27 [6] safe_cond_wait(cond = 0x1ac3bb8, mp = 0x1ac3b68, file = 0x114ad8c "os/os0sync.c", line = 399U), line 240 in "thr_mutex.c" # 03:09:27 [7] os_event_wait_low(event = 0x1ac3b68, reset_sig_count = 0), line 399 in "os0sync.c" # 03:09:27 [8] os_aio_simulated_handle(global_segment = 4U, message1 = 0xf66fbf28, message2 = 0xf66fbf24, type = 0xf66fbf20), line 4197 in "os0file.c" # 03:09:27 [9] fil_aio_wait(segment = 4U), line 4451 in "fil0fil.c" # 03:09:27 [10] io_handler_thread(arg = 0x14e1020), line 492 in "srv0start.c" # 03:09:27 current thread: t@7 # 03:09:27 =>[1] __lwp_park(0x4, 0x0, 0x0, 0x0, 0xff36e050, 0x1), at 0xfee48ac4 # 03:09:27 [2] cond_sleep_queue(0x0, 0x1ac3bf0, 0x0, 0x0, 0x6dbb0, 0x0), at 0xfee42910 # 03:09:27 [3] cond_wait_queue(0x1ac3c28, 0x1ac3bf0, 0x0, 0x0, 0x1c00, 0x0), at 0xfee42ad4 # 03:09:27 [4] cond_wait(0x1ac3c28, 0x1ac3bf0, 0x0, 0x1c00, 0xfed22a00, 0x1ac3bd8), at 0xfee4301c # 03:09:27 [5] _pthread_cond_wait(0x1ac3c28, 0x1ac3bf0, 0xfeeb5800, 0x0, 0xfed22a00, 0x0), at 0xfee43058 # 03:09:27 [6] safe_cond_wait(cond = 0x1ac3c28, mp = 0x1ac3bd8, file = 0x114ad8c "os/os0sync.c", line = 399U), line 240 in "thr_mutex.c" # 03:09:27 [7] os_event_wait_low(event = 0x1ac3bd8, reset_sig_count = 0), line 399 in "os0sync.c" # 03:09:27 [8] os_aio_simulated_handle(global_segment = 5U, message1 = 0xf65fbf28, message2 = 0xf65fbf24, type = 0xf65fbf20), line 4197 in "os0file.c" # 03:09:27 [9] fil_aio_wait(segment = 5U), line 4451 in "fil0fil.c" # 03:09:27 [10] io_handler_thread(arg = 0x14e1024), line 492 in "srv0start.c" # 03:09:27 current thread: t@8 # 03:09:27 =>[1] __lwp_park(0x4, 0x0, 0x0, 0x0, 0xff36e060, 0x1), at 0xfee48ac4 # 03:09:27 [2] cond_sleep_queue(0x0, 0x1ac3c60, 0x0, 0x0, 0x6dbb0, 0x0), at 0xfee42910 # 03:09:27 [3] cond_wait_queue(0x1ac3c98, 0x1ac3c60, 0x0, 0x0, 0x1c00, 0x0), at 0xfee42ad4 # 03:09:27 [4] cond_wait(0x1ac3c98, 0x1ac3c60, 0x0, 0x1c00, 0xfed23200, 0x1ac3c48), at 0xfee4301c # 03:09:27 [5] _pthread_cond_wait(0x1ac3c98, 0x1ac3c60, 0xfeeb5800, 0x0, 0xfed23200, 0x0), at 0xfee43058 # 03:09:27 [6] safe_cond_wait(cond = 0x1ac3c98, mp = 0x1ac3c48, file = 0x114ad8c "os/os0sync.c", line = 399U), line 240 in "thr_mutex.c" # 03:09:27 [7] os_event_wait_low(event = 0x1ac3c48, reset_sig_count = 0), line 399 in "os0sync.c" # 03:09:27 [8] os_aio_simulated_handle(global_segment = 6U, message1 = 0xf64fbf28, message2 = 0xf64fbf24, type = 0xf64fbf20), line 4197 in "os0file.c" # 03:09:27 [9] fil_aio_wait(segment = 6U), line 4451 in "fil0fil.c" # 03:09:27 [10] io_handler_thread(arg = 0x14e1028), line 492 in "srv0start.c" # 03:09:27 current thread: t@9 # 03:09:27 =>[1] __lwp_park(0x4, 0x0, 0x0, 0x0, 0xff36e0a0, 0x1), at 0xfee48ac4 # 03:09:27 [2] cond_sleep_queue(0x0, 0x1ac3cd0, 0x0, 0x0, 0x6dbb0, 0x0), at 0xfee42910 # 03:09:27 [3] cond_wait_queue(0x1ac3d08, 0x1ac3cd0, 0x0, 0x0, 0x1c00, 0x0), at 0xfee42ad4 # 03:09:27 [4] cond_wait(0x1ac3d08, 0x1ac3cd0, 0x0, 0x1c00, 0xfed23a00, 0x1ac3cb8), at 0xfee4301c # 03:09:27 [5] _pthread_cond_wait(0x1ac3d08, 0x1ac3cd0, 0xfeeb5800, 0x0, 0xfed23a00, 0x0), at 0xfee43058 # 03:09:27 [6] safe_cond_wait(cond = 0x1ac3d08, mp = 0x1ac3cb8, file = 0x114ad8c "os/os0sync.c", line = 399U), line 240 in "thr_mutex.c" # 03:09:27 [7] os_event_wait_low(event = 0x1ac3cb8, reset_sig_count = 0), line 399 in "os0sync.c" # 03:09:27 [8] os_aio_simulated_handle(global_segment = 7U, message1 = 0xf63fbf28, message2 = 0xf63fbf24, type = 0xf63fbf20), line 4197 in "os0file.c" # 03:09:27 [9] fil_aio_wait(segment = 7U), line 4451 in "fil0fil.c" # 03:09:27 [10] io_handler_thread(arg = 0x14e102c), line 492 in "srv0start.c" # 03:09:27 current thread: t@10 # 03:09:27 =>[1] __lwp_park(0x4, 0x0, 0x0, 0x0, 0xff36e070, 0x1), at 0xfee48ac4 # 03:09:27 [2] cond_sleep_queue(0x0, 0x1ac3d40, 0x0, 0x0, 0x6dbb0, 0x0), at 0xfee42910 # 03:09:27 [3] cond_wait_queue(0x1ac3d78, 0x1ac3d40, 0x0, 0x0, 0x1c00, 0x0), at 0xfee42ad4 # 03:09:27 [4] cond_wait(0x1ac3d78, 0x1ac3d40, 0x0, 0x1c00, 0xfed24200, 0x1ac3d28), at 0xfee4301c # 03:09:27 [5] _pthread_cond_wait(0x1ac3d78, 0x1ac3d40, 0xfeeb5800, 0x0, 0xfed24200, 0x0), at 0xfee43058 # 03:09:27 [6] safe_cond_wait(cond = 0x1ac3d78, mp = 0x1ac3d28, file = 0x114ad8c "os/os0sync.c", line = 399U), line 240 in "thr_mutex.c" # 03:09:27 [7] os_event_wait_low(event = 0x1ac3d28, reset_sig_count = 0), line 399 in "os0sync.c" # 03:09:27 [8] os_aio_simulated_handle(global_segment = 8U, message1 = 0xf62fbf28, message2 = 0xf62fbf24, type = 0xf62fbf20), line 4197 in "os0file.c" # 03:09:27 [9] fil_aio_wait(segment = 8U), line 4451 in "fil0fil.c" # 03:09:27 [10] io_handler_thread(arg = 0x14e1030), line 492 in "srv0start.c" # 03:09:27 current thread: t@11 # 03:09:27 =>[1] __lwp_park(0x4, 0x0, 0x0, 0x0, 0xff36e080, 0x1), at 0xfee48ac4 # 03:09:27 [2] cond_sleep_queue(0x0, 0x1ac3db0, 0x0, 0x0, 0x6dbb0, 0x0), at 0xfee42910 # 03:09:27 [3] cond_wait_queue(0x1ac3de8, 0x1ac3db0, 0x0, 0x0, 0x1c00, 0x0), at 0xfee42ad4 # 03:09:27 [4] cond_wait(0x1ac3de8, 0x1ac3db0, 0x0, 0x1c00, 0xfed24a00, 0x1ac3d98), at 0xfee4301c # 03:09:27 [5] _pthread_cond_wait(0x1ac3de8, 0x1ac3db0, 0xfeeb5800, 0x0, 0xfed24a00, 0x0), at 0xfee43058 # 03:09:27 [6] safe_cond_wait(cond = 0x1ac3de8, mp = 0x1ac3d98, file = 0x114ad8c "os/os0sync.c", line = 399U), line 240 in "thr_mutex.c" # 03:09:27 [7] os_event_wait_low(event = 0x1ac3d98, reset_sig_count = 0), line 399 in "os0sync.c" # 03:09:27 [8] os_aio_simulated_handle(global_segment = 9U, message1 = 0xf61fbf28, message2 = 0xf61fbf24, type = 0xf61fbf20), line 4197 in "os0file.c" # 03:09:27 [9] fil_aio_wait(segment = 9U), line 4451 in "fil0fil.c" # 03:09:27 [10] io_handler_thread(arg = 0x14e1034), line 492 in "srv0start.c" # 03:09:27 current thread: t@12 # 03:09:27 =>[1] __pollsys(0x4, 0x0, 0xf60fbe88, 0x0, 0x0, 0x0), at 0xfee4c2f0 # 03:09:27 [2] _pollsys(0xf60fbe20, 0x0, 0xf60fbe88, 0x0, 0x0, 0x0), at 0xfee3bfcc # 03:09:27 [3] _pselect(0xf60fbe20, 0xfeeb4630, 0xfeeb4630, 0x0, 0xf60fbe88, 0x0), at 0xfede7c00 # 03:09:27 [4] _select(0x0, 0x0, 0x0, 0x0, 0xf60fbef0, 0x0), at 0xfede7f78 # 03:09:27 [5] os_thread_sleep(tm = 1000000U), line 281 in "os0thread.c" # 03:09:27 [6] srv_lock_timeout_and_monitor_thread(arg = (nil)), line 1984 in "srv0srv.c" # 03:09:27 current thread: t@13 # 03:09:27 =>[1] __pollsys(0x4, 0x0, 0xf5ffbeb8, 0x0, 0x0, 0x0), at 0xfee4c2f0 # 03:09:27 [2] _pollsys(0xf5ffbe50, 0x0, 0xf5ffbeb8, 0x0, 0x0, 0x0), at 0xfee3bfcc # 03:09:27 [3] _pselect(0xf5ffbe50, 0xfeeb4630, 0xfeeb4630, 0x0, 0xf5ffbeb8, 0x0), at 0xfede7c00 # 03:09:27 [4] _select(0x0, 0x0, 0x0, 0x0, 0xf5ffbf20, 0x0), at 0xfede7f78 # 03:09:27 [5] os_thread_sleep(tm = 1000000U), line 281 in "os0thread.c" # 03:09:27 [6] srv_error_monitor_thread(arg = (nil)), line 2220 in "srv0srv.c" # 03:09:27 current thread: t@14 # 03:09:27 =>[1] __lwp_park(0x4, 0x0, 0x0, 0x0, 0xff36e0d0, 0x1), at 0xfee48ac4 # 03:09:27 [2] cond_sleep_queue(0x0, 0x1634930, 0x0, 0x0, 0x6dbb0, 0x0), at 0xfee42910 # 03:09:27 [3] cond_wait_queue(0x1634968, 0x1634930, 0x0, 0x0, 0x1c00, 0x0), at 0xfee42ad4 # 03:09:27 [4] cond_wait(0x1634968, 0x1634930, 0x0, 0x1c00, 0xfed26200, 0x1634918), at 0xfee4301c # 03:09:27 [5] _pthread_cond_wait(0x1634968, 0x1634930, 0xfeeb5800, 0x0, 0xfed26200, 0x0), at 0xfee43058 # 03:09:27 [6] safe_cond_wait(cond = 0x1634968, mp = 0x1634918, file = 0x114ad8c "os/os0sync.c", line = 399U), line 240 in "thr_mutex.c" # 03:09:27 [7] os_event_wait_low(event = 0x1634918, reset_sig_count = 0), line 399 in "os0sync.c" # 03:09:27 [8] srv_master_thread(arg = (nil)), line 2740 in "srv0srv.c" # 03:09:27 current thread: t@15 # 03:09:27 =>[1] __lwp_park(0x4, 0x0, 0x0, 0x0, 0xff36e0e0, 0x1), at 0xfee48ac4 # 03:09:27 [2] mutex_lock_queue(0xfed26a00, 0x0, 0x14e7058, 0x0, 0x1c00, 0x1d3c), at 0xfee40df4 # 03:09:27 [3] safe_mutex_lock(mp = 0x14e7040, try_lock = '\0', file = 0x109dbd3 "sql_test.cc", line = 500U), line 152 in "thr_mutex.c" # 03:09:27 [4] mysql_print_status(), line 500 in "sql_test.cc" # 03:09:27 [5] signal_hand(arg = (nil)), line 2985 in "mysqld.cc" # 03:09:27 current thread: t@16 # 03:09:27 =>[1] _read(0x4, 0x2abf658, 0x4, 0xa7, 0x1, 0xfed272fc), at 0xfee4c404 # 03:09:27 [2] read(0x1f, 0x2abf658, 0x4, 0x0, 0xfed27200, 0xfed272fc), at 0xfee3aaec # 03:09:27 [3] vio_read(vio = 0x1630728, buf = 0x2abf658 "^G", size = 4U), line 44 in "viosocket.c" # 03:09:27 [4] my_real_read(net = 0x2a9edb8, complen = 0xf5defe0c), line 836 in "net_serv.cc" # 03:09:27 [5] my_net_read(net = 0x2a9edb8), line 1026 in "net_serv.cc" # 03:09:27 [6] do_command(thd = 0x2a9ec80), line 655 in "sql_parse.cc" # 03:09:27 [7] do_handle_one_connection(thd_arg = 0x2a9ec80), line 1174 in "sql_connect.cc" # 03:09:27 [8] handle_one_connection(arg = 0x2a9ec80), line 1113 in "sql_connect.cc" # 03:09:27 current thread: t@22 # 03:09:27 =>[1] __lwp_park(0x4, 0xf5dab830, 0x0, 0x0, 0xff36e100, 0x1), at 0xfee48ac4 # 03:09:27 [2] cond_sleep_queue(0x1, 0x2abd030, 0xf5dab830, 0x0, 0x6dbb0, 0x0), at 0xfee42910 # 03:09:27 [3] cond_wait_queue(0x2ab17b0, 0x2abd030, 0xf5dab830, 0x0, 0x142, 0x0), at 0xfee42ad4 # 03:09:27 [4] cond_wait_common(0x2ab17b0, 0x2abd030, 0xf5dab830, 0x0, 0x0, 0x0), at 0xfee42f18 # 03:09:27 [5] _cond_timedwait(0x2ab17b0, 0x2abd030, 0xf5daba4c, 0x10, 0xf5dabf3f, 0x0), at 0xfee430ac # 03:09:27 [6] cond_timedwait(0x2ab17b0, 0x2abd030, 0xf5daba4c, 0x1c00, 0xfed27a00, 0x2abd018), at 0xfee431a0 # 03:09:27 [7] _pthread_cond_timedwait(0x2ab17b0, 0x2abd030, 0xf5daba4c, 0x0, 0xfed27a00, 0x0), at 0xfee431e0 # 03:09:27 [8] safe_cond_timedwait(cond = 0x2ab17b0, mp = 0x2abd018, abstime = 0xf5daba4c, file = 0x11975a4 "../include/mysql/psi/mysql_thread.h", line = 812U), line 278 in "thr_mutex.c" # 03:09:27 [9] inline_mysql_cond_timedwait(that = 0x2ab17b0, mutex = 0x2abd018, abstime = 0xf5daba4c), line 812 in "mysql_thread.h" # 03:09:27 [10] wait_for_lock(wait = 0x2abd070, data = 0x2abd8b0, in_wait_list = '\0', lock_wait_timeout = 31536000U), line 442 in "thr_lock.c" # 03:09:27 [11] thr_lock(data = 0x2abd8b0, owner = 0x2ac9f28, lock_type = TL_WRITE, lock_wait_timeout = 31536000U), line 779 in "thr_lock.c" # 03:09:27 [12] thr_multi_lock(data = 0x2c24404, count = 1U, owner = 0x2ac9f28, lock_wait_timeout = 31536000U), line 1050 in "thr_lock.c" # 03:09:27 [13] mysql_lock_tables(thd = 0x2ac9690, tables = 0x2ad3290, count = 1U, flags = 0, need_reopen = 0xf5dabf3f), line 336 in "lock.cc" # 03:09:27 [14] lock_tables(thd = 0x2ac9690, tables = 0xf5dac028, count = 1U, flags = 0, need_reopen = 0xf5dabf3f), line 5286 in "sql_base.cc" # 03:09:27 [15] open_and_lock_tables_derived(thd = 0x2ac9690, tables = 0xf5dac028, derived = false, flags = 0, prelocking_strategy = 0xf5dabfd8), line 5132 in "sql_base.cc" # 03:09:27 [16] Event_db_repository::open_event_table(this = 0x14f1580, thd = 0x2ac9690, lock_type = TL_WRITE, table = 0xf5dac47c), line 577 in "event_db_repository.cc" # 03:09:27 [17] Event_db_repository::create_event(this = 0x14f1580, thd = 0x2ac9690, parse_data = 0x2ad30f8, create_if_not = '\0'), line 625 in "event_db_repository.cc" # 03:09:27 [18] Events::create_event(thd = 0x2ac9690, parse_data = 0x2ad30f8, if_not_exists = false), line 335 in "events.cc" # 03:09:27 [19] mysql_execute_command(thd = 0x2ac9690), line 3526 in "sql_parse.cc" # 03:09:27 [20] mysql_parse(thd = 0x2ac9690, inBuf = 0x2ad3008 "CREATE EVENT n ON SCHEDULE AT NOW() DO SET @a=@a", length = 48U, found_semicolon = 0xf5dafa78), line 5581 in "sql_parse.cc" # 03:09:27 [21] dispatch_command(command = COM_QUERY, thd = 0x2ac9690, packet = 0x2add639 "CREATE EVENT n ON SCHEDULE AT NOW() DO SET @a=@a", packet_length = 48U), line 1023 in "sql_parse.cc" # 03:09:27 [22] do_command(thd = 0x2ac9690), line 709 in "sql_parse.cc" # 03:09:27 [23] do_handle_one_connection(thd_arg = 0x2ac9690), line 1174 in "sql_connect.cc" # 03:09:27 [24] handle_one_connection(arg = 0x2ac9690), line 1113 in "sql_connect.cc" # 03:09:27 current thread: t@23 # 03:09:27 =>[1] __lwp_park(0x4, 0xf5d6aa88, 0x0, 0x0, 0xff36e110, 0x1), at 0xfee48ac4 # 03:09:27 [2] cond_sleep_queue(0x1, 0x2abd030, 0xf5d6aa88, 0x0, 0x6dbb0, 0x0), at 0xfee42910 # 03:09:27 [3] cond_wait_queue(0x2b24220, 0x2abd030, 0xf5d6aa88, 0x0, 0x142, 0x0), at 0xfee42ad4 # 03:09:27 [4] cond_wait_common(0x2b24220, 0x2abd030, 0xf5d6aa88, 0x0, 0x0, 0x0), at 0xfee42f18 # 03:09:27 [5] _cond_timedwait(0x2b24220, 0x2abd030, 0xf5d6aca4, 0x10, 0xf5d6b197, 0x0), at 0xfee430ac # 03:09:27 [6] cond_timedwait(0x2b24220, 0x2abd030, 0xf5d6aca4, 0x1c00, 0xfed28200, 0x2abd018), at 0xfee431a0 # 03:09:27 [7] _pthread_cond_timedwait(0x2b24220, 0x2abd030, 0xf5d6aca4, 0x0, 0xfed28200, 0x0), at 0xfee431e0 # 03:09:27 [8] safe_cond_timedwait(cond = 0x2b24220, mp = 0x2abd018, abstime = 0xf5d6aca4, file = 0x11975a4 "../include/mysql/psi/mysql_thread.h", line = 812U), line 278 in "thr_mutex.c" # 03:09:27 [9] inline_mysql_cond_timedwait(that = 0x2b24220, mutex = 0x2abd018, abstime = 0xf5d6aca4), line 812 in "mysql_thread.h" # 03:09:27 [10] wait_for_lock(wait = 0x2abd060, data = 0x3290150, in_wait_list = '\0', lock_wait_timeout = 31536000U), line 442 in "thr_lock.c" # 03:09:27 [11] thr_lock(data = 0x3290150, owner = 0x2c20960, lock_type = TL_READ, lock_wait_timeout = 31536000U), line 779 in "thr_lock.c" # 03:09:27 [12] thr_multi_lock(data = 0x2e09c5c, count = 1U, owner = 0x2c20960, lock_wait_timeout = 31536000U), line 1050 in "thr_lock.c" # 03:09:27 [13] mysql_lock_tables(thd = 0x2c200c8, tables = 0x330ab98, count = 1U, flags = 0, need_reopen = 0xf5d6b197), line 336 in "lock.cc" # 03:09:27 [14] lock_tables(thd = 0x2c200c8, tables = 0xf5d6b280, count = 1U, flags = 0, need_reopen = 0xf5d6b197), line 5286 in "sql_base.cc" # 03:09:27 [15] open_and_lock_tables_derived(thd = 0x2c200c8, tables = 0xf5d6b280, derived = false, flags = 0, prelocking_strategy = 0xf5d6b230), line 5132 in "sql_base.cc" # 03:09:27 [16] Event_db_repository::open_event_table(this = 0x14f1580, thd = 0x2c200c8, lock_type = TL_READ, table = 0xf5d6b69c), line 577 in "event_db_repository.cc" # 03:09:27 [17] Event_db_repository::fill_schema_events(this = 0x14f1580, thd = 0x2c200c8, tables = 0x2c253c0, db = (nil)), line 522 in "event_db_repository.cc" # 03:09:27 [18] Events::fill_schema_events(thd = 0x2c200c8, tables = 0x2c253c0, _ARG3 = (nil)), line 773 in "events.cc" # 03:09:27 [19] get_schema_tables_result(join = 0x336cf00, executed_place = PROCESSED_BY_JOIN_EXEC), line 6642 in "sql_show.cc" # 03:09:27 [20] JOIN::exec(this = 0x336cf00), line 1809 in "sql_select.cc" # 03:09:27 [21] mysql_select(thd = 0x2c200c8, rref_pointer_array = 0x2c21564, tables = 0x2c253c0, wild_num = 1U, fields = CLASS, conds = 0x2c26450, og_num = 3U, order = 0x2c26638, group = (nil), having = (nil), proc_param = (nil), select_options = 2684619520ULL, result = 0x2ff8020, unit = 0x2c21030, select_lex = 0x2c21468), line 2480 in "sql_select.cc" # 03:09:27 [22] handle_select(thd = 0x2c200c8, lex = 0x2c20fd0, result = 0x2ff8020, setup_tables_done_option = 0), line 259 in "sql_select.cc" # 03:09:27 [23] execute_sqlcom_select(thd = 0x2c200c8, all_tables = 0x2c253c0), line 4548 in "sql_parse.cc" # 03:09:27 [24] mysql_execute_command(thd = 0x2c200c8), line 2060 in "sql_parse.cc" # 03:09:27 [25] mysql_parse(thd = 0x2c200c8, inBuf = 0x2c24c48 "SELECT * FROM (INFORMATION_SCHEMA . `EVENTS` AS table1 STRAIGHT_JOIN mysql . `help_relation` AS table2 ON ( table2 . `help_keyword_id` = table1 . `STATUS` ) ) WHERE NOT table2 . `help_keyword_id` <> 0 ORDER BY table1 . `EVENT_DEFINITION` , table2 . `help_topic_id` , table2 . `help_topic_id` LIMIT 7", length = 301U, found_semicolon = 0xf5d6fa78), line 5581 in "sql_parse.cc" # 03:09:27 [26] dispatch_command(command = COM_QUERY, thd = 0x2c200c8, packet = 0x2c26e61 " SELECT * FROM (INFORMATION_SCHEMA . `EVENTS` AS table1 STRAIGHT_JOIN mysql . `help_relation` AS table2 ON ( table2 . `help_keyword_id` = table1 . `STATUS` ) ) WHERE NOT table2 . `help_keyword_id` <> 0 ORDER BY table1 . `EVENT_DEFINITION` , table2 . `help_topic_id` , table2 . `help_topic_id` LIMIT 7", packet_length = 302U), line 1023 in "sql_parse.cc" # 03:09:27 [27] do_command(thd = 0x2c200c8), line 709 in "sql_parse.cc" # 03:09:27 [28] do_handle_one_connection(thd_arg = 0x2c200c8), line 1174 in "sql_connect.cc" # 03:09:27 [29] handle_one_connection(arg = 0x2c200c8), line 1113 in "sql_connect.cc" # 03:09:27 current thread: t@24 # 03:09:27 =>[1] __lwp_park(0x4, 0x0, 0x0, 0x0, 0xff36e120, 0x1), at 0xfee48ac4 # 03:09:27 [2] mutex_lock_queue(0xfed28a00, 0x0, 0x14e6588, 0x0, 0x1c00, 0x1d3c), at 0xfee40df4 # 03:09:27 [3] safe_mutex_lock(mp = 0x14e6570, try_lock = '\0', file = 0x10b8787 "sql_show.cc", line = 2160U), line 152 in "thr_mutex.c" # 03:09:27 [4] show_status_array(thd = 0x2c3b1b0, wild = (nil), variables = 0x30fc2c8, value_type = OPT_SESSION, status_var = (nil), prefix = 0x10b925c "", table = 0x3296998, ucase_names = true, cond = 0x30b2118), line 2160 in "sql_show.cc" # 03:09:27 [5] fill_variables(thd = 0x2c3b1b0, tables = 0x2c4f908, cond = 0x30b2118), line 5924 in "sql_show.cc" # 03:09:27 [6] get_schema_tables_result(join = 0x32c69c8, executed_place = PROCESSED_BY_JOIN_EXEC), line 6642 in "sql_show.cc" # 03:09:27 [7] JOIN::exec(this = 0x32c69c8), line 1809 in "sql_select.cc" # 03:09:27 [8] mysql_select(thd = 0x2c3b1b0, rref_pointer_array = 0x2c3c64c, tables = 0x2c4f4d8, wild_num = 1U, fields = CLASS, conds = 0x2c505f8, og_num = 0, order = (nil), group = (nil), having = 0x2c50ba8, proc_param = (nil), select_options = 2684619520ULL, result = 0x32c69b8, unit = 0x2c3c118, select_lex = 0x2c3c550), line 2480 in "sql_select.cc" # 03:09:27 [9] handle_select(thd = 0x2c3b1b0, lex = 0x2c3c0b8, result = 0x32c69b8, setup_tables_done_option = 0), line 259 in "sql_select.cc" # 03:09:27 [10] execute_sqlcom_select(thd = 0x2c3b1b0, all_tables = 0x2c4f4d8), line 4548 in "sql_parse.cc" # 03:09:27 [11] mysql_execute_command(thd = 0x2c3b1b0), line 2060 in "sql_parse.cc" # 03:09:27 [12] mysql_parse(thd = 0x2c3b1b0, inBuf = 0x2c4ece8 "SELECT * FROM (INFORMATION_SCHEMA . `USER_PRIVILEGES` AS table1 INNER JOIN INFORMATION_SCHEMA . `SESSION_VARIABLES` AS table2 ON ( table2 . `VARIABLE_NAME` = table1 . `PRIVILEGE_TYPE` ) ) WHERE NOT table2 . `VARIABLE_VALUE` > '2009-03-27 09:29:15' HAVING ( table1 . `TABLE_CATALOG` <= '2002-10-03 01:03:42' AND table2 . `VARIABLE_VALUE` <> 'qg')", length = 347U, found_semicolon = 0xf5d2fa78), line 5581 in "sql_parse.cc" # 03:09:27 [13] dispatch_command(command = COM_QUERY, thd = 0x2c3b1b0, packet = 0x2ccd279 " SELECT * FROM (INFORMATION_SCHEMA . `USER_PRIVILEGES` AS table1 INNER JOIN INFORMATION_SCHEMA . `SESSION_VARIABLES` AS table2 ON ( table2 . `VARIABLE_NAME` = table1 . `PRIVILEGE_TYPE` ) ) WHERE NOT table2 . `VARIABLE_VALUE` > '2009-03-27 09:29:15' HAVING ( table1 . `TABLE_CATALOG` <= '2002-10-03 01:03:42' AND table2 . `VARIABLE_VALUE` <> 'qg') ", packet_length = 349U), line 1023 in "sql_parse.cc" # 03:09:27 [14] do_command(thd = 0x2c3b1b0), line 709 in "sql_parse.cc" # 03:09:27 [15] do_handle_one_connection(thd_arg = 0x2c3b1b0), line 1174 in "sql_connect.cc" # 03:09:27 [16] handle_one_connection(arg = 0x2c3b1b0), line 1113 in "sql_connect.cc" # 03:09:27 current thread: t@25 # 03:09:27 =>[1] __lwp_park(0x4, 0x0, 0x0, 0x0, 0xff36e130, 0x1), at 0xfee48ac4 # 03:09:27 [2] mutex_lock_queue(0xfed29200, 0x0, 0x14e7058, 0x0, 0x1c00, 0x1d3c), at 0xfee40df4 # 03:09:27 [3] safe_mutex_lock(mp = 0x14e7040, try_lock = '\0', file = 0x10b9275 "sql_show.cc", line = 5962U), line 152 in "thr_mutex.c" # 03:09:27 [4] fill_status(thd = 0x2c3ce18, tables = 0x2ddd800, cond = 0x2de29f8), line 5962 in "sql_show.cc" # 03:09:27 [5] get_schema_tables_result(join = 0x326cb78, executed_place = PROCESSED_BY_JOIN_EXEC), line 6642 in "sql_show.cc" # 03:09:27 [6] JOIN::exec(this = 0x326cb78), line 1809 in "sql_select.cc" # 03:09:27 [7] mysql_select(thd = 0x2c3ce18, rref_pointer_array = 0x2c3e2b4, tables = 0x2ddd3e8, wild_num = 1U, fields = CLASS, conds = 0x2ddea98, og_num = 0, order = (nil), group = (nil), having = 0x326c7f8, proc_param = (nil), select_options = 2684619520ULL, result = 0x326cb68, unit = 0x2c3dd80, select_lex = 0x2c3e1b8), line 2480 in "sql_select.cc" # 03:09:27 [8] handle_select(thd = 0x2c3ce18, lex = 0x2c3dd20, result = 0x326cb68, setup_tables_done_option = 0), line 259 in "sql_select.cc" # 03:09:27 [9] execute_sqlcom_select(thd = 0x2c3ce18, all_tables = 0x2ddd3e8), line 4548 in "sql_parse.cc" # 03:09:27 [10] mysql_execute_command(thd = 0x2c3ce18), line 2060 in "sql_parse.cc" # 03:09:27 [11] mysql_parse(thd = 0x2c3ce18, inBuf = 0x2ddcc68 "SELECT * FROM (test . `BB` AS table1 RIGHT JOIN INFORMATION_SCHEMA . `GLOBAL_STATUS` AS table2 ON ( table2 . `VARIABLE_NAME` = table1 . `col_varchar_nokey` ) ) WHERE NOT ( table1 . `col_date_nokey` < table1 . `col_int_key` AND table2 . `VARIABLE_VALUE` >= table1 . `col_varchar_key`) HAVING table2 . `VARIABLE_NAME` = 4", length = 322U, found_semicolon = 0xf5cefa78), line 5581 in "sql_parse.cc" # 03:09:27 [12] dispatch_command(command = COM_QUERY, thd = 0x2c3ce18, packet = 0x2e1c639 " SELECT * FROM (test . `BB` AS table1 RIGHT JOIN INFORMATION_SCHEMA . `GLOBAL_STATUS` AS table2 ON ( table2 . `VARIABLE_NAME` = table1 . `col_varchar_nokey` ) ) WHERE NOT ( table1 . `col_date_nokey` < table1 . `col_int_key` AND table2 . `VARIABLE_VALUE` >= table1 . `col_varchar_key`) HAVING table2 . `VARIABLE_NAME` = 4 ", packet_length = 324U), line 1023 in "sql_parse.cc" # 03:09:27 [13] do_command(thd = 0x2c3ce18), line 709 in "sql_parse.cc" # 03:09:27 [14] do_handle_one_connection(thd_arg = 0x2c3ce18), line 1174 in "sql_connect.cc" # 03:09:27 [15] handle_one_connection(arg = 0x2c3ce18), line 1113 in "sql_connect.cc" # 03:09:27 current thread: t@26 # 03:09:27 =>[1] __lwp_park(0x4, 0x0, 0x0, 0x0, 0xff36e140, 0x1), at 0xfee48ac4 # 03:09:27 [2] mutex_lock_queue(0xfed29a00, 0x0, 0x14e7ae8, 0x0, 0x1c00, 0x1d3c), at 0xfee40df4 # 03:09:27 [3] safe_mutex_lock(mp = 0x14e7ad0, try_lock = '\0', file = 0x1086f3c "sys_vars_shared.h", line = 51U), line 152 in "thr_mutex.c" # 03:09:27 [4] PolyLock_mutex::rdlock(this = 0x123b608), line 51 in "sys_vars_shared.h" # 03:09:27 [5] sys_var::value_ptr(this = 0x123b610, thd = 0x2b1e980, type = OPT_GLOBAL, base = 0xf5cab260), line 225 in "set_var.cc" # 03:09:27 [6] show_status_array(thd = 0x2b1e980, wild = (nil), variables = 0x30d2dd4, value_type = OPT_GLOBAL, status_var = (nil), prefix = 0x10b925c "", table = 0x2d69100, ucase_names = true, cond = (nil)), line 2166 in "sql_show.cc" # 03:09:27 [7] fill_variables(thd = 0x2b1e980, tables = 0x2b72fd8, cond = (nil)), line 5924 in "sql_show.cc" # 03:09:27 [8] get_schema_tables_result(join = 0x2e0c4b0, executed_place = PROCESSED_BY_JOIN_EXEC), line 6642 in "sql_show.cc" # 03:09:27 [9] JOIN::exec(this = 0x2e0c4b0), line 1809 in "sql_select.cc" # 03:09:27 [10] mysql_select(thd = 0x2b1e980, rref_pointer_array = 0x2b1fe1c, tables = 0x2b72ba8, wild_num = 1U, fields = CLASS, conds = 0x2bbb8e0, og_num = 4U, order = 0x2bbc008, group = (nil), having = 0x2bbbe70, proc_param = (nil), select_options = 2684619520ULL, result = 0x2bbc5b0, unit = 0x2b1f8e8, select_lex = 0x2b1fd20), line 2480 in "sql_select.cc" # 03:09:27 [11] handle_select(thd = 0x2b1e980, lex = 0x2b1f888, result = 0x2bbc5b0, setup_tables_done_option = 0), line 259 in "sql_select.cc" # 03:09:27 [12] execute_sqlcom_select(thd = 0x2b1e980, all_tables = 0x2b72ba8), line 4548 in "sql_parse.cc" # 03:09:27 [13] mysql_execute_command(thd = 0x2b1e980), line 2060 in "sql_parse.cc" # 03:09:27 [14] mysql_parse(thd = 0x2b1e980, inBuf = 0x2b72280 "SELECT * FROM (test . `E` AS table1 INNER JOIN INFORMATION_SCHEMA . `GLOBAL_VARIABLES` AS table2 ON ( table2 . `VARIABLE_VALUE` = table1 . `col_datetime_nokey` ) ) WHERE (NOT (NOT table1 . `col_date_key` <> table2 . `VARIABLE_VALUE` OR table2 . `VARIABLE_NAME` != table1 . `col_time_nokey`) OR table1 . `col_time_key` > 'li') HAVING (table1 . `col_date_nokey` > 2 IS NULL AND table2 . `VARIABLE_NAME` = 'y') ORDER BY table2 . `VARIABLE_VALUE` , table1 . `col_date_key` , table2 . `VARIABLE_NAME` , table2 . `" ..., length = 534U, found_semicolon = 0xf5cafa78), line 5581 in "sql_parse.cc" # 03:09:27 [15] dispatch_command(command = COM_QUERY, thd = 0x2b1e980, packet = 0x2c19f19 " SELECT * FROM (test . `E` AS table1 INNER JOIN INFORMATION_SCHEMA . `GLOBAL_VARIABLES` AS table2 ON ( table2 . `VARIABLE_VALUE` = table1 . `col_datetime_nokey` ) ) WHERE (NOT (NOT table1 . `col_date_key` <> table2 . `VARIABLE_VALUE` OR table2 . `VARIABLE_NAME` != table1 . `col_time_nokey`) OR table1 . `col_time_key` > 'li') HAVING (table1 . `col_date_nokey` > 2 IS NULL AND table2 . `VARIABLE_NAME` = 'y') ORDER BY table2 . `VARIABLE_VALUE` , table1 . `col_date_key` , table2 . `VARIABLE_NAME` , table2 . " ..., packet_length = 535U), line 1023 in "sql_parse.cc" # 03:09:27 [16] do_command(thd = 0x2b1e980), line 709 in "sql_parse.cc" # 03:09:27 [17] do_handle_one_connection(thd_arg = 0x2b1e980), line 1174 in "sql_connect.cc" # 03:09:27 [18] handle_one_connection(arg = 0x2b1e980), line 1113 in "sql_connect.cc" # 03:09:27 current thread: t@27 # 03:09:27 =>[1] __lwp_park(0x4, 0xf5c6aa88, 0x0, 0x0, 0xff36e150, 0x1), at 0xfee48ac4 # 03:09:27 [2] cond_sleep_queue(0x1, 0x2abd030, 0xf5c6aa88, 0x0, 0x6dbb0, 0x0), at 0xfee42910 # 03:09:27 [3] cond_wait_queue(0x2dfcf70, 0x2abd030, 0xf5c6aa88, 0x0, 0x142, 0x0), at 0xfee42ad4 # 03:09:27 [4] cond_wait_common(0x2dfcf70, 0x2abd030, 0xf5c6aa88, 0x0, 0x0, 0x0), at 0xfee42f18 # 03:09:27 [5] _cond_timedwait(0x2dfcf70, 0x2abd030, 0xf5c6aca4, 0x10, 0xf5c6b197, 0x0), at 0xfee430ac # 03:09:27 [6] cond_timedwait(0x2dfcf70, 0x2abd030, 0xf5c6aca4, 0x1c00, 0xfed2a200, 0x2abd018), at 0xfee431a0 # 03:09:27 [7] _pthread_cond_timedwait(0x2dfcf70, 0x2abd030, 0xf5c6aca4, 0x0, 0xfed2a200, 0x0), at 0xfee431e0 # 03:09:27 [8] safe_cond_timedwait(cond = 0x2dfcf70, mp = 0x2abd018, abstime = 0xf5c6aca4, file = 0x11975a4 "../include/mysql/psi/mysql_thread.h", line = 812U), line 278 in "thr_mutex.c" # 03:09:27 [9] inline_mysql_cond_timedwait(that = 0x2dfcf70, mutex = 0x2abd018, abstime = 0xf5c6aca4), line 812 in "mysql_thread.h" # 03:09:27 [10] wait_for_lock(wait = 0x2abd060, data = 0x2df52f8, in_wait_list = '\0', lock_wait_timeout = 31536000U), line 442 in "thr_lock.c" # 03:09:27 [11] thr_lock(data = 0x2df52f8, owner = 0x2db1940, lock_type = TL_READ, lock_wait_timeout = 31536000U), line 779 in "thr_lock.c" # 03:09:27 [12] thr_multi_lock(data = 0x14ea3f4, count = 1U, owner = 0x2db1940, lock_wait_timeout = 31536000U), line 1050 in "thr_lock.c" # 03:09:27 [13] mysql_lock_tables(thd = 0x2db10a8, tables = 0x2e4a6c0, count = 1U, flags = 0, need_reopen = 0xf5c6b197), line 336 in "lock.cc" # 03:09:27 [14] lock_tables(thd = 0x2db10a8, tables = 0xf5c6b280, count = 1U, flags = 0, need_reopen = 0xf5c6b197), line 5286 in "sql_base.cc" # 03:09:27 [15] open_and_lock_tables_derived(thd = 0x2db10a8, tables = 0xf5c6b280, derived = false, flags = 0, prelocking_strategy = 0xf5c6b230), line 5132 in "sql_base.cc" # 03:09:27 [16] Event_db_repository::open_event_table(this = 0x14f1580, thd = 0x2db10a8, lock_type = TL_READ, table = 0xf5c6b69c), line 577 in "event_db_repository.cc" # 03:09:27 [17] Event_db_repository::fill_schema_events(this = 0x14f1580, thd = 0x2db10a8, tables = 0x2db85f8, db = (nil)), line 522 in "event_db_repository.cc" # 03:09:27 [18] Events::fill_schema_events(thd = 0x2db10a8, tables = 0x2db85f8, _ARG3 = (nil)), line 773 in "events.cc" # 03:09:27 [19] get_schema_tables_result(join = 0x382f838, executed_place = PROCESSED_BY_JOIN_EXEC), line 6642 in "sql_show.cc" # 03:09:27 [20] JOIN::exec(this = 0x382f838), line 1809 in "sql_select.cc" # 03:09:27 [21] mysql_select(thd = 0x2db10a8, rref_pointer_array = 0x2db2544, tables = 0x2db81f8, wild_num = 1U, fields = CLASS, conds = 0x2cf7f88, og_num = 1U, order = 0x2cf8650, group = (nil), having = 0x2cf8498, proc_param = (nil), select_options = 2684619520ULL, result = 0x327a868, unit = 0x2db2010, select_lex = 0x2db2448), line 2480 in "sql_select.cc" # 03:09:27 [22] handle_select(thd = 0x2db10a8, lex = 0x2db1fb0, result = 0x327a868, setup_tables_done_option = 0), line 259 in "sql_select.cc" # 03:09:27 [23] execute_sqlcom_select(thd = 0x2db10a8, all_tables = 0x2db81f8), line 4548 in "sql_parse.cc" # 03:09:27 [24] mysql_execute_command(thd = 0x2db10a8), line 2060 in "sql_parse.cc" # 03:09:27 [25] mysql_parse(thd = 0x2db10a8, inBuf = 0x2db77b0 "SELECT * FROM (mysql . `time_zone_transition_type` AS table1 INNER JOIN INFORMATION_SCHEMA . `EVENTS` AS table2 ON ( table2 . `EXECUTE_AT` = table1 . `Transition_type_id` ) ) WHERE ( (NOT ( ( ( ( ( table2 . `INTERVAL_VALUE` <> table2 . `EVENT_BODY` OR table1 . `Offset` <> 'ue') OR table2 . `EVENT_NAME` = table1 . `Is_DST`) OR table2 . `LAST_EXECUTED` <= 1) AND table2 . `COLLATION_CONNECTION` != table1 . `Time_zone_id`) OR table1 . `Transition_type_id` >= 'ku') OR table2 . `COLLATION_CONNECTION` <= table1 ." ..., length = 629U, found_semicolon = 0xf5c6fa78), line 5581 in "sql_parse.cc" # 03:09:27 [26] dispatch_command(command = COM_QUERY, thd = 0x2db10a8, packet = 0x2e20649 " SELECT * FROM (mysql . `time_zone_transition_type` AS table1 INNER JOIN INFORMATION_SCHEMA . `EVENTS` AS table2 ON ( table2 . `EXECUTE_AT` = table1 . `Transition_type_id` ) ) WHERE ( (NOT ( ( ( ( ( table2 . `INTERVAL_VALUE` <> table2 . `EVENT_BODY` OR table1 . `Offset` <> 'ue') OR table2 . `EVENT_NAME` = table1 . `Is_DST`) OR table2 . `LAST_EXECUTED` <= 1) AND table2 . `COLLATION_CONNECTION` != table1 . `Time_zone_id`) OR table1 . `Transition_type_id` >= 'ku') OR table2 . `COLLATION_CONNECTION` <= table1 " ..., packet_length = 630U), line 1023 in "sql_parse.cc" # 03:09:27 [27] do_command(thd = 0x2db10a8), line 709 in "sql_parse.cc" # 03:09:27 [28] do_handle_one_connection(thd_arg = 0x2db10a8), line 1174 in "sql_connect.cc" # 03:09:27 [29] handle_one_connection(arg = 0x2db10a8), line 1113 in "sql_connect.cc" # 03:09:27 current thread: t@28 # 03:09:27 =>[1] __lwp_park(0x4, 0x0, 0x0, 0x0, 0xff36e160, 0x1), at 0xfee48ac4 # 03:09:27 [2] mutex_lock_queue(0xfed2aa00, 0x0, 0x14e7058, 0x0, 0x1c00, 0x1d3c), at 0xfee40df4 # 03:09:27 [3] safe_mutex_lock(mp = 0x14e7040, try_lock = '\0', file = 0x10b9275 "sql_show.cc", line = 5962U), line 152 in "thr_mutex.c" # 03:09:27 [4] fill_status(thd = 0x2e864d0, tables = 0x2db59b8, cond = 0x30c1fa8), line 5962 in "sql_show.cc" # 03:09:27 [5] get_schema_tables_result(join = 0x30c0db8, executed_place = PROCESSED_BY_JOIN_EXEC), line 6642 in "sql_show.cc" # 03:09:27 [6] JOIN::exec(this = 0x30c0db8), line 1809 in "sql_select.cc" # 03:09:27 [7] mysql_select(thd = 0x2e864d0, rref_pointer_array = 0x2e8796c, tables = 0x2db59b8, wild_num = 1U, fields = CLASS, conds = 0x2db6228, og_num = 2U, order = 0x2db66d0, group = (nil), having = 0x2db64f8, proc_param = (nil), select_options = 2684619520ULL, result = 0x2db6a70, unit = 0x2e87438, select_lex = 0x2e87870), line 2480 in "sql_select.cc" # 03:09:27 [8] handle_select(thd = 0x2e864d0, lex = 0x2e873d8, result = 0x2db6a70, setup_tables_done_option = 0), line 259 in "sql_select.cc" # 03:09:27 [9] execute_sqlcom_select(thd = 0x2e864d0, all_tables = 0x2db59b8), line 4548 in "sql_parse.cc" # 03:09:27 [10] mysql_execute_command(thd = 0x2e864d0), line 2060 in "sql_parse.cc" # 03:09:27 [11] mysql_parse(thd = 0x2e864d0, inBuf = 0x2db5640 "SELECT * FROM INFORMATION_SCHEMA . `GLOBAL_STATUS` AS table1 WHERE ( table1 . `VARIABLE_VALUE` = 'c' OR table1 . `VARIABLE_NAME` >= '2006-04-11 03:18:55') HAVING NOT table1 . `VARIABLE_NAME` >= 1 ORDER BY table1 . `VARIABLE_VALUE` , table1 . `VARIABLE_NAME` LIMIT 6", length = 267U, found_semicolon = 0xf5c2fa78), line 5581 in "sql_parse.cc" # 03:09:27 [12] dispatch_command(command = COM_QUERY, thd = 0x2e864d0, packet = 0x2c3ec81 " SELECT * FROM INFORMATION_SCHEMA . `GLOBAL_STATUS` AS table1 WHERE ( table1 . `VARIABLE_VALUE` = 'c' OR table1 . `VARIABLE_NAME` >= '2006-04-11 03:18:55') HAVING NOT table1 . `VARIABLE_NAME` >= 1 ORDER BY table1 . `VARIABLE_VALUE` , table1 . `VARIABLE_NAME` LIMIT 6", packet_length = 268U), line 1023 in "sql_parse.cc" # 03:09:27 [13] do_command(thd = 0x2e864d0), line 709 in "sql_parse.cc" # 03:09:27 [14] do_handle_one_connection(thd_arg = 0x2e864d0), line 1174 in "sql_connect.cc" # 03:09:27 [15] handle_one_connection(arg = 0x2e864d0), line 1113 in "sql_connect.cc" # 03:09:27 current thread: t@30 # 03:09:27 =>[1] __lwp_park(0x4, 0x0, 0x0, 0x0, 0xff36e170, 0x1), at 0xfee48ac4 # 03:09:27 [2] mutex_lock_queue(0xfed2b200, 0x0, 0x14e6588, 0x0, 0x1c00, 0x1d3c), at 0xfee40df4 # 03:09:27 [3] safe_mutex_lock(mp = 0x14e6570, try_lock = '\0', file = 0x10b8787 "sql_show.cc", line = 2160U), line 152 in "thr_mutex.c" # 03:09:27 [4] show_status_array(thd = 0x2fd55f8, wild = (nil), variables = 0x150e41c, value_type = OPT_GLOBAL, status_var = 0xf5beb468, prefix = 0x10b9281 "", table = 0x3293b30, ucase_names = true, cond = 0x2d94628), line 2160 in "sql_show.cc" # 03:09:27 [5] fill_status(thd = 0x2fd55f8, tables = 0x2ffe440, cond = 0x2d94628), line 5965 in "sql_show.cc" # 03:09:27 [6] get_schema_tables_result(join = 0x2d4f6d0, executed_place = PROCESSED_BY_JOIN_EXEC), line 6642 in "sql_show.cc" # 03:09:27 [7] JOIN::exec(this = 0x2d4f6d0), line 1809 in "sql_select.cc" # 03:09:27 [8] mysql_select(thd = 0x2fd55f8, rref_pointer_array = 0x2fd6a94, tables = 0x2ffe028, wild_num = 1U, fields = CLASS, conds = 0x2fff340, og_num = 0, order = (nil), group = (nil), having = (nil), proc_param = (nil), select_options = 2684619520ULL, result = 0x2fff868, unit = 0x2fd6560, select_lex = 0x2fd6998), line 2480 in "sql_select.cc" # 03:09:27 [9] handle_select(thd = 0x2fd55f8, lex = 0x2fd6500, result = 0x2fff868, setup_tables_done_option = 0), line 259 in "sql_select.cc" # 03:09:27 [10] execute_sqlcom_select(thd = 0x2fd55f8, all_tables = 0x2ffe028), line 4548 in "sql_parse.cc" # 03:09:27 [11] mysql_execute_command(thd = 0x2fd55f8), line 2060 in "sql_parse.cc" # 03:09:27 [12] mysql_parse(thd = 0x2fd55f8, inBuf = 0x2ffd8d8 "SELECT * FROM (mysql . `event` AS table1 STRAIGHT_JOIN INFORMATION_SCHEMA . `GLOBAL_STATUS` AS table2 ON ( table2 . `VARIABLE_VALUE` = table1 . `body` ) ) WHERE ( ( table1 . `body_utf8` > table1 . `db_collation` AND table1 . `created` != 'rb') AND table2 . `VARIABLE_NAME` = table1 . `comment`)", length = 295U, found_semicolon = 0xf5befa78), line 5581 in "sql_parse.cc" # 03:09:27 [13] dispatch_command(command = COM_QUERY, thd = 0x2fd55f8, packet = 0x2fd7261 " SELECT * FROM (mysql . `event` AS table1 STRAIGHT_JOIN INFORMATION_SCHEMA . `GLOBAL_STATUS` AS table2 ON ( table2 . `VARIABLE_VALUE` = table1 . `body` ) ) WHERE ( ( table1 . `body_utf8` > table1 . `db_collation` AND table1 . `created` != 'rb') AND table2 . `VARIABLE_NAME` = table1 . `comment`) ", packet_length = 299U), line 1023 in "sql_parse.cc" # 03:09:27 [14] do_command(thd = 0x2fd55f8), line 709 in "sql_parse.cc" # 03:09:27 [15] do_handle_one_connection(thd_arg = 0x2fd55f8), line 1174 in "sql_connect.cc" # 03:09:27 [16] handle_one_connection(arg = 0x2fd55f8), line 1113 in "sql_connect.cc" # 03:09:27 current thread: t@31 # 03:09:27 =>[1] __lwp_park(0x4, 0x0, 0x0, 0x0, 0xff36e180, 0x1), at 0xfee48ac4 # 03:09:27 [2] mutex_lock_queue(0xfed2ba00, 0x0, 0x14e6588, 0x0, 0x1c00, 0x1d3c), at 0xfee40df4 # 03:09:27 [3] safe_mutex_lock(mp = 0x14e6570, try_lock = '\0', file = 0x10b8787 "sql_show.cc", line = 2160U), line 152 in "thr_mutex.c" # 03:09:27 [4] show_status_array(thd = 0x305bf10, wild = (nil), variables = 0x316feb8, value_type = OPT_GLOBAL, status_var = (nil), prefix = 0x10b925c "", table = 0x2ada9a8, ucase_names = true, cond = 0x333b518), line 2160 in "sql_show.cc" # 03:09:27 [5] fill_variables(thd = 0x305bf10, tables = 0x30667d8, cond = 0x333b518), line 5924 in "sql_show.cc" # 03:09:27 [6] get_schema_tables_result(join = 0x334a8e8, executed_place = PROCESSED_BY_JOIN_EXEC), line 6642 in "sql_show.cc" # 03:09:27 [7] JOIN::exec(this = 0x334a8e8), line 1809 in "sql_select.cc" # 03:09:27 [8] mysql_select(thd = 0x305bf10, rref_pointer_array = 0x305d3ac, tables = 0x30663a8, wild_num = 1U, fields = CLASS, conds = 0x334a090, og_num = 1U, order = 0x334a220, group = (nil), having = (nil), proc_param = (nil), select_options = 2684619520ULL, result = 0x334a8d8, unit = 0x305ce78, select_lex = 0x305d2b0), line 2480 in "sql_select.cc" # 03:09:27 [9] handle_select(thd = 0x305bf10, lex = 0x305ce18, result = 0x334a8d8, setup_tables_done_option = 0), line 259 in "sql_select.cc" # 03:09:27 [10] execute_sqlcom_select(thd = 0x305bf10, all_tables = 0x30663a8), line 4548 in "sql_parse.cc" # 03:09:27 [11] mysql_execute_command(thd = 0x305bf10), line 2060 in "sql_parse.cc" # 03:09:27 [12] mysql_parse(thd = 0x305bf10, inBuf = 0x3065ba8 "SELECT * FROM (INFORMATION_SCHEMA . `INNODB_CMPMEM` AS table1 STRAIGHT_JOIN INFORMATION_SCHEMA . `GLOBAL_VARIABLES` AS table2 ON ( table2 . `VARIABLE_NAME` = table1 . `pages_free` ) ) WHERE (NOT (NOT table1 . `pages_used` = 4 AND table1 . `pages_used` >= table1 . `relocation_ops`) AND table2 . `VARIABLE_VALUE` = 'up') ORDER BY table2 . `VARIABLE_NAME`", length = 356U, found_semicolon = 0xf5bafa78), line 5581 in "sql_parse.cc" # 03:09:27 [13] dispatch_command(command = COM_QUERY, thd = 0x305bf10, packet = 0x305db79 " SELECT * FROM (INFORMATION_SCHEMA . `INNODB_CMPMEM` AS table1 STRAIGHT_JOIN INFORMATION_SCHEMA . `GLOBAL_VARIABLES` AS table2 ON ( table2 . `VARIABLE_NAME` = table1 . `pages_free` ) ) WHERE (NOT (NOT table1 . `pages_used` = 4 AND table1 . `pages_used` >= table1 . `relocation_ops`) AND table2 . `VARIABLE_VALUE` = 'up') ORDER BY table2 . `VARIABLE_NAME`", packet_length = 357U), line 1023 in "sql_parse.cc" # 03:09:27 [14] do_command(thd = 0x305bf10), line 709 in "sql_parse.cc" # 03:09:27 [15] do_handle_one_connection(thd_arg = 0x305bf10), line 1174 in "sql_connect.cc" # 03:09:27 [16] handle_one_connection(arg = 0x305bf10), line 1113 in "sql_connect.cc" # 03:09:27 current thread: t@32 # 03:09:27 =>[1] __lwp_park(0x4, 0x0, 0x0, 0x0, 0xff36e190, 0x1), at 0xfee48ac4 # 03:09:27 [2] mutex_lock_queue(0xfed2c200, 0x0, 0x14e6588, 0x0, 0x1c00, 0x1d3c), at 0xfee40df4 # 03:09:27 [3] safe_mutex_lock(mp = 0x14e6570, try_lock = '\0', file = 0x10b8787 "sql_show.cc", line = 2160U), line 152 in "thr_mutex.c" # 03:09:27 [4] show_status_array(thd = 0x2b04af8, wild = (nil), variables = 0x2e469e8, value_type = OPT_SESSION, status_var = (nil), prefix = 0x10b925c "", table = 0x2e7e918, ucase_names = false, cond = (nil)), line 2160 in "sql_show.cc" # 03:09:27 [5] fill_variables(thd = 0x2b04af8, tables = 0x2b6f9a0, cond = (nil)), line 5924 in "sql_show.cc" # 03:09:27 [6] get_schema_tables_result(join = 0x2b6ffc0, executed_place = PROCESSED_BY_JOIN_EXEC), line 6642 in "sql_show.cc" # 03:09:27 [7] JOIN::exec(this = 0x2b6ffc0), line 1809 in "sql_select.cc" # 03:09:27 [8] mysql_select(thd = 0x2b04af8, rref_pointer_array = 0x2b05f94, tables = 0x2b6f9a0, wild_num = 0, fields = CLASS, conds = (nil), og_num = 0, order = (nil), group = (nil), having = (nil), proc_param = (nil), select_options = 2684619520ULL, result = 0x2b6ffb0, unit = 0x2b05a60, select_lex = 0x2b05e98), line 2480 in "sql_select.cc" # 03:09:27 [9] handle_select(thd = 0x2b04af8, lex = 0x2b05a00, result = 0x2b6ffb0, setup_tables_done_option = 0), line 259 in "sql_select.cc" # 03:09:27 [10] execute_sqlcom_select(thd = 0x2b04af8, all_tables = 0x2b6f9a0), line 4548 in "sql_parse.cc" # 03:09:27 [11] mysql_execute_command(thd = 0x2b04af8), line 2060 in "sql_parse.cc" # 03:09:27 [12] mysql_parse(thd = 0x2b04af8, inBuf = 0x2b6f798 "SHOW VARIABLES", length = 14U, found_semicolon = 0xf5b6fa78), line 5581 in "sql_parse.cc" # 03:09:27 [13] dispatch_command(command = COM_QUERY, thd = 0x2b04af8, packet = 0x2b6b779 "SHOW VARIABLES", packet_length = 14U), line 1023 in "sql_parse.cc" # 03:09:27 [14] do_command(thd = 0x2b04af8), line 709 in "sql_parse.cc" # 03:09:27 [15] do_handle_one_connection(thd_arg = 0x2b04af8), line 1174 in "sql_connect.cc" # 03:09:27 [16] handle_one_connection(arg = 0x2b04af8), line 1113 in "sql_connect.cc"