Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-13743

galera_toi_truncate may fail with: query 'reap' succeeded - should have failed with errno 1213

    XMLWordPrintable

    Details

      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

            Activity

              People

              Assignee:
              jplindst Jan Lindström
              Reporter:
              anikitin Andrii Nikitin (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: