|
It will be good if MariaDB could detect if a running query fills up the tmp directory and if there is no free space left for some time (configurable option ? ) to roll back /cancel the transaction and to clear the created internal temp tables /Aria/ on the disk.
Example on mysqld: Retry in 60 secs. to roll back or to cancel the query that created the temp table on the disk but to clean the temp tables before that :
150618 2:29:24 [Warning] mysqld: Retry in 60 secs. Message reprinted in 600 secs
|
150618 2:30:24 [Warning] mysqld: Disk is full writing '/mysql_tmp/#sql_2941_1.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)
|
150618 2:30:24 [Warning] Message reprinted in 600 secs
|
150618 2:30:24 [Warning] mysqld: Disk is full writing '/mysql_tmp/#sql_2941_1.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)
|
150618 2:30:24 [Warning] mysqld: Retry in 60 secs. Message reprinted in 600 secs
|
150618 2:31:24 [ERROR] mysqld got signal 11 ;
|
|