[MDEV-31299] Galera test failure on MTR tests galera.galera_gcache_recover_manytrx and galera_sr.MDEV-27615, galera.galera_gcache_recover_manytrx Created: 2023-05-17  Updated: 2024-01-07

Status: Stalled
Project: MariaDB Server
Component/s: Galera
Affects Version/s: 11.1.1, 11.0
Fix Version/s: 11.0

Type: Bug Priority: Major
Reporter: Ramesh Sivaraman Assignee: Julius Goryavsky
Resolution: Unresolved Votes: 0
Labels: None

Attachments: File logs (8).tar.gz     File mtr (8).log    

 Description   

MTR test : galera.galera_gcache_recover_manytrx

==============================================================================
 
TEST                                      RESULT   TIME (ms) or COMMENT
--------------------------------------------------------------------------
 
worker[1]  - 'localhost:16000' was not free
worker[1] Using MTR_BUILD_THREAD 301, with reserved ports 16020..16039
galera.galera_gcache_recover_manytrx 'innodb' [ fail ]
        Test ended at 2023-05-17 08:55:09
 
CURRENT_TEST: galera.galera_gcache_recover_manytrx
mysqltest: At line 146: query 'reap' failed with wrong errno <Unknown> (2026): 'TLS/SSL error: The TLS connection was non-properly terminated.', instead of <Unknown> (2013)...
 
The result from queries just before the failure was:
< snip >
CALL insert_simple();;
connection node_1_insert_multi;
CALL insert_multi();;
connection node_1_insert_transaction;
CALL insert_transaction ();;
connection node_1_update_simple;
CALL update_simple ();;
connection node_1_insert_1k;
CALL insert_1k ();;
connection node_1_insert_1m;
CALL insert_1m ();;
connection node_1_insert_10m;
CALL insert_10m ();;
connection node_2;
call mtr.add_suppression("Error in Log_event::read_log_event():.*");
SET SESSION wsrep_sync_wait = 0;
Killing server ...
connection node_1;
Killing server ...
connection node_1_insert_simple;

MTR test : galera_sr.MDEV-27615

==============================================================================
 
TEST                                      RESULT   TIME (ms) or COMMENT
--------------------------------------------------------------------------
 
worker[1]  - 'localhost:16000' was not free
worker[1] Using MTR_BUILD_THREAD 301, with reserved ports 16020..16039
galera_sr.MDEV-27615 'innodb'            [ fail ]
        Test ended at 2023-05-17 09:05:01
 
CURRENT_TEST: galera_sr.MDEV-27615
mysqltest: At line 47: query 'reap' failed with wrong errno <Unknown> (2026): 'TLS/SSL error: The TLS connection was non-properly terminated.', instead of <Unknown> (2013)...
 
The result from queries just before the failure was:
connection node_2;
connection node_1;
connection node_1;
connection node_2;
connect node_2a, 127.0.0.1, root, , test, $NODE_MYPORT_2;
connection node_2;
CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) Engine=InnoDB;
SET DEBUG_SYNC='wsrep_before_fragment_certification SIGNAL before_fragment WAIT_FOR continue';
SET SESSION wsrep_trx_fragment_size=1;
START TRANSACTION;
INSERT INTO t1 VALUES (1);;
connection node_2a;
SET SESSION wsrep_sync_wait = 0;
SET DEBUG_SYNC='now WAIT_FOR before_fragment';
SET GLOBAL wsrep_cluster_address = '';
SET DEBUG_SYNC = 'now SIGNAL continue';
connection node_2;



 Comments   
Comment by Timofey Turenko [ 2023-08-11 ]

https://mdbe-ci-repo.mariadb.net/bb-logs/MariaDBServerCommunityProduction/11.1.1/debian_bullseye_gcp/mtr-galera-test/22503/

galera.galera_gcache_recover_manytrx 'innodb' [ fail ]
        Test ended at 2023-08-10 20:43:10
 
CURRENT_TEST: galera.galera_gcache_recover_manytrx
--- /usr/share/mariadb/mariadb-test/suite/galera/r/galera_gcache_recover_manytrx.result	2023-06-05 20:45:41.000000000 +0200
+++ /usr/share/mariadb/mariadb-test/suite/galera/r/galera_gcache_recover_manytrx.reject	2023-08-10 20:43:05.441871262 +0200
@@ -134,6 +134,3 @@
 call mtr.add_suppression("Error in Log_event::read_log_event():.*");
 CALL mtr.add_suppression("conflict state 7 after post commit");
 CALL mtr.add_suppression("Skipped GCache ring buffer recovery");
-connection node_2;
-call mtr.add_suppression("Error in Log_event::read_log_event():.*");
-CALL mtr.add_suppression("Skipped GCache ring buffer recovery");
 
mysqltest: Result length mismatch

Generated at Thu Feb 08 10:22:48 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.