From owner-freebsd-questions@FreeBSD.ORG Thu Apr 23 22:51:24 2015 Return-Path: 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 2CAE2226 for ; Thu, 23 Apr 2015 22:51:24 +0000 (UTC) Received: from 3s1.com (3s1.com [209.161.205.12]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (Client CN "3s1.com", Issuer "CA Cert Signing Authority" (not verified)) by mx1.freebsd.org (Postfix) with ESMTPS id D30811F10 for ; Thu, 23 Apr 2015 22:51:23 +0000 (UTC) Received: from 3s1.com (localhost [127.0.0.1]) by 3s1.com (8.14.4/8.14.4) with ESMTP id t3NMSN9c019096 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO) for ; Thu, 23 Apr 2015 18:28:23 -0400 (EDT) (envelope-from david+dated+1430260101.161ef0@skytracker.ca) Received: (from david@localhost) by 3s1.com (8.14.4/8.14.4/Submit) id t3NMSM8b019095 for questions@freebsd.org; Thu, 23 Apr 2015 18:28:22 -0400 (EDT) (envelope-from david+dated+1430260101.161ef0@skytracker.ca) X-Authentication-Warning: 3s1.com: david set sender to david+dated+1430260101.161ef0@skytracker.ca using -f Received: by 3s1.com (tmda-sendmail, from uid 1000); Thu, 23 Apr 2015 18:28:21 -0400 Date: Thu, 23 Apr 2015 18:28:20 -0400 To: questions@freebsd.org Subject: mysql keeping running but stops serving Message-ID: <20150423222819.GA17139@skytracker.ca> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.4.2.3i X-Delivery-Agent: TMDA/1.1.12 (Macallan) From: David Banning X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.20 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 23 Apr 2015 22:51:24 -0000 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. 150422 22:59:17 InnoDB: Started; log sequence number 0 4071213443 150422 22:59:17 [Note] /usr/local/libexec/mysqld: ready for connections. Version: '5.0.92-log' socket: '/tmp/mysql.sock' port: 3306 FreeBSD port: mysql-server-5.0.92 150423 18:15:54 [Note] /usr/local/libexec/mysqld: Normal shutdown 150423 18:15:55 [ERROR] /usr/local/libexec/mysqld: Sort aborted 150423 18:15:55 [ERROR] /usr/local/libexec/mysqld: Sort aborted 150423 18:15:59 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 13077 user: 'xxxxx' 150423 18:15:59 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 13076 user: 'xxxxx' 150423 18:15:59 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 13075 user: 'xxxxx'