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

ALTER TABLE xxx IMPORT TABLESPACE: SQLSTATE[HY000]: General error: 1810 IO Read error: (1916247584, (null)) when importing tablespace from Linux Server into Windows Server

    XMLWordPrintable

Details

    Description

      Copying Transportable Tablespaces for Non-partitioned Tables cannot be completed when importing a table from Linux server to Windows Server:
      On Linux Server:
      Step 0: ALTER TABLE t1 FORCE successful
      Step 1: FLUSH TABLES t1 FOR EXPORT successful
      Step 2: store result of SHOW CREATE TABLE t1
      Step 3: copying t1.ibd (and t1.cfg) to saved-tablespaces-directoy successful
      Step 4: UNLOCK TABLES successfull
      On Windows Server (after transfer of t1.*-files)
      Step 5: DROP TABLE t1 sucsessful
      Step 6: CREATE TABLE t1 as stored in step 2 successful
      Step 7: ALTER TABLE t1 DISCARD TABLESPACE successful
      Step 8: move t1.ibd and t1.cfg to datadir (successful)
      Step 9: ALTER TABLE t1 IMPORT TABLESPACE (fails)
      Error Message is "IMPORT TABLESPACE: SQLSTATE[HY000]: General error: 1810 IO Read error: (1916247584, (null)) "

      Due to this error, the data are not importetd into the table.

      The storage formats for temporal columns and the ROW_FORMAT-values are identical.
      Data-at-Rest Encryption is activated on the Linux server and on the Windows server. The keys are identical on both servers.
      This procedure works fine when transferring tables between two windows servers, between two Linux servers, and from a Windows Server to a Linux server. Only the transfer from a Linux server to a Windows server fails.

      Attachments

        1. my.cnf
          0.7 kB
        2. my.ini
          0.7 kB

        Activity

          People

            Unassigned Unassigned
            Pszola Bernhard Pszola
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.