[25P02] ERROR: current transaction is aborted, commands ignored until end of transaction block

Permanently deleted user

Created March 18, 2016 20:52

[25P02] ERROR: current transaction is aborted, commands ignored until end of transaction block

I'm using DataGrip 1.0.3 on a MacOS X El Capitan v 10.11.2 and am getting the following error whenever I try to run a query.

This issue only occurs while I'm in datagrip as i can use pgAdminIII to run queries without issue. Any ideas?

1 comment

Andrey Dernov

Created March 21, 2016 07:56

Hello Kevin,

Please try to turn Auto-commit on. Try also if it helps to append "?prepareThreshold=0" argument to a jdbc connection url or set the prepareThreshold property to 0 in Advanced tab in Data Source properties dialog. See aslo https://youtrack.jetbrains.com/issue/DBE-623 about this issue.

Please sign in to leave a comment.