[MDEV-22966] Server crashes or hangs with SET ROLE when started with skip-grant-tables - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5
Fix Version/s: 10.2.37, 10.3.28, 10.4.18, 10.5.9
Component/s: Authentication and Privilege System
Labels:
- roles

Description

If the server is started with --skip-grant-tables, then attempting to set a role either results in the server hanging or crashing, depending on affected version.

set role x;

ERROR 2013 (HY000): Lost connection to MySQL server during query

Attachments

Activity

Alice Sherepa added a comment - 2020-06-22 09:10

On 10.3-10.5, debug/non-debug, signal 11:

10.3 b633b6a9d8278a3e0d9ba
#3 <signal handler called>
#4 0x000055821bdb2d1a in start_mutex_wait_v1 (state=0x7f1fe09ba6d0, mutex=0x8f8f8f8f8f8f8f8f, op=PSI_MUTEX_LOCK, src_file=0x55821bf251e8 "/10.3/sql/sql_acl.cc", src_line=2567) at /10.3/storage/perfschema/pfs.cc:2220
#5 0x000055821b1dced0 in inline_mysql_mutex_lock (that=0x55821ef70700, src_file=0x55821bf251e8 "/10.3/sql/sql_acl.cc", src_line=2567) at /10.3/include/mysql/psi/mysql_thread.h:697
#6 0x000055821b1e1481 in check_user_can_set_role (thd=0x7f1fc4000d50, user=0x7f1fc4002b00 "", host=0x55821bf092ab "localhost", ip=0x0, rolename=0x7f1fc4012710 "x", access=0x7f1fc4012730) at /10.3/sql/sql_acl.cc:2567
#7 0x000055821b1e1970 in acl_check_setrole (thd=0x7f1fc4000d50, rolename=0x7f1fc4012710 "x", access=0x7f1fc4012730) at /10.3/sql/sql_acl.cc:2674
#8 0x000055821b1a1283 in set_var_role::check (this=0x7f1fc4012718, thd=0x7f1fc4000d50) at /10.3/sql/set_var.cc:948
#9 0x000055821b1a0af6 in sql_set_variables (thd=0x7f1fc4000d50, var_list=0x7f1fc4005a18, free=true) at /10.3/sql/set_var.cc:733
#10 0x000055821b2aa73e in mysql_execute_command (thd=0x7f1fc4000d50) at /10.3/sql/sql_parse.cc:4883
#11 0x000055821b2b45e6 in mysql_parse (thd=0x7f1fc4000d50, rawbuf=0x7f1fc4012680 "set role x", length=10, parser_state=0x7f1fe09bb5c0, is_com_multi=false, is_next_command=false) at /10.3/sql/sql_parse.cc:7818
#12 0x000055821b2a0f29 in dispatch_command (command=COM_QUERY, thd=0x7f1fc4000d50, packet=0x7f1fc4008ed1 "set role x", packet_length=10, is_com_multi=false, is_next_command=false) at /10.3/sql/sql_parse.cc:1855
#13 0x000055821b29f84c in do_command (thd=0x7f1fc4000d50) at /10.3/sql/sql_parse.cc:1401
#14 0x000055821b417168 in do_handle_one_connection (connect=0x55821ef6c6c0) at /10.3/sql/sql_connect.cc:1403
#15 0x000055821b416eca in handle_one_connection (arg=0x55821ef6c6c0) at /10.3/sql/sql_connect.cc:1308
#16 0x000055821bdb1d21 in pfs_spawn_thread (arg=0x55821efaee60) at /10.3/storage/perfschema/pfs.cc:1869
#17 0x00007f1fe7004fa3 in start_thread (arg=<optimized out>) at pthread_create.c:486
#18 0x00007f1fe69884cf in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

10.2-debug hangs:

[Thread debugging using libthread_db enabled]

Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1".

0x00007f638532fbf9 in __GI___poll (fds=0x7ffd691eeb60, nfds=2, timeout=-1) at ../sysdeps/unix/sysv/linux/poll.c:29

29	../sysdeps/unix/sysv/linux/poll.c: No such file or directory.

Thread 6 (Thread 0x7f637ec1c700 (LWP 11201)):

#0  __lll_lock_wait () at ../sysdeps/unix/sysv/linux/x86_64/lowlevellock.S:135

#1  0x00007f6385f55023 in __GI___pthread_mutex_lock (mutex=0x55d6d3b1f018) at ../nptl/pthread_mutex_lock.c:78

#2  0x000055d6d0b036fa in safe_mutex_lock (mp=0x55d6d3b1eff0, my_flags=0, file=0x55d6d0b7e608 "/10.2/sql/sql_acl.cc", line=2665) at /10.2/mysys/thr_mutex.c:292

#3  0x000055d6d004b530 in inline_mysql_mutex_lock (that=0x55d6d3b1eff0, src_file=0x55d6d0b7e608 "/10.2/sql/sql_acl.cc", src_line=2665) at /10.2/include/mysql/psi/mysql_thread.h:688

#4  0x000055d6d004f67f in check_user_can_set_role (thd=0x7f636c000d50, user=0x7f636c002920 "", host=0x55d6d0b66eb9 "localhost", ip=0x0, rolename=0x7f636c012340 "x", access=0x7f636c012360) at /10.2/sql/sql_acl.cc:2665

#5  0x000055d6d004fb66 in acl_check_setrole (thd=0x7f636c000d50, rolename=0x7f636c012340 "x", access=0x7f636c012360) at /10.2/sql/sql_acl.cc:2773

#6  0x000055d6d001f0cf in set_var_role::check (this=0x7f636c012348, thd=0x7f636c000d50) at /10.2/sql/set_var.cc:946

#7  0x000055d6d001e8ba in sql_set_variables (thd=0x7f636c000d50, var_list=0x7f636c0056d0, free=true) at /10.2/sql/set_var.cc:731

#8  0x000055d6d00ef326 in mysql_execute_command (thd=0x7f636c000d50) at /10.2/sql/sql_parse.cc:4591

#9  0x000055d6d00f917d in mysql_parse (thd=0x7f636c000d50, rawbuf=0x7f636c0122b0 "set role x", length=10, parser_state=0x7f637ec1b570, is_com_multi=false, is_next_command=false) at /10.2/sql/sql_parse.cc:7741

#10 0x000055d6d00e748a in dispatch_command (command=COM_QUERY, thd=0x7f636c000d50, packet=0x7f636c008b01 "set role x", packet_length=10, is_com_multi=false, is_next_command=false) at /10.2/sql/sql_parse.cc:1831

#11 0x000055d6d00e5f07 in do_command (thd=0x7f636c000d50) at /10.2/sql/sql_parse.cc:1385

#12 0x000055d6d023bbad in do_handle_one_connection (connect=0x55d6d3b18200) at /10.2/sql/sql_connect.cc:1336

#13 0x000055d6d023b918 in handle_one_connection (arg=0x55d6d3b18200) at /10.2/sql/sql_connect.cc:1241

#14 0x000055d6d0a51ac1 in pfs_spawn_thread (arg=0x55d6d3b424e0) at /10.2/storage/perfschema/pfs.cc:1869

#15 0x00007f6385f526db in start_thread (arg=0x7f637ec1c700) at pthread_create.c:463

#16 0x00007f638533c88f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

Thread 5 (Thread 0x7f637ec67700 (LWP 11198)):

#0  0x00007f6385f589f3 in futex_wait_cancelable (private=<optimized out>, expected=0, futex_word=0x55d6d169edec <COND_slave_background+44>) at ../sysdeps/unix/sysv/linux/futex-internal.h:88

#1  __pthread_cond_wait_common (abstime=0x0, mutex=0x55d6d16a1fe8 <LOCK_slave_background+40>, cond=0x55d6d169edc0 <COND_slave_background>) at pthread_cond_wait.c:502

#2  __pthread_cond_wait (cond=0x55d6d169edc0 <COND_slave_background>, mutex=0x55d6d16a1fe8 <LOCK_slave_background+40>) at pthread_cond_wait.c:655

#3  0x000055d6d0b03fe3 in safe_cond_wait (cond=0x55d6d169edc0 <COND_slave_background>, mp=0x55d6d16a1fc0 <LOCK_slave_background>, file=0x55d6d0b74a00 "/10.2/include/mysql/psi/mysql_thread.h", line=1145) at /10.2/mysys/thr_mutex.c:491

#4  0x000055d6d0021570 in inline_mysql_cond_wait (that=0x55d6d169edc0 <COND_slave_background>, mutex=0x55d6d16a1fc0 <LOCK_slave_background>, src_file=0x55d6d0b752e8 "/10.2/sql/slave.cc", src_line=337) at /10.2/include/mysql/psi/mysql_thread.h:1145

#5  0x000055d6d00221bb in handle_slave_background (arg=0x0) at /10.2/sql/slave.cc:337

#6  0x000055d6d0a51ac1 in pfs_spawn_thread (arg=0x55d6d3af4350) at /10.2/storage/perfschema/pfs.cc:1869

#7  0x00007f6385f526db in start_thread (arg=0x7f637ec67700) at pthread_create.c:463

#8  0x00007f638533c88f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

Thread 4 (Thread 0x7f637ecb2700 (LWP 11197)):

#0  0x00007f638525b26c in __GI___sigtimedwait (set=<optimized out>, set@entry=0x7f637ecb1d90, info=info@entry=0x7f637ecb1ca0, timeout=timeout@entry=0x0) at ../sysdeps/unix/sysv/linux/sigtimedwait.c:42

#1  0x00007f6385f5d45c in __sigwait (set=0x7f637ecb1d90, sig=0x7f637ecb1d60) at ../sysdeps/unix/sysv/linux/sigwait.c:28

#2  0x000055d6cfff8922 in signal_hand (arg=0x0) at /10.2/sql/mysqld.cc:3509

#3  0x000055d6d0a51ac1 in pfs_spawn_thread (arg=0x55d6d3ae97e0) at /10.2/storage/perfschema/pfs.cc:1869

#4  0x00007f6385f526db in start_thread (arg=0x7f637ecb2700) at pthread_create.c:463

#5  0x00007f638533c88f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

Thread 3 (Thread 0x7f637f4b3700 (LWP 11195)):

#0  0x00007f6385f58f85 in futex_abstimed_wait_cancelable (private=<optimized out>, abstime=0x7f637f4b2d60, expected=0, futex_word=0x55d6d1f23b08 <COND_checkpoint+40>) at ../sysdeps/unix/sysv/linux/futex-internal.h:205

#1  __pthread_cond_wait_common (abstime=0x7f637f4b2d60, mutex=0x55d6d1f23a48 <LOCK_checkpoint+40>, cond=0x55d6d1f23ae0 <COND_checkpoint>) at pthread_cond_wait.c:539

#2  __pthread_cond_timedwait (cond=0x55d6d1f23ae0 <COND_checkpoint>, mutex=0x55d6d1f23a48 <LOCK_checkpoint+40>, abstime=0x7f637f4b2d60) at pthread_cond_wait.c:667

#3  0x000055d6d0b043a3 in safe_cond_timedwait (cond=0x55d6d1f23ae0 <COND_checkpoint>, mp=0x55d6d1f23a20 <LOCK_checkpoint>, abstime=0x7f637f4b2d60, file=0x55d6d0e25080 "/10.2/include/mysql/psi/mysql_thread.h", line=1182) at /10.2/mysys/thr_mutex.c:545

#4  0x000055d6d0930c13 in inline_mysql_cond_timedwait (that=0x55d6d1f23ae0 <COND_checkpoint>, mutex=0x55d6d1f23a20 <LOCK_checkpoint>, abstime=0x7f637f4b2d60, src_file=0x55d6d0e250b8 "/10.2/storage/maria/ma_servicethread.c", src_line=116) at /10.2/include/mysql/psi/mysql_thread.h:1182

#5  0x000055d6d0931115 in my_service_thread_sleep (control=0x55d6d14e0a00 <checkpoint_control>, sleep_time=30000000000) at /10.2/storage/maria/ma_servicethread.c:115

#6  0x000055d6d0925b80 in ma_checkpoint_background (arg=0x1e) at /10.2/storage/maria/ma_checkpoint.c:709

#7  0x000055d6d0a51ac1 in pfs_spawn_thread (arg=0x55d6d3ae6920) at /10.2/storage/perfschema/pfs.cc:1869

#8  0x00007f6385f526db in start_thread (arg=0x7f637f4b3700) at pthread_create.c:463

#9  0x00007f638533c88f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

Thread 2 (Thread 0x7f638081d700 (LWP 11194)):

#0  0x00007f6385f58f85 in futex_abstimed_wait_cancelable (private=<optimized out>, abstime=0x7f638081ce10, expected=0, futex_word=0x55d6d1f351a8 <COND_timer+40>) at ../sysdeps/unix/sysv/linux/futex-internal.h:205

#1  __pthread_cond_wait_common (abstime=0x7f638081ce10, mutex=0x55d6d1f350e8 <LOCK_timer+40>, cond=0x55d6d1f35180 <COND_timer>) at pthread_cond_wait.c:539

#2  __pthread_cond_timedwait (cond=0x55d6d1f35180 <COND_timer>, mutex=0x55d6d1f350e8 <LOCK_timer+40>, abstime=0x7f638081ce10) at pthread_cond_wait.c:667

#3  0x000055d6d0b043a3 in safe_cond_timedwait (cond=0x55d6d1f35180 <COND_timer>, mp=0x55d6d1f350c0 <LOCK_timer>, abstime=0x7f638081ce10, file=0x55d6d0e68950 "/10.2/include/mysql/psi/mysql_thread.h", line=1182) at /10.2/mysys/thr_mutex.c:545

#4  0x000055d6d0b05318 in inline_mysql_cond_timedwait (that=0x55d6d1f35180 <COND_timer>, mutex=0x55d6d1f350c0 <LOCK_timer>, abstime=0x7f638081ce10, src_file=0x55d6d0e68988 "/10.2/mysys/thr_timer.c", src_line=292) at /10.2/include/mysql/psi/mysql_thread.h:1182

#5  0x000055d6d0b05e25 in timer_handler (arg=0x0) at /10.2/mysys/thr_timer.c:292

#6  0x000055d6d0a51ac1 in pfs_spawn_thread (arg=0x55d6d3a03bf0) at /10.2/storage/perfschema/pfs.cc:1869

#7  0x00007f6385f526db in start_thread (arg=0x7f638081d700) at pthread_create.c:463

#8  0x00007f638533c88f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

Thread 1 (Thread 0x7f63876e53c0 (LWP 11192)):

#0  0x00007f638532fbf9 in __GI___poll (fds=0x7ffd691eeb60, nfds=2, timeout=-1) at ../sysdeps/unix/sysv/linux/poll.c:29

#1  0x000055d6cfffe75d in handle_connections_sockets () at /10.2/sql/mysqld.cc:6667

#2  0x000055d6cfffda33 in mysqld_main (argc=129, argv=0x55d6d38e43d0) at /10.2/sql/mysqld.cc:6133

#3  0x000055d6cfff22aa in main (argc=7, argv=0x7ffd691eee58) at /10.2/sql/main.cc:25

Alice Sherepa added a comment - 2020-06-22 09:10 On 10.3-10.5, debug/non-debug, signal 11: 10.3 b633b6a9d8278a3e0d9ba #3 <signal handler called> #4 0x000055821bdb2d1a in start_mutex_wait_v1 (state=0x7f1fe09ba6d0, mutex=0x8f8f8f8f8f8f8f8f, op=PSI_MUTEX_LOCK, src_file=0x55821bf251e8 "/10.3/sql/sql_acl.cc", src_line=2567) at /10.3/storage/perfschema/pfs.cc:2220 #5 0x000055821b1dced0 in inline_mysql_mutex_lock (that=0x55821ef70700, src_file=0x55821bf251e8 "/10.3/sql/sql_acl.cc", src_line=2567) at /10.3/include/mysql/psi/mysql_thread.h:697 #6 0x000055821b1e1481 in check_user_can_set_role (thd=0x7f1fc4000d50, user=0x7f1fc4002b00 "", host=0x55821bf092ab "localhost", ip=0x0, rolename=0x7f1fc4012710 "x", access=0x7f1fc4012730) at /10.3/sql/sql_acl.cc:2567 #7 0x000055821b1e1970 in acl_check_setrole (thd=0x7f1fc4000d50, rolename=0x7f1fc4012710 "x", access=0x7f1fc4012730) at /10.3/sql/sql_acl.cc:2674 #8 0x000055821b1a1283 in set_var_role::check (this=0x7f1fc4012718, thd=0x7f1fc4000d50) at /10.3/sql/set_var.cc:948 #9 0x000055821b1a0af6 in sql_set_variables (thd=0x7f1fc4000d50, var_list=0x7f1fc4005a18, free=true) at /10.3/sql/set_var.cc:733 #10 0x000055821b2aa73e in mysql_execute_command (thd=0x7f1fc4000d50) at /10.3/sql/sql_parse.cc:4883 #11 0x000055821b2b45e6 in mysql_parse (thd=0x7f1fc4000d50, rawbuf=0x7f1fc4012680 "set role x", length=10, parser_state=0x7f1fe09bb5c0, is_com_multi=false, is_next_command=false) at /10.3/sql/sql_parse.cc:7818 #12 0x000055821b2a0f29 in dispatch_command (command=COM_QUERY, thd=0x7f1fc4000d50, packet=0x7f1fc4008ed1 "set role x", packet_length=10, is_com_multi=false, is_next_command=false) at /10.3/sql/sql_parse.cc:1855 #13 0x000055821b29f84c in do_command (thd=0x7f1fc4000d50) at /10.3/sql/sql_parse.cc:1401 #14 0x000055821b417168 in do_handle_one_connection (connect=0x55821ef6c6c0) at /10.3/sql/sql_connect.cc:1403 #15 0x000055821b416eca in handle_one_connection (arg=0x55821ef6c6c0) at /10.3/sql/sql_connect.cc:1308 #16 0x000055821bdb1d21 in pfs_spawn_thread (arg=0x55821efaee60) at /10.3/storage/perfschema/pfs.cc:1869 #17 0x00007f1fe7004fa3 in start_thread (arg=<optimized out>) at pthread_create.c:486 #18 0x00007f1fe69884cf in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 10.2-debug hangs: [Thread debugging using libthread_db enabled] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". 0x00007f638532fbf9 in __GI___poll (fds=0x7ffd691eeb60, nfds=2, timeout=-1) at ../sysdeps/unix/sysv/linux/poll.c:29 29 ../sysdeps/unix/sysv/linux/poll.c: No such file or directory. Thread 6 (Thread 0x7f637ec1c700 (LWP 11201)): #0 __lll_lock_wait () at ../sysdeps/unix/sysv/linux/x86_64/lowlevellock.S:135 #1 0x00007f6385f55023 in __GI___pthread_mutex_lock (mutex=0x55d6d3b1f018) at ../nptl/pthread_mutex_lock.c:78 #2 0x000055d6d0b036fa in safe_mutex_lock (mp=0x55d6d3b1eff0, my_flags=0, file=0x55d6d0b7e608 "/10.2/sql/sql_acl.cc", line=2665) at /10.2/mysys/thr_mutex.c:292 #3 0x000055d6d004b530 in inline_mysql_mutex_lock (that=0x55d6d3b1eff0, src_file=0x55d6d0b7e608 "/10.2/sql/sql_acl.cc", src_line=2665) at /10.2/include/mysql/psi/mysql_thread.h:688 #4 0x000055d6d004f67f in check_user_can_set_role (thd=0x7f636c000d50, user=0x7f636c002920 "", host=0x55d6d0b66eb9 "localhost", ip=0x0, rolename=0x7f636c012340 "x", access=0x7f636c012360) at /10.2/sql/sql_acl.cc:2665 #5 0x000055d6d004fb66 in acl_check_setrole (thd=0x7f636c000d50, rolename=0x7f636c012340 "x", access=0x7f636c012360) at /10.2/sql/sql_acl.cc:2773 #6 0x000055d6d001f0cf in set_var_role::check (this=0x7f636c012348, thd=0x7f636c000d50) at /10.2/sql/set_var.cc:946 #7 0x000055d6d001e8ba in sql_set_variables (thd=0x7f636c000d50, var_list=0x7f636c0056d0, free=true) at /10.2/sql/set_var.cc:731 #8 0x000055d6d00ef326 in mysql_execute_command (thd=0x7f636c000d50) at /10.2/sql/sql_parse.cc:4591 #9 0x000055d6d00f917d in mysql_parse (thd=0x7f636c000d50, rawbuf=0x7f636c0122b0 "set role x", length=10, parser_state=0x7f637ec1b570, is_com_multi=false, is_next_command=false) at /10.2/sql/sql_parse.cc:7741 #10 0x000055d6d00e748a in dispatch_command (command=COM_QUERY, thd=0x7f636c000d50, packet=0x7f636c008b01 "set role x", packet_length=10, is_com_multi=false, is_next_command=false) at /10.2/sql/sql_parse.cc:1831 #11 0x000055d6d00e5f07 in do_command (thd=0x7f636c000d50) at /10.2/sql/sql_parse.cc:1385 #12 0x000055d6d023bbad in do_handle_one_connection (connect=0x55d6d3b18200) at /10.2/sql/sql_connect.cc:1336 #13 0x000055d6d023b918 in handle_one_connection (arg=0x55d6d3b18200) at /10.2/sql/sql_connect.cc:1241 #14 0x000055d6d0a51ac1 in pfs_spawn_thread (arg=0x55d6d3b424e0) at /10.2/storage/perfschema/pfs.cc:1869 #15 0x00007f6385f526db in start_thread (arg=0x7f637ec1c700) at pthread_create.c:463 #16 0x00007f638533c88f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 5 (Thread 0x7f637ec67700 (LWP 11198)): #0 0x00007f6385f589f3 in futex_wait_cancelable (private=<optimized out>, expected=0, futex_word=0x55d6d169edec <COND_slave_background+44>) at ../sysdeps/unix/sysv/linux/futex-internal.h:88 #1 __pthread_cond_wait_common (abstime=0x0, mutex=0x55d6d16a1fe8 <LOCK_slave_background+40>, cond=0x55d6d169edc0 <COND_slave_background>) at pthread_cond_wait.c:502 #2 __pthread_cond_wait (cond=0x55d6d169edc0 <COND_slave_background>, mutex=0x55d6d16a1fe8 <LOCK_slave_background+40>) at pthread_cond_wait.c:655 #3 0x000055d6d0b03fe3 in safe_cond_wait (cond=0x55d6d169edc0 <COND_slave_background>, mp=0x55d6d16a1fc0 <LOCK_slave_background>, file=0x55d6d0b74a00 "/10.2/include/mysql/psi/mysql_thread.h", line=1145) at /10.2/mysys/thr_mutex.c:491 #4 0x000055d6d0021570 in inline_mysql_cond_wait (that=0x55d6d169edc0 <COND_slave_background>, mutex=0x55d6d16a1fc0 <LOCK_slave_background>, src_file=0x55d6d0b752e8 "/10.2/sql/slave.cc", src_line=337) at /10.2/include/mysql/psi/mysql_thread.h:1145 #5 0x000055d6d00221bb in handle_slave_background (arg=0x0) at /10.2/sql/slave.cc:337 #6 0x000055d6d0a51ac1 in pfs_spawn_thread (arg=0x55d6d3af4350) at /10.2/storage/perfschema/pfs.cc:1869 #7 0x00007f6385f526db in start_thread (arg=0x7f637ec67700) at pthread_create.c:463 #8 0x00007f638533c88f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 4 (Thread 0x7f637ecb2700 (LWP 11197)): #0 0x00007f638525b26c in __GI___sigtimedwait (set=<optimized out>, set@entry=0x7f637ecb1d90, info=info@entry=0x7f637ecb1ca0, timeout=timeout@entry=0x0) at ../sysdeps/unix/sysv/linux/sigtimedwait.c:42 #1 0x00007f6385f5d45c in __sigwait (set=0x7f637ecb1d90, sig=0x7f637ecb1d60) at ../sysdeps/unix/sysv/linux/sigwait.c:28 #2 0x000055d6cfff8922 in signal_hand (arg=0x0) at /10.2/sql/mysqld.cc:3509 #3 0x000055d6d0a51ac1 in pfs_spawn_thread (arg=0x55d6d3ae97e0) at /10.2/storage/perfschema/pfs.cc:1869 #4 0x00007f6385f526db in start_thread (arg=0x7f637ecb2700) at pthread_create.c:463 #5 0x00007f638533c88f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 3 (Thread 0x7f637f4b3700 (LWP 11195)): #0 0x00007f6385f58f85 in futex_abstimed_wait_cancelable (private=<optimized out>, abstime=0x7f637f4b2d60, expected=0, futex_word=0x55d6d1f23b08 <COND_checkpoint+40>) at ../sysdeps/unix/sysv/linux/futex-internal.h:205 #1 __pthread_cond_wait_common (abstime=0x7f637f4b2d60, mutex=0x55d6d1f23a48 <LOCK_checkpoint+40>, cond=0x55d6d1f23ae0 <COND_checkpoint>) at pthread_cond_wait.c:539 #2 __pthread_cond_timedwait (cond=0x55d6d1f23ae0 <COND_checkpoint>, mutex=0x55d6d1f23a48 <LOCK_checkpoint+40>, abstime=0x7f637f4b2d60) at pthread_cond_wait.c:667 #3 0x000055d6d0b043a3 in safe_cond_timedwait (cond=0x55d6d1f23ae0 <COND_checkpoint>, mp=0x55d6d1f23a20 <LOCK_checkpoint>, abstime=0x7f637f4b2d60, file=0x55d6d0e25080 "/10.2/include/mysql/psi/mysql_thread.h", line=1182) at /10.2/mysys/thr_mutex.c:545 #4 0x000055d6d0930c13 in inline_mysql_cond_timedwait (that=0x55d6d1f23ae0 <COND_checkpoint>, mutex=0x55d6d1f23a20 <LOCK_checkpoint>, abstime=0x7f637f4b2d60, src_file=0x55d6d0e250b8 "/10.2/storage/maria/ma_servicethread.c", src_line=116) at /10.2/include/mysql/psi/mysql_thread.h:1182 #5 0x000055d6d0931115 in my_service_thread_sleep (control=0x55d6d14e0a00 <checkpoint_control>, sleep_time=30000000000) at /10.2/storage/maria/ma_servicethread.c:115 #6 0x000055d6d0925b80 in ma_checkpoint_background (arg=0x1e) at /10.2/storage/maria/ma_checkpoint.c:709 #7 0x000055d6d0a51ac1 in pfs_spawn_thread (arg=0x55d6d3ae6920) at /10.2/storage/perfschema/pfs.cc:1869 #8 0x00007f6385f526db in start_thread (arg=0x7f637f4b3700) at pthread_create.c:463 #9 0x00007f638533c88f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 2 (Thread 0x7f638081d700 (LWP 11194)): #0 0x00007f6385f58f85 in futex_abstimed_wait_cancelable (private=<optimized out>, abstime=0x7f638081ce10, expected=0, futex_word=0x55d6d1f351a8 <COND_timer+40>) at ../sysdeps/unix/sysv/linux/futex-internal.h:205 #1 __pthread_cond_wait_common (abstime=0x7f638081ce10, mutex=0x55d6d1f350e8 <LOCK_timer+40>, cond=0x55d6d1f35180 <COND_timer>) at pthread_cond_wait.c:539 #2 __pthread_cond_timedwait (cond=0x55d6d1f35180 <COND_timer>, mutex=0x55d6d1f350e8 <LOCK_timer+40>, abstime=0x7f638081ce10) at pthread_cond_wait.c:667 #3 0x000055d6d0b043a3 in safe_cond_timedwait (cond=0x55d6d1f35180 <COND_timer>, mp=0x55d6d1f350c0 <LOCK_timer>, abstime=0x7f638081ce10, file=0x55d6d0e68950 "/10.2/include/mysql/psi/mysql_thread.h", line=1182) at /10.2/mysys/thr_mutex.c:545 #4 0x000055d6d0b05318 in inline_mysql_cond_timedwait (that=0x55d6d1f35180 <COND_timer>, mutex=0x55d6d1f350c0 <LOCK_timer>, abstime=0x7f638081ce10, src_file=0x55d6d0e68988 "/10.2/mysys/thr_timer.c", src_line=292) at /10.2/include/mysql/psi/mysql_thread.h:1182 #5 0x000055d6d0b05e25 in timer_handler (arg=0x0) at /10.2/mysys/thr_timer.c:292 #6 0x000055d6d0a51ac1 in pfs_spawn_thread (arg=0x55d6d3a03bf0) at /10.2/storage/perfschema/pfs.cc:1869 #7 0x00007f6385f526db in start_thread (arg=0x7f638081d700) at pthread_create.c:463 #8 0x00007f638533c88f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Thread 1 (Thread 0x7f63876e53c0 (LWP 11192)): #0 0x00007f638532fbf9 in __GI___poll (fds=0x7ffd691eeb60, nfds=2, timeout=-1) at ../sysdeps/unix/sysv/linux/poll.c:29 #1 0x000055d6cfffe75d in handle_connections_sockets () at /10.2/sql/mysqld.cc:6667 #2 0x000055d6cfffda33 in mysqld_main (argc=129, argv=0x55d6d38e43d0) at /10.2/sql/mysqld.cc:6133 #3 0x000055d6cfff22aa in main (argc=7, argv=0x7ffd691eee58) at /10.2/sql/main.cc:25

People

Assignee:: Sergei Golubchik

Reporter:: Ian Gilfillan

Votes:: 0 Vote for this issue

Watchers:: 4 Start watching this issue

Dates

Created:: 2020-06-19 21:26

Updated:: 2021-01-12 09:23

Resolved:: 2021-01-12 09:23

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server