Control Web Panel
WebPanel => MySQL => Topic started by: Bernie 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!
-
can you use this contact form so we can check it
http://centos-webpanel.com/contact
-
Maybe you you add another cron to automatic restart mysqld service after that daily cron
service mysqld restart