| struct | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Cause |
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| DataSource | labtrader | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Detail | [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 109) was deadlocked on lock 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 |
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| SQLState | 40001 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Sql | SELECT A.adnumber, A.phone, A.anonname, A.anonphone , AltCompany = labtrader.dbo.fnGetSellersName(A.adnumber) , A.location, A.city, A.state, A.latitude, A.longitude, A.zip, A.isGeocoded , A.headline, A.yourad, A.pic_ref, A.manufacturer, A.model , A.price, A.systemparts, A.condition, A.age, A.weight, A.date , A.hits, A.detailhits, A.AdTypeID, A.AdType, T.AdTypeTitle, T.AdTypeGroup , A.offWarranty, A.Availability, A.Currency, A.weightUnit, A.dimensionWidth, A.dimensionHeight, A.dimensionDepth, A.dimensionUnit , AdTypeGroupTitle = CASE WHEN T.AdTypeGroup <> 0 THEN (SELECT L.AdTypeTitle FROM labtrader.dbo.lkAdType L WHERE L.AdTypeID = T.AdTypeGroup) ELSE T.AdTypeTitle END , A.eventid, isNULL(A.terms,0) AS SellerTerms , A.videoLink, A.clientnumber, A.statusid , A.catid, K.AdClass AS CategoryName, K.MainCatID, K.Meta_Keyw, K.Meta_DESC , EventLogo = CASE WHEN A.EventID > 0 THEN (SELECT e.Logo FROM labtrader.dbo.txEvent e WHERE e.EventID = a.EventID AND e.eventtype = 1) ELSE NULL END , isTheSeller = isNULL(labtrader.dbo.fnIsUserTheSellerArchive( (param 1) , (param 2) ),0) FROM labxarchives.dbo.adsedited A LEFT JOIN labtrader.dbo.txAdClassKey K ON K.CatID = A.CatID JOIN labtrader.dbo.lkAdType T ON T.AdTypeID = A.AdTypeID WHERE A.adnumber = (param 3) AND A.StatusID = 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| StackTrace | coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:641) at cfactSelectLabXAd2ecfm1203339343.runPage(D:\Websites\www.labx.com\V2\adsearch\actSelectLabXAd.cfm:59) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfDetail32ecfm600681205._factor9(D:\Websites\www.labx.com\V2\adsearch\Detail3.cfm:114) at cfDetail32ecfm600681205.runPage(D:\Websites\www.labx.com\V2\adsearch\Detail3.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:201) 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 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$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) Caused by: java.sql.SQLTransactionRollbackException: [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 109) was deadlocked on lock 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.ddq.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.ddb9.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.v(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.r(Unknown Source) at macromedia.jdbc.sqlserverbase.ddb9.execute(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcc.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:91) at coldfusion.sql.Executive.executeQuery(Executive.java:1436) at coldfusion.sql.Executive.executeQuery(Executive.java:1183) at coldfusion.sql.Executive.executeQuery(Executive.java:1114) 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) ... 34 more | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| TagContext |
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Type | Database | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| queryError | [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 109) 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='0', sqltype='cf_sql_integer'] , (param 2) = [type='IN', class='java.lang.Integer', value='467812', sqltype='cf_sql_integer'] , (param 3) = [type='IN', class='java.lang.Integer', value='467812', sqltype='cf_sql_integer'] | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||