List:General Discussion« Previous MessageNext Message »
From:Iikka Meriläinen Date:August 18 2002 7:12pm
Subject:Re: Lost connections on Freebsd
View as plain text  
Hello,

Some basic points about these problems:
1) have you another application/mysqld listening on the same tcp port?
2) have you tried different versions (switching between 3.23 and 4.x
series, for example)
3) try compiling from the source with a bit different configuration
parameters
4) do your connections drop if you're connecting from the localhost? How
about from other hosts? How about connecting with other clients?

Just don't give up. I've never seen a MySQL-related problem that nobody
has been able to solve. I don't believe this isn't about anything big. And
probably there are lots of more people active on this list next week,
somebody of them might be able to solve your problem. :-)

Regards,
Iikka

******************************************
* Iikka Meriläinen                       *
* E-mail: Iikka.Merilainen@stripped *
* Vaala, Finland                         *
******************************************

On Sun, 18 Aug 2002, Gelu Gogancea wrote:

> My dear friend,
> If you put the problem in this way .....maybe it's a good ideea to go to the
> church and make some rosary for solving your problem.
>
> Bye
>
> ----- Original Message -----
> From: "Chris Knipe" <savage@stripped>
> To: <mysql@stripped>
> Sent: Sunday, August 18, 2002 9:06 PM
> Subject: Re: Lost connections on Freebsd
>
>
> > Fair enough,
> >
> > But then why is MySQL the *only* thing I am having problems with?  MySQL's
> > not the only application running on the box, it's not the only application
> > opening / closing tcp sockets, its not the only thing opening / closing
> file
> > sockets....
> >
> > *shrugs*... Maybe I should just rm -rf / and reinstall.....
> >
> > ----- Original Message -----
> > From: "Gelu Gogancea" <ggelu@stripped>
> > To: "Chris Knipe" <savage@stripped>; <mysql@stripped>
> > Sent: Sunday, August 18, 2002 8:01 PM
> > Subject: Re: Lost connections on Freebsd
> >
> >
> > > For sure "Bad file descriptor" error occur because your kernel it's not
> > > able to create handler for the new open file(don't forget...socket it's
> > also
> > > a file ) which must be open.
> > >
> > > _____________________________________________________
> > > G.NET SOFTWARE COMPANY
> > >
> > > Permanent e-mail address : gg@stripped
> > >                                           gelugogancea@stripped
> > > ----- Original Message -----
> > > From: "Chris Knipe" <savage@stripped>
> > > To: <mysql@stripped>
> > > Sent: Sunday, August 18, 2002 8:14 PM
> > > Subject: Re: Lost connections on Freebsd
> > >
> > >
> > > >
> > > > > ...or you have too many open files in the system.You reach the
> max.
> > > number
> > > > > of files which can be opened by the OS.Try to increase file-max
> from
> > > > > /proc/sys/fs.
> > > > >
> > > >
> > > > Highly doubtful.  It's a brand new server installation, exactly the
> same
> > > as
> > > > all my others, and it's not doing half as much as the others are....
> > > >
> > > > The box runs mysql, apache, and exim...  With less than 50 processes
> > > running
> > > > at any given time...
> > > >
> > > > It's FreeBSD as well btw, /proc/fs/ doesn't exist :P
> > > >
> > > > -SNIP-
> > > > DESCRIPTION
> > > >      The fstat utility identifies open files.  A file is considered
> open
> > > by
> > > > a
> > > >      process if it was explicitly opened, is the working directory,
> root
> > > >      directory, active executable text, or kernel trace file for that
> > > > process.
> > > >      If no options are specified, fstat reports on all open files in
> the
> > > > sys-
> > > >      tem.
> > > > -SNIP-
> > > >
> > > > 749 open files reported... Far less than the maximum.
> > > >
> > > > --
> > > > me
> > > >
> > > >
> > > >
> > > >
> > > > ---------------------------------------------------------------------
> > > > 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
> <mysql-thread117478@stripped>
> > > > To unsubscribe, e-mail
> > <mysql-unsubscribe-ggelu=arctic.ro@stripped>
> > > > 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 <mysql-thread117482@stripped>
> > To unsubscribe, e-mail
> <mysql-unsubscribe-ggelu=arctic.ro@stripped>
> > 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 <mysql-thread117483@stripped>
> To unsubscribe, e-mail
> <mysql-unsubscribe-Iikka.Merilainen=pato.vaala.fi@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>

Thread
Urgent: lost connections,Chris Knipe17 Aug
  • Re: Urgent: lost connections,Victoria Reznichenko17 Aug
  • Re: Urgent: lost connections,Chris Knipe17 Aug
    • Re: Lost connections on FreebsdMichael Widenius18 Aug
  • Re: Lost connections on FreebsdChris Knipe18 Aug
  • Re: Lost connections on FreebsdGelu Gogancea18 Aug
  • Re: Lost connections on FreebsdChris Knipe18 Aug
  • Re: Lost connections on FreebsdGelu Gogancea18 Aug
  • Re: Lost connections on FreebsdChris Knipe18 Aug
  • Re: Lost connections on FreebsdGelu Gogancea18 Aug
    • Re: Lost connections on FreebsdIikka Meriläinen18 Aug
  • Re: Lost connections on FreebsdChris Knipe19 Aug