This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-15. For the latest, interactive version please visit https://mariadb.com/kb/.

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.