[midPoint] Hibernate SQLServer Snapshot Isolation error

Todd Bickers tbickers at illinois.edu
Wed Oct 8 17:19:41 CEST 2014 

Hello,

I'm working on a Midpoint installation where we are importing 1,800,000+ 
records into Midpoint.  During our import process we are receiving 
SQLServer Snapshot isolation errors when we call the SOAP web services 
from a multi-threaded client.  This hibernate issue goes away if we turn 
off auditing.  Has anyone seen this issue with hibernate and SQL 
Server?  Does anyone know of a SQL Server installation with a lot of 
records in the m_user table?  Our process does complete and load the 
1,800,000+ records successfully.  We just get this error in the log.  
The client call completes successfully(no exceptions returned).

Thanks,

Todd Bickers
University of Illinois
tbickers at uillinois.edu


StackTrace:

2014-10-08 09:58:40,031 [MODEL] [http-8080-29] ERROR 
(org.hibernate.id.enhanced.TableStructure): could not read a hi value
com.microsoft.sqlserver.jdbc.SQLServerException: Snapshot isolation 
transaction aborted due to update conflict. You cannot use snapshot 
isolation to access table 'dbo.hibernate_sequence' directly or 
indirectly in database 'Midpoint_Todd' to update, delete, or insert the 
row that has been modified or deleted by another transaction. Retry the 
transaction or change the isolati
on level for the update/delete statement.
         at 
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216) 
~[sqljdbc4.jar:na]
         at 
com.microsoft.sqlserver.jdbc.SQLServerResultSet$FetchBuffer.nextRow(SQLServerResultSet.java:4853) 
~[sqljdbc4.jar:na]
         at 
com.microsoft.sqlserver.jdbc.SQLServerResultSet.fetchBufferNext(SQLServerResultSet.java:1781) 
~[sqljdbc4.jar:na]
         at 
com.microsoft.sqlserver.jdbc.SQLServerResultSet.next(SQLServerResultSet.java:1034) 
~[sqljdbc4.jar:na]
         at 
com.mchange.v2.c3p0.impl.NewProxyResultSet.next(NewProxyResultSet.java:2859) 
~[c3p0-0.9.1.jar:0.9.1]
         at 
org.hibernate.id.enhanced.TableStructure$1$1.execute(TableStructure.java:135) 
~[hibernate-core-4.1.12.Final.jar:4.1.12.Final]
         at 
org.hibernate.id.enhanced.TableStructure$1$1.execute(TableStructure.java:120) 
~[hibernate-core-4.1.12.Final.jar:4.1.12.Final]
         at 
org.hibernate.jdbc.WorkExecutor.executeReturningWork(WorkExecutor.java:72) 
~[hibernate-core-4.1.12.Final.jar:4.1.12.Final]
         at 
org.hibernate.jdbc.AbstractReturningWork.accept(AbstractReturningWork.java:51) 
~[hibernate-core-4.1.12.Final.jar:4.1.12.Final]
         at 
org.hibernate.engine.transaction.internal.jdbc.JdbcIsolationDelegate.delegateWork(JdbcIsolationDelegate.java:77) 
[hibernate-core-4.1.12.Final.jar:4.1.12.Final]
         at 
org.hibernate.id.enhanced.TableStructure$1.getNextValue(TableStructure.java:119) 
[hibernate-core-4.1.12.Final.jar:4.1.12.Final]
         at 
org.hibernate.id.enhanced.OptimizerFactory$NoopOptimizer.generate(OptimizerFactory.java:252) 
[hibernate-core-4.1.12.Final.jar:4.1.12.Final]
         at 
org.hibernate.id.enhanced.SequenceStyleGenerator.generate(SequenceStyleGenerator.java:369) 
[hibernate-core-4.1.12.Final.jar:4.1.12.Final]
         at 
org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:117) 
[hibernate-core-4.1.12.Final.jar:4.1.12.Final]
         at 
org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:204) 
[hibernate-core-4.1.12.Final.jar:4.1.12.Final]
         at 
org.hibernate.event.internal.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:55) 
[hibernate-core-4.1.12.Final.jar:4.1.12.Final]
         at 
org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:189) 
[hibernate-core-4.1.12.Final.jar:4.1.12.Final]
         at 
org.hibernate.event.internal.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:49) 
[hibernate-core-4.1.12.Final.jar:4.1.12.Final]
         at 
org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:90) 
[hibernate-core-4.1.12.Final.jar:4.1.12.Final]
         at 
org.hibernate.internal.SessionImpl.fireSave(SessionImpl.java:756) 
[hibernate-core-4.1.12.Final.jar:4.1.12.Final]
         at 
org.hibernate.internal.SessionImpl.save(SessionImpl.java:748) 
[hibernate-core-4.1.12.Final.jar:4.1.12.Final]
         at 
org.hibernate.internal.SessionImpl.save(SessionImpl.java:744) 
[hibernate-core-4.1.12.Final.jar:4.1.12.Final]
         at 
com.evolveum.midpoint.repo.sql.SqlAuditServiceImpl.auditAttempt(SqlAuditServiceImpl.java:77) 
[repo-sql-impl-3.0.jar:na]
         at 
com.evolveum.midpoint.repo.sql.SqlAuditServiceImpl.audit(SqlAuditServiceImpl.java:63) 
[repo-sql-impl-3.0.jar:na]
         at 
com.evolveum.midpoint.init.AuditServiceProxy.audit(AuditServiceProxy.java:56) 
[system-init-3.0.jar:na]
         at 
com.evolveum.midpoint.model.impl.lens.Clockwork.auditEvent(Clockwork.java:581) 
[model-impl-3.0.jar:na]
         at 
com.evolveum.midpoint.model.impl.lens.Clockwork.audit(Clockwork.java:488) [model-impl-3.0.jar:na]
         at 
com.evolveum.midpoint.model.impl.lens.Clockwork.processSecondary(Clockwork.java:402) 
[model-impl-3.0.jar:na]
         at 
com.evolveum.midpoint.model.impl.lens.Clockwork.click(Clockwork.java:230) [model-impl-3.0.jar:na]
         at 
com.evolveum.midpoint.model.impl.lens.Clockwork.run(Clockwork.java:156) 
[model-impl-3.0.jar:na]
         at 
com.evolveum.midpoint.model.impl.controller.ModelController.executeChanges_aroundBody2(ModelController.java:455) 
[model-impl-3.0.jar:na]
         at 
com.evolveum.midpoint.model.impl.controller.ModelController$AjcClosure3.run(ModelController.java:1) 
[model-impl-3.0.jar:na]
         at 
org.aspectj.runtime.reflect.JoinPointImpl.proceed(JoinPointImpl.java:149) [aspectjrt-1.7.3.jar:na]
         at 
com.evolveum.midpoint.util.aspect.MidpointAspect.wrapSubsystem(MidpointAspect.java:192) 
[util-3.0.jar:na]
         at 
com.evolveum.midpoint.util.aspect.MidpointAspect.ajc$inlineAccessMethod$com_evolveum_midpoint_util_aspect_MidpointAspect$com_evolveum_midpoint_util_aspect_MidpointAspect$wrapSub
system(MidpointAspect.java:1) [util-3.0.jar:na]
         at 
com.evolveum.midpoint.util.aspect.MidpointAspect.processModelNdc(MidpointAspect.java:77) 
[util-3.0.jar:na]
         at 
com.evolveum.midpoint.model.impl.controller.ModelController.executeChanges(ModelController.java:361) 
[model-impl-3.0.jar:na]
         at 
com.evolveum.midpoint.model.impl.ModelWebService.executeChanges(ModelWebService.java:193) 
[model-impl-3.0.jar:na]
         at 
com.evolveum.midpoint.model.impl.ModelWebServiceRaw.invokeAllowingFaults(ModelWebServiceRaw.java:154) 
[model-impl-3.0.jar:na]
         at 
com.evolveum.midpoint.model.impl.ModelWebServiceRaw.invoke(ModelWebServiceRaw.java:96) 
[model-impl-3.0.jar:na]
         at 
com.evolveum.midpoint.model.impl.ModelWebServiceRaw.invoke(ModelWebServiceRaw.java:1) 
[model-impl-3.0.jar:na]
         at sun.reflect.GeneratedMethodAccessor352.invoke(Unknown 
Source) ~[na:na]
         at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 
~[na:1.7.0_13]
         at java.lang.reflect.Method.invoke(Method.java:601) ~[na:1.7.0_13]
         at 
org.apache.cxf.service.invoker.AbstractInvoker.performInvocation(AbstractInvoker.java:180) 
[cxf-api-2.7.6.jar:2.7.6]
         at 
org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:96) 
[cxf-api-2.7.6.jar:2.7.6]
         at 
org.apache.cxf.jaxws.AbstractJAXWSMethodInvoker.invoke(AbstractJAXWSMethodInvoker.java:178) 
[cxf-rt-frontend-jaxws-2.7.6.jar:2.7.6]
         at 
org.apache.cxf.jaxws.JAXWSMethodInvoker.invoke(JAXWSMethodInvoker.java:68) 
[cxf-rt-frontend-jaxws-2.7.6.jar:2.7.6]
         at 
org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:75) 
[cxf-api-2.7.6.jar:2.7.6]
         at 
org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:57) 
[cxf-api-2.7.6.jar:2.7.6]
         at 
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) 
[na:1.7.0_13]
         at 
java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) 
[na:1.7.0_13]
         at java.util.concurrent.FutureTask.run(FutureTask.java:166) 
[na:1.7.0_13]
         at 
org.apache.cxf.workqueue.SynchronousExecutor.execute(SynchronousExecutor.java:37) 
[cxf-api-2.7.6.jar:2.7.6]
         at 
org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:106) 
[cxf-api-2.7.6.jar:2.7.6]
         at 
org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:271) 
[cxf-api-2.7.6.jar:2.7.6]
         at 
org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:121) 
[cxf-api-2.7.6.jar:2.7.6]
         at 
org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:239) 
[cxf-rt-transports-http-2.7.6.jar:2.7.6]
         at 
org.apache.cxf.transport.servlet.ServletController.invokeDestination(ServletController.java:223) 
[cxf-rt-transports-http-2.7.6.jar:2.7.6]
         at 
org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:203) 
[cxf-rt-transports-http-2.7.6.jar:2.7.6]
         at 
org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:137) 
[cxf-rt-transports-http-2.7.6.jar:2.7.6]
         at 
org.apache.cxf.transport.servlet.CXFNonSpringServlet.invoke(CXFNonSpringServlet.java:159) 
[cxf-rt-transports-http-2.7.6.jar:2.7.6]
         at 
org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:286) 
[cxf-rt-transports-http-2.7.6.jar:2.7.6]
         at 
org.apache.cxf.transport.servlet.AbstractHTTPServlet.doPost(AbstractHTTPServlet.java:206) 
[cxf-rt-transports-http-2.7.6.jar:2.7.6]
         at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) 
[servlet-api.jar:na]
         at 
org.apache.cxf.transport.servlet.AbstractHTTPServlet.service(AbstractHTTPServlet.java:262) 
[cxf-rt-transports-http-2.7.6.jar:2.7.6]
         at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) 
[catalina.jar:6.0.32]
         at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 
[catalina.jar:6.0.32]
         at 
org.apache.wicket.protocol.http.WicketFilter.processRequestCycle(WicketFilter.java:263) 
[wicket-core-6.14.0.jar:6.14.0]
         at 
org.apache.wicket.protocol.http.WicketFilter.processRequest(WicketFilter.java:201) 
[wicket-core-6.14.0.jar:6.14.0]
         at 
org.apache.wicket.protocol.http.WicketFilter.doFilter(WicketFilter.java:282) 
[wicket-core-6.14.0.jar:6.14.0]
         at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) 
[catalina.jar:6.0.32]
         at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 
[catalina.jar:6.0.32]
         at 
org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:167) 
[spring-security-web-3.1.0.RELEASE.jar:3.1.0.RELEASE]
         at 
org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) 
[spring-web-3.1.0.RELEASE.jar:3.1.0.RELEASE]
         at 
org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) 
[spring-web-3.1.0.RELEASE.jar:3.1.0.RELEASE]
         at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) 
[catalina.jar:6.0.32]
         at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 
[catalina.jar:6.0.32]
         at 
com.evolveum.midpoint.web.util.MidPointProfilingServletFilter.doFilter(MidPointProfilingServletFilter.java:86) 
[MidPointProfilingServletFilter.class:na]
         at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) 
[catalina.jar:6.0.32]
         at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 
[catalina.jar:6.0.32]
         at 
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) 
[catalina.jar:6.0.32]
         at 
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) 
[catalina.jar:6.0.32]
         at 
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) 
[catalina.jar:6.0.32]
         at 
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) 
[catalina.jar:6.0.32]
         at 
org.apache.catalina.valves.RequestFilterValve.process(RequestFilterValve.java:269) 
[catalina.jar:6.0.32]
         at 
org.apache.catalina.valves.RemoteAddrValve.invoke(RemoteAddrValve.java:81) 
[catalina.jar:6.0.32]
         at 
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) 
[catalina.jar:6.0.32]
         at 
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) 
[catalina.jar:6.0.32]
         at 
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859) 
[tomcat-coyote.jar:6.0.32]
         at 
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) 
[tomcat-coyote.jar:6.0.32]
         at 
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) 
[tomcat-coyote.jar:6.0.32]
         at java.lang.Thread.run(Thread.java:722) [na:1.7.0_13]

More information about the midPoint mailing list