Server disconnecting with mysql databases

dshorms · 10-29-2015, 05:30 AM

I've been running a vps with Heart Internet for nearly a year now and a few times all sites have disconnected with their mysql databases. The only way to get the databases reconnected is a manual server reboot.

The Server is running CENTOS 6.7 x86_64 kvm – 519609 and the error log on the last occurrence shows the following

Code:

[Thu Oct 22 21:19:51 2015] [error] [client 207.46.13.142] File does not exist: /home/websitedomain/public_html/shop
[Thu Oct 22 21:19:51 2015] [error] [client 207.46.13.142] File does not exist: /home/websitedomain/public_html/404.shtml
[Thu Oct 22 21:19:51 2015] [error] [client 207.46.13.142] File does not exist: /home/websitedomain/public_html/latest-news
[Thu Oct 22 21:19:51 2015] [error] [client 207.46.13.142] File does not exist: /home/websitedomain/public_html/404.shtml
[Thu Oct 22 21:19:51 2015] [error] [client 207.46.13.142] File does not exist: /home/websitedomain/public_html/shop
[Thu Oct 22 21:19:51 2015] [error] [client 207.46.13.142] File does not exist: /home/websitedomain/public_html/404.shtml
[Thu Oct 22 21:30:53 2015] [notice] caught SIGTERM, shutting down
[Thu Oct 22 21:31:44 2015] [warn] RSA server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
[Thu Oct 22 21:31:44 2015] [notice] suEXEC mechanism enabled (wrapper: /usr/local/apache/bin/suexec)
[Thu Oct 22 21:31:44 2015] [notice] Digest: generating secret for digest authentication ...
[Thu Oct 22 21:31:44 2015] [notice] Digest: done
[Thu Oct 22 21:31:45 2015] [warn] RSA server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
[Thu Oct 22 21:31:45 2015] [notice] Apache/2.2.29 (Unix) mod_ssl/2.2.29 OpenSSL/1.0.1e-fips mod_bwlimited/1.4 configured -- resuming normal operations
[Thu Oct 22 21:40:08 2015] [error] [client 207.46.13.137] File does not exist: /home/websitedomain/public_html/shop
[Thu Oct 22 21:40:08 2015] [error] [client 207.46.13.137] File does not exist: /home/websitedomain/public_html/404.shtml

I think it is something connected to

Code:

caught SIGTERM, shutting down

but no idea what this means. I've googled it but not found this same problem. There's also a lot of attempts from IP addresses trying to access files that don't exist.

Thanks and any ideas?

delite · 10-29-2015, 10:33 PM

SIGTERM is a terminate signal sent to a process running a program, https://en.wikipedia.org/wiki/Unix_signal

I don't know what is causing your server to shutdown, but you don't need to reboot the OS, instead you could create a cron job to check if the server is running and if not to restart it.

When you say, "all sites have disconnected with their mysql databases", do you have multiple websites or is happening to others at the same time? If its happening to all then its Hearts issue at the machine level, but your logs to me indicate that the logs are actually the webserver and not the database, so, are no pages served when this happens or are pages served but display a specific database error?

chrism01 · 10-29-2015, 11:02 PM

Quote:

your logs to me indicate that the logs are actually the webserver and not the database

Indeed, that's the Apache error_log showing Apache (not the DB) shutting down, then restarting almost immediately.

You need to find out why - no need to reboot anything (depending on exactly how your app code works).

BTW, try nslookup on those addresses...

dshorms · 10-30-2015, 06:14 AM

Thanks for the replies.

Delite - I have multiple wordpress sites hosted on my server, when this error happens each site defaults back to the wordpress installation screen, suggesting that each site isn't connected to the database. Any none database site is still displayed as normal. So would it seem the server is rebooting ok, but not restarting mysql?