PSQLException: current transaction is aborted, commands ignored until end of transaction block
В общем смежники наши босоногие полазили руками в продакшине и в результате на банальный запрос из Java OpenJPA выскакивает такая ошибка.
Стекоферфло читал не сильно помогло так как транзакции идут нормально на рабочих базах и в QA
http://stackoverflow.com/questions/10399727/psqlexception-current-transaction-is-aborted-commands-ignored-until-end-of-tra
Какой лог попросить чтоб запустили посмотреть где там проблемма? Попросил босоногих друзей отдать server.log может выдадут завтра по утру, но может чего там подкрутить в установках логов в postgresql.conf чтоб сразу показала на каком query транзакция затыкается?
В общем заранее благодарен за любой совет. Если совет удачный с меня бесплатный обед.
http://www.sql.ru/forum/1164940/psqlexception-current-transaction-is-aborted-commands-ignored-until-end-of-transaction
Задал этот вопрос в Постгрес разделе и решил повторить здесь на всякий случай
Лог в джава показывает следующие
2015-07-02 16:50:20,702[pool-29-thread-1]|ERROR|com.ge.pw.betz.data.excel.CtiDataLoader|ERROR: current transaction is aborted, commands ignored until end of transaction block {prepstmnt 886280117 SELECT NEXTVAL('mla.SEQ_ID_CTI_DATA_MAP')} [code=0, state=25P02]; nested exception is <openjpa-2.2.2-rUnversioned directory fatal general error> org.apache.openjpa.persistence.PersistenceException: ERROR: current transaction is aborted, commands ignored until end of transaction block {prepstmnt 886280117 SELECT NEXTVAL('mla.SEQ_ID_CTI_DATA_MAP')} [code=0, state=25P02]
org.springframework.orm.jpa.JpaSystemException: ERROR: current transaction is aborted, commands ignored until end of transaction block {prepstmnt 886280117 SELECT NEXTVAL('mla.SEQ_ID_CTI_DATA_MAP')} [code=0, state=25P02]; nested exception is <openjpa-2.2.2-rUnversioned directory fatal general error> org.apache.openjpa.persistence.PersistenceException: ERROR: current transaction is aborted, commands ignored until end of transaction block {prepstmnt 886280117 SELECT NEXTVAL('mla.SEQ_ID_CTI_DATA_MAP')} [code=0, state=25P02]
at org.springframework.orm.jpa.EntityManagerFactoryUtils.convertJpaAccessExceptionIfPossible(EntityManagerFactoryUtils.java:321)[132:org.springframework.orm:3.1.4.RELEASE]
at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.translateExceptionIfPossible(AbstractEntityManagerFactoryBean.java:404)[132:org.springframework.orm:3.1.4.RELEASE]
at org.springframework.dao.support.ChainedPersistenceExceptionTranslator.translateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:58)[111:org.springframework.transaction:3.1.4.RELEASE]
at org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:213)[111:org.springframework.transaction:3.1.4.RELEASE]
at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:163)[111:org.springframework.transaction:3.1.4.RELEASE]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)[18:org.springframework.aop:3.1.4.RELEASE]
at org.springframework.data.jpa.repository.support.LockModeRepositoryPostProcessor$LockModePopulatingMethodIntercceptor.invoke(LockModeRepositoryPostProcessor.java:92)[187:org.springframework.data.jpa:1.3.0.RELEASE]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)[18:org.springframework.aop:3.1.4.RELEASE]
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:90)[18:org.springframework.aop:3.1.4.RELEASE]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)[18:org.springframework.aop:3.1.4.RELEASE]
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)[18:org.springframework.aop:3.1.4.RELEASE]
at com.sun.proxy.$Proxy355.flush(Unknown Source)[:]
at com.ge.pw.betz.data.excel.CtiDataLoader.loadSiteCtiData(CtiDataLoader.java:175)[378:betz-data-service:1.0.0]
at com.ge.pw.betz.data.excel.CtiDataLoader.load(CtiDataLoader.java:106)[378:betz-data-service:1.0.0]
at com.ge.pw.betz.data.excel.CtiDataLoader$$FastClassByCGLIB$$b57640fb.invoke(<generated>)[mvn:org.apache.servicemix.bundles/org.apache.servicemix.bundles.cglib/2.2.2_1:]
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)[108:org.apache.servicemix.bundles.cglib:2.2.2.1]
at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:689)[18:org.springframework.aop:3.1.4.RELEASE]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)[18:org.springframework.aop:3.1.4.RELEASE]
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)[111:org.springframework.transaction:3.1.4.RELEASE]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)[18:org.springframework.aop:3.1.4.RELEASE]
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:622)[18:org.springframework.aop:3.1.4.RELEASE]
at com.ge.pw.betz.data.excel.CtiDataLoader$$EnhancerByCGLIB$$3011ea24.load(<generated>)[mvn:org.apache.servicemix.bundles/org.apache.servicemix.bundles.cglib/2.2.2_1:]
at com.ge.pw.betz.data.excel.ExcelLoaderService.loadCtiData(ExcelLoaderService.java:151)[378:betz-data-service:1.0.0]
at com.ge.pw.betz.data.excel.ExcelLoaderService.access$000(ExcelLoaderService.java:25)[378:betz-data-service:1.0.0]
at com.ge.pw.betz.data.excel.ExcelLoaderService$1.run(ExcelLoaderService.java:77)[378:betz-data-service:1.0.0]
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)[:1.7.0_75]
at java.util.concurrent.FutureTask.run(Unknown Source)[:1.7.0_75]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)[:1.7.0_75]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)[:1.7.0_75]
at java.lang.Thread.run(Unknown Source)[:1.7.0_75]
Caused by: <openjpa-2.2.2-rUnversioned directory fatal general error> org.apache.openjpa.persistence.PersistenceException: ERROR: current transaction is aborted, commands ignored until end of transaction block {prepstmnt 886280117 SELECT NEXTVAL('mla.SEQ_ID_CTI_DATA_MAP')} [code=0, state=25P02]
at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4967)[253:org.apache.openjpa:2.2.2]
at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4927)[253:org.apache.openjpa:2.2.2]
at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:136)[253:org.apache.openjpa:2.2.2]
at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:110)[253:org.apache.openjpa:2.2.2]
at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:62)[253:org.apache.openjpa:2.2.2]
at org.apache.openjpa.jdbc.kernel.AbstractJDBCSeq.next(AbstractJDBCSeq.java:66)[253:org.apache.openjpa:2.2.2]
at org.apache.openjpa.util.ImplHelper.generateValue(ImplHelper.java:160)[253:org.apache.openjpa:2.2.2]
at org.apache.openjpa.util.ImplHelper.generateFieldValue(ImplHelper.java:144)[253:org.apache.openjpa:2.2.2]
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.assignField(JDBCStoreManager.java:775)[253:org.apache.openjpa:2.2.2]
at org.apache.openjpa.util.ApplicationIds.assign(ApplicationIds.java:493)[253:org.apache.openjpa:2.2.2]
at org.apache.openjpa.util.ApplicationIds.assign(ApplicationIds.java:469)[253:org.apache.openjpa:2.2.2]
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.assignObjectId(JDBCStoreManager.java:759)[253:org.apache.openjpa:2.2.2]
