Comment 1 for bug 439719

Revision history for this message
fmpwizard (diego-fmpwizard) wrote :

So far the reason could be that two threads are using the same session. and one resets Diagnostics_area.m_status while the other thread was hoping for m_status != DA_EMPTY.

Some more information, courtesy of gdb:

gdb) thread apply all bt

Thread 10 (process 18572 thread 0x293f):
#0 0x00007fff82b416be in __semwait_signal_nocancel ()
#1 0x00007fff82b412f4 in nanosleep$NOCANCEL ()
#2 0x00007fff82b3b404 in usleep$NOCANCEL ()
#3 0x00007fff82b4ff77 in abort ()
#4 0x00007fff82b468c1 in __assert_rtn ()
#5 0x000000010000db1a in Diagnostics_area::set_ok_status (this=0x1018669d8, session=0x101865e00, affected_rows_arg=0, found_rows_arg=0, last_insert_id_arg=0, message_arg=0x103646580 "Rows matched: 0 Changed: 0 Warnings: 0") at diagnostics_area.cc:89
#6 0x0000000100005ce9 in Session::my_ok (this=0x101865e00, affected_rows=0, found_rows_arg=0, passed_id=0, message=0x103646580 "Rows matched: 0 Changed: 0 Warnings: 0") at session.h:
1288
#7 0x00000001001767cf in mysql_update (session=0x101865e00, table_list=0x101889f48, fields=@0x101866ff8, values=@0x101867298, conds=0x10188a3c8, order_num=0, order=0x0, limit=6, ignore=false) at sql_update.cc:637
#8 0x000000010000ae0a in drizzled::statement::Update::execute (this=0x1028aeff0) at statement/update.cc:50
#9 0x0000000100146e7b in mysql_execute_command (session=0x101865e00) at sql_parse.cc:934
#10 0x0000000100147070 in mysql_parse (session=0x101865e00, inBuf=0x101889e10 "UPDATE `table0_innodb_int_autoinc` SET `int_key` = 6 WHERE `enum_not_null_key` = 0 LIMIT 6", length=90, found_semicolon=0x103646e28) at sql_parse.cc:1234
#11 0x00000001001475fc in dispatch_command (command=COM_QUERY, session=0x101865e00, packet=0x10268b001 "UPDATE `table0_innodb_int_autoinc` SET `int_key` = 6 WHERE `enum_not_null_key` = 0 LIMIT 6", packet_length=90) at sql_parse.cc:210
#12 0x0000000100104819 in Session::executeStatement (this=0x101865e00) at session.cc:727
#13 0x0000000100104e99 in Session::run (this=0x101865e00) at session.cc:602
#14 0x0000000100370012 in MultiThreadScheduler::runSession (this=0x10289d4f0, session=0x101865e00) at plugin/multi_thread/multi_thread.cc:102
#15 0x000000010036ecc8 in session_thread (arg=0x101865e00) at plugin/multi_thread/multi_thread.cc:123
#16 0x00007fff82aa5e8b in _pthread_start ()
#17 0x00007fff82aa5d4d in thread_start ()

Thread 9 (process 18572 thread 0x2603):
#0 0x00007fff82ac3582 in select$DARWIN_EXTSN ()
#1 0x00000001002f7afd in os_thread_sleep (tm=1000000) at plugin/innobase/os/os0thread.c:292
#2 0x00000001003463ee in srv_master_thread (arg=0x0) at plugin/innobase/srv/srv0srv.c:2326
#3 0x00007fff82aa5e8b in _pthread_start ()
#4 0x00007fff82aa5d4d in thread_start ()

Thread 8 (process 18572 thread 0x2503):
#0 0x00007fff82ac3582 in select$DARWIN_EXTSN ()
#1 0x00000001002f7afd in os_thread_sleep (tm=1000000) at plugin/innobase/os/os0thread.c:292
#2 0x0000000100346155 in srv_error_monitor_thread (arg=0x0) at plugin/innobase/srv/srv0srv.c:2195
#3 0x00007fff82aa5e8b in _pthread_start ()
#4 0x00007fff82aa5d4d in thread_start ()

Thread 7 (process 18572 thread 0x2407):
#0 0x00007fff82ac3582 in select$DARWIN_EXTSN ()
#1 0x00000001002f7afd in os_thread_sleep (tm=1000000) at plugin/innobase/os/os0thread.c:292
#2 0x0000000100345be2 in srv_lock_timeout_and_monitor_thread (arg=0x0) at plugin/innobase/srv/srv0srv.c:1962
#3 0x00007fff82aa5e8b in _pthread_start ()
#4 0x00007fff82aa5d4d in thread_start ()

Thread 6 (process 18572 thread 0x2303):
#0 0x00007fff82a7edc2 in __semwait_signal ()
#1 0x00007fff82aa6ca9 in _pthread_cond_wait ()
#2 0x00000001002f737f in os_event_wait_low (event=0x102858470, reset_sig_count=0) at plugin/innobase/os/os0sync.c:438
#3 0x00000001002f618f in os_aio_simulated_handle (global_segment=3, message1=0x1033b7ec8, message2=0x1033b7ec0, type=0x1033b7eb8) at plugin/innobase/os/os0file.c:3954
#4 0x00000001002cb33a in fil_aio_wait (segment=3) at plugin/innobase/fil/fil0fil.c:4472
#5 0x00000001003472fd in io_handler_thread (arg=0x100655bf8) at plugin/innobase/srv/srv0start.c:450
#6 0x00007fff82aa5e8b in _pthread_start ()
#7 0x00007fff82aa5d4d in thread_start ()

Thread 5 (process 18572 thread 0x2203):
#0 0x00007fff82a7edc2 in __semwait_signal ()
#1 0x00007fff82aa6ca9 in _pthread_cond_wait ()
#2 0x00000001002f737f in os_event_wait_low (event=0x1028583e0, reset_sig_count=0) at plugin/innobase/os/os0sync.c:438
#3 0x00000001002f618f in os_aio_simulated_handle (global_segment=2, message1=0x103334ec8, message2=0x103334ec0, type=0x103334eb8) at plugin/innobase/os/os0file.c:3954
#4 0x00000001002cb33a in fil_aio_wait (segment=2) at plugin/innobase/fil/fil0fil.c:4472
#5 0x00000001003472fd in io_handler_thread (arg=0x100655bf0) at plugin/innobase/srv/srv0start.c:450
#6 0x00007fff82aa5e8b in _pthread_start ()
#7 0x00007fff82aa5d4d in thread_start ()

Thread 4 (process 18572 thread 0x2103):
#0 0x00007fff82a7edc2 in __semwait_signal ()
#1 0x00007fff82aa6ca9 in _pthread_cond_wait ()
#2 0x00000001002f737f in os_event_wait_low (event=0x102858350, reset_sig_count=0) at plugin/innobase/os/os0sync.c:438
#3 0x00000001002f618f in os_aio_simulated_handle (global_segment=1, message1=0x1032b1ec8, message2=0x1032b1ec0, type=0x1032b1eb8) at plugin/innobase/os/os0file.c:3954
#4 0x00000001002cb33a in fil_aio_wait (segment=1) at plugin/innobase/fil/fil0fil.c:4472
#5 0x00000001003472fd in io_handler_thread (arg=0x100655be8) at plugin/innobase/srv/srv0start.c:450
#6 0x00007fff82aa5e8b in _pthread_start ()
#7 0x00007fff82aa5d4d in thread_start ()

Thread 3 (process 18572 thread 0x2003):
#0 0x00007fff82a7edc2 in __semwait_signal ()
#1 0x00007fff82aa6ca9 in _pthread_cond_wait ()
#2 0x00000001002f737f in os_event_wait_low (event=0x1028582c0, reset_sig_count=0) at plugin/innobase/os/os0sync.c:438
#3 0x00000001002f618f in os_aio_simulated_handle (global_segment=0, message1=0x1017e2ec8, message2=0x1017e2ec0, type=0x1017e2eb8) at plugin/innobase/os/os0file.c:3954
#4 0x00000001002cb33a in fil_aio_wait (segment=0) at plugin/innobase/fil/fil0fil.c:4472
#5 0x00000001003472fd in io_handler_thread (arg=0x100655be0) at plugin/innobase/srv/srv0start.c:450
#6 0x00007fff82aa5e8b in _pthread_start ()
#7 0x00007fff82aa5d4d in thread_start ()

Thread 2 (process 18572 thread 0x117):
#0 0x00007fff82ae5222 in __sigwait ()
#1 0x00007fff82b0c49a in sigwait ()
#2 0x00000001003bb7aa in signal_hand () at plugin/signal_handler/signal_handler.cc:152
#3 0x00007fff82aa5e8b in _pthread_start ()
#4 0x00007fff82aa5d4d in thread_start ()

Thread 1 (process 18572 local thread 0x18707):
#0 0x00007fff82b231e6 in poll ()
#1 0x00000001001245c9 in drizzled::slot::Listen::getProtocol (this=0x1005fed90) at slot/listen.cc:274
#2 0x0000000100010e17 in main (argc=4, argv=0x7fff5fbff3b0) at drizzled.cc:1574
(gdb)