Subject: mySQL problem
To: None <current-users@netbsd.org>
From: Eric Delcamp <e.delcamp@wanadoo.fr>
List: current-users
Date: 07/01/2003 00:47:56
This is a multi-part message in MIME format.

------=_NextPart_000_0053_01C33F6A.6936ACE0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Hi !

I have some problem with the mySQL server running on -current i386. I have
tried to compile the package with and without PREFER_NATIVE_PTHREADS=NO,
without changes in the error. Messages I got in log file is :

[1]   Bus error               ${NOHUP_NICENESS...
030129 22:01:03  mysqld restarted
...

or often

assertion "victim != self" failed: file "/usr/src/lib/libpthread/pthread_sa.c",
line 312, function "pthread__find_interrupted"
[1]   Abort trap              ${NOHUP_NICENESS...
033230 23:32:17  mysqld restarted

gedeon# pkg_info | grep mysql
mysql-client-3.23.49nb3 MySQL, a free SQL database (client)
php-mysql-4.2.3     PHP4 extension for MySQL databases
mysql-server-3.23.49nb3 MySQL, a free SQL database (server)

gedeon# uname -a
NetBSD gedeon 1.6V NetBSD 1.6V (GEDEON) #0: Sun Jun 29 14:17:49 CEST 2003
root@gedeon:/usr/src/sys/arch/i386/compile/GEDEON i386

This is a light webserver with Apache, PhP and mySQL. mySQL crash when someone
access it, and it could either restart by itself (launch script should poll the
process I think), but sometimes, whole server crash and restart (rebooting).

------=_NextPart_000_0053_01C33F6A.6936ACE0
Content-Type: text/x-vcard;
	name="Eric Delcamp.vcf"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: attachment;
	filename="Eric Delcamp.vcf"

BEGIN:VCARD
VERSION:2.1
N:Delcamp;Eric
FN:Eric Delcamp
TEL;HOME;VOICE:05.56.28.56.48
ADR;HOME:;;Apt 15, Bat A1, R=E9sidence M=E9doc Ste Germaine, 10 rue de =
la colonne;Bruges;Gironde;33520;France
LABEL;HOME;ENCODING=3DQUOTED-PRINTABLE:Apt 15, Bat A1, R=3DE9sidence =
M=3DE9doc Ste Germaine, 10 rue de la colonne=3D0D=3D
=3D0ABruges, Gironde 33520=3D0D=3D0AFrance
URL;HOME:http://singman.homeunix.org
BDAY:19671019
KEY;X509;ENCODING=3DBASE64:
    =
MIICgjCCAeugAwIBAgIDCHgeMA0GCSqGSIb3DQEBBAUAMIGSMQswCQYDVQQGEwJaQTEVMBMG
    =
A1UECBMMV2VzdGVybiBDYXBlMRIwEAYDVQQHEwlDYXBlIFRvd24xDzANBgNVBAoTBlRoYXd0
    =
ZTEdMBsGA1UECxMUQ2VydGlmaWNhdGUgU2VydmljZXMxKDAmBgNVBAMTH1BlcnNvbmFsIEZy
    =
ZWVtYWlsIFJTQSAyMDAwLjguMzAwHhcNMDIxMDEzMDEzNzIzWhcNMDMxMDEzMDEzNzIzWjBG
    =
MR8wHQYDVQQDExZUaGF3dGUgRnJlZW1haWwgTWVtYmVyMSMwIQYJKoZIhvcNAQkBFhRlLmRl
    =
bGNhbXBAd2FuYWRvby5mcjCBnzANBgkqhkiG9w0BAQEFAAOBjQAwgYkCgYEAuqTuxREy4o/y
    =
2FLgx/rcDF46tsOUaKFg1KBK5PX+WF85Ya2y2Life2Y3V/HME1tl0KQe1IzmCqHaWxi+R4Dk
    =
7k9/wU/ezkJpBL8rDqCO8C8Y0kXu3sYZxCIWiKaoVj/i7fyElxygKR/ft/Bk0W4loJH0U+NI
    =
XEyvRrvCCjJUMdsCAwEAAaMxMC8wHwYDVR0RBBgwFoEUZS5kZWxjYW1wQHdhbmFkb28uZnIw
    =
DAYDVR0TAQH/BAIwADANBgkqhkiG9w0BAQQFAAOBgQDEQcMtBdPcBzR83vy7E+VsBFrHbGhX
    =
PEf+Rbh7IcZ7sMTDtvaMF28IrRXdoNyD8S/mRLWD/FZAUCA5Mf01V9m1mJPSEFCsE/7FQkK+
    =
s9VN5+76YPTTiHKQZ2M+Dt58K69t2lp/506bHKH1yhqgu5N3P2F4jP8740mXcu3+1ax8tA=3D=
=3D


EMAIL;PREF;INTERNET:e.delcamp@wanadoo.fr
REV:20030630T224756Z
END:VCARD

------=_NextPart_000_0053_01C33F6A.6936ACE0--