SQLSTATE[HY000]: General error: 6 Error on delete of '/tmp/#sql_10f07_0.MAI' (Errcode: 2 "No such file or directory")
this error has started to pop up every now and then in different queries all across my app. This is basically the last ditch effort of getting this solved.
Server information
- /tmp/ permissions -> root:root 777
- Issue happens on both of our identical servers
Database information
- MariaDB 10.4.15 database server
- Database is in a Master - Master sync with its counterpart on the other server using Galera cluster.
Possible causes
- Restart of workers is scheduled about 20 minutes before the issue appeared last == they would get disconnected from the database.
Logs
- Went through both mysqld and system logs
- In mysqld logs, only thing that shows up at the time is a deadlock, which is handeled by the code and most likely completely unrelated since deadlocks happen quite a few times per day and none of them cause this issue:
- System logs dont show anything during the time of the issue.
Similar issues found online and why they didn't work
- MAMP - mysqli_query(): (HY000/6): Error on delete of ....
- This is just a permission issue and its on windows, the /tmp/ folder has 777 with the owner and group of root:root
- https://forums.mysql.com/read.php?20,604184
- It isnt a permission isssue, since AFAIK that would cause it to not work all the time and i can go multiple days without the issue appearing
- Mariadb: Can't create/write to file '/var/tmp/#sql_c27_0.MAI' (Errcode: 2 "No such file or directory")
- Disk has plenty of free space(TBs of it)
- Symfony3 - SQLSTATE[HY000] [2002] No such file or directory
- This is already the case with out symfony setup and probably unrelated - Just grasping at straws
