Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.5
    • 10.5
    • Galera
    • 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

          Activity

            ramesh Ramesh Sivaraman added a comment - - edited

            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
            

            ramesh Ramesh Sivaraman added a comment - - edited 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

            jplindst 10.8 crashes similar to MDEV-27806 using same RQG stress test.

            (gdb) bt
            #0  __pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
            #1  0x000055b0268e6b99 in my_write_core (sig=sig@entry=6) at /test/10.8_dbg/mysys/stacktrace.c:424
            #2  0x000055b02619ff05 in handle_fatal_signal (sig=6) at /test/10.8_dbg/sql/signal_handler.cc:355
            #3  <signal handler called>
            #4  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
            #5  0x0000151e3efc7859 in __GI_abort () at abort.c:79
            #6  0x0000151e3efc7729 in __assert_fail_base (fmt=0x151e3f15d588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", 
                assertion=0x55b026fe3c90 "state() == s_executing || state() == s_preparing || state() == s_prepared || state() == s_must_abort || state() == s_aborting || state() == s_cert_failed || state() == s_must_replay", file=0x55b026fe34d8 "/test/10.8_dbg/wsrep-lib/src/transaction.cpp", line=659, function=<optimized out>) at assert.c:92
            #7  0x0000151e3efd8f36 in __GI___assert_fail (
                assertion=assertion@entry=0x55b026fe3c90 "state() == s_executing || state() == s_preparing || state() == s_prepared || state() == s_must_abort || state() == s_aborting || state() == s_cert_failed || state() == s_must_replay", file=file@entry=0x55b026fe34d8 "/test/10.8_dbg/wsrep-lib/src/transaction.cpp", line=line@entry=659, function=function@entry=0x55b026fe3c60 "int wsrep::transaction::before_rollback()")
                at assert.c:101
            #8  0x000055b026a4f4e4 in wsrep::transaction::before_rollback (this=this@entry=0x151d9c1f7148) at /test/10.8_dbg/wsrep-lib/src/transaction.cpp:738
            #9  0x000055b0261a54fa in wsrep::client_state::before_rollback (this=0x151d9c1f70e0) at /test/10.8_dbg/wsrep-lib/include/wsrep/client_state.hpp:527
            #10 wsrep_before_rollback (all=true, thd=0x151d9c1f0a88) at /test/10.8_dbg/sql/wsrep_trans_observer.h:404
            #11 ha_rollback_trans (thd=thd@entry=0x151d9c1f0a88, all=all@entry=true) at /test/10.8_dbg/sql/handler.cc:2167
            #12 0x000055b02603878f in trans_rollback (thd=0x151d9c1f0a88) at /test/10.8_dbg/sql/transaction.cc:372
            #13 0x000055b02646dd97 in Wsrep_high_priority_service::rollback (this=0x151e081f0df0, ws_handle=..., ws_meta=...) at /test/10.8_dbg/wsrep-lib/include/wsrep/transaction_id.hpp:50
            #14 0x000055b026a4a8db in apply_write_set (server_state=..., high_priority_service=..., ws_handle=..., ws_meta=..., data=...) at /test/10.8_dbg/wsrep-lib/src/server_state.cpp:341
            #15 0x000055b026a4b78d in wsrep::server_state::on_apply (this=<optimized out>, high_priority_service=..., ws_handle=..., ws_meta=..., data=...) at /test/10.8_dbg/wsrep-lib/src/server_state.cpp:1118
            #16 0x000055b026a5baa2 in wsrep::high_priority_service::apply (data=..., ws_meta=..., ws_handle=..., this=0x151e081f0df0) at /test/10.8_dbg/wsrep-lib/include/wsrep/high_priority_service.hpp:47
            #17 (anonymous namespace)::apply_cb (ctx=ctx@entry=0x151e081f0df0, wsh=wsh@entry=0x151e081f0630, flags=flags@entry=65, buf=buf@entry=0x151e081f0640, meta=meta@entry=0x151e081f0920, 
                exit_loop=exit_loop@entry=0x151e081f08e0) at /test/10.8_dbg/wsrep-lib/src/wsrep_provider_v26.cpp:507
            #18 0x0000151e3ea27c55 in galera::TrxHandleSlave::apply (this=this@entry=0x151d9c169e80, recv_ctx=recv_ctx@entry=0x151e081f0df0, 
                apply_cb=0x55b026a5b91f <(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=@0x151e081f08e0: false)
                at /test/10.8_galera_dbg/galera/src/trx_handle.cpp:396
            #19 0x0000151e3ea42bba in galera::ReplicatorSMM::replay_trx (this=0x55b028460420, trx=..., lock=..., trx_ctx=0x151e081f0df0) at /test/10.8_galera_dbg/galera/src/replicator_smm.cpp:1116
            #20 0x0000151e3ea14c75 in galera_replay_trx (gh=<optimized out>, trx_handle=<optimized out>, recv_ctx=0x151e081f0df0) at /test/10.8_galera_dbg/galera/src/wsrep_provider.cpp:338
            #21 0x000055b026a5cbd4 in wsrep::wsrep_provider_v26::replay (this=<optimized out>, ws_handle=..., reply_service=<optimized out>) at /test/10.8_dbg/wsrep-lib/src/wsrep_provider_v26.cpp:209
            #22 0x000055b02646c613 in Wsrep_client_service::replay (this=0x151d9c0073f8) at /test/10.8_dbg/wsrep-lib/include/wsrep/transaction.hpp:225
            #23 0x000055b026a51eeb in wsrep::transaction::replay (this=this@entry=0x151d9c007478, lock=...) at /test/10.8_dbg/wsrep-lib/src/transaction.cpp:1999
            #24 0x000055b026a55469 in wsrep::transaction::after_statement (this=this@entry=0x151d9c007478) at /test/10.8_dbg/wsrep-lib/src/transaction.cpp:862
            #25 0x000055b026a3b280 in wsrep::client_state::after_statement (this=this@entry=0x151d9c007410) at /test/10.8_dbg/wsrep-lib/src/client_state.cpp:278
            #26 0x000055b025eb4cc5 in wsrep_after_statement (thd=0x151d9c000db8) at /test/10.8_dbg/sql/sql_class.h:5395
            #27 wsrep_mysql_parse (thd=thd@entry=0x151d9c000db8, rawbuf=0x151d9c016530 "CREATE OR REPLACE TABLE F AS SELECT * FROM `t6` /* QNO 1580 CON_ID 24 */", length=72, parser_state=parser_state@entry=0x151e081f1470)
                at /test/10.8_dbg/sql/sql_parse.cc:7870
            #28 0x000055b025ec2b19 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x151d9c000db8, 
                packet=packet@entry=0x151d9c00b7a9 "CREATE OR REPLACE TABLE F AS SELECT * FROM `t6` /* QNO 1580 CON_ID 24 */ ", packet_length=packet_length@entry=73, blocking=blocking@entry=true)
                at /test/10.8_dbg/sql/sql_class.h:1362
            #29 0x000055b025ec5215 in do_command (thd=0x151d9c000db8, blocking=blocking@entry=true) at /test/10.8_dbg/sql/sql_parse.cc:1407
            #30 0x000055b026023d73 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x55b02865e1f8, put_in_cache=put_in_cache@entry=true) at /test/10.8_dbg/sql/sql_connect.cc:1418
            #31 0x000055b02602427f in handle_one_connection (arg=0x55b02865e1f8) at /test/10.8_dbg/sql/sql_connect.cc:1312
            #32 0x0000151e3f4d6609 in start_thread (arg=<optimized out>) at pthread_create.c:477
            #33 0x0000151e3f0c4293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
            (gdb) 
            

            ramesh Ramesh Sivaraman added a comment - jplindst 10.8 crashes similar to MDEV-27806 using same RQG stress test. (gdb) bt #0 __pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:56 #1 0x000055b0268e6b99 in my_write_core (sig=sig@entry=6) at /test/10.8_dbg/mysys/stacktrace.c:424 #2 0x000055b02619ff05 in handle_fatal_signal (sig=6) at /test/10.8_dbg/sql/signal_handler.cc:355 #3 <signal handler called> #4 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50 #5 0x0000151e3efc7859 in __GI_abort () at abort.c:79 #6 0x0000151e3efc7729 in __assert_fail_base (fmt=0x151e3f15d588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x55b026fe3c90 "state() == s_executing || state() == s_preparing || state() == s_prepared || state() == s_must_abort || state() == s_aborting || state() == s_cert_failed || state() == s_must_replay", file=0x55b026fe34d8 "/test/10.8_dbg/wsrep-lib/src/transaction.cpp", line=659, function=<optimized out>) at assert.c:92 #7 0x0000151e3efd8f36 in __GI___assert_fail ( assertion=assertion@entry=0x55b026fe3c90 "state() == s_executing || state() == s_preparing || state() == s_prepared || state() == s_must_abort || state() == s_aborting || state() == s_cert_failed || state() == s_must_replay", file=file@entry=0x55b026fe34d8 "/test/10.8_dbg/wsrep-lib/src/transaction.cpp", line=line@entry=659, function=function@entry=0x55b026fe3c60 "int wsrep::transaction::before_rollback()") at assert.c:101 #8 0x000055b026a4f4e4 in wsrep::transaction::before_rollback (this=this@entry=0x151d9c1f7148) at /test/10.8_dbg/wsrep-lib/src/transaction.cpp:738 #9 0x000055b0261a54fa in wsrep::client_state::before_rollback (this=0x151d9c1f70e0) at /test/10.8_dbg/wsrep-lib/include/wsrep/client_state.hpp:527 #10 wsrep_before_rollback (all=true, thd=0x151d9c1f0a88) at /test/10.8_dbg/sql/wsrep_trans_observer.h:404 #11 ha_rollback_trans (thd=thd@entry=0x151d9c1f0a88, all=all@entry=true) at /test/10.8_dbg/sql/handler.cc:2167 #12 0x000055b02603878f in trans_rollback (thd=0x151d9c1f0a88) at /test/10.8_dbg/sql/transaction.cc:372 #13 0x000055b02646dd97 in Wsrep_high_priority_service::rollback (this=0x151e081f0df0, ws_handle=..., ws_meta=...) at /test/10.8_dbg/wsrep-lib/include/wsrep/transaction_id.hpp:50 #14 0x000055b026a4a8db in apply_write_set (server_state=..., high_priority_service=..., ws_handle=..., ws_meta=..., data=...) at /test/10.8_dbg/wsrep-lib/src/server_state.cpp:341 #15 0x000055b026a4b78d in wsrep::server_state::on_apply (this=<optimized out>, high_priority_service=..., ws_handle=..., ws_meta=..., data=...) at /test/10.8_dbg/wsrep-lib/src/server_state.cpp:1118 #16 0x000055b026a5baa2 in wsrep::high_priority_service::apply (data=..., ws_meta=..., ws_handle=..., this=0x151e081f0df0) at /test/10.8_dbg/wsrep-lib/include/wsrep/high_priority_service.hpp:47 #17 (anonymous namespace)::apply_cb (ctx=ctx@entry=0x151e081f0df0, wsh=wsh@entry=0x151e081f0630, flags=flags@entry=65, buf=buf@entry=0x151e081f0640, meta=meta@entry=0x151e081f0920, exit_loop=exit_loop@entry=0x151e081f08e0) at /test/10.8_dbg/wsrep-lib/src/wsrep_provider_v26.cpp:507 #18 0x0000151e3ea27c55 in galera::TrxHandleSlave::apply (this=this@entry=0x151d9c169e80, recv_ctx=recv_ctx@entry=0x151e081f0df0, apply_cb=0x55b026a5b91f <(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=@0x151e081f08e0: false) at /test/10.8_galera_dbg/galera/src/trx_handle.cpp:396 #19 0x0000151e3ea42bba in galera::ReplicatorSMM::replay_trx (this=0x55b028460420, trx=..., lock=..., trx_ctx=0x151e081f0df0) at /test/10.8_galera_dbg/galera/src/replicator_smm.cpp:1116 #20 0x0000151e3ea14c75 in galera_replay_trx (gh=<optimized out>, trx_handle=<optimized out>, recv_ctx=0x151e081f0df0) at /test/10.8_galera_dbg/galera/src/wsrep_provider.cpp:338 #21 0x000055b026a5cbd4 in wsrep::wsrep_provider_v26::replay (this=<optimized out>, ws_handle=..., reply_service=<optimized out>) at /test/10.8_dbg/wsrep-lib/src/wsrep_provider_v26.cpp:209 #22 0x000055b02646c613 in Wsrep_client_service::replay (this=0x151d9c0073f8) at /test/10.8_dbg/wsrep-lib/include/wsrep/transaction.hpp:225 #23 0x000055b026a51eeb in wsrep::transaction::replay (this=this@entry=0x151d9c007478, lock=...) at /test/10.8_dbg/wsrep-lib/src/transaction.cpp:1999 #24 0x000055b026a55469 in wsrep::transaction::after_statement (this=this@entry=0x151d9c007478) at /test/10.8_dbg/wsrep-lib/src/transaction.cpp:862 #25 0x000055b026a3b280 in wsrep::client_state::after_statement (this=this@entry=0x151d9c007410) at /test/10.8_dbg/wsrep-lib/src/client_state.cpp:278 #26 0x000055b025eb4cc5 in wsrep_after_statement (thd=0x151d9c000db8) at /test/10.8_dbg/sql/sql_class.h:5395 #27 wsrep_mysql_parse (thd=thd@entry=0x151d9c000db8, rawbuf=0x151d9c016530 "CREATE OR REPLACE TABLE F AS SELECT * FROM `t6` /* QNO 1580 CON_ID 24 */", length=72, parser_state=parser_state@entry=0x151e081f1470) at /test/10.8_dbg/sql/sql_parse.cc:7870 #28 0x000055b025ec2b19 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x151d9c000db8, packet=packet@entry=0x151d9c00b7a9 "CREATE OR REPLACE TABLE F AS SELECT * FROM `t6` /* QNO 1580 CON_ID 24 */ ", packet_length=packet_length@entry=73, blocking=blocking@entry=true) at /test/10.8_dbg/sql/sql_class.h:1362 #29 0x000055b025ec5215 in do_command (thd=0x151d9c000db8, blocking=blocking@entry=true) at /test/10.8_dbg/sql/sql_parse.cc:1407 #30 0x000055b026023d73 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x55b02865e1f8, put_in_cache=put_in_cache@entry=true) at /test/10.8_dbg/sql/sql_connect.cc:1418 #31 0x000055b02602427f in handle_one_connection (arg=0x55b02865e1f8) at /test/10.8_dbg/sql/sql_connect.cc:1312 #32 0x0000151e3f4d6609 in start_thread (arg=<optimized out>) at pthread_create.c:477 #33 0x0000151e3f0c4293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 (gdb)

            People

              janlindstrom Jan Lindström
              ramesh Ramesh Sivaraman
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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