[MDEV-21421] Galera test sporadic failure on galera.galera_as_slave_gtid_myisam: Result length mismatch Created: 2020-01-03  Updated: 2020-06-22  Resolved: 2020-05-08

Status: Closed
Project: MariaDB Server
Component/s: Galera, Tests
Affects Version/s: 10.2.30, 10.4.12
Fix Version/s: 10.5.4, 10.2.33, 10.3.24, 10.4.14

Type: Bug Priority: Critical
Reporter: Stepan Patryshev (Inactive) Assignee: Jan Lindström (Inactive)
Resolution: Fixed Votes: 0
Labels: None
Environment:

TestTarball_2 rhel-6; CentOS Linux release 7.6.1810 (Core).


Attachments: Zip Archive 191230_CS_local_SSD.zip     Text File 20191227.3_ttb2_rhel6.txt    

 Description   

galera.galera_as_slave_gtid_myisam sporadically fails on Azure and bb . It failed also on local run of CS 10.4.12-MariaDB ffc0a08 (Server logs).

Azure:
stdout.log:

10.4.11-5-MariaDB-enterprise d4f88b8, rhel-6

2019-12-27T05:53:10.9739977Z galera.galera_as_slave_gtid_myisam 'innodb' w2 [ fail ]
2019-12-27T05:53:10.9740914Z         Test ended at 2019-12-27 00:53:10
2019-12-27T05:53:10.9741129Z 
2019-12-27T05:53:10.9741372Z CURRENT_TEST: galera.galera_as_slave_gtid_myisam
2019-12-27T05:53:10.9742211Z --- /__w/1/s/mysql-test/suite/galera/r/galera_as_slave_gtid_myisam.result	2019-12-26 20:05:45.000000000 -0500
2019-12-27T05:53:10.9742859Z +++ /__w/1/s/mysql-test/suite/galera/r/galera_as_slave_gtid_myisam.reject	2019-12-27 00:53:10.695480129 -0500
2019-12-27T05:53:10.9743348Z @@ -22,12 +22,34 @@
2019-12-27T05:53:10.9743599Z  DROP TABLE t1;
2019-12-27T05:53:10.9743797Z  reset master;
2019-12-27T05:53:10.9743998Z  connection node_2a;
2019-12-27T05:53:10.9744503Z +Timeout in wait_condition.inc for SELECT COUNT(*) = 0 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1';
2019-12-27T05:53:10.9744801Z +Id	User	Host	db	Command	Time	State	Info	Progress
2019-12-27T05:53:10.9745006Z +1	system user		NULL	Sleep	36	Closing tables	NULL	0.000
2019-12-27T05:53:10.9745231Z +2	system user		NULL	Sleep	36	wsrep aborter idle	NULL	0.000
2019-12-27T05:53:10.9745457Z +3	system user		NULL	Daemon	NULL	InnoDB purge coordinator	NULL	0.000
2019-12-27T05:53:10.9745683Z +4	system user		NULL	Daemon	NULL	InnoDB purge worker	NULL	0.000
2019-12-27T05:53:10.9745920Z +6	system user		NULL	Daemon	NULL	InnoDB purge worker	NULL	0.000
2019-12-27T05:53:10.9746128Z +5	system user		NULL	Daemon	NULL	InnoDB purge worker	NULL	0.000
2019-12-27T05:53:10.9746348Z +7	system user		NULL	Daemon	NULL	InnoDB shutdown handler	NULL	0.000
2019-12-27T05:53:10.9746575Z +16	root	localhost:58344	test	Query	0	Init	show full processlist	0.000
2019-12-27T05:53:10.9746817Z +17	system user		NULL	Slave_IO	30	Waiting for master to send event	NULL	0.000
2019-12-27T05:53:10.9747076Z +18	system user		NULL	Slave_SQL	30	Slave has read all relay log; waiting for the slave I/O thread to update it	NULL	0.000
2019-12-27T05:53:10.9747313Z  STOP SLAVE;
2019-12-27T05:53:10.9747487Z  RESET SLAVE ALL;
2019-12-27T05:53:10.9747674Z  set global wsrep_on=OFF;
2019-12-27T05:53:10.9747865Z  reset master;
2019-12-27T05:53:10.9748049Z  set global wsrep_on=ON;
2019-12-27T05:53:10.9748227Z  connection node_3;
2019-12-27T05:53:10.9748738Z +Timeout in wait_condition.inc for SELECT COUNT(*) = 0 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1';
2019-12-27T05:53:10.9749082Z +Id	User	Host	db	Command	Time	State	Info	Progress
2019-12-27T05:53:10.9749330Z +1	system user		NULL	Sleep	65	wsrep aborter idle	NULL	0.000
2019-12-27T05:53:10.9749554Z +2	system user		NULL	Sleep	60	After apply log event	NULL	0.000
2019-12-27T05:53:10.9749764Z +5	system user		NULL	Daemon	NULL	InnoDB purge coordinator	NULL	0.000
2019-12-27T05:53:10.9749998Z +7	system user		NULL	Daemon	NULL	InnoDB purge worker	NULL	0.000
2019-12-27T05:53:10.9750218Z +4	system user		NULL	Daemon	NULL	InnoDB purge worker	NULL	0.000
2019-12-27T05:53:10.9750439Z +6	system user		NULL	Daemon	NULL	InnoDB purge worker	NULL	0.000
2019-12-27T05:53:10.9750659Z +8	system user		NULL	Daemon	NULL	InnoDB shutdown handler	NULL	0.000
2019-12-27T05:53:10.9750871Z +16	root	localhost:51258	test	Query	0	Init	show full processlist	0.000
2019-12-27T05:53:10.9751083Z  set global wsrep_on=OFF;
2019-12-27T05:53:10.9751275Z  reset master;
2019-12-27T05:53:10.9751458Z  set global wsrep_on=ON;
2019-12-27T05:53:10.9751616Z 
2019-12-27T05:53:10.9751797Z mysqltest: Result length mismatch



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

Increased the priority since it fails on Azure.

Comment by Stepan Patryshev (Inactive) [ 2020-01-15 ]

It fails also on Azure on 10.2.30-5-MariaDB-enterprise, run #20200112.1.

Comment by Stepan Patryshev (Inactive) [ 2020-03-02 ]

Reopened it since it is still presented in "disabled.def" on CS 10.3, but is not on ES 10.3. Rebase is needed.

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