[MDEV-21737] galera_sr.GCF-1043B MTR failed: Failed to open table mysql.wsrep_streaming_log for writing Created: 2020-02-14  Updated: 2021-09-29  Resolved: 2021-09-29

Status: Closed
Project: MariaDB Server
Component/s: Galera, Tests
Affects Version/s: 10.4.12
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Stepan Patryshev (Inactive) Assignee: Daniele Sciascia
Resolution: Done Votes: 0
Labels: None
Environment:

TestTarball_2 debian-8


Attachments: Zip Archive 200522_10.5_GCF-1043B.zip     Text File 200522_stdout_10.5_local.log    
Issue Links:
Relates
relates to MDEV-18556 galera_sr.GCF-1043B: Test failure: si... Closed

 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/'



 Comments   
Comment by Stepan Patryshev (Inactive) [ 2020-05-22 ]

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.

Comment by Stepan Patryshev (Inactive) [ 2020-08-27 ]

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

Comment by Daniele Sciascia [ 2021-09-29 ]

Test GCF-1043B was removed in 98ac2d425e6e5320afd498882b43e96d79f65f0a
Closing

Generated at Thu Feb 08 09:09:25 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.