[MDEV-13743] galera_toi_truncate may fail with: query 'reap' succeeded - should have failed with errno 1213 - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.1
Fix Version/s: 10.2.18, 10.3.10, 10.1.37
Component/s: Galera, Tests
Labels:
None

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

Attachments

Issue Links

blocks

MDEV-13549 Galera 3 test failures

Closed

relates to

MDEV-13549 Galera 3 test failures

Closed

Activity

People

Assignee:: Jan Lindström (Inactive)

Reporter:: Andrii Nikitin (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 2017-09-06 09:47

Updated:: 2018-09-12 10:36

Resolved:: 2018-09-12 10:36

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.