Mysql server fails to start [error : 28]
sudo service mysqld start
Timeout error occurred trying to start MySQL Daemon.
Starting MySQL: [FAILED]
Logs /var/log/mysqld :
mysqld Error: unable to create temporary file; errno: 28
Can't start server : Bind on unix socket: No space left on device
1. Check /tmp for permissions and space availability
2. df -h
Filesystem Size Used Avail Use% Mounted on
/dev/xvd 37G 35G 0M 100% /
...
tmpfs 2.0G 0 2.0G 0% /dev/shm
Now, /tmp is under / which has 0 M available and is 100% used.
3. ls -lrt /tmp . Its lined up with loads of RackMultipart files
Reason: Paperclip Issue
Check the no. of such files
> ls -lrt /tmp/RackMultipart* | wc -l
> 297
4. Remove these files
rm -f /tmp/RackMultipart*
5. Try again
sudo service mysqld start
Starting MySQL: [ OK ]
sudo service mysqld status
mysqld (pid 17048) is running...
Ref: http://man.chinaunix.net/database/manual_MySQL/manual_Problems.html













