logo Sign In

Post #625575

Author
georgec
Parent topic
Random Thoughts
Link to post in topic
https://originaltrilogy.com/post/id/625575/action/topic#625575
Date created
5-Mar-2013, 5:32 PM
The following information is meant for the website developer for debugging purposes.
Error Occurred While Processing Request
Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 259) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
 
The error occurred in E:\Inetpub\originaltrilogy.com\wwwroot\forum\components\ForumContent.cfc: line 327
Called from E:\Inetpub\originaltrilogy.com\wwwroot\forum\components\ForumContent.cfc: line 218
Called from E:\Inetpub\originaltrilogy.com\wwwroot\forum\topic.cfm: line 38
Called from E:\Inetpub\originaltrilogy.com\wwwroot\forum\topic.cfm: line 1
Called from E:\Inetpub\originaltrilogy.com\wwwroot\forum\components\ForumContent.cfc: line 327
Called from E:\Inetpub\originaltrilogy.com\wwwroot\forum\components\ForumContent.cfc: line 218
Called from E:\Inetpub\originaltrilogy.com\wwwroot\forum\topic.cfm: line 38
Called from E:\Inetpub\originaltrilogy.com\wwwroot\forum\topic.cfm: line 1
 
325 : 	( intUserID, intTopicID, dteTopicViewTime )
326 : 	values
327 : 	( <cfqueryparam cfsqltype="cf_sql_integer" value="#arguments.ForumUserID#" />, <cfqueryparam cfsqltype="cf_sql_integer" value="#arguments.ForumTopicID#" />, <cfqueryparam cfsqltype="cf_sql_timestamp" value="#arguments.DateTime#" /> )
328 : 	</cfquery>
329 : </cffunction>
SQLSTATE   40001
SQL    delete from tblForumTopicViewTimes where intUserID = (param 1) and intTopicID = (param 2) insert tblForumTopicViewTimes ( intUserID, intTopicID, dteTopicViewTime ) values ( (param 3) , (param 4) , (param 5) )
VENDORERRORCODE   1205
DATASOURCE   ot_forum
Resources:

 
Browser   Mozilla/5.0 (Windows NT 6.1; WOW64; rv:19.0) Gecko/20100101 Firefox/19.0
Remote Address   71.198.172.110
Referrer   http://originaltrilogy.com/forum/forum.cfm/Off-Topic-Unmoderated/forum/6/
Date/Time   05-Mar-13 04:31 PM
Stack Trace
at cfForumContent2ecfc332431$funcFORUMUSERTOPICVIEWTIMEINSERT.runFunction(E:\Inetpub\originaltrilogy.com\wwwroot\forum\components\ForumContent.cfc:327) at cfForumContent2ecfc332431$funcFORUMTOPICPOSTS.runFunction(E:\Inetpub\originaltrilogy.com\wwwroot\forum\components\ForumContent.cfc:218) at cftopic2ecfm2006013559._factor18(E:\Inetpub\originaltrilogy.com\wwwroot\forum\topic.cfm:38) at cftopic2ecfm2006013559.runPage(E:\Inetpub\originaltrilogy.com\wwwroot\forum\topic.cfm:1) at cfForumContent2ecfc332431$funcFORUMUSERTOPICVIEWTIMEINSERT.runFunction(E:\Inetpub\originaltrilogy.com\wwwroot\forum\components\ForumContent.cfc:327) at cfForumContent2ecfc332431$funcFORUMTOPICPOSTS.runFunction(E:\Inetpub\originaltrilogy.com\wwwroot\forum\components\ForumContent.cfc:218) at cftopic2ecfm2006013559._factor18(E:\Inetpub\originaltrilogy.com\wwwroot\forum\topic.cfm:38) at cftopic2ecfm2006013559.runPage(E:\Inetpub\originaltrilogy.com\wwwroot\forum\topic.cfm:1) 

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 259) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
	at macromedia.jdbc.base.BaseExceptions.createException(Unknown Source)
	at macromedia.jdbc.base.BaseExceptions.getException(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.TDSRPCRequest.processReplyToken(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)
	at macromedia.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source)
	at macromedia.jdbc.base.BaseStatement.commonTransitionToState(Unknown Source)
	at macromedia.jdbc.base.BaseStatement.postImplExecute(Unknown Source)
	at macromedia.jdbc.base.BasePreparedStatement.postImplExecute(Unknown Source)
	at macromedia.jdbc.base.BaseStatement.commonExecute(Unknown Source)
	at macromedia.jdbc.base.BaseStatement.executeInternal(Unknown Source)
	at macromedia.jdbc.base.BasePreparedStatement.execute(Unknown Source)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1249)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1008)
	at coldfusion.sql.Executive.executeQuery(Executive.java:939)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:325)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:831)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:521)
	at cfForumContent2ecfc332431$funcFORUMUSERTOPICVIEWTIMEINSERT.runFunction(E:\Inetpub\originaltrilogy.com\wwwroot\forum\components\ForumContent.cfc:327)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418)
	at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47)
	at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:360)
	at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:324)
	at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:59)
	at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:463)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:453)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:320)
	at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2222)
	at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:358)
	at cfForumContent2ecfc332431$funcFORUMTOPICPOSTS.runFunction(E:\Inetpub\originaltrilogy.com\wwwroot\forum\components\ForumContent.cfc:218)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:418)
	at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47)
	at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:360)
	at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:324)
	at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:59)
	at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:277)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:463)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:453)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:320)
	at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2222)
	at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:358)
	at cftopic2ecfm2006013559._factor18(E:\Inetpub\originaltrilogy.com\wwwroot\forum\topic.cfm:38)
	at cftopic2ecfm2006013559.runPage(E:\Inetpub\originaltrilogy.com\wwwroot\forum\topic.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:196)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:370)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:273)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:86)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70)
	at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
	at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
	at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46)
	at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
	at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
	at coldfusion.CfmServlet.service(CfmServlet.java:175)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
	at jrun.servlet.FilterChain.doFilter(FilterChain.java:86)
	at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
	at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
	at jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
	at jrun.servlet.FilterChain.service(FilterChain.java:101)
	at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106)
	at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
	at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286)
	at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543)
	at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203)
	at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320)
	at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428)
	at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266)
	at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)