That tends to mean that the database
connection dropped. You can simulate this by running a few queries (in or out
of reactor), which should establish a few connections to your DBMS. Then
restart your dbms. When you run the scripts again you’ll get errors
because pooled connections from CF to your DBMS are broken. Once all the open
connections have errored out like this the problem will go away and new connections
will be established from CF to your DBMS.
Doug
From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dan Vega
Sent: Wednesday, October 11, 2006
10:54 AM
To: reactor
Subject: [Reactor for CF]
Connection reset by peer.
A customer of ours got an error this morning that I have not seen
before and that I am having trouble tracking down the root cause for. When
doing multiple saves(false) inside a transaction tag the user got an error,
while one of the transactions commited the rest of them failed (which should
not happen) and this error was in my logs. Does anyone know why this would
happen? This is not reactor specfic right?
"Error","jrpp-553","10/11/06","08:56:17","*********","An
exception occurred during the execution of the transaction.The root cause of
this exception was: java.sql.SQLException : [Macromedia][SQLServer JDBC
Driver]Connection reset by peer: socket write error. The specific sequence of
files included or processed is: D:\webdocs\*********\staff\editClient.cfm,
line: 182 "
coldfusion.tagext.sql.TransactionTag$TransactionException: An exception
occurred during the execution of the transaction.
at
coldfusion.tagext.sql.TransactionTag.rollback(TransactionTag.java:336)
at coldfusion.tagext.sql.TransactionTag.doStartTag(TransactionTag.java
:157)
at
cfeditClient2ecfm1998965365._factor5(D:\webdocs\*********\staff\editClient.cfm:182)
at
cfeditClient2ecfm1998965365._factor6(D:\webdocs\*********\staff\editClient.cfm:152)
at cfeditClient2ecfm1998965365._factor10(D:\webdocs\*********\staff\editClient.cfm:150)
at
cfeditClient2ecfm1998965365.runPage(D:\webdocs\*********\staff\editClient.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java
:349)
at
coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1915)
at
cfApplication2ecfc1419541673$funcONREQUEST.runFunction(D:\webdocs\*********\staff\Application.cfc:25)
at coldfusion.runtime.UDFMethod.invoke (UDFMethod.java:348)
at
coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:294)
at
coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:258)
at coldfusion.filter.FunctionAccessFilter.invoke
(FunctionAccessFilter.java:56)
at
coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:211)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:173)
at coldfusion.runtime.TemplateProxy.invoke(
TemplateProxy.java:192)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:145)
at
coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:54)
at coldfusion.runtime.AppEventInvoker.onRequest
(AppEventInvoker.java:115)
at
coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:200)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:86)
at coldfusion.filter.ExceptionFilter.invoke
(ExceptionFilter.java:69)
at
coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.GlobalsFilter.invoke
(GlobalsFilter.java:38)
at
coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:115)
at coldfusion.CfmServlet.service (CfmServlet.java:107)
at
coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:78)
at
jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
at jrun.servlet.JRunInvokerChain.invokeNext
(JRunInvokerChain.java:42)
at
jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:257)
at
jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:541)
at jrun.servlet.jrpp.JRunProxyService.invokeRunnable
(JRunProxyService.java:204)
at
jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:318)
at
jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:426)
at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable
(ThreadPool.java:264)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
Thank You
Dan Vega
[EMAIL PROTECTED]
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
--
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
--
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
|
