SET GLOBAL wsrep_provider='none'; locks the node

Bug #1136571 reported by Alex Yurchenko
This bug report is a duplicate of:  Bug #1208493: settting wsrep_provider=none hangs. Edit Remove
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
MySQL patches by Codership
Incomplete
Medium
Unassigned

Bug Description

meaning:
1) current client connection becomes unresponsive
2) no new connections to server can be made

branch 5.5-23, revision 3852

Error log stops at:

130301 0:59:33 [Note] WSREP: applier thread exiting (code:5)
130301 0:59:35 [Note] WSREP: rollbacker thread exiting

Stack trace (relevant threads must be 18 and 2, thread 1 hangs accepting a new connection):

Thread 19 (Thread 0x7f92bcb8b700 (LWP 31334)):
#0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162
#1 0x00007f92b7529dbe in wait (cond=..., this=<optimized out>) at galerautils/src/gu_lock.hpp:56
#2 galera::ServiceThd::thd_func (arg=0x25fb7d0) at galera/src/galera_service_thd.cpp:25
#3 0x00007f92bcf52e9a in start_thread (arg=0x7f92bcb8b700) at pthread_create.c:308
#4 0x00007f92bcc7fcbd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
#5 0x0000000000000000 in ?? ()

Thread 18 (Thread 0x7f92b024a700 (LWP 31345)):
#0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162
#1 0x00000000005204cf in inline_mysql_cond_wait (src_line=2335, that=0x103f3c0 <COND_thread_cache>, mutex=<optimized out>, src_file=<optimized out>)
    at /home/ayurchen/codership/mysql/5.5-23/include/mysql/psi/mysql_thread.h:980
#2 cache_thread () at /home/ayurchen/codership/mysql/5.5-23/sql/mysqld.cc:2335
#3 one_thread_per_connection_end (thd=<optimized out>, put_in_cache=true) at /home/ayurchen/codership/mysql/5.5-23/sql/mysqld.cc:2400
#4 0x000000000052013d in start_wsrep_THD (arg=0x597120 <wsrep_rollback_process(THD*)>) at /home/ayurchen/codership/mysql/5.5-23/sql/mysqld.cc:4432
#5 0x00007f92bcf52e9a in start_thread (arg=0x7f92b024a700) at pthread_create.c:308
#6 0x00007f92bcc7fcbd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
#7 0x0000000000000000 in ?? ()

Thread 17 (Thread 0x7f925fbd0700 (LWP 31347)):
#0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162
#1 0x000000000092c6d1 in os_cond_wait (mutex=0x391f290, cond=0x391f2c8) at /home/ayurchen/codership/mysql/5.5-23/storage/innobase/os/os0sync.c:207
#2 os_event_wait_low (event=0x391f290, reset_sig_count=<optimized out>, reset_sig_count@entry=0) at /home/ayurchen/codership/mysql/5.5-23/storage/innobase/os/os0sync.c:609
#3 0x000000000092b7cf in os_aio_simulated_handle (global_segment=global_segment@entry=0, message1=message1@entry=0x7f925fbcfe20, message2=message2@entry=0x7f925fbcfe30,
    type=type@entry=0x7f925fbcfe40) at /home/ayurchen/codership/mysql/5.5-23/storage/innobase/os/os0file.c:5095
#4 0x00000000008e58c4 in fil_aio_wait (segment=segment@entry=0) at /home/ayurchen/codership/mysql/5.5-23/storage/innobase/fil/fil0fil.c:4595
#5 0x000000000086a4a8 in io_handler_thread (arg=<optimized out>) at /home/ayurchen/codership/mysql/5.5-23/storage/innobase/srv/srv0start.c:482
#6 0x00007f92bcf52e9a in start_thread (arg=0x7f925fbd0700) at pthread_create.c:308
#7 0x00007f92bcc7fcbd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
#8 0x0000000000000000 in ?? ()

Thread 16 (Thread 0x7f925f3cf700 (LWP 31348)):
#0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162
#1 0x000000000092c6d1 in os_cond_wait (mutex=0x391f310, cond=0x391f348) at /home/ayurchen/codership/mysql/5.5-23/storage/innobase/os/os0sync.c:207
#2 os_event_wait_low (event=0x391f310, reset_sig_count=<optimized out>, reset_sig_count@entry=0) at /home/ayurchen/codership/mysql/5.5-23/storage/innobase/os/os0sync.c:609
#3 0x000000000092b7cf in os_aio_simulated_handle (global_segment=global_segment@entry=1, message1=message1@entry=0x7f925f3cee20, message2=message2@entry=0x7f925f3cee30,
    type=type@entry=0x7f925f3cee40) at /home/ayurchen/codership/mysql/5.5-23/storage/innobase/os/os0file.c:5095
#4 0x00000000008e58c4 in fil_aio_wait (segment=segment@entry=1) at /home/ayurchen/codership/mysql/5.5-23/storage/innobase/fil/fil0fil.c:4595
#5 0x000000000086a4a8 in io_handler_thread (arg=<optimized out>) at /home/ayurchen/codership/mysql/5.5-23/storage/innobase/srv/srv0start.c:482
#6 0x00007f92bcf52e9a in start_thread (arg=0x7f925f3cf700) at pthread_create.c:308
#7 0x00007f92bcc7fcbd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
#8 0x0000000000000000 in ?? ()

Thread 15 (Thread 0x7f925ebce700 (LWP 31349)):
#0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162
#1 0x000000000092c6d1 in os_cond_wait (mutex=0x391f390, cond=0x391f3c8) at /home/ayurchen/codership/mysql/5.5-23/storage/innobase/os/os0sync.c:207
#2 os_event_wait_low (event=0x391f390, reset_sig_count=<optimized out>, reset_sig_count@entry=0) at /home/ayurchen/codership/mysql/5.5-23/storage/innobase/os/os0sync.c:609
#3 0x000000000092b7cf in os_aio_simulated_handle (global_segment=global_segment@entry=2, message1=message1@entry=0x7f925ebcde20, message2=message2@entry=0x7f925ebcde30,
    type=type@entry=0x7f925ebcde40) at /home/ayurchen/codership/mysql/5.5-23/storage/innobase/os/os0file.c:5095
#4 0x00000000008e58c4 in fil_aio_wait (segment=segment@entry=2) at /home/ayurchen/codership/mysql/5.5-23/storage/innobase/fil/fil0fil.c:4595
#5 0x000000000086a4a8 in io_handler_thread (arg=<optimized out>) at /home/ayurchen/codership/mysql/5.5-23/storage/innobase/srv/srv0start.c:482
#6 0x00007f92bcf52e9a in start_thread (arg=0x7f925ebce700) at pthread_create.c:308
#7 0x00007f92bcc7fcbd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
---Type <return> to continue, or q <return> to quit---
#8 0x0000000000000000 in ?? ()

Thread 14 (Thread 0x7f925e3cd700 (LWP 31350)):
#0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162
#1 0x000000000092c6d1 in os_cond_wait (mutex=0x391f410, cond=0x391f448) at /home/ayurchen/codership/mysql/5.5-23/storage/innobase/os/os0sync.c:207
#2 os_event_wait_low (event=0x391f410, reset_sig_count=<optimized out>, reset_sig_count@entry=0) at /home/ayurchen/codership/mysql/5.5-23/storage/innobase/os/os0sync.c:609
#3 0x000000000092b7cf in os_aio_simulated_handle (global_segment=global_segment@entry=3, message1=message1@entry=0x7f925e3cce20, message2=message2@entry=0x7f925e3cce30,
    type=type@entry=0x7f925e3cce40) at /home/ayurchen/codership/mysql/5.5-23/storage/innobase/os/os0file.c:5095
#4 0x00000000008e58c4 in fil_aio_wait (segment=segment@entry=3) at /home/ayurchen/codership/mysql/5.5-23/storage/innobase/fil/fil0fil.c:4595
#5 0x000000000086a4a8 in io_handler_thread (arg=<optimized out>) at /home/ayurchen/codership/mysql/5.5-23/storage/innobase/srv/srv0start.c:482
#6 0x00007f92bcf52e9a in start_thread (arg=0x7f925e3cd700) at pthread_create.c:308
#7 0x00007f92bcc7fcbd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
#8 0x0000000000000000 in ?? ()

Thread 13 (Thread 0x7f925dbcc700 (LWP 31351)):
#0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162
#1 0x000000000092c6d1 in os_cond_wait (mutex=0x391f490, cond=0x391f4c8) at /home/ayurchen/codership/mysql/5.5-23/storage/innobase/os/os0sync.c:207
#2 os_event_wait_low (event=0x391f490, reset_sig_count=<optimized out>, reset_sig_count@entry=0) at /home/ayurchen/codership/mysql/5.5-23/storage/innobase/os/os0sync.c:609
#3 0x000000000092b7cf in os_aio_simulated_handle (global_segment=global_segment@entry=4, message1=message1@entry=0x7f925dbcbe20, message2=message2@entry=0x7f925dbcbe30,
    type=type@entry=0x7f925dbcbe40) at /home/ayurchen/codership/mysql/5.5-23/storage/innobase/os/os0file.c:5095
#4 0x00000000008e58c4 in fil_aio_wait (segment=segment@entry=4) at /home/ayurchen/codership/mysql/5.5-23/storage/innobase/fil/fil0fil.c:4595
#5 0x000000000086a4a8 in io_handler_thread (arg=<optimized out>) at /home/ayurchen/codership/mysql/5.5-23/storage/innobase/srv/srv0start.c:482
#6 0x00007f92bcf52e9a in start_thread (arg=0x7f925dbcc700) at pthread_create.c:308
#7 0x00007f92bcc7fcbd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
#8 0x0000000000000000 in ?? ()

Thread 12 (Thread 0x7f925d3cb700 (LWP 31352)):
#0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162
#1 0x000000000092c6d1 in os_cond_wait (mutex=0x391f510, cond=0x391f548) at /home/ayurchen/codership/mysql/5.5-23/storage/innobase/os/os0sync.c:207
#2 os_event_wait_low (event=0x391f510, reset_sig_count=<optimized out>, reset_sig_count@entry=0) at /home/ayurchen/codership/mysql/5.5-23/storage/innobase/os/os0sync.c:609
#3 0x000000000092b7cf in os_aio_simulated_handle (global_segment=global_segment@entry=5, message1=message1@entry=0x7f925d3cae20, message2=message2@entry=0x7f925d3cae30,
    type=type@entry=0x7f925d3cae40) at /home/ayurchen/codership/mysql/5.5-23/storage/innobase/os/os0file.c:5095
#4 0x00000000008e58c4 in fil_aio_wait (segment=segment@entry=5) at /home/ayurchen/codership/mysql/5.5-23/storage/innobase/fil/fil0fil.c:4595
#5 0x000000000086a4a8 in io_handler_thread (arg=<optimized out>) at /home/ayurchen/codership/mysql/5.5-23/storage/innobase/srv/srv0start.c:482
#6 0x00007f92bcf52e9a in start_thread (arg=0x7f925d3cb700) at pthread_create.c:308
#7 0x00007f92bcc7fcbd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
#8 0x0000000000000000 in ?? ()

Thread 11 (Thread 0x7f925cbca700 (LWP 31353)):
#0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162
#1 0x000000000092c6d1 in os_cond_wait (mutex=0x391f590, cond=0x391f5c8) at /home/ayurchen/codership/mysql/5.5-23/storage/innobase/os/os0sync.c:207
#2 os_event_wait_low (event=0x391f590, reset_sig_count=<optimized out>, reset_sig_count@entry=0) at /home/ayurchen/codership/mysql/5.5-23/storage/innobase/os/os0sync.c:609
#3 0x000000000092b7cf in os_aio_simulated_handle (global_segment=global_segment@entry=6, message1=message1@entry=0x7f925cbc9e20, message2=message2@entry=0x7f925cbc9e30,
    type=type@entry=0x7f925cbc9e40) at /home/ayurchen/codership/mysql/5.5-23/storage/innobase/os/os0file.c:5095
#4 0x00000000008e58c4 in fil_aio_wait (segment=segment@entry=6) at /home/ayurchen/codership/mysql/5.5-23/storage/innobase/fil/fil0fil.c:4595
#5 0x000000000086a4a8 in io_handler_thread (arg=<optimized out>) at /home/ayurchen/codership/mysql/5.5-23/storage/innobase/srv/srv0start.c:482
#6 0x00007f92bcf52e9a in start_thread (arg=0x7f925cbca700) at pthread_create.c:308
#7 0x00007f92bcc7fcbd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
#8 0x0000000000000000 in ?? ()

Thread 10 (Thread 0x7f925c3c9700 (LWP 31354)):
#0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162
#1 0x000000000092c6d1 in os_cond_wait (mutex=0x391f610, cond=0x391f648) at /home/ayurchen/codership/mysql/5.5-23/storage/innobase/os/os0sync.c:207
#2 os_event_wait_low (event=0x391f610, reset_sig_count=<optimized out>, reset_sig_count@entry=0) at /home/ayurchen/codership/mysql/5.5-23/storage/innobase/os/os0sync.c:609
---Type <return> to continue, or q <return> to quit---
#3 0x000000000092b7cf in os_aio_simulated_handle (global_segment=global_segment@entry=7, message1=message1@entry=0x7f925c3c8e20, message2=message2@entry=0x7f925c3c8e30,
    type=type@entry=0x7f925c3c8e40) at /home/ayurchen/codership/mysql/5.5-23/storage/innobase/os/os0file.c:5095
#4 0x00000000008e58c4 in fil_aio_wait (segment=segment@entry=7) at /home/ayurchen/codership/mysql/5.5-23/storage/innobase/fil/fil0fil.c:4595
#5 0x000000000086a4a8 in io_handler_thread (arg=<optimized out>) at /home/ayurchen/codership/mysql/5.5-23/storage/innobase/srv/srv0start.c:482
#6 0x00007f92bcf52e9a in start_thread (arg=0x7f925c3c9700) at pthread_create.c:308
#7 0x00007f92bcc7fcbd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
#8 0x0000000000000000 in ?? ()

Thread 9 (Thread 0x7f925bbc8700 (LWP 31355)):
#0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162
#1 0x000000000092c6d1 in os_cond_wait (mutex=0x391f690, cond=0x391f6c8) at /home/ayurchen/codership/mysql/5.5-23/storage/innobase/os/os0sync.c:207
#2 os_event_wait_low (event=0x391f690, reset_sig_count=<optimized out>, reset_sig_count@entry=0) at /home/ayurchen/codership/mysql/5.5-23/storage/innobase/os/os0sync.c:609
#3 0x000000000092b7cf in os_aio_simulated_handle (global_segment=global_segment@entry=8, message1=message1@entry=0x7f925bbc7e20, message2=message2@entry=0x7f925bbc7e30,
    type=type@entry=0x7f925bbc7e40) at /home/ayurchen/codership/mysql/5.5-23/storage/innobase/os/os0file.c:5095
#4 0x00000000008e58c4 in fil_aio_wait (segment=segment@entry=8) at /home/ayurchen/codership/mysql/5.5-23/storage/innobase/fil/fil0fil.c:4595
#5 0x000000000086a4a8 in io_handler_thread (arg=<optimized out>) at /home/ayurchen/codership/mysql/5.5-23/storage/innobase/srv/srv0start.c:482
#6 0x00007f92bcf52e9a in start_thread (arg=0x7f925bbc8700) at pthread_create.c:308
#7 0x00007f92bcc7fcbd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
#8 0x0000000000000000 in ?? ()

Thread 8 (Thread 0x7f925b3c7700 (LWP 31356)):
#0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162
#1 0x000000000092c6d1 in os_cond_wait (mutex=0x391f710, cond=0x391f748) at /home/ayurchen/codership/mysql/5.5-23/storage/innobase/os/os0sync.c:207
#2 os_event_wait_low (event=0x391f710, reset_sig_count=<optimized out>, reset_sig_count@entry=0) at /home/ayurchen/codership/mysql/5.5-23/storage/innobase/os/os0sync.c:609
#3 0x000000000092b7cf in os_aio_simulated_handle (global_segment=global_segment@entry=9, message1=message1@entry=0x7f925b3c6e20, message2=message2@entry=0x7f925b3c6e30,
    type=type@entry=0x7f925b3c6e40) at /home/ayurchen/codership/mysql/5.5-23/storage/innobase/os/os0file.c:5095
#4 0x00000000008e58c4 in fil_aio_wait (segment=segment@entry=9) at /home/ayurchen/codership/mysql/5.5-23/storage/innobase/fil/fil0fil.c:4595
#5 0x000000000086a4a8 in io_handler_thread (arg=<optimized out>) at /home/ayurchen/codership/mysql/5.5-23/storage/innobase/srv/srv0start.c:482
#6 0x00007f92bcf52e9a in start_thread (arg=0x7f925b3c7700) at pthread_create.c:308
#7 0x00007f92bcc7fcbd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
#8 0x0000000000000000 in ?? ()

Thread 7 (Thread 0x7f925a3c5700 (LWP 31358)):
#0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:215
#1 0x000000000092c7db in os_cond_wait_timed (abstime=0x7f925a3c4e10, mutex=0x329f820, cond=0x329f858) at /home/ayurchen/codership/mysql/5.5-23/storage/innobase/os/os0sync.c:171
#2 os_event_wait_time_low (event=0x329f820, time_in_usec=time_in_usec@entry=1000000, reset_sig_count=<optimized out>)
    at /home/ayurchen/codership/mysql/5.5-23/storage/innobase/os/os0sync.c:716
#3 0x0000000000867f28 in srv_lock_timeout_thread (arg=<optimized out>) at /home/ayurchen/codership/mysql/5.5-23/storage/innobase/srv/srv0srv.c:2378
#4 0x00007f92bcf52e9a in start_thread (arg=0x7f925a3c5700) at pthread_create.c:308
#5 0x00007f92bcc7fcbd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
#6 0x0000000000000000 in ?? ()

Thread 6 (Thread 0x7f92592a3700 (LWP 31359)):
#0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:215
#1 0x000000000092c7db in os_cond_wait_timed (abstime=0x7f92592a2df0, mutex=0x329f7a0, cond=0x329f7d8) at /home/ayurchen/codership/mysql/5.5-23/storage/innobase/os/os0sync.c:171
#2 os_event_wait_time_low (event=0x329f7a0, time_in_usec=time_in_usec@entry=1000000, reset_sig_count=<optimized out>)
    at /home/ayurchen/codership/mysql/5.5-23/storage/innobase/os/os0sync.c:716
#3 0x00000000008682b3 in srv_error_monitor_thread (arg=<optimized out>) at /home/ayurchen/codership/mysql/5.5-23/storage/innobase/srv/srv0srv.c:2580
#4 0x00007f92bcf52e9a in start_thread (arg=0x7f92592a3700) at pthread_create.c:308
#5 0x00007f92bcc7fcbd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
#6 0x0000000000000000 in ?? ()

Thread 5 (Thread 0x7f9258aa2700 (LWP 31360)):
#0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:215
---Type <return> to continue, or q <return> to quit---
#1 0x000000000092c7db in os_cond_wait_timed (abstime=0x7f9258aa1e60, mutex=0x329f8a0, cond=0x329f8d8) at /home/ayurchen/codership/mysql/5.5-23/storage/innobase/os/os0sync.c:171
#2 os_event_wait_time_low (event=0x329f8a0, time_in_usec=time_in_usec@entry=5000000, reset_sig_count=<optimized out>)
    at /home/ayurchen/codership/mysql/5.5-23/storage/innobase/os/os0sync.c:716
#3 0x0000000000867c43 in srv_monitor_thread (arg=<optimized out>) at /home/ayurchen/codership/mysql/5.5-23/storage/innobase/srv/srv0srv.c:2207
#4 0x00007f92bcf52e9a in start_thread (arg=0x7f9258aa2700) at pthread_create.c:308
#5 0x00007f92bcc7fcbd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
#6 0x0000000000000000 in ?? ()

Thread 4 (Thread 0x7f925abc6700 (LWP 31361)):
#0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162
#1 0x000000000092c6d1 in os_cond_wait (mutex=0x26551d0, cond=0x2655208) at /home/ayurchen/codership/mysql/5.5-23/storage/innobase/os/os0sync.c:207
#2 os_event_wait_low (event=0x26551d0, reset_sig_count=<optimized out>, reset_sig_count@entry=0) at /home/ayurchen/codership/mysql/5.5-23/storage/innobase/os/os0sync.c:609
#3 0x0000000000869009 in srv_master_thread (arg=<optimized out>) at /home/ayurchen/codership/mysql/5.5-23/storage/innobase/srv/srv0srv.c:3255
#4 0x00007f92bcf52e9a in start_thread (arg=0x7f925abc6700) at pthread_create.c:308
#5 0x00007f92bcc7fcbd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
#6 0x0000000000000000 in ?? ()

Thread 3 (Thread 0x7f92bddb2700 (LWP 31366)):
#0 do_sigwait (set=<optimized out>, sig=0x7f92bddb1da0) at ../nptl/sysdeps/unix/sysv/linux/../../../../../sysdeps/unix/sysv/linux/sigwait.c:65
#1 0x00007f92bcf5aa79 in __sigwait (set=<optimized out>, sig=<optimized out>) at ../nptl/sysdeps/unix/sysv/linux/../../../../../sysdeps/unix/sysv/linux/sigwait.c:100
#2 0x000000000051e11b in signal_hand (arg=<optimized out>) at /home/ayurchen/codership/mysql/5.5-23/sql/mysqld.cc:2803
#3 0x00007f92bcf52e9a in start_thread (arg=0x7f92bddb2700) at pthread_create.c:308
#4 0x00007f92bcc7fcbd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
#5 0x0000000000000000 in ?? ()

Thread 2 (Thread 0x7f9259b01700 (LWP 31386)):
#0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162
#1 0x0000000000522e47 in inline_mysql_cond_wait (src_line=4772, that=<optimized out>, mutex=<optimized out>, src_file=<optimized out>)
    at /home/ayurchen/codership/mysql/5.5-23/include/mysql/psi/mysql_thread.h:980
#2 wsrep_wait_appliers_close (thd=0x5206340) at /home/ayurchen/codership/mysql/5.5-23/sql/mysqld.cc:4772
#3 0x0000000000655ac8 in wsrep_stop_replication (thd=0x5206340) at /home/ayurchen/codership/mysql/5.5-23/sql/wsrep_mysqld.cc:648
#4 0x000000000065d257 in wsrep_provider_update (self=<optimized out>, thd=0x5206340, type=<optimized out>) at /home/ayurchen/codership/mysql/5.5-23/sql/wsrep_var.cc:239
#5 0x000000000053437d in sys_var::update (this=this@entry=0x1057ec0 <Sys_wsrep_provider>, thd=thd@entry=0x5206340, var=<optimized out>)
    at /home/ayurchen/codership/mysql/5.5-23/sql/set_var.cc:201
#6 0x0000000000534d71 in update (var=<optimized out>, thd=0x5206340, this=0x1057ec0 <Sys_wsrep_provider>) at /home/ayurchen/codership/mysql/5.5-23/sql/set_var.cc:190
#7 set_var::update (this=<optimized out>, thd=0x5206340) at /home/ayurchen/codership/mysql/5.5-23/sql/set_var.cc:671
#8 0x0000000000535549 in sql_set_variables (thd=0x5206340, var_list=0x52089f0) at /home/ayurchen/codership/mysql/5.5-23/sql/set_var.cc:575
#9 0x0000000000599081 in mysql_execute_command (thd=thd@entry=0x5206340) at /home/ayurchen/codership/mysql/5.5-23/sql/sql_parse.cc:3515
#10 0x000000000059d024 in mysql_parse (thd=0x5206340, parser_state=0x7f9259b00060, length=<optimized out>, rawbuf=<optimized out>)
    at /home/ayurchen/codership/mysql/5.5-23/sql/sql_parse.cc:6190
#11 0x000000000059d373 in wsrep_mysql_parse (thd=thd@entry=0x5206340, rawbuf=0x7f922c006900 "set global wsrep_provider='none'", length=32, parser_state=parser_state@entry=0x7f9259b00060)
    at /home/ayurchen/codership/mysql/5.5-23/sql/sql_parse.cc:6096
#12 0x000000000059f2d3 in dispatch_command (command=<optimized out>, command@entry=COM_QUERY, thd=thd@entry=0x5206340, packet=packet@entry=0x5209271 "set global wsrep_provider='none'",
    packet_length=packet_length@entry=32) at /home/ayurchen/codership/mysql/5.5-23/sql/sql_parse.cc:1212
#13 0x000000000059f996 in do_command (thd=0x5206340) at /home/ayurchen/codership/mysql/5.5-23/sql/sql_parse.cc:869
#14 0x0000000000639eb5 in do_handle_one_connection (thd_arg=thd_arg@entry=0x5206340) at /home/ayurchen/codership/mysql/5.5-23/sql/sql_connect.cc:878
#15 0x0000000000639f2c in handle_one_connection (arg=0x5206340) at /home/ayurchen/codership/mysql/5.5-23/sql/sql_connect.cc:790
#16 0x00007f92bcf52e9a in start_thread (arg=0x7f9259b01700) at pthread_create.c:308
#17 0x00007f92bcc7fcbd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
#18 0x0000000000000000 in ?? ()

Thread 1 (Thread 0x7f92bdeb9700 (LWP 31331)):
#0 __lll_lock_wait () at ../nptl/sysdeps/unix/sysv/linux/x86_64/lowlevellock.S:132
#1 0x00007f92bcf5509b in _L_lock_1006 () from /lib/x86_64-linux-gnu/libpthread.so.0
---Type <return> to continue, or q <return> to quit---
#2 0x00007f92bcf5501c in __pthread_mutex_lock (mutex=0x103cc80 <LOCK_global_system_variables>) at pthread_mutex_lock.c:101
#3 0x000000000056c378 in inline_mysql_mutex_lock (that=0x103cc80 <LOCK_global_system_variables>, src_line=src_line@entry=1393,
    src_file=0x9da048 "/home/ayurchen/codership/mysql/5.5-23/sql/sql_class.cc") at /home/ayurchen/codership/mysql/5.5-23/include/mysql/psi/mysql_thread.h:617
#4 0x000000000057000b in THD::init (this=this@entry=0x263a580) at /home/ayurchen/codership/mysql/5.5-23/sql/sql_class.cc:1393
#5 0x0000000000571058 in THD::THD (this=0x263a580, is_applier=<optimized out>) at /home/ayurchen/codership/mysql/5.5-23/sql/sql_class.cc:1069
#6 0x00000000005233e9 in handle_connections_sockets () at /home/ayurchen/codership/mysql/5.5-23/sql/mysqld.cc:6043
#7 0x000000000052703f in mysqld_main (argc=48, argv=0x25952c8) at /home/ayurchen/codership/mysql/5.5-23/sql/mysqld.cc:5326
#8 0x00007f92bcbad76d in __libc_start_main (main=0x50c060 <main(int, char**)>, argc=17, ubp_av=0x7fff00637c38, init=<optimized out>, fini=<optimized out>, rtld_fini=<optimized out>,
    stack_end=0x7fff00637c28) at libc-start.c:226
#9 0x000000000051c56d in _start ()

Changed in codership-mysql:
importance: Undecided → High
milestone: none → 5.5.29-23.7.3
status: New → Confirmed
Revision history for this message
Alex Yurchenko (ayurchen) wrote :

Does not seem to be easily reproducible, lowering the priority.

Changed in codership-mysql:
importance: High → Medium
Changed in codership-mysql:
status: Confirmed → Incomplete
Changed in codership-mysql:
milestone: 5.5.29-23.7.3 → none
Revision history for this message
Alex Yurchenko (ayurchen) wrote :

Marking it as duplicate in favour of a more recent, but more actively fixed bug.

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.