Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.0.17, 5.5(EOL), 10.0(EOL)
-
None
-
CentOS release 6.6 (Final)
Kernel: 2.6.32-358.23.2.el6.x86_64
-
5.5.45
Description
We were running a very large insert (500M rows) from an innodb table to a tokudb table.
The insert failed and the mariadb crashed. Which came 1st is still unknown at this point.
The tokudb table has 700 partitions with 4 indexes.
After the failures anything regarding TokuDB metadata was returning that error: No such file or directory. Whether we were looking at this table or another.
show table status...
Select * from TokuDB_fractal_tree_info;
Using sysdig, we found out that no mater what table you would be looking at, tokudb opens all tokudb related files. And in this case, the file it was looking for, existed but had a different name.
The file it was looking for was:
/data/mysql/tokudb_data/_MYDB_MYTAB_P_day_20140101_key_idx1_9a60c_2_1b_B_3.tokudb
But the file was named:
/data/mysql/tokudb_data/_MYDB_MYTAB_P_day_20140101_key_idx1_99906_5_1b.tokudb
We shutdown the database, and renamed the file, and all worked after that.
We tried many thing to get around the problem, one was to drop the table, which wasn't possible as it was giving us the same error.
Attachments
Issue Links
- is blocked by
-
MDEV-8259 5.5.44 merge
- Closed