Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.6.19
-
None
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--------------------
- 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
- relates to
-
MDEV-27806 Galera crash when "create a table as select"
- Closed
-
MDEV-30862 Assertion `mode_ == m_high_priority' failed in void wsrep::client_state::after_applying()
- Closed