Error Executing Database Query.
|
|
[Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 61) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
|
| |
The error occurred in D:/inetpub/wwwroot/rdic-images/cfc/Work.cfc: line 387
Called from D:/inetpub/wwwroot/rdic-images/cfc/Work.cfc: line 132
Called from d:/inetpub/wwwroot/rdic-images/buy-image.cfm: line 37
Called from D:/inetpub/wwwroot/rdic-images/cfc/Work.cfc: line 387
Called from D:/inetpub/wwwroot/rdic-images/cfc/Work.cfc: line 132
Called from d:/inetpub/wwwroot/rdic-images/buy-image.cfm: line 37
|
385 : FROM FieldData fd
386 : INNER JOIN Fields f ON f.FieldId = fd.FieldId
387 : WHERE fd.WorkId = <cfqueryparam value="#this.WorkId#">
388 : AND fd.ImageId IS NULL
389 : ORDER BY f.FieldOrder ASC, f.FieldName ASC, fd.FieldDataId ASC
|
|
| SQLSTATE |
40001 |
| DATASOURCE |
rdic-images |
| VENDORERRORCODE |
1205 |
| SQL |
SELECT f.FieldId,
f.FieldName,
fd.FieldDataId,
COALESCE(
CONVERT(nvarchar(max), fd.FieldStringValue),
CONVERT(nvarchar(max), fd.FieldTextValue),
CASE WHEN fd.FieldDateValue IS NOT NULL THEN CONVERT(nvarchar(30), fd.FieldDateValue, 120) END,
CASE WHEN fd.FieldIntValue IS NOT NULL THEN CONVERT(nvarchar(50), fd.FieldIntValue) END,
CASE WHEN fd.FieldFloatValue IS NOT NULL THEN CONVERT(nvarchar(50), fd.FieldFloatValue) END
) as FieldValue
FROM FieldData fd
INNER JOIN Fields f ON f.FieldId = fd.FieldId
WHERE fd.WorkId = (param 1)
AND fd.ImageId IS NULL
ORDER BY f.FieldOrder ASC, f.FieldName ASC, fd.FieldDataId ASC
|
|
|
Resources:
|
| Browser |
Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) |
| Remote Address |
216.73.216.171 |
| Referrer |
|
| Date/Time |
12-Jan-26 11:49 AM |
|
|
Stack Trace
|
at cfWork2ecfc142742447$funcLOADFIELDS.runFunction(D:/inetpub/wwwroot/rdic-images/cfc/Work.cfc:387) at cfWork2ecfc142742447$funcLOAD.runFunction(D:/inetpub/wwwroot/rdic-images/cfc/Work.cfc:132) at cfbuy2dimage2ecfm234399200.runPage(d:/inetpub/wwwroot/rdic-images/buy-image.cfm:37)
at cfWork2ecfc142742447$funcLOADFIELDS.runFunction(D:/inetpub/wwwroot/rdic-images/cfc/Work.cfc:387) at cfWork2ecfc142742447$funcLOAD.runFunction(D:/inetpub/wwwroot/rdic-images/cfc/Work.cfc:132) at cfbuy2dimage2ecfm234399200.runPage(d:/inetpub/wwwroot/rdic-images/buy-image.cfm:37)
java.sql.SQLTransactionRollbackException: [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 61) 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.dda4.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:1553)
at coldfusion.sql.Executive.executeQuery(Executive.java:1287)
at coldfusion.sql.Executive.executeQuery(Executive.java:1217)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406)
at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1181)
at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:815)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:768)
at cfWork2ecfc142742447$funcLOADFIELDS.runFunction(D:\inetpub\wwwroot\rdic-images\cfc\Work.cfc:387)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:493)
at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47)
at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:389)
at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:340)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:235)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:654)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:443)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:413)
at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3247)
at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3224)
at cfWork2ecfc142742447$funcLOAD.runFunction(D:\inetpub\wwwroot\rdic-images\cfc\Work.cfc:132)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:493)
at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:389)
at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:340)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:235)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:654)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:443)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:413)
at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3247)
at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3224)
at cfbuy2dimage2ecfm234399200.runPage(d:\inetpub\wwwroot\rdic-images\buy-image.cfm:37)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:254)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:743)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:505)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43)
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.BrowserDebugFilter.invoke(BrowserDebugFilter.java:78)
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:223)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
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:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:200)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:544)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:359)
at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:552)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:831)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1634)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
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)
|
|