Hi all,
My application is stalling when using MVCC. I'm using the 1.3.173 version
embedded in another application.
I was able to reproduce the exact same behaviour with 1.3.164 but analysing
the thread dump using that version it seemed to me that it was a deadlock.
With the most recent version, it doesn't look like it. You can find a
thread dump at the end of the post.
I'm just trying to understand if this might be a bug or not in order to
open up a bug.
The statement is being submitted with autocommit turned off.
*The table in question has the following schema:*
CREATE TABLE "ABC_APP_FIELD" ("CREATEDAT" BIGINT, "CREATEDBY" INTEGER,
"UPDATEDAT" BIGINT, "UPDATEDBY" INTEGER, "APP_ID" INTEGER NOT NULL,
"SFL_ID" INTEGER AUTO_INCREMENT NOT NULL, "SFL_TYPE" VARCHAR(256), "SCH_ID"
INTEGER, "SFL_NAME" VARCHAR(256) NOT NULL, "SFL_DESC" VARCHAR(256),
"SFL_IS_DIMENSION" BOOLEAN, "SFL_IS_TIMESTAMP" BOOLEAN, "FLD_ORDER" INTEGER
NOT NULL, "FLD_PARENT" INTEGER, "FLD_NULLABLE" BOOLEAN DEFAULT TRUE,
"FLD_STORE" BOOLEAN DEFAULT TRUE, "DIM_ID" INTEGER)
*The query being blocked is the following:*
UPDATE "ABC_APP_FIELD" SET "DIM_ID" = 34 WHERE ("SFL_ID") IN (216, 323,
329) AND "APP_ID" = 3 AND "SFL_IS_DIMENSION" = TRUE
Anyone might know what can be wrong with this?
Thanks in advance,
Best regards,
Rui
--
*The thread dump:*
"jetty-246" prio=10 tid=0x00007fb274198800 nid=0x6836 runnable
[0x00007fb1f9ad5000]
java.lang.Thread.State: RUNNABLE
at org.h2.index.TreeCursor.next(TreeCursor.java:82)
at org.h2.index.TreeCursor.next(TreeCursor.java:50)
at org.h2.index.MultiVersionIndex.removeIfExists(MultiVersionIndex.java:165)
at org.h2.index.MultiVersionIndex.add(MultiVersionIndex.java:53)
- locked <0x00000000e2dc40d0> (a org.h2.engine.Database)
at org.h2.table.RegularTable.addRow(RegularTable.java:125)
at org.h2.command.dml.Insert.insertRows(Insert.java:127)
at org.h2.command.dml.Insert.update(Insert.java:86)
at org.h2.command.CommandContainer.update(CommandContainer.java:79)
at org.h2.command.Command.executeUpdate(Command.java:235)
- locked <0x00000000e2dc40d0> (a org.h2.engine.Database)
at
org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:154)
- locked <0x00000000e69e53c0> (a org.h2.engine.Session)
at
org.h2.jdbc.JdbcPreparedStatement.executeBatch(JdbcPreparedStatement.java:1152)
at
com.abc.commons.sql.abstraction.engine.DatabaseEngineImpl.flush(DatabaseEngineImpl.java:596)
- locked <0x00000000e635f740> (a
com.abc.commons.sql.abstraction.engine.impl.H2Engine)
at
com.abc.def.service.apps.manager.AppDimensionManagerImpl$AddMappingsAction.apply(AppDimensionManagerImpl.java:377)
at
com.abc.def.service.apps.manager.AppDimensionManagerImpl$1.access(AppDimensionManagerImpl.java:94)
at
com.abc.def.service.apps.manager.AppDimensionManagerImpl$1.access(AppDimensionManagerImpl.java:71)
at com.abc.def.web.api.commons.db.AbstractDbFun.call(AbstractDbFun.java:27)
at
com.abc.def.service.apps.manager.AppDimensionManagerImpl.doCreate(AppDimensionManagerImpl.java:71)
at
com.abc.def.service.apps.manager.AppDimensionManagerImpl$$EnhancerByGuice$$df4a5902.CGLIB$doCreate$1(<generated>)
at
com.abc.def.service.apps.manager.AppDimensionManagerImpl$$EnhancerByGuice$$df4a5902$$FastClassByGuice$$2f361d07.invoke(<generated>)
at
com.google.inject.internal.cglib.proxy.$MethodProxy.invokeSuper(MethodProxy.java:228)
at
com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72)
at
com.abc.def.service.security.guice.EnforcePermissionsInterceptor.invoke(EnforcePermissionsInterceptor.java:53)
at
com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72)
at
com.google.inject.internal.InterceptorStackCallback.intercept(InterceptorStackCallback.java:52)
at
com.abc.def.service.apps.manager.AppDimensionManagerImpl$$EnhancerByGuice$$df4a5902.doCreate(<generated>)
at
com.abc.def.service.apps.manager.AppDimensionManagerImpl.doCreate(AppDimensionManagerImpl.java:62)
at
com.abc.def.service.apps.manager.CachingModelManager.create(CachingModelManager.java:90)
at
com.abc.def.service.apps.manager.OwnableModelManager.create(OwnableModelManager.java:59)
at
com.abc.def.service.apps.manager.OwnableModelManager.create(OwnableModelManager.java:49)
at
com.abc.def.service.apps.manager.AppAdminImpl$7.access(AppAdminImpl.java:1571)
at
com.abc.def.service.apps.manager.AppAdminImpl$7.access(AppAdminImpl.java:1532)
at com.abc.def.web.api.commons.db.AbstractDbFun.call(AbstractDbFun.java:27)
at
com.abc.def.service.apps.manager.AppAdminImpl.importAppModel(AppAdminImpl.java:1532)
at
com.abc.def.service.apps.manager.AppAdminImpl$6.access(AppAdminImpl.java:1502)
at
com.abc.def.service.apps.manager.AppAdminImpl$6.access(AppAdminImpl.java:1491)
at com.abc.def.web.api.commons.db.AbstractDbFun.call(AbstractDbFun.java:27)
at
com.abc.def.service.apps.manager.AppAdminImpl.importApp(AppAdminImpl.java:1491)
at
com.abc.def.web.api.resources.app.AppResource.importApp(AppResource.java:157)
at
com.abc.def.web.api.resources.app.AppResource$$EnhancerByGuice$$77d4240d.CGLIB$importApp$1(<generated>)
at
com.abc.def.web.api.resources.app.AppResource$$EnhancerByGuice$$77d4240d$$FastClassByGuice$$cbccfe49.invoke(<generated>)
at
com.google.inject.internal.cglib.proxy.$MethodProxy.invokeSuper(MethodProxy.java:228)
at
com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72)
at
com.abc.def.web.api.commons.exceptions.TracingInterceptor.invoke(TracingInterceptor.java:52)
at
com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72)
at
com.google.inject.internal.InterceptorStackCallback.intercept(InterceptorStackCallback.java:52)
at
com.abc.def.web.api.resources.app.AppResource$$EnhancerByGuice$$77d4240d.importApp(<generated>)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at
com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60)
at
com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$TypeOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:185)
at
com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75)
at
com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302)
at
com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
at
com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108)
at
com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
at
com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84)
at
com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1511)
at
com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1442)
at
com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1391)
at
com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1381)
at
com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:416)
at
com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:538)
at
com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:716)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:848)
at
com.google.inject.servlet.ServletDefinition.doService(ServletDefinition.java:263)
at
com.google.inject.servlet.ServletDefinition.service(ServletDefinition.java:178)
at
com.google.inject.servlet.ManagedServletPipeline.service(ManagedServletPipeline.java:91)
at
com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:62)
at
com.google.inject.servlet.ManagedFilterPipeline.dispatch(ManagedFilterPipeline.java:118)
at com.google.inject.servlet.AppGuiceFilter.doFilter(AppGuiceFilter.java:47)
at
org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1494)
at
org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61)
at
org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
at
org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
at
org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
at
org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
at
org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
at
org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
at
org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
at
org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
at
org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449)
at
org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365)
at
org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90)
at
org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83)
at
org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:383)
at
org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362)
at
org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
at
org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1486)
at
org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:503)
at
org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:138)
at
org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:540)
at
org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:213)
at
org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1094)
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:432)
at
org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:175)
at
org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1028)
at
org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:136)
at
org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:258)
at
org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:109)
at
org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
at org.eclipse.jetty.server.Server.handle(Server.java:445)
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:267)
at
org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:224)
at
org.eclipse.jetty.io.AbstractConnection$ReadCallback.run(AbstractConnection.java:358)
at
org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:601)
at
org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:532)
at java.lang.Thread.run(Thread.java:724)
Locked ownable synchronizers:
- None
"H2 Log Writer def" daemon prio=10 tid=0x00007fb208053800 nid=0x67c7 in
Object.wait() [0x00007fb2333f2000]
java.lang.Thread.State: TIMED_WAITING (on object monitor)
at java.lang.Object.wait(Native Method)
at org.h2.store.WriterThread.run(WriterThread.java:105)
- locked <0x00000000e2f5bf80> (a org.h2.store.WriterThread)
at java.lang.Thread.run(Thread.java:724)
Locked ownable synchronizers:
- None
"H2 TCP Server (tcp://127.0.1.1:32902)" daemon prio=10
tid=0x00007fb208052000 nid=0x67c5 runnable [0x00007fb2334f3000]
java.lang.Thread.State: RUNNABLE
at java.net.PlainSocketImpl.socketAccept(Native Method)
at java.net.AbstractPlainSocketImpl.accept(AbstractPlainSocketImpl.java:398)
at java.net.ServerSocket.implAccept(ServerSocket.java:530)
at java.net.ServerSocket.accept(ServerSocket.java:498)
at org.h2.server.TcpServer.listen(TcpServer.java:244)
at org.h2.tools.Server.run(Server.java:549)
at java.lang.Thread.run(Thread.java:724)
Locked ownable synchronizers:
- None
"H2 File Lock Watchdog def.lock.db" daemon prio=10 tid=0x00007fb208051000
nid=0x67c4 waiting on condition [0x00007fb2336f5000]
java.lang.Thread.State: TIMED_WAITING (sleeping)
at java.lang.Thread.sleep(Native Method)
at org.h2.store.FileLock.run(FileLock.java:493)
at java.lang.Thread.run(Thread.java:724)
Locked ownable synchronizers:
- None
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/groups/opt_out.
