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

Test timeouts on p8-trusty-bintar and p8-trusty-bintar-debug

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 5.5(EOL), 10.0(EOL), 10.1(EOL)
    • N/A
    • Tests
    • 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

          Activity

            elenst Elena Stepanova created issue -
            elenst Elena Stepanova made changes -
            Field Original Value New Value
            elenst Elena Stepanova made changes -
            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}
            elenst Elena Stepanova made changes -
            Affects Version/s 10.0 [ 16000 ]
            elenst Elena Stepanova made changes -
            Fix Version/s 10.0 [ 16000 ]
            elenst Elena Stepanova made changes -
            Affects Version/s 10.1 [ 16100 ]
            elenst Elena Stepanova made changes -
            Fix Version/s 10.1 [ 16100 ]
            svoj Sergey Vojtovich made changes -
            Assignee Sergey Vojtovich [ svoj ] Elena Stepanova [ elenst ]
            elenst Elena Stepanova made changes -
            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 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 76131 ] MariaDB v4 [ 150533 ]

            People

              dbart Daniel Bartholomew
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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