Nicolai, As I sent you earlier, on the 17th, you MUST upgrade your
FreeBSD to FreeBSD-stable of January 10th or later, or apply the
patch I sent you and recompile, or use the contributed binary on the
mysql web page:
http://www.mysql.com/Downloads/MySQL-3.23/mysql-3.23.30-gamma-unknown-
freebsdelf4.2-i386.tar.gz
You will keep getting seg faults unless you do one of these things.
(check the output of dmesg). The FreeBSD 4.2 Release has multiple
thread problems.
The other message (aborted connections) is a problem with PHP, I
think someone has a patch for that. Maybe they could post it here.
Ken
-----------------------------------------------------
Ken Menzel ICQ# 9325188
www.icarz.com [EMAIL PROTECTED]
----- Original Message -----
From: "Nicolai Gylling" <[EMAIL PROTECTED]>
To: "'Danny'" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, January 19, 2001 9:20 AM
Subject: RE: Crashing MySQL on FreeBSD4.2 with Apache/php4
> Hi again
>
> Now i've tried running with the 3.23.26-beta from the ports tree for
a
> couple of days, and the server has got a lot more stable, but stil
we
> experience appox. 20 restarts a day. Furthermore we are getting a
lot of
> these:
>
> Aborted connection 64 to db: 'username' user: 'testuser' host:
`localhost'
> (Got an error reading communicatio
> n packets)
>
> Any other ideas?
>
> -----Original Message-----
> From: Danny [mailto:[EMAIL PROTECTED]]
> Sent: 16. januar 2001 02:15
> To: Nicolai Gylling; '[EMAIL PROTECTED]'
> Subject: Re: Crashing MySQL on FreeBSD4.2 with Apache/php4
>
>
> Hallo
>
> - Just out of interest .
>
> Did you install MySQL on FREEBSD using www.freebsd.org/ports
> if you didnt I highly recom,mend you should.
>
> Looking forward to your feedback.
>
> dannyh
>
> [EMAIL PROTECTED]
>
>
>
>
> On Tue, 16 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
>
> --------------------------------------------------------------------
-
> 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