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

Galera crash when "create a table as select"

    XMLWordPrintable

    Details

      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

          Activity

            People

            Assignee:
            jplindst Jan Lindström
            Reporter:
            yongjian.wu yongjian.wu
            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.