Facebook
From Botched Coyote, 4 Years ago, written in Plain Text.
Embed
Download Paste or View Raw
Hits: 377
  1. 2020-10-09 19:23:17,700 ERROR [saraCsvFileRead2] org.springframework.batch.core.step.AbstractStep: Encountered an error executing step saraCsvFileToDatabaseStep in job saraCsvFileRead
  2. org.springframework.batch.core.step.FatalStepExecutionException: JobRepository failure forcing rollback
  3.         at org.springframework.batch.core.step.tasklet.TaskletStep$ChunkTransactionCallback.doInTransaction(TaskletStep.java:464)
  4.         at org.springframework.batch.core.step.tasklet.TaskletStep$ChunkTransactionCallback.doInTransaction(TaskletStep.java:331)
  5.         at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:140)
  6.         at org.springframework.batch.core.step.tasklet.TaskletStep$2.doInChunkContext(TaskletStep.java:273)
  7.         at org.springframework.batch.core.scope.context.StepContextRepeatCallback.doInIteration(StepContextRepeatCallback.java:82)
  8.         at org.springframework.batch.repeat.support.RepeatTemplate.getNextResult(RepeatTemplate.java:375)
  9.         at org.springframework.batch.repeat.support.RepeatTemplate.executeInternal(RepeatTemplate.java:215)
  10.         at org.springframework.batch.repeat.support.RepeatTemplate.iterate(RepeatTemplate.java:145)
  11.         at org.springframework.batch.core.step.tasklet.TaskletStep.doExecute(TaskletStep.java:258)
  12.         at org.springframework.batch.core.step.AbstractStep.execute(AbstractStep.java:208)
  13.         at org.springframework.batch.core.job.SimpleStepHandler.handleStep(SimpleStepHandler.java:148)
  14.         at org.springframework.batch.core.job.flow.JobFlowExecutor.executeStep(JobFlowExecutor.java:68)
  15.         at org.springframework.batch.core.job.flow.support.state.StepState.handle(StepState.java:68)
  16.         at org.springframework.batch.core.job.flow.support.SimpleFlow.resume(SimpleFlow.java:169)
  17.         at org.springframework.batch.core.job.flow.support.SimpleFlow.start(SimpleFlow.java:144)
  18.         at org.springframework.batch.core.job.flow.FlowJob.doExecute(FlowJob.java:137)
  19.         at org.springframework.batch.core.job.AbstractJob.execute(AbstractJob.java:319)
  20.         at org.springframework.batch.core.launch.support.SimpleJobLauncher$1.run(SimpleJobLauncher.java:147)
  21.         at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:50)
  22.         at org.springframework.batch.core.launch.support.SimpleJobLauncher.run(SimpleJobLauncher.java:140)
  23.         at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  24.         at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  25.         at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  26.         at java.base/java.lang.reflect.Method.invoke(Method.java:566)
  27.         at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)
  28.         at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)
  29.         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
  30.         at org.springframework.batch.core.configuration.annotation.SimpleBatchConfiguration$PassthruAdvice.invoke(SimpleBatchConfiguration.java:127)
  31.         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  32.         at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
  33.         at com.sun.proxy.$Proxy204.run(Unknown Source)
  34.         at pl.devapo.ibpm.geoloc.sara.SaraImportStarter.lambda$handleContextRefreshEvent$0(SaraImportStarter.java:33)
  35.         at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
  36.         at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
  37.         at java.base/java.lang.Thread.run(Thread.java:834)
  38. 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
  39.         at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:89)
  40.         at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
  41.         at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
  42.         at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1443)
  43.         at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:633)
  44.         at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:862)
  45.         at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:917)
  46.         at org.springframework.batch.core.repository.dao.JdbcExecutionContextDao.persistSerializedContext(JdbcExecutionContextDao.java:236)
  47.         at org.springframework.batch.core.repository.dao.JdbcExecutionContextDao.updateExecutionContext(JdbcExecutionContextDao.java:163)
  48.         at org.springframework.batch.core.repository.support.SimpleJobRepository.updateExecutionContext(SimpleJobRepository.java:210)
  49.         at jdk.internal.reflect.GeneratedMethodAccessor739.invoke(Unknown Source)
  50.         at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  51.         at java.base/java.lang.reflect.Method.invoke(Method.java:566)
  52.         at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)
  53.         at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)
  54.         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
  55.         at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:366)
  56.         at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:99)
  57.         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  58.         at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
  59.         at com.sun.proxy.$Proxy203.updateExecutionContext(Unknown Source)
  60.         at jdk.internal.reflect.GeneratedMethodAccessor739.invoke(Unknown Source)
  61.         at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  62.         at java.base/java.lang.reflect.Method.invoke(Method.java:566)
  63.         at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)
  64.         at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)
  65.         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
  66.         at org.springframework.batch.core.configuration.annotation.SimpleBatchConfiguration$PassthruAdvice.invoke(SimpleBatchConfiguration.java:127)
  67.         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  68.         at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
  69.         at com.sun.proxy.$Proxy203.updateExecutionContext(Unknown Source)
  70.         at org.springframework.batch.core.step.tasklet.TaskletStep$ChunkTransactionCallback.doInTransaction(TaskletStep.java:452)
  71.         ... 34 common frames omitted
  72. Caused by: org.postgresql.util.PSQLException: BŁĄD: bieżąca transakcja została przerwana, polecenia ignorowane do końca bloku transakcji
  73.         at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2532)
  74.         at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2267)
  75.         at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:312)
  76.         at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:448)
  77.         at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:369)
  78.         at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:153)
  79.         at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:119)
  80.         at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61)
  81.         at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeUpdate(HikariProxyPreparedStatement.java)
  82.         at org.springframework.jdbc.core.JdbcTemplate.lambda$update$0(JdbcTemplate.java:867)
  83.         at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:617)
  84.         ... 61 common frames omitted
  85. Caused by: org.postgresql.util.PSQLException: BŁĄD: podwójna wartość klucza narusza ograniczenie unikalności "building_type_pkey"
  86.   Szczegóły: Klucz (key)=(TYPZAB002) już istnieje.
  87.         at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2532)
  88.         at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2267)
  89.         at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:312)
  90.         at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:448)
  91.         at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:369)
  92.         at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:153)
  93.         at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:119)
  94.         at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61)
  95.         at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeUpdate(HikariProxyPreparedStatement.java)
  96.         at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:197)
  97.         at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3226)
  98.         at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3751)
  99.         at org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:91)
  100.         at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:604)
  101.         at org.hibernate.engine.spi.ActionQueue.lambda$executeActions$1(ActionQueue.java:478)
  102.         at java.base/java.util.LinkedHashMap.forEach(LinkedHashMap.java:684)
  103.         at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:475)
  104.         at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:348)
  105.         at org.hibernate.event.internal.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:57)
  106.         at org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:108)
  107.         at org.hibernate.internal.SessionImpl.autoFlushIfRequired(SessionImpl.java:1309)
  108.         at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1389)
  109.         at org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1558)
  110.         at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1526)
  111.         at org.hibernate.query.internal.AbstractProducedQuery.getSingleResult(AbstractProducedQuery.java:1574)
  112.         at org.hibernate.query.criteria.internal.compile.CriteriaQueryTypeQueryAdapter.getSingleResult(CriteriaQueryTypeQueryAdapter.java:111)
  113.         at org.springframework.data.jpa.repository.query.JpaQueryExecution$SingleEntityExecution.doExecute(JpaQueryExecution.java:196)
  114.         at org.springframework.data.jpa.repository.query.JpaQueryExecution.execute(JpaQueryExecution.java:88)
  115.         at org.springframework.data.jpa.repository.query.AbstractJpaQuery.doExecute(AbstractJpaQuery.java:154)
  116.         at org.springframework.data.jpa.repository.query.AbstractJpaQuery.execute(AbstractJpaQuery.java:142)
  117.         at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.doInvoke(RepositoryFactorySupport.java:618)
  118.         at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.invoke(RepositoryFactorySupport.java:605)
  119.         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  120.         at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:366)
  121.         at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:99)
  122.         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  123.         at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:139)
  124.         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  125.         at org.springframework.data.jpa.repository.support.CrudMethodMetadataPostProcessor$CrudMethodMetadataPopulatingMethodInterceptor.invoke(CrudMethodMetadataPostProcessor.java:149)
  126.         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  127.         at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:95)
  128.         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  129.         at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
  130.         at com.sun.proxy.$Proxy183.findFirstByCode(Unknown Source)
  131.         at pl.devapo.ibpm.geoloc.services.PlacesService.getPopulation(PlacesService.java:85)
  132.         at pl.devapo.ibpm.geoloc.services.GeographicLocationService.toDto(GeographicLocationService.java:257)
  133.         at pl.devapo.ibpm.geoloc.services.GeographicLocationService.save(GeographicLocationService.java:89)
  134.         at pl.devapo.ibpm.geoloc.services.GeographicLocationService$$FastClassBySpringCGLIB$$63e00f1.invoke(<generated>)
  135.         at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
  136.         at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:769)
  137.         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
  138.         at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:747)
  139.         at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:366)
  140.         at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:99)
  141.         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  142.         at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:747)
  143.         at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:689)
  144.         at pl.devapo.ibpm.geoloc.services.GeographicLocationService$$EnhancerBySpringCGLIB$$91a7a6d5.save(<generated>)
  145.         at pl.devapo.ibpm.geoloc.sara.GeoLocCreator.create(GeoLocCreator.java:35)
  146.         at pl.devapo.ibpm.geoloc.sara.SaraCsvRowProcessor.lambda$findGeoLocation$3(SaraCsvRowProcessor.java:58)
  147.         at java.base/java.util.Optional.or(Optional.java:318)
  148.         at pl.devapo.ibpm.geoloc.sara.SaraCsvRowProcessor.findGeoLocation(SaraCsvRowProcessor.java:58)
  149.         at pl.devapo.ibpm.geoloc.sara.SaraCsvRowProcessor.process(SaraCsvRowProcessor.java:33)
  150.         at java.base/java.util.ArrayList.forEach(ArrayList.java:1540)
  151.         at java.base/java.util.Collections$UnmodifiableCollection.forEach(Collections.java:1085)
  152.         at pl.devapo.ibpm.geoloc.sara.SaraImportConfiguration.lambda$csvSaraWriter$0(SaraImportConfiguration.java:42)
  153.         at org.springframework.batch.core.step.item.SimpleChunkProcessor.writeItems(SimpleChunkProcessor.java:193)
  154.         at org.springframework.batch.core.step.item.SimpleChunkProcessor.doWrite(SimpleChunkProcessor.java:159)
  155.         at org.springframework.batch.core.step.item.SimpleChunkProcessor.write(SimpleChunkProcessor.java:294)
  156.         at org.springframework.batch.core.step.item.SimpleChunkProcessor.process(SimpleChunkProcessor.java:217)
  157.         at org.springframework.batch.core.step.item.ChunkOrientedTasklet.execute(ChunkOrientedTasklet.java:77)
  158.         at org.springframework.batch.core.step.tasklet.TaskletStep$ChunkTransactionCallback.doInTransaction(TaskletStep.java:407)
  159.         ... 34 common frames omitted

Replies to Untitled rss

Title Name Language When
Re: Untitled Mature Peafowl text 4 Years ago.