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

parts.partition_alter2_1_1_innodb fails sporadically in buildbot

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Cannot Reproduce
    • 10.1
    • N/A
    • Tests
    • None

    Description

      http://buildbot.askmonty.org/buildbot/builders/kvm-fulltest/builds/4110/steps/test_3/logs/stdio

      parts.partition_alter2_1_1_innodb 'innodb_plugin' w2 [ fail ]
              Test ended at 2015-03-29 21:37:20
       
      CURRENT_TEST: parts.partition_alter2_1_1_innodb
      mysqltest: In included file "./suite/parts/inc/partition_trigg1.inc": 
      included from ./suite/parts/inc/partition_check.inc at line 972:
      included from ./suite/parts/inc/partition_alter_1.inc at line 71:
      included from ./suite/parts/inc/partition_alter_11.inc at line 91:
      included from ./suite/parts/inc/partition_alter2_1.inc at line 33:
      included from /mnt/buildbot/build/mariadb-10.1.3/mysql-test/suite/parts/t/partition_alter2_1_1_innodb.test at line 84:
      At line 58: query 'DROP TRIGGER trg_1' failed: 1360: Trigger does not exist
       
      The result from queries just before the failure was:
      < snip >
      UPDATE t1 SET f_charbig = CONCAT('===',CAST(f_int1 AS CHAR),'===');
      INSERT INTO t1(f_int1,f_int2,f_char1,f_char2,f_charbig)
      SELECT f_int1,f_int2,f_char1,f_char2,'just inserted' FROM t0_template
      WHERE f_int1 BETWEEN @max_row_div2 - 1 AND @max_row_div2 + 1;
      INSERT INTO t0_aux(f_int1,f_int2,f_char1,f_char2,f_charbig)
      SELECT -f_int1,-f_int1,CAST(-f_int1 AS CHAR),CAST(-f_int1 AS CHAR),
      'just inserted' FROM t0_template
      WHERE f_int1 BETWEEN @max_row_div2 - 1 AND @max_row_div2 + 1;
      CREATE TRIGGER trg_1 BEFORE INSERT ON t0_aux FOR EACH ROW
      BEGIN
      UPDATE t1 SET f_int1 = -f_int1, f_int2 = -f_int2,
      f_charbig = 'updated by trigger'
            WHERE f_int1 = new.f_int1;
      END|
      INSERT INTO t0_aux(f_int1,f_int2,f_char1,f_char2,f_charbig)
      SELECT f_int1,f_int2,f_char1,f_char2,NULL FROM t0_template
      WHERE f_int1 BETWEEN @max_row_div2 - 1 AND @max_row_div2 + 1;
      	
      # check trigger-1 success: 	0
      DROP TRIGGER trg_1;
       
      More results from queries before failure can be found in /mnt/buildbot/build/mariadb-10.1.3/mysql-test/var/2/log/partition_alter2_1_1_innodb.log

      It happened several times by now. Not easily reproducible.

      Attachments

        Issue Links

          Activity

            People

              elenst Elena Stepanova
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              1 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.