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

sql_sequence.gtid fails in buildbot

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.3
    • Fix Version/s: 10.3.1
    • Component/s: Tests
    • Labels:
      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

            • Assignee:
              serg Sergei Golubchik
              Reporter:
              alice Alice Sherepa
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: