Hi All,
I’m testing a simple web application using HSQLDB and the latest version of Cuba Platform (7.0.6) with “reports” and “charts” components added to the project. All worked fine until I tried to create a CUBA Scheduled Tasks. When I switched from false to true the “cuba.schedulingActive” property at the restart I got in catalina.out “…INFO c.h.c.c.a.s.DbBasedCoordinator - Unable to acquire lock on tasks”.
After login when I tried to enter in Admnistraton --> ScheduledTask I received an exception and I never manage to have my Task scheduled.
I tried serveral time to recreate the DB from scratch (CUBA —> create DB) but nothing seems to work…
_ERROR c.h.cuba.core.sys.ServiceInterceptor - Exception: _
_javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.3.2-cuba): org.eclipse.persistence.exceptions.DatabaseException_
_Internal Exception: java.sql.SQLSyntaxErrorException: unexpected token: AS required: ( in statement [SELECT LIMIT ? ? ID AS a1, IS_ACTIVE AS a2, BEAN_NAME AS a3, CLASS_NAME AS a4, CREATE_TS AS a5, CREATED_BY AS a6, CRON AS a7, DEFINED_BY AS a8, DELETE_TS AS a9, DELETED_BY AS a10, DESCRIPTION AS a11, LAST_START_SERVER AS a12, LAST_START_TIME AS a13, LOG_FINISH AS a14, LOG_START AS a15, METHOD_NAME AS a16, METHOD_PARAMS AS a17, PERIOD AS a18, PERMITTED_SERVERS AS a19, SCHEDULING_TYPE AS a20, SCRIPT_NAME AS a21, IS_SINGLETON AS a22, START_DATE AS a23, START_DELAY AS a24, TIME_FRAME AS a25, TIMEOUT AS a26, UPDATE_TS AS a27, UPDATED_BY AS a28, USER_NAME AS a29 FROM SYS_SCHEDULED_TASK WHERE (DELETE_TS IS NULL)]_
_Error Code: -5581_
_Call: SELECT LIMIT ? ? ID AS a1, IS_ACTIVE AS a2, BEAN_NAME AS a3, CLASS_NAME AS a4, CREATE_TS AS a5, CREATED_BY AS a6, CRON AS a7, DEFINED_BY AS a8, DELETE_TS AS a9, DELETED_BY AS a10, DESCRIPTION AS a11, LAST_START_SERVER AS a12, LAST_START_TIME AS a13, LOG_FINISH AS a14, LOG_START AS a15, METHOD_NAME AS a16, METHOD_PARAMS AS a17, PERIOD AS a18, PERMITTED_SERVERS AS a19, SCHEDULING_TYPE AS a20, SCRIPT_NAME AS a21, IS_SINGLETON AS a22, START_DATE AS a23, START_DELAY AS a24, TIME_FRAME AS a25, TIMEOUT AS a26, UPDATE_TS AS a27, UPDATED_BY AS a28, USER_NAME AS a29 FROM SYS_SCHEDULED_TASK WHERE (DELETE_TS IS NULL)_
_ bind => [0, 50]_
_Query: ReadAllQuery(referenceClass=ScheduledTask sql="SELECT LIMIT ? ? ID AS a1, IS_ACTIVE AS a2, BEAN_NAME AS a3, CLASS_NAME AS a4, CREATE_TS AS a5, CREATED_BY AS a6, CRON AS a7, DEFINED_BY AS a8, DELETE_TS AS a9, DELETED_BY AS a10, DESCRIPTION AS a11, LAST_START_SERVER AS a12, LAST_START_TIME AS a13, LOG_FINISH AS a14, LOG_START AS a15, METHOD_NAME AS a16, METHOD_PARAMS AS a17, PERIOD AS a18, PERMITTED_SERVERS AS a19, SCHEDULING_TYPE AS a20, SCRIPT_NAME AS a21, IS_SINGLETON AS a22, START_DATE AS a23, START_DELAY AS a24, TIME_FRAME AS a25, TIMEOUT AS a26, UPDATE_TS AS a27, UPDATED_BY AS a28, USER_NAME AS a29 FROM SYS_SCHEDULED_TASK WHERE (DELETE_TS IS NULL)")_
_FetchGroup(){description, className, deletedBy, timeout, deleteTs, methodParamsXml, beanName, createTs, id, lastStartServer, cron, singleton, period, logStart, updatedBy, logFinish, active, methodName, userName, timeFrame, schedulingType, createdBy, definedBy, lastStartTime, scriptName, startDelay, updateTs, permittedServers, startDate}_
_ at org.eclipse.persistence.internal.jpa.QueryImpl.getDetailedException(QueryImpl.java:391) ~[org.eclipse.persistence.jpa-2.7.3-2-cuba.jar:na]_
_ at org.eclipse.persistence.internal.jpa.QueryImpl.executeReadQuery(QueryImpl.java:264) ~[org.eclipse.persistence.jpa-2.7.3-2-cuba.jar:na]_
_ at org.eclipse.persistence.internal.jpa.QueryImpl.getResultList(QueryImpl.java:482) ~[org.eclipse.persistence.jpa-2.7.3-2-cuba.jar:na]_
_ at com.haulmont.cuba.core.sys.QueryImpl.getResultFromCache(QueryImpl.java:715) ~[cuba-core-7.0.6.jar:7.0.6]_
_ at com.haulmont.cuba.core.sys.QueryImpl.getResultList(QueryImpl.java:372) ~[cuba-core-7.0.6.jar:7.0.6]_
_ at com.haulmont.cuba.core.app.RdbmsStore.executeQuery(RdbmsStore.java:756) ~[cuba-core-7.0.6.jar:7.0.6]_
_ at com.haulmont.cuba.core.app.RdbmsStore.getResultList(RdbmsStore.java:664) ~[cuba-core-7.0.6.jar:7.0.6]_
_ at com.haulmont.cuba.core.app.RdbmsStore.loadList(RdbmsStore.java:225) ~[cuba-core-7.0.6.jar:7.0.6]_
_ at com.haulmont.cuba.core.app.DataManagerBean.loadList(DataManagerBean.java:74) ~[cuba-core-7.0.6.jar:7.0.6]_
_ at com.haulmont.cuba.core.app.DataServiceBean.loadList(DataServiceBean.java:54) ~[cuba-core-7.0.6.jar:7.0.6]_
_ at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_211]_
_ at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_211]_
_ at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_211]_
_ at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_211]_
_ at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343) ~[spring-aop-5.1.6.RELEASE.jar:5.1.6.RELEASE]_
_ at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198) [spring-aop-5.1.6.RELEASE.jar:5.1.6.RELEASE]_
_ at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) [spring-aop-5.1.6.RELEASE.jar:5.1.6.RELEASE]_
_ at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:88) ~[spring-aop-5.1.6.RELEASE.jar:5.1.6.RELEASE]_
_ at com.haulmont.cuba.core.sys.ServiceInterceptor.aroundInvoke(ServiceInterceptor.java:117) ~[cuba-core-7.0.6.jar:7.0.6]_
_ at sun.reflect.GeneratedMethodAccessor152.invoke(Unknown Source) ~[na:na]_
_ at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_211]_
_ at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_211]_
_ at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:644) [spring-aop-5.1.6.RELEASE.jar:5.1.6.RELEASE]_
_ at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:633) [spring-aop-5.1.6.RELEASE.jar:5.1.6.RELEASE]_
_ at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70) [spring-aop-5.1.6.RELEASE.jar:5.1.6.RELEASE]_
_ at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:175) [spring-aop-5.1.6.RELEASE.jar:5.1.6.RELEASE]_
_ at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:93) [spring-aop-5.1.6.RELEASE.jar:5.1.6.RELEASE]_
_ at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) [spring-aop-5.1.6.RELEASE.jar:5.1.6.RELEASE]_
_ at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212) [spring-aop-5.1.6.RELEASE.jar:5.1.6.RELEASE]_
_ at com.sun.proxy.$Proxy229.loadList(Unknown Source) [na:na]_
_ at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_211]_
_ at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_211]_
_ at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_211]_
_ at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_211]_
_ at com.haulmont.cuba.core.sys.remoting.LocalServiceInvokerImpl.invoke(LocalServiceInvokerImpl.java:94) [cuba-core-7.0.6.jar:7.0.6]_
_ at com.haulmont.cuba.web.sys.remoting.LocalServiceProxy$LocalServiceInvocationHandler.invoke(LocalServiceProxy.java:154) [cuba-web-7.0.6.jar:7.0.6]_
_ at com.sun.proxy.$Proxy35.loadList(Unknown Source) [na:na]_
_ at com.haulmont.cuba.client.sys.DataManagerClientImpl.loadList(DataManagerClientImpl.java:57) [cuba-client-7.0.6.jar:7.0.6]_
_ at com.haulmont.cuba.gui.data.impl.GenericDataSupplier.loadList(GenericDataSupplier.java:117) [cuba-gui-7.0.6.jar:7.0.6]_
_ at com.haulmont.cuba.gui.data.impl.CollectionDatasourceImpl.loadData(CollectionDatasourceImpl.java:614) [cuba-gui-7.0.6.jar:7.0.6]_
_ at com.haulmont.cuba.gui.data.impl.CollectionDatasourceImpl.refresh(CollectionDatasourceImpl.java:161) [cuba-gui-7.0.6.jar:7.0.6]_
_ at com.haulmont.cuba.gui.data.impl.CollectionDatasourceImpl.refreshIfNotSuspended(CollectionDatasourceImpl.java:112) [cuba-gui-7.0.6.jar:7.0.6]_
_ at com.haulmont.cuba.gui.components.filter.FilterDelegateImpl$DatasourceAdapter.refreshIfNotSuspended(FilterDelegateImpl.java:3259) [cuba-gui-7.0.6.jar:7.0.6]_
_ at com.haulmont.cuba.gui.components.filter.FilterDelegateImpl.refreshDatasource(FilterDelegateImpl.java:1747) [cuba-gui-7.0.6.jar:7.0.6]_
_ at com.haulmont.cuba.gui.components.filter.FilterDelegateImpl.apply(FilterDelegateImpl.java:1587) [cuba-gui-7.0.6.jar:7.0.6]_
_ at com.haulmont.cuba.web.gui.components.WebFilter.apply(WebFilter.java:88) [cuba-web-7.0.6.jar:7.0.6]_
_ at com.haulmont.cuba.web.gui.components.WebFilter.apply(WebFilter.java:93) [cuba-web-7.0.6.jar:7.0.6]_
_ at com.haulmont.cuba.gui.app.core.entityinspector.EntityInspectorBrowse.createFilter(EntityInspectorBrowse.java:315) [cuba-gui-7.0.6.jar:7.0.6]_
_ at com.haulmont.cuba.gui.app.core.entityinspector.EntityInspectorBrowse.createEntitiesTable(EntityInspectorBrowse.java:299) [cuba-gui-7.0.6.jar:7.0.6]_
_ at com.haulmont.cuba.gui.app.core.entityinspector.EntityInspectorBrowse.showEntities(EntityInspectorBrowse.java:188) [cuba-gui-7.0.6.jar:7.0.6]_
_ at com.haulmont.cuba.gui.app.core.entityinspector.EntityInspectorBrowse.lambda$init$0(EntityInspectorBrowse.java:153) [cuba-gui-7.0.6.jar:7.0.6]_
_ at com.haulmont.bali.events.EventHub.publish(EventHub.java:170) ~[cuba-global-7.0.6.jar:7.0.6]_
_ at com.haulmont.cuba.web.gui.components.WebAbstractComponent.publish(WebAbstractComponent.java:88) ~[cuba-web-7.0.6.jar:7.0.6]_
_ at com.haulmont.cuba.web.gui.components.WebAbstractValueComponent.componentValueChanged(WebAbstractValueComponent.java:152) ~[cuba-web-7.0.6.jar:7.0.6]_
_ at com.haulmont.cuba.web.gui.components.WebV8AbstractField.lambda$attachValueChangeListener$ab1c93c8$1(WebV8AbstractField.java:143) ~[cuba-web-7.0.6.jar:7.0.6]_
_ at com.vaadin.ui.ComboBox.lambda$addValueChangeListener$bddd7469$1(ComboBox.java:807) ~[vaadin-server-8.6.4-11-cuba.jar:8.6.4-11-cuba]_
_ at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_211]_
_ at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_211]_
_ at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_211]_
_ at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_211]_
_ at com.vaadin.event.ListenerMethod.receiveEvent(ListenerMethod.java:496) ~[vaadin-server-8.6.4-11-cuba.jar:8.6.4-11-cuba]_
_ at com.vaadin.event.EventRouter.fireEvent(EventRouter.java:273) ~[vaadin-server-8.6.4-11-cuba.jar:8.6.4-11-cuba]_
_ at com.vaadin.event.EventRouter.fireEvent(EventRouter.java:237) ~[vaadin-server-8.6.4-11-cuba.jar:8.6.4-11-cuba]_
_ at com.vaadin.server.AbstractClientConnector.fireEvent(AbstractClientConnector.java:1041) ~[vaadin-server-8.6.4-11-cuba.jar:8.6.4-11-cuba]_
_ at com.vaadin.ui.AbstractSingleSelect.setSelectedItem(AbstractSingleSelect.java:358) ~[vaadin-server-8.6.4-11-cuba.jar:8.6.4-11-cuba]_
_ at com.vaadin.ui.AbstractSingleSelect$1.select(AbstractSingleSelect.java:291) ~[vaadin-server-8.6.4-11-cuba.jar:8.6.4-11-cuba]_
_ at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_211]_
_ at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_211]_
_ at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_211]_
_ at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_211]_
_ at com.vaadin.server.ServerRpcManager.applyInvocation(ServerRpcManager.java:153) ~[vaadin-server-8.6.4-11-cuba.jar:8.6.4-11-cuba]_
_ at com.vaadin.server.ServerRpcManager.applyInvocation(ServerRpcManager.java:115) ~[vaadin-server-8.6.4-11-cuba.jar:8.6.4-11-cuba]_
_ at com.vaadin.server.communication.ServerRpcHandler.handleInvocation(ServerRpcHandler.java:431) ~[vaadin-server-8.6.4-11-cuba.jar:8.6.4-11-cuba]_
_ at com.vaadin.server.communication.ServerRpcHandler.handleInvocations(ServerRpcHandler.java:396) ~[vaadin-server-8.6.4-11-cuba.jar:8.6.4-11-cuba]_
_ at com.vaadin.server.communication.ServerRpcHandler.handleRpc(ServerRpcHandler.java:260) ~[vaadin-server-8.6.4-11-cuba.jar:8.6.4-11-cuba]_
_ at com.vaadin.server.communication.UidlRequestHandler.synchronizedHandleRequest(UidlRequestHandler.java:82) ~[vaadin-server-8.6.4-11-cuba.jar:8.6.4-11-cuba]_
_ at com.vaadin.server.SynchronizedRequestHandler.handleRequest(SynchronizedRequestHandler.java:40) ~[vaadin-server-8.6.4-11-cuba.jar:8.6.4-11-cuba]_
_ at com.vaadin.server.VaadinService.handleRequest(VaadinService.java:1577) ~[vaadin-server-8.6.4-11-cuba.jar:8.6.4-11-cuba]_
_ at com.vaadin.server.VaadinServlet.service(VaadinServlet.java:425) ~[vaadin-server-8.6.4-11-cuba.jar:8.6.4-11-cuba]_
_ at com.haulmont.cuba.web.sys.CubaApplicationServlet.serviceAppRequest(CubaApplicationServlet.java:329) ~[cuba-web-7.0.6.jar:7.0.6]_
_ at com.haulmont.cuba.web.sys.CubaApplicationServlet.service(CubaApplicationServlet.java:215) ~[cuba-web-7.0.6.jar:7.0.6]_
_ at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) ~[servlet-api.jar:na]_
_ at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) ~[catalina.jar:9.0.14]_
_ at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[catalina.jar:9.0.14]_
_ at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) ~[tomcat-websocket.jar:9.0.14]_
_ at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[catalina.jar:9.0.14]_
_ at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[catalina.jar:9.0.14]_
_ at org.springframework.web.filter.CompositeFilter$VirtualFilterChain.doFilter(CompositeFilter.java:107) ~[spring-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]_
_ at org.springframework.web.filter.CompositeFilter.doFilter(CompositeFilter.java:73) ~[spring-web-5.1.6.RELEASE.jar:5.1.6.RELEASE]_
_ at com.haulmont.cuba.web.sys.CubaHttpFilter.doFilter(CubaHttpFilter.java:108) ~[cuba-web-7.0.6.jar:7.0.6]_
_ at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[catalina.jar:9.0.14]_
_ at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[catalina.jar:9.0.14]_
_ at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) ~[catalina.jar:9.0.14]_
_ at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) ~[catalina.jar:9.0.14]_
_ at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490) ~[catalina.jar:9.0.14]_
_ at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) ~[catalina.jar:9.0.14]_
_ at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) ~[catalina.jar:9.0.14]_
_ at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:668) ~[catalina.jar:9.0.14]_
_ at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) ~[catalina.jar:9.0.14]_
_ at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) ~[catalina.jar:9.0.14]_
_ at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408) ~[tomcat-coyote.jar:9.0.14]_
_ at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) ~[tomcat-coyote.jar:9.0.14]_
_ at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:834) ~[tomcat-coyote.jar:9.0.14]_
_ at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1417) ~[tomcat-coyote.jar:9.0.14]_
_ at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) ~[tomcat-coyote.jar:9.0.14]_
_ at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[na:1.8.0_211]_
_ at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[na:1.8.0_211]_
_ at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) ~[tomcat-util.jar:9.0.14]_
_ at java.lang.Thread.run(Thread.java:748) ~[na:1.8.0_211]_
_Caused by: org.eclipse.persistence.exceptions.DatabaseException: _
_Internal Exception: java.sql.SQLSyntaxErrorException: unexpected token: AS required: ( in statement [SELECT LIMIT ? ? ID AS a1, IS_ACTIVE AS a2, BEAN_NAME AS a3, CLASS_NAME AS a4, CREATE_TS AS a5, CREATED_BY AS a6, CRON AS a7, DEFINED_BY AS a8, DELETE_TS AS a9, DELETED_BY AS a10, DESCRIPTION AS a11, LAST_START_SERVER AS a12, LAST_START_TIME AS a13, LOG_FINISH AS a14, LOG_START AS a15, METHOD_NAME AS a16, METHOD_PARAMS AS a17, PERIOD AS a18, PERMITTED_SERVERS AS a19, SCHEDULING_TYPE AS a20, SCRIPT_NAME AS a21, IS_SINGLETON AS a22, START_DATE AS a23, START_DELAY AS a24, TIME_FRAME AS a25, TIMEOUT AS a26, UPDATE_TS AS a27, UPDATED_BY AS a28, USER_NAME AS a29 FROM SYS_SCHEDULED_TASK WHERE (DELETE_TS IS NULL)]_
_Error Code: -5581_