[MDEV-7158] main.create_or_replace fails sporadically in buildbot (timeout) Created: 2014-11-22  Updated: 2015-03-10  Resolved: 2015-03-10

Status: Closed
Project: MariaDB Server
Component/s: Tests
Affects Version/s: 10.0
Fix Version/s: 10.0.16

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Sergei Golubchik
Resolution: Fixed Votes: 0
Labels: buildbot, tests

Issue Links:
Relates
relates to MDEV-7069 Fix buildbot failures in main server ... Stalled

 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;



 Comments   
Comment by Elena Stepanova [ 2015-03-10 ]

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

Generated at Thu Feb 08 07:17:27 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.