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

SR transaction crashes with innodb_snapshot_isolation

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.6
    • 10.6
    • Galera
    • None

    Description

      Streaming replication combined with innodb_snapshot_isolation

      CREATE TABLE t1 (f1 INTEGER PRIMARY KEY); 
      SET SESSION wsrep_trx_fragment_size=1;
      SET SESSION innodb_snapshot_isolation=ON;
      START TRANSACTION WITH CONSISTENT SNAPSHOT;
      INSERT INTO t1 VALUES (1);                
      COMMIT;
      

      leads to the following error (and assertion in debug builds):

      2024-10-29  9:45:05 12 [ERROR] WSREP: init_for_index_scan failed to read first record, error 123
      mariadbd: /home/sciascid/Workspace/src/mariadb-server/wsrep-lib/src/transaction.cpp:382: int wsrep::transaction::before_prepare(wsrep::unique_lock<wsrep::mutex>&): Assertion `state() == s_pr
      eparing || (is_xa() && state() == s_replaying) || (ret && (state() == s_must_abort || state() == s_must_replay || state() == s_cert_failed || state() == s_aborted))' failed.
      241029  9:45:05 [ERROR] mysqld got signal 6 ;
      

      Attachments

        Issue Links

          Activity

            People

              sciascid Daniele Sciascia
              sciascid Daniele Sciascia
              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.