Bug #24928 MySQl.data.dll
Submitted: 8 Dec 2006 22:14 Modified: 11 Dec 2006 6:54
Reporter: Lilian Chen Email Updates:
Status: Duplicate Impact on me:
None 
Category:Connector / NET Severity:S2 (Serious)
Version:1.0.0.22708 OS:Windows (Windows XP)
Assigned to: CPU Architecture:Any
Tags: wait-timeout

[8 Dec 2006 22:14] Lilian Chen 
Description:
Our application uses mysql.data.dll in MySQL Connector/Net to connect to mysql database. Our MySql server is 5.0.18-nt with configuration wait_timeout=300. We try to query the database again and get an arror if there is not activity more than 5 minuse after we query database. The error message is "Arithmetic operation resulted in an overflow". I use the dedug tool to find the status of connection is open.

How to repeat:
set wait_timeout=300 in my.ini. query mysql database and don't close the connection, then no any activity,  try query mysql database agagin after 5 minuses using same connection.

Suggested fix:
I think MySQl.Data.dll doesn't reflect the status of connection immediately after the server kills the connection thread.
[11 Dec 2006 6:54] Tonci Grgin 
Please do not submit the same bug more than once. An existing bug report already describes this very problem. Even if you feel that your issue is somewhat different, the resolution is likely
to be the same. Because of this, we hope you add your comments to the original bug instead.

Thank you for your interest in MySQL.

Explanation: Lilian, this is the duplicate of Bug#23825.