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






















