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

Galera test failure on galera_var_replicate_myisam_on

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Cannot Reproduce
    • 10.4(EOL), 10.5
    • N/A
    • Galera, Tests, wsrep
    • None

    Description

      2020-10-30  8:39:30 53 [ERROR] Slave SQL: Error 'Duplicate entry '11' for key 'PRIMARY'' on query. Default database: 'test'. Query: 'insert into t1 values (11,11)', Internal MariaDB error code: 1062
      2020-10-30  8:39:30 53 [Warning] WSREP: Ignoring error 'Duplicate entry '11' for key 'PRIMARY'' on query. Default database: 'test'. Query: 'insert into t1 values (11,11)', Error_code: 1062
      mysqld: /home/jan/mysql/10.4-bugs/wsrep-lib/src/client_state.cpp:227: int wsrep::client_state::after_statement(): Assertion `mode() == m_local' failed.
      

      Attachments

        Activity

          Found in disabled.def that it was disabled, also I'm adding the missing label.

          julien.fritsch Julien Fritsch added a comment - Found in disabled.def that it was disabled, also I'm adding the missing label.

          Found in disabled.def for ES that it was disabled, also I'm adding the missing label.

          julien.fritsch Julien Fritsch added a comment - Found in disabled.def for ES that it was disabled, also I'm adding the missing label.

          Reduced testcase

          CREATE TABLE t1 (a INT, b INT, UNIQUE(a)) ENGINE=MyISAM;
          CREATE TRIGGER tr1 BEFORE INSERT ON t1 FOR EACH ROW SET NEW.a=1;
          SET GLOBAL wsrep_replicate_myisam=ON;
          INSERT INTO t1  (a,b) VALUES (10,20);
          

          ramesh Ramesh Sivaraman added a comment - Reduced testcase CREATE TABLE t1 (a INT, b INT, UNIQUE(a)) ENGINE=MyISAM; CREATE TRIGGER tr1 BEFORE INSERT ON t1 FOR EACH ROW SET NEW.a=1; SET GLOBAL wsrep_replicate_myisam=ON; INSERT INTO t1 (a,b) VALUES (10,20);

          On merge to 10.5, the test galera.galera_var_replicate_myisam_on would trigger an assertion failure:

          10.5 99bb3fb656f4a2a06c808b7c5d50e18e4c44b73b

          CURRENT_TEST: galera.galera_var_replicate_myisam_on
          mysqltest: At line 214: query 'SELECT * FROM t1 ORDER BY id' failed: 2013: Lost connection to MySQL server during query
          2021-10-13 12:42:16 31 [Warning] WSREP: Ignoring error 'Duplicate entry '1' for key 'PRIMARY'' on query. Default database: 'test'. Query: 'INSERT INTO t1 VALUES (1)', Error_code: 1062
          2021-10-13 12:42:16 2 [ERROR] Slave SQL: Error 'Duplicate entry '11' for key 'PRIMARY'' on query. Default database: 'test'. Query: 'insert into t1 values (11,11)', Internal MariaDB error code: 1062
          2021-10-13 12:42:16 2 [Warning] WSREP: Ignoring error 'Duplicate entry '11' for key 'PRIMARY'' on query. Default database: 'test'. Query: 'insert into t1 values (11,11)', Error_code: 1062
          mariadbd: /mariadb/10.5m/wsrep-lib/src/client_state.cpp:253: int wsrep::client_state::after_statement(): Assertion `mode() == m_local' failed.
          

          Also, in 10.6, the change to the test conflicts with an earlier change, which apparently replaced wsrep_replicate_myisam=TRUE with wsrep_mode=REPLICATE_MYISAM. (How can you tell Galera to replicate both MyISAM and Aria?)

          marko Marko Mäkelä added a comment - On merge to 10.5 , the test galera.galera_var_replicate_myisam_on would trigger an assertion failure: 10.5 99bb3fb656f4a2a06c808b7c5d50e18e4c44b73b CURRENT_TEST: galera.galera_var_replicate_myisam_on mysqltest: At line 214: query 'SELECT * FROM t1 ORDER BY id' failed: 2013: Lost connection to MySQL server during query … 2021-10-13 12:42:16 31 [Warning] WSREP: Ignoring error 'Duplicate entry '1' for key 'PRIMARY'' on query. Default database: 'test'. Query: 'INSERT INTO t1 VALUES (1)', Error_code: 1062 2021-10-13 12:42:16 2 [ERROR] Slave SQL: Error 'Duplicate entry '11' for key 'PRIMARY'' on query. Default database: 'test'. Query: 'insert into t1 values (11,11)', Internal MariaDB error code: 1062 2021-10-13 12:42:16 2 [Warning] WSREP: Ignoring error 'Duplicate entry '11' for key 'PRIMARY'' on query. Default database: 'test'. Query: 'insert into t1 values (11,11)', Error_code: 1062 mariadbd: /mariadb/10.5m/wsrep-lib/src/client_state.cpp:253: int wsrep::client_state::after_statement(): Assertion `mode() == m_local' failed. Also, in 10.6, the change to the test conflicts with an earlier change , which apparently replaced wsrep_replicate_myisam=TRUE with wsrep_mode=REPLICATE_MYISAM . (How can you tell Galera to replicate both MyISAM and Aria?)

          Test case not anymore disabled and I could not reproduce with given test case. wsrep_mode=REPLICATE_ARIA could be used for Aria tables in 10.6+.

          janlindstrom Jan Lindström added a comment - Test case not anymore disabled and I could not reproduce with given test case. wsrep_mode=REPLICATE_ARIA could be used for Aria tables in 10.6+.

          People

            janlindstrom Jan Lindström
            jplindst Jan Lindström (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            5 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.