Details
Critical 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/'
|
Attachments
Issue Links
- blocks
-
MDEV-19969 Galera test failures on 10.4
-
- Closed
-
Activity
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
|
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; |
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_dataAdd wait conditions and compare cardinality etc information
between nodes and print something only if they differ.