Details
-
Bug
-
Status: Needs Feedback (View Workflow)
-
Major
-
Resolution: Unresolved
-
11.8.4, 11.8.5
-
None
-
Rocky Linux release 9.6
Description
after switching from mariadb 11.8.3 to 11.8.4 / 11.8.5 we can not restore tables when other tables have constraints, referencing the table to be restored.
e.g. Table `B` has: CONSTRAINT `x` FOREIGN KEY (`id2`) referencing Table `A` (`id`).
while trying to restore table A, we get
ERROR 1100 (HY000) at line 10: Table 'B' was not locked with LOCK TABLES.
this is new since 11.8.4 and is not expected. especially it is not compatible with parallel import of multiple tables.
since old backups can not be used any more, and we haven't found a workaround yet since locking all tables also does not seem to work, recovery strategies depending on dumps don't work any more.