[MDEV-11106] Improve error messages when importing tablespaces Created: 2016-10-22  Updated: 2017-05-29  Resolved: 2016-10-29

Status: Closed
Project: MariaDB Server
Component/s: Data Definition - Alter Table, Storage Engine - InnoDB, Storage Engine - XtraDB
Affects Version/s: 10.0.27
Fix Version/s: 10.1.19

Type: Bug Priority: Minor
Reporter: Manuel Arostegui Assignee: Jan Lindström (Inactive)
Resolution: Fixed Votes: 0
Labels: None
Environment:

debian 8.6



 Description   

I am running MariaDB 10.0.27 and I was importing some tablespaces from another host.
All the tables were imported fine, but one of them was failing:

MariaDB DBSTORE localhost enwiki > alter table abuse_filter_action import tablespace;
ERROR 1810 (HY000): IO Read error: (139862985341824, ) (null)

When trying to debug the issue, the logs were not too helpful

InnoDB: Discarding tablespace of table "enwiki"."abuse_filter_action": Generic error

It would be nice to try to generate more verbosity with this kind of error.

Thanks

PS: Let me know if this rather needs to be reported to bugs.mysql.com



 Comments   
Comment by Jan Lindström (Inactive) [ 2016-10-27 ]

What did the show warnings; output ?

Comment by Manuel Arostegui [ 2016-10-27 ]

I didn't run it

Comment by Jan Lindström (Inactive) [ 2016-10-27 ]

Ok, do you have .cfg and .ibd file for abuse_filter_action table that causes problems and could you share that with us ?

Comment by Manuel Arostegui [ 2016-10-27 ]

No I don't have them anymore as this happened a few days ago, as I tried twice and the second time it worked fine - which is also weird because nothing changed in the way I did it.

Comment by Jan Lindström (Inactive) [ 2016-10-28 ]

If you do not have error logs or anything else that would help to get bottom of this, I can't help you anymore. If you see this again please do not remove anything. On surface it could be that you did run out of disk space when exporting but not sure as above IO error is quite generic.

Comment by Manuel Arostegui [ 2016-10-28 ]

We did not run out of space.
But that is the whole point, that the error is quite generic and doesn't help to debug or troubleshoot the issue.
The point of this ticket was to see if it would be possible be a bit more verbose when showing this error so you can actually start digging on it

Comment by Jan Lindström (Inactive) [ 2016-10-29 ]

commit de0f77a2a87e0d77df9cd2b079f51e3142db1e22
Author: Jan Lindström <jan.lindstrom@mariadb.com>
Date: Fri Oct 28 09:27:03 2016 +0300

MDEV-11106: Improve error messages when importing tablespaces

Add error message when used index_id in index page is not found
from configuration file.

Comment by Manuel Arostegui [ 2016-10-29 ]

Hi Jan,

How can I see that commit? Just curious to see the fix.
Thanks.

Comment by Manuel Arostegui [ 2017-05-29 ]

This is not yet fixed

root@db1095[(none)]> select @@version;
+-----------------+
| @@version       |
+-----------------+
| 10.1.23-MariaDB |
+-----------------+
1 row in set (0.00 sec)

2017-05-29 16:06:26 140601743619840 [Note] InnoDB: Discarding tablespace of table "wikidatawiki"."categorylinks": Generic error

Generated at Thu Feb 08 07:47:21 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.