Does anyone know why the following error is happening?
It happens at random times. I can hit over and over again with no problems, then all the sudden it will throw a JDBC commit failed.
I am using Coldbox 3.5beta, Railo 3.3.0029, on Mac OSX 10.6.8.
I have a dedicated MySQL & a dedicated tomcat/railo server. I’ve checked memory, network connections, upgraded my servers, verified the code any way to Sunday but I’m at a loss why this randomly happens.
I’ve put the server under significant load using Apache Benchmark’s tool hitting my server at 45 request per second. I am unable to reproduce it consistently.
Do anyone have any thoughts/ideas on where to look next?
StackTrace: "JDBC commit failed at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:914):914 at com.mysql.jdbc.Connection.commit(Connection.java:2274):2274 at org.hibernate.transaction.JDBCTransaction.commitAndResetAutoCommit(JDBCTransaction.java:170):170 at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:146):146 at sun.reflect.GeneratedMethodAccessor194.invoke(Unknown Source):-1 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25):25 at java.lang.reflect.Method.invoke(Method.java:597):597 at railo.runtime.reflection.pairs.MethodInstance.invoke(MethodInstance.java:37):37 at railo.runtime.reflection.Reflector.callMethod(Reflector.java:626):626 at railo.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:742):742 at railo.runtime.PageContextImpl.getFunction(PageContextImpl.java:1444):1444 at coldbox.system.orm.hibernate.baseormservice_cfc$cf.udfCall6(/usr/local/tomcat/webapps/PROD/coldbox/system/orm/hibernate/BaseORMService.cfc:1099):1099 at coldbox.system.orm.hibernate.baseormservice_cfc$cf.udfCall(/usr/local/tomcat/webapps/PROD/coldbox/system/orm/hibernate/BaseORMService.cfc):-1 at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:214):214 at railo.runtime.type.UDFImpl._call(UDFImpl.java:418):418 at railo.runtime.type.UDFImpl.call(UDFImpl.java:383):383 at railo.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:738):738 at railo.runtime.PageContextImpl.getFunction(PageContextImpl.java:1444):1444 at coldbox.system.orm.hibernate.baseormservice_cfc$cf.udfCall4(/usr/local/tomcat/webapps/PROD/coldbox/system/orm/hibernate/BaseORMService.cfc:678):678 at coldbox.system.orm.hibernate.baseormservice_cfc$cf.udfCall(/usr/local/tomcat/webapps/PROD/coldbox/system/orm/hibernate/BaseORMService.cfc):-1 at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:214):214 at railo.runtime.type.UDFImpl._call(UDFImpl.java:418):418 at railo.runtime.type.UDFImpl.call(UDFImpl.java:383):383 at railo.runtime.ComponentImpl._call(ComponentImpl.java:609):609 at railo.runtime.ComponentImpl._call(ComponentImpl.java:496):496 at railo.runtime.ComponentImpl.call(ComponentImpl.java:1794):1794 at railo.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:733):733 at railo.runtime.PageContextImpl.getFunction(PageContextImpl.java:1444):1444 at handlers.api._1.apns_cfc$cf.udfCall(/usr/local/tomcat/webapps/PROD/handlers/api/1/apns.cfc:68):68 at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:214):214 at railo.runtime.type.UDFImpl._call(UDFImpl.java:418):418 at railo.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:376):376 at railo.runtime.ComponentImpl._call(ComponentImpl.java:610):610 at railo.runtime.ComponentImpl._call(ComponentImpl.java:496):496 at railo.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1809):1809 at railo.runtime.tag.Invoke.doComponent(Invoke.java:210):210 at railo.runtime.tag.Invoke.doEndTag(Invoke.java:183):183 at coldbox.system.web.controller_cfc$cf.udfCall5(/usr/local/tomcat/webapps/PROD/coldbox/system/web/Controller.cfc:690):690 at coldbox.system.web.controller_cfc$cf.udfCall(/usr/local/tomcat/webapps/PROD/coldbox/system/web/Controller.cfc):-1 at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:214):214 at railo.runtime.type.UDFImpl._call(UDFImpl.java:418):418 at railo.runtime.type.UDFImpl.call(UDFImpl.java:383):383 at railo.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:738):738 at railo.runtime.PageContextImpl.getFunction(PageContextImpl.java:1444):1444 at coldbox.system.web.controller_cfc$cf.udfCall5(/usr/local/tomcat/webapps/PROD/coldbox/system/web/Controller.cfc:575):575 at coldbox.system.web.controller_cfc$cf.udfCall(/usr/local/tomcat/webapps/PROD/coldbox/system/web/Controller.cfc):-1 at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:214):214 at railo.runtime.type.UDFImpl._call(UDFImpl.java:418):418 at railo.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:376):376 at railo.runtime.ComponentImpl._call(ComponentImpl.java:610):610 at railo.runtime.ComponentImpl._call(ComponentImpl.java:496):496 at railo.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1813):1813 at railo.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:769):769 at railo.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1459):1459 at coldbox.system.coldbox_cfc$cf.udfCall1(/usr/local/tomcat/webapps/PROD/coldbox/system/Coldbox.cfc:243):243 at coldbox.system.coldbox_cfc$cf.udfCall(/usr/local/tomcat/webapps/PROD/coldbox/system/Coldbox.cfc):-1 at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:214):214 at railo.runtime.type.UDFImpl._call(UDFImpl.java:418):418 at railo.runtime.type.UDFImpl.call(UDFImpl.java:383):383 at railo.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:738):738 at railo.runtime.PageContextImpl.getFunction(PageContextImpl.java:1444):1444 at application_cfc$cf.udfCall(/usr/local/tomcat/webapps/PROD/Application.cfc:101):101 at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:214):214 at railo.runtime.type.UDFImpl._call(UDFImpl.java:418):418 at railo.runtime.type.UDFImpl.call(UDFImpl.java:383):383 at railo.runtime.ComponentImpl._call(ComponentImpl.java:609):609 at railo.runtime.ComponentImpl._call(ComponentImpl.java:496):496 at railo.runtime.ComponentImpl.call(ComponentImpl.java:1794):1794 at railo.runtime.listener.ModernAppListener.call(ModernAppListener.java:347):347 at railo.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:106):106 at railo.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:23):23 at railo.runtime.PageContextImpl.execute(PageContextImpl.java:1991):1991 at railo.runtime.PageContextImpl.execute(PageContextImpl.java:1958):1958 at railo.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:297):297 at railo.loader.servlet.CFMLServlet.service(CFMLServlet.java:32):32 at javax.servlet.http.HttpServlet.service(HttpServlet.java:722):722 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:304):304 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210):210 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:240):240 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:164):164 at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:462):462 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164):164 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100):100 at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:563):563 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118):118 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:403):403 at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:292):292 at org.apache.coyote.ajp.AjpProtocol$AjpConnectionHandler.process(AjpProtocol.java:143):143 at org.apache.coyote.ajp.AjpProtocol$AjpConnectionHandler.process(AjpProtocol.java:129):129 at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:309):309 at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886):886 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908):908 at java.lang.Thread.run(Thread.java:680):680
Jeremy R. DeYoung
Phone:615.261.8201
RantsFromAMadMan.com