2022-08-07 01:07:09,422 |27.0.0.1-8009-exec-6 |ServiceUtil |E| {errorMessage=Product not found in the current category., responseMessage=fail} 2022-08-07 01:27:40,084 |7.0.0.1-8009-exec-10 |ServiceUtil |E| {errorMessage=Product not found in the current category., responseMessage=fail} 2022-08-07 02:26:42,562 |27.0.0.1-8009-exec-2 |ServiceUtil |E| {errorMessage=Product not found in the current category., responseMessage=fail} 2022-08-07 03:09:51,233 |27.0.0.1-8009-exec-9 |ServiceUtil |E| {errorMessage=Product not found in the current category., responseMessage=fail} 2022-08-07 03:16:43,025 |27.0.0.1-8009-exec-8 |FreeMarkerWorker |E| null freemarker.core.InvalidReferenceException: The following has evaluated to null or missing: ==> parameters.SEARCH_STRING [in template "component://order/template/entry/catalog/TagSearch.ftl" at line 20, column 47] ---- Tip: It's the step after the last dot that caused this error, not those before it. ---- Tip: If the failing expression is known to legally refer to something that's sometimes null or missing, either specify a default value like myOptionalVar!myDefault, or use <#if myOptionalVar??>when-present<#else>when-missing. (These only cover the last step of the expression; to cover the whole expression, use parenthesis: (myOptionalVar.foo)!myDefault, (myOptionalVar.foo)?? ---- ---- FTL stack trace ("~" means nesting-related): - Failed at: ${parameters.SEARCH_STRING} [in template "component://order/template/entry/catalog/TagSearch.ftl" at line 20, column 45] ---- at freemarker.core.InvalidReferenceException.getInstance(InvalidReferenceException.java:134) ~[freemarker-2.3.28.jar:2.3.28] at freemarker.core.EvalUtil.coerceModelToTextualCommon(EvalUtil.java:467) ~[freemarker-2.3.28.jar:2.3.28] at freemarker.core.EvalUtil.coerceModelToStringOrMarkup(EvalUtil.java:389) ~[freemarker-2.3.28.jar:2.3.28] at freemarker.core.EvalUtil.coerceModelToStringOrMarkup(EvalUtil.java:358) ~[freemarker-2.3.28.jar:2.3.28] at freemarker.core.DollarVariable.calculateInterpolatedStringOrMarkup(DollarVariable.java:100) ~[freemarker-2.3.28.jar:2.3.28] at freemarker.core.DollarVariable.accept(DollarVariable.java:63) ~[freemarker-2.3.28.jar:2.3.28] at freemarker.core.Environment.visit(Environment.java:330) [freemarker-2.3.28.jar:2.3.28] at freemarker.core.Environment.visit(Environment.java:336) [freemarker-2.3.28.jar:2.3.28] at freemarker.core.Environment.process(Environment.java:309) [freemarker-2.3.28.jar:2.3.28] at org.apache.ofbiz.base.util.template.FreeMarkerWorker.renderTemplate(FreeMarkerWorker.java:211) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.HtmlWidget.renderHtmlTemplate(HtmlWidget.java:163) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.HtmlWidget$HtmlTemplate.renderWidgetString(HtmlWidget.java:200) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.HtmlWidget.renderWidgetString(HtmlWidget.java:139) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget$PlatformSpecific.renderWidgetString(ModelScreenWidget.java:1321) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:102) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget$DecoratorSection.renderWidgetString(ModelScreenWidget.java:912) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget$SectionsRenderer.render(ModelScreenWidget.java:131) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget$DecoratorSectionInclude.renderWidgetString(ModelScreenWidget.java:949) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:102) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget$Container.renderWidgetString(ModelScreenWidget.java:462) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:102) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget$Container.renderWidgetString(ModelScreenWidget.java:462) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:102) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget$Container.renderWidgetString(ModelScreenWidget.java:462) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:102) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:284) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:102) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:284) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreen.renderScreenString(ModelScreen.java:164) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ScreenFactory.renderReferencedScreen(ScreenFactory.java:204) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget$DecoratorScreen.renderWidgetString(ModelScreenWidget.java:866) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:102) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:284) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreen.renderScreenString(ModelScreen.java:164) [ofbiz.jar:?] at org.apache.ofbiz.widget.renderer.ScreenRenderer.render(ScreenRenderer.java:140) [ofbiz.jar:?] at org.apache.ofbiz.widget.renderer.ScreenRenderer.render(ScreenRenderer.java:102) [ofbiz.jar:?] at org.apache.ofbiz.widget.renderer.macro.MacroScreenViewHandler.render(MacroScreenViewHandler.java:115) [ofbiz.jar:?] at org.apache.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:980) [ofbiz.jar:?] at org.apache.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:657) [ofbiz.jar:?] at org.apache.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:217) [ofbiz.jar:?] at javax.servlet.http.HttpServlet.service(HttpServlet.java:686) [javax.servlet-api-4.0.0.jar:4.0.0] at javax.servlet.http.HttpServlet.service(HttpServlet.java:791) [javax.servlet-api-4.0.0.jar:4.0.0] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) [tomcat-embed-websocket-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.ofbiz.webapp.control.SameSiteFilter.doFilter(SameSiteFilter.java:44) [ofbiz.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.ofbiz.webapp.control.ControlFilter.doFilter(ControlFilter.java:157) [ofbiz.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.ofbiz.content.content.ContentUrlFilter.doFilter(ContentUrlFilter.java:100) [ofbiz.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.ofbiz.product.category.CatalogUrlFilter.doFilter(CatalogUrlFilter.java:337) [ofbiz.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:191) [ofbiz.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:688) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:415) [tomcat-coyote-9.0.31.jar:9.0.31] at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) [tomcat-coyote-9.0.31.jar:9.0.31] at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868) [tomcat-coyote-9.0.31.jar:9.0.31] at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1639) [tomcat-coyote-9.0.31.jar:9.0.31] at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-coyote-9.0.31.jar:9.0.31] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_201] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_201] at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util-9.0.31.jar:9.0.31] at java.lang.Thread.run(Thread.java:748) [?:1.8.0_201] 2022-08-07 03:26:15,776 |7.0.0.1-8009-exec-10 |RequestHandler |E| Request setCurrentSearchFromHistory caused an error with the following message: java.lang.IllegalArgumentException: Could not set current search options to history index [0], only [0] entries in the history list. 2022-08-07 04:10:49,902 |27.0.0.1-8009-exec-4 |RequestHandler |E| Request setCurrentSearchFromHistoryAndSearch caused an error with the following message: java.lang.IllegalArgumentException: Could not set current search options to history index [0], only [0] entries in the history list. 2022-08-07 05:23:24,211 |27.0.0.1-8009-exec-4 |ServiceUtil |E| {errorMessage=Product not found in the current category., responseMessage=fail} 2022-08-07 08:24:58,762 |27.0.0.1-8009-exec-8 |ContentWorker |E| No dataResourceId found for contentId: STORE_POLICIES 2022-08-07 08:24:59,465 |27.0.0.1-8009-exec-9 |ServiceUtil |E| {errorMessage=Product not found in the current category., responseMessage=fail} 2022-08-07 08:25:00,543 |27.0.0.1-8009-exec-4 |ServiceEventHandler |E| =============== Found URL parameter [blogContentId] passed to secure (https) request-map with uri [ViewBlogRss] with an event that calls service [generateBlogRssFeed]; this is not allowed for security reasons! The data should be encrypted by making it part of the request body (a form field) instead of the request URL. Moreover it would be kind if you could create a Jira sub-task of https://issues.apache.org/jira/browse/OFBIZ-2330 (check before if a sub-task for this error does not exist). If you are not sure how to create a Jira issue please have a look before at https://cwiki.apache.org/confluence/display/OFBIZ/OFBiz+Contributors+Best+Practices Thank you in advance for your help.; In session [ hidden sessionId by default.]; Note that this can be changed using the service.http.parameters.require.encrypted property in the url.properties file 2022-08-07 08:25:00,559 |27.0.0.1-8009-exec-4 |RequestHandler |E| Request ViewBlogRss caused an error with the following message: Error calling event: org.apache.ofbiz.webapp.event.EventHandlerException: Found URL parameter [blogContentId] passed to secure (https) request-map with uri [ViewBlogRss] with an event that calls service [generateBlogRssFeed]; this is not allowed for security reasons! The data should be encrypted by making it part of the request body (a form field) instead of the request URL. Moreover it would be kind if you could create a Jira sub-task of https://issues.apache.org/jira/browse/OFBIZ-2330 (check before if a sub-task for this error does not exist). If you are not sure how to create a Jira issue please have a look before at https://cwiki.apache.org/confluence/display/OFBIZ/OFBiz+Contributors+Best+Practices Thank you in advance for your help. 2022-08-07 08:25:01,575 |27.0.0.1-8009-exec-5 |ServiceEventHandler |E| =============== Found URL parameter [blogContentId] passed to secure (https) request-map with uri [ViewBlogRss] with an event that calls service [generateBlogRssFeed]; this is not allowed for security reasons! The data should be encrypted by making it part of the request body (a form field) instead of the request URL. Moreover it would be kind if you could create a Jira sub-task of https://issues.apache.org/jira/browse/OFBIZ-2330 (check before if a sub-task for this error does not exist). If you are not sure how to create a Jira issue please have a look before at https://cwiki.apache.org/confluence/display/OFBIZ/OFBiz+Contributors+Best+Practices Thank you in advance for your help.; In session [ hidden sessionId by default.]; Note that this can be changed using the service.http.parameters.require.encrypted property in the url.properties file 2022-08-07 08:25:01,575 |27.0.0.1-8009-exec-5 |RequestHandler |E| Request ViewBlogRss caused an error with the following message: Error calling event: org.apache.ofbiz.webapp.event.EventHandlerException: Found URL parameter [blogContentId] passed to secure (https) request-map with uri [ViewBlogRss] with an event that calls service [generateBlogRssFeed]; this is not allowed for security reasons! The data should be encrypted by making it part of the request body (a form field) instead of the request URL. Moreover it would be kind if you could create a Jira sub-task of https://issues.apache.org/jira/browse/OFBIZ-2330 (check before if a sub-task for this error does not exist). If you are not sure how to create a Jira issue please have a look before at https://cwiki.apache.org/confluence/display/OFBIZ/OFBiz+Contributors+Best+Practices Thank you in advance for your help. 2022-08-07 08:25:02,419 |27.0.0.1-8009-exec-9 |RequestHandler |E| Request setCurrentSearchFromHistory caused an error with the following message: java.lang.IllegalArgumentException: Could not set current search options to history index [0], only [0] entries in the history list. 2022-08-07 08:25:02,481 |27.0.0.1-8009-exec-5 |RequestHandler |E| Request setCurrentSearchFromHistoryAndSearch caused an error with the following message: java.lang.IllegalArgumentException: Could not set current search options to history index [0], only [0] entries in the history list. 2022-08-07 08:25:11,731 |27.0.0.1-8009-exec-6 |ServiceUtil |E| {errorMessage=Product not found in the current category., responseMessage=fail} 2022-08-07 08:25:11,794 |27.0.0.1-8009-exec-7 |ServiceUtil |E| {errorMessage=Product not found in the current category., responseMessage=fail} 2022-08-07 08:25:11,965 |27.0.0.1-8009-exec-1 |ServiceUtil |E| {errorMessage=Product not found in the current category., responseMessage=fail} 2022-08-07 08:25:12,590 |27.0.0.1-8009-exec-7 |ServiceUtil |E| {errorMessage=Product not found in the current category., responseMessage=fail} 2022-08-07 08:25:12,637 |27.0.0.1-8009-exec-4 |ServiceUtil |E| {errorMessage=Product not found in the current category., responseMessage=fail} 2022-08-07 08:25:12,653 |27.0.0.1-8009-exec-7 |ServiceUtil |E| {errorMessage=Product not found in the current category., responseMessage=fail} 2022-08-07 08:25:12,762 |27.0.0.1-8009-exec-6 |ServiceUtil |E| {errorMessage=Product not found in the current category., responseMessage=fail} 2022-08-07 08:25:12,778 |27.0.0.1-8009-exec-8 |ServiceUtil |E| {errorMessage=Product not found in the current category., responseMessage=fail} 2022-08-07 08:25:12,919 |27.0.0.1-8009-exec-1 |ServiceUtil |E| {errorMessage=Product not found in the current category., responseMessage=fail} 2022-08-07 08:25:13,059 |27.0.0.1-8009-exec-7 |ServiceUtil |E| {errorMessage=Product not found in the current category., responseMessage=fail} 2022-08-07 08:25:13,215 |27.0.0.1-8009-exec-9 |ServiceUtil |E| {errorMessage=Product not found in the current category., responseMessage=fail} 2022-08-07 08:25:29,987 |27.0.0.1-8009-exec-2 |ListFinder |E| Failure in by condition find operation, rolling back transaction org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT CA.CONTENT_ID, CA.FROM_DATE, CA.THRU_DATE, CO.OWNER_CONTENT_ID, CO.CONTENT_ID, CO.CONTENT_TYPE_ID, CO.DESCRIPTION, CO.MIME_TYPE_ID, CO.CHILD_LEAF_COUNT, CO.PRIVILEGE_ENUM_ID, CO.DATA_SOURCE_ID, CO.LAST_MODIFIED_BY_USER_LOGIN, CO.DATA_RESOURCE_ID, CO.CREATED_BY_USER_LOGIN, CO.TEMPLATE_DATA_RESOURCE_ID, CO.LAST_MODIFIED_DATE, CO.INSTANCE_OF_CONTENT_ID, CO.SERVICE_NAME, CO.CUSTOM_METHOD_ID, CO.CHARACTER_SET_ID, CO.CONTENT_NAME, CO.CREATED_DATE, CO.STATUS_ID, CO.LOCALE_STRING, CO.DECORATOR_CONTENT_ID, CO.CHILD_BRANCH_COUNT, CA.SEQUENCE_NUM, CA.LAST_MODIFIED_DATE, CA.CONTENT_ID_TO, CA.UPPER_COORDINATE, CA.LEFT_COORDINATE, CA.CONTENT_ID, CA.MAP_KEY, CA.THRU_DATE, CA.FROM_DATE, CA.CONTENT_ASSOC_PREDICATE_ID, CA.DATA_SOURCE_ID, CA.LAST_MODIFIED_BY_USER_LOGIN, CA.CREATED_DATE, CA.CONTENT_ASSOC_TYPE_ID, CA.CREATED_BY_USER_LOGIN FROM OFBIZ.CONTENT_ASSOC CA INNER JOIN OFBIZ.CONTENT CO ON CA.CONTENT_ID_TO = CO.CONTENT_ID WHERE ((CA.CONTENT_ID = ? AND CA.CONTENT_ASSOC_TYPE_ID = ? AND CA.FROM_DATE <= ? AND (CA.THRU_DATE IS NULL OR CA.THRU_DATE > ?))) ORDER BY CA.FROM_DATE DESC (A lock could not be obtained due to a deadlock, cycle of locks and waiters is: Lock : ROW, CONTENT, (32,12) Waiting XID : {8748953, S} , OFBIZ, SELECT CA.CONTENT_ID, CA.FROM_DATE, CA.THRU_DATE, CO.OWNER_CONTENT_ID, CO.CONTENT_ID, CO.CONTENT_TYPE_ID, CO.DESCRIPTION, CO.MIME_TYPE_ID, CO.CHILD_LEAF_COUNT, CO.PRIVILEGE_ENUM_ID, CO.DATA_SOURCE_ID, CO.LAST_MODIFIED_BY_USER_LOGIN, CO.DATA_RESOURCE_ID, CO.CREATED_BY_USER_LOGIN, CO.TEMPLATE_DATA_RESOURCE_ID, CO.LAST_MODIFIED_DATE, CO.INSTANCE_OF_CONTENT_ID, CO.SERVICE_NAME, CO.CUSTOM_METHOD_ID, CO.CHARACTER_SET_ID, CO.CONTENT_NAME, CO.CREATED_DATE, CO.STATUS_ID, CO.LOCALE_STRING, CO.DECORATOR_CONTENT_ID, CO.CHILD_BRANCH_COUNT, CA.SEQUENCE_NUM, CA.LAST_MODIFIED_DATE, CA.CONTENT_ID_TO, CA.UPPER_COORDINATE, CA.LEFT_COORDINATE, CA.CONTENT_ID, CA.MAP_KEY, CA.THRU_DATE, CA.FROM_DATE, CA.CONTENT_ASSOC_PREDICATE_ID, CA.DATA_SOURCE_ID, CA.LAST_MODIFIED_BY_USER_LOGIN, CA.CREATED_DATE, CA.CONTENT_ASSOC_TYPE_ID, CA.CREATED_BY_USER_LOGIN FROM OFBIZ.CONTENT_ASSOC CA INNER JOIN OFBIZ.CONTENT CO ON CA.CONTENT_ID_TO = CO.CONTENT_ID WHERE ((CA.CONTENT_ID = ? AND CA.CONTENT_ASSOC_TYPE_ID = ? AND CA.FROM_DATE <= ? AND (CA.THRU_DATE IS NULL OR CA.THRU_DATE > ?))) ORDER BY CA.FROM_DATE DESC Granted XID : {8748944, X} Lock : ROW, CONTENT, (32,10) Waiting XID : {8748944, X} , OFBIZ, UPDATE OFBIZ.CONTENT SET CONTENT_TYPE_ID=?, OWNER_CONTENT_ID=?, DECORATOR_CONTENT_ID=?, INSTANCE_OF_CONTENT_ID=?, DATA_RESOURCE_ID=?, TEMPLATE_DATA_RESOURCE_ID=?, DATA_SOURCE_ID=?, STATUS_ID=?, PRIVILEGE_ENUM_ID=?, SERVICE_NAME=?, CUSTOM_METHOD_ID=?, CONTENT_NAME=?, DESCRIPTION=?, LOCALE_STRING=?, MIME_TYPE_ID=?, CHARACTER_SET_ID=?, CHILD_LEAF_COUNT=?, CHILD_BRANCH_COUNT=?, CREATED_DATE=?, CREATED_BY_USER_LOGIN=?, LAST_MODIFIED_DATE=?, LAST_MODIFIED_BY_USER_LOGIN=?, LAST_UPDATED_STAMP=?, LAST_UPDATED_TX_STAMP=?, CREATED_STAMP=?, CREATED_TX_STAMP=? WHERE CONTENT_ID=? Granted XID : {8748953, S} . The selected victim is XID : 8748953.) at org.apache.ofbiz.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:402) ~[ofbiz.jar:?] at org.apache.ofbiz.entity.datasource.GenericDAO.selectListIteratorByCondition(GenericDAO.java:736) ~[ofbiz.jar:?] at org.apache.ofbiz.entity.datasource.GenericHelperDAO.findListIteratorByCondition(GenericHelperDAO.java:141) ~[ofbiz.jar:?] at org.apache.ofbiz.entity.GenericDelegator.find(GenericDelegator.java:1563) ~[ofbiz.jar:?] at org.apache.ofbiz.entity.finder.ListFinder.runFind(ListFinder.java:215) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelTreeAction$EntityCondition.runAction(ModelTreeAction.java:239) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.AbstractModelAction.runSubActions(AbstractModelAction.java:143) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelTree$ModelNode.getChildren(ModelTree.java:397) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelTree$ModelNode.hasChildren(ModelTree.java:490) [ofbiz.jar:?] at org.apache.ofbiz.widget.renderer.macro.MacroTreeRenderer.renderNodeBegin(MacroTreeRenderer.java:147) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelTree$ModelNode.renderNodeString(ModelTree.java:564) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelTree.renderTreeString(ModelTree.java:255) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget$Tree.renderWidgetString(ModelScreenWidget.java:1247) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:102) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget$DecoratorSection.renderWidgetString(ModelScreenWidget.java:912) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget$SectionsRenderer.render(ModelScreenWidget.java:131) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget$DecoratorSectionInclude.renderWidgetString(ModelScreenWidget.java:949) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:102) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget$Container.renderWidgetString(ModelScreenWidget.java:462) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:102) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget$Container.renderWidgetString(ModelScreenWidget.java:462) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:102) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget$Container.renderWidgetString(ModelScreenWidget.java:462) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:102) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:284) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:102) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:284) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreen.renderScreenString(ModelScreen.java:164) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ScreenFactory.renderReferencedScreen(ScreenFactory.java:204) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget$DecoratorScreen.renderWidgetString(ModelScreenWidget.java:866) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:102) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:284) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreen.renderScreenString(ModelScreen.java:164) [ofbiz.jar:?] at org.apache.ofbiz.widget.renderer.ScreenRenderer.render(ScreenRenderer.java:140) [ofbiz.jar:?] at org.apache.ofbiz.widget.renderer.ScreenRenderer.render(ScreenRenderer.java:102) [ofbiz.jar:?] at org.apache.ofbiz.widget.renderer.macro.MacroScreenViewHandler.render(MacroScreenViewHandler.java:115) [ofbiz.jar:?] at org.apache.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:980) [ofbiz.jar:?] at org.apache.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:657) [ofbiz.jar:?] at org.apache.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:217) [ofbiz.jar:?] at javax.servlet.http.HttpServlet.service(HttpServlet.java:686) [javax.servlet-api-4.0.0.jar:4.0.0] at javax.servlet.http.HttpServlet.service(HttpServlet.java:791) [javax.servlet-api-4.0.0.jar:4.0.0] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) [tomcat-embed-websocket-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.ofbiz.webapp.control.SameSiteFilter.doFilter(SameSiteFilter.java:44) [ofbiz.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.ofbiz.webapp.control.ControlFilter.doFilter(ControlFilter.java:157) [ofbiz.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.ofbiz.content.content.ContentUrlFilter.doFilter(ContentUrlFilter.java:100) [ofbiz.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.ofbiz.product.category.CatalogUrlFilter.doFilter(CatalogUrlFilter.java:337) [ofbiz.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:191) [ofbiz.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:688) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:415) [tomcat-coyote-9.0.31.jar:9.0.31] at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) [tomcat-coyote-9.0.31.jar:9.0.31] at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868) [tomcat-coyote-9.0.31.jar:9.0.31] at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1639) [tomcat-coyote-9.0.31.jar:9.0.31] at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-coyote-9.0.31.jar:9.0.31] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_201] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_201] at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util-9.0.31.jar:9.0.31] at java.lang.Thread.run(Thread.java:748) [?:1.8.0_201] Caused by: java.sql.SQLTransactionRollbackException: A lock could not be obtained due to a deadlock, cycle of locks and waiters is: Lock : ROW, CONTENT, (32,12) Waiting XID : {8748953, S} , OFBIZ, SELECT CA.CONTENT_ID, CA.FROM_DATE, CA.THRU_DATE, CO.OWNER_CONTENT_ID, CO.CONTENT_ID, CO.CONTENT_TYPE_ID, CO.DESCRIPTION, CO.MIME_TYPE_ID, CO.CHILD_LEAF_COUNT, CO.PRIVILEGE_ENUM_ID, CO.DATA_SOURCE_ID, CO.LAST_MODIFIED_BY_USER_LOGIN, CO.DATA_RESOURCE_ID, CO.CREATED_BY_USER_LOGIN, CO.TEMPLATE_DATA_RESOURCE_ID, CO.LAST_MODIFIED_DATE, CO.INSTANCE_OF_CONTENT_ID, CO.SERVICE_NAME, CO.CUSTOM_METHOD_ID, CO.CHARACTER_SET_ID, CO.CONTENT_NAME, CO.CREATED_DATE, CO.STATUS_ID, CO.LOCALE_STRING, CO.DECORATOR_CONTENT_ID, CO.CHILD_BRANCH_COUNT, CA.SEQUENCE_NUM, CA.LAST_MODIFIED_DATE, CA.CONTENT_ID_TO, CA.UPPER_COORDINATE, CA.LEFT_COORDINATE, CA.CONTENT_ID, CA.MAP_KEY, CA.THRU_DATE, CA.FROM_DATE, CA.CONTENT_ASSOC_PREDICATE_ID, CA.DATA_SOURCE_ID, CA.LAST_MODIFIED_BY_USER_LOGIN, CA.CREATED_DATE, CA.CONTENT_ASSOC_TYPE_ID, CA.CREATED_BY_USER_LOGIN FROM OFBIZ.CONTENT_ASSOC CA INNER JOIN OFBIZ.CONTENT CO ON CA.CONTENT_ID_TO = CO.CONTENT_ID WHERE ((CA.CONTENT_ID = ? AND CA.CONTENT_ASSOC_TYPE_ID = ? AND CA.FROM_DATE <= ? AND (CA.THRU_DATE IS NULL OR CA.THRU_DATE > ?))) ORDER BY CA.FROM_DATE DESC Granted XID : {8748944, X} Lock : ROW, CONTENT, (32,10) Waiting XID : {8748944, X} , OFBIZ, UPDATE OFBIZ.CONTENT SET CONTENT_TYPE_ID=?, OWNER_CONTENT_ID=?, DECORATOR_CONTENT_ID=?, INSTANCE_OF_CONTENT_ID=?, DATA_RESOURCE_ID=?, TEMPLATE_DATA_RESOURCE_ID=?, DATA_SOURCE_ID=?, STATUS_ID=?, PRIVILEGE_ENUM_ID=?, SERVICE_NAME=?, CUSTOM_METHOD_ID=?, CONTENT_NAME=?, DESCRIPTION=?, LOCALE_STRING=?, MIME_TYPE_ID=?, CHARACTER_SET_ID=?, CHILD_LEAF_COUNT=?, CHILD_BRANCH_COUNT=?, CREATED_DATE=?, CREATED_BY_USER_LOGIN=?, LAST_MODIFIED_DATE=?, LAST_MODIFIED_BY_USER_LOGIN=?, LAST_UPDATED_STAMP=?, LAST_UPDATED_TX_STAMP=?, CREATED_STAMP=?, CREATED_TX_STAMP=? WHERE CONTENT_ID=? Granted XID : {8748953, S} . The selected victim is XID : 8748953. at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeQuery(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83) ~[commons-dbcp2-2.1.1.jar:2.1.1] at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83) ~[commons-dbcp2-2.1.1.jar:2.1.1] at org.apache.ofbiz.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:399) ~[ofbiz.jar:?] ... 77 more Caused by: org.apache.derby.iapi.error.StandardException: A lock could not be obtained due to a deadlock, cycle of locks and waiters is: Lock : ROW, CONTENT, (32,12) Waiting XID : {8748953, S} , OFBIZ, SELECT CA.CONTENT_ID, CA.FROM_DATE, CA.THRU_DATE, CO.OWNER_CONTENT_ID, CO.CONTENT_ID, CO.CONTENT_TYPE_ID, CO.DESCRIPTION, CO.MIME_TYPE_ID, CO.CHILD_LEAF_COUNT, CO.PRIVILEGE_ENUM_ID, CO.DATA_SOURCE_ID, CO.LAST_MODIFIED_BY_USER_LOGIN, CO.DATA_RESOURCE_ID, CO.CREATED_BY_USER_LOGIN, CO.TEMPLATE_DATA_RESOURCE_ID, CO.LAST_MODIFIED_DATE, CO.INSTANCE_OF_CONTENT_ID, CO.SERVICE_NAME, CO.CUSTOM_METHOD_ID, CO.CHARACTER_SET_ID, CO.CONTENT_NAME, CO.CREATED_DATE, CO.STATUS_ID, CO.LOCALE_STRING, CO.DECORATOR_CONTENT_ID, CO.CHILD_BRANCH_COUNT, CA.SEQUENCE_NUM, CA.LAST_MODIFIED_DATE, CA.CONTENT_ID_TO, CA.UPPER_COORDINATE, CA.LEFT_COORDINATE, CA.CONTENT_ID, CA.MAP_KEY, CA.THRU_DATE, CA.FROM_DATE, CA.CONTENT_ASSOC_PREDICATE_ID, CA.DATA_SOURCE_ID, CA.LAST_MODIFIED_BY_USER_LOGIN, CA.CREATED_DATE, CA.CONTENT_ASSOC_TYPE_ID, CA.CREATED_BY_USER_LOGIN FROM OFBIZ.CONTENT_ASSOC CA INNER JOIN OFBIZ.CONTENT CO ON CA.CONTENT_ID_TO = CO.CONTENT_ID WHERE ((CA.CONTENT_ID = ? AND CA.CONTENT_ASSOC_TYPE_ID = ? AND CA.FROM_DATE <= ? AND (CA.THRU_DATE IS NULL OR CA.THRU_DATE > ?))) ORDER BY CA.FROM_DATE DESC Granted XID : {8748944, X} Lock : ROW, CONTENT, (32,10) Waiting XID : {8748944, X} , OFBIZ, UPDATE OFBIZ.CONTENT SET CONTENT_TYPE_ID=?, OWNER_CONTENT_ID=?, DECORATOR_CONTENT_ID=?, INSTANCE_OF_CONTENT_ID=?, DATA_RESOURCE_ID=?, TEMPLATE_DATA_RESOURCE_ID=?, DATA_SOURCE_ID=?, STATUS_ID=?, PRIVILEGE_ENUM_ID=?, SERVICE_NAME=?, CUSTOM_METHOD_ID=?, CONTENT_NAME=?, DESCRIPTION=?, LOCALE_STRING=?, MIME_TYPE_ID=?, CHARACTER_SET_ID=?, CHILD_LEAF_COUNT=?, CHILD_BRANCH_COUNT=?, CREATED_DATE=?, CREATED_BY_USER_LOGIN=?, LAST_MODIFIED_DATE=?, LAST_MODIFIED_BY_USER_LOGIN=?, LAST_UPDATED_STAMP=?, LAST_UPDATED_TX_STAMP=?, CREATED_STAMP=?, CREATED_TX_STAMP=? WHERE CONTENT_ID=? Granted XID : {8748953, S} . The selected victim is XID : 8748953. at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.services.locks.Deadlock.buildException(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.services.locks.ConcurrentLockSet.lockObject(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.services.locks.AbstractPool.lockObject(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.services.locks.ConcurrentPool.lockObject(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.store.raw.xact.RowLocking2.lockRecordForRead(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.store.access.heap.HeapController.lockRow(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.store.access.heap.HeapController.lockRow(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.store.access.btree.index.B2IRowLocking3.lockRowOnPage(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.store.access.btree.index.B2IRowLocking3._lockScanRow(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.store.access.btree.index.B2IRowLockingRR.lockScanRow(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.store.access.btree.BTreeForwardScan.fetchRows(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.store.access.btree.BTreeScan.fetchNext(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.sql.execute.TableScanResultSet.loopControl(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.sql.execute.TableScanResultSet.getNextRowCore(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.sql.execute.IndexRowToBaseRowResultSet.getNextRowCore(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.sql.execute.NestedLoopJoinResultSet.getNextRowCore(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.getNextRowCore(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.sql.execute.SortResultSet.getRowFromResultSet(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.sql.execute.SortResultSet.getNextRowFromRS(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.sql.execute.SortResultSet.loadSorter(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.sql.execute.SortResultSet.openCore(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.sql.execute.ScrollInsensitiveResultSet.openCore(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.open(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeQuery(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83) ~[commons-dbcp2-2.1.1.jar:2.1.1] at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83) ~[commons-dbcp2-2.1.1.jar:2.1.1] at org.apache.ofbiz.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:399) ~[ofbiz.jar:?] ... 77 more 2022-08-07 08:25:30,003 |27.0.0.1-8009-exec-2 |ListFinder |E| null org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT CA.CONTENT_ID, CA.FROM_DATE, CA.THRU_DATE, CO.OWNER_CONTENT_ID, CO.CONTENT_ID, CO.CONTENT_TYPE_ID, CO.DESCRIPTION, CO.MIME_TYPE_ID, CO.CHILD_LEAF_COUNT, CO.PRIVILEGE_ENUM_ID, CO.DATA_SOURCE_ID, CO.LAST_MODIFIED_BY_USER_LOGIN, CO.DATA_RESOURCE_ID, CO.CREATED_BY_USER_LOGIN, CO.TEMPLATE_DATA_RESOURCE_ID, CO.LAST_MODIFIED_DATE, CO.INSTANCE_OF_CONTENT_ID, CO.SERVICE_NAME, CO.CUSTOM_METHOD_ID, CO.CHARACTER_SET_ID, CO.CONTENT_NAME, CO.CREATED_DATE, CO.STATUS_ID, CO.LOCALE_STRING, CO.DECORATOR_CONTENT_ID, CO.CHILD_BRANCH_COUNT, CA.SEQUENCE_NUM, CA.LAST_MODIFIED_DATE, CA.CONTENT_ID_TO, CA.UPPER_COORDINATE, CA.LEFT_COORDINATE, CA.CONTENT_ID, CA.MAP_KEY, CA.THRU_DATE, CA.FROM_DATE, CA.CONTENT_ASSOC_PREDICATE_ID, CA.DATA_SOURCE_ID, CA.LAST_MODIFIED_BY_USER_LOGIN, CA.CREATED_DATE, CA.CONTENT_ASSOC_TYPE_ID, CA.CREATED_BY_USER_LOGIN FROM OFBIZ.CONTENT_ASSOC CA INNER JOIN OFBIZ.CONTENT CO ON CA.CONTENT_ID_TO = CO.CONTENT_ID WHERE ((CA.CONTENT_ID = ? AND CA.CONTENT_ASSOC_TYPE_ID = ? AND CA.FROM_DATE <= ? AND (CA.THRU_DATE IS NULL OR CA.THRU_DATE > ?))) ORDER BY CA.FROM_DATE DESC (A lock could not be obtained due to a deadlock, cycle of locks and waiters is: Lock : ROW, CONTENT, (32,12) Waiting XID : {8748953, S} , OFBIZ, SELECT CA.CONTENT_ID, CA.FROM_DATE, CA.THRU_DATE, CO.OWNER_CONTENT_ID, CO.CONTENT_ID, CO.CONTENT_TYPE_ID, CO.DESCRIPTION, CO.MIME_TYPE_ID, CO.CHILD_LEAF_COUNT, CO.PRIVILEGE_ENUM_ID, CO.DATA_SOURCE_ID, CO.LAST_MODIFIED_BY_USER_LOGIN, CO.DATA_RESOURCE_ID, CO.CREATED_BY_USER_LOGIN, CO.TEMPLATE_DATA_RESOURCE_ID, CO.LAST_MODIFIED_DATE, CO.INSTANCE_OF_CONTENT_ID, CO.SERVICE_NAME, CO.CUSTOM_METHOD_ID, CO.CHARACTER_SET_ID, CO.CONTENT_NAME, CO.CREATED_DATE, CO.STATUS_ID, CO.LOCALE_STRING, CO.DECORATOR_CONTENT_ID, CO.CHILD_BRANCH_COUNT, CA.SEQUENCE_NUM, CA.LAST_MODIFIED_DATE, CA.CONTENT_ID_TO, CA.UPPER_COORDINATE, CA.LEFT_COORDINATE, CA.CONTENT_ID, CA.MAP_KEY, CA.THRU_DATE, CA.FROM_DATE, CA.CONTENT_ASSOC_PREDICATE_ID, CA.DATA_SOURCE_ID, CA.LAST_MODIFIED_BY_USER_LOGIN, CA.CREATED_DATE, CA.CONTENT_ASSOC_TYPE_ID, CA.CREATED_BY_USER_LOGIN FROM OFBIZ.CONTENT_ASSOC CA INNER JOIN OFBIZ.CONTENT CO ON CA.CONTENT_ID_TO = CO.CONTENT_ID WHERE ((CA.CONTENT_ID = ? AND CA.CONTENT_ASSOC_TYPE_ID = ? AND CA.FROM_DATE <= ? AND (CA.THRU_DATE IS NULL OR CA.THRU_DATE > ?))) ORDER BY CA.FROM_DATE DESC Granted XID : {8748944, X} Lock : ROW, CONTENT, (32,10) Waiting XID : {8748944, X} , OFBIZ, UPDATE OFBIZ.CONTENT SET CONTENT_TYPE_ID=?, OWNER_CONTENT_ID=?, DECORATOR_CONTENT_ID=?, INSTANCE_OF_CONTENT_ID=?, DATA_RESOURCE_ID=?, TEMPLATE_DATA_RESOURCE_ID=?, DATA_SOURCE_ID=?, STATUS_ID=?, PRIVILEGE_ENUM_ID=?, SERVICE_NAME=?, CUSTOM_METHOD_ID=?, CONTENT_NAME=?, DESCRIPTION=?, LOCALE_STRING=?, MIME_TYPE_ID=?, CHARACTER_SET_ID=?, CHILD_LEAF_COUNT=?, CHILD_BRANCH_COUNT=?, CREATED_DATE=?, CREATED_BY_USER_LOGIN=?, LAST_MODIFIED_DATE=?, LAST_MODIFIED_BY_USER_LOGIN=?, LAST_UPDATED_STAMP=?, LAST_UPDATED_TX_STAMP=?, CREATED_STAMP=?, CREATED_TX_STAMP=? WHERE CONTENT_ID=? Granted XID : {8748953, S} . The selected victim is XID : 8748953.) at org.apache.ofbiz.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:402) ~[ofbiz.jar:?] at org.apache.ofbiz.entity.datasource.GenericDAO.selectListIteratorByCondition(GenericDAO.java:736) ~[ofbiz.jar:?] at org.apache.ofbiz.entity.datasource.GenericHelperDAO.findListIteratorByCondition(GenericHelperDAO.java:141) ~[ofbiz.jar:?] at org.apache.ofbiz.entity.GenericDelegator.find(GenericDelegator.java:1563) ~[ofbiz.jar:?] at org.apache.ofbiz.entity.finder.ListFinder.runFind(ListFinder.java:215) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelTreeAction$EntityCondition.runAction(ModelTreeAction.java:239) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.AbstractModelAction.runSubActions(AbstractModelAction.java:143) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelTree$ModelNode.getChildren(ModelTree.java:397) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelTree$ModelNode.hasChildren(ModelTree.java:490) [ofbiz.jar:?] at org.apache.ofbiz.widget.renderer.macro.MacroTreeRenderer.renderNodeBegin(MacroTreeRenderer.java:147) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelTree$ModelNode.renderNodeString(ModelTree.java:564) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelTree.renderTreeString(ModelTree.java:255) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget$Tree.renderWidgetString(ModelScreenWidget.java:1247) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:102) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget$DecoratorSection.renderWidgetString(ModelScreenWidget.java:912) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget$SectionsRenderer.render(ModelScreenWidget.java:131) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget$DecoratorSectionInclude.renderWidgetString(ModelScreenWidget.java:949) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:102) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget$Container.renderWidgetString(ModelScreenWidget.java:462) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:102) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget$Container.renderWidgetString(ModelScreenWidget.java:462) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:102) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget$Container.renderWidgetString(ModelScreenWidget.java:462) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:102) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:284) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:102) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:284) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreen.renderScreenString(ModelScreen.java:164) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ScreenFactory.renderReferencedScreen(ScreenFactory.java:204) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget$DecoratorScreen.renderWidgetString(ModelScreenWidget.java:866) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:102) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:284) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreen.renderScreenString(ModelScreen.java:164) [ofbiz.jar:?] at org.apache.ofbiz.widget.renderer.ScreenRenderer.render(ScreenRenderer.java:140) [ofbiz.jar:?] at org.apache.ofbiz.widget.renderer.ScreenRenderer.render(ScreenRenderer.java:102) [ofbiz.jar:?] at org.apache.ofbiz.widget.renderer.macro.MacroScreenViewHandler.render(MacroScreenViewHandler.java:115) [ofbiz.jar:?] at org.apache.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:980) [ofbiz.jar:?] at org.apache.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:657) [ofbiz.jar:?] at org.apache.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:217) [ofbiz.jar:?] at javax.servlet.http.HttpServlet.service(HttpServlet.java:686) [javax.servlet-api-4.0.0.jar:4.0.0] at javax.servlet.http.HttpServlet.service(HttpServlet.java:791) [javax.servlet-api-4.0.0.jar:4.0.0] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) [tomcat-embed-websocket-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.ofbiz.webapp.control.SameSiteFilter.doFilter(SameSiteFilter.java:44) [ofbiz.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.ofbiz.webapp.control.ControlFilter.doFilter(ControlFilter.java:157) [ofbiz.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.ofbiz.content.content.ContentUrlFilter.doFilter(ContentUrlFilter.java:100) [ofbiz.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.ofbiz.product.category.CatalogUrlFilter.doFilter(CatalogUrlFilter.java:337) [ofbiz.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:191) [ofbiz.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:688) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:415) [tomcat-coyote-9.0.31.jar:9.0.31] at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) [tomcat-coyote-9.0.31.jar:9.0.31] at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868) [tomcat-coyote-9.0.31.jar:9.0.31] at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1639) [tomcat-coyote-9.0.31.jar:9.0.31] at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-coyote-9.0.31.jar:9.0.31] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_201] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_201] at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util-9.0.31.jar:9.0.31] at java.lang.Thread.run(Thread.java:748) [?:1.8.0_201] Caused by: java.sql.SQLTransactionRollbackException: A lock could not be obtained due to a deadlock, cycle of locks and waiters is: Lock : ROW, CONTENT, (32,12) Waiting XID : {8748953, S} , OFBIZ, SELECT CA.CONTENT_ID, CA.FROM_DATE, CA.THRU_DATE, CO.OWNER_CONTENT_ID, CO.CONTENT_ID, CO.CONTENT_TYPE_ID, CO.DESCRIPTION, CO.MIME_TYPE_ID, CO.CHILD_LEAF_COUNT, CO.PRIVILEGE_ENUM_ID, CO.DATA_SOURCE_ID, CO.LAST_MODIFIED_BY_USER_LOGIN, CO.DATA_RESOURCE_ID, CO.CREATED_BY_USER_LOGIN, CO.TEMPLATE_DATA_RESOURCE_ID, CO.LAST_MODIFIED_DATE, CO.INSTANCE_OF_CONTENT_ID, CO.SERVICE_NAME, CO.CUSTOM_METHOD_ID, CO.CHARACTER_SET_ID, CO.CONTENT_NAME, CO.CREATED_DATE, CO.STATUS_ID, CO.LOCALE_STRING, CO.DECORATOR_CONTENT_ID, CO.CHILD_BRANCH_COUNT, CA.SEQUENCE_NUM, CA.LAST_MODIFIED_DATE, CA.CONTENT_ID_TO, CA.UPPER_COORDINATE, CA.LEFT_COORDINATE, CA.CONTENT_ID, CA.MAP_KEY, CA.THRU_DATE, CA.FROM_DATE, CA.CONTENT_ASSOC_PREDICATE_ID, CA.DATA_SOURCE_ID, CA.LAST_MODIFIED_BY_USER_LOGIN, CA.CREATED_DATE, CA.CONTENT_ASSOC_TYPE_ID, CA.CREATED_BY_USER_LOGIN FROM OFBIZ.CONTENT_ASSOC CA INNER JOIN OFBIZ.CONTENT CO ON CA.CONTENT_ID_TO = CO.CONTENT_ID WHERE ((CA.CONTENT_ID = ? AND CA.CONTENT_ASSOC_TYPE_ID = ? AND CA.FROM_DATE <= ? AND (CA.THRU_DATE IS NULL OR CA.THRU_DATE > ?))) ORDER BY CA.FROM_DATE DESC Granted XID : {8748944, X} Lock : ROW, CONTENT, (32,10) Waiting XID : {8748944, X} , OFBIZ, UPDATE OFBIZ.CONTENT SET CONTENT_TYPE_ID=?, OWNER_CONTENT_ID=?, DECORATOR_CONTENT_ID=?, INSTANCE_OF_CONTENT_ID=?, DATA_RESOURCE_ID=?, TEMPLATE_DATA_RESOURCE_ID=?, DATA_SOURCE_ID=?, STATUS_ID=?, PRIVILEGE_ENUM_ID=?, SERVICE_NAME=?, CUSTOM_METHOD_ID=?, CONTENT_NAME=?, DESCRIPTION=?, LOCALE_STRING=?, MIME_TYPE_ID=?, CHARACTER_SET_ID=?, CHILD_LEAF_COUNT=?, CHILD_BRANCH_COUNT=?, CREATED_DATE=?, CREATED_BY_USER_LOGIN=?, LAST_MODIFIED_DATE=?, LAST_MODIFIED_BY_USER_LOGIN=?, LAST_UPDATED_STAMP=?, LAST_UPDATED_TX_STAMP=?, CREATED_STAMP=?, CREATED_TX_STAMP=? WHERE CONTENT_ID=? Granted XID : {8748953, S} . The selected victim is XID : 8748953. at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeQuery(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83) ~[commons-dbcp2-2.1.1.jar:2.1.1] at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83) ~[commons-dbcp2-2.1.1.jar:2.1.1] at org.apache.ofbiz.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:399) ~[ofbiz.jar:?] ... 77 more Caused by: org.apache.derby.iapi.error.StandardException: A lock could not be obtained due to a deadlock, cycle of locks and waiters is: Lock : ROW, CONTENT, (32,12) Waiting XID : {8748953, S} , OFBIZ, SELECT CA.CONTENT_ID, CA.FROM_DATE, CA.THRU_DATE, CO.OWNER_CONTENT_ID, CO.CONTENT_ID, CO.CONTENT_TYPE_ID, CO.DESCRIPTION, CO.MIME_TYPE_ID, CO.CHILD_LEAF_COUNT, CO.PRIVILEGE_ENUM_ID, CO.DATA_SOURCE_ID, CO.LAST_MODIFIED_BY_USER_LOGIN, CO.DATA_RESOURCE_ID, CO.CREATED_BY_USER_LOGIN, CO.TEMPLATE_DATA_RESOURCE_ID, CO.LAST_MODIFIED_DATE, CO.INSTANCE_OF_CONTENT_ID, CO.SERVICE_NAME, CO.CUSTOM_METHOD_ID, CO.CHARACTER_SET_ID, CO.CONTENT_NAME, CO.CREATED_DATE, CO.STATUS_ID, CO.LOCALE_STRING, CO.DECORATOR_CONTENT_ID, CO.CHILD_BRANCH_COUNT, CA.SEQUENCE_NUM, CA.LAST_MODIFIED_DATE, CA.CONTENT_ID_TO, CA.UPPER_COORDINATE, CA.LEFT_COORDINATE, CA.CONTENT_ID, CA.MAP_KEY, CA.THRU_DATE, CA.FROM_DATE, CA.CONTENT_ASSOC_PREDICATE_ID, CA.DATA_SOURCE_ID, CA.LAST_MODIFIED_BY_USER_LOGIN, CA.CREATED_DATE, CA.CONTENT_ASSOC_TYPE_ID, CA.CREATED_BY_USER_LOGIN FROM OFBIZ.CONTENT_ASSOC CA INNER JOIN OFBIZ.CONTENT CO ON CA.CONTENT_ID_TO = CO.CONTENT_ID WHERE ((CA.CONTENT_ID = ? AND CA.CONTENT_ASSOC_TYPE_ID = ? AND CA.FROM_DATE <= ? AND (CA.THRU_DATE IS NULL OR CA.THRU_DATE > ?))) ORDER BY CA.FROM_DATE DESC Granted XID : {8748944, X} Lock : ROW, CONTENT, (32,10) Waiting XID : {8748944, X} , OFBIZ, UPDATE OFBIZ.CONTENT SET CONTENT_TYPE_ID=?, OWNER_CONTENT_ID=?, DECORATOR_CONTENT_ID=?, INSTANCE_OF_CONTENT_ID=?, DATA_RESOURCE_ID=?, TEMPLATE_DATA_RESOURCE_ID=?, DATA_SOURCE_ID=?, STATUS_ID=?, PRIVILEGE_ENUM_ID=?, SERVICE_NAME=?, CUSTOM_METHOD_ID=?, CONTENT_NAME=?, DESCRIPTION=?, LOCALE_STRING=?, MIME_TYPE_ID=?, CHARACTER_SET_ID=?, CHILD_LEAF_COUNT=?, CHILD_BRANCH_COUNT=?, CREATED_DATE=?, CREATED_BY_USER_LOGIN=?, LAST_MODIFIED_DATE=?, LAST_MODIFIED_BY_USER_LOGIN=?, LAST_UPDATED_STAMP=?, LAST_UPDATED_TX_STAMP=?, CREATED_STAMP=?, CREATED_TX_STAMP=? WHERE CONTENT_ID=? Granted XID : {8748953, S} . The selected victim is XID : 8748953. at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.services.locks.Deadlock.buildException(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.services.locks.ConcurrentLockSet.lockObject(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.services.locks.AbstractPool.lockObject(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.services.locks.ConcurrentPool.lockObject(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.store.raw.xact.RowLocking2.lockRecordForRead(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.store.access.heap.HeapController.lockRow(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.store.access.heap.HeapController.lockRow(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.store.access.btree.index.B2IRowLocking3.lockRowOnPage(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.store.access.btree.index.B2IRowLocking3._lockScanRow(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.store.access.btree.index.B2IRowLockingRR.lockScanRow(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.store.access.btree.BTreeForwardScan.fetchRows(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.store.access.btree.BTreeScan.fetchNext(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.sql.execute.TableScanResultSet.loopControl(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.sql.execute.TableScanResultSet.getNextRowCore(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.sql.execute.IndexRowToBaseRowResultSet.getNextRowCore(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.sql.execute.NestedLoopJoinResultSet.getNextRowCore(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.getNextRowCore(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.sql.execute.SortResultSet.getRowFromResultSet(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.sql.execute.SortResultSet.getNextRowFromRS(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.sql.execute.SortResultSet.loadSorter(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.sql.execute.SortResultSet.openCore(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.sql.execute.ScrollInsensitiveResultSet.openCore(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.open(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeQuery(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83) ~[commons-dbcp2-2.1.1.jar:2.1.1] at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83) ~[commons-dbcp2-2.1.1.jar:2.1.1] at org.apache.ofbiz.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:399) ~[ofbiz.jar:?] ... 77 more 2022-08-07 08:25:30,065 |27.0.0.1-8009-exec-2 |ModelTreeAction |E| Error doing entity query by condition: org.apache.ofbiz.base.util.GeneralException: Error doing find by condition: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT CA.CONTENT_ID, CA.FROM_DATE, CA.THRU_DATE, CO.OWNER_CONTENT_ID, CO.CONTENT_ID, CO.CONTENT_TYPE_ID, CO.DESCRIPTION, CO.MIME_TYPE_ID, CO.CHILD_LEAF_COUNT, CO.PRIVILEGE_ENUM_ID, CO.DATA_SOURCE_ID, CO.LAST_MODIFIED_BY_USER_LOGIN, CO.DATA_RESOURCE_ID, CO.CREATED_BY_USER_LOGIN, CO.TEMPLATE_DATA_RESOURCE_ID, CO.LAST_MODIFIED_DATE, CO.INSTANCE_OF_CONTENT_ID, CO.SERVICE_NAME, CO.CUSTOM_METHOD_ID, CO.CHARACTER_SET_ID, CO.CONTENT_NAME, CO.CREATED_DATE, CO.STATUS_ID, CO.LOCALE_STRING, CO.DECORATOR_CONTENT_ID, CO.CHILD_BRANCH_COUNT, CA.SEQUENCE_NUM, CA.LAST_MODIFIED_DATE, CA.CONTENT_ID_TO, CA.UPPER_COORDINATE, CA.LEFT_COORDINATE, CA.CONTENT_ID, CA.MAP_KEY, CA.THRU_DATE, CA.FROM_DATE, CA.CONTENT_ASSOC_PREDICATE_ID, CA.DATA_SOURCE_ID, CA.LAST_MODIFIED_BY_USER_LOGIN, CA.CREATED_DATE, CA.CONTENT_ASSOC_TYPE_ID, CA.CREATED_BY_USER_LOGIN FROM OFBIZ.CONTENT_ASSOC CA INNER JOIN OFBIZ.CONTENT CO ON CA.CONTENT_ID_TO = CO.CONTENT_ID WHERE ((CA.CONTENT_ID = ? AND CA.CONTENT_ASSOC_TYPE_ID = ? AND CA.FROM_DATE <= ? AND (CA.THRU_DATE IS NULL OR CA.THRU_DATE > ?))) ORDER BY CA.FROM_DATE DESC (A lock could not be obtained due to a deadlock, cycle of locks and waiters is: Lock : ROW, CONTENT, (32,12) Waiting XID : {8748953, S} , OFBIZ, SELECT CA.CONTENT_ID, CA.FROM_DATE, CA.THRU_DATE, CO.OWNER_CONTENT_ID, CO.CONTENT_ID, CO.CONTENT_TYPE_ID, CO.DESCRIPTION, CO.MIME_TYPE_ID, CO.CHILD_LEAF_COUNT, CO.PRIVILEGE_ENUM_ID, CO.DATA_SOURCE_ID, CO.LAST_MODIFIED_BY_USER_LOGIN, CO.DATA_RESOURCE_ID, CO.CREATED_BY_USER_LOGIN, CO.TEMPLATE_DATA_RESOURCE_ID, CO.LAST_MODIFIED_DATE, CO.INSTANCE_OF_CONTENT_ID, CO.SERVICE_NAME, CO.CUSTOM_METHOD_ID, CO.CHARACTER_SET_ID, CO.CONTENT_NAME, CO.CREATED_DATE, CO.STATUS_ID, CO.LOCALE_STRING, CO.DECORATOR_CONTENT_ID, CO.CHILD_BRANCH_COUNT, CA.SEQUENCE_NUM, CA.LAST_MODIFIED_DATE, CA.CONTENT_ID_TO, CA.UPPER_COORDINATE, CA.LEFT_COORDINATE, CA.CONTENT_ID, CA.MAP_KEY, CA.THRU_DATE, CA.FROM_DATE, CA.CONTENT_ASSOC_PREDICATE_ID, CA.DATA_SOURCE_ID, CA.LAST_MODIFIED_BY_USER_LOGIN, CA.CREATED_DATE, CA.CONTENT_ASSOC_TYPE_ID, CA.CREATED_BY_USER_LOGIN FROM OFBIZ.CONTENT_ASSOC CA INNER JOIN OFBIZ.CONTENT CO ON CA.CONTENT_ID_TO = CO.CONTENT_ID WHERE ((CA.CONTENT_ID = ? AND CA.CONTENT_ASSOC_TYPE_ID = ? AND CA.FROM_DATE <= ? AND (CA.THRU_DATE IS NULL OR CA.THRU_DATE > ?))) ORDER BY CA.FROM_DATE DESC Granted XID : {8748944, X} Lock : ROW, CONTENT, (32,10) Waiting XID : {8748944, X} , OFBIZ, UPDATE OFBIZ.CONTENT SET CONTENT_TYPE_ID=?, OWNER_CONTENT_ID=?, DECORATOR_CONTENT_ID=?, INSTANCE_OF_CONTENT_ID=?, DATA_RESOURCE_ID=?, TEMPLATE_DATA_RESOURCE_ID=?, DATA_SOURCE_ID=?, STATUS_ID=?, PRIVILEGE_ENUM_ID=?, SERVICE_NAME=?, CUSTOM_METHOD_ID=?, CONTENT_NAME=?, DESCRIPTION=?, LOCALE_STRING=?, MIME_TYPE_ID=?, CHARACTER_SET_ID=?, CHILD_LEAF_COUNT=?, CHILD_BRANCH_COUNT=?, CREATED_DATE=?, CREATED_BY_USER_LOGIN=?, LAST_MODIFIED_DATE=?, LAST_MODIFIED_BY_USER_LOGIN=?, LAST_UPDATED_STAMP=?, LAST_UPDATED_TX_STAMP=?, CREATED_STAMP=?, CREATED_TX_STAMP=? WHERE CONTENT_ID=? Granted XID : {8748953, S} . The selected victim is XID : 8748953.) (SQL Exception while executing the following:SELECT CA.CONTENT_ID, CA.FROM_DATE, CA.THRU_DATE, CO.OWNER_CONTENT_ID, CO.CONTENT_ID, CO.CONTENT_TYPE_ID, CO.DESCRIPTION, CO.MIME_TYPE_ID, CO.CHILD_LEAF_COUNT, CO.PRIVILEGE_ENUM_ID, CO.DATA_SOURCE_ID, CO.LAST_MODIFIED_BY_USER_LOGIN, CO.DATA_RESOURCE_ID, CO.CREATED_BY_USER_LOGIN, CO.TEMPLATE_DATA_RESOURCE_ID, CO.LAST_MODIFIED_DATE, CO.INSTANCE_OF_CONTENT_ID, CO.SERVICE_NAME, CO.CUSTOM_METHOD_ID, CO.CHARACTER_SET_ID, CO.CONTENT_NAME, CO.CREATED_DATE, CO.STATUS_ID, CO.LOCALE_STRING, CO.DECORATOR_CONTENT_ID, CO.CHILD_BRANCH_COUNT, CA.SEQUENCE_NUM, CA.LAST_MODIFIED_DATE, CA.CONTENT_ID_TO, CA.UPPER_COORDINATE, CA.LEFT_COORDINATE, CA.CONTENT_ID, CA.MAP_KEY, CA.THRU_DATE, CA.FROM_DATE, CA.CONTENT_ASSOC_PREDICATE_ID, CA.DATA_SOURCE_ID, CA.LAST_MODIFIED_BY_USER_LOGIN, CA.CREATED_DATE, CA.CONTENT_ASSOC_TYPE_ID, CA.CREATED_BY_USER_LOGIN FROM OFBIZ.CONTENT_ASSOC CA INNER JOIN OFBIZ.CONTENT CO ON CA.CONTENT_ID_TO = CO.CONTENT_ID WHERE ((CA.CONTENT_ID = ? AND CA.CONTENT_ASSOC_TYPE_ID = ? AND CA.FROM_DATE <= ? AND (CA.THRU_DATE IS NULL OR CA.THRU_DATE > ?))) ORDER BY CA.FROM_DATE DESC (A lock could not be obtained due to a deadlock, cycle of locks and waiters is: Lock : ROW, CONTENT, (32,12) Waiting XID : {8748953, S} , OFBIZ, SELECT CA.CONTENT_ID, CA.FROM_DATE, CA.THRU_DATE, CO.OWNER_CONTENT_ID, CO.CONTENT_ID, CO.CONTENT_TYPE_ID, CO.DESCRIPTION, CO.MIME_TYPE_ID, CO.CHILD_LEAF_COUNT, CO.PRIVILEGE_ENUM_ID, CO.DATA_SOURCE_ID, CO.LAST_MODIFIED_BY_USER_LOGIN, CO.DATA_RESOURCE_ID, CO.CREATED_BY_USER_LOGIN, CO.TEMPLATE_DATA_RESOURCE_ID, CO.LAST_MODIFIED_DATE, CO.INSTANCE_OF_CONTENT_ID, CO.SERVICE_NAME, CO.CUSTOM_METHOD_ID, CO.CHARACTER_SET_ID, CO.CONTENT_NAME, CO.CREATED_DATE, CO.STATUS_ID, CO.LOCALE_STRING, CO.DECORATOR_CONTENT_ID, CO.CHILD_BRANCH_COUNT, CA.SEQUENCE_NUM, CA.LAST_MODIFIED_DATE, CA.CONTENT_ID_TO, CA.UPPER_COORDINATE, CA.LEFT_COORDINATE, CA.CONTENT_ID, CA.MAP_KEY, CA.THRU_DATE, CA.FROM_DATE, CA.CONTENT_ASSOC_PREDICATE_ID, CA.DATA_SOURCE_ID, CA.LAST_MODIFIED_BY_USER_LOGIN, CA.CREATED_DATE, CA.CONTENT_ASSOC_TYPE_ID, CA.CREATED_BY_USER_LOGIN FROM OFBIZ.CONTENT_ASSOC CA INNER JOIN OFBIZ.CONTENT CO ON CA.CONTENT_ID_TO = CO.CONTENT_ID WHERE ((CA.CONTENT_ID = ? AND CA.CONTENT_ASSOC_TYPE_ID = ? AND CA.FROM_DATE <= ? AND (CA.THRU_DATE IS NULL OR CA.THRU_DATE > ?))) ORDER BY CA.FROM_DATE DESC Granted XID : {8748944, X} Lock : ROW, CONTENT, (32,10) Waiting XID : {8748944, X} , OFBIZ, UPDATE OFBIZ.CONTENT SET CONTENT_TYPE_ID=?, OWNER_CONTENT_ID=?, DECORATOR_CONTENT_ID=?, INSTANCE_OF_CONTENT_ID=?, DATA_RESOURCE_ID=?, TEMPLATE_DATA_RESOURCE_ID=?, DATA_SOURCE_ID=?, STATUS_ID=?, PRIVILEGE_ENUM_ID=?, SERVICE_NAME=?, CUSTOM_METHOD_ID=?, CONTENT_NAME=?, DESCRIPTION=?, LOCALE_STRING=?, MIME_TYPE_ID=?, CHARACTER_SET_ID=?, CHILD_LEAF_COUNT=?, CHILD_BRANCH_COUNT=?, CREATED_DATE=?, CREATED_BY_USER_LOGIN=?, LAST_MODIFIED_DATE=?, LAST_MODIFIED_BY_USER_LOGIN=?, LAST_UPDATED_STAMP=?, LAST_UPDATED_TX_STAMP=?, CREATED_STAMP=?, CREATED_TX_STAMP=? WHERE CONTENT_ID=? Granted XID : {8748953, S} . The selected victim is XID : 8748953.)) org.apache.ofbiz.base.util.GeneralException: Error doing find by condition: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT CA.CONTENT_ID, CA.FROM_DATE, CA.THRU_DATE, CO.OWNER_CONTENT_ID, CO.CONTENT_ID, CO.CONTENT_TYPE_ID, CO.DESCRIPTION, CO.MIME_TYPE_ID, CO.CHILD_LEAF_COUNT, CO.PRIVILEGE_ENUM_ID, CO.DATA_SOURCE_ID, CO.LAST_MODIFIED_BY_USER_LOGIN, CO.DATA_RESOURCE_ID, CO.CREATED_BY_USER_LOGIN, CO.TEMPLATE_DATA_RESOURCE_ID, CO.LAST_MODIFIED_DATE, CO.INSTANCE_OF_CONTENT_ID, CO.SERVICE_NAME, CO.CUSTOM_METHOD_ID, CO.CHARACTER_SET_ID, CO.CONTENT_NAME, CO.CREATED_DATE, CO.STATUS_ID, CO.LOCALE_STRING, CO.DECORATOR_CONTENT_ID, CO.CHILD_BRANCH_COUNT, CA.SEQUENCE_NUM, CA.LAST_MODIFIED_DATE, CA.CONTENT_ID_TO, CA.UPPER_COORDINATE, CA.LEFT_COORDINATE, CA.CONTENT_ID, CA.MAP_KEY, CA.THRU_DATE, CA.FROM_DATE, CA.CONTENT_ASSOC_PREDICATE_ID, CA.DATA_SOURCE_ID, CA.LAST_MODIFIED_BY_USER_LOGIN, CA.CREATED_DATE, CA.CONTENT_ASSOC_TYPE_ID, CA.CREATED_BY_USER_LOGIN FROM OFBIZ.CONTENT_ASSOC CA INNER JOIN OFBIZ.CONTENT CO ON CA.CONTENT_ID_TO = CO.CONTENT_ID WHERE ((CA.CONTENT_ID = ? AND CA.CONTENT_ASSOC_TYPE_ID = ? AND CA.FROM_DATE <= ? AND (CA.THRU_DATE IS NULL OR CA.THRU_DATE > ?))) ORDER BY CA.FROM_DATE DESC (A lock could not be obtained due to a deadlock, cycle of locks and waiters is: Lock : ROW, CONTENT, (32,12) Waiting XID : {8748953, S} , OFBIZ, SELECT CA.CONTENT_ID, CA.FROM_DATE, CA.THRU_DATE, CO.OWNER_CONTENT_ID, CO.CONTENT_ID, CO.CONTENT_TYPE_ID, CO.DESCRIPTION, CO.MIME_TYPE_ID, CO.CHILD_LEAF_COUNT, CO.PRIVILEGE_ENUM_ID, CO.DATA_SOURCE_ID, CO.LAST_MODIFIED_BY_USER_LOGIN, CO.DATA_RESOURCE_ID, CO.CREATED_BY_USER_LOGIN, CO.TEMPLATE_DATA_RESOURCE_ID, CO.LAST_MODIFIED_DATE, CO.INSTANCE_OF_CONTENT_ID, CO.SERVICE_NAME, CO.CUSTOM_METHOD_ID, CO.CHARACTER_SET_ID, CO.CONTENT_NAME, CO.CREATED_DATE, CO.STATUS_ID, CO.LOCALE_STRING, CO.DECORATOR_CONTENT_ID, CO.CHILD_BRANCH_COUNT, CA.SEQUENCE_NUM, CA.LAST_MODIFIED_DATE, CA.CONTENT_ID_TO, CA.UPPER_COORDINATE, CA.LEFT_COORDINATE, CA.CONTENT_ID, CA.MAP_KEY, CA.THRU_DATE, CA.FROM_DATE, CA.CONTENT_ASSOC_PREDICATE_ID, CA.DATA_SOURCE_ID, CA.LAST_MODIFIED_BY_USER_LOGIN, CA.CREATED_DATE, CA.CONTENT_ASSOC_TYPE_ID, CA.CREATED_BY_USER_LOGIN FROM OFBIZ.CONTENT_ASSOC CA INNER JOIN OFBIZ.CONTENT CO ON CA.CONTENT_ID_TO = CO.CONTENT_ID WHERE ((CA.CONTENT_ID = ? AND CA.CONTENT_ASSOC_TYPE_ID = ? AND CA.FROM_DATE <= ? AND (CA.THRU_DATE IS NULL OR CA.THRU_DATE > ?))) ORDER BY CA.FROM_DATE DESC Granted XID : {8748944, X} Lock : ROW, CONTENT, (32,10) Waiting XID : {8748944, X} , OFBIZ, UPDATE OFBIZ.CONTENT SET CONTENT_TYPE_ID=?, OWNER_CONTENT_ID=?, DECORATOR_CONTENT_ID=?, INSTANCE_OF_CONTENT_ID=?, DATA_RESOURCE_ID=?, TEMPLATE_DATA_RESOURCE_ID=?, DATA_SOURCE_ID=?, STATUS_ID=?, PRIVILEGE_ENUM_ID=?, SERVICE_NAME=?, CUSTOM_METHOD_ID=?, CONTENT_NAME=?, DESCRIPTION=?, LOCALE_STRING=?, MIME_TYPE_ID=?, CHARACTER_SET_ID=?, CHILD_LEAF_COUNT=?, CHILD_BRANCH_COUNT=?, CREATED_DATE=?, CREATED_BY_USER_LOGIN=?, LAST_MODIFIED_DATE=?, LAST_MODIFIED_BY_USER_LOGIN=?, LAST_UPDATED_STAMP=?, LAST_UPDATED_TX_STAMP=?, CREATED_STAMP=?, CREATED_TX_STAMP=? WHERE CONTENT_ID=? Granted XID : {8748953, S} . The selected victim is XID : 8748953.) (SQL Exception while executing the following:SELECT CA.CONTENT_ID, CA.FROM_DATE, CA.THRU_DATE, CO.OWNER_CONTENT_ID, CO.CONTENT_ID, CO.CONTENT_TYPE_ID, CO.DESCRIPTION, CO.MIME_TYPE_ID, CO.CHILD_LEAF_COUNT, CO.PRIVILEGE_ENUM_ID, CO.DATA_SOURCE_ID, CO.LAST_MODIFIED_BY_USER_LOGIN, CO.DATA_RESOURCE_ID, CO.CREATED_BY_USER_LOGIN, CO.TEMPLATE_DATA_RESOURCE_ID, CO.LAST_MODIFIED_DATE, CO.INSTANCE_OF_CONTENT_ID, CO.SERVICE_NAME, CO.CUSTOM_METHOD_ID, CO.CHARACTER_SET_ID, CO.CONTENT_NAME, CO.CREATED_DATE, CO.STATUS_ID, CO.LOCALE_STRING, CO.DECORATOR_CONTENT_ID, CO.CHILD_BRANCH_COUNT, CA.SEQUENCE_NUM, CA.LAST_MODIFIED_DATE, CA.CONTENT_ID_TO, CA.UPPER_COORDINATE, CA.LEFT_COORDINATE, CA.CONTENT_ID, CA.MAP_KEY, CA.THRU_DATE, CA.FROM_DATE, CA.CONTENT_ASSOC_PREDICATE_ID, CA.DATA_SOURCE_ID, CA.LAST_MODIFIED_BY_USER_LOGIN, CA.CREATED_DATE, CA.CONTENT_ASSOC_TYPE_ID, CA.CREATED_BY_USER_LOGIN FROM OFBIZ.CONTENT_ASSOC CA INNER JOIN OFBIZ.CONTENT CO ON CA.CONTENT_ID_TO = CO.CONTENT_ID WHERE ((CA.CONTENT_ID = ? AND CA.CONTENT_ASSOC_TYPE_ID = ? AND CA.FROM_DATE <= ? AND (CA.THRU_DATE IS NULL OR CA.THRU_DATE > ?))) ORDER BY CA.FROM_DATE DESC (A lock could not be obtained due to a deadlock, cycle of locks and waiters is: Lock : ROW, CONTENT, (32,12) Waiting XID : {8748953, S} , OFBIZ, SELECT CA.CONTENT_ID, CA.FROM_DATE, CA.THRU_DATE, CO.OWNER_CONTENT_ID, CO.CONTENT_ID, CO.CONTENT_TYPE_ID, CO.DESCRIPTION, CO.MIME_TYPE_ID, CO.CHILD_LEAF_COUNT, CO.PRIVILEGE_ENUM_ID, CO.DATA_SOURCE_ID, CO.LAST_MODIFIED_BY_USER_LOGIN, CO.DATA_RESOURCE_ID, CO.CREATED_BY_USER_LOGIN, CO.TEMPLATE_DATA_RESOURCE_ID, CO.LAST_MODIFIED_DATE, CO.INSTANCE_OF_CONTENT_ID, CO.SERVICE_NAME, CO.CUSTOM_METHOD_ID, CO.CHARACTER_SET_ID, CO.CONTENT_NAME, CO.CREATED_DATE, CO.STATUS_ID, CO.LOCALE_STRING, CO.DECORATOR_CONTENT_ID, CO.CHILD_BRANCH_COUNT, CA.SEQUENCE_NUM, CA.LAST_MODIFIED_DATE, CA.CONTENT_ID_TO, CA.UPPER_COORDINATE, CA.LEFT_COORDINATE, CA.CONTENT_ID, CA.MAP_KEY, CA.THRU_DATE, CA.FROM_DATE, CA.CONTENT_ASSOC_PREDICATE_ID, CA.DATA_SOURCE_ID, CA.LAST_MODIFIED_BY_USER_LOGIN, CA.CREATED_DATE, CA.CONTENT_ASSOC_TYPE_ID, CA.CREATED_BY_USER_LOGIN FROM OFBIZ.CONTENT_ASSOC CA INNER JOIN OFBIZ.CONTENT CO ON CA.CONTENT_ID_TO = CO.CONTENT_ID WHERE ((CA.CONTENT_ID = ? AND CA.CONTENT_ASSOC_TYPE_ID = ? AND CA.FROM_DATE <= ? AND (CA.THRU_DATE IS NULL OR CA.THRU_DATE > ?))) ORDER BY CA.FROM_DATE DESC Granted XID : {8748944, X} Lock : ROW, CONTENT, (32,10) Waiting XID : {8748944, X} , OFBIZ, UPDATE OFBIZ.CONTENT SET CONTENT_TYPE_ID=?, OWNER_CONTENT_ID=?, DECORATOR_CONTENT_ID=?, INSTANCE_OF_CONTENT_ID=?, DATA_RESOURCE_ID=?, TEMPLATE_DATA_RESOURCE_ID=?, DATA_SOURCE_ID=?, STATUS_ID=?, PRIVILEGE_ENUM_ID=?, SERVICE_NAME=?, CUSTOM_METHOD_ID=?, CONTENT_NAME=?, DESCRIPTION=?, LOCALE_STRING=?, MIME_TYPE_ID=?, CHARACTER_SET_ID=?, CHILD_LEAF_COUNT=?, CHILD_BRANCH_COUNT=?, CREATED_DATE=?, CREATED_BY_USER_LOGIN=?, LAST_MODIFIED_DATE=?, LAST_MODIFIED_BY_USER_LOGIN=?, LAST_UPDATED_STAMP=?, LAST_UPDATED_TX_STAMP=?, CREATED_STAMP=?, CREATED_TX_STAMP=? WHERE CONTENT_ID=? Granted XID : {8748953, S} . The selected victim is XID : 8748953.)) at org.apache.ofbiz.entity.finder.ListFinder.runFind(ListFinder.java:237) ~[ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelTreeAction$EntityCondition.runAction(ModelTreeAction.java:239) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.AbstractModelAction.runSubActions(AbstractModelAction.java:143) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelTree$ModelNode.getChildren(ModelTree.java:397) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelTree$ModelNode.hasChildren(ModelTree.java:490) [ofbiz.jar:?] at org.apache.ofbiz.widget.renderer.macro.MacroTreeRenderer.renderNodeBegin(MacroTreeRenderer.java:147) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelTree$ModelNode.renderNodeString(ModelTree.java:564) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelTree.renderTreeString(ModelTree.java:255) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget$Tree.renderWidgetString(ModelScreenWidget.java:1247) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:102) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget$DecoratorSection.renderWidgetString(ModelScreenWidget.java:912) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget$SectionsRenderer.render(ModelScreenWidget.java:131) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget$DecoratorSectionInclude.renderWidgetString(ModelScreenWidget.java:949) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:102) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget$Container.renderWidgetString(ModelScreenWidget.java:462) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:102) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget$Container.renderWidgetString(ModelScreenWidget.java:462) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:102) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget$Container.renderWidgetString(ModelScreenWidget.java:462) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:102) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:284) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:102) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:284) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreen.renderScreenString(ModelScreen.java:164) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ScreenFactory.renderReferencedScreen(ScreenFactory.java:204) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget$DecoratorScreen.renderWidgetString(ModelScreenWidget.java:866) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:102) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:284) [ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreen.renderScreenString(ModelScreen.java:164) [ofbiz.jar:?] at org.apache.ofbiz.widget.renderer.ScreenRenderer.render(ScreenRenderer.java:140) [ofbiz.jar:?] at org.apache.ofbiz.widget.renderer.ScreenRenderer.render(ScreenRenderer.java:102) [ofbiz.jar:?] at org.apache.ofbiz.widget.renderer.macro.MacroScreenViewHandler.render(MacroScreenViewHandler.java:115) [ofbiz.jar:?] at org.apache.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:980) [ofbiz.jar:?] at org.apache.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:657) [ofbiz.jar:?] at org.apache.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:217) [ofbiz.jar:?] at javax.servlet.http.HttpServlet.service(HttpServlet.java:686) [javax.servlet-api-4.0.0.jar:4.0.0] at javax.servlet.http.HttpServlet.service(HttpServlet.java:791) [javax.servlet-api-4.0.0.jar:4.0.0] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) [tomcat-embed-websocket-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.ofbiz.webapp.control.SameSiteFilter.doFilter(SameSiteFilter.java:44) [ofbiz.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.ofbiz.webapp.control.ControlFilter.doFilter(ControlFilter.java:157) [ofbiz.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.ofbiz.content.content.ContentUrlFilter.doFilter(ContentUrlFilter.java:100) [ofbiz.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.ofbiz.product.category.CatalogUrlFilter.doFilter(CatalogUrlFilter.java:337) [ofbiz.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:191) [ofbiz.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:688) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:415) [tomcat-coyote-9.0.31.jar:9.0.31] at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) [tomcat-coyote-9.0.31.jar:9.0.31] at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868) [tomcat-coyote-9.0.31.jar:9.0.31] at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1639) [tomcat-coyote-9.0.31.jar:9.0.31] at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-coyote-9.0.31.jar:9.0.31] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_201] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_201] at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util-9.0.31.jar:9.0.31] at java.lang.Thread.run(Thread.java:748) [?:1.8.0_201] Caused by: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT CA.CONTENT_ID, CA.FROM_DATE, CA.THRU_DATE, CO.OWNER_CONTENT_ID, CO.CONTENT_ID, CO.CONTENT_TYPE_ID, CO.DESCRIPTION, CO.MIME_TYPE_ID, CO.CHILD_LEAF_COUNT, CO.PRIVILEGE_ENUM_ID, CO.DATA_SOURCE_ID, CO.LAST_MODIFIED_BY_USER_LOGIN, CO.DATA_RESOURCE_ID, CO.CREATED_BY_USER_LOGIN, CO.TEMPLATE_DATA_RESOURCE_ID, CO.LAST_MODIFIED_DATE, CO.INSTANCE_OF_CONTENT_ID, CO.SERVICE_NAME, CO.CUSTOM_METHOD_ID, CO.CHARACTER_SET_ID, CO.CONTENT_NAME, CO.CREATED_DATE, CO.STATUS_ID, CO.LOCALE_STRING, CO.DECORATOR_CONTENT_ID, CO.CHILD_BRANCH_COUNT, CA.SEQUENCE_NUM, CA.LAST_MODIFIED_DATE, CA.CONTENT_ID_TO, CA.UPPER_COORDINATE, CA.LEFT_COORDINATE, CA.CONTENT_ID, CA.MAP_KEY, CA.THRU_DATE, CA.FROM_DATE, CA.CONTENT_ASSOC_PREDICATE_ID, CA.DATA_SOURCE_ID, CA.LAST_MODIFIED_BY_USER_LOGIN, CA.CREATED_DATE, CA.CONTENT_ASSOC_TYPE_ID, CA.CREATED_BY_USER_LOGIN FROM OFBIZ.CONTENT_ASSOC CA INNER JOIN OFBIZ.CONTENT CO ON CA.CONTENT_ID_TO = CO.CONTENT_ID WHERE ((CA.CONTENT_ID = ? AND CA.CONTENT_ASSOC_TYPE_ID = ? AND CA.FROM_DATE <= ? AND (CA.THRU_DATE IS NULL OR CA.THRU_DATE > ?))) ORDER BY CA.FROM_DATE DESC (A lock could not be obtained due to a deadlock, cycle of locks and waiters is: Lock : ROW, CONTENT, (32,12) Waiting XID : {8748953, S} , OFBIZ, SELECT CA.CONTENT_ID, CA.FROM_DATE, CA.THRU_DATE, CO.OWNER_CONTENT_ID, CO.CONTENT_ID, CO.CONTENT_TYPE_ID, CO.DESCRIPTION, CO.MIME_TYPE_ID, CO.CHILD_LEAF_COUNT, CO.PRIVILEGE_ENUM_ID, CO.DATA_SOURCE_ID, CO.LAST_MODIFIED_BY_USER_LOGIN, CO.DATA_RESOURCE_ID, CO.CREATED_BY_USER_LOGIN, CO.TEMPLATE_DATA_RESOURCE_ID, CO.LAST_MODIFIED_DATE, CO.INSTANCE_OF_CONTENT_ID, CO.SERVICE_NAME, CO.CUSTOM_METHOD_ID, CO.CHARACTER_SET_ID, CO.CONTENT_NAME, CO.CREATED_DATE, CO.STATUS_ID, CO.LOCALE_STRING, CO.DECORATOR_CONTENT_ID, CO.CHILD_BRANCH_COUNT, CA.SEQUENCE_NUM, CA.LAST_MODIFIED_DATE, CA.CONTENT_ID_TO, CA.UPPER_COORDINATE, CA.LEFT_COORDINATE, CA.CONTENT_ID, CA.MAP_KEY, CA.THRU_DATE, CA.FROM_DATE, CA.CONTENT_ASSOC_PREDICATE_ID, CA.DATA_SOURCE_ID, CA.LAST_MODIFIED_BY_USER_LOGIN, CA.CREATED_DATE, CA.CONTENT_ASSOC_TYPE_ID, CA.CREATED_BY_USER_LOGIN FROM OFBIZ.CONTENT_ASSOC CA INNER JOIN OFBIZ.CONTENT CO ON CA.CONTENT_ID_TO = CO.CONTENT_ID WHERE ((CA.CONTENT_ID = ? AND CA.CONTENT_ASSOC_TYPE_ID = ? AND CA.FROM_DATE <= ? AND (CA.THRU_DATE IS NULL OR CA.THRU_DATE > ?))) ORDER BY CA.FROM_DATE DESC Granted XID : {8748944, X} Lock : ROW, CONTENT, (32,10) Waiting XID : {8748944, X} , OFBIZ, UPDATE OFBIZ.CONTENT SET CONTENT_TYPE_ID=?, OWNER_CONTENT_ID=?, DECORATOR_CONTENT_ID=?, INSTANCE_OF_CONTENT_ID=?, DATA_RESOURCE_ID=?, TEMPLATE_DATA_RESOURCE_ID=?, DATA_SOURCE_ID=?, STATUS_ID=?, PRIVILEGE_ENUM_ID=?, SERVICE_NAME=?, CUSTOM_METHOD_ID=?, CONTENT_NAME=?, DESCRIPTION=?, LOCALE_STRING=?, MIME_TYPE_ID=?, CHARACTER_SET_ID=?, CHILD_LEAF_COUNT=?, CHILD_BRANCH_COUNT=?, CREATED_DATE=?, CREATED_BY_USER_LOGIN=?, LAST_MODIFIED_DATE=?, LAST_MODIFIED_BY_USER_LOGIN=?, LAST_UPDATED_STAMP=?, LAST_UPDATED_TX_STAMP=?, CREATED_STAMP=?, CREATED_TX_STAMP=? WHERE CONTENT_ID=? Granted XID : {8748953, S} . The selected victim is XID : 8748953.) at org.apache.ofbiz.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:402) ~[ofbiz.jar:?] at org.apache.ofbiz.entity.datasource.GenericDAO.selectListIteratorByCondition(GenericDAO.java:736) ~[ofbiz.jar:?] at org.apache.ofbiz.entity.datasource.GenericHelperDAO.findListIteratorByCondition(GenericHelperDAO.java:141) ~[ofbiz.jar:?] at org.apache.ofbiz.entity.GenericDelegator.find(GenericDelegator.java:1563) ~[ofbiz.jar:?] at org.apache.ofbiz.entity.finder.ListFinder.runFind(ListFinder.java:215) ~[ofbiz.jar:?] ... 73 more Caused by: java.sql.SQLTransactionRollbackException: A lock could not be obtained due to a deadlock, cycle of locks and waiters is: Lock : ROW, CONTENT, (32,12) Waiting XID : {8748953, S} , OFBIZ, SELECT CA.CONTENT_ID, CA.FROM_DATE, CA.THRU_DATE, CO.OWNER_CONTENT_ID, CO.CONTENT_ID, CO.CONTENT_TYPE_ID, CO.DESCRIPTION, CO.MIME_TYPE_ID, CO.CHILD_LEAF_COUNT, CO.PRIVILEGE_ENUM_ID, CO.DATA_SOURCE_ID, CO.LAST_MODIFIED_BY_USER_LOGIN, CO.DATA_RESOURCE_ID, CO.CREATED_BY_USER_LOGIN, CO.TEMPLATE_DATA_RESOURCE_ID, CO.LAST_MODIFIED_DATE, CO.INSTANCE_OF_CONTENT_ID, CO.SERVICE_NAME, CO.CUSTOM_METHOD_ID, CO.CHARACTER_SET_ID, CO.CONTENT_NAME, CO.CREATED_DATE, CO.STATUS_ID, CO.LOCALE_STRING, CO.DECORATOR_CONTENT_ID, CO.CHILD_BRANCH_COUNT, CA.SEQUENCE_NUM, CA.LAST_MODIFIED_DATE, CA.CONTENT_ID_TO, CA.UPPER_COORDINATE, CA.LEFT_COORDINATE, CA.CONTENT_ID, CA.MAP_KEY, CA.THRU_DATE, CA.FROM_DATE, CA.CONTENT_ASSOC_PREDICATE_ID, CA.DATA_SOURCE_ID, CA.LAST_MODIFIED_BY_USER_LOGIN, CA.CREATED_DATE, CA.CONTENT_ASSOC_TYPE_ID, CA.CREATED_BY_USER_LOGIN FROM OFBIZ.CONTENT_ASSOC CA INNER JOIN OFBIZ.CONTENT CO ON CA.CONTENT_ID_TO = CO.CONTENT_ID WHERE ((CA.CONTENT_ID = ? AND CA.CONTENT_ASSOC_TYPE_ID = ? AND CA.FROM_DATE <= ? AND (CA.THRU_DATE IS NULL OR CA.THRU_DATE > ?))) ORDER BY CA.FROM_DATE DESC Granted XID : {8748944, X} Lock : ROW, CONTENT, (32,10) Waiting XID : {8748944, X} , OFBIZ, UPDATE OFBIZ.CONTENT SET CONTENT_TYPE_ID=?, OWNER_CONTENT_ID=?, DECORATOR_CONTENT_ID=?, INSTANCE_OF_CONTENT_ID=?, DATA_RESOURCE_ID=?, TEMPLATE_DATA_RESOURCE_ID=?, DATA_SOURCE_ID=?, STATUS_ID=?, PRIVILEGE_ENUM_ID=?, SERVICE_NAME=?, CUSTOM_METHOD_ID=?, CONTENT_NAME=?, DESCRIPTION=?, LOCALE_STRING=?, MIME_TYPE_ID=?, CHARACTER_SET_ID=?, CHILD_LEAF_COUNT=?, CHILD_BRANCH_COUNT=?, CREATED_DATE=?, CREATED_BY_USER_LOGIN=?, LAST_MODIFIED_DATE=?, LAST_MODIFIED_BY_USER_LOGIN=?, LAST_UPDATED_STAMP=?, LAST_UPDATED_TX_STAMP=?, CREATED_STAMP=?, CREATED_TX_STAMP=? WHERE CONTENT_ID=? Granted XID : {8748953, S} . The selected victim is XID : 8748953. at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeQuery(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83) ~[commons-dbcp2-2.1.1.jar:2.1.1] at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83) ~[commons-dbcp2-2.1.1.jar:2.1.1] at org.apache.ofbiz.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:399) ~[ofbiz.jar:?] at org.apache.ofbiz.entity.datasource.GenericDAO.selectListIteratorByCondition(GenericDAO.java:736) ~[ofbiz.jar:?] at org.apache.ofbiz.entity.datasource.GenericHelperDAO.findListIteratorByCondition(GenericHelperDAO.java:141) ~[ofbiz.jar:?] at org.apache.ofbiz.entity.GenericDelegator.find(GenericDelegator.java:1563) ~[ofbiz.jar:?] at org.apache.ofbiz.entity.finder.ListFinder.runFind(ListFinder.java:215) ~[ofbiz.jar:?] ... 73 more Caused by: org.apache.derby.iapi.error.StandardException: A lock could not be obtained due to a deadlock, cycle of locks and waiters is: Lock : ROW, CONTENT, (32,12) Waiting XID : {8748953, S} , OFBIZ, SELECT CA.CONTENT_ID, CA.FROM_DATE, CA.THRU_DATE, CO.OWNER_CONTENT_ID, CO.CONTENT_ID, CO.CONTENT_TYPE_ID, CO.DESCRIPTION, CO.MIME_TYPE_ID, CO.CHILD_LEAF_COUNT, CO.PRIVILEGE_ENUM_ID, CO.DATA_SOURCE_ID, CO.LAST_MODIFIED_BY_USER_LOGIN, CO.DATA_RESOURCE_ID, CO.CREATED_BY_USER_LOGIN, CO.TEMPLATE_DATA_RESOURCE_ID, CO.LAST_MODIFIED_DATE, CO.INSTANCE_OF_CONTENT_ID, CO.SERVICE_NAME, CO.CUSTOM_METHOD_ID, CO.CHARACTER_SET_ID, CO.CONTENT_NAME, CO.CREATED_DATE, CO.STATUS_ID, CO.LOCALE_STRING, CO.DECORATOR_CONTENT_ID, CO.CHILD_BRANCH_COUNT, CA.SEQUENCE_NUM, CA.LAST_MODIFIED_DATE, CA.CONTENT_ID_TO, CA.UPPER_COORDINATE, CA.LEFT_COORDINATE, CA.CONTENT_ID, CA.MAP_KEY, CA.THRU_DATE, CA.FROM_DATE, CA.CONTENT_ASSOC_PREDICATE_ID, CA.DATA_SOURCE_ID, CA.LAST_MODIFIED_BY_USER_LOGIN, CA.CREATED_DATE, CA.CONTENT_ASSOC_TYPE_ID, CA.CREATED_BY_USER_LOGIN FROM OFBIZ.CONTENT_ASSOC CA INNER JOIN OFBIZ.CONTENT CO ON CA.CONTENT_ID_TO = CO.CONTENT_ID WHERE ((CA.CONTENT_ID = ? AND CA.CONTENT_ASSOC_TYPE_ID = ? AND CA.FROM_DATE <= ? AND (CA.THRU_DATE IS NULL OR CA.THRU_DATE > ?))) ORDER BY CA.FROM_DATE DESC Granted XID : {8748944, X} Lock : ROW, CONTENT, (32,10) Waiting XID : {8748944, X} , OFBIZ, UPDATE OFBIZ.CONTENT SET CONTENT_TYPE_ID=?, OWNER_CONTENT_ID=?, DECORATOR_CONTENT_ID=?, INSTANCE_OF_CONTENT_ID=?, DATA_RESOURCE_ID=?, TEMPLATE_DATA_RESOURCE_ID=?, DATA_SOURCE_ID=?, STATUS_ID=?, PRIVILEGE_ENUM_ID=?, SERVICE_NAME=?, CUSTOM_METHOD_ID=?, CONTENT_NAME=?, DESCRIPTION=?, LOCALE_STRING=?, MIME_TYPE_ID=?, CHARACTER_SET_ID=?, CHILD_LEAF_COUNT=?, CHILD_BRANCH_COUNT=?, CREATED_DATE=?, CREATED_BY_USER_LOGIN=?, LAST_MODIFIED_DATE=?, LAST_MODIFIED_BY_USER_LOGIN=?, LAST_UPDATED_STAMP=?, LAST_UPDATED_TX_STAMP=?, CREATED_STAMP=?, CREATED_TX_STAMP=? WHERE CONTENT_ID=? Granted XID : {8748953, S} . The selected victim is XID : 8748953. at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.services.locks.Deadlock.buildException(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.services.locks.ConcurrentLockSet.lockObject(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.services.locks.AbstractPool.lockObject(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.services.locks.ConcurrentPool.lockObject(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.store.raw.xact.RowLocking2.lockRecordForRead(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.store.access.heap.HeapController.lockRow(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.store.access.heap.HeapController.lockRow(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.store.access.btree.index.B2IRowLocking3.lockRowOnPage(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.store.access.btree.index.B2IRowLocking3._lockScanRow(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.store.access.btree.index.B2IRowLockingRR.lockScanRow(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.store.access.btree.BTreeForwardScan.fetchRows(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.store.access.btree.BTreeScan.fetchNext(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.sql.execute.TableScanResultSet.loopControl(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.sql.execute.TableScanResultSet.getNextRowCore(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.sql.execute.IndexRowToBaseRowResultSet.getNextRowCore(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.sql.execute.NestedLoopJoinResultSet.getNextRowCore(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.getNextRowCore(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.sql.execute.SortResultSet.getRowFromResultSet(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.sql.execute.SortResultSet.getNextRowFromRS(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.sql.execute.SortResultSet.loadSorter(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.sql.execute.SortResultSet.openCore(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.sql.execute.ScrollInsensitiveResultSet.openCore(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.open(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeQuery(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83) ~[commons-dbcp2-2.1.1.jar:2.1.1] at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83) ~[commons-dbcp2-2.1.1.jar:2.1.1] at org.apache.ofbiz.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:399) ~[ofbiz.jar:?] at org.apache.ofbiz.entity.datasource.GenericDAO.selectListIteratorByCondition(GenericDAO.java:736) ~[ofbiz.jar:?] at org.apache.ofbiz.entity.datasource.GenericHelperDAO.findListIteratorByCondition(GenericHelperDAO.java:141) ~[ofbiz.jar:?] at org.apache.ofbiz.entity.GenericDelegator.find(GenericDelegator.java:1563) ~[ofbiz.jar:?] at org.apache.ofbiz.entity.finder.ListFinder.runFind(ListFinder.java:215) ~[ofbiz.jar:?] ... 73 more 2022-08-07 08:25:30,112 |27.0.0.1-8009-exec-2 |ControlServlet |E| Error in request handler: java.lang.IllegalArgumentException: Error doing entity query by condition: org.apache.ofbiz.base.util.GeneralException: Error doing find by condition: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT CA.CONTENT_ID, CA.FROM_DATE, CA.THRU_DATE, CO.OWNER_CONTENT_ID, CO.CONTENT_ID, CO.CONTENT_TYPE_ID, CO.DESCRIPTION, CO.MIME_TYPE_ID, CO.CHILD_LEAF_COUNT, CO.PRIVILEGE_ENUM_ID, CO.DATA_SOURCE_ID, CO.LAST_MODIFIED_BY_USER_LOGIN, CO.DATA_RESOURCE_ID, CO.CREATED_BY_USER_LOGIN, CO.TEMPLATE_DATA_RESOURCE_ID, CO.LAST_MODIFIED_DATE, CO.INSTANCE_OF_CONTENT_ID, CO.SERVICE_NAME, CO.CUSTOM_METHOD_ID, CO.CHARACTER_SET_ID, CO.CONTENT_NAME, CO.CREATED_DATE, CO.STATUS_ID, CO.LOCALE_STRING, CO.DECORATOR_CONTENT_ID, CO.CHILD_BRANCH_COUNT, CA.SEQUENCE_NUM, CA.LAST_MODIFIED_DATE, CA.CONTENT_ID_TO, CA.UPPER_COORDINATE, CA.LEFT_COORDINATE, CA.CONTENT_ID, CA.MAP_KEY, CA.THRU_DATE, CA.FROM_DATE, CA.CONTENT_ASSOC_PREDICATE_ID, CA.DATA_SOURCE_ID, CA.LAST_MODIFIED_BY_USER_LOGIN, CA.CREATED_DATE, CA.CONTENT_ASSOC_TYPE_ID, CA.CREATED_BY_USER_LOGIN FROM OFBIZ.CONTENT_ASSOC CA INNER JOIN OFBIZ.CONTENT CO ON CA.CONTENT_ID_TO = CO.CONTENT_ID WHERE ((CA.CONTENT_ID = ? AND CA.CONTENT_ASSOC_TYPE_ID = ? AND CA.FROM_DATE <= ? AND (CA.THRU_DATE IS NULL OR CA.THRU_DATE > ?))) ORDER BY CA.FROM_DATE DESC (A lock could not be obtained due to a deadlock, cycle of locks and waiters is: Lock : ROW, CONTENT, (32,12) Waiting XID : {8748953, S} , OFBIZ, SELECT CA.CONTENT_ID, CA.FROM_DATE, CA.THRU_DATE, CO.OWNER_CONTENT_ID, CO.CONTENT_ID, CO.CONTENT_TYPE_ID, CO.DESCRIPTION, CO.MIME_TYPE_ID, CO.CHILD_LEAF_COUNT, CO.PRIVILEGE_ENUM_ID, CO.DATA_SOURCE_ID, CO.LAST_MODIFIED_BY_USER_LOGIN, CO.DATA_RESOURCE_ID, CO.CREATED_BY_USER_LOGIN, CO.TEMPLATE_DATA_RESOURCE_ID, CO.LAST_MODIFIED_DATE, CO.INSTANCE_OF_CONTENT_ID, CO.SERVICE_NAME, CO.CUSTOM_METHOD_ID, CO.CHARACTER_SET_ID, CO.CONTENT_NAME, CO.CREATED_DATE, CO.STATUS_ID, CO.LOCALE_STRING, CO.DECORATOR_CONTENT_ID, CO.CHILD_BRANCH_COUNT, CA.SEQUENCE_NUM, CA.LAST_MODIFIED_DATE, CA.CONTENT_ID_TO, CA.UPPER_COORDINATE, CA.LEFT_COORDINATE, CA.CONTENT_ID, CA.MAP_KEY, CA.THRU_DATE, CA.FROM_DATE, CA.CONTENT_ASSOC_PREDICATE_ID, CA.DATA_SOURCE_ID, CA.LAST_MODIFIED_BY_USER_LOGIN, CA.CREATED_DATE, CA.CONTENT_ASSOC_TYPE_ID, CA.CREATED_BY_USER_LOGIN FROM OFBIZ.CONTENT_ASSOC CA INNER JOIN OFBIZ.CONTENT CO ON CA.CONTENT_ID_TO = CO.CONTENT_ID WHERE ((CA.CONTENT_ID = ? AND CA.CONTENT_ASSOC_TYPE_ID = ? AND CA.FROM_DATE <= ? AND (CA.THRU_DATE IS NULL OR CA.THRU_DATE > ?))) ORDER BY CA.FROM_DATE DESC Granted XID : {8748944, X} Lock : ROW, CONTENT, (32,10) Waiting XID : {8748944, X} , OFBIZ, UPDATE OFBIZ.CONTENT SET CONTENT_TYPE_ID=?, OWNER_CONTENT_ID=?, DECORATOR_CONTENT_ID=?, INSTANCE_OF_CONTENT_ID=?, DATA_RESOURCE_ID=?, TEMPLATE_DATA_RESOURCE_ID=?, DATA_SOURCE_ID=?, STATUS_ID=?, PRIVILEGE_ENUM_ID=?, SERVICE_NAME=?, CUSTOM_METHOD_ID=?, CONTENT_NAME=?, DESCRIPTION=?, LOCALE_STRING=?, MIME_TYPE_ID=?, CHARACTER_SET_ID=?, CHILD_LEAF_COUNT=?, CHILD_BRANCH_COUNT=?, CREATED_DATE=?, CREATED_BY_USER_LOGIN=?, LAST_MODIFIED_DATE=?, LAST_MODIFIED_BY_USER_LOGIN=?, LAST_UPDATED_STAMP=?, LAST_UPDATED_TX_STAMP=?, CREATED_STAMP=?, CREATED_TX_STAMP=? WHERE CONTENT_ID=? Granted XID : {8748953, S} . The selected victim is XID : 8748953.) (SQL Exception while executing the following:SELECT CA.CONTENT_ID, CA.FROM_DATE, CA.THRU_DATE, CO.OWNER_CONTENT_ID, CO.CONTENT_ID, CO.CONTENT_TYPE_ID, CO.DESCRIPTION, CO.MIME_TYPE_ID, CO.CHILD_LEAF_COUNT, CO.PRIVILEGE_ENUM_ID, CO.DATA_SOURCE_ID, CO.LAST_MODIFIED_BY_USER_LOGIN, CO.DATA_RESOURCE_ID, CO.CREATED_BY_USER_LOGIN, CO.TEMPLATE_DATA_RESOURCE_ID, CO.LAST_MODIFIED_DATE, CO.INSTANCE_OF_CONTENT_ID, CO.SERVICE_NAME, CO.CUSTOM_METHOD_ID, CO.CHARACTER_SET_ID, CO.CONTENT_NAME, CO.CREATED_DATE, CO.STATUS_ID, CO.LOCALE_STRING, CO.DECORATOR_CONTENT_ID, CO.CHILD_BRANCH_COUNT, CA.SEQUENCE_NUM, CA.LAST_MODIFIED_DATE, CA.CONTENT_ID_TO, CA.UPPER_COORDINATE, CA.LEFT_COORDINATE, CA.CONTENT_ID, CA.MAP_KEY, CA.THRU_DATE, CA.FROM_DATE, CA.CONTENT_ASSOC_PREDICATE_ID, CA.DATA_SOURCE_ID, CA.LAST_MODIFIED_BY_USER_LOGIN, CA.CREATED_DATE, CA.CONTENT_ASSOC_TYPE_ID, CA.CREATED_BY_USER_LOGIN FROM OFBIZ.CONTENT_ASSOC CA INNER JOIN OFBIZ.CONTENT CO ON CA.CONTENT_ID_TO = CO.CONTENT_ID WHERE ((CA.CONTENT_ID = ? AND CA.CONTENT_ASSOC_TYPE_ID = ? AND CA.FROM_DATE <= ? AND (CA.THRU_DATE IS NULL OR CA.THRU_DATE > ?))) ORDER BY CA.FROM_DATE DESC (A lock could not be obtained due to a deadlock, cycle of locks and waiters is: Lock : ROW, CONTENT, (32,12) Waiting XID : {8748953, S} , OFBIZ, SELECT CA.CONTENT_ID, CA.FROM_DATE, CA.THRU_DATE, CO.OWNER_CONTENT_ID, CO.CONTENT_ID, CO.CONTENT_TYPE_ID, CO.DESCRIPTION, CO.MIME_TYPE_ID, CO.CHILD_LEAF_COUNT, CO.PRIVILEGE_ENUM_ID, CO.DATA_SOURCE_ID, CO.LAST_MODIFIED_BY_USER_LOGIN, CO.DATA_RESOURCE_ID, CO.CREATED_BY_USER_LOGIN, CO.TEMPLATE_DATA_RESOURCE_ID, CO.LAST_MODIFIED_DATE, CO.INSTANCE_OF_CONTENT_ID, CO.SERVICE_NAME, CO.CUSTOM_METHOD_ID, CO.CHARACTER_SET_ID, CO.CONTENT_NAME, CO.CREATED_DATE, CO.STATUS_ID, CO.LOCALE_STRING, CO.DECORATOR_CONTENT_ID, CO.CHILD_BRANCH_COUNT, CA.SEQUENCE_NUM, CA.LAST_MODIFIED_DATE, CA.CONTENT_ID_TO, CA.UPPER_COORDINATE, CA.LEFT_COORDINATE, CA.CONTENT_ID, CA.MAP_KEY, CA.THRU_DATE, CA.FROM_DATE, CA.CONTENT_ASSOC_PREDICATE_ID, CA.DATA_SOURCE_ID, CA.LAST_MODIFIED_BY_USER_LOGIN, CA.CREATED_DATE, CA.CONTENT_ASSOC_TYPE_ID, CA.CREATED_BY_USER_LOGIN FROM OFBIZ.CONTENT_ASSOC CA INNER JOIN OFBIZ.CONTENT CO ON CA.CONTENT_ID_TO = CO.CONTENT_ID WHERE ((CA.CONTENT_ID = ? AND CA.CONTENT_ASSOC_TYPE_ID = ? AND CA.FROM_DATE <= ? AND (CA.THRU_DATE IS NULL OR CA.THRU_DATE > ?))) ORDER BY CA.FROM_DATE DESC Granted XID : {8748944, X} Lock : ROW, CONTENT, (32,10) Waiting XID : {8748944, X} , OFBIZ, UPDATE OFBIZ.CONTENT SET CONTENT_TYPE_ID=?, OWNER_CONTENT_ID=?, DECORATOR_CONTENT_ID=?, INSTANCE_OF_CONTENT_ID=?, DATA_RESOURCE_ID=?, TEMPLATE_DATA_RESOURCE_ID=?, DATA_SOURCE_ID=?, STATUS_ID=?, PRIVILEGE_ENUM_ID=?, SERVICE_NAME=?, CUSTOM_METHOD_ID=?, CONTENT_NAME=?, DESCRIPTION=?, LOCALE_STRING=?, MIME_TYPE_ID=?, CHARACTER_SET_ID=?, CHILD_LEAF_COUNT=?, CHILD_BRANCH_COUNT=?, CREATED_DATE=?, CREATED_BY_USER_LOGIN=?, LAST_MODIFIED_DATE=?, LAST_MODIFIED_BY_USER_LOGIN=?, LAST_UPDATED_STAMP=?, LAST_UPDATED_TX_STAMP=?, CREATED_STAMP=?, CREATED_TX_STAMP=? WHERE CONTENT_ID=? Granted XID : {8748953, S} . The selected victim is XID : 8748953.)) at org.apache.ofbiz.widget.model.ModelTreeAction$EntityCondition.runAction(ModelTreeAction.java:253) ~[ofbiz.jar:?] at org.apache.ofbiz.widget.model.AbstractModelAction.runSubActions(AbstractModelAction.java:143) ~[ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelTree$ModelNode.getChildren(ModelTree.java:397) ~[ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelTree$ModelNode.hasChildren(ModelTree.java:490) ~[ofbiz.jar:?] at org.apache.ofbiz.widget.renderer.macro.MacroTreeRenderer.renderNodeBegin(MacroTreeRenderer.java:147) ~[ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelTree$ModelNode.renderNodeString(ModelTree.java:564) ~[ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelTree.renderTreeString(ModelTree.java:255) ~[ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget$Tree.renderWidgetString(ModelScreenWidget.java:1247) ~[ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:102) ~[ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget$DecoratorSection.renderWidgetString(ModelScreenWidget.java:912) ~[ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget$SectionsRenderer.render(ModelScreenWidget.java:131) ~[ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget$DecoratorSectionInclude.renderWidgetString(ModelScreenWidget.java:949) ~[ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:102) ~[ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget$Container.renderWidgetString(ModelScreenWidget.java:462) ~[ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:102) ~[ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget$Container.renderWidgetString(ModelScreenWidget.java:462) ~[ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:102) ~[ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget$Container.renderWidgetString(ModelScreenWidget.java:462) ~[ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:102) ~[ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:284) ~[ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:102) ~[ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:284) ~[ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreen.renderScreenString(ModelScreen.java:164) ~[ofbiz.jar:?] at org.apache.ofbiz.widget.model.ScreenFactory.renderReferencedScreen(ScreenFactory.java:204) ~[ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget$DecoratorScreen.renderWidgetString(ModelScreenWidget.java:866) ~[ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget.renderSubWidgetsString(ModelScreenWidget.java:102) ~[ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreenWidget$Section.renderWidgetString(ModelScreenWidget.java:284) ~[ofbiz.jar:?] at org.apache.ofbiz.widget.model.ModelScreen.renderScreenString(ModelScreen.java:164) ~[ofbiz.jar:?] at org.apache.ofbiz.widget.renderer.ScreenRenderer.render(ScreenRenderer.java:140) ~[ofbiz.jar:?] at org.apache.ofbiz.widget.renderer.ScreenRenderer.render(ScreenRenderer.java:102) ~[ofbiz.jar:?] at org.apache.ofbiz.widget.renderer.macro.MacroScreenViewHandler.render(MacroScreenViewHandler.java:115) ~[ofbiz.jar:?] at org.apache.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:980) ~[ofbiz.jar:?] at org.apache.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:657) ~[ofbiz.jar:?] at org.apache.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:217) [ofbiz.jar:?] at javax.servlet.http.HttpServlet.service(HttpServlet.java:686) [javax.servlet-api-4.0.0.jar:4.0.0] at javax.servlet.http.HttpServlet.service(HttpServlet.java:791) [javax.servlet-api-4.0.0.jar:4.0.0] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) [tomcat-embed-websocket-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.ofbiz.webapp.control.SameSiteFilter.doFilter(SameSiteFilter.java:44) [ofbiz.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.ofbiz.webapp.control.ControlFilter.doFilter(ControlFilter.java:157) [ofbiz.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.ofbiz.content.content.ContentUrlFilter.doFilter(ContentUrlFilter.java:100) [ofbiz.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.ofbiz.product.category.CatalogUrlFilter.doFilter(CatalogUrlFilter.java:337) [ofbiz.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:191) [ofbiz.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:688) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:415) [tomcat-coyote-9.0.31.jar:9.0.31] at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) [tomcat-coyote-9.0.31.jar:9.0.31] at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868) [tomcat-coyote-9.0.31.jar:9.0.31] at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1639) [tomcat-coyote-9.0.31.jar:9.0.31] at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-coyote-9.0.31.jar:9.0.31] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_201] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_201] at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util-9.0.31.jar:9.0.31] at java.lang.Thread.run(Thread.java:748) [?:1.8.0_201] 2022-08-07 08:25:30,143 |27.0.0.1-8009-exec-2 |ControlServlet |E| An error occurred, going to the errorPage: /error/error.jsp 2022-08-07 08:25:30,143 |27.0.0.1-8009-exec-2 |ControlServlet |E| Including errorPage: /error/error.jsp 2022-08-07 08:25:30,143 |27.0.0.1-8009-exec-2 |TransactionUtil |E| [TransactionUtil.rollback] java.lang.Exception: Stack Trace at org.apache.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:315) [ofbiz.jar:?] at org.apache.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:299) [ofbiz.jar:?] at org.apache.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:315) [ofbiz.jar:?] at javax.servlet.http.HttpServlet.service(HttpServlet.java:686) [javax.servlet-api-4.0.0.jar:4.0.0] at javax.servlet.http.HttpServlet.service(HttpServlet.java:791) [javax.servlet-api-4.0.0.jar:4.0.0] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) [tomcat-embed-websocket-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.ofbiz.webapp.control.SameSiteFilter.doFilter(SameSiteFilter.java:44) [ofbiz.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.ofbiz.webapp.control.ControlFilter.doFilter(ControlFilter.java:157) [ofbiz.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.ofbiz.content.content.ContentUrlFilter.doFilter(ContentUrlFilter.java:100) [ofbiz.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.ofbiz.product.category.CatalogUrlFilter.doFilter(CatalogUrlFilter.java:337) [ofbiz.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:191) [ofbiz.jar:?] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:688) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) [tomcat-catalina-9.0.31.jar:9.0.31] at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:415) [tomcat-coyote-9.0.31.jar:9.0.31] at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) [tomcat-coyote-9.0.31.jar:9.0.31] at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868) [tomcat-coyote-9.0.31.jar:9.0.31] at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1639) [tomcat-coyote-9.0.31.jar:9.0.31] at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-coyote-9.0.31.jar:9.0.31] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_201] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_201] at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util-9.0.31.jar:9.0.31] at java.lang.Thread.run(Thread.java:748) [?:1.8.0_201] 2022-08-07 08:30:39,405 |27.0.0.1-8009-exec-6 |ServiceUtil |E| {errorMessage=Product not found in the current category., responseMessage=fail} 2022-08-07 12:38:45,787 |27.0.0.1-8009-exec-6 |ServiceUtil |E| {errorMessage=Product not found in the current category., responseMessage=fail} 2022-08-07 15:12:12,429 |27.0.0.1-8009-exec-7 |ServiceUtil |E| {errorMessage=Product not found in the current category., responseMessage=fail}