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

main.create_or_replace fails sporadically in buildbot (timeout)

Details

    Description

      http://buildbot.askmonty.org/buildbot/builders/kvm-fulltest2/builds/2949/steps/test_5/logs/stdio

       
      		 
      Test case timeout after 900 seconds
      		 
       
      		 
      == /run/shm/var_auto_wjF2/2/log/create_or_replace.log == 
      #	MDL_INTENTION_EXCLUSIVE	MDL_EXPLICIT	Schema metadata lock	test	
      #	MDL_SHARED_READ	MDL_EXPLICIT	Table metadata lock	test	t2
      		 
      create or replace table t1 select 1 as f1;
      		 
      select * from information_schema.metadata_lock_info;
      		 
      THREAD_ID	LOCK_MODE	LOCK_DURATION	LOCK_TYPE	TABLE_SCHEMA	TABLE_NAME
      		 
      #	MDL_INTENTION_EXCLUSIVE	MDL_EXPLICIT	Global read lock		
      #	MDL_SHARED_NO_READ_WRITE	MDL_EXPLICIT	Table metadata lock	test	t1
      		 
      #	MDL_INTENTION_EXCLUSIVE	MDL_EXPLICIT	Schema metadata lock	test	
      #	MDL_SHARED_READ	MDL_EXPLICIT	Table metadata lock	test	t2
      		 
      drop table t1;
      		 
      unlock tables;
      		 
      #
      		 
      # MDEV-6560
      		 
      # Assertion `! is_set() ' failed in Diagnostics_area::set_ok_status
      		 
      #
      		 
      CREATE TABLE t1 (col_int_nokey INT)  ENGINE=InnoDB;
      		 
      CREATE OR REPLACE TEMPORARY TABLE tmp LIKE t1;
      		 
      LOCK TABLE t1 WRITE;
      		 
      CREATE OR REPLACE TABLE t1 LIKE tmp;
      		 
      KILL QUERY con_id;

      Attachments

        Issue Links

          relates to

          Task - A task that needs to be done. MDEV-7069 Fix buildbot failures in main server trees

          • Major - Major loss of function.
          • Closed

          Activity

            elenst Elena Stepanova added a comment -

            Fixed in 10.0 tree by the following revision:

            revno: 4573
            		 
            revision-id: sergii@pisem.net-20150119131914-2h0sd0988be6czxd
            		 
            parent: sergii@pisem.net-20150119131905-zjcvewlb9dw85two
            		 
            fixes bug: https://mariadb.atlassian.net/browse/MDEV-7299
            		 
            committer: Sergei Golubchik <sergii@pisem.net>
            		 
            branch nick: 10.0
            		 
            timestamp: Mon 2015-01-19 14:19:14 +0100
            		 
            message:
            		 
              MDEV-7299 Assertion `m_status == DA_ERROR || m_status == DA_OK' fails on concurrent execution of DDL, queries from I_S, and KILL QUERY
            		 
              
              Fix MDL to report an error when a wait was killed, but preserve
            		 
              the old documented behavior of GET_LOCK() where killing it is not an error.
            		 
              
              Also remove race conditions in main.create_or_replace test

            elenst Elena Stepanova added a comment - Fixed in 10.0 tree by the following revision: revno: 4573 revision-id: sergii@pisem.net-20150119131914-2h0sd0988be6czxd parent: sergii@pisem.net-20150119131905-zjcvewlb9dw85two fixes bug: https://mariadb.atlassian.net/browse/MDEV-7299 committer: Sergei Golubchik <sergii@pisem.net> branch nick: 10.0 timestamp: Mon 2015-01-19 14:19:14 +0100 message: MDEV-7299 Assertion `m_status == DA_ERROR || m_status == DA_OK' fails on concurrent execution of DDL, queries from I_S, and KILL QUERY Fix MDL to report an error when a wait was killed, but preserve the old documented behavior of GET_LOCK() where killing it is not an error. Also remove race conditions in main.create_or_replace test

            People

              serg Sergei Golubchik
              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.