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

After upgrading from 10.6.16 to 10.6.19, CTAS crashes the slave instance

    XMLWordPrintable

Details

    Description

      We started patching MariaDB at our site from 10.6.16 to 10.6.19 since last week. CTAS (create table as select) failed to work at the slave node after upgrading to 10.6.19.

      Description of environment:
      OS: RHEL 8.x
      DB 2-node active-active cluster + 1 arbitrator node.
      Galera version is 26.4.16.

      Test case to reproduce the error:
      -----------reproduct case for 10..6.19 crash for CTAS--------------------

      1. mysql --defaults-file=/XXX/XXXX/XXXXX/mariadb.cnf
        Welcome to the MariaDB monitor. Commands end with ; or \g.
        Your MariaDB connection id is 17112148
        Server version: 10.6.19-MariaDB-log MariaDB Server

      Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

      Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

      MariaDB [(none)]> select * from mysql.wsrep_cluster_members;
      -------------------------------------------------------------------------------------------------------------------------+

      node_uuid cluster_uuid node_name node_incoming_address

      -------------------------------------------------------------------------------------------------------------------------+

      6538045b-1f2e-11ef-a363-fa787f04aeb4 bbbc6b0b-9dc8-11ec-96a3-bf2d42d5f86d xxxx-xxxx-xxxx-1-02 xxxx-xxxx-xxxx-1-02-db:19307
      94487f4b-84b1-11ef-8212-022101df84ac bbbc6b0b-9dc8-11ec-96a3-bf2d42d5f86d garb  
      97040df3-1d89-11ef-912f-3f338b3e3330 bbbc6b0b-9dc8-11ec-96a3-bf2d42d5f86d xxxx-xxxx-xxxx-2-02 xxxx-xxxx-xxxx-2-02-db:19307

      -------------------------------------------------------------------------------------------------------------------------+
      3 rows in set (0.003 sec)

      MariaDB [(none)]> create schema testdb
      MariaDB [(none)]> use testdb
      MariaDB [testdb]> select version();
      ---------------------

      version()

      ---------------------

      10.6.19-MariaDB-log

      ---------------------
      1 row in set (0.001 sec)

      MariaDB [testdb]> CREATE TABLE example_table (
      id INT NOT NULL,
      column1 VARCHAR(50),
      column2 INT,
      PRIMARY KEY (id)
      );

      MariaDB [testdb]> insert into example_table values('1001','john','1001');
      MariaDB [testdb]> insert into example_table values('1002','john','1001');
      MariaDB [testdb]> insert into example_table values('1003','john','1001');
      MariaDB [testdb]> insert into example_table values('1004','john','1001');
      MariaDB [testdb]> insert into example_table values('1005','john','1001');
      MariaDB [testdb]> insert into example_table values('1006','john','1001');
      MariaDB [testdb]> insert into example_table values('1007','john','1001');
      MariaDB [testdb]> insert into example_table values('1008','john','1001');
      MariaDB [testdb]> insert into example_table values('1009','john','1001');
      MariaDB [testdb]> insert into example_table values('1010','john','1001');
      MariaDB [testdb]> commit;

      MariaDB [(none)]> set session wsrep_trx_fragment_size=0;
      Query OK, 0 rows affected (0.001 sec)

      MariaDB [(none)]> select @@wsrep_trx_fragment_size;
      ---------------------------

      @@wsrep_trx_fragment_size

      ---------------------------

      0

      ---------------------------
      1 row in set (0.000 sec)

      MariaDB [testdb]> CREATE TABLE t04 (
      id int(11) NOT NULL,
      column1 varchar(50) DEFAULT NULL,
      column2 int(11) DEFAULT NULL,
      PRIMARY KEY (id)
      )
      as select * from example_table ;

      >>>>> the node2 is crashed as below error log:>>>>>>>>
      2024-10-16 13:07:58 125 [ERROR] Slave SQL: Error 'CREATE TABLE AS SELECT is not supported with streaming replication' on query. Default database: 'testdb'. Query: 'CREATE TABLE `t04` (
      `id` int(11) NOT NULL,
      `column1` varchar(50) DEFAULT NULL,
      `column2` int(11) DEFAULT NULL,
      PRIMARY KEY (`id`)
      )', Internal MariaDB error code: 1148
      2024-10-16 13:07:58 125 [Warning] WSREP: Event 1 Query apply failed: 1, seqno 44893294
      2024-10-16 13:07:58 0 [Note] WSREP: Member 0(xxxx-xxxx-xxxx-1-02) initiates vote on a5792d27-9dcc-11ec-8730-46a58493969f:44893294,bae5c2243040fda0: CREATE TABLE AS SELECT is not supported with streaming replication, Error_code: 1148;

      >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

      Slave node DB crashed and needed to restart.

      Attachments

        Issue Links

          Activity

            People

              sysprg Julius Goryavsky
              LawrenceMan Lawrence Man
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.