fomu65
By:
fomu65

Restored from backup and very little is working

September 10, 2015 764 views
Backups MySQL Ubuntu

Ubuntu 14.04 with latest patches. Running node, ghost, MySQL, sqlbuddy, nginx, feed a fever and phpbb3. Been running just fine for a couple years now.

Had issues with node and ghost, specifically latest versions of each. Reverted to older version of node to resolve and that didn't work. I decided to revert to a backup from two days ago and this is when the real problem started. Backup restored just fun, but the second time fever went to refresh, MySQL died and wouldn't come back up. I tried to ssh in and got connection interrupted error. Was able to get back in via web console and see syslog showing errors about appshield and being unable to open socket for MySQL. I restore again thinking something just went bad and same problem. I restore from and 8 day old backup and same thing. Now I'm freaking out just a bit.

Fever is giving this error:

PDO/MySQL Error (2002): SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)

Syslog shows this whenever the Fever cron job runs:

Sep 9 22:30:01 highgravityconsulting CRON[2089]: (fomu65) CMD (curl -L -s --user-agent 'Fever Refresh Cron' 'http://fever.hig$
Sep 9 22:32:22 highgravityconsulting kernel: [ 261.197663] init: mysql main process (844) terminated with status 1
Sep 9 22:32:22 highgravityconsulting kernel: [ 261.197684] init: mysql main process ended, respawning
Sep 9 22:32:22 highgravityconsulting kernel: [ 261.217473] auditprintkskb: 15 callbacks suppressed
Sep 9 22:32:22 highgravityconsulting kernel: [ 261.217477] type=1400 audit(1441852342.215:17): apparmor="STATUS" operation="$
Sep 9 22:32:23 highgravityconsulting kernel: [ 262.421893] init: mysql main process (2190) terminated with status 1
Sep 9 22:32:23 highgravityconsulting kernel: [ 262.421911] init: mysql main process ended, respawning
Sep 9 22:32:24 highgravityconsulting kernel: [ 263.278897] init: mysql post-start process (2191) terminated with status 1
Sep 9 22:32:24 highgravityconsulting kernel: [ 263.287959] type=1400 audit(1441852344.283:18): apparmor="STATUS" operation="$
Sep 9 22:32:25 highgravityconsulting kernel: [ 264.438051] init: mysql main process (2250) terminated with status 1
Sep 9 22:32:25 highgravityconsulting kernel: [ 264.438070] init: mysql respawning too fast, stopped

Anyone have an idea of what has happened and any ideas on what I can do to fix this? I have never seen anything like this and searching on the web has returned zero useful results.

Be the first one to answer this question.