From owner-freebsd-questions@FreeBSD.ORG Tue Oct 28 10:55:26 2003 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 2D2A116A4CE for ; Tue, 28 Oct 2003 10:55:26 -0800 (PST) Received: from knast.server-king.de (knast.server-king.de [217.19.167.129]) by mx1.FreeBSD.org (Postfix) with ESMTP id 198ED43FDF for ; Tue, 28 Oct 2003 10:55:22 -0800 (PST) (envelope-from freebsd@knarf.de) Received: from knast.server-king.de (knarf@localhost.server-king.de [127.0.0.1])h9SItKuu047675 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO) for ; Tue, 28 Oct 2003 19:55:20 +0100 (CET) (envelope-from freebsd@knarf.de) Received: (from knarf@localhost) by knast.server-king.de (8.12.9p1/8.12.9/Submit) id h9SItKwE047655 for freebsd-questions@freebsd.org; Tue, 28 Oct 2003 19:55:20 +0100 (CET) (envelope-from freebsd@knarf.de) X-Authentication-Warning: knast.server-king.de: knarf set sender to freebsd@knarf.de using -f Date: Tue, 28 Oct 2003 19:55:19 +0100 From: Frank Bartels To: freebsd-questions@freebsd.org Message-ID: <20031028185519.GA26292@server-king.de> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="SLDf9lqlvOQaIe6s" Content-Disposition: inline User-Agent: Mutt/1.4.1i Subject: Problems using mysql-4.0 under 5.1-RELEASE X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 28 Oct 2003 18:55:26 -0000 --SLDf9lqlvOQaIe6s Content-Type: text/plain; charset=iso-8859-15 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Heya all, I have big problems using mysql. I really tried so many different combinations of software and configurations, but it's always the same: mysqld crashes. My preferred setup: FreeBSD 5.1-RELEASE-p10 /usr/ports cvsupped daily perl-5.8.0_8 (will try 5.8.1 soon) mysql-server-4.0.16 mysql-client-4.0.16 I get the following error message in /var/db/mysql/hostname.err: ---snip--- 031028 18:35:16 mysqld restarted 031028 18:35:17 InnoDB: Started /usr/local/libexec/mysqld: ready for connections. Version: '4.0.16' socket: '/tmp/mysql.sock' port: 3306 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 diagno= se the problem, but since we have already crashed, something is definitely wro= ng and this may fail. key_buffer_size=3D8388600 read_buffer_size=3D131072 max_used_connections=3D0 max_connections=3D100 threads_connected=3D0 It is possible that mysqld could use up to=20 key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections =3D= 225791 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Number of processes running now: 0 031028 18:35:17 mysqld restarted 031028 18:35:17 InnoDB: Started [...] ---snap--- I really do not understand the error message. I don't know the value of sort_buffer_size and I do not understand how 8388600 + something-positive can be just 225791. I have 1 GB swap, so this cannot be the problem? This error happens every time when someone is trying to connect to the database using IP (not socket). Because all the mysql-clients in my network try to connect to the database all the time, the server starts and crashes, starts and crashes and so on... I build mysql using portinstall databases/mysql40-server, my make.conf says just CPUTYPE?=3Dp3, sometimes just ?=3Di586 depending on the machine I used and the things needed for perl-5.8.0. I do not use any of the mysql build options. I've tested this with the default database and with my own database (which worked fine for years with FreeBSD 4.x and mysql-3.23.x). I think the dilemma began after upgrading from FreeBSD 4.8 to 5.1 and after upgrading mysql-3.23.57 (still the binary built with 4.8) to mysql-3.23.58 for the first time. Then I decided to upgrade to mysql-4.0 which did not cure the problem. Oh, maybe this is not really interesting, but I use LANG=3DC and LC_CTYPE=3Dde_DE.ISO8859-15. I also got the message: Oct 24 16:01:24 otherhost kernel: Oct 24 16:01:24 otherhost mysqld[13083]: = warning: can't get client address: Bad file descriptor Oct 24 16:01:55 otherhost kernel: Oct 24 16:01:29 otherhost mysqld[13083]: = warning: can't get client address: Bad file descriptor This problem was "solved" by editing /etc/hosts.allow this way: ---snip--- mysqld : 192.168.0.0/255.255.255.224 : allow # THESE LINES CRASH mysqld!!! # ALL : PARANOID : RFC931 20 : deny # ALL : ALL@ALL : allow # ALL : ALL : allow ---snap--- While having this problem, I tried WITH_LINUXTHREADS and SKIP_DNS_CHECK and related options in the my.cnf like --skip-name-resolve and --skip-networking (which also solved the problem). I really don't know how many times I've recompiled the mysql software in the last weeks... I hope someone of you can help me. Bye, Knarf --SLDf9lqlvOQaIe6s Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.3 (FreeBSD) iD8DBQE/nruX3N92+OaFVBwRApB4AJ4jr7L1AhqqNn6+ih/WV3fxJ+QezACg8Ppz jE5Srz6pGQ/YG0sT8+VPLRA= =Wmga -----END PGP SIGNATURE----- --SLDf9lqlvOQaIe6s--