Database console does not terminate transaction
I am using following version of IntelliJ:
IntelliJ IDEA 2017.1.2
Build #IU-171.4249.39, built on April 25, 2017
Licensed to Salman Kagzi
You have a perpetual fallback license for this version
Subscription is active until October 18, 2018
JRE: 1.8.0_112-release-736-b16 x86_64
JVM: OpenJDK 64-Bit Server VM by JetBrains s.r.o
Mac OS X 10.12.4
When I run a query from the database console it creates a transaction and does not terminate it. This subsequently does not allow running any other query from the console and the transaction would block any other read/write to those tables because of this block. I have tried turning the Auto-Commit on and off both, but the behavior remains same. Is there any other setting for this?
Please sign in to leave a comment.
What database/driver do you use? How do you know that there is a transaction running?
I am using PostgreSQL. I had checked the database server which showed running "idle in transaction" status for the query that I had executed last.
Hello,
Could you please try IntelliJ IDEA 2017.2 EAP build (you can install and run it at the same time with installed 2017.1.2 version) as it fixes related issue with console: https://youtrack.jetbrains.com/issue/DBE-1697 This fix will also be available with the next 2017.1.X version update.
Will try it out. Also, the bug covers the case when cancelling a long running query. For me this is happening even when the query completes successfully.
Just trued the EAP Release that was pointed out by Andrey, but same problem exists. After every query that gets executed a save point is created and never released. Following is the output from stats table in postgresql
<DBNAME> | 17446 | <USER> | idle in transaction | | | 00:00:07.759052 | RELEASE SAVEPOINT JDBC_SAVEPOINT_0
Any workarounds for this? I cant use the developer console at all with this version of intelliJ
Please confirm that you have Auto Commit option enabled for this Data Source?
Please file report at https://youtrack.jetbrains.com/issues/DBE with idea.log file attached after IDE restart and reproducing. Please also attach Details* output from Test Connection button for the Data Source. Thanks.