Bug #13459 Connection Pooling Bug

• Submitted: 24 Sep 2005 13:41
• Modified: 6 Nov 2007 15:38
• Reporter: Carsten Jendro
• Status: Closed
• Category: Connector / NET
• Severity: S4 (Feature request)
• Version: 1.0.5
• OS: Windows (windows & linux)
• CPU Architecture: Any

[24 Sep 2005 13:41] Carsten Jendro

Description:
An Exception Occures on 

MySqlConnection c = new MySqlConnection("......");
c.Open()

when 

- Pooling is ON
- There is a Connection in the Pool
- The TCP Connection to the MySql Server ist Terminated Serverside (e.g. Network down or Server closed Connection after 28800 Seconds) 

Driver Tryes to read or write from the closed Connection then 

How to repeat:
MySqlConnection c = new MySqlConnection("......");
c.Open()
c.Close()

/* connection is in the pool now and still open */

terminate tcp connection or shutdown server

c = new MySqlConnection("......");
c.Open()

Suggested fix:
when a pool connection is used, you should check it first (ping) and create a new connection if this dont works.

never pass pool exceptions to the application

[6 Nov 2007 15:38] Reggie Burnett

This is an old bug report and this is no longer a problem