Hi Nicolai, Sorry for the delay in responding, I have been away on vacation. FreeBSD 4.2 Release did have several threads problems related to the compilers and the threads library. I have attacthed the commit log of the fixes you are looking for and the minimum patch necassary (patch-4.txt) to get the seg-faults to stop. I would recemmond upgrading you 4.2 release to FreeBSD-stable. Or using the binary installation provided on the MySQL web site. I experienced you exact problems. If you use the patch, you MUST recompile MySQL if you compiled it yourself. Unless you cvsup to the current stable release you will miss many fixes. Good Luck! Ken ----------------------------------------------------- Ken Menzel ICQ# 9325188 www.icarz.com [EMAIL PROTECTED] ----- Original Message ----- From: <[EMAIL PROTECTED]> To: "Nicolai Gylling" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, January 16, 2001 7:18 PM Subject: Re: Crashing MySQL on FreeBSD4.2 with Apache/php4 > There were some very recent fixed to FreeBSD-stable > surrounding C++ and threads, that directly mysql, > I'd strongly recommend updating freebsd. > > > On Mon, 15 Jan 2001, Nicolai Gylling wrote: > > > Hi > > > > I'm currently running a FreeBSD4.2-Stable server with > > Apache1.3.14/PHP4.0.4pl1 and MySQL 3.23.27-Beta. > > > > The problem is that MySQL is crashing constantly, sometimes several times > > each minute. I've been through all the "What to do if mysql keeps crashing" > > steps in the MySQL-documentation, but nothing helped. My research has come > > up with suggestions regarding the threads in FreeBSD4.2 and sessionhandling > > in PHP. > > > > Is there anyone who has had similar problems, or might know what to do? > > > > Nicolai Gylling > > > > System Administrator | [EMAIL PROTECTED] | http://www.neoideo.com > > Neo Ideo A/S | Galionsvej, Bygning 156 | DK-1437 Copenhagen K. > > Phone: +45 7020 2414 | Direct: +45 7730 4300 | Telefax: +45 7020 2415 | > > Mobile: +45 2098 5543 > > > > -------------------------------------------------------------------- - > > Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > > > > -------------------------------------------------------------------- - > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > >
obrien 2001/01/06 15:16:58 PST Modified files: (Branch: RELENG_4) gnu/lib Makefile gnu/lib/libgcc Makefile gnu/usr.bin/cc/cc_tools freebsd-native.h lib/libc_r/uthread uthread_init.c lib/libpam/modules/pam_cleartext_pass_ok Makefile lib/libpam/modules/pam_deny Makefile lib/libpam/modules/pam_kerberosIV Makefile lib/libpam/modules/pam_opie Makefile lib/libpam/modules/pam_permit Makefile lib/libpam/modules/pam_radius Makefile lib/libpam/modules/pam_skey Makefile lib/libpam/modules/pam_ssh Makefile lib/libpam/modules/pam_tacplus Makefile lib/libpam/modules/pam_unix Makefile Log: MFC: use a unified libgcc and ensure strong references to pthread functions weakly referenced in libgcc. Revision Changes Path 1.25.2.4 +3 -1 src/gnu/lib/Makefile 1.31.2.1 +7 -1 src/gnu/lib/libgcc/Makefile 1.5.2.2 +1 -11 src/gnu/usr.bin/cc/cc_tools/freebsd-native.h 1.23.2.4 +33 -1 src/lib/libc_r/uthread/uthread_init.c 1.2.6.2 +3 -3 src/lib/libpam/modules/pam_cleartext_pass_ok/Makefile 1.1.4.1 +1 -3 src/lib/libpam/modules/pam_deny/Makefile 1.5.2.1 +3 -3 src/lib/libpam/modules/pam_kerberosIV/Makefile 1.1.2.1 +3 -3 src/lib/libpam/modules/pam_opie/Makefile 1.1.4.1 +1 -3 src/lib/libpam/modules/pam_permit/Makefile 1.4.2.1 +3 -3 src/lib/libpam/modules/pam_radius/Makefile 1.2.6.1 +3 -3 src/lib/libpam/modules/pam_skey/Makefile 1.2.2.1 +3 -3 src/lib/libpam/modules/pam_ssh/Makefile 1.2.6.1 +3 -3 src/lib/libpam/modules/pam_tacplus/Makefile 1.4.2.1 +3 -3 src/lib/libpam/modules/pam_unix/Makefile
RCS file: /home/ncvs/src/gnu/usr.bin/cc/cc_tools/freebsd-native.h,v retrieving revision 1.5.2.1 diff -u -r1.5.2.1 freebsd-native.h --- freebsd-native.h 2000/11/11 21:52:40 1.5.2.1 +++ freebsd-native.h 2000/12/06 17:56:06 @@ -52,7 +52,4 @@ #define LIBGCC_SPEC \ "%{!shared: \ %{!pthread:libgcc.a%s} \ - %{pthread:libgcc_r.a%s}} \ - %{shared: \ - %{!pthread:libgcc_pic.a%s} \ - %{pthread:libgcc_r_pic.a%s}}" + %{pthread:libgcc_r.a%s}}"
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php