Jan Lindström (Inactive) added a comment - 2019-08-27 05:28 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.

Marko Mäkelä added a comment - 2019-09-10 12:26 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

Marko Mäkelä added a comment - 2019-09-10 13:48 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;

Stepan Patryshev (Inactive) added a comment - 2020-01-08 14:52 Increased the priority since it fails on Azure.