From owner-freebsd-questions@FreeBSD.ORG Fri Apr 1 10:30:14 2005 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id B230B16A4CE for ; Fri, 1 Apr 2005 10:30:14 +0000 (GMT) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.193]) by mx1.FreeBSD.org (Postfix) with ESMTP id 48EA343D45 for ; Fri, 1 Apr 2005 10:30:14 +0000 (GMT) (envelope-from olafvdspek@gmail.com) Received: by wproxy.gmail.com with SMTP id 69so825707wri for ; Fri, 01 Apr 2005 02:30:13 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:mime-version:content-type:content-transfer-encoding; b=jE9pf9LnVX8npIP1TryIVZTNCBFb6Wa/rgeFBRGPHk07k9tWyKSB4BdqiHTAP5EH5+UqTtkrVvfUMatTtVLolwcKKvPO6aUw1K127DrjGOI9mjLoh9ID+2UP/EQomyCybt5dVvbss5ibjsSgU+01wzE7PfzGbHQddsA5GCpLaZ0= Received: by 10.54.55.16 with SMTP id d16mr422278wra; Fri, 01 Apr 2005 02:30:13 -0800 (PST) Received: by 10.54.49.66 with HTTP; Fri, 1 Apr 2005 02:30:12 -0800 (PST) Message-ID: Date: Fri, 1 Apr 2005 12:30:12 +0200 From: Olaf van der Spek To: freebsd-questions@freebsd.org Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Subject: MySQLd crash: signal 11 X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list Reply-To: Olaf van der Spek List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 01 Apr 2005 10:30:14 -0000 Hi, I've got MySQL 4.1 and FreeBSD 4 and have some issues with it crashing. Does anyone know what could cause this or how it could be solved? uname -a FreeBSD greek-torrents.com 4.11-STABLE FreeBSD 4.11-STABLE #0: Tue Feb 8 22:53:48 CET 2005 igor@ds-24.ispserver.com:/usr/src/sys/compile/HOSTING i386 050331 22:21:00 mysqld restarted 050331 22:21:00 InnoDB: Started; log sequence number 0 43912 /usr/local/libexec/mysqld: ready for connections. Version: '4.1.10' socket: '/tmp/mysql.sock' port: 3306 FreeBSD port: mysql-server-4.1.10 mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=16384 read_buffer_size=258048 max_used_connections=36 max_connections=200 threads_connected=28 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 63214 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. 050331 22:21:34 mysqld restarted 050331 22:21:34 InnoDB: Started; log sequence number 0 43912