| struct |
|---|
| Cause |
| struct |
|---|
| ErrorCode |
1205
|
| Message |
[Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 58) 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 58) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
at macromedia.jdbc.sqlserverbase.BaseExceptions.b(BaseExceptions.java:1095)
at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:977)
at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:1124)
at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:193)
at macromedia.jdbc.sqlserver.tds.s.ct(TDSRequest.java:1153)
at macromedia.jdbc.sqlserver.tds.s.a(TDSRequest.java:4124)
at macromedia.jdbc.sqlserver.tds.r.a(TDSRPCRequest.java:1063)
at macromedia.jdbc.sqlserver.tds.s.c(TDSRequest.java:4273)
at macromedia.jdbc.sqlserver.bi.getNextResultType(SQLServerImplStatement.java:1895)
at macromedia.jdbc.sqlserverbase.go.bY(BaseStatement.java:632)
at macromedia.jdbc.sqlserverbase.go.B(BaseStatement.java:2661)
at macromedia.jdbc.sqlserverbase.fe.B(BasePreparedStatement.java:530)
at macromedia.jdbc.sqlserverbase.go.kx(BaseStatement.java:2470)
at macromedia.jdbc.sqlserverbase.go.kq(BaseStatement.java:1322)
at macromedia.jdbc.sqlserverbase.fe.$fr$execute(BasePreparedStatement.java:2656)
at macromedia.jdbc.sqlserverbase.fe.execute(BasePreparedStatement.java)
at macromedia.jdbc.sqlserverbase.fg.$fr$execute(BasePreparedStatementPoolable.java:525)
at macromedia.jdbc.sqlserverbase.fg.execute(BasePreparedStatementPoolable.java)
at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101)
at coldfusion.sql.Executive.executeQuery(Executive.java:1601)
at coldfusion.sql.Executive.executeQuery(Executive.java:1327)
at coldfusion.sql.Executive.executeQuery(Executive.java:1257)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425)
at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1247)
at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:876)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:821)
at cfxref2ecfc752622485$funcGETPOPULARPOST.runFunction(C:\inetpub\wwwroot\clients\production_frontend\com\xref.cfc:90)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:623)
at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47)
at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:553)
at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:516)
at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:463)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:438)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:310)
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:4254)
at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4217)
at cfpublications_detail2einc602028021._factor10(C:\inetpub\wwwroot\clients\production_frontend\includes\publications_detail.inc:19)
at cfpublications_detail2einc602028021._factor12(C:\inetpub\wwwroot\clients\production_frontend\includes\publications_detail.inc:1)
at cfpublications_detail2einc602028021.runPage(C:\inetpub\wwwroot\clients\production_frontend\includes\publications_detail.inc:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257)
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:5201)
at cfindex2ecfm1608311978.runPage(C:\inetpub\wwwroot\clients\production_frontend\index.cfm:18)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:573)
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:227)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
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:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at jdk.internal.reflect.GeneratedMethodAccessor119.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:134)
at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doNext(FusionReactorRequestHandler.java:772)
at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doHttpServletRequest(FusionReactorRequestHandler.java:344)
at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doFusionRequest(FusionReactorRequestHandler.java:207)
at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.handle(FusionReactorRequestHandler.java:809)
at com.intergral.fusionreactor.j2ee.filter.FusionReactorCoreFilter.doFilter(FusionReactorCoreFilter.java:36)
at jdk.internal.reflect.GeneratedMethodAccessor118.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:71)
at jdk.internal.reflect.GeneratedMethodAccessor109.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at com.intergral.fusionreactor.agent.filter.FusionReactorStaticFilter.doFilter(FusionReactorStaticFilter.java:54)
at com.intergral.fusionreactor.agent.pointcuts.NewFilterChainPointCut$1.invoke(NewFilterChainPointCut.java:42)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:377)
at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:463)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:889)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.base/java.lang.Thread.run(Thread.java:834)
|
| Suppressed |
|
| TagContext |
| array
|
|---|
| 1 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CFQUERY
|
| LINE |
90
|
| RAW_TRACE |
at cfxref2ecfc752622485$funcGETPOPULARPOST.runFunction(C:\inetpub\wwwroot\clients\production_frontend\com\xref.cfc:90)
|
| TEMPLATE |
C:\inetpub\wwwroot\clients\production_frontend\com\xref.cfc
|
| TYPE |
CFML
|
|
| 2 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CF_TEMPLATEPROXY
|
| LINE |
19
|
| RAW_TRACE |
at cfpublications_detail2einc602028021._factor10(C:\inetpub\wwwroot\clients\production_frontend\includes\publications_detail.inc:19)
|
| TEMPLATE |
C:\inetpub\wwwroot\clients\production_frontend\includes\publications_detail.inc
|
| TYPE |
CFML
|
|
| 3 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CF_PUBLICATIONS_DETAIL
|
| LINE |
1
|
| RAW_TRACE |
at cfpublications_detail2einc602028021._factor12(C:\inetpub\wwwroot\clients\production_frontend\includes\publications_detail.inc:1)
|
| TEMPLATE |
C:\inetpub\wwwroot\clients\production_frontend\includes\publications_detail.inc
|
| TYPE |
CFML
|
|
| 4 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CF_PUBLICATIONS_DETAIL
|
| LINE |
1
|
| RAW_TRACE |
at cfpublications_detail2einc602028021.runPage(C:\inetpub\wwwroot\clients\production_frontend\includes\publications_detail.inc:1)
|
| TEMPLATE |
C:\inetpub\wwwroot\clients\production_frontend\includes\publications_detail.inc
|
| TYPE |
CFML
|
|
| 5 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CFINCLUDE
|
| LINE |
18
|
| RAW_TRACE |
at cfindex2ecfm1608311978.runPage(C:\inetpub\wwwroot\clients\production_frontend\index.cfm:18)
|
| TEMPLATE |
C:\inetpub\wwwroot\clients\production_frontend\index.cfm
|
| TYPE |
CFML
|
|
|
| Type |
java.sql.SQLTransactionRollbackException
|
|
| DataSource |
Eurasia_production
|
| Detail |
[Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 58) 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 58) 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 58) 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 58) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
at macromedia.jdbc.sqlserverbase.BaseExceptions.b(BaseExceptions.java:1095)
at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:977)
at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:1124)
at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:193)
at macromedia.jdbc.sqlserver.tds.s.ct(TDSRequest.java:1153)
at macromedia.jdbc.sqlserver.tds.s.a(TDSRequest.java:4124)
at macromedia.jdbc.sqlserver.tds.r.a(TDSRPCRequest.java:1063)
at macromedia.jdbc.sqlserver.tds.s.c(TDSRequest.java:4273)
at macromedia.jdbc.sqlserver.bi.getNextResultType(SQLServerImplStatement.java:1895)
at macromedia.jdbc.sqlserverbase.go.bY(BaseStatement.java:632)
at macromedia.jdbc.sqlserverbase.go.B(BaseStatement.java:2661)
at macromedia.jdbc.sqlserverbase.fe.B(BasePreparedStatement.java:530)
at macromedia.jdbc.sqlserverbase.go.kx(BaseStatement.java:2470)
at macromedia.jdbc.sqlserverbase.go.kq(BaseStatement.java:1322)
at macromedia.jdbc.sqlserverbase.fe.$fr$execute(BasePreparedStatement.java:2656)
at macromedia.jdbc.sqlserverbase.fe.execute(BasePreparedStatement.java)
at macromedia.jdbc.sqlserverbase.fg.$fr$execute(BasePreparedStatementPoolable.java:525)
at macromedia.jdbc.sqlserverbase.fg.execute(BasePreparedStatementPoolable.java)
at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101)
at coldfusion.sql.Executive.executeQuery(Executive.java:1601)
at coldfusion.sql.Executive.executeQuery(Executive.java:1327)
at coldfusion.sql.Executive.executeQuery(Executive.java:1257)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425)
at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1247)
at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:876)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:821)
at cfxref2ecfc752622485$funcGETPOPULARPOST.runFunction(C:\inetpub\wwwroot\clients\production_frontend\com\xref.cfc:90)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:623)
at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47)
at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:553)
at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:516)
at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:463)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:438)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:310)
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:4254)
at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4217)
at cfpublications_detail2einc602028021._factor10(C:\inetpub\wwwroot\clients\production_frontend\includes\publications_detail.inc:19)
at cfpublications_detail2einc602028021._factor12(C:\inetpub\wwwroot\clients\production_frontend\includes\publications_detail.inc:1)
at cfpublications_detail2einc602028021.runPage(C:\inetpub\wwwroot\clients\production_frontend\includes\publications_detail.inc:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257)
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:5201)
at cfindex2ecfm1608311978.runPage(C:\inetpub\wwwroot\clients\production_frontend\index.cfm:18)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:573)
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:227)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
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:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at jdk.internal.reflect.GeneratedMethodAccessor119.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:134)
at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doNext(FusionReactorRequestHandler.java:772)
at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doHttpServletRequest(FusionReactorRequestHandler.java:344)
at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doFusionRequest(FusionReactorRequestHandler.java:207)
at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.handle(FusionReactorRequestHandler.java:809)
at com.intergral.fusionreactor.j2ee.filter.FusionReactorCoreFilter.doFilter(FusionReactorCoreFilter.java:36)
at jdk.internal.reflect.GeneratedMethodAccessor118.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:71)
at jdk.internal.reflect.GeneratedMethodAccessor109.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at com.intergral.fusionreactor.agent.filter.FusionReactorStaticFilter.doFilter(FusionReactorStaticFilter.java:54)
at com.intergral.fusionreactor.agent.pointcuts.NewFilterChainPointCut$1.invoke(NewFilterChainPointCut.java:42)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:377)
at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:463)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:889)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.base/java.lang.Thread.run(Thread.java:834)
|
| Suppressed |
|
| TagContext |
| array
|
|---|
| 1 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CFQUERY
|
| LINE |
90
|
| RAW_TRACE |
at cfxref2ecfc752622485$funcGETPOPULARPOST.runFunction(C:\inetpub\wwwroot\clients\production_frontend\com\xref.cfc:90)
|
| TEMPLATE |
C:\inetpub\wwwroot\clients\production_frontend\com\xref.cfc
|
| TYPE |
CFML
|
|
| 2 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CF_TEMPLATEPROXY
|
| LINE |
19
|
| RAW_TRACE |
at cfpublications_detail2einc602028021._factor10(C:\inetpub\wwwroot\clients\production_frontend\includes\publications_detail.inc:19)
|
| TEMPLATE |
C:\inetpub\wwwroot\clients\production_frontend\includes\publications_detail.inc
|
| TYPE |
CFML
|
|
| 3 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CF_PUBLICATIONS_DETAIL
|
| LINE |
1
|
| RAW_TRACE |
at cfpublications_detail2einc602028021._factor12(C:\inetpub\wwwroot\clients\production_frontend\includes\publications_detail.inc:1)
|
| TEMPLATE |
C:\inetpub\wwwroot\clients\production_frontend\includes\publications_detail.inc
|
| TYPE |
CFML
|
|
| 4 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CF_PUBLICATIONS_DETAIL
|
| LINE |
1
|
| RAW_TRACE |
at cfpublications_detail2einc602028021.runPage(C:\inetpub\wwwroot\clients\production_frontend\includes\publications_detail.inc:1)
|
| TEMPLATE |
C:\inetpub\wwwroot\clients\production_frontend\includes\publications_detail.inc
|
| TYPE |
CFML
|
|
| 5 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CFINCLUDE
|
| LINE |
18
|
| RAW_TRACE |
at cfindex2ecfm1608311978.runPage(C:\inetpub\wwwroot\clients\production_frontend\index.cfm:18)
|
| TEMPLATE |
C:\inetpub\wwwroot\clients\production_frontend\index.cfm
|
| TYPE |
CFML
|
|
|
| Type |
java.sql.SQLTransactionRollbackException
|
|
| SQLState |
40001
|
| Sql |
SELECT TOP(1) tp.thirtyDayTotal as hitCount, tp.livePostId,
DATEADD(d, -1, DATEDIFF(d, 0, GETDATE())), DATEADD(d, 0, DATEDIFF(d, 0, GETDATE())),
p.title, ps.friendly_url as urlSlug, dbo.udf_GetFile(p.pubID,10,18,1) as fileName, dbo.udf_GetFileWindow(p.pubID,10,18,1) as fileWindow
FROM XREF_livepost_dateTotals tp
INNER JOIN pubIndex p
ON p.pubID = livePostID
AND p.audio_video=1
AND p.itemType = (param 1)
AND p.pubID != (param 2)
AND EXISTS (
SELECT TOP(1) sl.sourceID
FROM siteLink_Index sl
WHERE sl.sourceID = p.pubID
AND sl.targetID IN( (param 3) , (param 4) )
AND sl.itemContent = 10
AND sl.itemType = 163
)
INNER JOIN slugIndex ps
ON ps.itemID = p.pubID
AND ps.pageID=34
AND ps.editStatus=0
WHERE tp.StatDate = (SELECT TOP(1) tpd.StatDate FROM XREF_livepost_dateTotals tpd WHERE tpd.livePostID = tp.livePostID ORDER BY tpd.StatDate DESC)
ORDER BY tp.thirtyDayTotal desc
|
| StackTrace |
coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query.
at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:929)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:821)
at cfxref2ecfc752622485$funcGETPOPULARPOST.runFunction(C:\inetpub\wwwroot\clients\production_frontend\com\xref.cfc:90)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:623)
at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47)
at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:553)
at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:516)
at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:463)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:438)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:310)
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:4254)
at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4217)
at cfpublications_detail2einc602028021._factor10(C:\inetpub\wwwroot\clients\production_frontend\includes\publications_detail.inc:19)
at cfpublications_detail2einc602028021._factor12(C:\inetpub\wwwroot\clients\production_frontend\includes\publications_detail.inc:1)
at cfpublications_detail2einc602028021.runPage(C:\inetpub\wwwroot\clients\production_frontend\includes\publications_detail.inc:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257)
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:5201)
at cfindex2ecfm1608311978.runPage(C:\inetpub\wwwroot\clients\production_frontend\index.cfm:18)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:573)
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:227)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
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:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at jdk.internal.reflect.GeneratedMethodAccessor119.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:134)
at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doNext(FusionReactorRequestHandler.java:772)
at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doHttpServletRequest(FusionReactorRequestHandler.java:344)
at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doFusionRequest(FusionReactorRequestHandler.java:207)
at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.handle(FusionReactorRequestHandler.java:809)
at com.intergral.fusionreactor.j2ee.filter.FusionReactorCoreFilter.doFilter(FusionReactorCoreFilter.java:36)
at jdk.internal.reflect.GeneratedMethodAccessor118.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:71)
at jdk.internal.reflect.GeneratedMethodAccessor109.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at com.intergral.fusionreactor.agent.filter.FusionReactorStaticFilter.doFilter(FusionReactorStaticFilter.java:54)
at com.intergral.fusionreactor.agent.pointcuts.NewFilterChainPointCut$1.invoke(NewFilterChainPointCut.java:42)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:377)
at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:463)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:889)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: java.sql.SQLTransactionRollbackException: [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 58) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
at macromedia.jdbc.sqlserverbase.BaseExceptions.b(BaseExceptions.java:1095)
at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:977)
at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:1124)
at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:193)
at macromedia.jdbc.sqlserver.tds.s.ct(TDSRequest.java:1153)
at macromedia.jdbc.sqlserver.tds.s.a(TDSRequest.java:4124)
at macromedia.jdbc.sqlserver.tds.r.a(TDSRPCRequest.java:1063)
at macromedia.jdbc.sqlserver.tds.s.c(TDSRequest.java:4273)
at macromedia.jdbc.sqlserver.bi.getNextResultType(SQLServerImplStatement.java:1895)
at macromedia.jdbc.sqlserverbase.go.bY(BaseStatement.java:632)
at macromedia.jdbc.sqlserverbase.go.B(BaseStatement.java:2661)
at macromedia.jdbc.sqlserverbase.fe.B(BasePreparedStatement.java:530)
at macromedia.jdbc.sqlserverbase.go.kx(BaseStatement.java:2470)
at macromedia.jdbc.sqlserverbase.go.kq(BaseStatement.java:1322)
at macromedia.jdbc.sqlserverbase.fe.$fr$execute(BasePreparedStatement.java:2656)
at macromedia.jdbc.sqlserverbase.fe.execute(BasePreparedStatement.java)
at macromedia.jdbc.sqlserverbase.fg.$fr$execute(BasePreparedStatementPoolable.java:525)
at macromedia.jdbc.sqlserverbase.fg.execute(BasePreparedStatementPoolable.java)
at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101)
at coldfusion.sql.Executive.executeQuery(Executive.java:1601)
at coldfusion.sql.Executive.executeQuery(Executive.java:1327)
at coldfusion.sql.Executive.executeQuery(Executive.java:1257)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425)
at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1247)
at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:876)
... 85 more
|
| Suppressed |
|
| TagContext |
| array
|
|---|
| 1 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CFQUERY
|
| LINE |
90
|
| RAW_TRACE |
at cfxref2ecfc752622485$funcGETPOPULARPOST.runFunction(C:\inetpub\wwwroot\clients\production_frontend\com\xref.cfc:90)
|
| TEMPLATE |
C:\inetpub\wwwroot\clients\production_frontend\com\xref.cfc
|
| TYPE |
CFML
|
|
| 2 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CF_TEMPLATEPROXY
|
| LINE |
19
|
| RAW_TRACE |
at cfpublications_detail2einc602028021._factor10(C:\inetpub\wwwroot\clients\production_frontend\includes\publications_detail.inc:19)
|
| TEMPLATE |
C:\inetpub\wwwroot\clients\production_frontend\includes\publications_detail.inc
|
| TYPE |
CFML
|
|
| 3 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CF_PUBLICATIONS_DETAIL
|
| LINE |
1
|
| RAW_TRACE |
at cfpublications_detail2einc602028021._factor12(C:\inetpub\wwwroot\clients\production_frontend\includes\publications_detail.inc:1)
|
| TEMPLATE |
C:\inetpub\wwwroot\clients\production_frontend\includes\publications_detail.inc
|
| TYPE |
CFML
|
|
| 4 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CF_PUBLICATIONS_DETAIL
|
| LINE |
1
|
| RAW_TRACE |
at cfpublications_detail2einc602028021.runPage(C:\inetpub\wwwroot\clients\production_frontend\includes\publications_detail.inc:1)
|
| TEMPLATE |
C:\inetpub\wwwroot\clients\production_frontend\includes\publications_detail.inc
|
| TYPE |
CFML
|
|
| 5 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CFINCLUDE
|
| LINE |
18
|
| RAW_TRACE |
at cfindex2ecfm1608311978.runPage(C:\inetpub\wwwroot\clients\production_frontend\index.cfm:18)
|
| TEMPLATE |
C:\inetpub\wwwroot\clients\production_frontend\index.cfm
|
| TYPE |
CFML
|
|
|
| Type |
Database
|
| queryError |
[Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 58) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
|
| where |
(param 1) = [type='IN', class='java.lang.Integer', value='1', sqltype='CF_SQL_INTEGER'] , (param 2) = [type='IN', class='java.lang.Integer', value='2906', sqltype='CF_SQL_INTEGER'] , (param 3) = [type='IN', class='java.lang.Integer', value='144', sqltype='CF_SQL_INTEGER'] , (param 4) = [type='IN', class='java.lang.Integer', value='134', sqltype='CF_SQL_INTEGER']
|
