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

galera_sr.GCF-1043B MTR failed: Failed to open table mysql.wsrep_streaming_log for writing

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Done
    • 10.4.12
    • N/A
    • Galera, Tests
    • None
    • TestTarball_2 debian-8

    Description

      galera_sr.GCF-1043B failed on CI: Failed to open table mysql.wsrep_streaming_log for writing.

      stdio.log:

      10.4.12-6-MariaDB-enterprise cbfa2cfc48da12a13957d06c59e6a7651b77aa6a, debian-8

      		 
      2020-02-14T05:54:10.5495945Z galera_sr.GCF-1043B 'innodb'             w2 [ fail ]  Found warnings/errors in server log file!
      		 
      2020-02-14T05:54:10.5497767Z         Test ended at 2020-02-14 05:54:10
      		 
      2020-02-14T05:54:10.5498259Z line
      		 
      2020-02-14T05:54:10.5499049Z 2020-02-14  5:54:06 25 [ERROR] WSREP: Failed to open table mysql.wsrep_streaming_log for writing
      		 
      2020-02-14T05:54:10.5499493Z ^ Found warnings in /var/tmp/mtr/2/log/mysqld.2.err
      		 
      2020-02-14T05:54:10.5500663Z ok
      		 
      2020-02-14T05:54:10.5501041Z 
      2020-02-14T05:54:10.5531462Z  - saving '/var/tmp/mtr/2/log/galera_sr.GCF-1043B-innodb/' to '/var/tmp/mtr/log/galera_sr.GCF-1043B-innodb/'

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-18556 galera_sr.GCF-1043B: Test failure: signal 6; mysqltest: Can't connect to local MySQL server

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            stepan.patryshev Stepan Patryshev (Inactive) added a comment -

            It failed on 10.5 local run.

            stdio.log:

            10.5.4 CS, 37c14690fc6bc9237bdad9b8e26157d1174a49fc, debug build, Centos 7

            		 
            200522 17:34:45 +2.444 galera_sr.GCF-1043B 'innodb'             [ fail ]
            		 
                    Test ended at 2020-05-22 17:34:45
            		 
             
            		 
            CURRENT_TEST: galera_sr.GCF-1043B
            		 
            mysqltest: In included file "./suite/galera/include/galera_concurrent_test.inc": 
            included from /home/stepan/mariadb/10.5/mysql-test/suite/galera_sr/t/GCF-1043B.test at line 14:
            		 
            At line 74: query 'reap' failed with wrong errno 1146: 'Table 'test.t1' doesn't exist', instead of 0...
            		 
             
            		 
            The result from queries just before the failure was:
            		 
            < snip >
            		 
            connect node_1a, 127.0.0.1, root, , test, $NODE_MYPORT_1;
            		 
            Running a concurrent test with the following queries:
            		 
            DELETE FROM t1
            		 
            INSERT INTO t1 VALUES (1,'y'),(2,'x')
            		 
            UPDATE t1 SET f2 = 'y' WHERE f1 = 1 OR f1 = 2;
            		 
            connection node_1;
            		 
            DROP TABLE IF EXISTS t1;
            		 
            CREATE TABLE t1 (f1 INTEGER PRIMARY KEY AUTO_INCREMENT, f2 CHAR(255)) ENGINE=InnoDB;
            		 
            SET SESSION wsrep_sync_wait = 0;
            		 
            SET SESSION wsrep_trx_fragment_size = 1;;;
            		 
            connection node_1a;
            		 
            SET SESSION wsrep_sync_wait = 0;
            		 
            SET SESSION wsrep_trx_fragment_size = 1;;;
            		 
            connection node_2;
            		 
            SET SESSION wsrep_sync_wait = 0;
            		 
            SET SESSION wsrep_trx_fragment_size = 1;;;
            		 
             
            		 
            More results from queries before failure can be found in /home/stepan/mariadb/10.5/mysql-test/var/log/GCF-1043B.log
            		 
             
            		 
             - saving '/home/stepan/mariadb/10.5/mysql-test/var/log/galera_sr.GCF-1043B-innodb/' to '/home/stepan/mariadb/10.5/mysql-test/var/log/galera_sr.GCF-1043B-innodb/'
            		 
            ***Warnings generated in error logs during shutdown after running tests: galera_sr.GCF-1008 galera_sr.GCF-1043B galera_sr.GCF-1018 galera_sr.mysql-wsrep-features#9
            		 
             
            		 
            mariadbd: /home/stepan/mariadb/10.5/sql/transaction.cc:494: bool trans_commit_stmt(THD*): Assertion `thd->in_active_multi_stmt_transaction() || thd->m_transaction_psi == __null' failed.
            		 
            Attempting backtrace. You can use the following information to find out

            Server logs.

            stepan.patryshev Stepan Patryshev (Inactive) added a comment - It failed on 10.5 local run. stdio.log : 10.5.4 CS, 37c14690fc6bc9237bdad9b8e26157d1174a49fc, debug build, Centos 7 200522 17:34:45 +2.444 galera_sr.GCF-1043B 'innodb' [ fail ] Test ended at 2020-05-22 17:34:45   CURRENT_TEST: galera_sr.GCF-1043B mysqltest: In included file "./suite/galera/include/galera_concurrent_test.inc": included from /home/stepan/mariadb/10.5/mysql-test/suite/galera_sr/t/GCF-1043B.test at line 14: At line 74: query 'reap' failed with wrong errno 1146: 'Table 'test.t1' doesn't exist', instead of 0...   The result from queries just before the failure was: < snip > connect node_1a, 127.0.0.1, root, , test, $NODE_MYPORT_1; Running a concurrent test with the following queries: DELETE FROM t1 INSERT INTO t1 VALUES (1,'y'),(2,'x') UPDATE t1 SET f2 = 'y' WHERE f1 = 1 OR f1 = 2; connection node_1; DROP TABLE IF EXISTS t1; CREATE TABLE t1 (f1 INTEGER PRIMARY KEY AUTO_INCREMENT, f2 CHAR(255)) ENGINE=InnoDB; SET SESSION wsrep_sync_wait = 0; SET SESSION wsrep_trx_fragment_size = 1;;; connection node_1a; SET SESSION wsrep_sync_wait = 0; SET SESSION wsrep_trx_fragment_size = 1;;; connection node_2; SET SESSION wsrep_sync_wait = 0; SET SESSION wsrep_trx_fragment_size = 1;;;   More results from queries before failure can be found in /home/stepan/mariadb/10.5/mysql-test/var/log/GCF-1043B.log   - saving '/home/stepan/mariadb/10.5/mysql-test/var/log/galera_sr.GCF-1043B-innodb/' to '/home/stepan/mariadb/10.5/mysql-test/var/log/galera_sr.GCF-1043B-innodb/' ***Warnings generated in error logs during shutdown after running tests: galera_sr.GCF-1008 galera_sr.GCF-1043B galera_sr.GCF-1018 galera_sr.mysql-wsrep-features#9   mariadbd: /home/stepan/mariadb/10.5/sql/transaction.cc:494: bool trans_commit_stmt(THD*): Assertion `thd->in_active_multi_stmt_transaction() || thd->m_transaction_psi == __null' failed. Attempting backtrace. You can use the following information to find out Server logs .
            stepan.patryshev Stepan Patryshev (Inactive) added a comment -

            It failed also on BB, 10.4 and BB, 10.5.

            stepan.patryshev Stepan Patryshev (Inactive) added a comment - It failed also on BB, 10.4 and BB, 10.5 .
            sciascid Daniele Sciascia added a comment -

            Test GCF-1043B was removed in 98ac2d425e6e5320afd498882b43e96d79f65f0a
            Closing

            sciascid Daniele Sciascia added a comment - Test GCF-1043B was removed in 98ac2d425e6e5320afd498882b43e96d79f65f0a Closing

            People

              sciascid Daniele Sciascia
              stepan.patryshev Stepan Patryshev (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.