Bug #11588 | "Catastrophic failure" when you reuse connections after MySQL restart | ||
---|---|---|---|
Submitted: | 27 Jun 2005 10:22 | Modified: | 10 Jun 2010 19:34 |
Reporter: | Emmanuel KARTMANN | Email Updates: | |
Status: | Duplicate | Impact on me: | |
Category: | Connector / ODBC | Severity: | S2 (Serious) |
Version: | MyODBC 3.51.11 | OS: | Windows (Windows XP, Windows 2003 Server) |
Assigned to: | CPU Architecture: | Any |
[27 Jun 2005 10:22]
Emmanuel KARTMANN
[27 Jun 2005 10:23]
Emmanuel KARTMANN
Start HTML Page for test case
Attachment: myodbc_catastrophic_failure.htm (text/html), 979 bytes.
[27 Jun 2005 10:24]
Emmanuel KARTMANN
First ASP Page of test case - open connection and stores it in Session
Attachment: myodbc_catastrophic_failure1.asp (text/plain), 1.26 KiB.
[27 Jun 2005 10:24]
Emmanuel KARTMANN
Second ASP Page of test case - fetch connection from Session and reuses it (and crashes!)
Attachment: myodbc_catastrophic_failure2.asp (text/plain), 3.51 KiB.
[27 Jun 2005 10:27]
Emmanuel KARTMANN
Test case (in ASP) is available for download: * myodbc_catastrophic_failure.sql: creates the test case database * myodbc_catastrophic_failure.htm: start page * myodbc_catastrophic_failure1.asp: first ASP page; opens connection and stores it in Session * myodbc_catastrophic_failure2.asp: second ASP page; reuses connection from Session (YOU MUST RESTART MYSQL before calling this page).
[27 Jun 2005 10:27]
Emmanuel KARTMANN
Creates test case database and table
Attachment: myodbc_catastrophic_failure.sql (text/plain), 679 bytes.
[27 Jun 2005 13:38]
MySQL Verification Team
I was unable to repeat the reported behavior on my XP Pro box, I was able for to reload the first asp page after the second and expected not connect message with 2nd asp page.
[27 Jun 2005 15:25]
Emmanuel KARTMANN
I knew this one was tricky to reproduce (took me one month to get it ;-) Did you get a success message on ASP page 2 ("Test completed with no error!")? Can you please try the test case again with a slight change: * myodbc_catastrophic_failure.htm (click on "GO!") * myodbc_catastrophic_failure1.asp (RESTART MySQL, click on "GO!") * myodbc_catastrophic_failure2.asp (use the "Reload" button from Internet Explorer - sometimes it takes 2 calls to this page to crash). * myodbc_catastrophic_failure2.asp (you should get error "An exception occurred" displayed in red). Regards, E.
[10 Jun 2010 17:09]
Edwin van Putten
I can confirm this problem! See bug report #48406 and #54404
[10 Jun 2010 19:34]
Lawrenty Novitsky
Thank you Edwin. Marking as a duplicate of the Bug#46910