Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.5
-
None
Description
10.5.11 1de258ea44357787b4cdf3dcbc59c1c7d2c1bf5f |
Core was generated by `/test/mtest/GAL_MD170621-mariadb-10.5.11-linux-x86_64-dbg/bin/mysqld --defaults'.
|
Program terminated with signal SIGSEGV, Segmentation fault.
|
#0 0x0000000070000002 in ?? ()
|
[Current thread is 1 (Thread 0x4f6e03291700 (LWP 1668597))]
|
(gdb) bt
|
#0 0x0000000070000002 in ?? ()
|
#1 0x0000563b371e6766 in _raw_syscall () at /home/roc/rr/rr/src/preload/raw_syscall.S:120
|
#2 0x0000563b371e204e in traced_raw_syscall (call=<optimized out>) at /home/roc/rr/rr/src/preload/syscallbuf.c:272
|
#3 0x0000563b371e54d1 in syscall_hook_internal (call=0x14a7a9d87fa0) at /home/roc/rr/rr/src/preload/syscallbuf.c:3295
|
#4 syscall_hook (call=0x14a7a9d87fa0) at /home/roc/rr/rr/src/preload/syscallbuf.c:3329
|
#5 0x0000563b371e1e50 in _syscall_hook_trampoline () at /home/roc/rr/rr/src/preload/syscall_hook.S:313
|
#6 0x0000563b371e1eaf in __morestack () at /home/roc/rr/rr/src/preload/syscall_hook.S:458
|
#7 0x0000563b371e1f08 in _syscall_hook_trampoline_89_c2_f7_da () at /home/roc/rr/rr/src/preload/syscall_hook.S:504
|
#8 0x00005c577e252f0c in __pthread_kill (threadid=<optimized out>, signo=signo@entry=11) at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
|
#9 0x0000563b386ca2d2 in my_write_core (sig=sig@entry=11) at /test/mtest/10.5_dbg/mysys/stacktrace.c:424
|
#10 0x0000563b37e10622 in handle_fatal_signal (sig=11) at /test/mtest/10.5_dbg/sql/signal_handler.cc:343
|
#11 <signal handler called>
|
#12 __memcmp_avx2_movbe () at ../sysdeps/x86_64/multiarch/memcmp-avx2-movbe.S:182
|
#13 0x0000563b37c95dfd in rpl_sql_thread_info::cached_charset_compare (this=0xa5a5a5a5a5a5a5a5, charset=charset@entry=0x3535740a7ac0 "\b")
|
at /test/mtest/10.5_dbg/sql/rpl_rli.cc:2535
|
#14 0x0000563b37fa54a0 in Query_log_event::do_apply_event (this=0x3535740a79c8, rgi=0x353574149980,
|
query_arg=0x35357414a613 "CREATE TABLE IF NOT EXISTS `v1` (\n `a` int(1) NOT NULL\n)", q_len_arg=57)
|
at /test/mtest/10.5_dbg/sql/log_event_server.cc:1742
|
#15 0x0000563b37fa6b62 in Query_log_event::do_apply_event (this=<optimized out>, rgi=<optimized out>)
|
at /test/mtest/10.5_dbg/sql/log_event_server.cc:1581
|
#16 0x0000563b381e5980 in Log_event::apply_event (rgi=0x353574149980, this=0x3535740a79c8) at /test/mtest/10.5_dbg/sql/log_event.h:1505
|
#17 wsrep_apply_events (thd=thd@entry=0x353574136c28, rli=<optimized out>, events_buf=<optimized out>, buf_len=137)
|
at /test/mtest/10.5_dbg/sql/wsrep_applier.cc:208
|
#18 0x0000563b381c9371 in apply_events (thd=thd@entry=0x353574136c28, rli=<optimized out>, data=..., err=...)
|
at /test/mtest/10.5_dbg/wsrep-lib/include/wsrep/buffer.hpp:48
|
#19 0x0000563b381c96fb in Wsrep_replayer_service::apply_write_set (this=0x4f6e0328fcd0, ws_meta=..., data=..., err=...)
|
at /test/mtest/10.5_dbg/sql/wsrep_high_priority_service.cc:720
|
#20 0x0000563b387f21cd in apply_write_set (server_state=..., high_priority_service=..., ws_handle=..., ws_meta=..., data=...)
|
at /test/mtest/10.5_dbg/wsrep-lib/src/server_state.cpp:327
|
#21 0x0000563b387f3119 in wsrep::server_state::on_apply (this=<optimized out>, high_priority_service=..., ws_handle=..., ws_meta=...,
|
data=...) at /test/mtest/10.5_dbg/wsrep-lib/src/server_state.cpp:1137
|
#22 0x0000563b38800e43 in wsrep::high_priority_service::apply (data=..., ws_meta=..., ws_handle=..., this=0x4f6e0328fcd0)
|
at /test/mtest/10.5_dbg/wsrep-lib/include/wsrep/high_priority_service.hpp:47
|
#23 (anonymous namespace)::apply_cb (ctx=ctx@entry=0x4f6e0328fcd0, wsh=wsh@entry=0x4f6e0328f520, flags=flags@entry=65,
|
buf=buf@entry=0x4f6e0328f530, meta=meta@entry=0x4f6e0328f7e0, exit_loop=exit_loop@entry=0x4f6e0328f7a0)
|
at /test/mtest/10.5_dbg/wsrep-lib/src/wsrep_provider_v26.cpp:504
|
#24 0x000014a7b12f7145 in galera::TrxHandleSlave::apply (this=this@entry=0x3535740d32a0, recv_ctx=recv_ctx@entry=0x4f6e0328fcd0,
|
apply_cb=0x563b38800cc0 <(anonymous namespace)::apply_cb(void*, wsrep_ws_handle_t const*, uint32_t, wsrep_buf_t const*, wsrep_trx_meta_t const*, wsrep_bool_t*)>, meta=..., exit_loop=@0x4f6e0328f7a0: false) at /test/mtest/10.5_galera_dbg/galera/src/trx_handle.cpp:391
|
#25 0x000014a7b130e318 in galera::ReplicatorSMM::replay_trx (this=0x563b3bafdc20, trx=..., lock=..., trx_ctx=0x4f6e0328fcd0)
|
at /test/mtest/10.5_galera_dbg/galera/src/replicator_smm.cpp:1108
|
#26 0x000014a7b12e3c24 in galera_replay_trx (gh=<optimized out>, trx_handle=<optimized out>, recv_ctx=0x4f6e0328fcd0)
|
at /test/mtest/10.5_galera_dbg/galera/src/wsrep_provider.cpp:311
|
#27 0x0000563b388016fe in wsrep::wsrep_provider_v26::replay (this=<optimized out>, ws_handle=..., reply_service=<optimized out>)
|
at /test/mtest/10.5_dbg/wsrep-lib/src/wsrep_provider_v26.cpp:206
|
#28 0x0000563b381c8c45 in Wsrep_client_service::replay (this=0x35357409b478)
|
at /test/mtest/10.5_dbg/wsrep-lib/include/wsrep/transaction.hpp:223
|
#29 0x0000563b387f910f in wsrep::transaction::replay (this=this@entry=0x35357409b4f8, lock=...)
|
at /test/mtest/10.5_dbg/wsrep-lib/src/transaction.cpp:1889
|
#30 0x0000563b387fc2ee in wsrep::transaction::after_statement (this=this@entry=0x35357409b4f8)
|
--Type <RET> for more, q to quit, c to continue without paging--
|
at /test/mtest/10.5_dbg/wsrep-lib/src/transaction.cpp:855
|
#31 0x0000563b387e2f66 in wsrep::client_state::after_statement (this=this@entry=0x35357409b490)
|
at /test/mtest/10.5_dbg/wsrep-lib/src/client_state.cpp:276
|
#32 0x0000563b37b3280a in wsrep_after_statement (thd=0x353574094ff8) at /test/mtest/10.5_dbg/sql/sql_class.h:5099
|
#33 wsrep_mysql_parse (thd=thd@entry=0x353574094ff8, rawbuf=0x3535740a7f40 "CREATE TABLE IF NOT EXISTS v1 SELECT 2 as a", length=43,
|
parser_state=parser_state@entry=0x4f6e032903d0, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false)
|
at /test/mtest/10.5_dbg/sql/sql_parse.cc:7929
|
#34 0x0000563b37b42563 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x353574094ff8,
|
packet=packet@entry=0x35357409f659 "CREATE TABLE IF NOT EXISTS v1 SELECT 2 as a;", packet_length=packet_length@entry=44,
|
is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/mtest/10.5_dbg/sql/sql_class.h:1271
|
#35 0x0000563b37b45dd5 in do_command (thd=0x353574094ff8) at /test/mtest/10.5_dbg/sql/sql_parse.cc:1370
|
#36 0x0000563b37ca3a28 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x6e2e2f620c28,
|
put_in_cache=put_in_cache@entry=true) at /test/mtest/10.5_dbg/sql/sql_connect.cc:1423
|
#37 0x0000563b37ca412f in handle_one_connection (arg=arg@entry=0x6e2e2f620c28) at /test/mtest/10.5_dbg/sql/sql_connect.cc:1325
|
#38 0x0000563b38160871 in pfs_spawn_thread (arg=0x6e2e2f646e08) at /test/mtest/10.5_dbg/storage/perfschema/pfs.cc:2201
|
#39 0x00005c577e24a609 in start_thread (arg=<optimized out>) at pthread_create.c:477
|
#40 0x0000104668744293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
|
Attachments
Issue Links
- relates to
-
MDEV-27806 Galera crash when "create a table as select"
-
- Closed
-
Reproduced the issue using RQG stress test
test case
perl runall-new.pl \
--basedir=/test/GAL_MD300622-mariadb-10.5.17-linux-x86_64-dbg \
--vardir=/home/ramesh/galera-rqg-test \
--mysqld=--wsrep-provider=/test/GAL_MD300622-mariadb-10.5.17-linux-x86_64-dbg/lib/libgalera_smm.so \
--gendata=conf/mariadb/innodb_compression_encryption.zz \
--grammar=conf/mariadb/innodb_compression_encryption.yy \
--threads=16 \
--galera=mss \
--mysqld=--wsrep_sst_method=rsync \
--mysqld=--core \
--mysqld=--general-log \
--mysqld=--general-log-file=queries.log \
--mysqld=--log-output=file \
--mysqld=--wsrep-debug=0 \
--mysqld=--wsrep-sync-wait=15 \
--mysqld=--wsrep_retry_autocommit=0 \
--mysqld=--wsrep_slave_threads=12 \
--mysqld=--wsrep_log_conflicts=1 \
--mysqld=--wsrep_on=1 \
--mysqld=--default-storage-engine=innodb \
--mysqld=--sort_buffer_size=200M \
--mysqld=--innodb-lock-wait-timeout=1 \
--mysqld=--binlog-format=ROW \
--mysqld=--gtid_strict_mode=1 \
--mysqld=--log_slave_updates=ON \
--mysqld=--log_bin=binlog
(gdb) bt
#0 __pthread_kill (threadid=<optimized out>, signo=signo@entry=11) at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
#1 0x000055a5eb85944e in my_write_core (sig=sig@entry=11) at /test/10.5_dbg/mysys/stacktrace.c:424
#2 0x000055a5eb0781f5 in handle_fatal_signal (sig=11) at /test/10.5_dbg/sql/signal_handler.cc:354
#3 <signal handler called>
#4 __memcmp_avx2_movbe () at ../sysdeps/x86_64/multiarch/memcmp-avx2-movbe.S:182
#5 0x000055a5eaf10d63 in rpl_sql_thread_info::cached_charset_compare (this=0xa5a5a5a5a5a5a5a5, charset=charset@entry=0x153ba4026420 "\b") at /test/10.5_dbg/sql/rpl_rli.cc:2535
#6 0x000055a5eb1f8f20 in Query_log_event::do_apply_event (this=0x153ba4026328, rgi=0x153ba40256a0,
query_arg=0x153ba40264f3 "CREATE OR REPLACE TABLE `C` (\n `pad` char(60) NOT NULL DEFAULT '',\n `id` int(10) unsigned NOT NULL DEFAULT 0,\n `k` int(10) unsigned NOT NULL DEFAULT 0,\n `c` char(120) NOT NULL DEFAULT ''\n)", q_len_arg=192) at /test/10.5_dbg/sql/log_event_server.cc:1743
#7 0x000055a5eb1fa17c in Query_log_event::do_apply_event (this=<optimized out>, rgi=<optimized out>) at /test/10.5_dbg/sql/log_event_server.cc:1582
#8 0x000055a5eb3a319b in Log_event::apply_event (rgi=0x153ba40256a0, this=0x153ba4026328) at /test/10.5_dbg/sql/log_event.h:1505
#9 wsrep_apply_events (thd=thd@entry=0x153ba4032518, rli=<optimized out>, events_buf=<optimized out>, buf_len=20544) at /test/10.5_dbg/sql/wsrep_applier.cc:208
#10 0x000055a5eb388976 in apply_events (thd=thd@entry=0x153ba4032518, rli=<optimized out>, data=..., err=...) at /test/10.5_dbg/wsrep-lib/include/wsrep/buffer.hpp:48
#11 0x000055a5eb389058 in Wsrep_replayer_service::apply_write_set (this=0x153cb4263dc0, ws_meta=..., data=..., err=...) at /test/10.5_dbg/sql/wsrep_high_priority_service.cc:740
#12 0x000055a5eb9a6702 in apply_write_set (server_state=..., high_priority_service=..., ws_handle=..., ws_meta=..., data=...) at /test/10.5_dbg/wsrep-lib/src/server_state.cpp:331
#13 0x000055a5eb9a764f in wsrep::server_state::on_apply (this=<optimized out>, high_priority_service=..., ws_handle=..., ws_meta=..., data=...) at /test/10.5_dbg/wsrep-lib/src/server_state.cpp:1118
#14 0x000055a5eb9b7a9e in wsrep::high_priority_service::apply (data=..., ws_meta=..., ws_handle=..., this=0x153cb4263dc0) at /test/10.5_dbg/wsrep-lib/include/wsrep/high_priority_service.hpp:47
#15 (anonymous namespace)::apply_cb (ctx=ctx@entry=0x153cb4263dc0, wsh=wsh@entry=0x153cb4263600, flags=flags@entry=65, buf=buf@entry=0x153cb4263610, meta=meta@entry=0x153cb42638f0,
exit_loop=exit_loop@entry=0x153cb42638b0) at /test/10.5_dbg/wsrep-lib/src/wsrep_provider_v26.cpp:507
#16 0x0000153d6e1c2c55 in galera::TrxHandleSlave::apply (this=this@entry=0x153ba80229c0, recv_ctx=recv_ctx@entry=0x153cb4263dc0,
apply_cb=0x55a5eb9b791b <(anonymous namespace)::apply_cb(void*, wsrep_ws_handle_t const*, uint32_t, wsrep_buf_t const*, wsrep_trx_meta_t const*, wsrep_bool_t*)>, meta=..., exit_loop=@0x153cb42638b0: false)
at /test/10.5_galera_dbg/galera/src/trx_handle.cpp:396
#17 0x0000153d6e1ddbba in galera::ReplicatorSMM::replay_trx (this=0x55a5ed9b6fc0, trx=..., lock=..., trx_ctx=0x153cb4263dc0) at /test/10.5_galera_dbg/galera/src/replicator_smm.cpp:1116
#18 0x0000153d6e1afc75 in galera_replay_trx (gh=<optimized out>, trx_handle=<optimized out>, recv_ctx=0x153cb4263dc0) at /test/10.5_galera_dbg/galera/src/wsrep_provider.cpp:338
#19 0x000055a5eb9b8bd0 in wsrep::wsrep_provider_v26::replay (this=<optimized out>, ws_handle=..., reply_service=<optimized out>) at /test/10.5_dbg/wsrep-lib/src/wsrep_provider_v26.cpp:209
#20 0x000055a5eb38842d in Wsrep_client_service::replay (this=0x153ba4007030) at /test/10.5_dbg/wsrep-lib/include/wsrep/transaction.hpp:225
#21 0x000055a5eb9addad in wsrep::transaction::replay (this=this@entry=0x153ba40070b0, lock=...) at /test/10.5_dbg/wsrep-lib/src/transaction.cpp:1999
#22 0x000055a5eb9b132b in wsrep::transaction::after_statement (this=this@entry=0x153ba40070b0) at /test/10.5_dbg/wsrep-lib/src/transaction.cpp:862
#23 0x000055a5eb997142 in wsrep::client_state::after_statement (this=this@entry=0x153ba4007048) at /test/10.5_dbg/wsrep-lib/src/client_state.cpp:278
#24 0x000055a5eadc95a6 in wsrep_after_statement (thd=0x153ba4000db8) at /test/10.5_dbg/sql/sql_class.h:5150
#25 wsrep_mysql_parse (thd=thd@entry=0x153ba4000db8, rawbuf=0x153ba4013cb0 "CREATE OR REPLACE TABLE C AS SELECT * FROM `t2` /* QNO 1577 CON_ID 37 */", length=72, parser_state=parser_state@entry=0x153cb4264480,
is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.5_dbg/sql/sql_parse.cc:7933
#26 0x000055a5eadd7d6c in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x153ba4000db8,
packet=packet@entry=0x153ba400b3d9 "CREATE OR REPLACE TABLE C AS SELECT * FROM `t2` /* QNO 1577 CON_ID 37 */ ", packet_length=packet_length@entry=73, is_com_multi=is_com_multi@entry=false,
is_next_command=is_next_command@entry=false) at /test/10.5_dbg/sql/sql_class.h:1290
#27 0x000055a5eadda86f in do_command (thd=0x153ba4000db8) at /test/10.5_dbg/sql/sql_parse.cc:1375
#28 0x000055a5eaf1b896 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x55a5ee10bea8, put_in_cache=put_in_cache@entry=true) at /test/10.5_dbg/sql/sql_connect.cc:1418
#29 0x000055a5eaf1bda1 in handle_one_connection (arg=0x55a5ee10bea8) at /test/10.5_dbg/sql/sql_connect.cc:1312
#30 0x0000153d6ec71609 in start_thread (arg=<optimized out>) at pthread_create.c:477
#31 0x0000153d6e85f293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95