mariadb tries to delete the wrong file from tmp directory
Running mariadb-server.x86_64 1:5.5.60-1.el7_5 from Centos Base Repo
I have a temp directory that is filling up, and log entries such as:
2019-07-15 12:33:02 140419247667968 [Warning] Could not remove temporary table: '/mariadb_tmp/#sql3db2_d430e2_0', error: 2 2019-07-15 12:33:04 140419247360768 [Warning] Could not remove temporary table: '/mariadb_tmp/#sql3db2_d4315c_0', error: 2
When I look for this file, I don't find it, but I do find the filename with .ibd as in:
-rw-rw---- 1 mysql mysql 606208 Jul 15 12:33 #sql3db2_d430ba_0.ibd -rw-rw---- 1 mysql mysql 344064 Jul 15 12:34 #sql3db2_d4315c_0.ibd
Not sure what is going on here. Any help welcomed.
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.