[MDEV-28079] Shutdown hangs after altering innodb partition fts table Created: 2022-03-16  Updated: 2022-03-16  Resolved: 2022-03-16

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - InnoDB
Affects Version/s: 10.6
Fix Version/s: 10.6.8, 10.7.4, 10.8.3

Type: Bug Priority: Major
Reporter: Thirunarayanan Balathandayuthapani Assignee: Thirunarayanan Balathandayuthapani
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Problem/Incident
is caused by MDEV-25506 Atomic DDL: .frm file is removed and ... Closed

 Description   

Shutdown keeps on hanging because purge threads are waiting on purge_sys.check_stop_FTS()

--source include/have_partition.inc
 
--source include/have_innodb.inc
 
create table t1 (f1 int, f2 char(100))engine=innodb partition by hash(f1) partitions 2;
 
ALTER TABLE t1 ADD FULLTEXT(f2);
 
set global innodb_fast_shutdown=0;
 
--source include/restart_mysqld.inc
 
DROP TABLE t1;

stop_FTS is being called for each partition, but it calls resume_FTS() only once in alter command.

 Comments   
Comment by Marko Mäkelä [ 2022-03-16 ]

Thank you, the logic of the fix looks good to me. For the regression test, I hope that we can reproduce this with wait_all_purged.inc instead of requiring a server restart.

Generated at Thu Feb 08 09:57:53 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.