Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-38314

wsrep::transaction::after_rollback(): Assertion `state() == s_aborting || state() == s_must_replay' failed.

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 12.0.2
    • 12.0.2
    • Galera
    • None
    • Can result in hang or crash

    Description

      RQG run Galera slave node in async master (mariadb server) slave (galera node1) setup.

      mariadb started with below command

      ./mtr galera.galera_as_slave_priv --start
      

      perl gendata.pl --dsn=dbi:mysql:host=127.0.0.1:port=19002:user=root:database=test --spec=conf/runtime/concurrency_1.zz
      perl gentest.pl --dsn=dbi:mysql:host=127.0.0.1:port=19002:user=root:database=test --grammar=conf/runtime/concurrency_1.yy --threads=32 --duration=30000 --queries=1000000000 &
      

      2025-12-11 18:45:11 12 [Note] Slave I/O thread: connected to master 'repl@127.0.0.1:19002',replication starts at GTID position ''
      mariadbd: /home/hemant/Projects/code/mariadb-server-tmp/server1/server/wsrep-lib/src/transaction.cpp:757: int wsrep::transaction::after_rollback(): Assertion `state() == s_aborting || state() == s_must_replay' failed.
      251211 18:47:27 [ERROR] /home/hemant/Projects/build/mariadb-server/INSTALL/usr/local/mysql/bin/mariadbd got signal 6 ;
      Sorry, we probably made a mistake, and this is a bug.
       
       
      Thread pointer: 0x7bfac0014678
      stack_bottom = 0x7bfb056b0000 thread_stack 0x49000
      2025-12-11 18:47:27 0 [Note] WSREP: (f094e801-9c1f, 'tcp://0.0.0.0:19006') turning message relay requesting on, nonlive peers: tcp://127.0.0.1:19003 
      2025-12-11 18:47:28 0 [Note] WSREP: Failed to establish connection: Operation aborted.
      2025-12-11 18:47:28 0 [Note] WSREP: (f094e801-9c1f, 'tcp://0.0.0.0:19006') reconnecting to f07523f6-aba7 (tcp://127.0.0.1:19003), attempt 0
      2025-12-11 18:47:28 0 [Note] InnoDB: Memory pressure event disregarded; innodb_buffer_pool_size=8m, innodb_buffer_pool_size_auto_min=8m
      mysys/stacktrace.c:215(my_print_stacktrace)[0x56506075155f]
      sql/signal_handler.cc:230(handle_fatal_signal)[0x56505fd0b50e]
      libc_sigaction.c:0(__restore_rt)[0x7bfb12245330]
      nptl/pthread_kill.c:44(__pthread_kill_implementation)[0x7bfb1229eb2c]
      posix/raise.c:27(__GI_raise)[0x7bfb1224527e]
      stdlib/abort.c:81(__GI_abort)[0x7bfb122288ff]
      intl/loadmsgcat.c:1177(_nl_load_domain)[0x7bfb1222881b]
      /lib/x86_64-linux-gnu/libc.so.6(+0x3b517)[0x7bfb1223b517]
      2025-12-11 18:47:30 0 [Note] WSREP: Failed to establish connection: Operation aborted.
      2025-12-11 18:47:31 0 [Note] WSREP: Failed to establish connection: Operation aborted.
      src/transaction.cpp:765(wsrep::transaction::after_rollback())[0x56506085eedf]
      src/client_state.cpp:419(wsrep::client_state::after_rollback())[0x56506082eb73]
      sql/wsrep_trans_observer.h:463(wsrep_after_rollback(THD*, bool))[0x56506016bb19]
      sql/wsrep_mysqld.cc:4106(wsrep_commit_empty(THD*, bool))[0x565060179152]
      sql/handler.cc:1833(ha_commit_trans(THD*, bool))[0x56505fd11ba3]
      sql/rpl_gtid.cc:752(rpl_slave_state::record_gtid(THD*, rpl_gtid const*, unsigned long long, bool, bool, void**))[0x56505fb88b60]
      sql/log_event_server.cc:2018(Query_log_event::do_apply_event(rpl_group_info*, char const*, unsigned int))[0x56505fed69d2]
      sql/log_event_server.cc:1516(Query_log_event::do_apply_event(rpl_group_info*))[0x56505fed5134]
      sql/log_event.cc:3984(Log_event::apply_event(rpl_group_info*))[0x56505fecaa00]
      sql/slave.cc:3615(apply_event_and_update_pos_apply(Log_event*, THD*, rpl_group_info*, int))[0x56505f7691b3]
      sql/slave.cc:3791(apply_event_and_update_pos(Log_event*, THD*, rpl_group_info*))[0x56505f7698bf]
      sql/slave.cc:4233(exec_relay_log_event(THD*, Relay_log_info*, rpl_group_info*))[0x56505f76a744]
      sql/slave.cc:5464(handle_slave_sql)[0x56505f76eac7]
      perfschema/pfs.cc:2200(pfs_spawn_thread)[0x5650600cafc2]
      nptl/pthread_create.c:447(start_thread)[0x7bfb1229caa4]
      x86_64/clone3.S:80(clone3)[0x7bfb12329c6c]
      

      Attachments

        Activity

          People

            hemantdangi Hemant Dangi
            hemantdangi Hemant Dangi
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.