Skip site navigation (1)Skip section navigation (2)
Date:      Fri, 24 Apr 2015 16:13:38 +0200
From:      "lokadamus@gmx.de" <lokadamus@gmx.de>
To:        David Banning <david+dated+1430260101.161ef0@skytracker.ca>,  questions@freebsd.org
Subject:   Re: mysql keeping running but stops serving
Message-ID:  <553A4F92.70804@gmx.de>
In-Reply-To: <20150423222819.GA17139@skytracker.ca>
References:  <20150423222819.GA17139@skytracker.ca>

next in thread | previous in thread | raw e-mail | index | archive | help
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



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?553A4F92.70804>