- 2020-10-09 19:23:17,700 ERROR [saraCsvFileRead2] org.springframework.batch.core.step.AbstractStep: Encountered an error executing step saraCsvFileToDatabaseStep in job saraCsvFileRead
- org.springframework.batch.core.step.FatalStepExecutionException: JobRepository failure forcing rollback
- at org.springframework.batch.core.step.tasklet.TaskletStep$ChunkTransactionCallback.doInTransaction(TaskletStep.java:464)
- at org.springframework.batch.core.step.tasklet.TaskletStep$ChunkTransactionCallback.doInTransaction(TaskletStep.java:331)
- at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:140)
- at org.springframework.batch.core.step.tasklet.TaskletStep$2.doInChunkContext(TaskletStep.java:273)
- at org.springframework.batch.core.scope.context.StepContextRepeatCallback.doInIteration(StepContextRepeatCallback.java:82)
- at org.springframework.batch.repeat.support.RepeatTemplate.getNextResult(RepeatTemplate.java:375)
- at org.springframework.batch.repeat.support.RepeatTemplate.executeInternal(RepeatTemplate.java:215)
- at org.springframework.batch.repeat.support.RepeatTemplate.iterate(RepeatTemplate.java:145)
- at org.springframework.batch.core.step.tasklet.TaskletStep.doExecute(TaskletStep.java:258)
- at org.springframework.batch.core.step.AbstractStep.execute(AbstractStep.java:208)
- at org.springframework.batch.core.job.SimpleStepHandler.handleStep(SimpleStepHandler.java:148)
- at org.springframework.batch.core.job.flow.JobFlowExecutor.executeStep(JobFlowExecutor.java:68)
- at org.springframework.batch.core.job.flow.support.state.StepState.handle(StepState.java:68)
- at org.springframework.batch.core.job.flow.support.SimpleFlow.resume(SimpleFlow.java:169)
- at org.springframework.batch.core.job.flow.support.SimpleFlow.start(SimpleFlow.java:144)
- at org.springframework.batch.core.job.flow.FlowJob.doExecute(FlowJob.java:137)
- at org.springframework.batch.core.job.AbstractJob.execute(AbstractJob.java:319)
- at org.springframework.batch.core.launch.support.SimpleJobLauncher$1.run(SimpleJobLauncher.java:147)
- at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:50)
- at org.springframework.batch.core.launch.support.SimpleJobLauncher.run(SimpleJobLauncher.java:140)
- at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
- at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
- at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
- at java.base/java.lang.reflect.Method.invoke(Method.java:566)
- at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)
- at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)
- at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
- at org.springframework.batch.core.configuration.annotation.SimpleBatchConfiguration$PassthruAdvice.invoke(SimpleBatchConfiguration.java:127)
- at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
- at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
- at com.sun.proxy.$Proxy204.run(Unknown Source)
- at pl.devapo.ibpm.geoloc.sara.SaraImportStarter.lambda$handleContextRefreshEvent$0(SaraImportStarter.java:33)
- at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
- at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
- at java.base/java.lang.Thread.run(Thread.java:834)
- Caused by: org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [UPDATE BATCH_STEP_EXECUTION_CONTEXT SET SHORT_CONTEXT = ?, SERIALIZED_CONTEXT = ? WHERE STEP_EXECUTION_ID = ?]; SQL state [25P02]; error code [0]; BŁĄD: bieżąca transakcja została przerwana, polecenia ignorowane do końca bloku transakcji; nested exception is org.postgresql.util.PSQLException: BŁĄD: bieżąca transakcja została przerwana, polecenia ignorowane do końca bloku transakcji
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:89)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
- at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1443)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:633)
- at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:862)
- at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:917)
- at org.springframework.batch.core.repository.dao.JdbcExecutionContextDao.persistSerializedContext(JdbcExecutionContextDao.java:236)
- at org.springframework.batch.core.repository.dao.JdbcExecutionContextDao.updateExecutionContext(JdbcExecutionContextDao.java:163)
- at org.springframework.batch.core.repository.support.SimpleJobRepository.updateExecutionContext(SimpleJobRepository.java:210)
- at jdk.internal.reflect.GeneratedMethodAccessor739.invoke(Unknown Source)
- at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
- at java.base/java.lang.reflect.Method.invoke(Method.java:566)
- at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)
- at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)
- at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
- at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:366)
- at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:99)
- at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
- at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
- at com.sun.proxy.$Proxy203.updateExecutionContext(Unknown Source)
- at jdk.internal.reflect.GeneratedMethodAccessor739.invoke(Unknown Source)
- at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
- at java.base/java.lang.reflect.Method.invoke(Method.java:566)
- at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)
- at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)
- at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
- at org.springframework.batch.core.configuration.annotation.SimpleBatchConfiguration$PassthruAdvice.invoke(SimpleBatchConfiguration.java:127)
- at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
- at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
- at com.sun.proxy.$Proxy203.updateExecutionContext(Unknown Source)
- at org.springframework.batch.core.step.tasklet.TaskletStep$ChunkTransactionCallback.doInTransaction(TaskletStep.java:452)
- ... 34 common frames omitted
- Caused by: org.postgresql.util.PSQLException: BŁĄD: bieżąca transakcja została przerwana, polecenia ignorowane do końca bloku transakcji
- at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2532)
- at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2267)
- at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:312)
- at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:448)
- at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:369)
- at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:153)
- at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:119)
- at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61)
- at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeUpdate(HikariProxyPreparedStatement.java)
- at org.springframework.jdbc.core.JdbcTemplate.lambda$update$0(JdbcTemplate.java:867)
- at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:617)
- ... 61 common frames omitted
- Caused by: org.postgresql.util.PSQLException: BŁĄD: podwójna wartość klucza narusza ograniczenie unikalności "building_type_pkey"
- Szczegóły: Klucz (key)=(TYPZAB002) już istnieje.
- at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2532)
- at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2267)
- at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:312)
- at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:448)
- at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:369)
- at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:153)
- at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:119)
- at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61)
- at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeUpdate(HikariProxyPreparedStatement.java)
- at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:197)
- at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3226)
- at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3751)
- at org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:91)
- at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:604)
- at org.hibernate.engine.spi.ActionQueue.lambda$executeActions$1(ActionQueue.java:478)
- at java.base/java.util.LinkedHashMap.forEach(LinkedHashMap.java:684)
- at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:475)
- at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:348)
- at org.hibernate.event.internal.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:57)
- at org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:108)
- at org.hibernate.internal.SessionImpl.autoFlushIfRequired(SessionImpl.java:1309)
- at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1389)
- at org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1558)
- at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1526)
- at org.hibernate.query.internal.AbstractProducedQuery.getSingleResult(AbstractProducedQuery.java:1574)
- at org.hibernate.query.criteria.internal.compile.CriteriaQueryTypeQueryAdapter.getSingleResult(CriteriaQueryTypeQueryAdapter.java:111)
- at org.springframework.data.jpa.repository.query.JpaQueryExecution$SingleEntityExecution.doExecute(JpaQueryExecution.java:196)
- at org.springframework.data.jpa.repository.query.JpaQueryExecution.execute(JpaQueryExecution.java:88)
- at org.springframework.data.jpa.repository.query.AbstractJpaQuery.doExecute(AbstractJpaQuery.java:154)
- at org.springframework.data.jpa.repository.query.AbstractJpaQuery.execute(AbstractJpaQuery.java:142)
- at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.doInvoke(RepositoryFactorySupport.java:618)
- at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.invoke(RepositoryFactorySupport.java:605)
- at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
- at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:366)
- at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:99)
- at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
- at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:139)
- at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
- at org.springframework.data.jpa.repository.support.CrudMethodMetadataPostProcessor$CrudMethodMetadataPopulatingMethodInterceptor.invoke(CrudMethodMetadataPostProcessor.java:149)
- at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
- at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:95)
- at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
- at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
- at com.sun.proxy.$Proxy183.findFirstByCode(Unknown Source)
- at pl.devapo.ibpm.geoloc.services.PlacesService.getPopulation(PlacesService.java:85)
- at pl.devapo.ibpm.geoloc.services.GeographicLocationService.toDto(GeographicLocationService.java:257)
- at pl.devapo.ibpm.geoloc.services.GeographicLocationService.save(GeographicLocationService.java:89)
- at pl.devapo.ibpm.geoloc.services.GeographicLocationService$$FastClassBySpringCGLIB$$63e00f1.invoke(<generated>)
- at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
- at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:769)
- at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
- at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:747)
- at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:366)
- at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:99)
- at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
- at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:747)
- at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:689)
- at pl.devapo.ibpm.geoloc.services.GeographicLocationService$$EnhancerBySpringCGLIB$$91a7a6d5.save(<generated>)
- at pl.devapo.ibpm.geoloc.sara.GeoLocCreator.create(GeoLocCreator.java:35)
- at pl.devapo.ibpm.geoloc.sara.SaraCsvRowProcessor.lambda$findGeoLocation$3(SaraCsvRowProcessor.java:58)
- at java.base/java.util.Optional.or(Optional.java:318)
- at pl.devapo.ibpm.geoloc.sara.SaraCsvRowProcessor.findGeoLocation(SaraCsvRowProcessor.java:58)
- at pl.devapo.ibpm.geoloc.sara.SaraCsvRowProcessor.process(SaraCsvRowProcessor.java:33)
- at java.base/java.util.ArrayList.forEach(ArrayList.java:1540)
- at java.base/java.util.Collections$UnmodifiableCollection.forEach(Collections.java:1085)
- at pl.devapo.ibpm.geoloc.sara.SaraImportConfiguration.lambda$csvSaraWriter$0(SaraImportConfiguration.java:42)
- at org.springframework.batch.core.step.item.SimpleChunkProcessor.writeItems(SimpleChunkProcessor.java:193)
- at org.springframework.batch.core.step.item.SimpleChunkProcessor.doWrite(SimpleChunkProcessor.java:159)
- at org.springframework.batch.core.step.item.SimpleChunkProcessor.write(SimpleChunkProcessor.java:294)
- at org.springframework.batch.core.step.item.SimpleChunkProcessor.process(SimpleChunkProcessor.java:217)
- at org.springframework.batch.core.step.item.ChunkOrientedTasklet.execute(ChunkOrientedTasklet.java:77)
- at org.springframework.batch.core.step.tasklet.TaskletStep$ChunkTransactionCallback.doInTransaction(TaskletStep.java:407)
- ... 34 common frames omitted