[MDEV-29667] Server hangs on DROP DATABASE after failing LOCK TABLES on Spider table Created: 2022-09-29  Updated: 2023-11-22  Resolved: 2023-11-17

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - Spider
Affects Version/s: 10.3, 10.4, 10.5, 10.6, 11.1
Fix Version/s: 10.4.33, 10.5.24, 10.6.17, 10.11.7, 11.0.5, 11.1.4, 11.2.3

Type: Bug Priority: Critical
Reporter: Nayuta Yanagisawa (Inactive) Assignee: Yuchen Pei
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Blocks
is blocked by MDEV-30014 heap-use-after-free in ha_spider::lo... Closed
PartOf
is part of MDEV-30014 heap-use-after-free in ha_spider::lo... Closed
Relates
relates to MDEV-29484 Assertion `!trx_free || !trx->locked_... Closed

 Description   

mdev_29667.test

--disable_query_log
--disable_result_log
--source ../../t/test_init.inc
--enable_result_log
--enable_query_log
 
--connection child2_1
CREATE DATABASE auto_test_remote;
USE auto_test_remote;
eval CREATE TABLE tbl_a (
    a INT
) $CHILD2_1_ENGINE $CHILD2_1_CHARSET;
 
--connection master_1
CREATE DATABASE auto_test_local;
USE auto_test_local;
eval CREATE TABLE tbl_a (
    a INT
) $MASTER_1_ENGINE $MASTER_1_CHARSET COMMENT='table "tbl_a", srv "s_2_1"';
eval CREATE TABLE tbl_b (
    a INT
) $MASTER_1_ENGINE $MASTER_1_CHARSET;
 
LOCK TABLES tbl_a WRITE;
--error 1429
LOCK TABLES tbl_b READ, tbl_a READ;
 
--connection master_1
DROP DATABASE IF EXISTS auto_test_local;
 
--connection child2_1
DROP DATABASE IF EXISTS auto_test_remote;
 
--disable_query_log
--disable_result_log
--source ../t/test_deinit.inc
--enable_query_log
--enable_result_log

mdev_29667.cnf

!include include/default_mysqld.cnf
!include ../my_1_1.cnf
!include ../my_2_1.cnf



 Comments   
Comment by Yuchen Pei [ 2023-05-15 ]

I could reprod this at 11.1, taking over

Comment by Yuchen Pei [ 2023-11-17 ]

fixed by MDEV-30014

Generated at Thu Feb 08 10:10:22 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.