MySQL 5.7 keeps restarting

ericovk

Verified User
Joined
Apr 17, 2012
Messages
219
Location
Rotterdam, Netherlands
Yesterday I upgraded MySQL from 5.5 to 5.6 and directly to 5.7.25.
I also rebuild php, and configured it from 2 php options to 4 php options.
After the installation everything looked fine, but mysql keeps 'crashing' every 10 ~ 20 minutes.

I checked Apache (root and user level) logs and MySQL logs, but found no errors, only some notices.

I think that MySQL or the server is running out of resources and MySQL is restarting itself after x minutes. (Sites can connect after a couple of minutes). Last night the entire server crashed anyway so I had to do a reboot this morning.

Got these error logs from last afternoon, they are pretty unrelated because the mysql server restarted every 10 ~ 20 minutes and these lines only appeared once in the logs:

/var/log/httpd/error_logs tail:

HTML:
p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Andale Mono'; color: #2fff12; background-color: #000000; background-color: rgba(0, 0, 0, 0.9)}span.s1 {font-variant-ligatures: no-common-ligatures}[Mon Sep 30 17:33:05.501155 2019] [core:warn] [pid 1719:tid 140335202920384] AH00045: child process 6669 still did not exit, sending a SIGTERM
[Mon Sep 30 17:33:07.946236 2019] [core:warn] [pid 1719:tid 140335202920384] AH00045: child process 6669 still did not exit, sending a SIGTERM
[Mon Sep 30 17:33:10.093219 2019] [core:warn] [pid 1719:tid 140335202920384] AH00045: child process 6669 still did not exit, sending a SIGTERM
[Mon Sep 30 17:33:11.518737 2019] [core:error] [pid 1719:tid 140335202920384] AH00046: child process 6669 still did not exit, sending a SIGKILL
[Mon Sep 30 17:33:12.533569 2019] [mpm_event:notice] [pid 1719:tid 140335202920384] AH00494: SIGHUP received.  Attempting to restart
[Mon Sep 30 17:33:12.872753 2019] [ssl:warn] [pid 1719:tid 140335202920384] AH01909: localhost:443:0 server certificate does NOT include an ID which matches the server name
[Mon Sep 30 17:33:12.874314 2019] [ssl:warn] [pid 1719:tid 140335202920384] AH01909: shared.domain:443:0 server certificate does NOT include an ID which matches the server name
[Mon Sep 30 17:33:12.875874 2019] [ssl:warn] [pid 1719:tid 140335202920384] AH01909: www.example.com:443:0 server certificate does NOT include an ID which matches the server name
[Mon Sep 30 17:33:12.878426 2019] [lbmethod_heartbeat:notice] [pid 1719:tid 140335202920384] AH02282: No slotmem from mod_heartmonitor
[Mon Sep 30 17:33:12.883244 2019] [mpm_event:notice] [pid 1719:tid 140335202920384] AH00489: Apache/2.4.41 (Unix) OpenSSL/1.0.1e-fips configured -- resuming normal operations
[Mon Sep 30 17:33:12.883296 2019] [core:notice] [pid 1719:tid 140335202920384] AH00094: Command line: '/usr/sbin/httpd'
 

ericovk

Verified User
Joined
Apr 17, 2012
Messages
219
Location
Rotterdam, Netherlands
PS: when MySQL isn’t available, the websites show the message can’t connect to sock. The sock file is available on the server though.
 
Top