Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
10.0.27
-
None
-
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
Attachments
Activity
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 
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.
Hi Jan,
How can I see that commit? Just curious to see the fix.
Thanks.
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
|
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.