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:
708:
709: </cfquery>
710:
711:

called from C:\inetpub\wwwroot\Webfiles\presscity.com\inc\SEO\LandingpagesV2\level4_1.cfm: line 32
called from C:\inetpub\wwwroot\Webfiles\presscity.com\inc\SEO\LandingpagesV2\level4.cfm: line 67
called from C:\inetpub\wwwroot\Webfiles\presscity.com\inc\SEO\machine_landing_pagesV2.cfm: line 38
called from C:\inetpub\wwwroot\Webfiles\presscity.com\index-desktop.cfm: line 871
called from C:\inetpub\wwwroot\Webfiles\presscity.com\index-desktop.cfm: line 302
called from C:\inetpub\wwwroot\Webfiles\presscity.com\index.cfm: line 1
called from C:\inetpub\wwwroot\Webfiles\presscity.com\application.cfc: line 589
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