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

sql_sequence.gtid fails in buildbot

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.3(EOL)
    • 10.3.1
    • Tests
    • None

    Description

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

      sql_sequence.gtid 'innodb,row'           w2 [ fail ]
              Test ended at 2017-08-15 16:07:48
       
      CURRENT_TEST: sql_sequence.gtid
      mysqltest: At line 231: query 'select next value for s_db.s1' failed with wrong errno 1146: 'Table 's_db.s1' doesn't exist', instead of 1290...
       
      The result from queries just before the failure was:
      < snip >
      connection m_normal_1;
      use s_db;
      drop sequence s_t;
      drop table t;
      ###########################################
      read_only prevent query sequence
      ###########################################
      connection m_normal_1;
      create sequence s_db.s1;
      show global variables like 'read_only';
      Variable_name	Value
      read_only	OFF
      select next value for s_db.s1;
      next value for s_db.s1
      1
      connection s_normal_3;
      show global variables like 'read_only';
      Variable_name	Value
      read_only	ON
      select next value for s_db.s1;
       
      More results from queries before failure can be found in /mnt/buildbot/build/mariadb-10.3.1/mysql-test/var/2/log/gtid.log
       
      sql_sequence.gtid 'innodb,row'           w2 [ retry-fail ]
              Test ended at 2017-08-15 16:07:51
       
      CURRENT_TEST: sql_sequence.gtid
      --- /mnt/buildbot/build/mariadb-10.3.1/mysql-test/suite/sql_sequence/gtid.result	2017-08-15 10:05:47.000000000 -0400
      +++ /mnt/buildbot/build/mariadb-10.3.1/mysql-test/suite/sql_sequence/gtid.reject	2017-08-15 16:07:50.775096895 -0400
      @@ -154,7 +154,7 @@
       Qcache_hits	0
       show status like 'Qcache_inserts';
       Variable_name	Value
      -Qcache_inserts	0
      +Qcache_inserts	12
       ###########################################
       priv test
       ###########################################
       
      mysqltest: Result length mismatch
      
      

      Attachments

        Activity

          People

            serg Sergei Golubchik
            alice Alice Sherepa
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.