Server crashes in MYSQL_LOG::is_open upon ALTER on partitioned table

Version: '11.0.1-MariaDB-debug-log'  

230412 10:26:43 [ERROR] mysqld got signal 11 ;

Server version: 11.0.1-MariaDB-debug-log source revision: c600951df9850c1c8e5d067e854983a084b67db3

sql/signal_handler.cc:238(handle_fatal_signal)[0x55ae6cc385d6]

sql/log.h:323(MYSQL_LOG::is_open())[0x55ae6c0e69bf]

sql/sql_table.cc:11930(copy_data_between_tables(THD*, TABLE*, TABLE*, List<Create_field>&, bool, unsigned int, st_order*, unsigned long long*, unsigned long long*, Alter_info::enum_enable_or_disable, Alter_table_ctx*, bool))[0x55ae6c66c938]

sql/sql_table.cc:10986(mysql_alter_table(THD*, st_mysql_const_lex_string const*, st_mysql_const_lex_string const*, Table_specification_st*, TABLE_LIST*, Recreate_info*, Alter_info*, unsigned int, st_order*, bool, bool))[0x55ae6c664933]

sql/sql_alter.cc:563(Sql_cmd_alter_table::execute(THD*))[0x55ae6c827916]

sql/sql_parse.cc:6001(mysql_execute_command(THD*, bool))[0x55ae6c3715f6]

sql/sql_parse.cc:8000(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x55ae6c37e393]

sql/sql_parse.cc:1896(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x55ae6c354c81]

sql/sql_parse.cc:1407(do_command(THD*, bool))[0x55ae6c35198a]

sql/sql_connect.cc:1416(do_handle_one_connection(CONNECT*, bool))[0x55ae6c80a430]

sql/sql_connect.cc:1320(handle_one_connection)[0x55ae6c809d86]

perfschema/pfs.cc:2203(pfs_spawn_thread)[0x55ae6d49f897]

nptl/pthread_create.c:487(start_thread)[0x7f2725da5fa3]

x86_64/clone.S:97(clone)[0x7f27259af06f]

Query (0x6290016a32a8): ALTER  TABLE `t1` REMOVE PARTITIONING

[New LWP 7120]

[New LWP 7121]

[New LWP 7122]

[New LWP 7123]

[New LWP 7143]

[New LWP 7144]

[New LWP 7152]

[New LWP 7153]

[New LWP 7162]

[New LWP 7163]

[New LWP 7164]

[New LWP 7168]

[New LWP 7169]

[New LWP 7171]

[New LWP 7172]

[Thread debugging using libthread_db enabled]

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

0x00007f3c943936f9 in __GI___poll (fds=0x6120000255c8, nfds=3, timeout=-1) at ../sysdeps/unix/sysv/linux/poll.c:29

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

Thread 16 (Thread 0x7f3c62d27700 (LWP 7172)):

#0  0x00007f3c943936f9 in __GI___poll (fds=0x7f3c62d26580, nfds=1, timeout=28800000) at ../sysdeps/unix/sysv/linux/poll.c:29

#1  0x00007f3c94c16bd2 in poll () from /lib/x86_64-linux-gnu/libasan.so.5

#2  0x000056183ddf52c8 in vio_io_wait (vio=0x616000cb0e08, event=VIO_IO_EVENT_READ, timeout=28800000) at /11.0/vio/viosocket.c:948

#3  0x000056183ddf1202 in vio_socket_io_wait (vio=0x616000cb0e08, event=VIO_IO_EVENT_READ) at /11.0/vio/viosocket.c:116

#4  0x000056183ddf15ac in vio_read (vio=0x616000cb0e08, buf=0x62900039d288 "\002", size=4) at /11.0/vio/viosocket.c:182

#5  0x000056183dd36acb in my_real_read (net=0x62b0001b95c8, complen=0x7f3c62d269e0, header=1 '\001') at /11.0/sql/net_serv.cc:1005

#6  0x000056183dd3853f in my_net_read_packet_reallen (net=0x62b0001b95c8, read_from_server=1 '\001', reallen=0x7f3c62d26a80) at /11.0/sql/net_serv.cc:1286

#7  0x000056183dd383b1 in my_net_read_packet (net=0x62b0001b95c8, read_from_server=1 '\001') at /11.0/sql/net_serv.cc:1270

#8  0x000056183d039a42 in do_command (thd=0x62b0001b9288, blocking=true) at /11.0/sql/sql_parse.cc:1263

#9  0x000056183d4f3430 in do_handle_one_connection (connect=0x611000034008, put_in_cache=true) at /11.0/sql/sql_connect.cc:1416

#10 0x000056183d4f2d86 in handle_one_connection (arg=0x611000034008) at /11.0/sql/sql_connect.cc:1318

#11 0x000056183e188897 in pfs_spawn_thread (arg=0x618000008108) at /11.0/storage/perfschema/pfs.cc:2201

#12 0x00007f3c94794fa3 in start_thread (arg=<optimized out>) at pthread_create.c:486

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

Thread 15 (Thread 0x7f3c62e3f700 (LWP 7171)):

#0  futex_abstimed_wait_cancelable (private=0, abstime=0x7f3c62e37fc0, expected=0, futex_word=0x62b0001ab4bc) at ../sysdeps/unix/sysv/linux/futex-internal.h:205

#1  __pthread_cond_wait_common (abstime=0x7f3c62e37fc0, mutex=0x62b0001ab408, cond=0x62b0001ab490) at pthread_cond_wait.c:539

#2  __pthread_cond_timedwait (cond=0x62b0001ab490, mutex=0x62b0001ab408, abstime=0x7f3c62e37fc0) at pthread_cond_wait.c:667

#3  0x000056183ed7d8d1 in safe_cond_timedwait (cond=0x62b0001ab490, mp=0x62b0001ab3e0, abstime=0x7f3c62e37fc0, file=0x56183f2d6280 "/11.0/include/mysql/psi/mysql_thread.h", line=1088) at /11.0/mysys/thr_mutex.c:548

#4  0x000056183d515a39 in inline_mysql_cond_timedwait (that=0x62b0001ab490, mutex=0x62b0001ab3e0, abstime=0x7f3c62e37fc0, src_file=0x56183f2da220 "/11.0/sql/mdl.cc", src_line=1208) at /11.0/include/mysql/psi/mysql_thread.h:1088

#5  0x000056183d518676 in MDL_wait::timed_wait (this=0x62b0001ab3e0, owner=0x62b0001ab370, abs_timeout=0x7f3c62e37fc0, set_status_on_timeout=false, wait_state_name=0x561840912750 <MDL_key::m_namespace_to_wait_state_name+48>) at /11.0/sql/mdl.cc:1207

#6  0x000056183d51cf58 in MDL_context::acquire_lock (this=0x62b0001ab3e0, mdl_request=0x7f3c62e381b0, lock_wait_timeout=86400) at /11.0/sql/mdl.cc:2401

#7  0x000056183d51e130 in MDL_context::upgrade_shared_lock (this=0x62b0001ab3e0, mdl_ticket=0x6070000943d0, new_type=MDL_EXCLUSIVE, lock_wait_timeout=86400) at /11.0/sql/mdl.cc:2610

#8  0x000056183ce9727f in wait_while_table_is_used (thd=0x62b0001ab288, table=0x619000151408, function=HA_EXTRA_PREPARE_FOR_RENAME) at /11.0/sql/sql_base.cc:1352

#9  0x000056183d33522b in mysql_inplace_alter_table (thd=0x62b0001ab288, table_list=0x6290003984b0, table=0x619000151408, altered_table=0x7f3c62e3a370, ha_alter_info=0x7f3c62e398b0, target_mdl_request=0x7f3c62e39990, ddl_log_state=0x7f3c62e395f0, trigger_param=0x7f3c62e3a770, alter_ctx=0x7f3c62e3b1b0, partial_alter=@0x7f3c62e38f70: false, start_alter_id=@0x7f3c62e39030: 0, if_exists=false) at /11.0/sql/sql_table.cc:7694

#10 0x000056183d34c544 in mysql_alter_table (thd=0x62b0001ab288, new_db=0x62b0001affa0, new_name=0x62b0001b03e8, create_info=0x7f3c62e3c140, table_list=0x6290003984b0, recreate_info=0x7f3c62e3bf60, alter_info=0x7f3c62e3c020, order_num=0, order=0x0, ignore=false, if_exists=false) at /11.0/sql/sql_table.cc:10813

#11 0x000056183d510916 in Sql_cmd_alter_table::execute (this=0x629000398be0, thd=0x62b0001ab288) at /11.0/sql/sql_alter.cc:563

#12 0x000056183d05a5f6 in mysql_execute_command (thd=0x62b0001ab288, is_called_from_prepared_stmt=false) at /11.0/sql/sql_parse.cc:6001

#13 0x000056183d067393 in mysql_parse (thd=0x62b0001ab288, rawbuf=0x6290003982a8 "ALTER /* QNO 977 CON_ID 12 */ TABLE `table10_myisam_int_autoinc` ROW_FORMAT=DYNAMIC", length=83, parser_state=0x7f3c62e3daf0) at /11.0/sql/sql_parse.cc:8000

#14 0x000056183d03dc81 in dispatch_command (command=COM_QUERY, thd=0x62b0001ab288, packet=0x62900038e289 "ALTER /* QNO 977 CON_ID 12 */ TABLE `table10_myisam_int_autoinc` ROW_FORMAT=DYNAMIC", packet_length=83, blocking=true) at /11.0/sql/sql_parse.cc:1894

#15 0x000056183d03a98a in do_command (thd=0x62b0001ab288, blocking=true) at /11.0/sql/sql_parse.cc:1407

#16 0x000056183d4f3430 in do_handle_one_connection (connect=0x611000033ec8, put_in_cache=true) at /11.0/sql/sql_connect.cc:1416

#17 0x000056183d4f2d86 in handle_one_connection (arg=0x611000033ec8) at /11.0/sql/sql_connect.cc:1318

#18 0x000056183e188897 in pfs_spawn_thread (arg=0x618000007d08) at /11.0/storage/perfschema/pfs.cc:2201

#19 0x00007f3c94794fa3 in start_thread (arg=<optimized out>) at pthread_create.c:486

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

Thread 14 (Thread 0x7f3c63453700 (LWP 7169)):

#0  0x00007f3c943936f9 in __GI___poll (fds=0x7f3c63452580, nfds=1, timeout=28800000) at ../sysdeps/unix/sysv/linux/poll.c:29

#1  0x00007f3c94c16bd2 in poll () from /lib/x86_64-linux-gnu/libasan.so.5

#2  0x000056183ddf52c8 in vio_io_wait (vio=0x616000a60f08, event=VIO_IO_EVENT_READ, timeout=28800000) at /11.0/vio/viosocket.c:948

#3  0x000056183ddf1202 in vio_socket_io_wait (vio=0x616000a60f08, event=VIO_IO_EVENT_READ) at /11.0/vio/viosocket.c:116

#4  0x000056183ddf15ac in vio_read (vio=0x616000a60f08, buf=0x62900029e288 "\002", size=4) at /11.0/vio/viosocket.c:182

#5  0x000056183dd36acb in my_real_read (net=0x62b00019d5c8, complen=0x7f3c634529e0, header=1 '\001') at /11.0/sql/net_serv.cc:1005

#6  0x000056183dd3853f in my_net_read_packet_reallen (net=0x62b00019d5c8, read_from_server=1 '\001', reallen=0x7f3c63452a80) at /11.0/sql/net_serv.cc:1286

#7  0x000056183dd383b1 in my_net_read_packet (net=0x62b00019d5c8, read_from_server=1 '\001') at /11.0/sql/net_serv.cc:1270

#8  0x000056183d039a42 in do_command (thd=0x62b00019d288, blocking=true) at /11.0/sql/sql_parse.cc:1263

#9  0x000056183d4f3430 in do_handle_one_connection (connect=0x611000033d88, put_in_cache=true) at /11.0/sql/sql_connect.cc:1416

#10 0x000056183d4f2d86 in handle_one_connection (arg=0x611000033d88) at /11.0/sql/sql_connect.cc:1318

#11 0x000056183e188897 in pfs_spawn_thread (arg=0x618000007908) at /11.0/storage/perfschema/pfs.cc:2201

#12 0x00007f3c94794fa3 in start_thread (arg=<optimized out>) at pthread_create.c:486

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

Thread 13 (Thread 0x7f3c6356b700 (LWP 7168)):

#0  futex_abstimed_wait_cancelable (private=0, abstime=0x7f3c63567a20, expected=0, futex_word=0x61300020ffb4) at ../sysdeps/unix/sysv/linux/futex-internal.h:205

#1  __pthread_cond_wait_common (abstime=0x7f3c63567a20, mutex=0x61e000001cd0, cond=0x61300020ff88) at pthread_cond_wait.c:539

#2  __pthread_cond_timedwait (cond=0x61300020ff88, mutex=0x61e000001cd0, abstime=0x7f3c63567a20) at pthread_cond_wait.c:667

#3  0x000056183ed7d8d1 in safe_cond_timedwait (cond=0x61300020ff88, mp=0x61e000001ca8, abstime=0x7f3c63567a20, file=0x56183ff837a0 "/11.0/include/mysql/psi/mysql_thread.h", line=1088) at /11.0/mysys/thr_mutex.c:548

#4  0x000056183ed744a2 in inline_mysql_cond_timedwait (that=0x61300020ff88, mutex=0x61e000001ca8, abstime=0x7f3c63567a20, src_file=0x56183ff83800 "/11.0/mysys/thr_lock.c", src_line=558) at /11.0/include/mysql/psi/mysql_thread.h:1088

#5  0x000056183ed752ff in wait_for_lock (wait=0x61e000001d78, data=0x61f00019b8d0, in_wait_list=0 '\000', lock_wait_timeout=86400) at /11.0/mysys/thr_lock.c:558

#6  0x000056183ed76e80 in thr_lock (data=0x61f00019b8d0, owner=0x62b000191030, lock_wait_timeout=86400) at /11.0/mysys/thr_lock.c:890

#7  0x000056183ed78796 in thr_multi_lock (data=0x62900029a668, count=1, owner=0x62b000191030, lock_wait_timeout=86400) at /11.0/mysys/thr_lock.c:1171

#8  0x000056183dcb2bc3 in mysql_lock_tables (thd=0x62b00018f288, sql_lock=0x62900029a640, flags=0) at /11.0/sql/lock.cc:352

#9  0x000056183dcb2764 in mysql_lock_tables (thd=0x62b00018f288, tables=0x62900029a630, count=1, flags=0) at /11.0/sql/lock.cc:304

#10 0x000056183ceaf9fc in lock_tables (thd=0x62b00018f288, tables=0x6290002994d8, count=1, flags=0) at /11.0/sql/sql_base.cc:5819

#11 0x000056183d3bce62 in mysql_update (thd=0x62b00018f288, table_list=0x6290002994d8, fields=..., values=..., conds=0x62900029a218, order_num=0, order=0x0, limit=18446744073709551615, ignore=true, found_return=0x7f3c63568e70, updated_return=0x7f3c63568eb0) at /11.0/sql/sql_update.cc:442

#12 0x000056183d04e163 in mysql_execute_command (thd=0x62b00018f288, is_called_from_prepared_stmt=false) at /11.0/sql/sql_parse.cc:4412

#13 0x000056183d067393 in mysql_parse (thd=0x62b00018f288, rawbuf=0x6290002992a8 "UPDATE /* QNO 846 CON_ID 10 */ IGNORE `table10_myisam_int_autoinc` SET `pk` = `pk` + 1 WHERE `pk` = 24715", length=105, parser_state=0x7f3c63569af0) at /11.0/sql/sql_parse.cc:8000

#14 0x000056183d03dc81 in dispatch_command (command=COM_QUERY, thd=0x62b00018f288, packet=0x62900028f289 "UPDATE /* QNO 846 CON_ID 10 */ IGNORE `table10_myisam_int_autoinc` SET `pk` = `pk` + 1 WHERE `pk` = 24715", packet_length=105, blocking=true) at /11.0/sql/sql_parse.cc:1894

#15 0x000056183d03a98a in do_command (thd=0x62b00018f288, blocking=true) at /11.0/sql/sql_parse.cc:1407

#16 0x000056183d4f3430 in do_handle_one_connection (connect=0x611000033c48, put_in_cache=true) at /11.0/sql/sql_connect.cc:1416

#17 0x000056183d4f2d86 in handle_one_connection (arg=0x611000033c48) at /11.0/sql/sql_connect.cc:1318

#18 0x000056183e188897 in pfs_spawn_thread (arg=0x618000007508) at /11.0/storage/perfschema/pfs.cc:2201

#19 0x00007f3c94794fa3 in start_thread (arg=<optimized out>) at pthread_create.c:486

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

Thread 12 (Thread 0x7f3c64c80700 (LWP 7164)):

#0  0x00007f3c943936f9 in __GI___poll (fds=0x7f3c64c7f580, nfds=1, timeout=28800000) at ../sysdeps/unix/sysv/linux/poll.c:29

#1  0x00007f3c94c16bd2 in poll () from /lib/x86_64-linux-gnu/libasan.so.5

#2  0x000056183ddf52c8 in vio_io_wait (vio=0x616000438d08, event=VIO_IO_EVENT_READ, timeout=28800000) at /11.0/vio/viosocket.c:948

#3  0x000056183ddf1202 in vio_socket_io_wait (vio=0x616000438d08, event=VIO_IO_EVENT_READ) at /11.0/vio/viosocket.c:116

#4  0x000056183ddf15ac in vio_read (vio=0x616000438d08, buf=0x629000212288 "\002", size=4) at /11.0/vio/viosocket.c:182

#5  0x000056183dd36acb in my_real_read (net=0x62b00017a5c8, complen=0x7f3c64c7f9e0, header=1 '\001') at /11.0/sql/net_serv.cc:1005

#6  0x000056183dd3853f in my_net_read_packet_reallen (net=0x62b00017a5c8, read_from_server=1 '\001', reallen=0x7f3c64c7fa80) at /11.0/sql/net_serv.cc:1286

#7  0x000056183dd383b1 in my_net_read_packet (net=0x62b00017a5c8, read_from_server=1 '\001') at /11.0/sql/net_serv.cc:1270

#8  0x000056183d039a42 in do_command (thd=0x62b00017a288, blocking=true) at /11.0/sql/sql_parse.cc:1263

#9  0x000056183d4f3430 in do_handle_one_connection (connect=0x611000033b08, put_in_cache=true) at /11.0/sql/sql_connect.cc:1416

#10 0x000056183d4f2d86 in handle_one_connection (arg=0x611000033608) at /11.0/sql/sql_connect.cc:1318

#11 0x000056183e188897 in pfs_spawn_thread (arg=0x618000007108) at /11.0/storage/perfschema/pfs.cc:2201

#12 0x00007f3c94794fa3 in start_thread (arg=<optimized out>) at pthread_create.c:486

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

Thread 11 (Thread 0x7f3c64d98700 (LWP 7163)):

#0  0x00007f3c943936f9 in __GI___poll (fds=0x7f3c64d97580, nfds=1, timeout=28800000) at ../sysdeps/unix/sysv/linux/poll.c:29

#1  0x00007f3c94c16bd2 in poll () from /lib/x86_64-linux-gnu/libasan.so.5

#2  0x000056183ddf52c8 in vio_io_wait (vio=0x616000878e08, event=VIO_IO_EVENT_READ, timeout=28800000) at /11.0/vio/viosocket.c:948

#3  0x000056183ddf1202 in vio_socket_io_wait (vio=0x616000878e08, event=VIO_IO_EVENT_READ) at /11.0/vio/viosocket.c:116

#4  0x000056183ddf15ac in vio_read (vio=0x616000878e08, buf=0x629000244288 "\002", size=4) at /11.0/vio/viosocket.c:182

#5  0x000056183dd36acb in my_real_read (net=0x62b00016c5c8, complen=0x7f3c64d979e0, header=1 '\001') at /11.0/sql/net_serv.cc:1005

#6  0x000056183dd3853f in my_net_read_packet_reallen (net=0x62b00016c5c8, read_from_server=1 '\001', reallen=0x7f3c64d97a80) at /11.0/sql/net_serv.cc:1286

#7  0x000056183dd383b1 in my_net_read_packet (net=0x62b00016c5c8, read_from_server=1 '\001') at /11.0/sql/net_serv.cc:1270

#8  0x000056183d039a42 in do_command (thd=0x62b00016c288, blocking=true) at /11.0/sql/sql_parse.cc:1263

#9  0x000056183d4f3430 in do_handle_one_connection (connect=0x6110000339c8, put_in_cache=true) at /11.0/sql/sql_connect.cc:1416

#10 0x000056183d4f2d86 in handle_one_connection (arg=0x6110000334c8) at /11.0/sql/sql_connect.cc:1318

#11 0x000056183e188897 in pfs_spawn_thread (arg=0x618000006d08) at /11.0/storage/perfschema/pfs.cc:2201

#12 0x00007f3c94794fa3 in start_thread (arg=<optimized out>) at pthread_create.c:486

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

Thread 10 (Thread 0x7f3c65343700 (LWP 7162)):

#0  0x00007f3c943936f9 in __GI___poll (fds=0x7f3c65342580, nfds=1, timeout=28800000) at ../sysdeps/unix/sysv/linux/poll.c:29

#1  0x00007f3c94c16bd2 in poll () from /lib/x86_64-linux-gnu/libasan.so.5

#2  0x000056183ddf52c8 in vio_io_wait (vio=0x616000391008, event=VIO_IO_EVENT_READ, timeout=28800000) at /11.0/vio/viosocket.c:948

#3  0x000056183ddf1202 in vio_socket_io_wait (vio=0x616000391008, event=VIO_IO_EVENT_READ) at /11.0/vio/viosocket.c:116

#4  0x000056183ddf15ac in vio_read (vio=0x616000391008, buf=0x6290000dc288 "t_attrs_size\002-1(", size=4) at /11.0/vio/viosocket.c:182

#5  0x000056183dd36acb in my_real_read (net=0x62b00015e5c8, complen=0x7f3c653429e0, header=1 '\001') at /11.0/sql/net_serv.cc:1005

#6  0x000056183dd3853f in my_net_read_packet_reallen (net=0x62b00015e5c8, read_from_server=1 '\001', reallen=0x7f3c65342a80) at /11.0/sql/net_serv.cc:1286

#7  0x000056183dd383b1 in my_net_read_packet (net=0x62b00015e5c8, read_from_server=1 '\001') at /11.0/sql/net_serv.cc:1270

#8  0x000056183d039a42 in do_command (thd=0x62b00015e288, blocking=true) at /11.0/sql/sql_parse.cc:1263

#9  0x000056183d4f3430 in do_handle_one_connection (connect=0x611000033388, put_in_cache=true) at /11.0/sql/sql_connect.cc:1416

#10 0x000056183d4f2d86 in handle_one_connection (arg=0x611000033388) at /11.0/sql/sql_connect.cc:1318

#11 0x000056183e188897 in pfs_spawn_thread (arg=0x618000006908) at /11.0/storage/perfschema/pfs.cc:2201

#12 0x00007f3c94794fa3 in start_thread (arg=<optimized out>) at pthread_create.c:486

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

Thread 9 (Thread 0x7f3c6549b700 (LWP 7153)):

#0  0x00007f3c942dd5fc in __GI___sigtimedwait (set=0x7f3c6549abd0, info=0x7f3c6549a980, timeout=0x0) at ../sysdeps/unix/sysv/linux/sigtimedwait.c:29

#1  0x00007f3c94c10f7d in ?? () from /lib/x86_64-linux-gnu/libasan.so.5

#2  0x000056183cc8ab49 in my_sigwait (set=0x7f3c6549abd0, sig=0x7f3c6549aa90, code=0x7f3c6549aad0) at /11.0/include/my_pthread.h:195

#3  0x000056183cc9998d in signal_hand (arg=0x0) at /11.0/sql/mysqld.cc:3261

#4  0x000056183e188897 in pfs_spawn_thread (arg=0x618000003d08) at /11.0/storage/perfschema/pfs.cc:2201

#5  0x00007f3c94794fa3 in start_thread (arg=<optimized out>) at pthread_create.c:486

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

Thread 8 (Thread 0x7f3c655d5700 (LWP 7152)):

#0  futex_wait_cancelable (private=0, expected=0, futex_word=0x5618415074ac <COND_manager+44>) at ../sysdeps/unix/sysv/linux/futex-internal.h:88

#1  __pthread_cond_wait_common (abstime=0x0, mutex=0x5618415073c8 <LOCK_manager+40>, cond=0x561841507480 <COND_manager>) at pthread_cond_wait.c:502

#2  __pthread_cond_wait (cond=0x561841507480 <COND_manager>, mutex=0x5618415073c8 <LOCK_manager+40>) at pthread_cond_wait.c:655

#3  0x000056183ed7d019 in safe_cond_wait (cond=0x561841507480 <COND_manager>, mp=0x5618415073a0 <LOCK_manager>, file=0x56183f105600 "/11.0/include/mysql/psi/mysql_thread.h", line=1072) at /11.0/mysys/thr_mutex.c:494

#4  0x000056183d030861 in inline_mysql_cond_wait (that=0x561841507480 <COND_manager>, mutex=0x5618415073a0 <LOCK_manager>, src_file=0x56183f108340 "/11.0/sql/sql_manager.cc", src_line=103) at /11.0/include/mysql/psi/mysql_thread.h:1072

#5  0x000056183d030ef0 in handle_manager (arg=0x0) at /11.0/sql/sql_manager.cc:103

#6  0x000056183e188897 in pfs_spawn_thread (arg=0x618000003108) at /11.0/storage/perfschema/pfs.cc:2201

#7  0x00007f3c94794fa3 in start_thread (arg=<optimized out>) at pthread_create.c:486

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

Thread 7 (Thread 0x7f3c6968e700 (LWP 7144)):

#0  futex_abstimed_wait_cancelable (private=0, abstime=0x7f3c6968d790, expected=0, futex_word=0x630000000e2c) at ../sysdeps/unix/sysv/linux/futex-internal.h:205

#1  __pthread_cond_wait_common (abstime=0x7f3c6968d790, mutex=0x618000000d98, cond=0x630000000e00) at pthread_cond_wait.c:539

#2  __pthread_cond_timedwait (cond=0x630000000e00, mutex=0x618000000d98, abstime=0x7f3c6968d790) at pthread_cond_wait.c:667

#3  0x000056183eba9e55 in __gthread_cond_timedwait (__cond=0x630000000e00, __mutex=0x618000000d98, __abs_timeout=0x7f3c6968d790) at /usr/include/x86_64-linux-gnu/c++/8/bits/gthr-default.h:871

#4  0x000056183ebb1345 in std::condition_variable::__wait_until_impl<std::chrono::duration<long, std::ratio<1l, 1000000000l> > > (this=0x630000000e00, __lock=..., __atime=...) at /usr/include/c++/8/condition_variable:178

#5  0x000056183ebaec47 in std::condition_variable::wait_until<std::chrono::duration<long, std::ratio<1l, 1000000000l> > > (this=0x630000000e00, __lock=..., __atime=...) at /usr/include/c++/8/condition_variable:106

#6  0x000056183ebac9df in std::condition_variable::wait_for<long, std::ratio<1l, 1000l> > (this=0x630000000e00, __lock=..., __rtime=...) at /usr/include/c++/8/condition_variable:143

#7  0x000056183eba61d4 in tpool::thread_pool_generic::wait_for_tasks (this=0x618000000c80, lk=..., thread_data=0x630000000e00) at /11.0/tpool/tpool_generic.cc:480

#8  0x000056183eba662b in tpool::thread_pool_generic::get_task (this=0x618000000c80, thread_var=0x630000000e00, t=0x7f3c6968da80) at /11.0/tpool/tpool_generic.cc:533

#9  0x000056183eba6c51 in tpool::thread_pool_generic::worker_main (this=0x618000000c80, thread_var=0x630000000e00) at /11.0/tpool/tpool_generic.cc:578

#10 0x000056183ebafcf0 in std::__invoke_impl<void, void (tpool::thread_pool_generic::*)(tpool::worker_data*), tpool::thread_pool_generic*, tpool::worker_data*> (__f=@0x6040000024a8: (void (tpool::thread_pool_generic::*)(class tpool::thread_pool_generic * const, struct tpool::worker_data *)) 0x56183eba6b32 <tpool::thread_pool_generic::worker_main(tpool::worker_data*)>, __t=@0x6040000024a0: 0x618000000c80, __args#0=@0x604000002498: 0x630000000e00) at /usr/include/c++/8/bits/invoke.h:73

#11 0x000056183ebad4f8 in std::__invoke<void (tpool::thread_pool_generic::*)(tpool::worker_data*), tpool::thread_pool_generic*, tpool::worker_data*> (__fn=@0x6040000024a8: (void (tpool::thread_pool_generic::*)(class tpool::thread_pool_generic * const, struct tpool::worker_data *)) 0x56183eba6b32 <tpool::thread_pool_generic::worker_main(tpool::worker_data*)>, __args#0=@0x6040000024a0: 0x618000000c80, __args#1=@0x604000002498: 0x630000000e00) at /usr/include/c++/8/bits/invoke.h:95

#12 0x000056183ebb5443 in std::thread::_Invoker<std::tuple<void (tpool::thread_pool_generic::*)(tpool::worker_data*), tpool::thread_pool_generic*, tpool::worker_data*> >::_M_invoke<0ul, 1ul, 2ul> (this=0x604000002498) at /usr/include/c++/8/thread:244

#13 0x000056183ebb5399 in std::thread::_Invoker<std::tuple<void (tpool::thread_pool_generic::*)(tpool::worker_data*), tpool::thread_pool_generic*, tpool::worker_data*> >::operator() (this=0x604000002498) at /usr/include/c++/8/thread:253

#14 0x000056183ebb5308 in std::thread::_State_impl<std::thread::_Invoker<std::tuple<void (tpool::thread_pool_generic::*)(tpool::worker_data*), tpool::thread_pool_generic*, tpool::worker_data*> > >::_M_run (this=0x604000002490) at /usr/include/c++/8/thread:196

#15 0x00007f3c946bfb2f in ?? () from /lib/x86_64-linux-gnu/libstdc++.so.6

#16 0x00007f3c94794fa3 in start_thread (arg=<optimized out>) at pthread_create.c:486

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

Thread 6 (Thread 0x7f3c69ea5700 (LWP 7143)):

#0  futex_abstimed_wait_cancelable (private=0, abstime=0x7f3c69ea4790, expected=0, futex_word=0x630000000da8) at ../sysdeps/unix/sysv/linux/futex-internal.h:205

#1  __pthread_cond_wait_common (abstime=0x7f3c69ea4790, mutex=0x618000000d98, cond=0x630000000d80) at pthread_cond_wait.c:539

#2  __pthread_cond_timedwait (cond=0x630000000d80, mutex=0x618000000d98, abstime=0x7f3c69ea4790) at pthread_cond_wait.c:667

#3  0x000056183eba9e55 in __gthread_cond_timedwait (__cond=0x630000000d80, __mutex=0x618000000d98, __abs_timeout=0x7f3c69ea4790) at /usr/include/x86_64-linux-gnu/c++/8/bits/gthr-default.h:871

#4  0x000056183ebb1345 in std::condition_variable::__wait_until_impl<std::chrono::duration<long, std::ratio<1l, 1000000000l> > > (this=0x630000000d80, __lock=..., __atime=...) at /usr/include/c++/8/condition_variable:178

#5  0x000056183ebaec47 in std::condition_variable::wait_until<std::chrono::duration<long, std::ratio<1l, 1000000000l> > > (this=0x630000000d80, __lock=..., __atime=...) at /usr/include/c++/8/condition_variable:106

#6  0x000056183ebac9df in std::condition_variable::wait_for<long, std::ratio<1l, 1000l> > (this=0x630000000d80, __lock=..., __rtime=...) at /usr/include/c++/8/condition_variable:143

#7  0x000056183eba61d4 in tpool::thread_pool_generic::wait_for_tasks (this=0x618000000c80, lk=..., thread_data=0x630000000d80) at /11.0/tpool/tpool_generic.cc:480

#8  0x000056183eba662b in tpool::thread_pool_generic::get_task (this=0x618000000c80, thread_var=0x630000000d80, t=0x7f3c69ea4a80) at /11.0/tpool/tpool_generic.cc:533

#9  0x000056183eba6c51 in tpool::thread_pool_generic::worker_main (this=0x618000000c80, thread_var=0x630000000d80) at /11.0/tpool/tpool_generic.cc:578

#10 0x000056183ebafcf0 in std::__invoke_impl<void, void (tpool::thread_pool_generic::*)(tpool::worker_data*), tpool::thread_pool_generic*, tpool::worker_data*> (__f=@0x604000002468: (void (tpool::thread_pool_generic::*)(class tpool::thread_pool_generic * const, struct tpool::worker_data *)) 0x56183eba6b32 <tpool::thread_pool_generic::worker_main(tpool::worker_data*)>, __t=@0x604000002460: 0x618000000c80, __args#0=@0x604000002458: 0x630000000d80) at /usr/include/c++/8/bits/invoke.h:73

#11 0x000056183ebad4f8 in std::__invoke<void (tpool::thread_pool_generic::*)(tpool::worker_data*), tpool::thread_pool_generic*, tpool::worker_data*> (__fn=@0x604000002468: (void (tpool::thread_pool_generic::*)(class tpool::thread_pool_generic * const, struct tpool::worker_data *)) 0x56183eba6b32 <tpool::thread_pool_generic::worker_main(tpool::worker_data*)>, __args#0=@0x604000002460: 0x618000000c80, __args#1=@0x604000002458: 0x630000000d80) at /usr/include/c++/8/bits/invoke.h:95

#12 0x000056183ebb5443 in std::thread::_Invoker<std::tuple<void (tpool::thread_pool_generic::*)(tpool::worker_data*), tpool::thread_pool_generic*, tpool::worker_data*> >::_M_invoke<0ul, 1ul, 2ul> (this=0x604000002458) at /usr/include/c++/8/thread:244

#13 0x000056183ebb5399 in std::thread::_Invoker<std::tuple<void (tpool::thread_pool_generic::*)(tpool::worker_data*), tpool::thread_pool_generic*, tpool::worker_data*> >::operator() (this=0x604000002458) at /usr/include/c++/8/thread:253

#14 0x000056183ebb5308 in std::thread::_State_impl<std::thread::_Invoker<std::tuple<void (tpool::thread_pool_generic::*)(tpool::worker_data*), tpool::thread_pool_generic*, tpool::worker_data*> > >::_M_run (this=0x604000002450) at /usr/include/c++/8/thread:196

#15 0x00007f3c946bfb2f in ?? () from /lib/x86_64-linux-gnu/libstdc++.so.6

#16 0x00007f3c94794fa3 in start_thread (arg=<optimized out>) at pthread_create.c:486

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

Thread 5 (Thread 0x7f3c77892700 (LWP 7123)):

#0  futex_wait_cancelable (private=0, expected=0, futex_word=0x5618410bb070 <buf_pool+17584>) at ../sysdeps/unix/sysv/linux/futex-internal.h:88

#1  __pthread_cond_wait_common (abstime=0x0, mutex=0x5618410baf68 <buf_pool+17320>, cond=0x5618410bb048 <buf_pool+17544>) at pthread_cond_wait.c:502

#2  __pthread_cond_wait (cond=0x5618410bb048 <buf_pool+17544>, mutex=0x5618410baf68 <buf_pool+17320>) at pthread_cond_wait.c:655

#3  0x000056183ed7d019 in safe_cond_wait (cond=0x5618410bb048 <buf_pool+17544>, mp=0x5618410baf40 <buf_pool+17280>, file=0x56183fddf5a0 "/11.0/storage/innobase/buf/buf0flu.cc", line=2326) at /11.0/mysys/thr_mutex.c:494

#4  0x000056183e98b949 in buf_flush_page_cleaner () at /11.0/storage/innobase/buf/buf0flu.cc:2326

#5  0x000056183e994696 in std::__invoke_impl<void, void (*)()> (__f=@0x602000000078: 0x56183e98b2b5 <buf_flush_page_cleaner()>) at /usr/include/c++/8/bits/invoke.h:60

#6  0x000056183e993f59 in std::__invoke<void (*)()> (__fn=@0x602000000078: 0x56183e98b2b5 <buf_flush_page_cleaner()>) at /usr/include/c++/8/bits/invoke.h:95

#7  0x000056183e994f12 in std::thread::_Invoker<std::tuple<void (*)()> >::_M_invoke<0ul> (this=0x602000000078) at /usr/include/c++/8/thread:244

#8  0x000056183e994e9f in std::thread::_Invoker<std::tuple<void (*)()> >::operator() (this=0x602000000078) at /usr/include/c++/8/thread:253

#9  0x000056183e994e0e in std::thread::_State_impl<std::thread::_Invoker<std::tuple<void (*)()> > >::_M_run (this=0x602000000070) at /usr/include/c++/8/thread:196

#10 0x00007f3c946bfb2f in ?? () from /lib/x86_64-linux-gnu/libstdc++.so.6

#11 0x00007f3c94794fa3 in start_thread (arg=<optimized out>) at pthread_create.c:486

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

Thread 4 (Thread 0x7f3c802e5700 (LWP 7122)):

#0  syscall () at ../sysdeps/unix/sysv/linux/x86_64/syscall.S:38

#1  0x000056183ebb728b in my_getevents (ctx=0x7f3c802e6000, min_nr=1, nr=256, ev=0x7f3c802e2ad0) at /11.0/tpool/aio_linux.cc:63

#2  0x000056183ebb7821 in tpool::aio_linux::getevent_thread_routine (aio=0x603000000370) at /11.0/tpool/aio_linux.cc:105

#3  0x000056183ebb8a7f in std::__invoke_impl<void, void (*)(tpool::aio_linux*), tpool::aio_linux*> (__f=@0x6030000003b0: 0x56183ebb7741 <tpool::aio_linux::getevent_thread_routine(tpool::aio_linux*)>, __args#0=@0x6030000003a8: 0x603000000370) at /usr/include/c++/8/bits/invoke.h:60

#4  0x000056183ebb8476 in std::__invoke<void (*)(tpool::aio_linux*), tpool::aio_linux*> (__fn=@0x6030000003b0: 0x56183ebb7741 <tpool::aio_linux::getevent_thread_routine(tpool::aio_linux*)>, __args#0=@0x6030000003a8: 0x603000000370) at /usr/include/c++/8/bits/invoke.h:95

#5  0x000056183ebb8edb in std::thread::_Invoker<std::tuple<void (*)(tpool::aio_linux*), tpool::aio_linux*> >::_M_invoke<0ul, 1ul> (this=0x6030000003a8) at /usr/include/c++/8/thread:244

#6  0x000056183ebb8e4d in std::thread::_Invoker<std::tuple<void (*)(tpool::aio_linux*), tpool::aio_linux*> >::operator() (this=0x6030000003a8) at /usr/include/c++/8/thread:253

#7  0x000056183ebb8dbc in std::thread::_State_impl<std::thread::_Invoker<std::tuple<void (*)(tpool::aio_linux*), tpool::aio_linux*> > >::_M_run (this=0x6030000003a0) at /usr/include/c++/8/thread:196

#8  0x00007f3c946bfb2f in ?? () from /lib/x86_64-linux-gnu/libstdc++.so.6

#9  0x00007f3c94794fa3 in start_thread (arg=<optimized out>) at pthread_create.c:486

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

Thread 3 (Thread 0x7f3c80f20700 (LWP 7121)):

#0  futex_abstimed_wait_cancelable (private=0, abstime=0x7f3c80f1fb50, expected=0, futex_word=0x561841d68848 <COND_checkpoint+40>) at ../sysdeps/unix/sysv/linux/futex-internal.h:205

#1  __pthread_cond_wait_common (abstime=0x7f3c80f1fb50, mutex=0x561841d68768 <LOCK_checkpoint+40>, cond=0x561841d68820 <COND_checkpoint>) at pthread_cond_wait.c:539

#2  __pthread_cond_timedwait (cond=0x561841d68820 <COND_checkpoint>, mutex=0x561841d68768 <LOCK_checkpoint+40>, abstime=0x7f3c80f1fb50) at pthread_cond_wait.c:667

#3  0x000056183ed7d8d1 in safe_cond_timedwait (cond=0x561841d68820 <COND_checkpoint>, mp=0x561841d68740 <LOCK_checkpoint>, abstime=0x7f3c80f1fb50, file=0x56183f808ba0 "/11.0/include/mysql/psi/mysql_thread.h", line=1088) at /11.0/mysys/thr_mutex.c:548

#4  0x000056183df96fbe in inline_mysql_cond_timedwait (that=0x561841d68820 <COND_checkpoint>, mutex=0x561841d68740 <LOCK_checkpoint>, abstime=0x7f3c80f1fb50, src_file=0x56183f808c20 "/11.0/storage/maria/ma_servicethread.c", src_line=116) at /11.0/include/mysql/psi/mysql_thread.h:1088

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

#6  0x000056183df7a82a in ma_checkpoint_background (arg=0x1e) at /11.0/storage/maria/ma_checkpoint.c:725

#7  0x00007f3c94794fa3 in start_thread (arg=<optimized out>) at pthread_create.c:486

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

Thread 2 (Thread 0x7f3c91550700 (LWP 7120)):

#0  futex_abstimed_wait_cancelable (private=0, abstime=0x7f3c9154fca0, expected=0, futex_word=0x561841e35f2c <COND_timer+44>) at ../sysdeps/unix/sysv/linux/futex-internal.h:205

#1  __pthread_cond_wait_common (abstime=0x7f3c9154fca0, mutex=0x561841e35e48 <LOCK_timer+40>, cond=0x561841e35f00 <COND_timer>) at pthread_cond_wait.c:539

#2  __pthread_cond_timedwait (cond=0x561841e35f00 <COND_timer>, mutex=0x561841e35e48 <LOCK_timer+40>, abstime=0x7f3c9154fca0) at pthread_cond_wait.c:667

#3  0x000056183ed7d8d1 in safe_cond_timedwait (cond=0x561841e35f00 <COND_timer>, mp=0x561841e35e20 <LOCK_timer>, abstime=0x7f3c9154fca0, file=0x56183ff852e0 "/11.0/include/mysql/psi/mysql_thread.h", line=1088) at /11.0/mysys/thr_mutex.c:548

#4  0x000056183ed80200 in inline_mysql_cond_timedwait (that=0x561841e35f00 <COND_timer>, mutex=0x561841e35e20 <LOCK_timer>, abstime=0x7f3c9154fca0, src_file=0x56183ff85380 "/11.0/mysys/thr_timer.c", src_line=321) at /11.0/include/mysql/psi/mysql_thread.h:1088

#5  0x000056183ed82233 in timer_handler (arg=0x0) at /11.0/mysys/thr_timer.c:321

#6  0x00007f3c94794fa3 in start_thread (arg=<optimized out>) at pthread_create.c:486

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

Thread 1 (Thread 0x7f3c94296940 (LWP 7119)):

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

#1  0x00007f3c94c16bd2 in poll () from /lib/x86_64-linux-gnu/libasan.so.5

#2  0x000056183cca4701 in handle_connections_sockets () at /11.0/sql/mysqld.cc:6315

#3  0x000056183cca2f27 in mysqld_main (argc=16, argv=0x6170000001f8) at /11.0/sql/mysqld.cc:6020

#4  0x000056183cc8a7e5 in main (argc=15, argv=0x7fff2091d538) at /11.0/sql/main.cc:34

query_init_add:

CREATE TABLE IF NOT EXISTS t1 (b int, a int, pk int, KEY (a ASC), PRIMARY KEY (pk)); INSERT ignore INTO  t1 VALUES  (null, 2, 1) ,  (-258342912, null, 2) ,  (6, 115539968, 3) ,  (6, null, 4) ,  (831651840, null, 5) ,  (3, 25821184, 6) ,  (4, -113049600, 7) ,  (null, 1, 8) ,  (3, null, 9) ,  (777060352, null, 10) ,  (-10289152, -1094844416, 11) ,  (null, null, 12) ,  (-1616445440, -1152909312, 13) ,  (-1555300352, 6, 14) ,  (207093760, null, 15) ,  (9, 5898240, 16) ,  (-1439563776, 7, 17) ;

;

thread1:

    ALTER TABLE t1 PARTITION BY HASH(pk) | ALTER TABLE t1 REMOVE PARTITIONING;

thread2:

  #INSERT IGNORE INTO t1 ( pk ) VALUES ( NULL ) |

   UPDATE IGNORE t1 SET a = a + 1 WHERE pk = 3 ;