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

Galera nodes should operate when transaction-read-only=ON

    XMLWordPrintable

Details

    • Can result in hang or crash
    • Q4/2025 Galera Development

    Description

      Wsrep system threads (schema and appliers) should be able to run in a transaction read-only context.

      Such MTR test should pass:

      --source include/galera_cluster.inc
      --source include/have_innodb.inc
      --source include/big_test.inc
       
      # Restart the node 2 in transaction_read_only mode.
      --connection node_2
      --source include/shutdown_mysqld.inc
      --let $start_mysqld_params=--transaction_read_only=TRUE
      --source include/start_mysqld.inc
       
      --connection node_1
      CREATE TABLE t1 (id INT PRIMARY KEY) ENGINE=InnoDB;
      INSERT INTO t1 VALUES (1);
       
      --connection node_2
      SELECT COUNT(*) = 1 AS EXPECT_1 FROM t1;
       
      # Restart the node 2 in normal mode.
      --connection node_2
      --source include/shutdown_mysqld.inc
      --let $start_mysqld_params=
      --source include/start_mysqld.inc
       
      # Cleanup
      --connection node_1
      DROP TABLE t1;
      

      Attachments

        Activity

          People

            denis.protivensky Denis Protivensky
            denis.protivensky Denis Protivensky
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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