[MDEV-13738] galera_applier_ftwrl_table_alter may fail with '2006: MySQL server has gone away' - Jira

XML

Word

Printable

Details

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

Description

I can reproduce the problem in at least two environments (both source distribution and hasky build) when running galera_applier_ftwrl_table_alter with few more tests, e.g.

./mtr --repeat=20 --suite=galera -par=12 --big-test galera_applier_ftwrl_table_alter galera_gtid  galera_applier_ftwrl_table query_cache

But with more tests it should be easier to reproduce, e.g.:

./mtr --repeat=20 --suite=galera -par=12 --big-test galera_applier_ftwrl_table_alter galera_applier_ftwrl_table galera_binlog_checksum galera_gtid galera_binlog_event_max_size_min galera_binlog_event_max_size_max

The failure usually occurs at start of run, so better just restart command if no error is shown within ~1 min
In my understanding one of nodes (or both) just may silently exit when first node executes :

FLUSH TABLE t1 WITH READ LOCK;

ALTER TABLE t1 ADD COLUMN f2 INTEGER;

Error logs of both nodes and system logs are just empty without messages past node initialization.

below are few examples:

[buildbot@centos73-amd64 mysql-test]$ ./mtr --repeat=20 --suite=galera -par=12 --big-test galera_applier_ftwrl_table_alter galera_gtid  galera_applier_ftwrl_table query_cache

Logging: ./mtr  --repeat=20 --suite=galera -par=12 --big-test galera_applier_ftwrl_table_alter galera_gtid galera_applier_ftwrl_table query_cache

vardir: /home/buildbot/mariadb-environs/_depot/m-tar/10.1-16005/mysql-test/var

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...

==============================================================================

TEST                                  WORKER RESULT   TIME (ms) or COMMENT

--------------------------------------------------------------------------

worker[2] Using MTR_BUILD_THREAD 300, with reserved ports 16000..16019

worker[3] Using MTR_BUILD_THREAD 302, with reserved ports 16040..16059

worker[1] Using MTR_BUILD_THREAD 301, with reserved ports 16020..16039

worker[4] Using MTR_BUILD_THREAD 303, with reserved ports 16060..16079

worker[6] Using MTR_BUILD_THREAD 307, with reserved ports 16140..16159

worker[5] Using MTR_BUILD_THREAD 308, with reserved ports 16160..16179

worker[7] Using MTR_BUILD_THREAD 306, with reserved ports 16120..16139

worker[8] Using MTR_BUILD_THREAD 305, with reserved ports 16100..16119

worker[12] Using MTR_BUILD_THREAD 304, with reserved ports 16080..16099

worker[11] Using MTR_BUILD_THREAD 309, with reserved ports 16180..16199

worker[10] Using MTR_BUILD_THREAD 311, with reserved ports 16220..16239

worker[9] Using MTR_BUILD_THREAD 310, with reserved ports 16200..16219

galera.galera_gtid 'innodb_plugin'       w12 [ pass ]   5706

galera.galera_applier_ftwrl_table_alter 'innodb_plugin' w2 [ fail ]

        Test ended at 2017-09-05 08:28:51

CURRENT_TEST: galera.galera_applier_ftwrl_table_alter

mysqltest: At line 22: query 'ALTER TABLE t1 ADD COLUMN f2 INTEGER' failed: 2006: MySQL server has gone away

The result from queries just before the failure was:

SET SESSION wsrep_sync_wait = 0;

SET SESSION lock_wait_timeout = 60;

SET SESSION innodb_lock_wait_timeout=60;

SET SESSION wait_timeout=60;

CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;

FLUSH TABLE t1 WITH READ LOCK;

ALTER TABLE t1 ADD COLUMN f2 INTEGER;

 - saving '/home/buildbot/mariadb-environs/_depot/m-tar/10.1-16005/mysql-test/var/2/log/galera.galera_applier_ftwrl_table_alter-innodb_plugin/' to '/home/buildbot/mariadb-environs/_depot/m-tar/10.1-16005/mysql-test/var/log/galera.galera_applier_ftwrl_table_alter-innodb_plugin/'

Only  1  of 8 completed.

--------------------------------------------------------------------------

The servers were restarted 0 times

Spent 5.706 of 39 seconds executing testcases

Failure: Failed 1/1 tests, 0.00% were successful.

Failing test(s): galera.galera_applier_ftwrl_table_alter

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

[buildbot@centos73-amd64 mysql-test]$ ./mtr --repeat=20 --suite=galera,mariabackup -par=12 --big-test galera_applier_ftwrl_table_alter galera_applier_ftwrl_table query_cache full_backup incremental_backup

Logging: /home/buildbot/mariadb-environs/_depot/m-branch/10.1/mysql-test/mysql-test-run.pl  --repeat=20 --suite=galera,mariabackup -par=12 --big-test galera_applier_ftwrl_table_alter galera_applier_ftwrl_table query_cache full_backup incremental_backup

vardir: /home/buildbot/mariadb-environs/m1-10.1/build/mysql-test/var

Checking leftover processes...

Removing old var directory...

Creating var directory '/home/buildbot/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[2] Using MTR_BUILD_THREAD 302, with reserved ports 16040..16059

==============================================================================

TEST                                  WORKER RESULT   TIME (ms) or COMMENT

--------------------------------------------------------------------------

worker[7] Using MTR_BUILD_THREAD 303, with reserved ports 16060..16079

worker[5] Using MTR_BUILD_THREAD 305, with reserved ports 16100..16119

worker[8] Using MTR_BUILD_THREAD 306, with reserved ports 16120..16139

worker[6] Using MTR_BUILD_THREAD 304, with reserved ports 16080..16099

worker[12] Using MTR_BUILD_THREAD 308, with reserved ports 16160..16179

worker[9] Using MTR_BUILD_THREAD 309, with reserved ports 16180..16199

worker[10] Using MTR_BUILD_THREAD 307, with reserved ports 16140..16159

worker[11] Using MTR_BUILD_THREAD 310, with reserved ports 16200..16219

worker[4] Using MTR_BUILD_THREAD 311, with reserved ports 16220..16239

galera.galera_applier_ftwrl_table_alter 'innodb_plugin' w2 [ fail ]

        Test ended at 2017-09-05 08:02:05

CURRENT_TEST: galera.galera_applier_ftwrl_table_alter

mysqltest: At line 22: query 'ALTER TABLE t1 ADD COLUMN f2 INTEGER' failed: 2006: MySQL server has gone away

The result from queries just before the failure was:

SET SESSION wsrep_sync_wait = 0;

SET SESSION lock_wait_timeout = 60;

SET SESSION innodb_lock_wait_timeout=60;

SET SESSION wait_timeout=60;

CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;

FLUSH TABLE t1 WITH READ LOCK;

ALTER TABLE t1 ADD COLUMN f2 INTEGER;

 - saving '/home/buildbot/mariadb-environs/m1-10.1/build/mysql-test/var/2/log/galera.galera_applier_ftwrl_table_alter-innodb_plugin/' to '/home/buildbot/mariadb-environs/m1-10.1/build/mysql-test/var/log/galera.galera_applier_ftwrl_table_alter-innodb_plugin/'

Only  1  of 8 completed.

--------------------------------------------------------------------------

The servers were restarted 0 times

Spent 0.000 of 58 seconds executing testcases

Failure: Failed 1/1 tests, 0.00% were successful.

Failing test(s): galera.galera_applier_ftwrl_table_alter

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

[buildbot@centos73-amd64 mysql-test]$ ./mtr --repeat=20 --suite=galera,mariabackup -par=12 --big-test galera_applier_ftwrl_table_alter galera_applier_ftwrl_table query_cache

Logging: /home/buildbot/mariadb-environs/_depot/m-branch/10.1/mysql-test/mysql-test-run.pl  --repeat=20 --suite=galera,mariabackup -par=12 --big-test galera_applier_ftwrl_table_alter galera_applier_ftwrl_table query_cache

vardir: /home/buildbot/mariadb-environs/m1-10.1/build/mysql-test/var

Checking leftover processes...

Removing old var directory...

Creating var directory '/home/buildbot/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...

==============================================================================

TEST                                  WORKER RESULT   TIME (ms) or COMMENT

--------------------------------------------------------------------------

worker[2] Using MTR_BUILD_THREAD 300, with reserved ports 16000..16019

worker[3] Using MTR_BUILD_THREAD 301, with reserved ports 16020..16039

worker[6] Using MTR_BUILD_THREAD 302, with reserved ports 16040..16059

worker[4] Using MTR_BUILD_THREAD 304, with reserved ports 16080..16099

worker[5] Using MTR_BUILD_THREAD 305, with reserved ports 16100..16119

worker[9] Using MTR_BUILD_THREAD 306, with reserved ports 16120..16139

worker[11] Using MTR_BUILD_THREAD 308, with reserved ports 16160..16179

worker[10] Using MTR_BUILD_THREAD 309, with reserved ports 16180..16199

worker[8] Using MTR_BUILD_THREAD 307, with reserved ports 16140..16159

worker[7] Using MTR_BUILD_THREAD 311, with reserved ports 16220..16239

worker[12] Using MTR_BUILD_THREAD 310, with reserved ports 16200..16219

worker[1] Using MTR_BUILD_THREAD 303, with reserved ports 16060..16079

galera.galera_applier_ftwrl_table 'innodb_plugin' w3 [ pass ]   5418

galera.galera_applier_ftwrl_table 'xtradb' w2 [ pass ]   5562

galera.galera_applier_ftwrl_table 'xtradb' w2 [ pass ]   3676

galera.galera_applier_ftwrl_table 'innodb_plugin' w3 [ pass ]   4033

galera.galera_applier_ftwrl_table_alter 'innodb_plugin' w11 [ pass ]  13537

galera.galera_applier_ftwrl_table_alter 'xtradb' w12 [ pass ]  14115

galera.galera_applier_ftwrl_table 'xtradb' w2 [ pass ]   3628

galera.galera_applier_ftwrl_table 'innodb_plugin' w3 [ pass ]   4102

galera.galera_applier_ftwrl_table 'xtradb' w2 [ pass ]   3342

galera.galera_applier_ftwrl_table 'innodb_plugin' w3 [ pass ]   2804

galera.galera_applier_ftwrl_table 'xtradb' w2 [ pass ]   2815

galera.galera_applier_ftwrl_table 'innodb_plugin' w3 [ pass ]   2797

galera.galera_applier_ftwrl_table_alter 'xtradb' w12 [ pass ]  10575

galera.galera_applier_ftwrl_table_alter 'innodb_plugin' w11 [ pass ]  11173

galera.galera_applier_ftwrl_table 'innodb_plugin' w3 [ pass ]   5928

galera.galera_applier_ftwrl_table 'xtradb' w2 [ pass ]   7349

galera.galera_applier_ftwrl_table 'xtradb' w2 [ pass ]   2900

galera.galera_applier_ftwrl_table 'innodb_plugin' w3 [ pass ]   2912

galera.galera_applier_ftwrl_table_alter 'xtradb' w12 [ pass ]  11252

galera.galera_applier_ftwrl_table_alter 'innodb_plugin' w11 [ pass ]  11151

galera.galera_applier_ftwrl_table 'xtradb' w2 [ pass ]   3632

galera.galera_applier_ftwrl_table 'innodb_plugin' w3 [ pass ]   3689

galera.galera_applier_ftwrl_table 'innodb_plugin' w3 [ pass ]   4900

galera.galera_applier_ftwrl_table 'xtradb' w2 [ pass ]   5735

galera.galera_applier_ftwrl_table 'xtradb' w2 [ pass ]   3351

galera.query_cache 'innodb_plugin'       w10 [ pass ]  47802

galera.galera_applier_ftwrl_table 'innodb_plugin' w3 [ pass ]   4386

galera.query_cache 'xtradb'              w8 [ pass ]  48757

galera.galera_applier_ftwrl_table_alter 'xtradb' w12 [ pass ]  13349

galera.galera_applier_ftwrl_table_alter 'innodb_plugin' w11 [ pass ]  11650

galera.galera_applier_ftwrl_table 'xtradb' w2 [ pass ]   3631

galera.galera_applier_ftwrl_table 'innodb_plugin' w3 [ pass ]   3625

galera.galera_applier_ftwrl_table 'xtradb' w2 [ pass ]   4924

galera.galera_applier_ftwrl_table 'innodb_plugin' w3 [ pass ]   5746

galera.galera_applier_ftwrl_table_alter 'xtradb' w12 [ pass ]  11077

galera.galera_applier_ftwrl_table_alter 'innodb_plugin' w11 [ pass ]  12937

galera.galera_applier_ftwrl_table 'innodb_plugin' w3 [ pass ]   4931

galera.galera_applier_ftwrl_table 'xtradb' w2 [ pass ]   6602

galera.galera_applier_ftwrl_table 'innodb_plugin' w3 [ pass ]   3118

galera.galera_applier_ftwrl_table 'xtradb' w2 [ pass ]   3263

galera.galera_applier_ftwrl_table 'innodb_plugin' w3 [ pass ]   3036

galera.galera_applier_ftwrl_table 'xtradb' w2 [ pass ]   2840

galera.galera_applier_ftwrl_table_alter 'xtradb' w12 [ pass ]  12951

galera.galera_applier_ftwrl_table_alter 'innodb_plugin' w11 [ pass ]  11414

galera.galera_applier_ftwrl_table 'innodb_plugin' w3 [ pass ]   3266

galera.galera_applier_ftwrl_table 'xtradb' w2 [ pass ]   3251

galera.galera_applier_ftwrl_table 'innodb_plugin' w3 [ pass ]   5766

galera.galera_applier_ftwrl_table 'xtradb' w2 [ pass ]   6450

galera.galera_applier_ftwrl_table_alter 'xtradb' w12 [ pass ]  11248

galera.galera_applier_ftwrl_table_alter 'innodb_plugin' w11 [ pass ]  13903

galera.galera_applier_ftwrl_table 'innodb_plugin' w3 [ pass ]   5273

galera.galera_applier_ftwrl_table 'xtradb' w2 [ pass ]   5559

galera.galera_applier_ftwrl_table 'xtradb' w2 [ pass ]   3652

galera.galera_applier_ftwrl_table 'innodb_plugin' w3 [ pass ]   3553

galera.galera_applier_ftwrl_table_alter 'xtradb' w12 [ pass ]  10718

galera.galera_applier_ftwrl_table 'xtradb' w2 [ pass ]   4003

galera.galera_applier_ftwrl_table 'innodb_plugin' w3 [ pass ]   5720

galera.galera_applier_ftwrl_table_alter 'innodb_plugin' w11 [ pass ]  12914

galera.query_cache 'innodb_plugin'       w10 [ pass ]  60801

galera.galera_applier_ftwrl_table_alter 'xtradb' w12 [ pass ]  13972

galera.query_cache 'xtradb'              w8 [ pass ]  63959

galera.galera_applier_ftwrl_table_alter 'innodb_plugin' w11 [ pass ]  13227

galera.galera_applier_ftwrl_table_alter 'xtradb' w12 [ pass ]  11395

galera.galera_applier_ftwrl_table_alter 'innodb_plugin' w11 [ pass ]  10164

galera.galera_applier_ftwrl_table_alter 'xtradb' w12 [ pass ]   9069

galera.galera_applier_ftwrl_table_alter 'innodb_plugin' w11 [ pass ]  13942

galera.galera_applier_ftwrl_table_alter 'xtradb' w12 [ pass ]  14791

galera.galera_applier_ftwrl_table_alter 'innodb_plugin' w11 [ pass ]  12137

galera.galera_applier_ftwrl_table_alter 'xtradb' w12 [ pass ]  14208

galera.galera_applier_ftwrl_table_alter 'xtradb' w12 [ fail ]

        Test ended at 2017-09-05 08:09:23

CURRENT_TEST: galera.galera_applier_ftwrl_table_alter

mysqltest: At line 22: query 'ALTER TABLE t1 ADD COLUMN f2 INTEGER' failed: 2006: MySQL server has gone away

The result from queries just before the failure was:

SET SESSION wsrep_sync_wait = 0;

SET SESSION lock_wait_timeout = 60;

SET SESSION innodb_lock_wait_timeout=60;

SET SESSION wait_timeout=60;

CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;

FLUSH TABLE t1 WITH READ LOCK;

ALTER TABLE t1 ADD COLUMN f2 INTEGER;

 - saving '/home/buildbot/mariadb-environs/m1-10.1/build/mysql-test/var/12/log/galera.galera_applier_ftwrl_table_alter-xtradb/' to '/home/buildbot/mariadb-environs/m1-10.1/build/mysql-test/var/log/galera.galera_applier_ftwrl_table_alter-xtradb/'

Only  3  of 6 completed.

--------------------------------------------------------------------------

The servers were restarted 0 times

Spent 699.356 of 192 seconds executing testcases

Failure: Failed 1/54 tests, 98.15% were successful.

Failing test(s): galera.galera_applier_ftwrl_table_alter

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

[buildbot@centos73-amd64 mysql-test]$ ./mtr --repeat=20 --suite=galera -par=12 --big-test galera_applier_ftwrl_table_alter galera_gtid  galera_applier_ftwrl_table query_cache

Logging: ./mtr  --repeat=20 --suite=galera -par=12 --big-test galera_applier_ftwrl_table_alter galera_gtid galera_applier_ftwrl_table query_cache

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...

==============================================================================

TEST                                  WORKER RESULT   TIME (ms) or COMMENT

--------------------------------------------------------------------------

worker[2] Using MTR_BUILD_THREAD 300, with reserved ports 16000..16019

worker[1] Using MTR_BUILD_THREAD 301, with reserved ports 16020..16039

worker[3] Using MTR_BUILD_THREAD 302, with reserved ports 16040..16059

worker[4] Using MTR_BUILD_THREAD 308, with reserved ports 16160..16179

worker[8] Using MTR_BUILD_THREAD 309, with reserved ports 16180..16199

worker[5] Using MTR_BUILD_THREAD 307, with reserved ports 16140..16159

worker[11] Using MTR_BUILD_THREAD 305, with reserved ports 16100..16119

worker[9] Using MTR_BUILD_THREAD 310, with reserved ports 16200..16219

worker[10] Using MTR_BUILD_THREAD 304, with reserved ports 16080..16099

worker[6] Using MTR_BUILD_THREAD 306, with reserved ports 16120..16139

worker[12] Using MTR_BUILD_THREAD 311, with reserved ports 16220..16239

worker[7] Using MTR_BUILD_THREAD 303, with reserved ports 16060..16079

galera.galera_gtid 'xtradb'              w3 [ pass ]   5738

galera.galera_applier_ftwrl_table 'xtradb' w12 [ pass ]   6056

galera.galera_gtid 'innodb_plugin'       w11 [ pass ]   6168

galera.galera_applier_ftwrl_table 'innodb_plugin' w2 [ pass ]   6302

galera.galera_gtid 'xtradb'              w3 [ pass ]   3914

galera.galera_gtid 'innodb_plugin'       w11 [ pass ]   4208

galera.galera_applier_ftwrl_table 'innodb_plugin' w2 [ pass ]   5179

galera.galera_applier_ftwrl_table 'xtradb' w12 [ pass ]   5983

galera.galera_gtid 'innodb_plugin'       w11 [ pass ]   5377

galera.galera_applier_ftwrl_table_alter 'xtradb' w1 [ pass ]  18062

galera.galera_applier_ftwrl_table_alter 'innodb_plugin' w4 [ pass ]  17659

galera.galera_gtid 'xtradb'              w3 [ pass ]   6412

galera.galera_applier_ftwrl_table 'innodb_plugin' w2 [ pass ]   6922

galera.galera_applier_ftwrl_table 'xtradb' w12 [ pass ]   4472

galera.galera_gtid 'innodb_plugin'       w11 [ pass ]   4015

galera.galera_gtid 'xtradb'              w3 [ pass ]   4363

galera.galera_applier_ftwrl_table 'innodb_plugin' w2 [ pass ]   5035

galera.galera_applier_ftwrl_table 'xtradb' w12 [ pass ]   4895

galera.galera_gtid 'innodb_plugin'       w11 [ pass ]   3001

galera.galera_gtid 'xtradb'              w3 [ pass ]   3537

galera.galera_applier_ftwrl_table 'innodb_plugin' w2 [ pass ]   2877

galera.galera_applier_ftwrl_table_alter 'xtradb' w1 [ pass ]  11911

galera.galera_gtid 'innodb_plugin'       w11 [ pass ]   3010

galera.galera_gtid 'xtradb'              w3 [ pass ]   5912

galera.galera_applier_ftwrl_table 'innodb_plugin' w2 [ pass ]   4550

galera.galera_applier_ftwrl_table 'xtradb' w12 [ pass ]   6709

galera.galera_applier_ftwrl_table_alter 'innodb_plugin' w4 [ pass ]  15613

galera.galera_gtid 'innodb_plugin'       w11 [ pass ]   3558

galera.galera_applier_ftwrl_table 'xtradb' w12 [ pass ]   6374

galera.galera_gtid 'xtradb'              w3 [ pass ]   5029

galera.galera_applier_ftwrl_table 'innodb_plugin' w2 [ pass ]   6475

galera.galera_gtid 'innodb_plugin'       w11 [ pass ]   5180

galera.galera_gtid 'xtradb'              w3 [ pass ]   3560

galera.galera_gtid 'innodb_plugin'       w11 [ pass ]   3044

galera.galera_applier_ftwrl_table 'innodb_plugin' w2 [ pass ]   4157

galera.galera_applier_ftwrl_table_alter 'xtradb' w1 [ pass ]  15167

galera.galera_applier_ftwrl_table 'xtradb' w12 [ pass ]   6984

galera.galera_applier_ftwrl_table_alter 'innodb_plugin' w4 [ pass ]  13173

galera.galera_gtid 'xtradb'              w3 [ pass ]   4159

galera.galera_gtid 'innodb_plugin'       w11 [ pass ]   4027

galera.galera_applier_ftwrl_table 'innodb_plugin' w2 [ pass ]   4957

galera.galera_applier_ftwrl_table 'xtradb' w12 [ pass ]   6540

galera.galera_gtid 'xtradb'              w3 [ pass ]   4595

galera.galera_gtid 'innodb_plugin'       w11 [ pass ]   3911

galera.galera_gtid 'xtradb'              w3 [ pass ]   4975

galera.galera_gtid 'innodb_plugin'       w11 [ pass ]   5515

galera.galera_applier_ftwrl_table_alter 'xtradb' w1 [ pass ]  13599

galera.galera_applier_ftwrl_table 'innodb_plugin' w2 [ pass ]   6454

galera.galera_applier_ftwrl_table 'xtradb' w12 [ pass ]   7080

galera.query_cache 'innodb_plugin'       w5 [ pass ]  66110

galera.galera_applier_ftwrl_table_alter 'innodb_plugin' w4 [ pass ]  15131

galera.galera_gtid 'xtradb'              w3 [ pass ]   4430

galera.galera_gtid 'innodb_plugin'       w11 [ pass ]   4256

galera.query_cache 'xtradb'              w8 [ pass ]  71096

galera.galera_applier_ftwrl_table 'innodb_plugin' w2 [ pass ]   5608

galera.galera_applier_ftwrl_table 'xtradb' w12 [ pass ]   6170

galera.galera_applier_ftwrl_table_alter 'xtradb' w1 [ fail ]

        Test ended at 2017-09-05 08:32:01

CURRENT_TEST: galera.galera_applier_ftwrl_table_alter

mysqltest: At line 22: query 'ALTER TABLE t1 ADD COLUMN f2 INTEGER' failed: 2006: MySQL server has gone away

The result from queries just before the failure was:

SET SESSION wsrep_sync_wait = 0;

SET SESSION lock_wait_timeout = 60;

SET SESSION innodb_lock_wait_timeout=60;

SET SESSION wait_timeout=60;

CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;

FLUSH TABLE t1 WITH READ LOCK;

ALTER TABLE t1 ADD COLUMN f2 INTEGER;

 - saving '/home/buildbot/mariadb-environs/_depot/m-tar/10.1-16005/mysql-test/var/1/log/galera.galera_applier_ftwrl_table_alter-xtradb/' to '/home/buildbot/mariadb-environs/_depot/m-tar/10.1-16005/mysql-test/var/log/galera.galera_applier_ftwrl_table_alter-xtradb/'

Only  1  of 8 completed.

--------------------------------------------------------------------------

The servers were restarted 0 times

Spent 489.194 of 100 seconds executing testcases

Failure: Failed 1/5 tests, 80.00% were successful.

Failing test(s): galera.galera_applier_ftwrl_table_alter

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

Attachments

Issue Links

blocks

MDEV-13549 Galera 3 test failures

Closed

relates to

MDEV-13549 Galera 3 test failures

Closed

MDEV-21525 galera.galera_ftwrl MTR failed: Crash with signal SIGABRT

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-05 08:35

Updated:: 2020-01-17 17:31

Resolved:: 2018-09-13 09:18

Git Integration

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