Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-38216

restore of dumped databases fails since ver 11.8.4 with ERROR 1100 if constraints are in place

    XMLWordPrintable

Details

    • Q1/2026 Galera Development

    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.

      Attachments

        Issue Links

          Activity

            People

              hemantdangi Hemant Dangi
              it-admin@gleif.org Christian Schulze
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.