Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.5.12, 10.6.5, 10.6.15, 10.4(EOL)
-
Galera cluster
Description
Hi
i met a trouble could you please help?
when i use the query create table as select * from; the galera db nodes crash.
but there are some case if the table is null the query can be execute success but if the table have rows the query can be success on the current node but crash on the others.
is there any config to avoid this ,or this is a limitation in the mariadb galera?
please help check the below:
no problem |
mysql@galeradb1:~$ mysql -uroot -p
|
Enter password:
|
Welcome to the MySQL monitor. Commands end with ; or \g.
|
Your MySQL connection id is 22
|
Server version: 5.5.5-10.5.12-MariaDB-debug-log Source distribution
|
|
|
|
(root@localhost) [cmsdb] 01:42:48> select count(*) from lbtest2;
|
+----------+
|
| count(*) |
|
+----------+
|
| 10 |
|
+----------+
|
1 row in set (0.01 sec)
|
|
(root@localhost) [cmsdb] 01:42:50> select count(*) from lbtest3;
|
+----------+
|
| count(*) |
|
+----------+
|
| 0 |
|
+----------+
|
1 row in set (0.01 sec)
|
|
(root@localhost) [cmsdb] 01:42:52> create table test1 as select * from lbtest3;
|
Query OK, 0 rows affected (0.02 sec)
|
Records: 0 Duplicates: 0 Warnings: 0
|
no problem ^^
problem |
(root@localhost) [cmsdb] 01:43:08> create table test2 as select * from lbtest2; |
Query OK, 10 rows affected (0.02 sec) |
Records: 10 Duplicates: 0 Warnings: 0
|
2022-02-11 1:43:53 2 [ERROR] mysqld: Error writing file '/opt/maria10.1/binlog/BINLOG' (errno: 1950 "Unknown error 1950")
|
mysqld: /opt/newsource/mariadb-10.5.12/wsrep-lib/src/transaction.cpp:665: int wsrep::transaction::before_rollback(): Assertion `state() == s_executing || state() == s_preparing || state() == s_prepared || state() == s_must_abort || state() == s_aborting || state() == s_cert_failed || state() == s_must_replay' failed.
|
220211 1:43:53 [ERROR] mysqld got signal 6 ;
|
(root@localhost) [cmsdb] 01:50:48> select count(*) from test111; |
+----------+ |
| count(*) | |
+----------+ |
| 1 |
|
+----------+ |
1 row in set (0.01 sec) |
|
(root@localhost) [cmsdb] 01:51:06> create table test1111 as select * from test111; |
Query OK, 1 row affected (0.02 sec)
|
Records: 1 Duplicates: 0 Warnings: 0
|
2022-02-11 1:51:28 2 [ERROR] mariadbd: Error writing file '/opt/maria10.1/binlog/BINLOG' (errno: 1950 "Unknown error 1950")
|
mariadbd: /opt/newsource/mariadb-10.5.12/wsrep-lib/src/transaction.cpp:665: int wsrep::transaction::before_rollback(): Assertion `state() == s_executing || state() == s_preparing || state() == s_prepared || state() == s_must_abort || state() == s_aborting || state() == s_cert_failed || state() == s_must_replay' failed.
|
220211 1:51:28 [ERROR] mysqld got signal 6 ;
|
Attachments
Issue Links
- is duplicated by
-
MDEV-32858 CTAS with non-empty table is crashing Galera secondary nodes
- Closed
- relates to
-
MDEV-25970 SIGSEGV in __memcmp_avx2_movbe
- Open
-
MDEV-32780 galera_as_slave_replay: assertion in the wsrep::transaction::before_rollback()
- In Review
-
MDEV-35167 After upgrading from 10.6.16 to 10.6.19, CTAS crashes the slave instance
- Confirmed