| Bug #46330 | sometime "nested transaction are not supported" message came out | ||
|---|---|---|---|
| Submitted: | 22 Jul 2009 2:43 | Modified: | 29 Aug 2009 7:10 |
| Reporter: | victor godwin | Email Updates: | |
| Status: | No Feedback | Impact on me: | |
| Category: | Connector / NET | Severity: | S3 (Non-critical) |
| Version: | 5.1.33 | OS: | Windows (SP3) |
| Assigned to: | Assigned Account | CPU Architecture: | Any |
| Tags: | .net, connector, nested transaction | ||
[22 Jul 2009 8:29]
Tonci Grgin
Hi Victor and thanks for your report. Truly, this looks like duplicate of Bug#36326 (and Bug#41664). Please, upgrade your MySQL server and c/NET to latest versions (5.1.36 and 5.2.7 respectively) and inform me of result. If you think this is not related to above reports, please attach test case I can run locally that will show me the problem.
[22 Jul 2009 8:50]
victor godwin
Hi Tonci, thank you for your answer. Last time when I use MySQL 5.1.36 my application didn't run properly. But I'll try to upgrade c/Net to 5.2.7 version. I will try to create test case if I can reproduce it again.
[24 Jul 2009 6:55]
Tonci Grgin
Victor, upgrading MySQL server to 5.1.36 is essential (as can be seen in other report). Please try even only for testing purposes. Waiting on your results.
[28 Jul 2009 6:40]
victor godwin
Hi Tonci, I am sorry, I still try to use 5.1.33 version to reproduce the bug. this is the vb.net error message: ================================ Just-In-Time (JIT) デバッグを呼び出すための詳細については、 ダイアログ ボックスではなく、このメッセージの最後を参照してください。 ************** 例外テキスト ************** System.InvalidOperationException: Nested transactions are not supported. 場所 MySql.Data.MySqlClient.MySqlConnection.BeginTransaction(IsolationLevel iso) 場所 MySql.Data.MySqlClient.MySqlConnection.BeginTransaction() this is from show innodb status : ================================ ------------ TRANSACTIONS ------------ Trx id counter 0 27495 Purge done for trx's n:o < 0 27482 undo n:o < 0 0 History list length 28 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 0, not started, OS thread id 5820 MySQL thread id 7, query id 355 localhost 127.0.0.1 root show innodb status ---TRANSACTION 0 27493, not started, OS thread id 6124 MySQL thread id 6, query id 351 localhost 127.0.0.1 koujikanri ---TRANSACTION 0 27492, not started, OS thread id 5408 MySQL thread id 5, query id 348 localhost 127.0.0.1 koujikanri ---TRANSACTION 0 27494, ACTIVE 58 sec, OS thread id 6112 MySQL thread id 2, query id 353 localhost 127.0.0.1 koujikanri Trx read view will not see trx with id >= 0 27495, sees < 0 27491 ---TRANSACTION 0 27491, ACTIVE 93 sec, OS thread id 4288 3 lock struct(s), heap size 320, 8 row lock(s) MySQL thread id 4, query id 343 localhost 127.0.0.1 koujikanri It seems that the "nested transaction are not supported" problem occured when the connection status is: "Trx read view will not see trx with id >= 0 27495, sees < 0 27491" Then after I read http://bugs.mysql.com/bug.php?id=37461, we try to use connection pool false and the problem gone. Now we are still testing it. So, maybe because we didn't use MySQLConnector properly, the problem occured. Please give your opinion. Also if you want I'll try to make test case for you. Thank you very much
[29 Jul 2009 7:10]
Tonci Grgin
Victor, attaching test case is always a good thing, so yes, please, attach one and I'll check.
[29 Aug 2009 23:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".
Description: I am developing an application using VB.net Express Edition and Connector/Net 5.2.5.0. The application using one connection for Transaction and one connection for Select statement. Sometime "nested transaction are not supported" message came out when the application try to start new transaction. For closing transaction I use MySqlTransaction.rollback and MySqlConnection.close It seems my situation resemble #36326 How to repeat: first application - connection 1: > begin transaction > select for update second application - connection 2: > normal select > begin transaction <-- "nested transaction are not supported" message came out But I can't repeat it always. It works fine most of the time ("nested transaction are not supported" message didn't came out). Suggested fix: I don't have.