org.postgresql.util.PSQLException: 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

,
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 Google Groups by Jenkins, 1 year ago
ERROR: current transaction is aborted, commands ignored until end of transaction block
via Google Groups by Jenkins, 1 year ago
ERROR: current transaction is aborted, commands ignored until end of transaction block
via postgresql.org by Unknown author, 11 months ago
via Stack Overflow by user1983299
, 2 years ago
ERROR: syntax error at or near "get" Position: 1
via Google Groups by Jennifer Whalan, 4 months ago
ERROR: current transaction is aborted, commands ignored until end of transaction block
via Google Groups by stuart.wood, 4 months ago
ERROR: duplicate key value violates unique constraint "community2community_pkey"
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:2102)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
at org.datanucleus.store.rdbms.datasource.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:94)
at org.datanucleus.store.rdbms.datasource.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:94)
at org.datanucleus.store.rdbms.ParamLoggingPreparedStatement.executeQuery(ParamLoggingPreparedStatement.java:375)
at org.datanucleus.store.rdbms.SQLController.executeStatementQuery(SQLController.java:552)
at org.datanucleus.store.query.Query.executeQuery(Query.java:1833)
at org.motechproject.mds.service.impl.history.HistoryServiceImpl.getLatestRevision(HistoryServiceImpl.java:170)
at org.motechproject.mds.service.impl.history.HistoryServiceImpl.shouldRecordHistory(HistoryServiceImpl.java:128)
at org.motechproject.mds.service.impl.history.HistoryServiceImpl.record(HistoryServiceImpl.java:47)
at sun.reflect.GeneratedMethodAccessor304.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at com.sun.proxy.$Proxy80.record(Unknown Source)
at org.motechproject.mds.listener.records.HistoryListener.postStore(HistoryListener.java:28)
at org.datanucleus.state.StateManagerImpl.flush(StateManagerImpl.java:4677)
at org.datanucleus.flush.FlushOrdered.execute(FlushOrdered.java:107)
at org.datanucleus.ExecutionContextImpl.flushInternal(ExecutionContextImpl.java:4013)
at org.datanucleus.store.query.Query.prepareDatastore(Query.java:1625)
at org.datanucleus.store.query.Query.executeQuery(Query.java:1810)
at org.motechproject.mds.query.QueryExecutor.executeWithArray(QueryExecutor.java:74)
at org.motechproject.mds.repository.MotechDataRepository.retrieveAll(MotechDataRepository.java:149)
at org.motechproject.mds.service.TransactionalMotechDataService$3.doInTransaction(TransactionalMotechDataService.java:47)
at org.motechproject.mds.service.TransactionalMotechDataService$3.doInTransaction(TransactionalMotechDataService.java:43)
at org.motechproject.mds.service.DefaultMotechDataService.doInTransaction(DefaultMotechDataService.java:440)
at org.motechproject.mds.service.TransactionalMotechDataService.retrieveAll(TransactionalMotechDataService.java:43)
at org.motechproject.security.domain.mdsserviceimpl.MotechUserServiceImpl.findByRole(MotechUserServiceImpl.java)
at sun.reflect.GeneratedMethodAccessor343.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
at com.sun.proxy.$Proxy90.findByRole(Unknown Source)
at sun.reflect.GeneratedMethodAccessor343.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at org.eclipse.gemini.blueprint.service.importer.support.internal.aop.ServiceInvoker.doInvoke(ServiceInvoker.java:56)
at org.eclipse.gemini.blueprint.service.importer.support.internal.aop.ServiceInvoker.invoke(ServiceInvoker.java:60)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:132)
at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:120)
at org.eclipse.gemini.blueprint.service.util.internal.aop.ServiceTCCLInterceptor.invokeUnprivileged(ServiceTCCLInterceptor.java:70)
at org.eclipse.gemini.blueprint.service.util.internal.aop.ServiceTCCLInterceptor.invoke(ServiceTCCLInterceptor.java:53)
at org.eclipse.gemini.blueprint.service.importer.support.LocalBundleContextAdvice.invoke(LocalBundleContextAdvice.java:57)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:132)
at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:120)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at com.sun.proxy.$Proxy112.findByRole(Unknown Source)
at org.motechproject.security.repository.MotechUsersDao.findByRole(MotechUsersDao.java:66)
at org.motechproject.security.repository.MotechUsersDao$$FastClassBySpringCGLIB$$6dc903cf.invoke()
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:700)
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.motechproject.security.repository.MotechUsersDao$$EnhancerBySpringCGLIB$$4e6d4196.findByRole()
at org.motechproject.security.service.impl.MotechRoleServiceImpl.updateRole(MotechRoleServiceImpl.java:60)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at com.sun.proxy.$Proxy115.updateRole(Unknown Source)
at org.motechproject.security.service.impl.MotechPermissionServiceImpl.add(MotechPermissionServiceImpl.java:106)
at org.motechproject.security.service.impl.MotechPermissionServiceImpl.addPermission(MotechPermissionServiceImpl.java:61)
at sun.reflect.GeneratedMethodAccessor362.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at com.sun.proxy.$Proxy118.addPermission(Unknown Source)
at org.motechproject.security.it.RolesBundleIT.setUp(RolesBundleIT.java:124)

Users with the same issue

37 times, 1 week ago
3 times, 1 month ago
Once, 2 months ago
Once, 2 months ago
32 times, 2 months ago

Write tip

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