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

main.create_or_replace fails sporadically in buildbot (timeout)

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Major
        • Resolution: Fixed
        • Affects Version/s: 10.0
        • Fix Version/s: 10.0.16
        • Component/s: Tests
        • Labels:

          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;

            Gliffy Diagrams

              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.
                • Stalled

                  Activity

                  Hide
                  Permalink
                  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
                  Show
                  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

                    • Assignee:
                      serg Sergei Golubchik
                      Reporter:
                      elenst Elena Stepanova
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      2 Start watching this issue

                      Dates

                      • Created:
                        Updated:
                        Resolved: