Catch
Entries: 15
additional
Struct (ordered)
SQL
stringSELECT i.T_items_autoID, i.t_items_itemid, i.t_items_title, i.t_items_urltitle, i.T_items_textonimage, i.T_items_price, i.T_items_price2, i.t_items_order, c.t_categories_urltitle AS cat_urltitle, sc.t_categories_urltitle AS subcat_urltitle, ii.sItemImage_middlePath, ii.sItemImage_maxPath FROM T_items i LEFT JOIN T_categories c ON ( c.T_categories_ID = i.T_items_categoryID AND c.T_categories_subcat_parent = 0 AND c.T_categories_partnerID = 42 ) LEFT JOIN T_categories sc ON ( sc.T_categories_subcat_ID = i.t_items_subcategoryID AND sc.T_categories_ID = i.T_items_categoryID AND sc.T_categories_partnerID = 42 AND sc.T_categories_subcat_ID > 0 ) INNER JOIN tblItemImages ii ON ii.t_items_autoid = i.t_items_autoid AND ii.iItemImage_order = 1 WHERE i.T_items_partnerID = 42 AND i.T_items_categoryID NOT IN (6826,6854,6855) AND i.t_items_active = 1 AND ( T_items_title LIKE '%Chairs%' OR T_items_shortDescription1 LIKE '%Chairs%' OR T_items_reference_code LIKE '%Chairs%' OR T_items_properties LIKE '%Chairs%' OR T_items_properties2 LIKE '%Chairs%' ) ORDER BY i.T_items_order ASC
DatabaseName
stringMicrosoft SQL Server
DatabaseVersion
string15.00.2104
DriverName
stringMicrosoft JDBC Driver 7.2 for SQL Server
DriverVersion
string7.2.2.0
Datasource
stringantiek1_com_mssql
DataSource
stringantiek1_com_mssql
Detail
string
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
stringTransaction (Process ID 80) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
NativeErrorCode
number1205
queryError
stringSELECT i.T_items_autoID, i.t_items_itemid, i.t_items_title, i.t_items_urltitle, i.T_items_textonimage, i.T_items_price, i.T_items_price2, i.t_items_order, c.t_categories_urltitle AS cat_urltitle, sc.t_categories_urltitle AS subcat_urltitle, ii.sItemImage_middlePath, ii.sItemImage_maxPath FROM T_items i LEFT JOIN T_categories c ON ( c.T_categories_ID = i.T_items_categoryID AND c.T_categories_subcat_parent = 0 AND c.T_categories_partnerID = 42 ) LEFT JOIN T_categories sc ON ( sc.T_categories_subcat_ID = i.t_items_subcategoryID AND sc.T_categories_ID = i.T_items_categoryID AND sc.T_categories_partnerID = 42 AND sc.T_categories_subcat_ID > 0 ) INNER JOIN tblItemImages ii ON ii.t_items_autoid = i.t_items_autoid AND ii.iItemImage_order = 1 WHERE i.T_items_partnerID = 42 AND i.T_items_categoryID NOT IN (6826,6854,6855) AND i.t_items_active = 1 AND ( T_items_title LIKE '%Chairs%' OR T_items_shortDescription1 LIKE '%Chairs%' OR T_items_reference_code LIKE '%Chairs%' OR T_items_properties LIKE '%Chairs%' OR T_items_properties2 LIKE '%Chairs%' ) ORDER BY i.T_items_order ASC
Sql
stringSELECT i.T_items_autoID, i.t_items_itemid, i.t_items_title, i.t_items_urltitle, i.T_items_textonimage, i.T_items_price, i.T_items_price2, i.t_items_order, c.t_categories_urltitle AS cat_urltitle, sc.t_categories_urltitle AS subcat_urltitle, ii.sItemImage_middlePath, ii.sItemImage_maxPath FROM T_items i LEFT JOIN T_categories c ON ( c.T_categories_ID = i.T_items_categoryID AND c.T_categories_subcat_parent = 0 AND c.T_categories_partnerID = 42 ) LEFT JOIN T_categories sc ON ( sc.T_categories_subcat_ID = i.t_items_subcategoryID AND sc.T_categories_ID = i.T_items_categoryID AND sc.T_categories_partnerID = 42 AND sc.T_categories_subcat_ID > 0 ) INNER JOIN tblItemImages ii ON ii.t_items_autoid = i.t_items_autoid AND ii.iItemImage_order = 1 WHERE i.T_items_partnerID = 42 AND i.T_items_categoryID NOT IN (6826,6854,6855) AND i.t_items_active = 1 AND ( T_items_title LIKE '%Chairs%' OR T_items_shortDescription1 LIKE '%Chairs%' OR T_items_reference_code LIKE '%Chairs%' OR T_items_properties LIKE '%Chairs%' OR T_items_properties2 LIKE '%Chairs%' ) ORDER BY i.T_items_order ASC
SQLState
string40001
StackTrace
stringlucee.runtime.exp.DatabaseException: Transaction (Process ID 80) 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:262) at com.microsoft.sqlserver.jdbc.SQLServerResultSet$FetchBuffer.nextRow(SQLServerResultSet.java:5427) at com.microsoft.sqlserver.jdbc.SQLServerResultSet.fetchBufferNext(SQLServerResultSet.java:1758) at com.microsoft.sqlserver.jdbc.SQLServerResultSet.next(SQLServerResultSet.java:1016) at lucee.runtime.type.QueryImpl.fillResult(QueryImpl.java:499) at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:290) at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:227) at lucee.runtime.tag.Query.executeDatasoure(Query.java:1112) at lucee.runtime.tag.Query._doEndTag(Query.java:686) at lucee.runtime.tag.Query.doEndTag(Query.java:553) at com.item_cfc$cf.udfCall(/com/item.cfc:170) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:344) at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:207) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:681) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:568) at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1917) at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:864) at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1729) at modules.items.dsp_itemdetails_cfm$cf.call(/modules/items/dsp_itemDetails.cfm:258) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:945) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:837) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:818) at templates.item_cfm$cf.call(/templates/item.cfm:16) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:945) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:837) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:818) at index_cfm$cf.call(/index.cfm:3) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:945) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:837) at lucee.runtime.listener.ClassicAppListener._onRequest(ClassicAppListener.java:64) at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:43) at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2416) at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2406) at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2381) at lucee.runtime.engine.Request.exe(Request.java:43) at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1170) at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1116) 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:741) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) 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:202) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) 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:432) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1590) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:834)
TagContext
Array
1
Struct
codePrintHTML
string168: ORDER BY i.T_items_order ASC<br> 169: &lt;/cfif&gt;<br> <b>170: &lt;/cfquery&gt;</b><br> 171: <br> 172: &lt;cfreturn q&gt;<br>
codePrintPlain
string168: ORDER BY i.T_items_order ASC 169: </cfif> 170: </cfquery> 171: 172: <cfreturn q>
column
number0
id
string??
line
number170
Raw_Trace
stringcom.item_cfc$cf.udfCall(/com/item.cfc:170)
template
stringD:\vhosts\eurotrocbelgium.com\com\item.cfc
type
stringcfml
2
Struct
codePrintHTML
string256: &lt;cfelse&gt;<br> 257: &lt;cfset qItems = application.item.getAll(<br> <b>258: search = &quot;#url.searchTerm#&quot;, t_items_active = 1, l_exclude_T_items_categoryID = '6826,6854,6855'</b><br> 259: )&gt;<br> 260: &lt;/cfif&gt;<br>
codePrintPlain
string256: <cfelse> 257: <cfset qItems = application.item.getAll( 258: search = "#url.searchTerm#", t_items_active = 1, l_exclude_T_items_categoryID = '6826,6854,6855' 259: )> 260: </cfif>
column
number0
id
string??
line
number258
Raw_Trace
stringmodules.items.dsp_itemdetails_cfm$cf.call(/modules/items/dsp_itemDetails.cfm:258)
template
stringD:\vhosts\eurotrocbelgium.com\modules\items\dsp_itemDetails.cfm
type
stringcfml
3
Struct
codePrintHTML
string14: <br> 15: &lt;cftry&gt;<br> <b>16: &lt;cfinclude template=&quot;#request.webPath#modules/items/dsp_itemDetails.cfm&quot;&gt;</b><br> 17: &lt;cfcatch type=&quot;any&quot;&gt;<br> 18: &lt;cfdump var=&quot;#cfcatch#&quot;/&gt;<br>
codePrintPlain
string14: 15: <cftry> 16: <cfinclude template="#request.webPath#modules/items/dsp_itemDetails.cfm"> 17: <cfcatch type="any"> 18: <cfdump var="#cfcatch#"/>
column
number0
id
string??
line
number16
Raw_Trace
stringtemplates.item_cfm$cf.call(/templates/item.cfm:16)
template
stringD:\vhosts\eurotrocbelgium.com\templates\item.cfm
type
stringcfml
4
Struct
codePrintHTML
string1: <br> 2: <br> <b>3: &lt;cfinclude template=&quot;#request.pageTemplate#&quot;&gt;</b><br> 4: <br>
codePrintPlain
string1: 2: 3: <cfinclude template="#request.pageTemplate#"> 4:
column
number0
id
string??
line
number3
Raw_Trace
stringindex_cfm$cf.call(/index.cfm:3)
template
stringD:\vhosts\eurotrocbelgium.com\index.cfm
type
stringcfml
type
stringdatabase
where
string