I’m having an issue when trying to update a single user orm object. Its
an intermittent problem.
The coldbox code for login.cfc is
user.setIsOnline(0);
user.setDateLastActivity(now());
user.setLoginUUID(‘’);
userService.save(entity=user,flush=true);
Essentially the user is trying to logout. Nothing special at all.
However this captured error below is happening randomly throughout my
entire application. No rhyme or reason from what I can tell. Sometimes its
when I’m adding a record. Sometimes its when I’m updating. And sometimes
its when I’m deleting.
I’m using Microsoft SQL Server 2005 database. With Microsoft SQL Driver
configured as below
this.datasources[“al3data”] = {
, connectionString: ‘jdbc:sqlserver://255.255.255.255:1433
;DATABASENAME=data;sendStringParametersAsUnicode=true;SelectMethod=direct;useUnicode=true;characterEncoding=UTF-8’
, username: ’ ’
, password: " "
, connectionLimit:25 // default:-1
, connectionTimeout:1 // default: 1; unit: seconds
};
I’m running on windows 10 and ubuntu 14.04. Lucee/Tomcat config. This is
happening on both platforms.
The catalina.out log says this “org.hibernate.util.JDBCExceptionReporter:A
result set was generated for update.” anytime the above error happens.
Any help or guidance would be greatly appreciated.
*Event: *nsg-module-security:logout.index
*Routed URL: *security/logout/
*Layout: *N/A (Module: )
*View: *N/A
*Timestamp: *02/10/2016 06:25:56 PM------------------------------
*Type: *org.hibernate.StaleStateException
Messages: Batch update returned unexpected row count from update [0];
actual row count: -1; expected: 1
Batch update returned unexpected row count from update [0]; actual row
count: -1; expected: 1
at org.hibernate.jdbc.Expectations$BasicExpectation.checkBatched(
Expectations.java:85):85
at org.hibernate.jdbc.Expectations$BasicExpectation.verifyOutcome(
Expectations.java:70):70
at org.hibernate.jdbc.NonBatchingBatcher.addToBatch
(NonBatchingBatcher.java:47):47
at org.hibernate.persister.entity.AbstractEntityPersister.update
(AbstractEntityPersister.java:2574):2574
at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert
(AbstractEntityPersister.java:2478):2478
at org.hibernate.persister.entity.AbstractEntityPersister.update
(AbstractEntityPersister.java:2805):2805
at org.hibernate.action.EntityUpdateAction.execute
(EntityUpdateAction.java:114):114
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:267):267
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:259)
:259
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:179)
:179
at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions
(AbstractFlushingEventListener.java:321):321
at org.hibernate.event.def.DefaultFlushEventListener.onFlush
(DefaultFlushEventListener.java:51):51
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1206):1206
at lucee.runtime.orm.hibernate.HibernateORMSession.flush
(HibernateORMSession.java:162):162
at lucee.runtime.orm.hibernate.HibernateORMSession.flush
(HibernateORMSession.java:154):154
at lucee.runtime.functions.orm.ORMFlush.call(ORMFlush.java:32):32
at models.util.ormutilsupport_cfc$cf.udfCall(/home/outlandusa/www/
slam.outlandusa.com/modules/coldbox-bundle/cborm/models/util/ORMUtilSupport.cfc:19
):19
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:229):229
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:642):642
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:524):524
at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1761):1761
at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues
(VariableUtilImpl.java:743):743
at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1593)
:1593
at models.baseormservice_cfc$cf.udfCall4(/home/outlandusa/www/
slam.outlandusa.com/modules/coldbox-bundle/cborm/models/BaseORMService.cfc:810
):810
at models.baseormservice_cfc$cf.udfCall(/home/outlandusa/www/
slam.outlandusa.com/modules/coldbox-bundle/cborm/models/BaseORMService.cfc)
:-1
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328
at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:216):216
at lucee.runtime.type.scope.ArgumentImpl.callWithNamedValues
(ArgumentImpl.java:520):520
at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues
(VariableUtilImpl.java:774):774
at lucee.runtime.PageContextImpl.getFunctionWithNamedValues
(PageContextImpl.java:1603):1603
at models.baseormservice_cfc$cf.udfCall6(/home/outlandusa/www/
slam.outlandusa.com/modules/coldbox-bundle/cborm/models/BaseORMService.cfc:1467
):1467
at models.baseormservice_cfc$cf.udfCall(/home/outlandusa/www/
slam.outlandusa.com/modules/coldbox-bundle/cborm/models/BaseORMService.cfc)
:-1
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:229):229
at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:766)
:766
at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues
(VariableUtilImpl.java:743):743
at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1593)
:1593
at models.baseormservice_cfc$cf.udfCall4(/home/outlandusa/www/
slam.outlandusa.com/modules/coldbox-bundle/cborm/models/BaseORMService.cfc:793
):793
at models.baseormservice_cfc$cf.udfCall(/home/outlandusa/www/
slam.outlandusa.com/modules/coldbox-bundle/cborm/models/BaseORMService.cfc)
:-1
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328
at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:216):216
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:643):643
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:524):524
at lucee.runtime.ComponentImpl.callWithNamedValues
(ComponentImpl.java:1778):1778
at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues
(VariableUtilImpl.java:774):774
at lucee.runtime.PageContextImpl.getFunctionWithNamedValues
(PageContextImpl.java:1603):1603
at modules.slamweb.interceptors.login_cfc$cf.udfCall(
/home/outlandusa/www/
slam.outlandusa.com/modules/slamweb/interceptors/login.cfc:260):260
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328
at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:216):216
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:643):643
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:524):524
at lucee.runtime.ComponentImpl.callWithNamedValues
(ComponentImpl.java:1774):1774
at lucee.runtime.tag.Invoke.doComponent(Invoke.java:221):221
at lucee.runtime.tag.Invoke.doEndTag(Invoke.java:194):194
at coldbox.system.web.context.interceptorstate_cfc$cf.udfCall2(
/home/outlandusa/www/
slam.outlandusa.com/coldbox/system/web/context/InterceptorState.cfc:370):370
at coldbox.system.web.context.interceptorstate_cfc$cf.udfCall(
/home/outlandusa/www/
slam.outlandusa.com/coldbox/system/web/context/InterceptorState.cfc):-1
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328
at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:216):216
at lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues
(UndefinedImpl.java:775):775
at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues
(VariableUtilImpl.java:774):774
at lucee.runtime.PageContextImpl.getFunctionWithNamedValues
(PageContextImpl.java:1603):1603
at coldbox.system.web.context.interceptorstate_cfc$cf.udfCall1(
/home/outlandusa/www/
slam.outlandusa.com/coldbox/system/web/context/InterceptorState.cfc:260):260
at coldbox.system.web.context.interceptorstate_cfc$cf.udfCall(
/home/outlandusa/www/
slam.outlandusa.com/coldbox/system/web/context/InterceptorState.cfc):-1
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328
at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:216):216
at lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues
(UndefinedImpl.java:775):775
at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues
(VariableUtilImpl.java:774):774
at lucee.runtime.PageContextImpl.getFunctionWithNamedValues
(PageContextImpl.java:1603):1603
at coldbox.system.web.context.interceptorstate_cfc$cf.udfCall1(
/home/outlandusa/www/
slam.outlandusa.com/coldbox/system/web/context/InterceptorState.cfc:121):121
at coldbox.system.web.context.interceptorstate_cfc$cf.udfCall(
/home/outlandusa/www/
slam.outlandusa.com/coldbox/system/web/context/InterceptorState.cfc):-1
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328
at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:216):216
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:643):643
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:524):524
at lucee.runtime.ComponentImpl.callWithNamedValues
(ComponentImpl.java:1778):1778
at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues
(VariableUtilImpl.java:774):774
at lucee.runtime.PageContextImpl.getFunctionWithNamedValues
(PageContextImpl.java:1603):1603
at coldbox.system.web.services.interceptorservice_cfc$cf.udfCall1(
/home/outlandusa/www/
slam.outlandusa.com/coldbox/system/web/services/InterceptorService.cfc:139)
:139
at coldbox.system.web.services.interceptorservice_cfc$cf.udfCall(
/home/outlandusa/www/
slam.outlandusa.com/coldbox/system/web/services/InterceptorService.cfc):-1
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328
at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:216):216
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:643):643
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:524):524
at lucee.runtime.ComponentImpl.callWithNamedValues
(ComponentImpl.java:1778):1778
at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues
(VariableUtilImpl.java:774):774
at lucee.runtime.PageContextImpl.getFunctionWithNamedValues
(PageContextImpl.java:1603):1603
at coldbox.system.frameworksupertype_cfc$cf.udfCall2(
/home/outlandusa/www/
slam.outlandusa.com/coldbox/system/FrameworkSupertype.cfc:216):216
at coldbox.system.frameworksupertype_cfc$cf.udfCall(
/home/outlandusa/www/
slam.outlandusa.com/coldbox/system/FrameworkSupertype.cfc):-1
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328
at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:216):216
at lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues
(UndefinedImpl.java:775):775
at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues
(VariableUtilImpl.java:774):774
at lucee.runtime.PageContextImpl.getFunctionWithNamedValues
(PageContextImpl.java:1603):1603
at modules.nsmain_bundle315.nsg_module_security675.handlers.logout_cfc
$cf.udfCall(/home/outlandusa/www/
slam.outlandusa.com/modules/nsMain-bundle/nsg-module-security/handlers/logout.cfc:5
):5
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328
at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:216):216
at lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues
(UndefinedImpl.java:775):775
at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues
(VariableUtilImpl.java:774):774
at lucee.runtime.PageContextImpl.getFunctionWithNamedValues
(PageContextImpl.java:1603):1603
at coldbox.system.eventhandler_cfc$cf.udfCall(/home/outlandusa/www/
slam.outlandusa.com/coldbox/system/EventHandler.cfc:78):78
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328
at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:216):216
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:643):643
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:524):524
at lucee.runtime.ComponentImpl.callWithNamedValues
(ComponentImpl.java:1778):1778
at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues
(VariableUtilImpl.java:774):774
at lucee.runtime.PageContextImpl.getFunctionWithNamedValues
(PageContextImpl.java:1603):1603
at coldbox.system.web.controller_cfc$cf.udfCall3(/home/outlandusa/www/
slam.outlandusa.com/coldbox/system/web/Controller.cfc:761):761
at coldbox.system.web.controller_cfc$cf.udfCall(/home/outlandusa/www/
slam.outlandusa.com/coldbox/system/web/Controller.cfc):-1
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328
at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:216):216
at lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues
(UndefinedImpl.java:775):775
at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues
(VariableUtilImpl.java:774):774
at lucee.runtime.PageContextImpl.getFunctionWithNamedValues
(PageContextImpl.java:1603):1603
at coldbox.system.web.controller_cfc$cf.udfCall2(/home/outlandusa/www/
slam.outlandusa.com/coldbox/system/web/Controller.cfc:599):599
at coldbox.system.web.controller_cfc$cf.udfCall(/home/outlandusa/www/
slam.outlandusa.com/coldbox/system/web/Controller.cfc):-1
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328
at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:216):216
at lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues
(UndefinedImpl.java:775):775
at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues
(VariableUtilImpl.java:774):774
at lucee.runtime.PageContextImpl.getFunctionWithNamedValues
(PageContextImpl.java:1603):1603
at coldbox.system.web.controller_cfc$cf.udfCall2(/home/outlandusa/www/
slam.outlandusa.com/coldbox/system/web/Controller.cfc:425):425
at coldbox.system.web.controller_cfc$cf.udfCall(/home/outlandusa/www/
slam.outlandusa.com/coldbox/system/web/Controller.cfc):-1
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328
at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:216):216
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:643):643
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:524):524
at lucee.runtime.ComponentImpl.callWithNamedValues
(ComponentImpl.java:1778):1778
at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues
(VariableUtilImpl.java:774):774
at lucee.runtime.PageContextImpl.getFunctionWithNamedValues
(PageContextImpl.java:1603):1603
at coldbox.system.bootstrap_cfc$cf.udfCall1(/home/outlandusa/www/
slam.outlandusa.com/coldbox/system/Bootstrap.cfc:197):197
at coldbox.system.bootstrap_cfc$cf.udfCall(/home/outlandusa/www/
slam.outlandusa.com/coldbox/system/Bootstrap.cfc):-1
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:229):229
at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:766)
:766
at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues
(VariableUtilImpl.java:743):743
at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1593)
:1593
at coldbox.system.bootstrap_cfc$cf.udfCall1(/home/outlandusa/www/
slam.outlandusa.com/coldbox/system/Bootstrap.cfc:353):353
at coldbox.system.bootstrap_cfc$cf.udfCall(/home/outlandusa/www/
slam.outlandusa.com/coldbox/system/Bootstrap.cfc):-1
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:229):229
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:642):642
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:524):524
at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1761):1761
at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues
(VariableUtilImpl.java:743):743
at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1593)
:1593
at application_cfc$cf.udfCall(/home/outlandusa/www/
slam.outlandusa.com/Application.cfc:107):107
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:229):229
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:642):642
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:524):524
at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1761):1761
at lucee.runtime.listener.ModernAppListener.call
(ModernAppListener.java:413):413
at lucee.runtime.listener.ModernAppListener._onRequest
(ModernAppListener.java:133):133
at lucee.runtime.listener.MixedAppListener.onRequest
(MixedAppListener.java:37):37
at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2265):2265
at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2228):2228
at lucee.runtime.engine.CFMLEngineImpl.serviceCFML
(CFMLEngineImpl.java:456):456
at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:47):47
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729):729
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
(ApplicationFilterChain.java:291):291
at org.apache.catalina.core.ApplicationFilterChain.doFilter
(ApplicationFilterChain.java:206):206
at org.apache.tomcat.websocket.server.WsFilter.doFilter
(WsFilter.java:52):52
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
(ApplicationFilterChain.java:239):239
at org.apache.catalina.core.ApplicationFilterChain.doFilter
(ApplicationFilterChain.java:206):206
at org.apache.catalina.core.StandardWrapperValve.invoke
(StandardWrapperValve.java:217):217
at org.apache.catalina.core.StandardContextValve.invoke
(StandardContextValve.java:106):106
at org.apache.catalina.authenticator.AuthenticatorBase.invoke
(AuthenticatorBase.java:502):502
at org.apache.catalina.core.StandardHostValve.invoke
(StandardHostValve.java:142):142
at org.apache.catalina.valves.ErrorReportValve.invoke
(ErrorReportValve.java:79):79
at org.apache.catalina.core.StandardEngineValve.invoke
(StandardEngineValve.java:88):88
at org.apache.catalina.connector.CoyoteAdapter.service
(CoyoteAdapter.java:518):518
at org.apache.coyote.http11.AbstractHttp11Processor.process
(AbstractHttp11Processor.java:1091):1091
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(
AbstractProtocol.java:673):673
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(
NioEndpoint.java:1500):1500
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(
NioEndpoint.java:1456):1456
at java.util.concurrent.ThreadPoolExecutor.runWorker
(ThreadPoolExecutor.java:1142):1142
at java.util.concurrent.ThreadPoolExecutor$Worker.run(
ThreadPoolExecutor.java:617):617
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(
TaskThread.java:61):61
at java.lang.Thread.run(Thread.java:745):745