Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
5.5(EOL), 10.0(EOL), 10.1(EOL)
-
None
Description
Various tests fail with timeouts on p8 buliders.
http://buildbot.askmonty.org/buildbot/builders/p8-trusty-bintar/builds/1071
rpl.rpl_mixed_drop_create_temp_table 'innodb_plugin,mix' w1 [ fail ] timeout after 900 seconds
|
Test ended at 2016-06-17 17:14:16
|
|
Test case timeout after 900 seconds
|
|
== /var/lib/buildbot/maria-slave/p8-trusty-bintar/build/mysql-test/var/1/log/rpl_mixed_drop_create_temp_table.log ==
|
Log_name Pos Event_type Server_id End_log_pos Info
|
master-bin.000001 # Query # # BEGIN
|
master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
|
master-bin.000001 # Xid # # COMMIT /* XID */
|
master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `xx_1` /* generated by server */
|
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-If-Xe << -e-e-e-e-e-e-e-e-e-e-e-
|
|
SET @commands= 'B T Drop-TXe';
|
BEGIN;
|
INSERT INTO tt_xx_1() VALUES (1);
|
DROP TABLE tt_2, xx_1;
|
ERROR 42S02: Unknown table 'xx_1'
|
-b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-TXe << -b-b-b-b-b-b-b-b-b-b-b-
|
Log_name Pos Event_type Server_id End_log_pos Info
|
master-bin.000001 # Query # # BEGIN
|
master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1)
|
master-bin.000001 # Xid # # COMMIT /* XID */
|
master-bin.000001 # Query # # use `test`; DROP TABLE `tt_2`,`xx_1` /* generated by server */
|
-e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-TXe << -e-e-e-e-e-e-e-e-e-e-e-
|
|
|
== /var/lib/buildbot/maria-slave/p8-trusty-bintar/build/mysql-test/var/1/tmp/analyze-timeout-mysqld.1.err ==
|
mysqltest: Could not open connection 'default' after 500 attempts: 2002 Can't connect to local MySQL server through socket '/var/lib/buildbot/maria-slave/p8-trusty-bintar/build/mysql-test/var/tmp/1/mysqld.1.sock' (111)
|
|
== /var/lib/buildbot/maria-slave/p8-trusty-bintar/build/mysql-test/var/1/tmp/analyze-timeout-mysqld.2.err ==
|
mysqltest: Could not open connection 'default' after 500 attempts: 2002 Can't connect to local MySQL server through socket '/var/lib/buildbot/maria-slave/p8-trusty-bintar/build/mysql-test/var/tmp/1/mysqld.2.sock' (111)
|
parts.partition_alter1_1_innodb 'innodb_plugin' w1 [ fail ] timeout after 900 seconds
|
Test ended at 2016-06-17 20:12:50
|
|
Test case timeout after 900 seconds
|
|
== /var/lib/buildbot/maria-slave/p8-trusty-bintar/build/mysql-test/var/1/log/partition_alter1_1_innodb.log ==
|
CAST(f_int1 AS CHAR), 'just inserted' FROM t0_template
|
WHERE f_int1 BETWEEN @max_row_div2 - 1 AND @max_row_div2 + 1
|
ORDER BY f_int1;
|
DROP TRIGGER trg_3;
|
|
# check trigger-12 success: 1
|
DELETE FROM t1
|
WHERE f_int1 <> CAST(f_char1 AS SIGNED INT)
|
AND f_int2 <> CAST(f_char1 AS SIGNED INT)
|
AND f_charbig = '####updated per insert trigger####';
|
ANALYZE TABLE t1;
|
Table Op Msg_type Msg_text
|
test.t1 analyze status OK
|
CHECK TABLE t1 EXTENDED;
|
Table Op Msg_type Msg_text
|
test.t1 check status OK
|
CHECKSUM TABLE t1 EXTENDED;
|
Table Checksum
|
test.t1 <some_value>
|
OPTIMIZE TABLE t1;
|
|
== /var/lib/buildbot/maria-slave/p8-trusty-bintar/build/mysql-test/var/1/tmp/analyze-timeout-mysqld.1.err ==
|
mysqltest: Could not open connection 'default' after 500 attempts: 2002 Can't connect to local MySQL server through socket '/var/lib/buildbot/maria-slave/p8-trusty-bintar/build/mysql-test/var/tmp/1/mysqld.1.sock' (111)
|
etc.
Another flavor:
http://buildbot.askmonty.org/buildbot/builders/p8-trusty-bintar/builds/1069/steps/test/logs/stdio
innodb.innodb_autoinc_lock_mode_zero 'innodb_plugin' w3 [ fail ]
|
Test ended at 2016-06-17 04:28:09
|
|
CURRENT_TEST: innodb.innodb_autoinc_lock_mode_zero
|
|
|
Failed to start mysqld.1
|
mysqltest failed but provided no output
|
Attachments
Issue Links
- blocks
-
MDEV-7069 Fix buildbot failures in main server trees
-
- Stalled
-
Activity
Description |
Various tests fail with timeouts on p8 buliders.
http://buildbot.askmonty.org/buildbot/builders/p8-trusty-bintar/builds/1071 {noformat} rpl.rpl_mixed_drop_create_temp_table 'innodb_plugin,mix' w1 [ fail ] timeout after 900 seconds Test ended at 2016-06-17 17:14:16 Test case timeout after 900 seconds == /var/lib/buildbot/maria-slave/p8-trusty-bintar/build/mysql-test/var/1/log/rpl_mixed_drop_create_temp_table.log == Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) master-bin.000001 # Xid # # COMMIT /* XID */ master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `xx_1` /* generated by server */ -e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-If-Xe << -e-e-e-e-e-e-e-e-e-e-e- SET @commands= 'B T Drop-TXe'; BEGIN; INSERT INTO tt_xx_1() VALUES (1); DROP TABLE tt_2, xx_1; ERROR 42S02: Unknown table 'xx_1' -b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-TXe << -b-b-b-b-b-b-b-b-b-b-b- Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) master-bin.000001 # Xid # # COMMIT /* XID */ master-bin.000001 # Query # # use `test`; DROP TABLE `tt_2`,`xx_1` /* generated by server */ -e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-TXe << -e-e-e-e-e-e-e-e-e-e-e- == /var/lib/buildbot/maria-slave/p8-trusty-bintar/build/mysql-test/var/1/tmp/analyze-timeout-mysqld.1.err == mysqltest: Could not open connection 'default' after 500 attempts: 2002 Can't connect to local MySQL server through socket '/var/lib/buildbot/maria-slave/p8-trusty-bintar/build/mysql-test/var/tmp/1/mysqld.1.sock' (111) == /var/lib/buildbot/maria-slave/p8-trusty-bintar/build/mysql-test/var/1/tmp/analyze-timeout-mysqld.2.err == mysqltest: Could not open connection 'default' after 500 attempts: 2002 Can't connect to local MySQL server through socket '/var/lib/buildbot/maria-slave/p8-trusty-bintar/build/mysql-test/var/tmp/1/mysqld.2.sock' (111) {noformat} {noformat} parts.partition_alter1_1_innodb 'innodb_plugin' w1 [ fail ] timeout after 900 seconds Test ended at 2016-06-17 20:12:50 Test case timeout after 900 seconds == /var/lib/buildbot/maria-slave/p8-trusty-bintar/build/mysql-test/var/1/log/partition_alter1_1_innodb.log == CAST(f_int1 AS CHAR), 'just inserted' FROM t0_template WHERE f_int1 BETWEEN @max_row_div2 - 1 AND @max_row_div2 + 1 ORDER BY f_int1; DROP TRIGGER trg_3; # check trigger-12 success: 1 DELETE FROM t1 WHERE f_int1 <> CAST(f_char1 AS SIGNED INT) AND f_int2 <> CAST(f_char1 AS SIGNED INT) AND f_charbig = '####updated per insert trigger####'; ANALYZE TABLE t1; Table Op Msg_type Msg_text test.t1 analyze status OK CHECK TABLE t1 EXTENDED; Table Op Msg_type Msg_text test.t1 check status OK CHECKSUM TABLE t1 EXTENDED; Table Checksum test.t1 <some_value> OPTIMIZE TABLE t1; == /var/lib/buildbot/maria-slave/p8-trusty-bintar/build/mysql-test/var/1/tmp/analyze-timeout-mysqld.1.err == mysqltest: Could not open connection 'default' after 500 attempts: 2002 Can't connect to local MySQL server through socket '/var/lib/buildbot/maria-slave/p8-trusty-bintar/build/mysql-test/var/tmp/1/mysqld.1.sock' (111) {noformat} etc. |
Various tests fail with timeouts on p8 buliders.
http://buildbot.askmonty.org/buildbot/builders/p8-trusty-bintar/builds/1071 {noformat} rpl.rpl_mixed_drop_create_temp_table 'innodb_plugin,mix' w1 [ fail ] timeout after 900 seconds Test ended at 2016-06-17 17:14:16 Test case timeout after 900 seconds == /var/lib/buildbot/maria-slave/p8-trusty-bintar/build/mysql-test/var/1/log/rpl_mixed_drop_create_temp_table.log == Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) master-bin.000001 # Xid # # COMMIT /* XID */ master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `xx_1` /* generated by server */ -e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-If-Xe << -e-e-e-e-e-e-e-e-e-e-e- SET @commands= 'B T Drop-TXe'; BEGIN; INSERT INTO tt_xx_1() VALUES (1); DROP TABLE tt_2, xx_1; ERROR 42S02: Unknown table 'xx_1' -b-b-b-b-b-b-b-b-b-b-b- >> B T Drop-TXe << -b-b-b-b-b-b-b-b-b-b-b- Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 # Query # # BEGIN master-bin.000001 # Query # # use `test`; INSERT INTO tt_xx_1() VALUES (1) master-bin.000001 # Xid # # COMMIT /* XID */ master-bin.000001 # Query # # use `test`; DROP TABLE `tt_2`,`xx_1` /* generated by server */ -e-e-e-e-e-e-e-e-e-e-e- >> B T Drop-TXe << -e-e-e-e-e-e-e-e-e-e-e- == /var/lib/buildbot/maria-slave/p8-trusty-bintar/build/mysql-test/var/1/tmp/analyze-timeout-mysqld.1.err == mysqltest: Could not open connection 'default' after 500 attempts: 2002 Can't connect to local MySQL server through socket '/var/lib/buildbot/maria-slave/p8-trusty-bintar/build/mysql-test/var/tmp/1/mysqld.1.sock' (111) == /var/lib/buildbot/maria-slave/p8-trusty-bintar/build/mysql-test/var/1/tmp/analyze-timeout-mysqld.2.err == mysqltest: Could not open connection 'default' after 500 attempts: 2002 Can't connect to local MySQL server through socket '/var/lib/buildbot/maria-slave/p8-trusty-bintar/build/mysql-test/var/tmp/1/mysqld.2.sock' (111) {noformat} {noformat} parts.partition_alter1_1_innodb 'innodb_plugin' w1 [ fail ] timeout after 900 seconds Test ended at 2016-06-17 20:12:50 Test case timeout after 900 seconds == /var/lib/buildbot/maria-slave/p8-trusty-bintar/build/mysql-test/var/1/log/partition_alter1_1_innodb.log == CAST(f_int1 AS CHAR), 'just inserted' FROM t0_template WHERE f_int1 BETWEEN @max_row_div2 - 1 AND @max_row_div2 + 1 ORDER BY f_int1; DROP TRIGGER trg_3; # check trigger-12 success: 1 DELETE FROM t1 WHERE f_int1 <> CAST(f_char1 AS SIGNED INT) AND f_int2 <> CAST(f_char1 AS SIGNED INT) AND f_charbig = '####updated per insert trigger####'; ANALYZE TABLE t1; Table Op Msg_type Msg_text test.t1 analyze status OK CHECK TABLE t1 EXTENDED; Table Op Msg_type Msg_text test.t1 check status OK CHECKSUM TABLE t1 EXTENDED; Table Checksum test.t1 <some_value> OPTIMIZE TABLE t1; == /var/lib/buildbot/maria-slave/p8-trusty-bintar/build/mysql-test/var/1/tmp/analyze-timeout-mysqld.1.err == mysqltest: Could not open connection 'default' after 500 attempts: 2002 Can't connect to local MySQL server through socket '/var/lib/buildbot/maria-slave/p8-trusty-bintar/build/mysql-test/var/tmp/1/mysqld.1.sock' (111) {noformat} etc. Another flavor: http://buildbot.askmonty.org/buildbot/builders/p8-trusty-bintar/builds/1069/steps/test/logs/stdio {noformat} innodb.innodb_autoinc_lock_mode_zero 'innodb_plugin' w3 [ fail ] Test ended at 2016-06-17 04:28:09 CURRENT_TEST: innodb.innodb_autoinc_lock_mode_zero Failed to start mysqld.1 mysqltest failed but provided no output {noformat} |
Affects Version/s | 10.0 [ 16000 ] |
Fix Version/s | 10.0 [ 16000 ] |
Affects Version/s | 10.1 [ 16100 ] |
Fix Version/s | 10.1 [ 16100 ] |
Assignee | Sergey Vojtovich [ svoj ] | Elena Stepanova [ elenst ] |
Fix Version/s | N/A [ 14700 ] | |
Fix Version/s | 5.5 [ 15800 ] | |
Fix Version/s | 10.0 [ 16000 ] | |
Fix Version/s | 10.1 [ 16100 ] | |
Assignee | Elena Stepanova [ elenst ] | Daniel Bartholomew [ dbart ] |
Resolution | Fixed [ 1 ] | |
Status | Open [ 1 ] | Closed [ 6 ] |
Workflow | MariaDB v3 [ 76131 ] | MariaDB v4 [ 150533 ] |