[MDEV-19968] Galera test failure on galera_load_data Created: 2019-07-05  Updated: 2020-11-23  Resolved: 2020-10-12

Status: Closed
Project: MariaDB Server
Component/s: Galera, Tests
Affects Version/s: 10.4
Fix Version/s: 10.2.35, 10.3.26, 10.4.16, 10.5.7, 10.6.0

Type: Bug Priority: Critical
Reporter: Jan Lindström (Inactive) Assignee: Jan Lindström (Inactive)
Resolution: Fixed Votes: 1
Labels: galera, galera_4, tests

Issue Links:
Blocks
blocks MDEV-19969 Galera test failures on 10.4 Closed

 Description    

2019-07-04T14:46:11.7937103Z galera.galera_load_data 'innodb'         w1 [ fail ]
 
2019-07-04T14:46:11.7938560Z         Test ended at 2019-07-04 14:46:11
 
2019-07-04T14:46:11.7939042Z 
2019-07-04T14:46:11.7939571Z CURRENT_TEST: galera.galera_load_data
 
2019-07-04T14:46:11.7940254Z --- /__w/1/a/debian-9/build/mysql-test/suite/galera/r/galera_load_data.result	2019-07-04 12:29:14.000000000 +0000
 
2019-07-04T14:46:11.7941052Z +++ /__w/1/a/debian-9/build/mysql-test/suite/galera/r/galera_load_data.reject	2019-07-04 14:46:11.544270360 +0000
 
2019-07-04T14:46:11.7941718Z @@ -64,7 +64,7 @@
 
2019-07-04T14:46:11.7943218Z  Seq_in_index	1
 
2019-07-04T14:46:11.7944695Z  Column_name	id
 
2019-07-04T14:46:11.7945090Z  Collation	A
 
2019-07-04T14:46:11.7945808Z -Cardinality	301
 
2019-07-04T14:46:11.7946434Z +Cardinality	288
 
2019-07-04T14:46:11.7946637Z  Sub_part	NULL
 
2019-07-04T14:46:11.7946932Z  Packed	NULL
 
2019-07-04T14:46:11.7947247Z  Null	
2019-07-04T14:46:11.7947724Z @@ -72,8 +72,8 @@
 
2019-07-04T14:46:11.7947933Z  Comment	
2019-07-04T14:46:11.7948081Z  Index_comment	
2019-07-04T14:46:11.7948554Z  select table_rows, avg_row_length, data_length from information_schema.tables WHERE TABLE_NAME = 'cardtest_tbl';
 
2019-07-04T14:46:11.7949351Z -table_rows	301
 
2019-07-04T14:46:11.7949937Z -avg_row_length	81
 
2019-07-04T14:46:11.7950303Z +table_rows	288
 
2019-07-04T14:46:11.7950596Z +avg_row_length	85
 
2019-07-04T14:46:11.7950881Z  data_length	24576
 
2019-07-04T14:46:11.7951183Z  select count(*) from cardtest_tbl;
 
2019-07-04T14:46:11.7951488Z  count(*)	301
 
2019-07-04T14:46:11.7952034Z 
2019-07-04T14:46:11.7952339Z mysqltest: Result content mismatch
 
2019-07-04T14:46:11.7952600Z 
2019-07-04T14:46:11.8003325Z  - saving '/__w/1/a/debian-9/build/mysql-test/var/1/log/galera.galera_load_data-innodb/' to '/__w/1/a/debian-9/build/mysql-test/var/log/galera.galera_load_data-innodb/'



 Comments   
Comment by Jan Lindström (Inactive) [ 2019-08-27 ]

commit 1a3c77e524e87e8f4151d31cd9c3112df6de218f
Author: Jan Lindström <jan.lindstrom@mariadb.com>
Date: Wed Aug 21 09:09:26 2019 +0300

MDEV-19968: Galera test failure on galera_load_data

Add wait conditions and compare cardinality etc information
between nodes and print something only if they differ.

Comment by Marko Mäkelä [ 2019-09-10 ]

I do not think that this is fixed. Here is a recent failure from buildbot:

10.3 ff5ecfd335582967d76c418514a4310f6804fdaa

 
galera.galera_load_data 'innodb'         w1 [ fail ]
 
        Test ended at 2019-09-10 09:10:36
 
 
 
CURRENT_TEST: galera.galera_load_data
 
--- /usr/share/mysql-test/suite/galera/r/galera_load_data.result	2019-09-10 07:09:25.000000000 +0000
 
+++ /dev/shm/var/1/log/galera_load_data.reject	2019-09-10 09:10:36.339596839 +0000
 
@@ -38,9 +38,31 @@
 
 connection node_2;
 
 set session wsrep_sync_wait=15;
 
 use cardtest02;
 
+Timeout in wait_condition.inc for SELECT table_rows = 301 from information_schema.tables WHERE TABLE_NAME = 'cardtest_tbl';
 
+Id	User	Host	db	Command	Time	State	Info	Progress
 
+1	system user		NULL	Sleep	620	WSREP aborter idle	NULL	0.000
 
+2	system user		NULL	Sleep	616	Committed 5	NULL	0.000
 
+3	system user		NULL	Daemon	NULL	InnoDB purge coordinator	NULL	0.000
 
+5	system user		NULL	Daemon	NULL	InnoDB purge worker	NULL	0.000
 
+6	system user		NULL	Daemon	NULL	InnoDB purge worker	NULL	0.000
 
+4	system user		NULL	Daemon	NULL	InnoDB purge worker	NULL	0.000
 
+7	system user		NULL	Daemon	NULL	InnoDB shutdown handler	NULL	0.000
 
+11	root	localhost:37678	cardtest02	Query	0	Init	show full processlist	0.000
 
 select count(*) from cardtest_tbl;
 
 count(*)
 
 301
 
+SELECT cardinality from information_schema.statistics WHERE TABLE_NAME = 'cardtest_tbl';
 
+cardinality
 
+69
 
+SELECT table_rows from information_schema.tables WHERE TABLE_NAME = 'cardtest_tbl';
 
+table_rows
 
+69
 
+SELECT avg_row_length from information_schema.tables WHERE TABLE_NAME = 'cardtest_tbl';
 
+avg_row_length
 
+118
 
+SELECT data_length from information_schema.tables WHERE TABLE_NAME = 'cardtest_tbl';
 
+data_length
 
+8192
 
 connection node_1;
 
 use test;
 
 drop database cardtest02;
 
 
 
mysqltest: Result length mismatch

Comment by Marko Mäkelä [ 2019-09-10 ]

Another failure of the same source code revision ff5ecfd335582967d76c418514a4310f6804fdaa:

CURRENT_TEST: galera.galera_load_data
 
--- /usr/share/mysql-test/suite/galera/r/galera_load_data.result	2019-09-10 07:09:25.000000000 +0000
 
+++ /dev/shm/var/2/log/galera_load_data.reject	2019-09-10 09:22:53.494222347 +0000
 
@@ -41,6 +41,15 @@
 
 select count(*) from cardtest_tbl;
 
 count(*)
 
 301
 
+SELECT cardinality from information_schema.statistics WHERE TABLE_NAME = 'cardtest_tbl';
 
+cardinality
 
+301
 
+SELECT avg_row_length from information_schema.tables WHERE TABLE_NAME = 'cardtest_tbl';
 
+avg_row_length
 
+81
 
+SELECT data_length from information_schema.tables WHERE TABLE_NAME = 'cardtest_tbl';
 
+data_length
 
+24576
 
 connection node_1;
 
 use test;
 
 drop database cardtest02;

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

Increased the priority since it fails on Azure.

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