[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 Created: 2020-12-28 Updated: 2021-02-16 Resolved: 2021-02-16 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Data Definition - Alter Table |
| Affects Version/s: | None |
| Fix Version/s: | N/A |
| Type: | Bug | Priority: | Major |
| Reporter: | Bernhard Pszola | Assignee: | Unassigned |
| Resolution: | Incomplete | Votes: | 0 |
| Labels: | need_feedback | ||
| Environment: |
Win 10, CentOS 7, mariadb 10.5.8 |
||
| Attachments: |
|
| Description |
|
Copying Transportable Tablespaces for Non-partitioned Tables cannot be completed when importing a table from Linux server to Windows Server: 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. |
| Comments |
| Comment by Elena Stepanova [ 2021-01-13 ] |
|
I can't reproduce this. |
| Comment by Bernhard Pszola [ 2021-01-13 ] |
|
I tried for different tables. The problem occurs even for tables with one row so that the .ibd file ist quite small. |
| Comment by Elena Stepanova [ 2021-01-14 ] |
|
Please attach configuration files (cnf/ini) and error logs from both the Linux donor and the Windows recipient. |
| Comment by Bernhard Pszola [ 2021-01-18 ] |
|
I attached the cnf/ini-files. |
| Comment by Elena Stepanova [ 2021-01-18 ] |
|
mariadb server error logs. Their names and location (and whether they are even separate files or a part of system logging) depend on your environment. |