org.jkiss.dbeaver.model.exec.DBCException: SQL Error [25P02]: ERROR: current transaction is aborted, commands ignored until end of transaction block

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Samebug tips

,
via stackoverflow.com by Unknown author

Upgrade the database driver to the latest and check.

<dependency>
    <groupId>org.postgresql</groupId>
    <artifactId>postgresql</artifactId>
    <version>9.3-1101-jdbc41</version>
</dependency>

Replace version with the latest driver version.

,
Expert tip

Try downgrading PostgresSQL server to 9.5 or update your PostgresSQL driver to 9.4-1211 with the following command: <postgresql.version>9.4.1211</postgresql.version>

Solutions on the web

via GitHub by alextakitani
, 11 months ago
SQL Error [25P02]: ERROR: current transaction is aborted, commands ignored until end of transaction block
via GitHub by hbhly
, 1 year ago
SQL ERROR [08S01]: org.apache.thrift.TApplicationException: GetOperationStatus failed: out of sequence response
via GitHub by gandolfwizard
, 2 months ago
SQL Error [42P16]: ERROR: cannot change name of view column "oa_zip4post" to "geom_intersect"
via GitHub by petrvalkoun-gooddata
, 7 months ago
SQL Error: Connection problem, connection_id=91b9428f-3b24-4cec-9c9e-75141ad03336
via GitHub by hbhly
, 1 year ago
SQL ERROR[08S01]: org.apache.thrift.transport.TTransportException: Read a negative frame size (-2147418110)!
via GitHub by cricri
, 7 months ago
SQL Error [42P01]: ERROR: relation "dataimport" does not exist Position: 15
org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2284)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2003)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:200)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:424)
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:321)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:313)
at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.execute(JDBCStatementImpl.java:345)
at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.executeStatement(JDBCStatementImpl.java:138)
at org.jkiss.dbeaver.runtime.sql.SQLQueryJob.executeSingleQuery(SQLQueryJob.java:344)
at org.jkiss.dbeaver.runtime.sql.SQLQueryJob.extractData(SQLQueryJob.java:708)
at org.jkiss.dbeaver.ui.editors.sql.SQLEditor$QueryResultsContainer.readData(SQLEditor.java:1682)
at org.jkiss.dbeaver.tools.transfer.database.DatabaseTransferProducer.transferData(DatabaseTransferProducer.java:113)
at org.jkiss.dbeaver.tools.transfer.database.DatabaseTransferProducer.transferData(DatabaseTransferProducer.java:1)
at org.jkiss.dbeaver.tools.transfer.wizard.DataTransferJob.transferData(DataTransferJob.java:96)
at org.jkiss.dbeaver.tools.transfer.wizard.DataTransferJob.run(DataTransferJob.java:65)
at org.jkiss.dbeaver.model.runtime.AbstractJob.run(AbstractJob.java:103)

Users with the same issue

3 times, 1 day ago
54 times, 1 week ago
Once, 4 weeks ago
Once, 1 month ago
32 times, 1 month ago

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.