org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block

Google Groups | Jenkins | 2 months ago
  1. 0

    Build failed in Jenkins: Platform-IntegrationTests-PostgreSQL #664

    Google Groups | 2 months ago | Jenkins
    org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block
  2. 0

    Build failed in Jenkins: Platform-IntegrationTests-PostgreSQL #563

    Google Groups | 6 months ago | Jenkins
    org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block
  3. 0

    Datanucleus + PostgreSQL not escaping backslashes

    Stack Overflow | 5 years ago | Mark Peters
    org.postgresql.util.PSQLException: ERROR: unterminated quoted string at or near "'\'" Position: 128
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Could not get a cluster ID

    GitHub | 2 years ago | wezell
    com.dotmarketing.exception.DotDataException: ERROR: current transaction is aborted, commands ignored until end of transaction block
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. org.postgresql.util.PSQLException

    ERROR: current transaction is aborted, commands ignored until end of transaction block

    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse()
  2. PostgreSQL JDBC Driver
    AbstractJdbc2Statement.executeQuery
    1. org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
    2. org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
    3. org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
    4. org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
    5. org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
    6. org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)
    6 frames
  3. DataNucleus RDBMS plugin
    JDOQLQuery.performExecute
    1. org.datanucleus.store.rdbms.datasource.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:94)
    2. org.datanucleus.store.rdbms.datasource.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:94)
    3. org.datanucleus.store.rdbms.ParamLoggingPreparedStatement.executeQuery(ParamLoggingPreparedStatement.java:375)
    4. org.datanucleus.store.rdbms.SQLController.executeStatementQuery(SQLController.java:552)
    5. org.datanucleus.store.rdbms.query.JDOQLQuery.performExecute(JDOQLQuery.java:615)
    5 frames
  4. DataNucleus Core
    Query.executeWithArray
    1. org.datanucleus.store.query.Query.executeQuery(Query.java:1833)
    2. org.datanucleus.store.query.Query.executeWithArray(Query.java:1722)
    2 frames
  5. DataNucleus JDO API plugin
    JDOQuery.execute
    1. org.datanucleus.api.jdo.JDOQuery.execute(JDOQuery.java:245)
    1 frame
  6. org.motechproject.mds
    HistoryServiceImpl.record
    1. org.motechproject.mds.service.impl.history.HistoryServiceImpl.getLatestRevision(HistoryServiceImpl.java:170)
    2. org.motechproject.mds.service.impl.history.HistoryServiceImpl.shouldRecordHistory(HistoryServiceImpl.java:128)
    3. org.motechproject.mds.service.impl.history.HistoryServiceImpl.record(HistoryServiceImpl.java:47)
    3 frames
  7. Java RT
    Method.invoke
    1. sun.reflect.GeneratedMethodAccessor304.invoke(Unknown Source)
    2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    3. java.lang.reflect.Method.invoke(Method.java:497)
    3 frames
  8. Spring AOP
    ReflectiveMethodInvocation.proceed
    1. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
    2. org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
    3. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
    3 frames
  9. Spring Tx
    TransactionInterceptor.invoke
    1. org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)
    2. org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)
    3. org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)
    3 frames
  10. Spring AOP
    JdkDynamicAopProxy.invoke
    1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
    2. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
    2 frames
  11. com.sun.proxy
    $Proxy79.record
    1. com.sun.proxy.$Proxy79.record(Unknown Source)
    1 frame
  12. org.motechproject.mds
    HistoryListener.postStore
    1. org.motechproject.mds.listener.records.HistoryListener.postStore(HistoryListener.java:28)
    1 frame
  13. DataNucleus JDO API plugin
    JDOCallbackHandler.postStore
    1. org.datanucleus.api.jdo.JDOCallbackHandler.postStore(JDOCallbackHandler.java:154)
    1 frame
  14. DataNucleus Core
    Query.executeWithArray
    1. org.datanucleus.state.StateManagerImpl.flush(StateManagerImpl.java:4677)
    2. org.datanucleus.flush.FlushOrdered.execute(FlushOrdered.java:107)
    3. org.datanucleus.ExecutionContextImpl.flushInternal(ExecutionContextImpl.java:4013)
    4. org.datanucleus.store.query.Query.prepareDatastore(Query.java:1625)
    5. org.datanucleus.store.query.Query.executeQuery(Query.java:1810)
    6. org.datanucleus.store.query.Query.executeWithArray(Query.java:1722)
    6 frames
  15. DataNucleus JDO API plugin
    JDOQuery.executeWithArray
    1. org.datanucleus.api.jdo.JDOQuery.executeWithArray(JDOQuery.java:314)
    1 frame
  16. org.motechproject.mds
    TransactionalMotechDataService$3.doInTransaction
    1. org.motechproject.mds.query.QueryExecutor.executeWithArray(QueryExecutor.java:74)
    2. org.motechproject.mds.repository.MotechDataRepository.retrieveAll(MotechDataRepository.java:149)
    3. org.motechproject.mds.service.TransactionalMotechDataService$3.doInTransaction(TransactionalMotechDataService.java:47)
    4. org.motechproject.mds.service.TransactionalMotechDataService$3.doInTransaction(TransactionalMotechDataService.java:43)
    4 frames
  17. Spring Tx
    TransactionTemplate.execute
    1. org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:131)
    1 frame
  18. org.motechproject.mds
    TransactionalMotechDataService.retrieveAll
    1. org.motechproject.mds.service.DefaultMotechDataService.doInTransaction(DefaultMotechDataService.java:464)
    2. org.motechproject.mds.service.TransactionalMotechDataService.retrieveAll(TransactionalMotechDataService.java:43)
    2 frames
  19. org.motechproject.security
    MotechUserServiceImpl.findByRole
    1. org.motechproject.security.domain.mdsserviceimpl.MotechUserServiceImpl.findByRole(MotechUserServiceImpl.java)
    1 frame
  20. Java RT
    Method.invoke
    1. sun.reflect.GeneratedMethodAccessor343.invoke(Unknown Source)
    2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    3. java.lang.reflect.Method.invoke(Method.java:497)
    3 frames
  21. Spring AOP
    JdkDynamicAopProxy.invoke
    1. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
    2. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:198)
    2 frames
  22. com.sun.proxy
    $Proxy88.findByRole
    1. com.sun.proxy.$Proxy88.findByRole(Unknown Source)
    1 frame
  23. Java RT
    Method.invoke
    1. sun.reflect.GeneratedMethodAccessor343.invoke(Unknown Source)
    2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    3. java.lang.reflect.Method.invoke(Method.java:497)
    3 frames
  24. Spring AOP
    AopUtils.invokeJoinpointUsingReflection
    1. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
    1 frame
  25. org.eclipse.gemini
    ServiceInvoker.invoke
    1. org.eclipse.gemini.blueprint.service.importer.support.internal.aop.ServiceInvoker.doInvoke(ServiceInvoker.java:56)
    2. org.eclipse.gemini.blueprint.service.importer.support.internal.aop.ServiceInvoker.invoke(ServiceInvoker.java:60)
    2 frames
  26. Spring AOP
    ReflectiveMethodInvocation.proceed
    1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
    2. org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:132)
    3. org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:120)
    4. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
    4 frames
  27. org.eclipse.gemini
    ServiceTCCLInterceptor.invoke
    1. org.eclipse.gemini.blueprint.service.util.internal.aop.ServiceTCCLInterceptor.invokeUnprivileged(ServiceTCCLInterceptor.java:70)
    2. org.eclipse.gemini.blueprint.service.util.internal.aop.ServiceTCCLInterceptor.invoke(ServiceTCCLInterceptor.java:53)
    2 frames
  28. Spring AOP
    ReflectiveMethodInvocation.proceed
    1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
    1 frame
  29. org.eclipse.gemini
    LocalBundleContextAdvice.invoke
    1. org.eclipse.gemini.blueprint.service.importer.support.LocalBundleContextAdvice.invoke(LocalBundleContextAdvice.java:57)
    1 frame
  30. Spring AOP
    JdkDynamicAopProxy.invoke
    1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
    2. org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:132)
    3. org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:120)
    4. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
    5. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
    5 frames
  31. com.sun.proxy
    $Proxy112.findByRole
    1. com.sun.proxy.$Proxy112.findByRole(Unknown Source)
    1 frame
  32. org.motechproject.security
    MotechUsersDao$$FastClassBySpringCGLIB$$6dc903cf.invoke
    1. org.motechproject.security.repository.MotechUsersDao.findByRole(MotechUsersDao.java:66)
    2. org.motechproject.security.repository.MotechUsersDao$$FastClassBySpringCGLIB$$6dc903cf.invoke(<generated>)
    2 frames
  33. Spring Core
    MethodProxy.invoke
    1. org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
    1 frame
  34. Spring AOP
    ReflectiveMethodInvocation.proceed
    1. org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:700)
    2. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
    2 frames
  35. Spring Tx
    TransactionInterceptor.invoke
    1. org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)
    2. org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)
    3. org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)
    3 frames
  36. Spring AOP
    CglibAopProxy$DynamicAdvisedInterceptor.intercept
    1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
    2. org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:633)
    2 frames
  37. org.motechproject.security
    MotechRoleServiceImpl.updateRole
    1. org.motechproject.security.repository.MotechUsersDao$$EnhancerBySpringCGLIB$$714133d2.findByRole(<generated>)
    2. org.motechproject.security.service.impl.MotechRoleServiceImpl.updateRole(MotechRoleServiceImpl.java:60)
    2 frames
  38. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    4. java.lang.reflect.Method.invoke(Method.java:497)
    4 frames
  39. Spring AOP
    ReflectiveMethodInvocation.proceed
    1. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
    2. org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
    3. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
    3 frames
  40. Spring Tx
    TransactionInterceptor.invoke
    1. org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)
    2. org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)
    3. org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)
    3 frames
  41. Spring AOP
    JdkDynamicAopProxy.invoke
    1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
    2. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
    2 frames
  42. com.sun.proxy
    $Proxy115.updateRole
    1. com.sun.proxy.$Proxy115.updateRole(Unknown Source)
    1 frame
  43. org.motechproject.security
    MotechPermissionServiceImpl.addPermission
    1. org.motechproject.security.service.impl.MotechPermissionServiceImpl.add(MotechPermissionServiceImpl.java:106)
    2. org.motechproject.security.service.impl.MotechPermissionServiceImpl.addPermission(MotechPermissionServiceImpl.java:61)
    2 frames
  44. Java RT
    Method.invoke
    1. sun.reflect.GeneratedMethodAccessor362.invoke(Unknown Source)
    2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    3. java.lang.reflect.Method.invoke(Method.java:497)
    3 frames
  45. Spring AOP
    ReflectiveMethodInvocation.proceed
    1. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
    2. org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
    3. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
    3 frames
  46. Spring Tx
    TransactionInterceptor.invoke
    1. org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)
    2. org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)
    3. org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)
    3 frames
  47. Spring AOP
    JdkDynamicAopProxy.invoke
    1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
    2. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
    2 frames
  48. com.sun.proxy
    $Proxy118.addPermission
    1. com.sun.proxy.$Proxy118.addPermission(Unknown Source)
    1 frame
  49. org.motechproject.security
    RolesBundleIT.setUp
    1. org.motechproject.security.it.RolesBundleIT.setUp(RolesBundleIT.java:124)
    1 frame