My wife calls me while I was in my man cave tonight and tells me our mythbox has crashed and didn’t come back up with a reboot. I have a look and the thing it is asking me for the DB details (ie, location, password etc) – as if we are setting the mythtv installation again from scratch. This understandably throws me into a bit of a panic especially when she tells me she has already seen the screens and just entered through them! <\/p>\n
I wasn’t able to log into the mysql tables using the cli client. Manually starting the mysql db FAILED as did restarting it or even stopping it, they all FAILED.<\/p>\n
After digging in Google I noticed that the mysql.sock file that is created in \/var\/lib\/mysql and which the mysql client must use to connect to the mysql db server was appearing and then the next moment it was gone, very very strange.<\/p>\n
I looked at the size of the mysql.log file, it was over 3 GB! Looking in the mysql.log I see “Can’t start server: can’t create PID file: No space left on device”<\/em><\/strong> then the penny drops, I had run out of disk space on the root partition.<\/p>\n Deleting the 3GB mysql.log file gives me back 34% of \/, rebooted and then off I go.<\/p>\n So the moral of the story kiddies is to check your log files for a hint to what’s going on and make sure you have enough space left in \/ or mysql will bomb out,<\/p>\n","protected":false},"excerpt":{"rendered":" My wife calls me while I was in my man cave tonight and tells me our mythbox has crashed and didn’t come back up with a reboot. I have a look and the thing it is asking me for the DB details (ie, location, password etc) – as if we are setting the mythtv installation … <\/p>\n