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


Samebug tips1

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>


7 months ago
Expert tip

Solutions on the web14

Solution icon of github
via GitHub by alextakitani
, 9 months ago
SQL Error [25P02]: ERROR: current transaction is aborted, commands ignored until end of transaction block

Solution icon of github
via GitHub by hbhly
, 1 year ago
SQL ERROR [08S01]: org.apache.thrift.TApplicationException: GetOperationStatus failed: out of sequence response

Solution icon of github
SQL Error: Interrupted

Solution icon of github
SQL Error [42P16]: ERROR: cannot change name of view column "oa_zip4post" to "geom_intersect"

Solution icon of github
SQL Error: Internal jdbc driver error

Solution icon of github
via GitHub by BuZZ-dEE
, 1 year ago
SQL Error [911] [22019]: ORA-00911: Ungültiges Zeichen

Solution icon of github
SQL Error [208] [S0002]: Invalid object name 'dbo.StatusOnOff'.

Solution icon of github
SQL Error: Connection problem, connection_id=91b9428f-3b24-4cec-9c9e-75141ad03336

Solution icon of github
via GitHub by hbhly
, 1 year ago
SQL ERROR[08S01]: org.apache.thrift.transport.TTransportException: Read a negative frame size (-2147418110)!

Solution icon of github
via GitHub by jk3us
, 3 weeks ago
SQL Error [42P01]: ERROR: relation "orders" does not exist Position: 15

Stack trace

org.jkiss.dbeaver.model.exec.DBCException: SQL Error [25P02]: ERROR: current transaction is aborted, commands ignored until end of transaction block
	at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.executeStatement(JDBCStatementImpl.java:141)
	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)
	at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)
Caused by: 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)
	... 9 more

Write tip

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago
5 times, 2 weeks ago
18 times, 5 months ago
4 times, 9 months ago
4430 times, 10 months ago
98 more bugmates