SAJHA.COM - Bringing Together Nepali Communities

[Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 57) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

SQLState

40001

StackTrace

java.sql.SQLTransactionRollbackException: [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 57) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. at macromedia.jdbc.sqlserverbase.ddcw.b(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcw.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcv.b(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcv.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.c(Unknown Source) at macromedia.jdbc.sqlserver.dda3.m(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.e(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.a(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.x(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.t(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359) at coldfusion.sql.Executive.executeQuery(Executive.java:1485) at coldfusion.sql.Executive.executeQuery(Executive.java:1235) at coldfusion.sql.Executive.executeQuery(Executive.java:1165) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1187) at coldfusion.tagext.sql.QueryTag.setupCachedQuery(QueryTag.java:1121) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:808) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:769) at cfshowforums2ecfm458093337.runPage(D:\inetpub\sajha.com\sajha\html\showforums.cfm:30) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:246) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3000) at cfnepalregion12ecfm233701571._factor0(D:\inetpub\sajha.com\sajha\html\nepalregion1.cfm:107) at cfnepalregion12ecfm233701571.runPage(D:\inetpub\sajha.com\sajha\html\nepalregion1.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:246) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3000) at cfindex2ecfm394747199.runPage(D:\inetpub\sajha.com\sajha\html\index.cfm:731) 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:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745)

Suppressed

array [empty]

TagContext

array

struct
COLUMN	0
ID	CFQUERY
LINE	30
RAW_TRACE	at cfshowforums2ecfm458093337.runPage(D:\inetpub\sajha.com\sajha\html\showforums.cfm:30)
TEMPLATE	D:\inetpub\sajha.com\sajha\html\showforums.cfm
TYPE	CFML

struct
COLUMN	0
ID	CFINCLUDE
LINE	107
RAW_TRACE	at cfnepalregion12ecfm233701571._factor0(D:\inetpub\sajha.com\sajha\html\nepalregion1.cfm:107)
TEMPLATE	D:\inetpub\sajha.com\sajha\html\nepalregion1.cfm
TYPE	CFML

struct
COLUMN	0
ID	CF_NEPALREGION1
LINE	1
RAW_TRACE	at cfnepalregion12ecfm233701571.runPage(D:\inetpub\sajha.com\sajha\html\nepalregion1.cfm:1)
TEMPLATE	D:\inetpub\sajha.com\sajha\html\nepalregion1.cfm
TYPE	CFML

struct
COLUMN	0
ID	CFINCLUDE
LINE	731
RAW_TRACE	at cfindex2ecfm394747199.runPage(D:\inetpub\sajha.com\sajha\html\index.cfm:731)
TEMPLATE	D:\inetpub\sajha.com\sajha\html\index.cfm
TYPE	CFML

Type

java.sql.SQLTransactionRollbackException

DataSource

sajhalocal

Detail

[Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 57) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

ErrorCode

40001

Exceptions

array

struct
class	java.sql.SQLTransactionRollbackException
message	[Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 57) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

Message

Error Executing Database Query.

NativeErrorCode

1205

RootCause

struct

ErrorCode

1205

Message

[Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 57) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

SQLState

40001

StackTrace

Suppressed

array [empty]

TagContext

array

struct
COLUMN	0
ID	CFQUERY
LINE	30
RAW_TRACE	at cfshowforums2ecfm458093337.runPage(D:\inetpub\sajha.com\sajha\html\showforums.cfm:30)
TEMPLATE	D:\inetpub\sajha.com\sajha\html\showforums.cfm
TYPE	CFML

struct
COLUMN	0
ID	CFINCLUDE
LINE	107
RAW_TRACE	at cfnepalregion12ecfm233701571._factor0(D:\inetpub\sajha.com\sajha\html\nepalregion1.cfm:107)
TEMPLATE	D:\inetpub\sajha.com\sajha\html\nepalregion1.cfm
TYPE	CFML

struct
COLUMN	0
ID	CF_NEPALREGION1
LINE	1
RAW_TRACE	at cfnepalregion12ecfm233701571.runPage(D:\inetpub\sajha.com\sajha\html\nepalregion1.cfm:1)
TEMPLATE	D:\inetpub\sajha.com\sajha\html\nepalregion1.cfm
TYPE	CFML

struct
COLUMN	0
ID	CFINCLUDE
LINE	731
RAW_TRACE	at cfindex2ecfm394747199.runPage(D:\inetpub\sajha.com\sajha\html\index.cfm:731)
TEMPLATE	D:\inetpub\sajha.com\sajha\html\index.cfm
TYPE	CFML

Type

java.sql.SQLTransactionRollbackException

SQLState

40001

Sql

SELECT TOP (20) dbo.tblThreads.GroupID, dbo.tblThreads.ThreadID, dbo.tblThreads.ThreadName, dbo.tblThreads.accessed, dbo.tblThreads.lastposter, dbo.tblThreads.UserName, dbo.tblThreads.replies AS noofposts, 'Kurakani' AS gettype, '1' AS getorder, dbo.tblThreads.lastposted, dbo.tblThreads.city, dbo.tblThreads.province, dbo.tblThreads.likes, dbo.tblThreads.dislikes, dbo.tblThreads.dislikes - dbo.tblThreads.likes AS flags, dbo.profilepic.photofile, dbo.user_table.fbid, dbo.tblThreads.originatoruid AS userid FROM dbo.tblThreads INNER JOIN dbo.user_table ON dbo.tblThreads.originatoruid = dbo.user_table.uniqueid LEFT OUTER JOIN dbo.profilepic ON dbo.tblThreads.originatoruid = dbo.profilepic.userid where tblThreads.GroupID = 101 and tblthreads.lastposted is not null ORDER BY dbo.tblThreads.lastposted DESC

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 cfshowforums2ecfm458093337.runPage(D:\inetpub\sajha.com\sajha\html\showforums.cfm:30) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:246) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3000) at cfnepalregion12ecfm233701571._factor0(D:\inetpub\sajha.com\sajha\html\nepalregion1.cfm:107) at cfnepalregion12ecfm233701571.runPage(D:\inetpub\sajha.com\sajha\html\nepalregion1.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:246) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3000) at cfindex2ecfm394747199.runPage(D:\inetpub\sajha.com\sajha\html\index.cfm:731) 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:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745) Caused by: java.sql.SQLTransactionRollbackException: [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 57) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. at macromedia.jdbc.sqlserverbase.ddcw.b(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcw.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcv.b(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcv.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.c(Unknown Source) at macromedia.jdbc.sqlserver.dda3.m(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.e(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.a(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.x(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.t(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359) at coldfusion.sql.Executive.executeQuery(Executive.java:1485) at coldfusion.sql.Executive.executeQuery(Executive.java:1235) at coldfusion.sql.Executive.executeQuery(Executive.java:1165) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1187) at coldfusion.tagext.sql.QueryTag.setupCachedQuery(QueryTag.java:1121) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:808) ... 51 more

Suppressed

array [empty]

TagContext

array

struct
COLUMN	0
ID	CFQUERY
LINE	30
RAW_TRACE	at cfshowforums2ecfm458093337.runPage(D:\inetpub\sajha.com\sajha\html\showforums.cfm:30)
TEMPLATE	D:\inetpub\sajha.com\sajha\html\showforums.cfm
TYPE	CFML

struct
COLUMN	0
ID	CFINCLUDE
LINE	107
RAW_TRACE	at cfnepalregion12ecfm233701571._factor0(D:\inetpub\sajha.com\sajha\html\nepalregion1.cfm:107)
TEMPLATE	D:\inetpub\sajha.com\sajha\html\nepalregion1.cfm
TYPE	CFML

struct
COLUMN	0
ID	CF_NEPALREGION1
LINE	1
RAW_TRACE	at cfnepalregion12ecfm233701571.runPage(D:\inetpub\sajha.com\sajha\html\nepalregion1.cfm:1)
TEMPLATE	D:\inetpub\sajha.com\sajha\html\nepalregion1.cfm
TYPE	CFML

struct
COLUMN	0
ID	CFINCLUDE
LINE	731
RAW_TRACE	at cfindex2ecfm394747199.runPage(D:\inetpub\sajha.com\sajha\html\index.cfm:731)
TEMPLATE	D:\inetpub\sajha.com\sajha\html\index.cfm
TYPE	CFML

Type

Database

queryError

[Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 57) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

where

[empty string]

Sajha.com Privacy Policy

↑ Back to Top

Like us in Facebook!