| struct |
| Cause |
| struct |
| ErrorCode |
1205
|
| Message |
[Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 68) 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 68) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
at macromedia.jdbc.sqlserverbase.ddcw.b(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddcw.a(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddcv.b(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddcv.a(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddq.a(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddr.c(Unknown Source)
at macromedia.jdbc.sqlserver.dda3.m(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.e(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.a(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddd2.a(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.x(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.t(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddd2.execute(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddd6.execute(Unknown Source)
at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101)
at coldfusion.sql.Executive.executeQuery(Executive.java:1501)
at coldfusion.sql.Executive.executeQuery(Executive.java:1235)
at coldfusion.sql.Executive.executeQuery(Executive.java:1165)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406)
at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1187)
at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:816)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:769)
at cfinfo2ecfm377022822._factor9(D:\inetpub\sajha.com\mobile\info.cfm:94)
at cfinfo2ecfm377022822._factor15(D:\inetpub\sajha.com\mobile\info.cfm:20)
at cfinfo2ecfm377022822.runPage(D:\inetpub\sajha.com\mobile\info.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:246)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:495)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:42)
at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:153)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:58)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62)
at coldfusion.CfmServlet.service(CfmServlet.java:219)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:218)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:506)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:466)
at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:197)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)
|
| Suppressed |
|
| TagContext |
| array
|
| 1 |
| struct |
| COLUMN |
0
|
| ID |
CFQUERY
|
| LINE |
94
|
| RAW_TRACE |
at cfinfo2ecfm377022822._factor9(D:\inetpub\sajha.com\mobile\info.cfm:94)
|
| TEMPLATE |
D:\inetpub\sajha.com\mobile\info.cfm
|
| TYPE |
CFML
|
|
| 2 |
| struct |
| COLUMN |
0
|
| ID |
CF_INFO
|
| LINE |
20
|
| RAW_TRACE |
at cfinfo2ecfm377022822._factor15(D:\inetpub\sajha.com\mobile\info.cfm:20)
|
| TEMPLATE |
D:\inetpub\sajha.com\mobile\info.cfm
|
| TYPE |
CFML
|
|
| 3 |
| struct |
| COLUMN |
0
|
| ID |
CF_INFO
|
| LINE |
1
|
| RAW_TRACE |
at cfinfo2ecfm377022822.runPage(D:\inetpub\sajha.com\mobile\info.cfm:1)
|
| TEMPLATE |
D:\inetpub\sajha.com\mobile\info.cfm
|
| TYPE |
CFML
|
|
|
| Type |
java.sql.SQLTransactionRollbackException
|
|
| DataSource |
sajhalocal
|
| Detail |
[Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 68) 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 68) 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 68) 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 68) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
at macromedia.jdbc.sqlserverbase.ddcw.b(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddcw.a(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddcv.b(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddcv.a(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddq.a(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddr.c(Unknown Source)
at macromedia.jdbc.sqlserver.dda3.m(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.e(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.a(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddd2.a(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.x(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.t(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddd2.execute(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddd6.execute(Unknown Source)
at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101)
at coldfusion.sql.Executive.executeQuery(Executive.java:1501)
at coldfusion.sql.Executive.executeQuery(Executive.java:1235)
at coldfusion.sql.Executive.executeQuery(Executive.java:1165)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406)
at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1187)
at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:816)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:769)
at cfinfo2ecfm377022822._factor9(D:\inetpub\sajha.com\mobile\info.cfm:94)
at cfinfo2ecfm377022822._factor15(D:\inetpub\sajha.com\mobile\info.cfm:20)
at cfinfo2ecfm377022822.runPage(D:\inetpub\sajha.com\mobile\info.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:246)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:495)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:42)
at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:153)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:58)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62)
at coldfusion.CfmServlet.service(CfmServlet.java:219)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:218)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:506)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:466)
at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:197)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)
|
| Suppressed |
|
| TagContext |
| array
|
| 1 |
| struct |
| COLUMN |
0
|
| ID |
CFQUERY
|
| LINE |
94
|
| RAW_TRACE |
at cfinfo2ecfm377022822._factor9(D:\inetpub\sajha.com\mobile\info.cfm:94)
|
| TEMPLATE |
D:\inetpub\sajha.com\mobile\info.cfm
|
| TYPE |
CFML
|
|
| 2 |
| struct |
| COLUMN |
0
|
| ID |
CF_INFO
|
| LINE |
20
|
| RAW_TRACE |
at cfinfo2ecfm377022822._factor15(D:\inetpub\sajha.com\mobile\info.cfm:20)
|
| TEMPLATE |
D:\inetpub\sajha.com\mobile\info.cfm
|
| TYPE |
CFML
|
|
| 3 |
| struct |
| COLUMN |
0
|
| ID |
CF_INFO
|
| LINE |
1
|
| RAW_TRACE |
at cfinfo2ecfm377022822.runPage(D:\inetpub\sajha.com\mobile\info.cfm:1)
|
| TEMPLATE |
D:\inetpub\sajha.com\mobile\info.cfm
|
| TYPE |
CFML
|
|
|
| Type |
java.sql.SQLTransactionRollbackException
|
|
| SQLState |
40001
|
| Sql |
SELECT dbo.tblThreads.ThreadName, dbo.tblThreads.UserName, dbo.tblThreads.GroupID, dbo.thread_image.imageurl, dbo.thread_image.threadinfo, dbo.tblthreads.noads, tblthreads.extra
FROM dbo.tblThreads LEFT OUTER JOIN
dbo.thread_image ON dbo.tblThreads.ThreadID = dbo.thread_image.threadid
where tblthreads.threadid = (param 1)
|
| StackTrace |
coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query.
at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:867)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:769)
at cfinfo2ecfm377022822._factor9(D:\inetpub\sajha.com\mobile\info.cfm:94)
at cfinfo2ecfm377022822._factor15(D:\inetpub\sajha.com\mobile\info.cfm:20)
at cfinfo2ecfm377022822.runPage(D:\inetpub\sajha.com\mobile\info.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:246)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:495)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:42)
at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:153)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:58)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62)
at coldfusion.CfmServlet.service(CfmServlet.java:219)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:218)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:506)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:466)
at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:197)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.sql.SQLTransactionRollbackException: [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 68) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
at macromedia.jdbc.sqlserverbase.ddcw.b(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddcw.a(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddcv.b(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddcv.a(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddq.a(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddr.c(Unknown Source)
at macromedia.jdbc.sqlserver.dda3.m(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.e(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.a(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddd2.a(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.x(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.t(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddd2.execute(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddd6.execute(Unknown Source)
at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101)
at coldfusion.sql.Executive.executeQuery(Executive.java:1501)
at coldfusion.sql.Executive.executeQuery(Executive.java:1235)
at coldfusion.sql.Executive.executeQuery(Executive.java:1165)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406)
at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1187)
at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:816)
... 42 more
|
| Suppressed |
|
| TagContext |
| array
|
| 1 |
| struct |
| COLUMN |
0
|
| ID |
CFQUERY
|
| LINE |
94
|
| RAW_TRACE |
at cfinfo2ecfm377022822._factor9(D:\inetpub\sajha.com\mobile\info.cfm:94)
|
| TEMPLATE |
D:\inetpub\sajha.com\mobile\info.cfm
|
| TYPE |
CFML
|
|
| 2 |
| struct |
| COLUMN |
0
|
| ID |
CF_INFO
|
| LINE |
20
|
| RAW_TRACE |
at cfinfo2ecfm377022822._factor15(D:\inetpub\sajha.com\mobile\info.cfm:20)
|
| TEMPLATE |
D:\inetpub\sajha.com\mobile\info.cfm
|
| TYPE |
CFML
|
|
| 3 |
| struct |
| COLUMN |
0
|
| ID |
CF_INFO
|
| LINE |
1
|
| RAW_TRACE |
at cfinfo2ecfm377022822.runPage(D:\inetpub\sajha.com\mobile\info.cfm:1)
|
| TEMPLATE |
D:\inetpub\sajha.com\mobile\info.cfm
|
| TYPE |
CFML
|
|
|
| Type |
Database
|
| queryError |
[Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 68) 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='142413', sqltype='cf_sql_integer']
|