mysql keeping running but stops serving

lokadamus at gmx.de lokadamus at gmx.de
Fri Apr 24 14:13:48 UTC 2015


On 04/24/15 00:28, David Banning wrote:
> After years of great service mysql stops working every 24 hours or so.
> Consulting the error log 3s1.com.err (my domain is 3s1.com) 
> 
> The log shows the server starting,  then without logging anything, it stops
> working after maybe 18 hours - it keeps running, but stops serving. 
> 
> The shutdown is my command, but you can see mysql does not want to shutdown.
> The "Forcing close of thead.." continues indefinitely.
> 
> Any pointers toward resolution would be helpful. Can I get more elaborate 
> logging?
> 
> 
> 
> 150422 22:59:17  mysqld started
> 150422 22:59:17 [Warning] No argument was provided to --log-bin, and --log-bin-index
> was not used; so replication may break when this MySQL server acts as a master
> and has his hostname changed!! Please use '--log-bin=3s1-bin' to avoid this problem.
Have you look at your my.cnf?
https://dev.mysql.com/doc/refman/5.0/en/replication-options-binary-log.html

Greetings


More information about the freebsd-questions mailing list