Error Occurred While Processing Request The web site you are accessing has experienced an unexpected error.
Please contact the website administrator.


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 57) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
 
The error occurred in D:/HOSTINGSPACES/churchil/churchillbooks.com/wwwroot/includes/inventory.cfc: line 320
Called from D:/HOSTINGSPACES/churchil/churchillbooks.com/wwwroot/includes/inventory.cfc: line 299
Called from D:/HOSTINGSPACES/churchil/churchillbooks.com/wwwroot/includes/inventory.cfc: line 74
Called from D:/HOSTINGSPACES/churchil/churchillbooks.com/wwwroot/includes/session.cfm: line 3
Called from D:/HOSTINGSPACES/churchil/churchillbooks.com/wwwroot/includes/session.cfm: line 2
Called from D:/HOSTINGSPACES/churchil/churchillbooks.com/wwwroot/includes/session.cfm: line 1
Called from D:/HOSTINGSPACES/churchil/churchillbooks.com/wwwroot/detail.cfm: line 2
Called from D:/HOSTINGSPACES/churchil/churchillbooks.com/wwwroot/includes/inventory.cfc: line 320
Called from D:/HOSTINGSPACES/churchil/churchillbooks.com/wwwroot/includes/inventory.cfc: line 299
Called from D:/HOSTINGSPACES/churchil/churchillbooks.com/wwwroot/includes/inventory.cfc: line 74
Called from D:/HOSTINGSPACES/churchil/churchillbooks.com/wwwroot/includes/session.cfm: line 3
Called from D:/HOSTINGSPACES/churchil/churchillbooks.com/wwwroot/includes/session.cfm: line 2
Called from D:/HOSTINGSPACES/churchil/churchillbooks.com/wwwroot/includes/session.cfm: line 1
Called from D:/HOSTINGSPACES/churchil/churchillbooks.com/wwwroot/detail.cfm: line 2
318 : 			
319 : 			<cfquery name="getInventory" datasource="#Variables.myDSN#">
320 : 				#PreserveSingleQuotes(Variables.queryString)#
321 : 			</cfquery>
322 :             

SQLSTATE   40001
DATASOURCE   churchill2015
VENDORERRORCODE   1205
SQL    SELECT i.*, g.intGuideID FROM inventory i, guide g WHERE i.intGuideNo *= g.intRefNo ORDER BY i.strAuthor ASC, i.dtSortDate, i.strTitle, i.strBiblioPrefix, i.intBiblioNo, i.intBiblioSuffix
Resources:

Browser   CCBot/2.0 (http://commoncrawl.org/faq/)
Remote Address   54.221.131.67
Referrer  
Date/Time   19-Feb-18 10:15 AM
Stack Trace
at cfinventory2ecfc1874575620$funcUPDATEQUERY._factor2(D:/HOSTINGSPACES/churchil/churchillbooks.com/wwwroot/includes/inventory.cfc:320) at cfinventory2ecfc1874575620$funcUPDATEQUERY.runFunction(D:/HOSTINGSPACES/churchil/churchillbooks.com/wwwroot/includes/inventory.cfc:299) at cfinventory2ecfc1874575620$funcINIT.runFunction(D:/HOSTINGSPACES/churchil/churchillbooks.com/wwwroot/includes/inventory.cfc:74) at cfsession2ecfm42191679._factor4(D:/HOSTINGSPACES/churchil/churchillbooks.com/wwwroot/includes/session.cfm:3) at cfsession2ecfm42191679._factor5(D:/HOSTINGSPACES/churchil/churchillbooks.com/wwwroot/includes/session.cfm:2) at cfsession2ecfm42191679.runPage(D:/HOSTINGSPACES/churchil/churchillbooks.com/wwwroot/includes/session.cfm:1) at cfdetail2ecfm440465707.runPage(D:/HOSTINGSPACES/churchil/churchillbooks.com/wwwroot/detail.cfm:2) at cfinventory2ecfc1874575620$funcUPDATEQUERY._factor2(D:/HOSTINGSPACES/churchil/churchillbooks.com/wwwroot/includes/inventory.cfc:320) at cfinventory2ecfc1874575620$funcUPDATEQUERY.runFunction(D:/HOSTINGSPACES/churchil/churchillbooks.com/wwwroot/includes/inventory.cfc:299) at cfinventory2ecfc1874575620$funcINIT.runFunction(D:/HOSTINGSPACES/churchil/churchillbooks.com/wwwroot/includes/inventory.cfc:74) at cfsession2ecfm42191679._factor4(D:/HOSTINGSPACES/churchil/churchillbooks.com/wwwroot/includes/session.cfm:3) at cfsession2ecfm42191679._factor5(D:/HOSTINGSPACES/churchil/churchillbooks.com/wwwroot/includes/session.cfm:2) at cfsession2ecfm42191679.runPage(D:/HOSTINGSPACES/churchil/churchillbooks.com/wwwroot/includes/session.cfm:1) at cfdetail2ecfm440465707.runPage(D:/HOSTINGSPACES/churchil/churchillbooks.com/wwwroot/detail.cfm:2)

java.sql.SQLTransactionRollbackException: [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 57) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
	at macromedia.jdbc.sqlserverbase.ddcw.b(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddcw.a(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddcv.b(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddcv.a(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.ddr.c(Unknown Source)
	at macromedia.jdbc.sqlserver.dda3.m(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.e(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.a(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.x(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.t(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.execute(Unknown Source)
	at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1485)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1235)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1165)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1187)
	at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:816)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:769)
	at cfinventory2ecfc1874575620$funcUPDATEQUERY._factor2(D:\HOSTINGSPACES\churchil\churchillbooks.com\wwwroot\includes\inventory.cfc:320)
	at cfinventory2ecfc1874575620$funcUPDATEQUERY.runFunction(D:\HOSTINGSPACES\churchil\churchillbooks.com\wwwroot\includes\inventory.cfc:299)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487)
	at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420)
	at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:383)
	at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
	at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:334)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:231)
	at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:2854)
	at cfinventory2ecfc1874575620$funcINIT.runFunction(D:\HOSTINGSPACES\churchil\churchillbooks.com\wwwroot\includes\inventory.cfc:74)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487)
	at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47)
	at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420)
	at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:383)
	at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
	at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:334)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:231)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:643)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:432)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:402)
	at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2483)
	at cfsession2ecfm42191679._factor4(D:\HOSTINGSPACES\churchil\churchillbooks.com\wwwroot\includes\session.cfm:3)
	at cfsession2ecfm42191679._factor5(D:\HOSTINGSPACES\churchil\churchillbooks.com\wwwroot\includes\session.cfm:2)
	at cfsession2ecfm42191679.runPage(D:\HOSTINGSPACES\churchil\churchillbooks.com\wwwroot\includes\session.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:246)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3000)
	at cfdetail2ecfm440465707.runPage(D:\HOSTINGSPACES\churchil\churchillbooks.com\wwwroot\detail.cfm:2)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:246)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:495)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:42)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:153)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94)
	at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:78)
	at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
	at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
	at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:58)
	at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
	at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
	at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62)
	at coldfusion.CfmServlet.service(CfmServlet.java:219)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
	at sun.reflect.GeneratedMethodAccessor51.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:288)
	at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:285)
	at java.security.AccessController.doPrivileged(Native Method)
	at javax.security.auth.Subject.doAsPrivileged(Subject.java:549)
	at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:320)
	at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:175)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:297)
	at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:55)
	at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:191)
	at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:187)
	at java.security.AccessController.doPrivileged(Native Method)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:186)
	at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
	at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
	at sun.reflect.GeneratedMethodAccessor50.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:288)
	at org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:285)
	at java.security.AccessController.doPrivileged(Native Method)
	at javax.security.auth.Subject.doAsPrivileged(Subject.java:549)
	at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:320)
	at org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:260)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
	at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:55)
	at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:191)
	at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:187)
	at java.security.AccessController.doPrivileged(Native Method)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:186)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:450)
	at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:197)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:745)