← Back to team overview

maria-discuss team mailing list archive

New Question: mysqld fills /tmp with file /tmp/#sql_26be_0.MAD



A new question has been asked in "MariaDB Documentation" by aferrett. Please answer it at http://mariadb.com/kb/en/mysqld-fills-tmp-with-file-tmpsql_26be_0mad/ as the person asking the question may not be subscribed to the mailing list.

We have MariaDB CE 10.1.11 running on RHEL.
We were loading data and started getting this error in the mysqld.log:
2016-04-22  9:45:54 139696698296064 [Warning] mysqld: Disk is full writing '/tmp/#sql_26be_0.MAD' (Errcode: 28 "No space left on device"). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)
We moved the large file out of /tmp, but had to reboot in order to free up the /tmp.  Restarted mysqld and it appears to be OK.
Any information on what this might be and how to get to root cause will be appreciated.


To view or answer this question please visit: http://mariadb.com/kb/en/mysqld-fills-tmp-with-file-tmpsql_26be_0mad/