14:19:12.541 [SimpleAsyncTaskExecutor-1] INFO  o.a.k.c.consumer.internals.Fetcher - [Consumer clientId=consumer-3, groupId=manual-db-process] Resetting offset for partition manual_events-2 to offset 0.


14:19:12.541 [SimpleAsyncTaskExecutor-1] INFO  o.a.k.c.consumer.internals.Fetcher - [Consumer clientId=consumer-4, groupId=manual-process] Resetting offset for partition manual_events-3 to offset 0.


14:19:12.541 [SimpleAsyncTaskExecutor-1] INFO  o.a.k.c.consumer.internals.Fetcher - [Consumer clientId=consumer-3, groupId=manual-db-process] Resetting offset for partition manual_events-3 to offset 0.


14:21:09.635 [scheduling-1] ERROR o.s.s.s.TaskUtils$LoggingErrorHandler - Unexpected error occurred in scheduled task.


org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [UPDATE stop_list_event SET exclusion_initiator = ?, exclusion_date = ? WHERE end_date IS NOT NULL AND end_date < ? AND manual = FALSE]; nested exception is java.sql.SQLSyntaxErrorException: Unknown column 'end_date' in 'where clause'


    at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:234)


    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)


    at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1444)


    at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:632)


    at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:862)


    at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:917)


    at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:927)


    at ru.nspk.sbp.stoplists.repository.StopListEventRepositoryImpl.excludeWithEndDateBefore(StopListEventRepositoryImpl.java:134)


    at ru.nspk.sbp.stoplists.repository.StopListEventRepositoryImpl$$FastClassBySpringCGLIB$$242b9fab.invoke(<generated>)


    at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)


    at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:684)


    at ru.nspk.sbp.stoplists.repository.StopListEventRepositoryImpl$$EnhancerBySpringCGLIB$$ef64e2fa.excludeWithEndDateBefore(<generated>)


    at ru.nspk.sbp.stoplists.service.scheduler.StopListsRemoveSchedulerServiceImpl.removeOldStopListEvents(StopListsRemoveSchedulerServiceImpl.java:21)


    at ru.nspk.sbp.stoplists.service.scheduler.StopListsRemoveSchedulerServiceImpl$$FastClassBySpringCGLIB$$4c74833a.invoke(<generated>)


    at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)


    at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:749)


    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)


    at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:294)


    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98)


    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)


    at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688)


    at ru.nspk.sbp.stoplists.service.scheduler.StopListsRemoveSchedulerServiceImpl$$EnhancerBySpringCGLIB$$b346bf07.removeOldStopListEvents(<generated>)


    at ru.nspk.sbp.stoplists.scheduler.StopListsRemoveSchedulerJob.removeOldStopListEvents(StopListsRemoveSchedulerJob.java:19)


    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)


    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)


    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)


    at java.lang.reflect.Method.invoke(Unknown Source)


    at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:84)


    at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)


    at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)


    at java.util.concurrent.FutureTask.runAndReset(Unknown Source)


    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(Unknown Source)


    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)


    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)


    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)


    at java.lang.Thread.run(Unknown Source)


Caused by: java.sql.SQLSyntaxErrorException: Unknown column 'end_date' in 'where clause'


    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)


    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)


    at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)


    at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:974)


    at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1113)


    at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1061)


    at com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1381)


    at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:1046)


    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)


    ... 32 common frames omitted