Lucee 5.4.4.38 Error (database) | |
Message | Transaction (Process ID 128) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. |
SQL | SELECT type_tab.sTypeName, type_tab.nTypeNo,type_tab.sSeoHeader,type_tab.sSeoText, count(*) as cnt FROM machine_tab INNER JOIN customMachineData_tab ON machine_tab.nMachineNo = customMachineData_tab.nMachineNo AND machine_tab.nOwnerCompanyNo = customMachineData_tab.nCompanyNo INNER JOIN models_tab ON machine_tab.nModelNo = models_tab.nModelNo INNER JOIN producent_tab ON models_tab.nProducentNo = producent_tab.nProducentNo INNER JOIN type_tab ON producent_tab.nTypeNo = type_tab.nTypeNo INNER JOIN company_tab ON customMachineData_tab.nCompanyNo = company_tab.nCompanyNo WHERE type_tab.nTypeGroupNo = 22 AND (machine_tab.bReady = 1) AND (machine_tab.bactive = 1) AND (machine_tab.bSold = 0) AND (customMachineData_tab.bDeleted = 0) AND ( customMachineData_tab.bCollaborate = 0 OR customMachineData_tab.bCollaborate IS NULL ) AND ( customMachineData_tab.bAllowPublishPortal = 1 ) AND ( customMachineData_tab.bPublishedPortal = 1 ) AND ( machine_tab.nMachineStatusId = 4 ) AND ( company_tab.bAccountClosed = 0 ) GROUP BY type_tab.nTypeNo,type_tab.sTypeName,type_tab.sSeoHeader,type_tab.sSeoText ORDER BY type_tab.sTypeName |
DatabaseName | Microsoft SQL Server |
DatabaseVersion | 12.00.6179 |
DriverName | Microsoft JDBC Driver 9.4 for SQL Server |
DriverVersion | 9.4.1.0 |
Datasource | presscity_failover |
Stacktrace | The Error Occurred in C:\inetpub\wwwroot\Webfiles\presscity.com\inc\SEO\functions\landingpagesV2.cfc: line 709 707:called from C:\inetpub\wwwroot\Webfiles\presscity.com\inc\SEO\LandingpagesV2\level4_1.cfm: line 32 30: <cfelse>called from C:\inetpub\wwwroot\Webfiles\presscity.com\inc\SEO\LandingpagesV2\level4.cfm: line 67 65:called from C:\inetpub\wwwroot\Webfiles\presscity.com\inc\SEO\machine_landing_pagesV2.cfm: line 38 36: <cfcase value="4">called from C:\inetpub\wwwroot\Webfiles\presscity.com\index-desktop.cfm: line 871 869: </cfcase>called from C:\inetpub\wwwroot\Webfiles\presscity.com\index-desktop.cfm: line 302 300:called from C:\inetpub\wwwroot\Webfiles\presscity.com\index.cfm: line 1 1: <cfif isdefined("url.page")><cfscript>fixPageParameter();</cfscript><cfswitch expression="#url.page#"><cfcase value="createmachine,frontpage,machinelistV2,details,search,machinelist,sitemap,latestmachines1,searchDealers,RequestMachine,requestCompletedMachine,detailsV2,auctions/list,auctions/details,accountInfo,autosearch_boot,savedMachines_boot,PortalNewsletter,myMachineList,dealersInfoPortalUser,dealersInfo" delimiters=","><cfinclude template="/index-bootstrap5.cfm"></cfcase><cfdefaultcase><cfinclude template="/index-desktop.cfm"></cfdefaultcase></cfswitch><cfelse><cfinclude template="/index-bootstrap5.cfm"></cfif><cffunction name="fixPageParameter" output="false"><cfsilent>called from C:\inetpub\wwwroot\Webfiles\presscity.com\application.cfc: line 589 587: |
Java Stacktrace | lucee.runtime.exp.DatabaseException: Transaction (Process ID 128) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:265) at com.microsoft.sqlserver.jdbc.SQLServerResultSet$FetchBuffer.nextRow(SQLServerResultSet.java:5471) at com.microsoft.sqlserver.jdbc.SQLServerResultSet.fetchBufferNext(SQLServerResultSet.java:1794) at com.microsoft.sqlserver.jdbc.SQLServerResultSet.next(SQLServerResultSet.java:1052) at lucee.runtime.type.QueryImpl.fillResult(QueryImpl.java:701) at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:304) at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:235) at lucee.runtime.tag.Query.executeDatasoure(Query.java:1135) at lucee.runtime.tag.Query._doEndTag(Query.java:700) at lucee.runtime.tag.Query.doEndTag(Query.java:566) at inc.seo.functions.landingpagesv2_cfc$cf.udfCall2(/inc/seo/functions/landingpagesV2.cfc:709) at inc.seo.functions.landingpagesv2_cfc$cf.udfCall(/inc/seo/functions/landingpagesV2.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:358) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:223) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:698) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:586) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1933) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:787) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1775) at inc.seo.landingpagesv2.level4_1_cfm$cf.call(/inc/seo/LandingpagesV2/level4_1.cfm:32) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1056) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:948) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:929) at inc.seo.landingpagesv2.level4_cfm$cf.call(/inc/seo/LandingpagesV2/level4.cfm:67) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1056) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:948) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:929) at inc.seo.machine_landing_pagesv2_cfm$cf.call(/inc/seo/machine_landing_pagesV2.cfm:38) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1056) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:948) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:929) at index_desktop_cfm270$cf.udfCall(/index-desktop.cfm:871) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:358) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:223) at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:786) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:787) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1775) at index_desktop_cfm270$cf.call(/index-desktop.cfm:302) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1056) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:948) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:929) at index_cfm$cf.call(/index.cfm:1) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1056) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:948) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:929) at application_cfc$cf.udfCall(/application.cfc:589) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:358) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:223) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:698) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:586) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1933) at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:444) at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:218) at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:44) at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2493) at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2478) at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2449) at lucee.runtime.engine.Request.exe(Request.java:45) at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1215) at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1161) at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97) at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:51) at javax.servlet.http.HttpServlet.service(HttpServlet.java:623) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:209) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:422) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:926) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1790) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Unknown Source) |
Timestamp | 3/28/24 2:05:00 PM GMT |