[MDEV-18760] galera.galera_transaction_replay: Test failure: mysqltest: Result length mismatch Created: 2019-02-27  Updated: 2020-03-09  Resolved: 2019-10-18

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

Type: Bug Priority: Major
Reporter: Stepan Patryshev (Inactive) Assignee: Jan Lindström (Inactive)
Resolution: Not a Bug Votes: 0
Labels: galera, galera_4
Environment:

OS: CentOS Linux release 7.6.1810 (Core).


Attachments: Zip Archive 190227_galera.galera_transaction_replay-innodb.zip     Text File 190227_stdout_laptop.log    
Issue Links:
Relates
relates to MDEV-18111 Galera 4: run galera test suite Closed

 Description   

MariaDB Server: 10.4.3-MariaDB-debug built from sources, branch=10.4, commit: c568e25379600db8af4bd39df4761ba0fbc1a14e.
Galera4 lib 26.4.0(r4477): debug built from sources, commit: 9bd47835d0fcdcf2f041da39dbe5b98ff738ff10.

Run:

./mtr --suite galera --force --big-test --max-test-fail=0

stdout.log: (attached 190227_stdout_laptop.log)

galera.galera_transaction_replay 'innodb' [ fail ]
 
--- /home/stepan/galera/git/10.4/server/mysql-test/suite/galera/r/galera_transaction_replay.result	2019-01-23 13:58:38.940427700 +0200
+++ /home/stepan/galera/git/10.4/server/mysql-test/suite/galera/r/galera_transaction_replay.reject	2019-02-27 14:18:21.129113700 +0200
@@ -24,11 +24,37 @@
 COMMIT;
 connection node_1a;
 SET SESSION wsrep_on = 0;
+Timeout in wait_condition.inc for SELECT 1 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_debug_sync_waiters' AND VARIABLE_VALUE = 'apply_monitor_slave_enter_sync commit_monitor_master_enter_sync'
+Id	User	Host	db	Command	Time	State	Info	Progress
+1	system user		NULL	Sleep	922	wsrep aborter idle	NULL	0.000
+3	system user		NULL	Sleep	12	After apply log event	NULL	0.000
+2	system user		NULL	Sleep	922	Waiting on cond	NULL	0.000
+6	system user		NULL	Daemon	NULL	InnoDB purge worker	NULL	0.000
+5	system user		NULL	Daemon	NULL	InnoDB purge coordinator	NULL	0.000
+7	system user		NULL	Daemon	NULL	InnoDB purge worker	NULL	0.000
+4	system user		NULL	Daemon	NULL	InnoDB purge worker	NULL	0.000
+8	system user		NULL	Daemon	NULL	InnoDB shutdown handler	NULL	0.000
+784	root	localhost	test	Sleep	12		NULL	0.000
+785	root	localhost:32956	test	Query	10	Init	COMMIT	0.000
+786	root	localhost:32958	test	Query	0	Init	show full processlist	0.000
 SET SESSION wsrep_on = 1;
 SET GLOBAL wsrep_provider_options = 'dbug=';
 SET GLOBAL wsrep_provider_options = 'dbug=d,abort_trx_end';
 SET GLOBAL wsrep_provider_options = 'signal=apply_monitor_slave_enter_sync';
 SET SESSION wsrep_on = 0;
+Timeout in wait_condition.inc for SELECT 1 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_debug_sync_waiters' AND VARIABLE_VALUE = 'abort_trx_end commit_monitor_master_enter_sync'
+Id	User	Host	db	Command	Time	State	Info	Progress
+1	system user		NULL	Sleep	932	wsrep aborter idle	NULL	0.000
+3	system user		NULL	Sleep	10	Update_rows_log_event::find_row(1228)	UPDATE t1 SET f2 = 'c' WHERE f1 = 2	0.000
+2	system user		NULL	Sleep	932	Waiting on cond	NULL	0.000
+6	system user		NULL	Daemon	NULL	InnoDB purge worker	NULL	0.000
+5	system user		NULL	Daemon	NULL	InnoDB purge coordinator	NULL	0.000
+7	system user		NULL	Daemon	NULL	InnoDB purge worker	NULL	0.000
+4	system user		NULL	Daemon	NULL	InnoDB purge worker	NULL	0.000
+8	system user		NULL	Daemon	NULL	InnoDB shutdown handler	NULL	0.000
+784	root	localhost	test	Sleep	22		NULL	0.000
+785	root	localhost:32956		Busy	20	Init	NULL	0.000
+786	root	localhost:32958	test	Query	0	Init	show full processlist	0.000
 SET SESSION wsrep_on = 1;
 SET GLOBAL wsrep_provider_options = 'dbug=';
 SET GLOBAL wsrep_provider_options = 'signal=abort_trx_end';
 
mysqltest: Result length mismatch

See also attached 190227_galera.galera_transaction_replay-innodb.zip.

Note: This test is failed sporadically.



 Comments   
Comment by Stepan Patryshev (Inactive) [ 2019-03-29 ]

This failure is not reproduced on buildbot. And on my machines the last failure was on 26.03.2019, but only being run with the suite, not on standalone running.

Comment by Jan Lindström (Inactive) [ 2019-10-18 ]

Can't repeat locally or in buildbot.

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