From owner-freebsd-questions Thu Nov 29 11:41:10 2001 Delivered-To: freebsd-questions@freebsd.org Received: from mx0.ecxnetwork.net (mx0.ecxnetwork.net [208.144.33.2]) by hub.freebsd.org (Postfix) with ESMTP id 872AA37B416 for ; Thu, 29 Nov 2001 11:41:03 -0800 (PST) Received: from mailsvr.ecx.com ([208.144.33.135]) by mx0.ecxnetwork.net (8.11.3/8.11.3) with ESMTP id fATJFjp30877 for ; Thu, 29 Nov 2001 11:15:45 -0800 (PST) (envelope-from JHilgeman@ecx.com) Received: by mailsvr.ecx.com with Internet Mail Service (5.5.2653.19) id ; Thu, 29 Nov 2001 11:39:21 -0800 Message-ID: <5D90F61EB6FDD411836500508B137F1AA3F0AD@mailsvr.ecx.com> From: Jonathan Hilgeman To: "'freebsd-questions@freebsd.org'" Subject: MySQL Problems - Still Rebooting Date: Thu, 29 Nov 2001 11:39:17 -0800 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2653.19) Content-Type: text/plain; charset="iso-8859-1" Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG Please please please take the time to look at this problem. I'm running MySQL 3.23.36 on FreeBSD 4.2. The only application that connects and manipulates MySQL is a single PHP application running on PHP 4.0.3. I've eliminated all the errors I can think of and tried to optimize all queries. CPU usage never goes about 10-20% tops. However, MySQL continues to restart randomly and I cannot detect a pattern. And each time it restarts, it appears as though it doesn't close the socket or something. If I run netstat on my machine, I see this near the bottom: Address Type Recv-Q Send-Q Inode Conn Refs Nextref Addr d56998c0 stream 0 0 d5a12d40 0 0 0 /tmp/mysql.sock d5888680 stream 0 0 d5695900 0 0 0 /var/run/ndc d5920f40 stream 0 0 0 0 0 0 /tmp/mysql.sock d5699e80 stream 0 0 0 0 0 0 /tmp/mysql.sock d5888f80 stream 0 0 0 0 0 0 /tmp/mysql.sock d5699880 stream 0 0 0 0 0 0 /tmp/mysql.sock d5920e00 stream 0 0 0 0 0 0 /tmp/mysql.sock d5920340 stream 0 0 0 0 0 0 /tmp/mysql.sock d5699280 stream 0 0 0 0 0 0 /tmp/mysql.sock d5888280 stream 0 0 0 0 0 0 /tmp/mysql.sock d5920b40 stream 0 0 0 0 0 0 /tmp/mysql.sock That list of mysql.sock entries continues to grow slowly until I start getting errors about sockets. I can't JUST shut down MySQL and start it up again - the sockets stay there. I have to reboot the whole server to make the socket entries go away. There are no specific errors in the error log file - only "mysql got signal 11" and it says something about checking the backtrace but it doesn't give me the actual backtrace data - just a message saying that I should check it. The binary logs don't hold any clues either. There's no pattern in the last queries before or beginning queries after the mySQL server restarts. They change each time. Help help help help help. - Jonathan To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message