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.