nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

database error during parallel REST-API calls

partizano

Hi, Activiti Team!

Maybe my question is not related to Activiti entirely, but the error occurs…

In my process instance I have 14 parallel user tasks, each has form properties variables. When I try to get form properties by REST-API, sometimes the error occurs:

### Error querying database.  Cause: org.h2.jdbc.JdbcSQLException: File corrupted while reading record: "C:\Activiti-58\apps\apache-tomcat-6.0.32\bin\.lobs.db\1.temp.db". Possible solution: use the recovery tool [90030-132]‍‍

Maybe, if I would get form property gradually (at first one property, then second, then third) then the error would not appear… But it is very long…

Can your help me? Or it is just a database error and I can't do anything?

Thanks!

Find more posts tagged with

Comments

trademak

Hi,

Hmm, is this the only exception message you get or are there more details?

Best regards,

partizano

Hi,

Thanks for the reply. More detailed exception is:

SEVERE: Error while closing command context<br>org.apache.ibatis.exceptions.PersistenceException: <br>### Error querying database.&nbsp; Cause: org.h2.jdbc.JdbcSQLException: &#1056;&curren;&#1056;&deg;&#1056;&#8470;&#1056;&raquo; &#1056;&#1111;&#1056;&#1109;&#1056;&#1030;&#1057;&#1026;&#1056;&micro;&#1056;&para;&#1056;&#1169;&#1056;&micro;&#1056;&#1029; &#1056;&#1111;&#1057;&#1026;&#1056;&#1105; &#1057;&Dagger;&#1057;&sbquo;&#1056;&micro;&#1056;&#1029;&#1056;&#1105;&#1056;&#1105; &#1057;&#1027;&#1057;&sbquo;&#1057;&#1026;&#1056;&#1109;&#1056;&#1108;&#1056;&#1105;: "C:\Activiti-58\apps\apache-tomcat-6.0.32\bin\.lobs.db\2.temp.db". &#1056;&rsquo;&#1056;&#1109;&#1056;&middot;&#1056;&#1112;&#1056;&#1109;&#1056;&para;&#1056;&#1029;&#1057;&lsaquo;&#1056;&micro; &#1057;&#1026;&#1056;&micro;&#1057;&euro;&#1056;&micro;&#1056;&#1029;&#1056;&#1105;&#1057;&#1039;: &#1056;&#1105;&#1057;&#1027;&#1056;&#1111;&#1056;&#1109;&#1056;&raquo;&#1057;&#1034;&#1056;&middot;&#1057;&#1107;&#1056;&#8470;&#1057;&sbquo;&#1056;&micro; &#1057;&#1107;&#1057;&sbquo;&#1056;&#1105;&#1056;&raquo;&#1056;&#1105;&#1057;&sbquo;&#1057;&#1107; &#1056;&#1030;&#1056;&#1109;&#1057;&#1027;&#1057;&#1027;&#1057;&sbquo;&#1056;&deg;&#1056;&#1029;&#1056;&#1109;&#1056;&#1030;&#1056;&raquo;&#1056;&micro;&#1056;&#1029;&#1056;&#1105;&#1057;&#1039; (recovery tool)<br>File corrupted while reading record: "C:\Activiti-58\apps\apache-tomcat-6.0.32\bin\.lobs.db\2.temp.db". Possible solution: use the recovery tool [90030-132]<br>### The error may involve org.activiti.engine.impl.persistence.entity.VariableInstanceEntity.selectVariablesByExecutionId-Inline<br>### The error occurred while setting parameters<br>### Cause: org.h2.jdbc.JdbcSQLException: &#1056;&curren;&#1056;&deg;&#1056;&#8470;&#1056;&raquo; &#1056;&#1111;&#1056;&#1109;&#1056;&#1030;&#1057;&#1026;&#1056;&micro;&#1056;&para;&#1056;&#1169;&#1056;&micro;&#1056;&#1029; &#1056;&#1111;&#1057;&#1026;&#1056;&#1105; &#1057;&Dagger;&#1057;&sbquo;&#1056;&micro;&#1056;&#1029;&#1056;&#1105;&#1056;&#1105; &#1057;&#1027;&#1057;&sbquo;&#1057;&#1026;&#1056;&#1109;&#1056;&#1108;&#1056;&#1105;: "C:\Activiti-58\apps\apache-tomcat-6.0.32\bin\.lobs.db\2.temp.db". &#1056;&rsquo;&#1056;&#1109;&#1056;&middot;&#1056;&#1112;&#1056;&#1109;&#1056;&para;&#1056;&#1029;&#1057;&lsaquo;&#1056;&micro; &#1057;&#1026;&#1056;&micro;&#1057;&euro;&#1056;&micro;&#1056;&#1029;&#1056;&#1105;&#1057;&#1039;: &#1056;&#1105;&#1057;&#1027;&#1056;&#1111;&#1056;&#1109;&#1056;&raquo;&#1057;&#1034;&#1056;&middot;&#1057;&#1107;&#1056;&#8470;&#1057;&sbquo;&#1056;&micro; &#1057;&#1107;&#1057;&sbquo;&#1056;&#1105;&#1056;&raquo;&#1056;&#1105;&#1057;&sbquo;&#1057;&#1107; &#1056;&#1030;&#1056;&#1109;&#1057;&#1027;&#1057;&#1027;&#1057;&sbquo;&#1056;&deg;&#1056;&#1029;&#1056;&#1109;&#1056;&#1030;&#1056;&raquo;&#1056;&micro;&#1056;&#1029;&#1056;&#1105;&#1057;&#1039; (recovery tool)<br>File corrupted while reading record: "C:\Activiti-58\apps\apache-tomcat-6.0.32\bin\.lobs.db\2.temp.db". Possible solution: use the recovery tool [90030-132]<br> at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:8)<br> at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:77)<br> at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:69)<br> at org.activiti.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:182)<br> at org.activiti.engine.impl.persistence.entity.VariableInstanceManager.findVariableInstancesByExecutionId(VariableInstanceManager.java:47)<br> at org.activiti.engine.impl.persistence.entity.ExecutionEntity.loadVariableInstances(ExecutionEntity.java:909)<br> at org.activiti.engine.impl.persistence.entity.VariableScopeImpl.ensureVariableInstancesInitialized(VariableScopeImpl.java:57)<br> at org.activiti.engine.impl.persistence.entity.VariableScopeImpl.getVariable(VariableScopeImpl.java:90)<br> at org.activiti.engine.impl.persistence.entity.VariableScopeImpl.getVariable(VariableScopeImpl.java:97)<br> at org.activiti.engine.impl.form.FormPropertyHandler.createFormProperty(FormPropertyHandler.java:48)<br> at org.activiti.engine.impl.form.DefaultFormHandler.initializeFormProperties(DefaultFormHandler.java:114)<br> at org.activiti.engine.impl.form.DefaultTaskFormHandler.createTaskForm(DefaultTaskFormHandler.java:31)<br> at org.activiti.engine.impl.cmd.GetTaskFormCmd.execute(GetTaskFormCmd.java:54)<br> at org.activiti.engine.impl.cmd.GetTaskFormCmd.execute(GetTaskFormCmd.java:30)<br> at org.activiti.engine.impl.interceptor.CommandExecutorImpl.execute(CommandExecutorImpl.java:24)<br> at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:42)<br> at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33)<br> at org.activiti.engine.impl.FormServiceImpl.getTaskFormData(FormServiceImpl.java:56)<br> at org.activiti.rest.api.task.TaskPropertiesResource.getTaskProperties(TaskPropertiesResource.java:35)<br> at sun.reflect.GeneratedMethodAccessor265.invoke(Unknown Source)<br> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<br> at java.lang.reflect.Method.invoke(Method.java:597)<br> at org.restlet.resource.ServerResource.doHandle(ServerResource.java:449)<br> at org.restlet.resource.ServerResource.get(ServerResource.java:645)<br> at org.restlet.resource.ServerResource.doHandle(ServerResource.java:527)<br> at org.restlet.resource.ServerResource.doNegotiatedHandle(ServerResource.java:587)<br> at org.restlet.resource.ServerResource.doConditionalHandle(ServerResource.java:299)<br> at org.restlet.resource.ServerResource.handle(ServerResource.java:846)<br> at org.restlet.resource.Finder.handle(Finder.java:510)<br> at org.restlet.routing.Filter.doHandle(Filter.java:156)<br> at org.restlet.routing.Filter.handle(Filter.java:203)<br> at org.restlet.routing.Router.doHandle(Router.java:497)<br> at org.restlet.routing.Router.handle(Router.java:737)<br> at org.restlet.routing.Filter.doHandle(Filter.java:156)<br> at org.restlet.routing.Filter.handle(Filter.java:203)<br> at org.restlet.routing.Filter.doHandle(Filter.java:156)<br> at org.restlet.routing.Filter.handle(Filter.java:203)<br> at org.restlet.routing.Filter.doHandle(Filter.java:156)<br> at org.restlet.routing.Filter.handle(Filter.java:203)<br> at org.restlet.routing.Filter.doHandle(Filter.java:156)<br> at org.restlet.engine.application.StatusFilter.doHandle(StatusFilter.java:151)<br> at org.restlet.routing.Filter.handle(Filter.java:203)<br> at org.restlet.routing.Filter.doHandle(Filter.java:156)<br> at org.restlet.routing.Filter.handle(Filter.java:203)<br> at org.restlet.engine.ChainHelper.handle(ChainHelper.java:111)<br> at org.restlet.engine.application.ApplicationHelper.handle(ApplicationHelper.java:72)<br> at org.restlet.Application.handle(Application.java:388)<br> at org.restlet.routing.Filter.doHandle(Filter.java:156)<br> at org.restlet.routing.Filter.handle(Filter.java:203)<br> at org.restlet.routing.Router.doHandle(Router.java:497)<br> at org.restlet.routing.Router.handle(Router.java:737)<br> at org.restlet.routing.Filter.doHandle(Filter.java:156)<br> at org.restlet.routing.Filter.handle(Filter.java:203)<br> at org.restlet.routing.Router.doHandle(Router.java:497)<br> at org.restlet.routing.Router.handle(Router.java:737)<br> at org.restlet.routing.Filter.doHandle(Filter.java:156)<br> at org.restlet.routing.Filter.handle(Filter.java:203)<br> at org.restlet.engine.ChainHelper.handle(ChainHelper.java:111)<br> at org.restlet.Component.handle(Component.java:387)<br> at org.restlet.Server.handle(Server.java:488)<br> at org.restlet.engine.ServerHelper.handle(ServerHelper.java:71)<br> at org.restlet.engine.http.HttpServerHelper.handle(HttpServerHelper.java:150)<br> at org.restlet.ext.servlet.ServerServlet.service(ServerServlet.java:1037)<br> at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)<br> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)<br> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<br> at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)<br> at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)<br> at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)<br> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)<br> at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)<br> at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)<br> at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)<br> at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)<br> at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)<br> at java.lang.Thread.run(Thread.java:662)<br>Caused by: org.h2.jdbc.JdbcSQLException: &#1056;&curren;&#1056;&deg;&#1056;&#8470;&#1056;&raquo; &#1056;&#1111;&#1056;&#1109;&#1056;&#1030;&#1057;&#1026;&#1056;&micro;&#1056;&para;&#1056;&#1169;&#1056;&micro;&#1056;&#1029; &#1056;&#1111;&#1057;&#1026;&#1056;&#1105; &#1057;&Dagger;&#1057;&sbquo;&#1056;&micro;&#1056;&#1029;&#1056;&#1105;&#1056;&#1105; &#1057;&#1027;&#1057;&sbquo;&#1057;&#1026;&#1056;&#1109;&#1056;&#1108;&#1056;&#1105;: "C:\Activiti-58\apps\apache-tomcat-6.0.32\bin\.lobs.db\2.temp.db". &#1056;&rsquo;&#1056;&#1109;&#1056;&middot;&#1056;&#1112;&#1056;&#1109;&#1056;&para;&#1056;&#1029;&#1057;&lsaquo;&#1056;&micro; &#1057;&#1026;&#1056;&micro;&#1057;&euro;&#1056;&micro;&#1056;&#1029;&#1056;&#1105;&#1057;&#1039;: &#1056;&#1105;&#1057;&#1027;&#1056;&#1111;&#1056;&#1109;&#1056;&raquo;&#1057;&#1034;&#1056;&middot;&#1057;&#1107;&#1056;&#8470;&#1057;&sbquo;&#1056;&micro; &#1057;&#1107;&#1057;&sbquo;&#1056;&#1105;&#1056;&raquo;&#1056;&#1105;&#1057;&sbquo;&#1057;&#1107; &#1056;&#1030;&#1056;&#1109;&#1057;&#1027;&#1057;&#1027;&#1057;&sbquo;&#1056;&deg;&#1056;&#1029;&#1056;&#1109;&#1056;&#1030;&#1056;&raquo;&#1056;&micro;&#1056;&#1029;&#1056;&#1105;&#1057;&#1039; (recovery tool)<br>File corrupted while reading record: "C:\Activiti-58\apps\apache-tomcat-6.0.32\bin\.lobs.db\2.temp.db". Possible solution: use the recovery tool [90030-132]<br> at org.h2.message.DbException.getJdbcSQLException(DbException.java:316)<br> at org.h2.message.DbException.get(DbException.java:167)<br> at org.h2.message.DbException.get(DbException.java:144)<br> at org.h2.engine.SessionRemote.openFile(SessionRemote.java:568)<br> at org.h2.value.ValueLob.getInputStream(ValueLob.java:613)<br> at org.h2.value.ValueLob.getReader(ValueLob.java:606)<br> at org.h2.value.ValueLob.getString(ValueLob.java:536)<br> at org.h2.jdbc.JdbcResultSet.getString(JdbcResultSet.java:283)<br> at org.apache.ibatis.type.StringTypeHandler.getNullableResult(StringTypeHandler.java:17)<br> at org.apache.ibatis.type.BaseTypeHandler.getResult(BaseTypeHandler.java:29)<br> at org.apache.ibatis.executor.resultset.FastResultSetHandler.getPropertyMappingValue(FastResultSetHandler.java:238)<br> at org.apache.ibatis.executor.resultset.FastResultSetHandler.applyPropertyMappings(FastResultSetHandler.java:221)<br> at org.apache.ibatis.executor.resultset.FastResultSetHandler.getRowValue(FastResultSetHandler.java:196)<br> at org.apache.ibatis.executor.resultset.FastResultSetHandler.handleRowValues(FastResultSetHandler.java:145)<br> at org.apache.ibatis.executor.resultset.FastResultSetHandler.handleResultSet(FastResultSetHandler.java:121)<br> at org.apache.ibatis.executor.resultset.FastResultSetHandler.handleResultSets(FastResultSetHandler.java:98)<br> at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:40)<br> at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:55)<br> at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:41)<br> at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:216)<br> at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:95)<br> at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:72)<br> at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:75)

trademak

Hi,

Is there some kind of unit test that you could build for this?
Or is it fully random?

Best regards,

partizano

Hi,

It is random. In my application I use workaround for this error - I repeat the request, if the request returned error. Of course, it is not very good solution, but I didn't find another way.