Details
-
Type:
Task
-
Status: Open
-
Priority:
Major
-
Resolution: Unresolved
-
Fix Version/s: None
-
Component/s: Storage Engine - Aria
-
Labels:None
Description
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 ;
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions