Drop database will not delete abandoned TokuDB files after getting error from storage engine
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS | Status tracked in 5.7 | |||||
5.6 |
Triaged
|
Medium
|
Unassigned | |||
5.7 |
Triaged
|
Medium
|
Unassigned |
Bug Description
Wrote a simple script for creating "Too many open files" error in Percona Server with TokuDB tables.
After a while got:
23 (HY000): Out of resources when opening file './tokudb_tables/' (Errcode: 24 - Too many open files)
1030 (HY000): Got error 1 from storage engine
1030 (HY000): Got error 24 from storage engine
1030 (HY000): Got error 24 from storage engine
23 (HY000): Out of resources when opening file './tokudb_tables/' (Errcode: 24 - Too many open files)
1030 (HY000): Got error 1 from storage engine
1030 (HY000): Got error 24 from storage engine
1030 (HY000): Got error 24 from storage engine
1030 (HY000): Got error 24 from storage engine
23 (HY000): Out of resources when opening file './tokudb_tables/' (Errcode: 24 - Too many open files)
Then restarted MySQL and tried to drop tokudb_tables database:
mysql> drop database tokudb_tables;
Query OK, 11878 rows affected (1 min 11.90 sec)
But there are abandoned TokuDB files in tokudb_data_dir after drop database:
Key files:
root@percona-
11733
Prrimary key files:
root@percona-
95
Stat files:
root@percona-
155
Some of files:
-rw-rw---- 1 mysql mysql 0 нояб. 13 12:51 _tokudb_
-rw-rw---- 1 mysql mysql 0 нояб. 13 12:51 _tokudb_
-rw-rw---- 1 mysql mysql 0 нояб. 13 12:51 _tokudb_
-rw-rw---- 1 mysql mysql 0 нояб. 13 12:51 _tokudb_
After all we must manually delete these files.
https:/ /tokutek. atlassian. net/browse/ DB-960