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

Import with disabled keys corrupts meta-data like rows, indexes, ...

    XMLWordPrintable

Details

    Description

      When importing a dump created by mysqldump with default options meta-data like Rows and Avg_row_length are 0 and Data_length is 16 KB and indexes are not available anymore which leads to long running or locking queries. Only after executing an optimize table afterwards corrects this or whem using the option skip-disable-keys for creating dump.

      Attached test-script to reproduce the problem and output.

      Already reported at MDEV-27214, but closed because it "appeared that this problem duplicates MDEV-28327".
      However, it the issue still exists with the latest 10.6-version 10.6.12.
      Unfortunately, my request to reopen the ticket 4 month ago was ignored.

      Attachments

        1. test-duration.sh
          1 kB
        2. test.sh
          0.7 kB
        3. results.txt
          6 kB

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-27214 Import with disabled keys corrupts meta-data like rows, indexes, ...

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Activity

            People

              marko Marko Mäkelä
              alex2 Alex
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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