From owner-freebsd-ports@FreeBSD.ORG Tue Jan 31 22:12:50 2006 Return-Path: X-Original-To: ports@freebsd.org Delivered-To: freebsd-ports@FreeBSD.ORG Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id DC55D16A420; Tue, 31 Jan 2006 22:12:49 +0000 (GMT) (envelope-from jlirochon@cyanide-studio.com) Received: from mail.cyanide-studio.com (cyanide.net1.nerim.net [62.212.119.207]) by mx1.FreeBSD.org (Postfix) with ESMTP id 1EC6143D45; Tue, 31 Jan 2006 22:12:48 +0000 (GMT) (envelope-from jlirochon@cyanide-studio.com) Received: from localhost (mail.cyanide-studio.com [10.1.8.5]) by mail.cyanide-studio.com (Postfix) with ESMTP id D570B61C1; Tue, 31 Jan 2006 23:20:31 +0100 (CET) Received: from mail.cyanide-studio.com ([10.1.8.5]) by localhost (mail.cyanide-studio.com [10.1.8.5]) (amavisd-new, port 10024) with ESMTP id 09396-02; Tue, 31 Jan 2006 23:20:31 +0100 (CET) Received: from [192.168.1.30] (mx.lirochon.net [82.227.253.27]) by mail.cyanide-studio.com (Postfix) with ESMTP id E53676104; Tue, 31 Jan 2006 23:20:30 +0100 (CET) Message-ID: <43DFE0F2.8050009@cyanide-studio.com> Date: Tue, 31 Jan 2006 23:13:06 +0100 From: Julien Lirochon User-Agent: Thunderbird 1.5 (Windows/20051201) MIME-Version: 1.0 To: Mike Jakubik References: <43DF42D2.5040903@cyanide-studio.com> <43DFCB41.9000100@rogers.com> In-Reply-To: <43DFCB41.9000100@rogers.com> Content-Type: multipart/signed; protocol="application/x-pkcs7-signature"; micalg=sha1; boundary="------------ms030603020401020301070509" X-Virus-Scanned: Maia Mailguard 1.0.0 Cc: ports@FreeBSD.org, ale@FreeBSD.org Subject: Re: FreeBSD Port: mysql-server-4.1.16 X-BeenThere: freebsd-ports@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Porting software to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 31 Jan 2006 22:12:50 -0000 This is a cryptographically signed message in MIME format. --------------ms030603020401020301070509 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit Mike Jakubik a écrit : > Julien Lirochon wrote: >> Hi, >> >> Could I suggest to enable -DWITH_LINUXTHREADS by default on >> mysql41-server port ? >> >> I'm running 5.4 stable, and 6.0 stable, on several machines. >> >> CPUTYPE=pentium4 or CPUTYPE=athlon >> CFLAGS= -O2 >> >> If I intall the mysql-server port by "make install", the resulting >> mysqld just can't work. It keeps crashing again and again, even under >> very very low stress. > > Uhm, no you may not :P I don't want to use linux anything. I have this > version of mysql running just fine on several boxes, with default > threading. How does it crash? Can you provide more details? Also, have > you tried using libthr or version 5 of mysql instead? I agree, that's not a very artistic way to solve the problem... Maybe it's related to CPUTYPE or kernel options ? My tests were run on GENERIC kernel on both pentium4 and athlon. mysqld error log says : mysqld in free(): warning: chunk is already free mysqld in free(): warning: modified (chunk-) pointer 060130 17:12:36 mysqld restarted 060130 17:12:36 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. (...) /usr/local/libexec/mysqld: ready for connections. Version: '4.1.16-log' socket: '/tmp/mysql.sock' port: 3306 FreeBSD port: mysql-server-4.1.16 mysqld in free(): warning: modified (chunk-) pointer 060130 17:12:57 mysqld restarted 060130 17:12:58 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. (...) /usr/local/libexec/mysqld: ready for connections. As you can see, the crash/restart occurs several times in a minute (under normal load). No more problem for me with linuxthreads (rock solid for about 30h now on the same box) I will try to link against libthr to see if it can survive too ;) Julien --------------ms030603020401020301070509 Content-Type: application/x-pkcs7-signature; name="smime.p7s" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="smime.p7s" Content-Description: S/MIME Cryptographic Signature MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIKhjCC BT8wggQnoAMCAQICEQCxnD1aw24XmtWm+0lGNGP0MA0GCSqGSIb3DQEBBQUAMGUxCzAJBgNV BAYTAlNFMRQwEgYDVQQKEwtBZGRUcnVzdCBBQjEdMBsGA1UECxMUQWRkVHJ1c3QgVFRQIE5l dHdvcmsxITAfBgNVBAMTGEFkZFRydXN0IENsYXNzIDEgQ0EgUm9vdDAeFw0wNjAxMDYwMDAw MDBaFw0wNzAxMDYyMzU5NTlaMIHnMTUwMwYDVQQLEyxDb21vZG8gVHJ1c3QgTmV0d29yayAt IFBFUlNPTkEgTk9UIFZBTElEQVRFRDFGMEQGA1UECxM9VGVybXMgYW5kIENvbmRpdGlvbnMg b2YgdXNlOiBodHRwOi8vd3d3LmNvbW9kby5uZXQvcmVwb3NpdG9yeTEfMB0GA1UECxMWKGMp MjAwMyBDb21vZG8gTGltaXRlZDEYMBYGA1UEAxMPSnVsaWVuIExpcm9jaG9uMSswKQYJKoZI hvcNAQkBFhxqbGlyb2Nob25AY3lhbmlkZS1zdHVkaW8uY29tMIGfMA0GCSqGSIb3DQEBAQUA A4GNADCBiQKBgQDCRI683dR9XkPzbv5vHKsDNMmBTEfg27ABDcZN7fOLUvfgQTz6B76uYdhQ tm+dEZqyVFeexd1Nx1wAjnsDcItsPYWJywsvzFekaJA3nn7d54S8xZcUUILPKsqzMMKbRwEN zmhJTBTkiZocoYM89USPS8rwL5mM5Ee5CjRNJJFwFQIDAQABo4IB6TCCAeUwHQYDVR0OBBYE FMQLFDtgZDUTwBUq9JJV0d6Q6h4wMA4GA1UdDwEB/wQEAwIFoDAMBgNVHRMBAf8EAjAAMCAG A1UdJQQZMBcGCCsGAQUFBwMEBgsrBgEEAbIxAQMFAjARBglghkgBhvhCAQEEBAMCBSAwRgYD VR0gBD8wPTA7BgwrBgEEAbIxAQIBAQEwKzApBggrBgEFBQcCARYdaHR0cHM6Ly9zZWN1cmUu Y29tb2RvLm5ldC9DUFMwdwYDVR0fBHAwbjA2oDSgMoYwaHR0cDovL2NybC5jb21vZG9jYS5j b20vQWRkVHJ1c3RDbGFzczFDQVJvb3QuY3JsMDSgMqAwhi5odHRwOi8vY3JsLmNvbW9kby5u ZXQvQWRkVHJ1c3RDbGFzczFDQVJvb3QuY3JsMIGGBggrBgEFBQcBAQR6MHgwOwYIKwYBBQUH MAKGL2h0dHA6Ly9jcnQuY29tb2RvY2EuY29tL0FkZFRydXN0VVROQ2xpZW50Q0EuY3J0MDkG CCsGAQUFBzAChi1odHRwOi8vY3J0LmNvbW9kby5uZXQvQWRkVHJ1c3RVVE5DbGllbnRDQS5j cnQwJwYDVR0RBCAwHoEcamxpcm9jaG9uQGN5YW5pZGUtc3R1ZGlvLmNvbTANBgkqhkiG9w0B AQUFAAOCAQEAOiHfOFnTk2OzE9W8onpp9UrWF5uZacC7Q94I6tuML+oYF/J0WKaaqvZUBI3u z39LeBMWowwK7/8dFq8TUuzX4VxZGscNhu6y1Gw6IjYQxeGk6GsJracWUPW7+Eh8/rMzESAs am7fgvs8eB3wpRIyIUosR1qpt8FAgtP/eorIvB0ZPKKOsBkj3eUHo9FyaHTezVzTE7LasDDT slkUzJAxmmhj/0PkGvO4EsM8N4wmNFwetXlZEn431giC7keyoI7KRLKB6nvgcaO+WWH03usa H8+vSkZSsFugaSBp7t8CIYyG5nkEunoRjeH+xb+VljaZr/1N3Wl5vR7Pa1lF5JFXCzCCBT8w ggQnoAMCAQICEQCxnD1aw24XmtWm+0lGNGP0MA0GCSqGSIb3DQEBBQUAMGUxCzAJBgNVBAYT AlNFMRQwEgYDVQQKEwtBZGRUcnVzdCBBQjEdMBsGA1UECxMUQWRkVHJ1c3QgVFRQIE5ldHdv cmsxITAfBgNVBAMTGEFkZFRydXN0IENsYXNzIDEgQ0EgUm9vdDAeFw0wNjAxMDYwMDAwMDBa Fw0wNzAxMDYyMzU5NTlaMIHnMTUwMwYDVQQLEyxDb21vZG8gVHJ1c3QgTmV0d29yayAtIFBF UlNPTkEgTk9UIFZBTElEQVRFRDFGMEQGA1UECxM9VGVybXMgYW5kIENvbmRpdGlvbnMgb2Yg dXNlOiBodHRwOi8vd3d3LmNvbW9kby5uZXQvcmVwb3NpdG9yeTEfMB0GA1UECxMWKGMpMjAw MyBDb21vZG8gTGltaXRlZDEYMBYGA1UEAxMPSnVsaWVuIExpcm9jaG9uMSswKQYJKoZIhvcN AQkBFhxqbGlyb2Nob25AY3lhbmlkZS1zdHVkaW8uY29tMIGfMA0GCSqGSIb3DQEBAQUAA4GN ADCBiQKBgQDCRI683dR9XkPzbv5vHKsDNMmBTEfg27ABDcZN7fOLUvfgQTz6B76uYdhQtm+d EZqyVFeexd1Nx1wAjnsDcItsPYWJywsvzFekaJA3nn7d54S8xZcUUILPKsqzMMKbRwENzmhJ TBTkiZocoYM89USPS8rwL5mM5Ee5CjRNJJFwFQIDAQABo4IB6TCCAeUwHQYDVR0OBBYEFMQL FDtgZDUTwBUq9JJV0d6Q6h4wMA4GA1UdDwEB/wQEAwIFoDAMBgNVHRMBAf8EAjAAMCAGA1Ud JQQZMBcGCCsGAQUFBwMEBgsrBgEEAbIxAQMFAjARBglghkgBhvhCAQEEBAMCBSAwRgYDVR0g BD8wPTA7BgwrBgEEAbIxAQIBAQEwKzApBggrBgEFBQcCARYdaHR0cHM6Ly9zZWN1cmUuY29t b2RvLm5ldC9DUFMwdwYDVR0fBHAwbjA2oDSgMoYwaHR0cDovL2NybC5jb21vZG9jYS5jb20v QWRkVHJ1c3RDbGFzczFDQVJvb3QuY3JsMDSgMqAwhi5odHRwOi8vY3JsLmNvbW9kby5uZXQv QWRkVHJ1c3RDbGFzczFDQVJvb3QuY3JsMIGGBggrBgEFBQcBAQR6MHgwOwYIKwYBBQUHMAKG L2h0dHA6Ly9jcnQuY29tb2RvY2EuY29tL0FkZFRydXN0VVROQ2xpZW50Q0EuY3J0MDkGCCsG AQUFBzAChi1odHRwOi8vY3J0LmNvbW9kby5uZXQvQWRkVHJ1c3RVVE5DbGllbnRDQS5jcnQw JwYDVR0RBCAwHoEcamxpcm9jaG9uQGN5YW5pZGUtc3R1ZGlvLmNvbTANBgkqhkiG9w0BAQUF AAOCAQEAOiHfOFnTk2OzE9W8onpp9UrWF5uZacC7Q94I6tuML+oYF/J0WKaaqvZUBI3uz39L eBMWowwK7/8dFq8TUuzX4VxZGscNhu6y1Gw6IjYQxeGk6GsJracWUPW7+Eh8/rMzESAsam7f gvs8eB3wpRIyIUosR1qpt8FAgtP/eorIvB0ZPKKOsBkj3eUHo9FyaHTezVzTE7LasDDTslkU zJAxmmhj/0PkGvO4EsM8N4wmNFwetXlZEn431giC7keyoI7KRLKB6nvgcaO+WWH03usaH8+v SkZSsFugaSBp7t8CIYyG5nkEunoRjeH+xb+VljaZr/1N3Wl5vR7Pa1lF5JFXCzGCAu8wggLr AgEBMHowZTELMAkGA1UEBhMCU0UxFDASBgNVBAoTC0FkZFRydXN0IEFCMR0wGwYDVQQLExRB ZGRUcnVzdCBUVFAgTmV0d29yazEhMB8GA1UEAxMYQWRkVHJ1c3QgQ2xhc3MgMSBDQSBSb290 AhEAsZw9WsNuF5rVpvtJRjRj9DAJBgUrDgMCGgUAoIIByzAYBgkqhkiG9w0BCQMxCwYJKoZI hvcNAQcBMBwGCSqGSIb3DQEJBTEPFw0wNjAxMzEyMjEzMDZaMCMGCSqGSIb3DQEJBDEWBBRd 9oUodU4h1ciZ86e6o2yLOvCmJzBSBgkqhkiG9w0BCQ8xRTBDMAoGCCqGSIb3DQMHMA4GCCqG SIb3DQMCAgIAgDANBggqhkiG9w0DAgIBQDAHBgUrDgMCBzANBggqhkiG9w0DAgIBKDCBiQYJ KwYBBAGCNxAEMXwwejBlMQswCQYDVQQGEwJTRTEUMBIGA1UEChMLQWRkVHJ1c3QgQUIxHTAb BgNVBAsTFEFkZFRydXN0IFRUUCBOZXR3b3JrMSEwHwYDVQQDExhBZGRUcnVzdCBDbGFzcyAx IENBIFJvb3QCEQCxnD1aw24XmtWm+0lGNGP0MIGLBgsqhkiG9w0BCRACCzF8oHowZTELMAkG A1UEBhMCU0UxFDASBgNVBAoTC0FkZFRydXN0IEFCMR0wGwYDVQQLExRBZGRUcnVzdCBUVFAg TmV0d29yazEhMB8GA1UEAxMYQWRkVHJ1c3QgQ2xhc3MgMSBDQSBSb290AhEAsZw9WsNuF5rV pvtJRjRj9DANBgkqhkiG9w0BAQEFAASBgKL24Y7hvSMt4c78fpOoQqaMBXBYEUA1XTwybECa KM5j82cMyFgUlP2tPPGRsRY3mulniN9Lrol/mkAl8GSFcXcIZvDdcxnCH+kQqdQpdVtBswEu dPY0v4/I354saCp1UeOGvhHo5nNVAYPRrnqzS+roiayraaCHYXUyjbIiKDuHAAAAAAAA --------------ms030603020401020301070509--