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

--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs [at] m.gmane.org

sorry, forgot - to get result fast set also master-connect-retry to 1


----- Original Message -----
Sent: Thursday, November 20, 2003 5:49 PM
Subject: mysqld doesn't close descriptor


> Hi all!
>
> Description:
> When slave_net_timeout expires slave mysqld opens new connection
> to master and doesn't close old one.
descriptor
~~~~~~~~
>
> 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
>
> --
> MySQL Bugs Mailing List
> For list archives: http://lists.mysql.com/bugs
> To unsubscribe: http://lists.mysql.com/bugs?unsub=dmitryadams [at] hotmail.com
>
>

--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs [at] m.gmane.org

sorry, forgot - to get result fast set also master-connect-retry to 1


----- Original Message -----
Sent: Thursday, November 20, 2003 5:49 PM
Subject: mysqld doesn't close descriptor


> Hi all!
>
> Description:
> When slave_net_timeout expires slave mysqld opens new connection
> to master and doesn't close old one.
descriptor
~~~~~~~~
>
> 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
>
> --
> MySQL Bugs Mailing List
> For list archives: http://lists.mysql.com/bugs
> To unsubscribe: http://lists.mysql.com/bugs?unsub=dmitryadams [at] hotmail.com
>
>

--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs [at] m.gmane.org