[Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 156) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
SQLState
40001
StackTrace
java.sql.SQLTransactionRollbackException: [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 156) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1095)
at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980)
at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124)
at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193)
at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153)
at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126)
at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275)
at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035)
at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632)
at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699)
at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508)
at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358)
at macromedia.jdbc.sqlserver.base.gr.execute(|SQLServer|6.0.0.1282|:4478)
at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359)
at coldfusion.sql.Executive.executeQuery(Executive.java:1642)
at coldfusion.sql.Executive.executeQuery(Executive.java:1384)
at coldfusion.sql.Executive.executeQuery(Executive.java:1314)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425)
at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1250)
at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:877)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:822)
at cfcategory2ecfc73142977$funcDISPSIDENAVFILTER.runFunction(C:\websites\stratusecommerce\functions\category.cfc:1807)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:629)
at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:522)
at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:469)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:444)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:316)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503)
at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4137)
at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4100)
at cfdepartments2ecfm26623308.runPage(C:\websites\stratusecommerce\includes\views\departments.cfm:152)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5083)
at cfsidenav2ecfm48817863._factor36(C:\websites\stratusecommerce\includes\sidenav.cfm:82)
at cfsidenav2ecfm48817863.runPage(C:\websites\stratusecommerce\includes\sidenav.cfm:2)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5083)
at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:175)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5083)
at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:243)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:629)
at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:559)
at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:522)
at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:469)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:444)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:316)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503)
at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115)
at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:569)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43)
at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:162)
at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60)
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:231)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46)
at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357)
at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:448)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:936)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1190)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63)
at java.base/java.lang.Thread.run(Thread.java:842)
Suppressed
array[empty]
TagContext
array
1
struct
COLUMN
0
ID
??
LINE
1095
RAW_TRACE
at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1095)
TEMPLATE
|SQLServer|6.0.0.1282|
TYPE
CFML
2
struct
COLUMN
0
ID
CF_|SQLSERVER|6.0.0
LINE
980
RAW_TRACE
at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980)
TEMPLATE
|SQLServer|6.0.0.1282|
TYPE
CFML
3
struct
COLUMN
0
ID
CF_|SQLSERVER|6.0.0
LINE
1124
RAW_TRACE
at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124)
TEMPLATE
|SQLServer|6.0.0.1282|
TYPE
CFML
4
struct
COLUMN
0
ID
CF_|SQLSERVER|6.0.0
LINE
193
RAW_TRACE
at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193)
TEMPLATE
|SQLServer|6.0.0.1282|
TYPE
CFML
5
struct
COLUMN
0
ID
CF_|SQLSERVER|6.0.0
LINE
1153
RAW_TRACE
at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153)
TEMPLATE
|SQLServer|6.0.0.1282|
TYPE
CFML
6
struct
COLUMN
0
ID
CF_|SQLSERVER|6.0.0
LINE
4126
RAW_TRACE
at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126)
TEMPLATE
|SQLServer|6.0.0.1282|
TYPE
CFML
7
struct
COLUMN
0
ID
CF_|SQLSERVER|6.0.0
LINE
4275
RAW_TRACE
at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275)
TEMPLATE
|SQLServer|6.0.0.1282|
TYPE
CFML
8
struct
COLUMN
0
ID
CF_|SQLSERVER|6.0.0
LINE
2035
RAW_TRACE
at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035)
TEMPLATE
|SQLServer|6.0.0.1282|
TYPE
CFML
9
struct
COLUMN
0
ID
CF_|SQLSERVER|6.0.0
LINE
632
RAW_TRACE
at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632)
TEMPLATE
|SQLServer|6.0.0.1282|
TYPE
CFML
10
struct
COLUMN
0
ID
CF_|SQLSERVER|6.0.0
LINE
2699
RAW_TRACE
at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699)
TEMPLATE
|SQLServer|6.0.0.1282|
TYPE
CFML
11
struct
COLUMN
0
ID
CF_|SQLSERVER|6.0.0
LINE
2508
RAW_TRACE
at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508)
TEMPLATE
|SQLServer|6.0.0.1282|
TYPE
CFML
12
struct
COLUMN
0
ID
CF_|SQLSERVER|6.0.0
LINE
1358
RAW_TRACE
at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358)
TEMPLATE
|SQLServer|6.0.0.1282|
TYPE
CFML
13
struct
COLUMN
0
ID
CF_|SQLSERVER|6.0.0
LINE
4478
RAW_TRACE
at macromedia.jdbc.sqlserver.base.gr.execute(|SQLServer|6.0.0.1282|:4478)
TEMPLATE
|SQLServer|6.0.0.1282|
TYPE
CFML
14
struct
COLUMN
0
ID
CFQUERY
LINE
1807
RAW_TRACE
at cfcategory2ecfc73142977$funcDISPSIDENAVFILTER.runFunction(C:\websites\stratusecommerce\functions\category.cfc:1807)
at cfsidenav2ecfm48817863._factor36(C:\websites\stratusecommerce\includes\sidenav.cfm:82)
TEMPLATE
C:\websites\stratusecommerce\includes\sidenav.cfm
TYPE
CFML
17
struct
COLUMN
0
ID
CF_SIDENAV
LINE
2
RAW_TRACE
at cfsidenav2ecfm48817863.runPage(C:\websites\stratusecommerce\includes\sidenav.cfm:2)
TEMPLATE
C:\websites\stratusecommerce\includes\sidenav.cfm
TYPE
CFML
18
struct
COLUMN
0
ID
CFINCLUDE
LINE
175
RAW_TRACE
at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:175)
TEMPLATE
C:\websites\stratusecommerce\category.cfm
TYPE
CFML
19
struct
COLUMN
0
ID
CFINCLUDE
LINE
243
RAW_TRACE
at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:243)
TEMPLATE
C:\websites\stratusecommerce\application.cfc
TYPE
CFML
Type
java.sql.SQLTransactionRollbackException
DataSource
koalasql
Detail
[Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 156) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
ErrorCode
40001
Exceptions
array
1
struct
class
java.sql.SQLTransactionRollbackException
message
[Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 156) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Message
Error Executing Database Query.
NativeErrorCode
1205
RootCause
struct
ErrorCode
1205
Message
[Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 156) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
SQLState
40001
StackTrace
java.sql.SQLTransactionRollbackException: [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 156) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1095)
at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980)
at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124)
at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193)
at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153)
at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126)
at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275)
at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035)
at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632)
at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699)
at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508)
at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358)
at macromedia.jdbc.sqlserver.base.gr.execute(|SQLServer|6.0.0.1282|:4478)
at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359)
at coldfusion.sql.Executive.executeQuery(Executive.java:1642)
at coldfusion.sql.Executive.executeQuery(Executive.java:1384)
at coldfusion.sql.Executive.executeQuery(Executive.java:1314)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425)
at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1250)
at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:877)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:822)
at cfcategory2ecfc73142977$funcDISPSIDENAVFILTER.runFunction(C:\websites\stratusecommerce\functions\category.cfc:1807)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:629)
at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:522)
at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:469)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:444)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:316)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503)
at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4137)
at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4100)
at cfdepartments2ecfm26623308.runPage(C:\websites\stratusecommerce\includes\views\departments.cfm:152)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5083)
at cfsidenav2ecfm48817863._factor36(C:\websites\stratusecommerce\includes\sidenav.cfm:82)
at cfsidenav2ecfm48817863.runPage(C:\websites\stratusecommerce\includes\sidenav.cfm:2)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5083)
at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:175)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5083)
at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:243)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:629)
at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:559)
at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:522)
at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:469)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:444)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:316)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503)
at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115)
at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:569)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43)
at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:162)
at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60)
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:231)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46)
at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357)
at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:448)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:936)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1190)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63)
at java.base/java.lang.Thread.run(Thread.java:842)
Suppressed
array[empty]
TagContext
array
1
struct
COLUMN
0
ID
??
LINE
1095
RAW_TRACE
at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1095)
TEMPLATE
|SQLServer|6.0.0.1282|
TYPE
CFML
2
struct
COLUMN
0
ID
CF_|SQLSERVER|6.0.0
LINE
980
RAW_TRACE
at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980)
TEMPLATE
|SQLServer|6.0.0.1282|
TYPE
CFML
3
struct
COLUMN
0
ID
CF_|SQLSERVER|6.0.0
LINE
1124
RAW_TRACE
at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124)
TEMPLATE
|SQLServer|6.0.0.1282|
TYPE
CFML
4
struct
COLUMN
0
ID
CF_|SQLSERVER|6.0.0
LINE
193
RAW_TRACE
at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193)
TEMPLATE
|SQLServer|6.0.0.1282|
TYPE
CFML
5
struct
COLUMN
0
ID
CF_|SQLSERVER|6.0.0
LINE
1153
RAW_TRACE
at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153)
TEMPLATE
|SQLServer|6.0.0.1282|
TYPE
CFML
6
struct
COLUMN
0
ID
CF_|SQLSERVER|6.0.0
LINE
4126
RAW_TRACE
at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126)
TEMPLATE
|SQLServer|6.0.0.1282|
TYPE
CFML
7
struct
COLUMN
0
ID
CF_|SQLSERVER|6.0.0
LINE
4275
RAW_TRACE
at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275)
TEMPLATE
|SQLServer|6.0.0.1282|
TYPE
CFML
8
struct
COLUMN
0
ID
CF_|SQLSERVER|6.0.0
LINE
2035
RAW_TRACE
at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035)
TEMPLATE
|SQLServer|6.0.0.1282|
TYPE
CFML
9
struct
COLUMN
0
ID
CF_|SQLSERVER|6.0.0
LINE
632
RAW_TRACE
at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632)
TEMPLATE
|SQLServer|6.0.0.1282|
TYPE
CFML
10
struct
COLUMN
0
ID
CF_|SQLSERVER|6.0.0
LINE
2699
RAW_TRACE
at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699)
TEMPLATE
|SQLServer|6.0.0.1282|
TYPE
CFML
11
struct
COLUMN
0
ID
CF_|SQLSERVER|6.0.0
LINE
2508
RAW_TRACE
at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508)
TEMPLATE
|SQLServer|6.0.0.1282|
TYPE
CFML
12
struct
COLUMN
0
ID
CF_|SQLSERVER|6.0.0
LINE
1358
RAW_TRACE
at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358)
TEMPLATE
|SQLServer|6.0.0.1282|
TYPE
CFML
13
struct
COLUMN
0
ID
CF_|SQLSERVER|6.0.0
LINE
4478
RAW_TRACE
at macromedia.jdbc.sqlserver.base.gr.execute(|SQLServer|6.0.0.1282|:4478)
TEMPLATE
|SQLServer|6.0.0.1282|
TYPE
CFML
14
struct
COLUMN
0
ID
CFQUERY
LINE
1807
RAW_TRACE
at cfcategory2ecfc73142977$funcDISPSIDENAVFILTER.runFunction(C:\websites\stratusecommerce\functions\category.cfc:1807)
at cfsidenav2ecfm48817863._factor36(C:\websites\stratusecommerce\includes\sidenav.cfm:82)
TEMPLATE
C:\websites\stratusecommerce\includes\sidenav.cfm
TYPE
CFML
17
struct
COLUMN
0
ID
CF_SIDENAV
LINE
2
RAW_TRACE
at cfsidenav2ecfm48817863.runPage(C:\websites\stratusecommerce\includes\sidenav.cfm:2)
TEMPLATE
C:\websites\stratusecommerce\includes\sidenav.cfm
TYPE
CFML
18
struct
COLUMN
0
ID
CFINCLUDE
LINE
175
RAW_TRACE
at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:175)
TEMPLATE
C:\websites\stratusecommerce\category.cfm
TYPE
CFML
19
struct
COLUMN
0
ID
CFINCLUDE
LINE
243
RAW_TRACE
at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:243)
TEMPLATE
C:\websites\stratusecommerce\application.cfc
TYPE
CFML
Type
java.sql.SQLTransactionRollbackException
SQLState
40001
Sql
SELECT a.typ as tax_name, a.web_url, a.sort_position, 0 as active, sum(b.taxCount) as itemcount
FROM tb_web_taxonomy a
inner join (Select count(style_id) as taxCount,dept,typ from web_all_products b where b.subtyp1='EMPTY' and b.typ<>'EMPTY' and b.dept='Firearms' group by b.dept, b.typ) b
on (upper(replace(a.typ,'''','')) = b.typ)
WHERE a.subtyp_1='EMPTY' and a.typ<>'EMPTY'
and a.dept='Firearms' and a.active=1
and a.site='1' Group by a.typ, a.web_url, a.sort_position ORDER BY a.sort_position
StackTrace
coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query.
at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:930)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:822)
at cfcategory2ecfc73142977$funcDISPSIDENAVFILTER.runFunction(C:\websites\stratusecommerce\functions\category.cfc:1807)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:629)
at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:522)
at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:469)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:444)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:316)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503)
at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4137)
at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4100)
at cfdepartments2ecfm26623308.runPage(C:\websites\stratusecommerce\includes\views\departments.cfm:152)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5083)
at cfsidenav2ecfm48817863._factor36(C:\websites\stratusecommerce\includes\sidenav.cfm:82)
at cfsidenav2ecfm48817863.runPage(C:\websites\stratusecommerce\includes\sidenav.cfm:2)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5083)
at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:175)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5083)
at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:243)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:629)
at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:559)
at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:522)
at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:469)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:444)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:316)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503)
at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115)
at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:569)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43)
at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:162)
at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60)
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:231)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46)
at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357)
at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:448)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:936)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1190)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63)
at java.base/java.lang.Thread.run(Thread.java:842)
Caused by: java.sql.SQLTransactionRollbackException: [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 156) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1095)
at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980)
at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124)
at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193)
at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153)
at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126)
at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275)
at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035)
at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632)
at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699)
at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508)
at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358)
at macromedia.jdbc.sqlserver.base.gr.execute(|SQLServer|6.0.0.1282|:4478)
at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359)
at coldfusion.sql.Executive.executeQuery(Executive.java:1642)
at coldfusion.sql.Executive.executeQuery(Executive.java:1384)
at coldfusion.sql.Executive.executeQuery(Executive.java:1314)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425)
at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1250)
at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:877)
... 81 more
Suppressed
array[empty]
TagContext
array
1
struct
COLUMN
0
ID
CFQUERY
LINE
1807
RAW_TRACE
at cfcategory2ecfc73142977$funcDISPSIDENAVFILTER.runFunction(C:\websites\stratusecommerce\functions\category.cfc:1807)
at cfsidenav2ecfm48817863._factor36(C:\websites\stratusecommerce\includes\sidenav.cfm:82)
TEMPLATE
C:\websites\stratusecommerce\includes\sidenav.cfm
TYPE
CFML
4
struct
COLUMN
0
ID
CF_SIDENAV
LINE
2
RAW_TRACE
at cfsidenav2ecfm48817863.runPage(C:\websites\stratusecommerce\includes\sidenav.cfm:2)
TEMPLATE
C:\websites\stratusecommerce\includes\sidenav.cfm
TYPE
CFML
5
struct
COLUMN
0
ID
CFINCLUDE
LINE
175
RAW_TRACE
at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:175)
TEMPLATE
C:\websites\stratusecommerce\category.cfm
TYPE
CFML
6
struct
COLUMN
0
ID
CFINCLUDE
LINE
243
RAW_TRACE
at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:243)
TEMPLATE
C:\websites\stratusecommerce\application.cfc
TYPE
CFML
7
struct
COLUMN
0
ID
??
LINE
1095
RAW_TRACE
at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1095)
TEMPLATE
|SQLServer|6.0.0.1282|
TYPE
CFML
8
struct
COLUMN
0
ID
CF_|SQLSERVER|6.0.0
LINE
980
RAW_TRACE
at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980)
TEMPLATE
|SQLServer|6.0.0.1282|
TYPE
CFML
9
struct
COLUMN
0
ID
CF_|SQLSERVER|6.0.0
LINE
1124
RAW_TRACE
at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124)
TEMPLATE
|SQLServer|6.0.0.1282|
TYPE
CFML
10
struct
COLUMN
0
ID
CF_|SQLSERVER|6.0.0
LINE
193
RAW_TRACE
at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193)
TEMPLATE
|SQLServer|6.0.0.1282|
TYPE
CFML
11
struct
COLUMN
0
ID
CF_|SQLSERVER|6.0.0
LINE
1153
RAW_TRACE
at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153)
TEMPLATE
|SQLServer|6.0.0.1282|
TYPE
CFML
12
struct
COLUMN
0
ID
CF_|SQLSERVER|6.0.0
LINE
4126
RAW_TRACE
at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126)
TEMPLATE
|SQLServer|6.0.0.1282|
TYPE
CFML
13
struct
COLUMN
0
ID
CF_|SQLSERVER|6.0.0
LINE
4275
RAW_TRACE
at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275)
TEMPLATE
|SQLServer|6.0.0.1282|
TYPE
CFML
14
struct
COLUMN
0
ID
CF_|SQLSERVER|6.0.0
LINE
2035
RAW_TRACE
at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035)
TEMPLATE
|SQLServer|6.0.0.1282|
TYPE
CFML
15
struct
COLUMN
0
ID
CF_|SQLSERVER|6.0.0
LINE
632
RAW_TRACE
at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632)
TEMPLATE
|SQLServer|6.0.0.1282|
TYPE
CFML
16
struct
COLUMN
0
ID
CF_|SQLSERVER|6.0.0
LINE
2699
RAW_TRACE
at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699)
TEMPLATE
|SQLServer|6.0.0.1282|
TYPE
CFML
17
struct
COLUMN
0
ID
CF_|SQLSERVER|6.0.0
LINE
2508
RAW_TRACE
at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508)
TEMPLATE
|SQLServer|6.0.0.1282|
TYPE
CFML
18
struct
COLUMN
0
ID
CF_|SQLSERVER|6.0.0
LINE
1358
RAW_TRACE
at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358)
TEMPLATE
|SQLServer|6.0.0.1282|
TYPE
CFML
19
struct
COLUMN
0
ID
CF_|SQLSERVER|6.0.0
LINE
4478
RAW_TRACE
at macromedia.jdbc.sqlserver.base.gr.execute(|SQLServer|6.0.0.1282|:4478)
TEMPLATE
|SQLServer|6.0.0.1282|
TYPE
CFML
Type
Database
queryError
[Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 156) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
where
[empty string]
Detail
An exception occurred while invoking an event handler method from Application.cfc. The method name is: onRequest.
Message
Event handler exception.
RootCause
struct
Cause
struct
ErrorCode
1205
Message
[Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 156) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
SQLState
40001
StackTrace
java.sql.SQLTransactionRollbackException: [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 156) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1095)
at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980)
at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124)
at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193)
at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153)
at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126)
at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275)
at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035)
at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632)
at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699)
at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508)
at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358)
at macromedia.jdbc.sqlserver.base.gr.execute(|SQLServer|6.0.0.1282|:4478)
at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359)
at coldfusion.sql.Executive.executeQuery(Executive.java:1642)
at coldfusion.sql.Executive.executeQuery(Executive.java:1384)
at coldfusion.sql.Executive.executeQuery(Executive.java:1314)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425)
at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1250)
at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:877)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:822)
at cfcategory2ecfc73142977$funcDISPSIDENAVFILTER.runFunction(C:\websites\stratusecommerce\functions\category.cfc:1807)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:629)
at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:522)
at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:469)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:444)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:316)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503)
at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4137)
at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4100)
at cfdepartments2ecfm26623308.runPage(C:\websites\stratusecommerce\includes\views\departments.cfm:152)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5083)
at cfsidenav2ecfm48817863._factor36(C:\websites\stratusecommerce\includes\sidenav.cfm:82)
at cfsidenav2ecfm48817863.runPage(C:\websites\stratusecommerce\includes\sidenav.cfm:2)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5083)
at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:175)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5083)
at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:243)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:629)
at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:559)
at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:522)
at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:469)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:444)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:316)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503)
at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115)
at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:569)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43)
at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:162)
at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60)
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:231)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46)
at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357)
at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:448)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:936)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1190)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63)
at java.base/java.lang.Thread.run(Thread.java:842)
Suppressed
array[empty]
TagContext
array
1
struct
COLUMN
0
ID
??
LINE
1095
RAW_TRACE
at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1095)
TEMPLATE
|SQLServer|6.0.0.1282|
TYPE
CFML
2
struct
COLUMN
0
ID
CF_|SQLSERVER|6.0.0
LINE
980
RAW_TRACE
at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980)
TEMPLATE
|SQLServer|6.0.0.1282|
TYPE
CFML
3
struct
COLUMN
0
ID
CF_|SQLSERVER|6.0.0
LINE
1124
RAW_TRACE
at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124)
TEMPLATE
|SQLServer|6.0.0.1282|
TYPE
CFML
4
struct
COLUMN
0
ID
CF_|SQLSERVER|6.0.0
LINE
193
RAW_TRACE
at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193)
TEMPLATE
|SQLServer|6.0.0.1282|
TYPE
CFML
5
struct
COLUMN
0
ID
CF_|SQLSERVER|6.0.0
LINE
1153
RAW_TRACE
at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153)
TEMPLATE
|SQLServer|6.0.0.1282|
TYPE
CFML
6
struct
COLUMN
0
ID
CF_|SQLSERVER|6.0.0
LINE
4126
RAW_TRACE
at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126)
TEMPLATE
|SQLServer|6.0.0.1282|
TYPE
CFML
7
struct
COLUMN
0
ID
CF_|SQLSERVER|6.0.0
LINE
4275
RAW_TRACE
at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275)
TEMPLATE
|SQLServer|6.0.0.1282|
TYPE
CFML
8
struct
COLUMN
0
ID
CF_|SQLSERVER|6.0.0
LINE
2035
RAW_TRACE
at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035)
TEMPLATE
|SQLServer|6.0.0.1282|
TYPE
CFML
9
struct
COLUMN
0
ID
CF_|SQLSERVER|6.0.0
LINE
632
RAW_TRACE
at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632)
TEMPLATE
|SQLServer|6.0.0.1282|
TYPE
CFML
10
struct
COLUMN
0
ID
CF_|SQLSERVER|6.0.0
LINE
2699
RAW_TRACE
at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699)
TEMPLATE
|SQLServer|6.0.0.1282|
TYPE
CFML
11
struct
COLUMN
0
ID
CF_|SQLSERVER|6.0.0
LINE
2508
RAW_TRACE
at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508)
TEMPLATE
|SQLServer|6.0.0.1282|
TYPE
CFML
12
struct
COLUMN
0
ID
CF_|SQLSERVER|6.0.0
LINE
1358
RAW_TRACE
at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358)
TEMPLATE
|SQLServer|6.0.0.1282|
TYPE
CFML
13
struct
COLUMN
0
ID
CF_|SQLSERVER|6.0.0
LINE
4478
RAW_TRACE
at macromedia.jdbc.sqlserver.base.gr.execute(|SQLServer|6.0.0.1282|:4478)
TEMPLATE
|SQLServer|6.0.0.1282|
TYPE
CFML
14
struct
COLUMN
0
ID
CFQUERY
LINE
1807
RAW_TRACE
at cfcategory2ecfc73142977$funcDISPSIDENAVFILTER.runFunction(C:\websites\stratusecommerce\functions\category.cfc:1807)
at cfsidenav2ecfm48817863._factor36(C:\websites\stratusecommerce\includes\sidenav.cfm:82)
TEMPLATE
C:\websites\stratusecommerce\includes\sidenav.cfm
TYPE
CFML
17
struct
COLUMN
0
ID
CF_SIDENAV
LINE
2
RAW_TRACE
at cfsidenav2ecfm48817863.runPage(C:\websites\stratusecommerce\includes\sidenav.cfm:2)
TEMPLATE
C:\websites\stratusecommerce\includes\sidenav.cfm
TYPE
CFML
18
struct
COLUMN
0
ID
CFINCLUDE
LINE
175
RAW_TRACE
at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:175)
TEMPLATE
C:\websites\stratusecommerce\category.cfm
TYPE
CFML
19
struct
COLUMN
0
ID
CFINCLUDE
LINE
243
RAW_TRACE
at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:243)
TEMPLATE
C:\websites\stratusecommerce\application.cfc
TYPE
CFML
Type
java.sql.SQLTransactionRollbackException
DataSource
koalasql
Detail
[Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 156) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
ErrorCode
40001
Exceptions
array
1
struct
class
java.sql.SQLTransactionRollbackException
message
[Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 156) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Message
Error Executing Database Query.
NativeErrorCode
1205
RootCause
struct
ErrorCode
1205
Message
[Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 156) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
SQLState
40001
StackTrace
java.sql.SQLTransactionRollbackException: [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 156) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1095)
at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980)
at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124)
at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193)
at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153)
at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126)
at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275)
at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035)
at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632)
at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699)
at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508)
at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358)
at macromedia.jdbc.sqlserver.base.gr.execute(|SQLServer|6.0.0.1282|:4478)
at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359)
at coldfusion.sql.Executive.executeQuery(Executive.java:1642)
at coldfusion.sql.Executive.executeQuery(Executive.java:1384)
at coldfusion.sql.Executive.executeQuery(Executive.java:1314)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425)
at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1250)
at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:877)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:822)
at cfcategory2ecfc73142977$funcDISPSIDENAVFILTER.runFunction(C:\websites\stratusecommerce\functions\category.cfc:1807)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:629)
at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:522)
at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:469)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:444)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:316)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503)
at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4137)
at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4100)
at cfdepartments2ecfm26623308.runPage(C:\websites\stratusecommerce\includes\views\departments.cfm:152)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5083)
at cfsidenav2ecfm48817863._factor36(C:\websites\stratusecommerce\includes\sidenav.cfm:82)
at cfsidenav2ecfm48817863.runPage(C:\websites\stratusecommerce\includes\sidenav.cfm:2)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5083)
at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:175)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5083)
at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:243)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:629)
at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:559)
at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:522)
at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:469)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:444)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:316)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503)
at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115)
at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:569)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43)
at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:162)
at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60)
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:231)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46)
at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357)
at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:448)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:936)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1190)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63)
at java.base/java.lang.Thread.run(Thread.java:842)
Suppressed
array[empty]
TagContext
array
1
struct
COLUMN
0
ID
??
LINE
1095
RAW_TRACE
at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1095)
TEMPLATE
|SQLServer|6.0.0.1282|
TYPE
CFML
2
struct
COLUMN
0
ID
CF_|SQLSERVER|6.0.0
LINE
980
RAW_TRACE
at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980)
TEMPLATE
|SQLServer|6.0.0.1282|
TYPE
CFML
3
struct
COLUMN
0
ID
CF_|SQLSERVER|6.0.0
LINE
1124
RAW_TRACE
at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124)
TEMPLATE
|SQLServer|6.0.0.1282|
TYPE
CFML
4
struct
COLUMN
0
ID
CF_|SQLSERVER|6.0.0
LINE
193
RAW_TRACE
at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193)
TEMPLATE
|SQLServer|6.0.0.1282|
TYPE
CFML
5
struct
COLUMN
0
ID
CF_|SQLSERVER|6.0.0
LINE
1153
RAW_TRACE
at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153)
TEMPLATE
|SQLServer|6.0.0.1282|
TYPE
CFML
6
struct
COLUMN
0
ID
CF_|SQLSERVER|6.0.0
LINE
4126
RAW_TRACE
at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126)
TEMPLATE
|SQLServer|6.0.0.1282|
TYPE
CFML
7
struct
COLUMN
0
ID
CF_|SQLSERVER|6.0.0
LINE
4275
RAW_TRACE
at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275)
TEMPLATE
|SQLServer|6.0.0.1282|
TYPE
CFML
8
struct
COLUMN
0
ID
CF_|SQLSERVER|6.0.0
LINE
2035
RAW_TRACE
at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035)
TEMPLATE
|SQLServer|6.0.0.1282|
TYPE
CFML
9
struct
COLUMN
0
ID
CF_|SQLSERVER|6.0.0
LINE
632
RAW_TRACE
at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632)
TEMPLATE
|SQLServer|6.0.0.1282|
TYPE
CFML
10
struct
COLUMN
0
ID
CF_|SQLSERVER|6.0.0
LINE
2699
RAW_TRACE
at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699)
TEMPLATE
|SQLServer|6.0.0.1282|
TYPE
CFML
11
struct
COLUMN
0
ID
CF_|SQLSERVER|6.0.0
LINE
2508
RAW_TRACE
at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508)
TEMPLATE
|SQLServer|6.0.0.1282|
TYPE
CFML
12
struct
COLUMN
0
ID
CF_|SQLSERVER|6.0.0
LINE
1358
RAW_TRACE
at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358)
TEMPLATE
|SQLServer|6.0.0.1282|
TYPE
CFML
13
struct
COLUMN
0
ID
CF_|SQLSERVER|6.0.0
LINE
4478
RAW_TRACE
at macromedia.jdbc.sqlserver.base.gr.execute(|SQLServer|6.0.0.1282|:4478)
TEMPLATE
|SQLServer|6.0.0.1282|
TYPE
CFML
14
struct
COLUMN
0
ID
CFQUERY
LINE
1807
RAW_TRACE
at cfcategory2ecfc73142977$funcDISPSIDENAVFILTER.runFunction(C:\websites\stratusecommerce\functions\category.cfc:1807)
at cfsidenav2ecfm48817863._factor36(C:\websites\stratusecommerce\includes\sidenav.cfm:82)
TEMPLATE
C:\websites\stratusecommerce\includes\sidenav.cfm
TYPE
CFML
17
struct
COLUMN
0
ID
CF_SIDENAV
LINE
2
RAW_TRACE
at cfsidenav2ecfm48817863.runPage(C:\websites\stratusecommerce\includes\sidenav.cfm:2)
TEMPLATE
C:\websites\stratusecommerce\includes\sidenav.cfm
TYPE
CFML
18
struct
COLUMN
0
ID
CFINCLUDE
LINE
175
RAW_TRACE
at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:175)
TEMPLATE
C:\websites\stratusecommerce\category.cfm
TYPE
CFML
19
struct
COLUMN
0
ID
CFINCLUDE
LINE
243
RAW_TRACE
at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:243)
TEMPLATE
C:\websites\stratusecommerce\application.cfc
TYPE
CFML
Type
java.sql.SQLTransactionRollbackException
SQLState
40001
Sql
SELECT a.typ as tax_name, a.web_url, a.sort_position, 0 as active, sum(b.taxCount) as itemcount
FROM tb_web_taxonomy a
inner join (Select count(style_id) as taxCount,dept,typ from web_all_products b where b.subtyp1='EMPTY' and b.typ<>'EMPTY' and b.dept='Firearms' group by b.dept, b.typ) b
on (upper(replace(a.typ,'''','')) = b.typ)
WHERE a.subtyp_1='EMPTY' and a.typ<>'EMPTY'
and a.dept='Firearms' and a.active=1
and a.site='1' Group by a.typ, a.web_url, a.sort_position ORDER BY a.sort_position
StackTrace
coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query.
at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:930)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:822)
at cfcategory2ecfc73142977$funcDISPSIDENAVFILTER.runFunction(C:\websites\stratusecommerce\functions\category.cfc:1807)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:629)
at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:522)
at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:469)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:444)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:316)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503)
at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4137)
at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4100)
at cfdepartments2ecfm26623308.runPage(C:\websites\stratusecommerce\includes\views\departments.cfm:152)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5083)
at cfsidenav2ecfm48817863._factor36(C:\websites\stratusecommerce\includes\sidenav.cfm:82)
at cfsidenav2ecfm48817863.runPage(C:\websites\stratusecommerce\includes\sidenav.cfm:2)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5083)
at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:175)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5083)
at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:243)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:629)
at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:559)
at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:522)
at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:469)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:444)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:316)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503)
at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115)
at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:569)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43)
at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:162)
at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60)
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:231)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46)
at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357)
at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:448)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:936)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1190)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63)
at java.base/java.lang.Thread.run(Thread.java:842)
Caused by: java.sql.SQLTransactionRollbackException: [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 156) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1095)
at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980)
at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124)
at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193)
at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153)
at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126)
at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275)
at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035)
at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632)
at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699)
at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508)
at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358)
at macromedia.jdbc.sqlserver.base.gr.execute(|SQLServer|6.0.0.1282|:4478)
at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359)
at coldfusion.sql.Executive.executeQuery(Executive.java:1642)
at coldfusion.sql.Executive.executeQuery(Executive.java:1384)
at coldfusion.sql.Executive.executeQuery(Executive.java:1314)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425)
at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1250)
at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:877)
... 81 more
Suppressed
array[empty]
TagContext
array
1
struct
COLUMN
0
ID
CFQUERY
LINE
1807
RAW_TRACE
at cfcategory2ecfc73142977$funcDISPSIDENAVFILTER.runFunction(C:\websites\stratusecommerce\functions\category.cfc:1807)
at cfsidenav2ecfm48817863._factor36(C:\websites\stratusecommerce\includes\sidenav.cfm:82)
TEMPLATE
C:\websites\stratusecommerce\includes\sidenav.cfm
TYPE
CFML
4
struct
COLUMN
0
ID
CF_SIDENAV
LINE
2
RAW_TRACE
at cfsidenav2ecfm48817863.runPage(C:\websites\stratusecommerce\includes\sidenav.cfm:2)
TEMPLATE
C:\websites\stratusecommerce\includes\sidenav.cfm
TYPE
CFML
5
struct
COLUMN
0
ID
CFINCLUDE
LINE
175
RAW_TRACE
at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:175)
TEMPLATE
C:\websites\stratusecommerce\category.cfm
TYPE
CFML
6
struct
COLUMN
0
ID
CFINCLUDE
LINE
243
RAW_TRACE
at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:243)
TEMPLATE
C:\websites\stratusecommerce\application.cfc
TYPE
CFML
7
struct
COLUMN
0
ID
??
LINE
1095
RAW_TRACE
at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1095)
TEMPLATE
|SQLServer|6.0.0.1282|
TYPE
CFML
8
struct
COLUMN
0
ID
CF_|SQLSERVER|6.0.0
LINE
980
RAW_TRACE
at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980)
TEMPLATE
|SQLServer|6.0.0.1282|
TYPE
CFML
9
struct
COLUMN
0
ID
CF_|SQLSERVER|6.0.0
LINE
1124
RAW_TRACE
at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124)
TEMPLATE
|SQLServer|6.0.0.1282|
TYPE
CFML
10
struct
COLUMN
0
ID
CF_|SQLSERVER|6.0.0
LINE
193
RAW_TRACE
at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193)
TEMPLATE
|SQLServer|6.0.0.1282|
TYPE
CFML
11
struct
COLUMN
0
ID
CF_|SQLSERVER|6.0.0
LINE
1153
RAW_TRACE
at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153)
TEMPLATE
|SQLServer|6.0.0.1282|
TYPE
CFML
12
struct
COLUMN
0
ID
CF_|SQLSERVER|6.0.0
LINE
4126
RAW_TRACE
at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126)
TEMPLATE
|SQLServer|6.0.0.1282|
TYPE
CFML
13
struct
COLUMN
0
ID
CF_|SQLSERVER|6.0.0
LINE
4275
RAW_TRACE
at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275)
TEMPLATE
|SQLServer|6.0.0.1282|
TYPE
CFML
14
struct
COLUMN
0
ID
CF_|SQLSERVER|6.0.0
LINE
2035
RAW_TRACE
at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035)
TEMPLATE
|SQLServer|6.0.0.1282|
TYPE
CFML
15
struct
COLUMN
0
ID
CF_|SQLSERVER|6.0.0
LINE
632
RAW_TRACE
at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632)
TEMPLATE
|SQLServer|6.0.0.1282|
TYPE
CFML
16
struct
COLUMN
0
ID
CF_|SQLSERVER|6.0.0
LINE
2699
RAW_TRACE
at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699)
TEMPLATE
|SQLServer|6.0.0.1282|
TYPE
CFML
17
struct
COLUMN
0
ID
CF_|SQLSERVER|6.0.0
LINE
2508
RAW_TRACE
at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508)
TEMPLATE
|SQLServer|6.0.0.1282|
TYPE
CFML
18
struct
COLUMN
0
ID
CF_|SQLSERVER|6.0.0
LINE
1358
RAW_TRACE
at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358)
TEMPLATE
|SQLServer|6.0.0.1282|
TYPE
CFML
19
struct
COLUMN
0
ID
CF_|SQLSERVER|6.0.0
LINE
4478
RAW_TRACE
at macromedia.jdbc.sqlserver.base.gr.execute(|SQLServer|6.0.0.1282|:4478)
TEMPLATE
|SQLServer|6.0.0.1282|
TYPE
CFML
Type
Database
queryError
[Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 156) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
where
[empty string]
StackTrace
coldfusion.runtime.EventHandlerException: Event handler exception.
at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:319)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:569)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43)
at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:162)
at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60)
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:231)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46)
at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357)
at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:448)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:936)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1190)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63)
at java.base/java.lang.Thread.run(Thread.java:842)
Caused by: coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query.
at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:930)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:822)
at cfcategory2ecfc73142977$funcDISPSIDENAVFILTER.runFunction(C:\websites\stratusecommerce\functions\category.cfc:1807)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:629)
at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:522)
at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:469)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:444)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:316)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503)
at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4137)
at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4100)
at cfdepartments2ecfm26623308.runPage(C:\websites\stratusecommerce\includes\views\departments.cfm:152)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5083)
at cfsidenav2ecfm48817863._factor36(C:\websites\stratusecommerce\includes\sidenav.cfm:82)
at cfsidenav2ecfm48817863.runPage(C:\websites\stratusecommerce\includes\sidenav.cfm:2)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5083)
at cfcategory2ecfm1745707752.runPage(C:\websites\stratusecommerce\category.cfm:175)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5083)
at cfapplication2ecfc592922610$funcONREQUEST.runFunction(C:\websites\stratusecommerce\application.cfc:243)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:629)
at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:559)
at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:522)
at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:469)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:444)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:316)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503)
at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115)
at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308)
... 39 more
Caused by: java.sql.SQLTransactionRollbackException: [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 156) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1095)
at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980)
at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124)
at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193)
at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153)
at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126)
at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275)
at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035)
at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632)
at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699)
at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508)
at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358)
at macromedia.jdbc.sqlserver.base.gr.execute(|SQLServer|6.0.0.1282|:4478)
at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359)
at coldfusion.sql.Executive.executeQuery(Executive.java:1642)
at coldfusion.sql.Executive.executeQuery(Executive.java:1384)
at coldfusion.sql.Executive.executeQuery(Executive.java:1314)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425)
at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1250)
at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:877)
... 81 more
Suppressed
array[empty]
TagContext
array
1
struct
COLUMN
0
ID
CFQUERY
LINE
1807
RAW_TRACE
at cfcategory2ecfc73142977$funcDISPSIDENAVFILTER.runFunction(C:\websites\stratusecommerce\functions\category.cfc:1807)