| struct |
|---|
| Cause |
| struct |
|---|
| ErrorCode |
1205
|
| Message |
[Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 330) was deadlocked on lock | communication buffer 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 330) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
at macromedia.jdbc.sqlserverbase.dda4.b(Unknown Source)
at macromedia.jdbc.sqlserverbase.dda4.a(Unknown Source)
at macromedia.jdbc.sqlserverbase.dda3.b(Unknown Source)
at macromedia.jdbc.sqlserverbase.dda3.a(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source)
at macromedia.jdbc.sqlserver.ddj.l(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddde.e(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddde.a(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddde.v(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddde.r(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddde.execute(Unknown Source)
at com.seefusion.ae.execute(ae.java:379)
at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:348)
at coldfusion.sql.Executive.executeQuery(Executive.java:1364)
at coldfusion.sql.Executive.executeQuery(Executive.java:1127)
at coldfusion.sql.Executive.executeQuery(Executive.java:1058)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341)
at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:915)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:590)
at cfarticles2ecfm244554443._factor12(D:\websites\hellometro\rss\articles.cfm:112)
at cfarticles2ecfm244554443._factor14(D:\websites\hellometro\rss\articles.cfm:9)
at cfarticles2ecfm244554443.runPage(D:\websites\hellometro\rss\articles.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:381)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)
at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:94)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62)
at coldfusion.CfmServlet.service(CfmServlet.java:200)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
at jrun.servlet.FilterChain.doFilter(FilterChain.java:86)
at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
at jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
at com.seefusion.Filter.doFilter(Filter.java:49)
at com.seefusion.SeeFusion.doFilter(SeeFusion.java:1500)
at jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
at jrun.servlet.FilterChain.service(FilterChain.java:101)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286)
at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543)
at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203)
at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320)
at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428)
at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
|
| TagContext |
| array
|
|---|
| 1 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CFQUERY
|
| LINE |
112
|
| RAW_TRACE |
at cfarticles2ecfm244554443._factor12(D:\websites\hellometro\rss\articles.cfm:112)
|
| TEMPLATE |
D:\websites\hellometro\rss\articles.cfm
|
| TYPE |
CFML
|
|
| 2 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CF_ARTICLES
|
| LINE |
9
|
| RAW_TRACE |
at cfarticles2ecfm244554443._factor14(D:\websites\hellometro\rss\articles.cfm:9)
|
| TEMPLATE |
D:\websites\hellometro\rss\articles.cfm
|
| TYPE |
CFML
|
|
| 3 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CF_ARTICLES
|
| LINE |
1
|
| RAW_TRACE |
at cfarticles2ecfm244554443.runPage(D:\websites\hellometro\rss\articles.cfm:1)
|
| TEMPLATE |
D:\websites\hellometro\rss\articles.cfm
|
| TYPE |
CFML
|
|
|
| Type |
java.sql.SQLTransactionRollbackException
|
|
| DataSource |
write
|
| Detail |
[Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 330) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
|
| ErrorCode |
40001
|
| Message |
Error Executing Database Query.
|
| NativeErrorCode |
1205
|
| RootCause |
| struct |
|---|
| ErrorCode |
1205
|
| Message |
[Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 330) was deadlocked on lock | communication buffer 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 330) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
at macromedia.jdbc.sqlserverbase.dda4.b(Unknown Source)
at macromedia.jdbc.sqlserverbase.dda4.a(Unknown Source)
at macromedia.jdbc.sqlserverbase.dda3.b(Unknown Source)
at macromedia.jdbc.sqlserverbase.dda3.a(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source)
at macromedia.jdbc.sqlserver.ddj.l(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddde.e(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddde.a(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddde.v(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddde.r(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddde.execute(Unknown Source)
at com.seefusion.ae.execute(ae.java:379)
at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:348)
at coldfusion.sql.Executive.executeQuery(Executive.java:1364)
at coldfusion.sql.Executive.executeQuery(Executive.java:1127)
at coldfusion.sql.Executive.executeQuery(Executive.java:1058)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341)
at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:915)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:590)
at cfarticles2ecfm244554443._factor12(D:\websites\hellometro\rss\articles.cfm:112)
at cfarticles2ecfm244554443._factor14(D:\websites\hellometro\rss\articles.cfm:9)
at cfarticles2ecfm244554443.runPage(D:\websites\hellometro\rss\articles.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:381)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)
at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:94)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62)
at coldfusion.CfmServlet.service(CfmServlet.java:200)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
at jrun.servlet.FilterChain.doFilter(FilterChain.java:86)
at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
at jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
at com.seefusion.Filter.doFilter(Filter.java:49)
at com.seefusion.SeeFusion.doFilter(SeeFusion.java:1500)
at jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
at jrun.servlet.FilterChain.service(FilterChain.java:101)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286)
at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543)
at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203)
at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320)
at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428)
at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
|
| TagContext |
| array
|
|---|
| 1 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CFQUERY
|
| LINE |
112
|
| RAW_TRACE |
at cfarticles2ecfm244554443._factor12(D:\websites\hellometro\rss\articles.cfm:112)
|
| TEMPLATE |
D:\websites\hellometro\rss\articles.cfm
|
| TYPE |
CFML
|
|
| 2 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CF_ARTICLES
|
| LINE |
9
|
| RAW_TRACE |
at cfarticles2ecfm244554443._factor14(D:\websites\hellometro\rss\articles.cfm:9)
|
| TEMPLATE |
D:\websites\hellometro\rss\articles.cfm
|
| TYPE |
CFML
|
|
| 3 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CF_ARTICLES
|
| LINE |
1
|
| RAW_TRACE |
at cfarticles2ecfm244554443.runPage(D:\websites\hellometro\rss\articles.cfm:1)
|
| TEMPLATE |
D:\websites\hellometro\rss\articles.cfm
|
| TYPE |
CFML
|
|
|
| Type |
java.sql.SQLTransactionRollbackException
|
|
| SQLState |
40001
|
| Sql |
delete from articles.dbo.qanda_facebook
where id not in(
select distinct id
from articles.dbo.qanda with(nolock)
)
|
| StackTrace |
coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query.
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:641)
at cfarticles2ecfm244554443._factor12(D:\websites\hellometro\rss\articles.cfm:112)
at cfarticles2ecfm244554443._factor14(D:\websites\hellometro\rss\articles.cfm:9)
at cfarticles2ecfm244554443.runPage(D:\websites\hellometro\rss\articles.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:381)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)
at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:94)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62)
at coldfusion.CfmServlet.service(CfmServlet.java:200)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
at jrun.servlet.FilterChain.doFilter(FilterChain.java:86)
at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
at jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
at com.seefusion.Filter.doFilter(Filter.java:49)
at com.seefusion.SeeFusion.doFilter(SeeFusion.java:1500)
at jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
at jrun.servlet.FilterChain.service(FilterChain.java:101)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286)
at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543)
at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203)
at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320)
at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428)
at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
Caused by: java.sql.SQLTransactionRollbackException: [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 330) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
at macromedia.jdbc.sqlserverbase.dda4.b(Unknown Source)
at macromedia.jdbc.sqlserverbase.dda4.a(Unknown Source)
at macromedia.jdbc.sqlserverbase.dda3.b(Unknown Source)
at macromedia.jdbc.sqlserverbase.dda3.a(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source)
at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source)
at macromedia.jdbc.sqlserver.ddj.l(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddde.e(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddde.a(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddde.v(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddde.r(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddde.execute(Unknown Source)
at com.seefusion.ae.execute(ae.java:379)
at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:348)
at coldfusion.sql.Executive.executeQuery(Executive.java:1364)
at coldfusion.sql.Executive.executeQuery(Executive.java:1127)
at coldfusion.sql.Executive.executeQuery(Executive.java:1058)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341)
at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:915)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:590)
... 36 more
|
| TagContext |
| array
|
|---|
| 1 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CFQUERY
|
| LINE |
112
|
| RAW_TRACE |
at cfarticles2ecfm244554443._factor12(D:\websites\hellometro\rss\articles.cfm:112)
|
| TEMPLATE |
D:\websites\hellometro\rss\articles.cfm
|
| TYPE |
CFML
|
|
| 2 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CF_ARTICLES
|
| LINE |
9
|
| RAW_TRACE |
at cfarticles2ecfm244554443._factor14(D:\websites\hellometro\rss\articles.cfm:9)
|
| TEMPLATE |
D:\websites\hellometro\rss\articles.cfm
|
| TYPE |
CFML
|
|
| 3 |
| struct |
|---|
| COLUMN |
0
|
| ID |
CF_ARTICLES
|
| LINE |
1
|
| RAW_TRACE |
at cfarticles2ecfm244554443.runPage(D:\websites\hellometro\rss\articles.cfm:1)
|
| TEMPLATE |
D:\websites\hellometro\rss\articles.cfm
|
| TYPE |
CFML
|
|
|
| Type |
Database
|
| queryError |
[Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 330) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
|
| where |
[empty string]
|