[MDEV-6764] Shutdown fails when disk full Created: 2014-09-21  Updated: 2014-11-19  Due: 2014-11-17  Resolved: 2014-11-19

Status: Closed
Project: MariaDB Server
Component/s: OTHER
Affects Version/s: 10.0.13
Fix Version/s: N/A

Type: Bug Priority: Minor
Reporter: Marc Gray Assignee: Elena Stepanova
Resolution: Incomplete Votes: 0
Labels: None
Environment:

CentOS 6.5


 Description   

I imported a few hundred gb of data and ran out of disk space, so I cancelled the import (Ctrl+C). At this point the logs show:

140919 15:12:54 [Warning] mysqld: Disk is full writing './mysql-bin.000055' (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)
 
140919 15:12:54 [Warning] mysqld: Retry in 60 secs. Message reprinted in 600 secs
 
140919 15:14:54 [Warning] mysqld: Disk is full writing './mysql-bin.000055' (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)
 
140919 15:14:54 [Warning] mysqld: Retry in 60 secs. Message reprinted in 600 secs
 
140919 15:24:54 [Warning] mysqld: Retry in 60 secs. Message reprinted in 600 secs

I forgot about it until today (2 days later) and attempted to stop the service (service mysql stop), but realised the disk space issue is probably blocking it. I freed 7gb (actually free, not open files locking space!) and tried to stop it again, with no success.

There appears to be no writes to the log or binlog.

"strace" shows:

futex(0x13a8904, FUTEX_WAIT_PRIVATE, 5, NULL) = -1 EAGAIN (Resource temporarily unavailable)
 
futex(0x13a8904, FUTEX_WAIT_PRIVATE, 6, NULL



 Comments   
Comment by Elena Stepanova [ 2014-10-17 ]

Hi Marc,

Sorry for the delayed response.

What kind of import it was – loading a dump file via MySQL client, or executing LOAD DATA statement, or...?

Which engine(s) are you using?

Was the log (error log where the warnings were printed) in the same disk partition as the binlogs, so that it was also affected by the disk space problem?

Thanks

Comment by Elena Stepanova [ 2014-11-19 ]

Please comment to re-open if you have additional information.

Generated at Thu Feb 08 07:14:24 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.