[MDEV-25989] Crash (or hang) during first startup after restoring backup Created: 2021-06-22  Updated: 2021-06-22  Resolved: 2021-06-22

Status: Closed
Project: MariaDB Server
Component/s: Backup, Full-text Search, Storage Engine - InnoDB
Affects Version/s: 10.6.2
Fix Version/s: 10.6.3

Type: Bug Priority: Major
Reporter: Marko Mäkelä Assignee: Marko Mäkelä
Resolution: Fixed Votes: 0
Labels: recovery, regression-10.6

Issue Links:
Problem/Incident
is caused by MDEV-25854 Restoring a backup may result in garb... Closed

 Description   

If an ALTER TABLE that affected a table with FULLTEXT INDEX was running while a backup was taken, the server will crash or hang during the first startup, while trying to drop a #sql-alter- table that contains FULLTEXT INDEX.

10.6

 
#4  0x0000560bf4c51ed8 in dict_sys_t::assert_not_locked (this=<optimized out>) at /usr/include/pthread.h:1167
 
#5  fts_optimize_remove_table (table=table@entry=0x618000002908) at /data/Server/bb-10.6-MDEV-25062C/storage/innobase/fts/fts0opt.cc:2594
 
#6  0x0000560bf430924e in drop_garbage_tables_after_restore () at /data/Server/bb-10.6-MDEV-25062C/storage/innobase/handler/ha_innodb.cc:2027

The logic that was implemented in MDEV-25854 had not been tested with tables that contain FULLTEXT INDEX.
Generated at Thu Feb 08 09:41:55 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.