[MDEV-13743] galera_toi_truncate may fail with: query 'reap' succeeded - should have failed with errno 1213 Created: 2017-09-06  Updated: 2018-09-12  Resolved: 2018-09-12

Status: Closed
Project: MariaDB Server
Component/s: Galera, Tests
Affects Version/s: 10.1
Fix Version/s: 10.2.18, 10.3.10, 10.1.37

Type: Bug Priority: Major
Reporter: Andrii Nikitin (Inactive) Assignee: Jan Lindström (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Blocks
blocks MDEV-13549 Galera 3 test failures Closed
Relates
relates to MDEV-13549 Galera 3 test failures Closed

 Description   

[buildbot@centos73-amd64 mysql-test]$ ./mtr --repeat=20 --suite=galera,mariabackup -par=12 --big-test galera_toi_truncate galera_wsrep_provider_options_syntax  galera_fk_multitable
Logging: ./mtr  --repeat=20 --suite=galera,mariabackup -par=12 --big-test galera_toi_truncate galera_wsrep_provider_options_syntax galera_fk_multitable
vardir: /home/buildbot/mariadb-environs/_depot/m-tar/10.1-16005/mysql-test/var
Checking leftover processes...
Removing old var directory...
Creating var directory '/home/buildbot/mariadb-environs/_depot/m-tar/10.1-16005/mysql-test/var'...
Checking supported features...
MariaDB Version 10.1.27-MariaDB
 - SSL connections supported
Collecting tests...
Installing system database...
worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 16000..16019
worker[3] Using MTR_BUILD_THREAD 302, with reserved ports 16040..16059
worker[2] Using MTR_BUILD_THREAD 301, with reserved ports 16020..16039
 
==============================================================================
 
TEST                                  WORKER RESULT   TIME (ms) or COMMENT
--------------------------------------------------------------------------
 
worker[11] Using MTR_BUILD_THREAD 304, with reserved ports 16080..16099
worker[5] Using MTR_BUILD_THREAD 305, with reserved ports 16100..16119
worker[4] Using MTR_BUILD_THREAD 303, with reserved ports 16060..16079
worker[6] Using MTR_BUILD_THREAD 306, with reserved ports 16120..16139
worker[7] Using MTR_BUILD_THREAD 307, with reserved ports 16140..16159
worker[9] Using MTR_BUILD_THREAD 309, with reserved ports 16180..16199
worker[10] Using MTR_BUILD_THREAD 308, with reserved ports 16160..16179
worker[12] Using MTR_BUILD_THREAD 310, with reserved ports 16200..16219
worker[8] Using MTR_BUILD_THREAD 311, with reserved ports 16220..16239
galera.galera_wsrep_provider_options_syntax 'xtradb' w11 [ pass ]   2017
galera.galera_wsrep_provider_options_syntax 'innodb_plugin' w6 [ pass ]   2029
galera.galera_wsrep_provider_options_syntax 'xtradb' w11 [ pass ]   2020
galera.galera_wsrep_provider_options_syntax 'xtradb' w11 [ pass ]   2023
galera.galera_wsrep_provider_options_syntax 'innodb_plugin' w6 [ pass ]   2021
galera.galera_fk_multitable 'innodb_plugin' w3 [ pass ]  28054
galera.galera_fk_multitable 'xtradb'     w10 [ pass ]  28473
galera.galera_wsrep_provider_options_syntax 'xtradb' w11 [ pass ]   9206
galera.galera_fk_multitable 'innodb_plugin' w3 [ pass ]  11315
galera.galera_wsrep_provider_options_syntax 'innodb_plugin' w6 [ pass ]   9303
galera.galera_fk_multitable 'xtradb'     w10 [ pass ]  13225
galera.galera_wsrep_provider_options_syntax 'innodb_plugin' w6 [ pass ]   2044
galera.galera_wsrep_provider_options_syntax 'xtradb' w11 [ pass ]   2037
galera.galera_toi_truncate 'innodb_plugin' w1 [ pass ]  44758
galera.galera_wsrep_provider_options_syntax 'innodb_plugin' w6 [ pass ]   2018
galera.galera_wsrep_provider_options_syntax 'xtradb' w11 [ pass ]   2018
galera.galera_wsrep_provider_options_syntax 'innodb_plugin' w6 [ pass ]   2016
galera.galera_fk_multitable 'xtradb'     w10 [ pass ]   8940
galera.galera_fk_multitable 'innodb_plugin' w3 [ pass ]  10614
galera.galera_wsrep_provider_options_syntax 'xtradb' w11 [ pass ]   2027
galera.galera_wsrep_provider_options_syntax 'innodb_plugin' w6 [ pass ]   2025
galera.galera_wsrep_provider_options_syntax 'xtradb' w11 [ pass ]   2022
galera.galera_wsrep_provider_options_syntax 'innodb_plugin' w6 [ pass ]   2022
galera.galera_wsrep_provider_options_syntax 'xtradb' w11 [ pass ]   2036
galera.galera_fk_multitable 'innodb_plugin' w3 [ pass ]   6420
galera.galera_fk_multitable 'xtradb'     w10 [ pass ]   7754
galera.galera_wsrep_provider_options_syntax 'xtradb' w11 [ pass ]   2021
galera.galera_wsrep_provider_options_syntax 'innodb_plugin' w6 [ pass ]   2023
galera.galera_wsrep_provider_options_syntax 'xtradb' w11 [ pass ]   3204
galera.galera_fk_multitable 'innodb_plugin' w3 [ pass ]   5526
galera.galera_toi_truncate 'innodb_plugin' w1 [ pass ]  16789
galera.galera_wsrep_provider_options_syntax 'innodb_plugin' w6 [ pass ]   3300
galera.galera_fk_multitable 'xtradb'     w10 [ pass ]   8678
galera.galera_wsrep_provider_options_syntax 'xtradb' w11 [ pass ]   2028
galera.galera_wsrep_provider_options_syntax 'innodb_plugin' w6 [ pass ]   2019
galera.galera_wsrep_provider_options_syntax 'xtradb' w11 [ pass ]   2045
galera.galera_wsrep_provider_options_syntax 'innodb_plugin' w6 [ pass ]   2038
galera.galera_wsrep_provider_options_syntax 'xtradb' w11 [ pass ]   2020
galera.galera_fk_multitable 'innodb_plugin' w3 [ pass ]   7657
galera.galera_fk_multitable 'xtradb'     w10 [ pass ]   7235
galera.galera_wsrep_provider_options_syntax 'innodb_plugin' w6 [ pass ]   2044
galera.galera_wsrep_provider_options_syntax 'xtradb' w11 [ pass ]   2028
galera.galera_wsrep_provider_options_syntax 'innodb_plugin' w6 [ pass ]   2017
galera.galera_wsrep_provider_options_syntax 'xtradb' w11 [ pass ]   2024
galera.galera_wsrep_provider_options_syntax 'innodb_plugin' w6 [ pass ]   2040
galera.galera_toi_truncate 'xtradb'      w8 [ fail ]
        Test ended at 2017-09-05 17:38:18
 
CURRENT_TEST: galera.galera_toi_truncate
mysqltest: At line 34: query 'reap' succeeded - should have failed with errno 1213...
 
The result from queries just before the failure was:
CREATE TABLE ten (f1 INTEGER) ENGINE=InnoDB;
INSERT INTO ten VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10);
CREATE TABLE t1 (f1 INTEGER) ENGINE=InnoDB;
SET SESSION wsrep_retry_autocommit = 0;
INSERT INTO t1 (f1) SELECT 1 FROM ten AS a1, ten AS a2, ten AS a3, ten AS a4, ten AS a5, ten AS a6;;
TRUNCATE TABLE t1;;
 
 - saving '/home/buildbot/mariadb-environs/_depot/m-tar/10.1-16005/mysql-test/var/8/log/galera.galera_toi_truncate-xtradb/' to '/home/buildbot/mariadb-environs/_depot/m-tar/10.1-16005/mysql-test/var/log/galera.galera_toi_truncate-xtradb/'
 
Only  1  of 6 completed.
--------------------------------------------------------------------------
The servers were restarted 0 times
Spent 285.173 of 113 seconds executing testcases
 
Failure: Failed 1/1 tests, 0.00% were successful.
 
Failing test(s): galera.galera_toi_truncate
 
The log files in var/log may give you some hint of what went wrong.
 
If you want to report this error, please read first the documentation
at http://dev.mysql.com/doc/mysql/en/mysql-test-suite.html
 
mysql-test-run: *** ERROR: there were failing test cases

a@UBINTI:~/mariadb-environs$ m1-10.1/build/mysql-test/mtr --repeat=20 --suite=galera,mariabackup -par=12 --big-test galera_toi_truncate ev51914 galera_fk_multitable
Logging: /home/a/mariadb-environs/_depot/m-branch/10.1/mysql-test/mysql-test-run.pl  --repeat=20 --suite=galera,mariabackup -par=12 --big-test galera_toi_truncate ev51914 galera_fk_multitable
vardir: /home/a/mariadb-environs/m1-10.1/build/mysql-test/var
Checking leftover processes...
Removing old var directory...
Creating var directory '/home/a/mariadb-environs/m1-10.1/build/mysql-test/var'...
Checking supported features...
MariaDB Version 10.1.27-MariaDB
 - SSL connections supported
Collecting tests...
Installing system database...
worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 16000..16019
worker[5] Using MTR_BUILD_THREAD 301, with reserved ports 16020..16039
worker[2] Using MTR_BUILD_THREAD 302, with reserved ports 16040..16059
 
==============================================================================
 
TEST                                  WORKER RESULT   TIME (ms) or COMMENT
--------------------------------------------------------------------------
 
worker[3] Using MTR_BUILD_THREAD 305, with reserved ports 16100..16119
worker[11] Using MTR_BUILD_THREAD 304, with reserved ports 16080..16099
worker[10] Using MTR_BUILD_THREAD 303, with reserved ports 16060..16079
worker[4] Using MTR_BUILD_THREAD 306, with reserved ports 16120..16139
worker[6] Using MTR_BUILD_THREAD 307, with reserved ports 16140..16159
worker[12] Using MTR_BUILD_THREAD 310, with reserved ports 16200..16219
worker[8] Using MTR_BUILD_THREAD 309, with reserved ports 16180..16199
worker[7] Using MTR_BUILD_THREAD 308, with reserved ports 16160..16179
worker[9] Using MTR_BUILD_THREAD 311, with reserved ports 16220..16239
galera.galera_fk_multitable 'xtradb'     w12 [ pass ]   3123
galera.galera_fk_multitable 'innodb_plugin' w9 [ pass ]   5636
galera.galera_fk_multitable 'xtradb'     w12 [ pass ]   5662
galera.galera_fk_multitable 'innodb_plugin' w9 [ pass ]   5282
galera.galera_fk_multitable 'xtradb'     w12 [ pass ]   5844
galera.galera_toi_truncate 'xtradb'      w10 [ pass ]  16358
galera.galera_toi_truncate 'innodb_plugin' w6 [ pass ]  16910
galera.ev51914 'innodb_plugin'           w2 [ pass ]  18570
galera.ev51914 'xtradb'                  w5 [ pass ]  19239
galera.galera_fk_multitable 'innodb_plugin' w9 [ pass ]   9030
galera.galera_fk_multitable 'xtradb'     w12 [ pass ]   7167
galera.galera_fk_multitable 'innodb_plugin' w9 [ pass ]   6301
galera.galera_fk_multitable 'xtradb'     w12 [ pass ]   6350
galera.galera_toi_truncate 'xtradb'      w10 [ pass ]  13518
galera.galera_toi_truncate 'innodb_plugin' w6 [ pass ]  13538
galera.galera_fk_multitable 'innodb_plugin' w9 [ pass ]   7803
galera.galera_fk_multitable 'xtradb'     w12 [ pass ]   8626
galera.ev51914 'innodb_plugin'           w2 [ pass ]  17205
galera.ev51914 'xtradb'                  w5 [ pass ]  18577
galera.galera_fk_multitable 'innodb_plugin' w9 [ pass ]   5696
galera.galera_fk_multitable 'xtradb'     w12 [ pass ]   5745
galera.galera_fk_multitable 'innodb_plugin' w9 [ pass ]   7946
galera.galera_toi_truncate 'innodb_plugin' w6 [ pass ]  18163
galera.galera_fk_multitable 'xtradb'     w12 [ pass ]   8092
galera.galera_toi_truncate 'xtradb'      w10 [ pass ]  19513
galera.galera_fk_multitable 'innodb_plugin' w9 [ pass ]   7877
galera.galera_fk_multitable 'xtradb'     w12 [ pass ]   9011
galera.galera_toi_truncate 'xtradb'      w10 [ pass ]   9799
galera.ev51914 'innodb_plugin'           w2 [ pass ]  23222
galera.ev51914 'xtradb'                  w5 [ pass ]  22763
galera.galera_fk_multitable 'innodb_plugin' w9 [ pass ]   7547
galera.galera_fk_multitable 'xtradb'     w12 [ pass ]   8883
galera.galera_toi_truncate 'xtradb'      w10 [ pass ]   8316
galera.galera_fk_multitable 'innodb_plugin' w9 [ pass ]  12733
galera.galera_toi_truncate 'innodb_plugin' w6 [ pass ]  31215
galera.galera_fk_multitable 'xtradb'     w12 [ pass ]  12636
galera.galera_fk_multitable 'innodb_plugin' w9 [ pass ]   6933
galera.ev51914 'innodb_plugin'           w2 [ pass ]  25969
galera.ev51914 'xtradb'                  w5 [ pass ]  26484
galera.galera_fk_multitable 'xtradb'     w12 [ pass ]   8434
galera.galera_fk_multitable 'innodb_plugin' w9 [ pass ]   7627
galera.galera_fk_multitable 'xtradb'     w12 [ pass ]   9192
galera.galera_fk_multitable 'innodb_plugin' w9 [ pass ]   8599
galera.galera_fk_multitable 'innodb_plugin' w9 [ pass ]   9582
galera.ev51914 'innodb_plugin'           w2 [ pass ]  25911
galera.galera_fk_multitable 'xtradb'     w12 [ pass ]  13064
galera.ev51914 'xtradb'                  w5 [ pass ]  25932
galera.galera_toi_truncate 'innodb_plugin' w6 [ pass ]  33111
galera.galera_fk_multitable 'innodb_plugin' w9 [ pass ]   7537
galera.galera_fk_multitable 'xtradb'     w12 [ pass ]  10277
galera.galera_toi_truncate 'xtradb'      w10 [ fail ]
        Test ended at 2017-09-05 19:38:56
 
CURRENT_TEST: galera.galera_toi_truncate
mysqltest: At line 34: query 'reap' succeeded - should have failed with errno 1213...
 
The result from queries just before the failure was:
CREATE TABLE ten (f1 INTEGER) ENGINE=InnoDB;
INSERT INTO ten VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10);
CREATE TABLE t1 (f1 INTEGER) ENGINE=InnoDB;
SET SESSION wsrep_retry_autocommit = 0;
INSERT INTO t1 (f1) SELECT 1 FROM ten AS a1, ten AS a2, ten AS a3, ten AS a4, ten AS a5, ten AS a6;;
TRUNCATE TABLE t1;;
 
 - saving '/home/a/mariadb-environs/m1-10.1/build/mysql-test/var/10/log/galera.galera_toi_truncate-xtradb/' to '/home/a/mariadb-environs/m1-10.1/build/mysql-test/var/log/galera.galera_toi_truncate-xtradb/'
 
Only  1  of 6 completed.
--------------------------------------------------------------------------
The servers were restarted 0 times
Spent 642.548 of 147 seconds executing testcases
 
Failure: Failed 1/6 tests, 83.33% were successful.
 
Failing test(s): galera.galera_toi_truncate
 
The log files in var/log may give you some hint of what went wrong.
 
If you want to report this error, please read first the documentation
at http://dev.mysql.com/doc/mysql/en/mysql-test-suite.html
 
mysql-test-run: *** ERROR: there were failing test cases

a@UBINTI:~/mariadb-environs$ m1-10.1/build/mysql-test/mtr --repeat=20 --suite=galera,mariabackup -par=12 --big-test galera_binlog_checksum galera_toi_truncate galera_fk_multitable galera_wsrep_provider_options_syntax ev51914 full_backup
Logging: /home/a/mariadb-environs/_depot/m-branch/10.1/mysql-test/mysql-test-run.pl  --repeat=20 --suite=galera,mariabackup -par=12 --big-test galera_binlog_checksum galera_toi_truncate galera_fk_multitable galera_wsrep_provider_options_syntax ev51914 full_backup
vardir: /home/a/mariadb-environs/m1-10.1/build/mysql-test/var
Checking leftover processes...
Removing old var directory...
Creating var directory '/home/a/mariadb-environs/m1-10.1/build/mysql-test/var'...
Checking supported features...
MariaDB Version 10.1.27-MariaDB
 - SSL connections supported
Collecting tests...
Installing system database...
worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 16000..16019
worker[3] Using MTR_BUILD_THREAD 301, with reserved ports 16020..16039
worker[5] Using MTR_BUILD_THREAD 302, with reserved ports 16040..16059
worker[4] Using MTR_BUILD_THREAD 304, with reserved ports 16080..16099
worker[2] Using MTR_BUILD_THREAD 303, with reserved ports 16060..16079
 
==============================================================================
 
TEST                                  WORKER RESULT   TIME (ms) or COMMENT
--------------------------------------------------------------------------
 
worker[8] Using MTR_BUILD_THREAD 305, with reserved ports 16100..16119
worker[11] Using MTR_BUILD_THREAD 309, with reserved ports 16180..16199
worker[10] Using MTR_BUILD_THREAD 308, with reserved ports 16160..16179
worker[6] Using MTR_BUILD_THREAD 306, with reserved ports 16120..16139
worker[9] Using MTR_BUILD_THREAD 307, with reserved ports 16140..16159
worker[12] Using MTR_BUILD_THREAD 310, with reserved ports 16200..16219
worker[7] Using MTR_BUILD_THREAD 311, with reserved ports 16220..16239
galera.galera_wsrep_provider_options_syntax 'innodb_plugin' w2 [ pass ]   2008
galera.galera_wsrep_provider_options_syntax 'xtradb' w11 [ pass ]   2008
galera.galera_binlog_checksum 'innodb_plugin' w9 [ pass ]   6619
galera.galera_wsrep_provider_options_syntax 'innodb_plugin' w2 [ pass ]   2007
galera.galera_wsrep_provider_options_syntax 'xtradb' w11 [ pass ]   2008
galera.galera_binlog_checksum 'xtradb'   w6 [ pass ]   8055
galera.galera_wsrep_provider_options_syntax 'innodb_plugin' w2 [ pass ]   2008
galera.galera_wsrep_provider_options_syntax 'xtradb' w11 [ pass ]   2007
galera.galera_fk_multitable 'innodb_plugin' w5 [ pass ]   9387
galera.galera_fk_multitable 'xtradb'     w3 [ pass ]  10362
galera.galera_wsrep_provider_options_syntax 'innodb_plugin' w2 [ pass ]   2009
galera.galera_wsrep_provider_options_syntax 'xtradb' w11 [ pass ]   2009
galera.galera_binlog_checksum 'innodb_plugin' w9 [ pass ]   4610
galera.galera_wsrep_provider_options_syntax 'innodb_plugin' w2 [ pass ]   2009
galera.galera_wsrep_provider_options_syntax 'xtradb' w11 [ pass ]   2008
galera.galera_binlog_checksum 'xtradb'   w6 [ pass ]   5569
galera.galera_wsrep_provider_options_syntax 'innodb_plugin' w2 [ pass ]   2009
galera.galera_wsrep_provider_options_syntax 'xtradb' w11 [ pass ]   2008
galera.galera_fk_multitable 'innodb_plugin' w5 [ pass ]   6815
galera.galera_binlog_checksum 'innodb_plugin' w9 [ pass ]   6045
galera.galera_wsrep_provider_options_syntax 'innodb_plugin' w2 [ pass ]   2007
galera.galera_wsrep_provider_options_syntax 'xtradb' w11 [ pass ]   2007
galera.galera_fk_multitable 'xtradb'     w3 [ pass ]   7543
galera.galera_wsrep_provider_options_syntax 'innodb_plugin' w2 [ pass ]   2007
galera.galera_wsrep_provider_options_syntax 'xtradb' w11 [ pass ]   2008
galera.galera_binlog_checksum 'xtradb'   w6 [ pass ]   6002
galera.galera_wsrep_provider_options_syntax 'innodb_plugin' w2 [ pass ]   2007
galera.galera_wsrep_provider_options_syntax 'xtradb' w11 [ pass ]   2008
galera.galera_toi_truncate 'innodb_plugin' w1 [ pass ]  22872
galera.galera_binlog_checksum 'innodb_plugin' w9 [ pass ]   5926
galera.galera_wsrep_provider_options_syntax 'innodb_plugin' w2 [ pass ]   2008
galera.galera_wsrep_provider_options_syntax 'xtradb' w11 [ pass ]   2008
galera.galera_fk_multitable 'innodb_plugin' w5 [ pass ]   8445
galera.galera_toi_truncate 'xtradb'      w7 [ pass ]  25054
galera.galera_binlog_checksum 'xtradb'   w6 [ pass ]   4800
galera.galera_wsrep_provider_options_syntax 'innodb_plugin' w2 [ pass ]   2008
galera.ev51914 'innodb_plugin'           w4 [ pass ]  25628
galera.galera_wsrep_provider_options_syntax 'xtradb' w11 [ pass ]   2008
galera.galera_wsrep_provider_options_syntax 'xtradb' w11 [ pass ]   2008
galera.galera_wsrep_provider_options_syntax 'innodb_plugin' w2 [ pass ]   2008
galera.ev51914 'xtradb'                  w8 [ pass ]  29091
galera.galera_binlog_checksum 'innodb_plugin' w9 [ pass ]   5843
galera.galera_fk_multitable 'xtradb'     w3 [ pass ]  11365
galera.galera_wsrep_provider_options_syntax 'xtradb' w11 [ pass ]   2009
galera.galera_wsrep_provider_options_syntax 'innodb_plugin' w2 [ pass ]   2008
galera.galera_binlog_checksum 'xtradb'   w6 [ pass ]   6550
galera.galera_wsrep_provider_options_syntax 'xtradb' w11 [ pass ]   2007
galera.galera_wsrep_provider_options_syntax 'innodb_plugin' w2 [ pass ]   2008
galera.galera_fk_multitable 'innodb_plugin' w5 [ pass ]   9639
galera.galera_wsrep_provider_options_syntax 'xtradb' w11 [ pass ]   2008
galera.galera_wsrep_provider_options_syntax 'innodb_plugin' w2 [ pass ]   2008
galera.galera_binlog_checksum 'innodb_plugin' w9 [ pass ]   6596
galera.galera_wsrep_provider_options_syntax 'xtradb' w11 [ pass ]   2008
galera.galera_wsrep_provider_options_syntax 'innodb_plugin' w2 [ pass ]   2008
galera.galera_binlog_checksum 'xtradb'   w6 [ pass ]   6520
galera.galera_wsrep_provider_options_syntax 'xtradb' w11 [ pass ]   2008
galera.galera_wsrep_provider_options_syntax 'innodb_plugin' w2 [ pass ]   2008
galera.galera_fk_multitable 'xtradb'     w3 [ pass ]  10257
galera.galera_binlog_checksum 'innodb_plugin' w9 [ pass ]   5220
galera.galera_wsrep_provider_options_syntax 'xtradb' w11 [ pass ]   2010
galera.galera_wsrep_provider_options_syntax 'innodb_plugin' w2 [ pass ]   2008
galera.galera_wsrep_provider_options_syntax 'xtradb' w11 [ pass ]   2008
galera.galera_wsrep_provider_options_syntax 'innodb_plugin' w2 [ pass ]   2008
galera.galera_fk_multitable 'innodb_plugin' w5 [ pass ]   9544
galera.galera_binlog_checksum 'xtradb'   w6 [ pass ]   5218
galera.galera_wsrep_provider_options_syntax 'xtradb' w11 [ pass ]   2008
galera.galera_wsrep_provider_options_syntax 'innodb_plugin' w2 [ pass ]   2007
galera.galera_binlog_checksum 'innodb_plugin' w9 [ pass ]   5243
mariabackup.full_backup                  w12 [ pass ]  64516
galera.galera_toi_truncate 'innodb_plugin' w1 [ pass ]  24450
galera.galera_fk_multitable 'xtradb'     w3 [ pass ]   8450
galera.galera_toi_truncate 'xtradb'      w7 [ pass ]  26108
galera.galera_binlog_checksum 'xtradb'   w6 [ pass ]   6924
galera.galera_binlog_checksum 'innodb_plugin' w9 [ pass ]   5041
galera.ev51914 'innodb_plugin'           w4 [ pass ]  27096
galera.galera_fk_multitable 'innodb_plugin' w5 [ pass ]   8580
galera.galera_binlog_checksum 'innodb_plugin' w9 [ pass ]   5235
galera.ev51914 'xtradb'                  w8 [ pass ]  29060
galera.galera_binlog_checksum 'xtradb'   w6 [ pass ]   6532
galera.galera_fk_multitable 'xtradb'     w3 [ pass ]  10217
galera.galera_binlog_checksum 'innodb_plugin' w9 [ pass ]   7573
galera.galera_binlog_checksum 'xtradb'   w6 [ pass ]   7185
galera.galera_fk_multitable 'innodb_plugin' w5 [ pass ]  12008
galera.galera_fk_multitable 'xtradb'     w3 [ pass ]  11555
galera.galera_binlog_checksum 'innodb_plugin' w9 [ pass ]   5572
galera.galera_binlog_checksum 'xtradb'   w6 [ pass ]   6722
galera.galera_fk_multitable 'innodb_plugin' w5 [ pass ]   9226
galera.galera_binlog_checksum 'innodb_plugin' w9 [ pass ]   5226
galera.galera_binlog_checksum 'xtradb'   w6 [ pass ]   6569
galera.galera_fk_multitable 'xtradb'     w3 [ pass ]   8482
galera.galera_binlog_checksum 'innodb_plugin' w9 [ pass ]   5869
galera.ev51914 'innodb_plugin'           w4 [ pass ]  29855
galera.galera_binlog_checksum 'xtradb'   w6 [ pass ]   6299
galera.galera_fk_multitable 'innodb_plugin' w5 [ pass ]  12103
galera.galera_toi_truncate 'innodb_plugin' w1 [ pass ]  39269
galera.galera_binlog_checksum 'innodb_plugin' w9 [ pass ]   7769
galera.galera_toi_truncate 'xtradb'      w7 [ pass ]  37969
galera.ev51914 'xtradb'                  w8 [ pass ]  33098
galera.galera_fk_multitable 'xtradb'     w3 [ pass ]  15183
galera.galera_binlog_checksum 'xtradb'   w6 [ pass ]   9641
galera.galera_binlog_checksum 'innodb_plugin' w9 [ pass ]   8991
galera.galera_fk_multitable 'innodb_plugin' w5 [ pass ]  13461
galera.galera_binlog_checksum 'xtradb'   w6 [ pass ]   8214
galera.galera_toi_truncate 'xtradb'      w7 [ pass ]  13626
galera.galera_binlog_checksum 'innodb_plugin' w9 [ pass ]   5779
galera.galera_fk_multitable 'xtradb'     w3 [ pass ]  14633
galera.galera_binlog_checksum 'xtradb'   w6 [ pass ]   6366
galera.galera_binlog_checksum 'innodb_plugin' w9 [ pass ]   6299
galera.galera_fk_multitable 'innodb_plugin' w5 [ pass ]  10189
galera.galera_binlog_checksum 'xtradb'   w6 [ pass ]   6403
galera.ev51914 'innodb_plugin'           w4 [ pass ]  33781
galera.galera_toi_truncate 'xtradb'      w7 [ pass ]  12466
galera.galera_binlog_checksum 'innodb_plugin' w9 [ pass ]   5699
galera.galera_fk_multitable 'xtradb'     w3 [ pass ]  12170
galera.galera_fk_multitable 'innodb_plugin' w5 [ pass ]  11061
galera.galera_binlog_checksum 'xtradb'   w6 [ pass ]   7604
galera.galera_binlog_checksum 'innodb_plugin' w9 [ pass ]   8359
galera.ev51914 'xtradb'                  w8 [ pass ]  37535
mariabackup.full_backup                  w12 [ pass ]  83261
galera.galera_binlog_checksum 'xtradb'   w6 [ pass ]   5525
galera.galera_fk_multitable 'xtradb'     w3 [ pass ]  10687
galera.galera_fk_multitable 'innodb_plugin' w5 [ pass ]  10799
galera.galera_binlog_checksum 'xtradb'   w6 [ pass ]   6097
galera.galera_fk_multitable 'innodb_plugin' w5 [ pass ]   9112
galera.galera_fk_multitable 'xtradb'     w3 [ pass ]  10848
galera.ev51914 'innodb_plugin'           w4 [ pass ]  31304
galera.galera_toi_truncate 'xtradb'      w7 [ pass ]  32884
galera.galera_fk_multitable 'innodb_plugin' w5 [ pass ]   7934
galera.galera_fk_multitable 'xtradb'     w3 [ pass ]  11127
galera.ev51914 'xtradb'                  w8 [ pass ]  28830
galera.galera_fk_multitable 'innodb_plugin' w5 [ pass ]   8002
galera.galera_fk_multitable 'xtradb'     w3 [ pass ]  12475
galera.galera_fk_multitable 'innodb_plugin' w5 [ pass ]   8695
galera.ev51914 'innodb_plugin'           w4 [ pass ]  27415
galera.galera_fk_multitable 'xtradb'     w3 [ pass ]  11946
galera.galera_fk_multitable 'innodb_plugin' w5 [ pass ]   9176
galera.galera_toi_truncate 'xtradb'      w7 [ pass ]  31786
galera.ev51914 'xtradb'                  w8 [ pass ]  25257
galera.galera_toi_truncate 'innodb_plugin' w1 [ fail ]
        Test ended at 2017-09-05 17:31:36
 
CURRENT_TEST: galera.galera_toi_truncate
mysqltest: At line 34: query 'reap' succeeded - should have failed with errno 1213...
 
The result from queries just before the failure was:
CREATE TABLE ten (f1 INTEGER) ENGINE=InnoDB;
INSERT INTO ten VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10);
CREATE TABLE t1 (f1 INTEGER) ENGINE=InnoDB;
SET SESSION wsrep_retry_autocommit = 0;
INSERT INTO t1 (f1) SELECT 1 FROM ten AS a1, ten AS a2, ten AS a3, ten AS a4, ten AS a5, ten AS a6;;
TRUNCATE TABLE t1;;
 
 - saving '/home/a/mariadb-environs/m1-10.1/build/mysql-test/var/1/log/galera.galera_toi_truncate-innodb_plugin/' to '/home/a/mariadb-environs/m1-10.1/build/mysql-test/var/log/galera.galera_toi_truncate-innodb_plugin/'
 
Only  5  of 11 completed.
--------------------------------------------------------------------------
The servers were restarted 0 times
Spent 1460.315 of 216 seconds executing testcases
 
Failure: Failed 1/84 tests, 98.81% were successful.
 
Failing test(s): galera.galera_toi_truncate
 
The log files in var/log may give you some hint of what went wrong.
 
If you want to report this error, please read first the documentation
at http://dev.mysql.com/doc/mysql/en/mysql-test-suite.html



 Comments   
Comment by Andrii Nikitin (Inactive) [ 2017-09-06 ]

I couldn't reproduce in mysql-wsrep-bugs

The test most likely to fail the same way if I reduce sleep amount in line #26 of the test (e.g. down to 0.1):

--connection node_1
--sleep 1
--send TRUNCATE TABLE t1;

I couldn't reproduce the problem after increasing sleep amount up to 2
The problem has happened with 'sleep 2' as well

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