From owner-freebsd-questions@FreeBSD.ORG  Fri Apr 24 14:13:48 2015
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
Delivered-To: questions@freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org [8.8.178.115])
 (using TLSv1.2 with cipher AECDH-AES256-SHA (256/256 bits))
 (No client certificate requested)
 by hub.freebsd.org (Postfix) with ESMTPS id 567FDBD3
 for <questions@freebsd.org>; Fri, 24 Apr 2015 14:13:48 +0000 (UTC)
Received: from mout.gmx.net (mout.gmx.net [212.227.15.18])
 (using TLSv1.2 with cipher DHE-RSA-AES256-GCM-SHA384 (256/256 bits))
 (Client CN "mout.gmx.net", Issuer "TeleSec ServerPass DE-1" (verified OK))
 by mx1.freebsd.org (Postfix) with ESMTPS id E21691F6A
 for <questions@freebsd.org>; Fri, 24 Apr 2015 14:13:47 +0000 (UTC)
Received: from [192.168.0.143] ([95.91.226.186]) by mail.gmx.com (mrgmx002)
 with ESMTPSA (Nemesis) id 0M2ckv-1ZdsuM2goH-00sL0m; Fri, 24 Apr 2015 16:13:39
 +0200
Message-ID: <553A4F92.70804@gmx.de>
Date: Fri, 24 Apr 2015 16:13:38 +0200
From: "lokadamus@gmx.de" <lokadamus@gmx.de>
User-Agent: Mozilla/5.0 (X11; FreeBSD i386;
 rv:31.0) Gecko/20100101 Thunderbird/31.6.0
MIME-Version: 1.0
To: David Banning <david+dated+1430260101.161ef0@skytracker.ca>, 
 questions@freebsd.org
Subject: Re: mysql keeping running but stops serving
References: <20150423222819.GA17139@skytracker.ca>
In-Reply-To: <20150423222819.GA17139@skytracker.ca>
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: 7bit
X-Provags-ID: V03:K0:L/90WYYa10VsISSg1YfjXplHERvVw0lCEh0hdxNsaTToetEL+A9
 7q3tc7R3vd+Kz4NmNPe+C72HQLIgvHySc6Sd/MJpXNUFRY06WPNxamHgl+gb4248m7p9oeE
 qXPcP05iWLKQQ+8nxW5zlwrxlBdmE1pwEHr/D2M2dKHdeBa/X99CmnkDORil1MgISt/8ECP
 lBk9DuSsnEIDl7eyej36g==
X-UI-Out-Filterresults: notjunk:1;
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.20
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/options/freebsd-questions>, 
 <mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions/>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
 <mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Fri, 24 Apr 2015 14:13:48 -0000

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