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

Google Groups | Jenkins | 10 months ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

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

    Google Groups | 10 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 #664

    Google Groups | 7 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 | 3 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
    $Proxy80.record
    1. com.sun.proxy.$Proxy80.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:440)
    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
    $Proxy90.findByRole
    1. com.sun.proxy.$Proxy90.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$$4e6d4196.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