Re: [Fwd: mysqld doesn't close descriptor]

> > Date: Thu, 20 Nov 2003 17:49:47 -0500
> > 
> > Hi all!
> > 
> > Description:
> >   When slave_net_timeout expires slave mysqld opens new connection
> > to master and doesn't close old one.
> > 
> > How to repeate:
> >   Setup replication. Set slave_net_timeout to1 sec.
> > Run lsof and take a look at lines like this:
> >    mysqld  38794 mysql   13u  KQUEUE 0xc9ee0600                     count=0, state=0
> > Later mysqld will run out of descriptors and you will get "Too many open files" error
> > message.
> > 
> > Mysql ver: 4.0.16
> > OS: FreeBSD 5.1 (release)
> > --
> > Dmitry

Hi,

I checked on Linux first:
ulimit -n 20
then started the slave mysqld.
"show variables like 'open_files_limit'" reported 20 as expected.
Started slave with slave_net_timeout=1. I also set master_connect_retry
to 1 (but it should not change anything, as the slave's code, when it
sees a broken connection (every slave_net_timeout seconds), tries to
reconnect immediately, and only if this fails it will wait
master_connect_retry seconds).
As expected the slave disconnected and reconnected every second, but got
no "too many open files".
I did the same test on one FreeBSD (FreeBSD 5.1-CURRENT) machine and it
also showed no error message.
So I don't know what is going wrong in your case.

Regards,
Guilhem


-- 
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe:    http://lists.mysql.com/[email protected]