Author Topic: MySQL Server down after daily cron  (Read 9774 times)

0 Members and 1 Guest are viewing this topic.

Offline
*
MySQL Server down after daily cron
« on: July 11, 2016, 06:09:33 AM »
Hi!

Every night after daily cron mySQL Server is down. Have to restart it manually every morning. Problem exists after CWP Version 0.9.8.17

Daily Cron Mail:

/etc/cron.daily/cwp:



====================================================
============= CentOS Web Panel Cron ================
====================================================


###########################
Firewall Flush Daily Blocks
###########################


######################
Update Server Packages
######################
Your CWP version: 0.9.8.24

No update needed, your CWP is up to date.
xxx.xxx.xx.xxx
Date which backup script is using: 2016-07-11 01:41:04

PHP Warning:  [obfuscated](): No such file or directory in /usr/local/cwpsrv/htdocs/resources/admin/include/cron_backup.php on line 0

Warning: [obfuscated](): No such file or directory in /usr/local/cwpsrv/htdocs/resources/admin/include/cron_backup.php on line 0
<br><br>Trying to start mysql server, please reload browser!<br><br>Could not connect: No such file or directory

Cron Log:

Jul 11 03:41:01 host anacron[27213]: Job `cron.daily' started
Jul 11 03:41:01 host run-parts(/etc/cron.daily)[27847]: starting amavisd
Jul 11 03:41:01 host run-parts(/etc/cron.daily)[27855]: finished amavisd
Jul 11 03:41:01 host run-parts(/etc/cron.daily)[27847]: starting certwatch
Jul 11 03:41:01 host run-parts(/etc/cron.daily)[27861]: finished certwatch
Jul 11 03:41:01 host run-parts(/etc/cron.daily)[27847]: starting cwp
Jul 11 03:41:01 host CROND[27871]: (root) CMD (sync; echo 3 > /proc/sys/vm/drop_caches)
Jul 11 03:41:05 host run-parts(/etc/cron.daily)[28160]: finished cwp
Jul 11 03:41:05 host run-parts(/etc/cron.daily)[27847]: starting freshclam
Jul 11 03:41:12 host run-parts(/etc/cron.daily)[28174]: finished freshclam
Jul 11 03:41:12 host run-parts(/etc/cron.daily)[27847]: starting logrotate
Jul 11 03:41:12 host run-parts(/etc/cron.daily)[28181]: finished logrotate
Jul 11 03:41:12 host run-parts(/etc/cron.daily)[27847]: starting makewhatis.cron
Jul 11 03:41:13 host run-parts(/etc/cron.daily)[28342]: finished makewhatis.cron
Jul 11 03:41:13 host run-parts(/etc/cron.daily)[27847]: starting mlocate.cron
Jul 11 03:41:28 host run-parts(/etc/cron.daily)[28353]: finished mlocate.cron
Jul 11 03:41:28 host run-parts(/etc/cron.daily)[27847]: starting prelink
Jul 11 03:41:28 host run-parts(/etc/cron.daily)[28365]: finished prelink
Jul 11 03:41:28 host run-parts(/etc/cron.daily)[27847]: starting readahead.cron
Jul 11 03:41:28 host run-parts(/etc/cron.daily)[28377]: finished readahead.cron
Jul 11 03:41:28 host run-parts(/etc/cron.daily)[27847]: starting tmpwatch
Jul 11 03:41:28 host run-parts(/etc/cron.daily)[28415]: finished tmpwatch
Jul 11 03:41:28 host anacron[27213]: Job `cron.daily' terminated (mailing output)
Jul 11 03:41:28 host anacron[27213]: Normal exit (1 job run)
Jul 11 03:42:01 host crond[6651]: (*system*) RELOAD (/etc/cron.d/cwp.sh)

MySQLd Log:

160711  3:41:02 [Note] /usr/libexec/mysqld: Normal shutdown

160711  3:41:02 [Note] Event Scheduler: Purging the queue. 0 events
160711  3:41:04  InnoDB: Starting shutdown...
160711 03:41:04 mysqld_safe A mysqld process already exists
160711  3:41:06  InnoDB: Shutdown completed; log sequence number 357504389
160711  3:41:06 [Note] /usr/libexec/mysqld: Shutdown complete

160711 03:41:06 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
160711 05:50:02 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql

Help appreciated!


Offline
*
Re: MySQL Server down after daily cron
« Reply #1 on: July 11, 2016, 08:59:39 AM »
can you use this contact form so we can check it
http://centos-webpanel.com/contact
AntiDDoS Protection (web + mail)
http://centos-webpanel.com/website-ddos-protection-proxy

Join our Development Team and get paid !
http://centos-webpanel.com/develope-modules-for-cwp


Services Monitoring & RBL Monitoring
http://centos-webpanel.com/services-monitor


Do you need Fast and FREE Support included for your CWP linux server?
http://centos-webpanel.com/noc-partner-list
Installation Instructions
http://centos-webpanel.com/installation-instructions
Get Fast Support Here
http://centos-webpanel.com/support-services

Offline
***
Re: MySQL Server down after daily cron
« Reply #2 on: July 20, 2016, 08:37:53 AM »
Maybe you you add another cron to automatic restart mysqld service after that daily cron

service mysqld restart