Re: INFORMATION_SCHEMA table gets locked
Hi Gabriela,
Thanks for replying. We are using MySql Connector 6.9.x
The server details are as :
+-------------------------+-----------------------------+
| Variable_name | Value |
+-------------------------+-----------------------------+
| innodb_version | 5.5.37 |
| protocol_version | 10 |
| slave_type_conversions | |
| version | 5.5.37-0ubuntu0.12.04.1-log |
| version_comment | (Ubuntu) |
| version_compile_machine | x86_64 |
| version_compile_os | debian-linux-gnu |
+-------------------------+-----------------------------+
We don't query the INFORMATION_SCHEMA directly. We just use stored procs in our .NET code. In .NET we are using Microsoft Enterprise Library 5.1 for querying the DB.
In case we convert the Stored Procs to String / Inline queries, it works perfectly fine.
We had been using the same architecture with SQL Server for years and never faced the issue.
Please let me know in case you need any more help.
Regards,
Tushar
Subject
Written By
Posted
September 08, 2015 12:57AM
September 18, 2015 08:36AM
Re: INFORMATION_SCHEMA table gets locked
September 18, 2015 10:38AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.