2024-04-28 00:37:21,898 |.0.0.1-8009-exec-485 |RequestHandler |E| Domain 50.21.190.236 not accepted to prevent host header injection 2024-04-28 00:37:21,898 |.0.0.1-8009-exec-485 |ControlServlet |E| Error in request handler: org.apache.ofbiz.webapp.control.RequestHandlerException: Domain 50.21.190.236 not accepted to prevent host header injection at org.apache.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:131) ~[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] 2024-04-28 00:37:21,929 |.0.0.1-8009-exec-485 |ControlServlet |E| An error occurred, going to the errorPage: /error/error.jsp 2024-04-28 00:37:21,929 |.0.0.1-8009-exec-485 |ControlServlet |E| Including errorPage: /error/error.jsp 2024-04-28 06:52:04,108 |.0.0.1-8009-exec-452 |ServiceUtil |E| {errorMessage=Product not found in the current category., responseMessage=fail} 2024-04-28 11:34:29,907 |.0.0.1-8009-exec-487 |ServiceUtil |E| {errorMessage=Product not found in the current category., responseMessage=fail} 2024-04-28 11:34:37,409 |.0.0.1-8009-exec-487 |ContentWorker |E| No dataResourceId found for contentId: STORE_POLICIES 2024-04-28 11:35:05,098 |.0.0.1-8009-exec-452 |ServiceUtil |E| {errorMessage=Product not found in the current category., responseMessage=fail} 2024-04-28 11:35:11,070 |.0.0.1-8009-exec-489 |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 2024-04-28 11:35:11,086 |.0.0.1-8009-exec-489 |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. 2024-04-28 11:35:19,242 |.0.0.1-8009-exec-493 |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 2024-04-28 11:35:19,242 |.0.0.1-8009-exec-493 |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. 2024-04-28 11:35:22,256 |.0.0.1-8009-exec-485 |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. 2024-04-28 11:35:24,928 |.0.0.1-8009-exec-492 |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. 2024-04-28 11:36:39,501 |.0.0.1-8009-exec-495 |ServiceUtil |E| {errorMessage=Product not found in the current category., responseMessage=fail} 2024-04-28 11:36:40,110 |.0.0.1-8009-exec-490 |ServiceUtil |E| {errorMessage=Product not found in the current category., responseMessage=fail} 2024-04-28 11:36:46,103 |.0.0.1-8009-exec-494 |ServiceUtil |E| {errorMessage=Product not found in the current category., responseMessage=fail} 2024-04-28 11:36:58,697 |.0.0.1-8009-exec-495 |ServiceUtil |E| {errorMessage=Product not found in the current category., responseMessage=fail} 2024-04-28 11:37:00,759 |.0.0.1-8009-exec-493 |ServiceUtil |E| {errorMessage=Product not found in the current category., responseMessage=fail} 2024-04-28 11:37:07,376 |.0.0.1-8009-exec-495 |ServiceUtil |E| {errorMessage=Product not found in the current category., responseMessage=fail} 2024-04-28 11:37:07,423 |.0.0.1-8009-exec-493 |ServiceUtil |E| {errorMessage=Product not found in the current category., responseMessage=fail} 2024-04-28 11:37:07,501 |.0.0.1-8009-exec-491 |ServiceUtil |E| {errorMessage=Product not found in the current category., responseMessage=fail} 2024-04-28 11:37:09,876 |.0.0.1-8009-exec-497 |ServiceUtil |E| {errorMessage=Product not found in the current category., responseMessage=fail} 2024-04-28 11:37:09,970 |.0.0.1-8009-exec-496 |ServiceUtil |E| {errorMessage=Product not found in the current category., responseMessage=fail} 2024-04-28 11:37:11,798 |.0.0.1-8009-exec-495 |ServiceUtil |E| {errorMessage=Product not found in the current category., responseMessage=fail} 2024-04-28 11:37:11,705 |.0.0.1-8009-exec-494 |GenericDelegator |E| Failure in findByCondition operation for entity [ContentAssocDataResourceViewTo]: org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT CA.CONTENT_ID, 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, 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, DR.DATA_RESOURCE_NAME, DR.SURVEY_ID, DR.DATA_TEMPLATE_TYPE_ID, DR.LAST_MODIFIED_DATE, DR.MIME_TYPE_ID, DR.DATA_CATEGORY_ID, DR.SURVEY_RESPONSE_ID, DR.CHARACTER_SET_ID, DR.DATA_SOURCE_ID, DR.LAST_MODIFIED_BY_USER_LOGIN, DR.CREATED_DATE, DR.STATUS_ID, DR.LOCALE_STRING, DR.RELATED_DETAIL_ID, DR.DATA_RESOURCE_ID, DR.IS_PUBLIC, DR.OBJECT_INFO, DR.DATA_RESOURCE_TYPE_ID, DR.CREATED_BY_USER_LOGIN FROM (OFBIZ.CONTENT_ASSOC CA LEFT OUTER JOIN OFBIZ.CONTENT CO ON CA.CONTENT_ID_TO = CO.CONTENT_ID) LEFT OUTER JOIN OFBIZ.DATA_RESOURCE DR ON CO.DATA_RESOURCE_ID = DR.DATA_RESOURCE_ID WHERE ((DR.DATA_RESOURCE_TYPE_ID = ? AND CA.CONTENT_ASSOC_TYPE_ID = ? AND CA.CONTENT_ID = ?)) (A lock could not be obtained due to a deadlock, cycle of locks and waiters is: Lock : ROW, CONTENT, (32,12) Waiting XID : {16125113, S} , OFBIZ, SELECT CA.CONTENT_ID, 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, 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, DR.DATA_RESOURCE_NAME, DR.SURVEY_ID, DR.DATA_TEMPLATE_TYPE_ID, DR.LAST_MODIFIED_DATE, DR.MIME_TYPE_ID, DR.DATA_CATEGORY_ID, DR.SURVEY_RESPONSE_ID, DR.CHARACTER_SET_ID, DR.DATA_SOURCE_ID, DR.LAST_MODIFIED_BY_USER_LOGIN, DR.CREATED_DATE, DR.STATUS_ID, DR.LOCALE_STRING, DR.RELATED_DETAIL_ID, DR.DATA_RESOURCE_ID, DR.IS_PUBLIC, DR.OBJECT_INFO, DR.DATA_RESOURCE_TYPE_ID, DR.CREATED_BY_USER_LOGIN FROM (OFBIZ.CONTENT_ASSOC CA LEFT OUTER JOIN OFBIZ.CONTENT CO ON CA.CONTENT_ID_TO = CO.CONTENT_ID) LEFT OUTER JOIN OFBIZ.DATA_RESOURCE DR ON CO.DATA_RESOURCE_ID = DR.DATA_RESOURCE_ID WHERE ((DR.DATA_RESOURCE_TYPE_ID = ? AND CA.CONTENT_ASSOC_TYPE_ID = ? AND CA.CONTENT_ID = ?)) Granted XID : {16125100, X} Lock : ROW, CONTENT, (32,10) Waiting XID : {16125100, 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 : {16125113, S} . The selected victim is XID : 16125113.). Rolling back transaction. org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT CA.CONTENT_ID, 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, 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, DR.DATA_RESOURCE_NAME, DR.SURVEY_ID, DR.DATA_TEMPLATE_TYPE_ID, DR.LAST_MODIFIED_DATE, DR.MIME_TYPE_ID, DR.DATA_CATEGORY_ID, DR.SURVEY_RESPONSE_ID, DR.CHARACTER_SET_ID, DR.DATA_SOURCE_ID, DR.LAST_MODIFIED_BY_USER_LOGIN, DR.CREATED_DATE, DR.STATUS_ID, DR.LOCALE_STRING, DR.RELATED_DETAIL_ID, DR.DATA_RESOURCE_ID, DR.IS_PUBLIC, DR.OBJECT_INFO, DR.DATA_RESOURCE_TYPE_ID, DR.CREATED_BY_USER_LOGIN FROM (OFBIZ.CONTENT_ASSOC CA LEFT OUTER JOIN OFBIZ.CONTENT CO ON CA.CONTENT_ID_TO = CO.CONTENT_ID) LEFT OUTER JOIN OFBIZ.DATA_RESOURCE DR ON CO.DATA_RESOURCE_ID = DR.DATA_RESOURCE_ID WHERE ((DR.DATA_RESOURCE_TYPE_ID = ? AND CA.CONTENT_ASSOC_TYPE_ID = ? AND CA.CONTENT_ID = ?)) (A lock could not be obtained due to a deadlock, cycle of locks and waiters is: Lock : ROW, CONTENT, (32,12) Waiting XID : {16125113, S} , OFBIZ, SELECT CA.CONTENT_ID, 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, 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, DR.DATA_RESOURCE_NAME, DR.SURVEY_ID, DR.DATA_TEMPLATE_TYPE_ID, DR.LAST_MODIFIED_DATE, DR.MIME_TYPE_ID, DR.DATA_CATEGORY_ID, DR.SURVEY_RESPONSE_ID, DR.CHARACTER_SET_ID, DR.DATA_SOURCE_ID, DR.LAST_MODIFIED_BY_USER_LOGIN, DR.CREATED_DATE, DR.STATUS_ID, DR.LOCALE_STRING, DR.RELATED_DETAIL_ID, DR.DATA_RESOURCE_ID, DR.IS_PUBLIC, DR.OBJECT_INFO, DR.DATA_RESOURCE_TYPE_ID, DR.CREATED_BY_USER_LOGIN FROM (OFBIZ.CONTENT_ASSOC CA LEFT OUTER JOIN OFBIZ.CONTENT CO ON CA.CONTENT_ID_TO = CO.CONTENT_ID) LEFT OUTER JOIN OFBIZ.DATA_RESOURCE DR ON CO.DATA_RESOURCE_ID = DR.DATA_RESOURCE_ID WHERE ((DR.DATA_RESOURCE_TYPE_ID = ? AND CA.CONTENT_ASSOC_TYPE_ID = ? AND CA.CONTENT_ID = ?)) Granted XID : {16125100, X} Lock : ROW, CONTENT, (32,10) Waiting XID : {16125100, 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 : {16125113, S} . The selected victim is XID : 16125113.) 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.GenericDelegator.findList(GenericDelegator.java:1597) [ofbiz.jar:?] at org.apache.ofbiz.entity.util.EntityQuery.query(EntityQuery.java:451) [ofbiz.jar:?] at org.apache.ofbiz.entity.util.EntityQuery.queryList(EntityQuery.java:381) [ofbiz.jar:?] at org.apache.ofbiz.product.category.CatalogUrlFilter.doFilter(CatalogUrlFilter.java:98) [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 : {16125113, S} , OFBIZ, SELECT CA.CONTENT_ID, 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, 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, DR.DATA_RESOURCE_NAME, DR.SURVEY_ID, DR.DATA_TEMPLATE_TYPE_ID, DR.LAST_MODIFIED_DATE, DR.MIME_TYPE_ID, DR.DATA_CATEGORY_ID, DR.SURVEY_RESPONSE_ID, DR.CHARACTER_SET_ID, DR.DATA_SOURCE_ID, DR.LAST_MODIFIED_BY_USER_LOGIN, DR.CREATED_DATE, DR.STATUS_ID, DR.LOCALE_STRING, DR.RELATED_DETAIL_ID, DR.DATA_RESOURCE_ID, DR.IS_PUBLIC, DR.OBJECT_INFO, DR.DATA_RESOURCE_TYPE_ID, DR.CREATED_BY_USER_LOGIN FROM (OFBIZ.CONTENT_ASSOC CA LEFT OUTER JOIN OFBIZ.CONTENT CO ON CA.CONTENT_ID_TO = CO.CONTENT_ID) LEFT OUTER JOIN OFBIZ.DATA_RESOURCE DR ON CO.DATA_RESOURCE_ID = DR.DATA_RESOURCE_ID WHERE ((DR.DATA_RESOURCE_TYPE_ID = ? AND CA.CONTENT_ASSOC_TYPE_ID = ? AND CA.CONTENT_ID = ?)) Granted XID : {16125100, X} Lock : ROW, CONTENT, (32,10) Waiting XID : {16125100, 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 : {16125113, S} . The selected victim is XID : 16125113. 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:?] ... 29 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 : {16125113, S} , OFBIZ, SELECT CA.CONTENT_ID, 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, 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, DR.DATA_RESOURCE_NAME, DR.SURVEY_ID, DR.DATA_TEMPLATE_TYPE_ID, DR.LAST_MODIFIED_DATE, DR.MIME_TYPE_ID, DR.DATA_CATEGORY_ID, DR.SURVEY_RESPONSE_ID, DR.CHARACTER_SET_ID, DR.DATA_SOURCE_ID, DR.LAST_MODIFIED_BY_USER_LOGIN, DR.CREATED_DATE, DR.STATUS_ID, DR.LOCALE_STRING, DR.RELATED_DETAIL_ID, DR.DATA_RESOURCE_ID, DR.IS_PUBLIC, DR.OBJECT_INFO, DR.DATA_RESOURCE_TYPE_ID, DR.CREATED_BY_USER_LOGIN FROM (OFBIZ.CONTENT_ASSOC CA LEFT OUTER JOIN OFBIZ.CONTENT CO ON CA.CONTENT_ID_TO = CO.CONTENT_ID) LEFT OUTER JOIN OFBIZ.DATA_RESOURCE DR ON CO.DATA_RESOURCE_ID = DR.DATA_RESOURCE_ID WHERE ((DR.DATA_RESOURCE_TYPE_ID = ? AND CA.CONTENT_ASSOC_TYPE_ID = ? AND CA.CONTENT_ID = ?)) Granted XID : {16125100, X} Lock : ROW, CONTENT, (32,10) Waiting XID : {16125100, 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 : {16125113, S} . The selected victim is XID : 16125113. 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.NestedLoopLeftOuterJoinResultSet.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.JoinResultSet.openCore(Unknown Source) ~[derby-10.14.1.0.jar:?] at org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.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:?] ... 29 more 2024-04-28 11:37:11,798 |.0.0.1-8009-exec-489 |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 : {16125080, 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 : {16125100, X} Lock : ROW, CONTENT, (32,10) Waiting XID : {16125100, 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 : {16125113, S} , {16125080, S} . The selected victim is XID : 16125080.) 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 : {16125080, 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 : {16125100, X} Lock : ROW, CONTENT, (32,10) Waiting XID : {16125100, 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 : {16125113, S} , {16125080, S} . The selected victim is XID : 16125080. 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 : {16125080, 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 : {16125100, X} Lock : ROW, CONTENT, (32,10) Waiting XID : {16125100, 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 : {16125113, S} , {16125080, S} . The selected victim is XID : 16125080. 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 2024-04-28 11:37:11,845 |.0.0.1-8009-exec-489 |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 : {16125080, 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 : {16125100, X} Lock : ROW, CONTENT, (32,10) Waiting XID : {16125100, 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 : {16125113, S} , {16125080, S} . The selected victim is XID : 16125080.) 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 : {16125080, 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 : {16125100, X} Lock : ROW, CONTENT, (32,10) Waiting XID : {16125100, 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 : {16125113, S} , {16125080, S} . The selected victim is XID : 16125080. 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 : {16125080, 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 : {16125100, X} Lock : ROW, CONTENT, (32,10) Waiting XID : {16125100, 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 : {16125113, S} , {16125080, S} . The selected victim is XID : 16125080. 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 2024-04-28 11:37:11,861 |.0.0.1-8009-exec-489 |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 : {16125080, 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 : {16125100, X} Lock : ROW, CONTENT, (32,10) Waiting XID : {16125100, 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 : {16125113, S} , {16125080, S} . The selected victim is XID : 16125080.) (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 : {16125080, 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 : {16125100, X} Lock : ROW, CONTENT, (32,10) Waiting XID : {16125100, 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 : {16125113, S} , {16125080, S} . The selected victim is XID : 16125080.)) 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 : {16125080, 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 : {16125100, X} Lock : ROW, CONTENT, (32,10) Waiting XID : {16125100, 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 : {16125113, S} , {16125080, S} . The selected victim is XID : 16125080.) (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 : {16125080, 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 : {16125100, X} Lock : ROW, CONTENT, (32,10) Waiting XID : {16125100, 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 : {16125113, S} , {16125080, S} . The selected victim is XID : 16125080.)) 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 : {16125080, 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 : {16125100, X} Lock : ROW, CONTENT, (32,10) Waiting XID : {16125100, 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 : {16125113, S} , {16125080, S} . The selected victim is XID : 16125080.) 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 : {16125080, 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 : {16125100, X} Lock : ROW, CONTENT, (32,10) Waiting XID : {16125100, 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 : {16125113, S} , {16125080, S} . The selected victim is XID : 16125080. 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 : {16125080, 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 : {16125100, X} Lock : ROW, CONTENT, (32,10) Waiting XID : {16125100, 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 : {16125113, S} , {16125080, S} . The selected victim is XID : 16125080. 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 2024-04-28 11:37:11,876 |.0.0.1-8009-exec-489 |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 : {16125080, 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 : {16125100, X} Lock : ROW, CONTENT, (32,10) Waiting XID : {16125100, 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 : {16125113, S} , {16125080, S} . The selected victim is XID : 16125080.) (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 : {16125080, 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 : {16125100, X} Lock : ROW, CONTENT, (32,10) Waiting XID : {16125100, 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 : {16125113, S} , {16125080, S} . The selected victim is XID : 16125080.)) 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] 2024-04-28 11:37:11,876 |.0.0.1-8009-exec-489 |ControlServlet |E| An error occurred, going to the errorPage: /error/error.jsp 2024-04-28 11:37:11,876 |.0.0.1-8009-exec-489 |ControlServlet |E| Including errorPage: /error/error.jsp 2024-04-28 11:37:11,892 |.0.0.1-8009-exec-489 |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] 2024-04-28 11:37:14,828 |.0.0.1-8009-exec-452 |ServiceUtil |E| {errorMessage=Product not found in the current category., responseMessage=fail} 2024-04-28 11:37:14,860 |.0.0.1-8009-exec-500 |FreeMarkerWorker |E| null freemarker.core._TemplateModelException: Java method "org.apache.ofbiz.product.product.ProductSearchSession$ProductSearchOptions.searchGetConstraintStrings(boolean, org.apache.ofbiz.entity.Delegator, Locale)" threw an exception when invoked on org.apache.ofbiz.product.product.ProductSearchSession$ProductSearchOptions object "org.apache.ofbiz.product.product.ProductSearchSession$ProductSearchOptions@66866e40"; see cause exception in the Java stack trace. ---- FTL stack trace ("~" means nesting-related): - Failed at: #assign constraintStrings = searchOpt... [in template "component://ecommerce/template/catalog/MiniLastProductSearches.ftl" at line 54, column 13] ---- at freemarker.ext.beans._MethodUtil.newInvocationTemplateModelException(_MethodUtil.java:289) ~[freemarker-2.3.28.jar:2.3.28] at freemarker.ext.beans._MethodUtil.newInvocationTemplateModelException(_MethodUtil.java:261) ~[freemarker-2.3.28.jar:2.3.28] at freemarker.ext.beans.OverloadedMethodsModel.exec(OverloadedMethodsModel.java:65) ~[freemarker-2.3.28.jar:2.3.28] at freemarker.core.MethodCall._eval(MethodCall.java:65) ~[freemarker-2.3.28.jar:2.3.28] at freemarker.core.Expression.eval(Expression.java:83) ~[freemarker-2.3.28.jar:2.3.28] at freemarker.core.Assignment.accept(Assignment.java:134) ~[freemarker-2.3.28.jar:2.3.28] at freemarker.core.Environment.visit(Environment.java:366) [freemarker-2.3.28.jar:2.3.28] at freemarker.core.IteratorBlock$IterationContext.executedNestedContentForCollOrSeqListing(IteratorBlock.java:317) [freemarker-2.3.28.jar:2.3.28] at freemarker.core.IteratorBlock$IterationContext.executeNestedContent(IteratorBlock.java:271) [freemarker-2.3.28.jar:2.3.28] at freemarker.core.IteratorBlock$IterationContext.accept(IteratorBlock.java:242) [freemarker-2.3.28.jar:2.3.28] at freemarker.core.Environment.visitIteratorBlock(Environment.java:642) [freemarker-2.3.28.jar:2.3.28] at freemarker.core.IteratorBlock.acceptWithResult(IteratorBlock.java:107) [freemarker-2.3.28.jar:2.3.28] at freemarker.core.IteratorBlock.accept(IteratorBlock.java:93) [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.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$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$IncludeScreen.renderWidgetString(ModelScreenWidget.java:786) [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$IncludeScreen.renderWidgetString(ModelScreenWidget.java:786) [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$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$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.lang.NullPointerException at org.apache.ofbiz.content.content.ContentWorker.renderContentAsText(ContentWorker.java:367) ~[ofbiz.jar:?] at org.apache.ofbiz.product.category.CategoryContentWrapper.getProductCategoryContentAsText(CategoryContentWrapper.java:152) ~[ofbiz.jar:?] at org.apache.ofbiz.product.category.CategoryContentWrapper.getProductCategoryContentAsText(CategoryContentWrapper.java:106) ~[ofbiz.jar:?] at org.apache.ofbiz.product.category.CategoryContentWrapper.getProductCategoryContentAsText(CategoryContentWrapper.java:93) ~[ofbiz.jar:?] at org.apache.ofbiz.product.product.ProductSearch$CategoryConstraint.prettyPrintConstraint(ProductSearch.java:993) ~[ofbiz.jar:?] at org.apache.ofbiz.product.product.ProductSearchSession$ProductSearchOptions.searchGetConstraintStrings(ProductSearchSession.java:292) ~[ofbiz.jar:?] at sun.reflect.GeneratedMethodAccessor884.invoke(Unknown Source) ~[?:?] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_201] at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_201] at freemarker.ext.beans.BeansWrapper.invokeMethod(BeansWrapper.java:1505) ~[freemarker-2.3.28.jar:2.3.28] at freemarker.ext.beans.ReflectionCallableMemberDescriptor.invokeMethod(ReflectionCallableMemberDescriptor.java:56) ~[freemarker-2.3.28.jar:2.3.28] at freemarker.ext.beans.MemberAndArguments.invokeMethod(MemberAndArguments.java:51) ~[freemarker-2.3.28.jar:2.3.28] at freemarker.ext.beans.OverloadedMethodsModel.exec(OverloadedMethodsModel.java:61) ~[freemarker-2.3.28.jar:2.3.28] ... 96 more 2024-04-28 11:37:14,891 |.0.0.1-8009-exec-500 |FreeMarkerWorker |E| null freemarker.core.InvalidReferenceException: The following has evaluated to null or missing: ==> constraintStrings [in template "component://ecommerce/template/catalog/MiniLastProductSearches.ftl" at line 55, column 20] ---- 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: #list constraintStrings as constraint... [in template "component://ecommerce/template/catalog/MiniLastProductSearches.ftl" at line 55, column 13] ---- at freemarker.core.InvalidReferenceException.getInstance(InvalidReferenceException.java:134) ~[freemarker-2.3.28.jar:2.3.28] at freemarker.core.Expression.assertNonNull(Expression.java:233) ~[freemarker-2.3.28.jar:2.3.28] at freemarker.core.IteratorBlock.acceptWithResult(IteratorBlock.java:103) ~[freemarker-2.3.28.jar:2.3.28] at freemarker.core.IteratorBlock.accept(IteratorBlock.java:93) ~[freemarker-2.3.28.jar:2.3.28] at freemarker.core.Environment.visit(Environment.java:366) [freemarker-2.3.28.jar:2.3.28] at freemarker.core.IteratorBlock$IterationContext.executedNestedContentForCollOrSeqListing(IteratorBlock.java:317) [freemarker-2.3.28.jar:2.3.28] at freemarker.core.IteratorBlock$IterationContext.executeNestedContent(IteratorBlock.java:271) [freemarker-2.3.28.jar:2.3.28] at freemarker.core.IteratorBlock$IterationContext.accept(IteratorBlock.java:242) [freemarker-2.3.28.jar:2.3.28] at freemarker.core.Environment.visitIteratorBlock(Environment.java:642) [freemarker-2.3.28.jar:2.3.28] at freemarker.core.IteratorBlock.acceptWithResult(IteratorBlock.java:107) [freemarker-2.3.28.jar:2.3.28] at freemarker.core.IteratorBlock.accept(IteratorBlock.java:93) [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.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$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$IncludeScreen.renderWidgetString(ModelScreenWidget.java:786) [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$IncludeScreen.renderWidgetString(ModelScreenWidget.java:786) [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$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$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] 2024-04-28 11:37:15,125 |.0.0.1-8009-exec-498 |ServiceUtil |E| {errorMessage=Product not found in the current category., responseMessage=fail} 2024-04-28 11:37:24,588 |.0.0.1-8009-exec-498 |ServiceUtil |E| {errorMessage=Product not found in the current category., responseMessage=fail} 2024-04-28 11:37:25,166 |.0.0.1-8009-exec-494 |ServiceUtil |E| {errorMessage=Product not found in the current category., responseMessage=fail} 2024-04-28 11:37:27,556 |.0.0.1-8009-exec-496 |ServiceUtil |E| {errorMessage=Product not found in the current category., responseMessage=fail} 2024-04-28 11:37:28,838 |.0.0.1-8009-exec-487 |ServiceUtil |E| {errorMessage=Product not found in the current category., responseMessage=fail} 2024-04-28 11:37:28,853 |.0.0.1-8009-exec-498 |ServiceUtil |E| {errorMessage=Product not found in the current category., responseMessage=fail} 2024-04-28 11:37:30,681 |.0.0.1-8009-exec-485 |ServiceUtil |E| {errorMessage=Product not found in the current category., responseMessage=fail} 2024-04-28 11:37:31,838 |.0.0.1-8009-exec-489 |ServiceUtil |E| {errorMessage=Product not found in the current category., responseMessage=fail} 2024-04-28 11:39:10,207 |.0.0.1-8009-exec-452 |ServiceUtil |E| {errorMessage=Product not found in the current category., responseMessage=fail} 2024-04-28 11:39:17,311 |.0.0.1-8009-exec-490 |ServiceUtil |E| {errorMessage=Product not found in the current category., responseMessage=fail} 2024-04-28 11:39:18,203 |.0.0.1-8009-exec-493 |ServiceUtil |E| {errorMessage=Product not found in the current category., responseMessage=fail} 2024-04-28 11:39:20,094 |.0.0.1-8009-exec-492 |ServiceUtil |E| {errorMessage=Product not found in the current category., responseMessage=fail} 2024-04-28 11:39:20,219 |.0.0.1-8009-exec-493 |ServiceUtil |E| {errorMessage=Product not found in the current category., responseMessage=fail} 2024-04-28 11:39:20,781 |.0.0.1-8009-exec-497 |ServiceUtil |E| {errorMessage=Product not found in the current category., responseMessage=fail} 2024-04-28 11:39:20,859 |.0.0.1-8009-exec-452 |ServiceUtil |E| {errorMessage=Product not found in the current category., responseMessage=fail} 2024-04-28 11:45:05,801 |.0.0.1-8009-exec-496 |RequestHandler |E| Domain 50.21.190.236 not accepted to prevent host header injection 2024-04-28 11:45:05,801 |.0.0.1-8009-exec-496 |ControlServlet |E| Error in request handler: org.apache.ofbiz.webapp.control.RequestHandlerException: Domain 50.21.190.236 not accepted to prevent host header injection at org.apache.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:131) ~[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] 2024-04-28 11:45:05,848 |.0.0.1-8009-exec-496 |ControlServlet |E| An error occurred, going to the errorPage: /error/error.jsp 2024-04-28 11:45:05,848 |.0.0.1-8009-exec-496 |ControlServlet |E| Including errorPage: /error/error.jsp 2024-04-28 14:07:43,155 |.0.0.1-8009-exec-492 |RequestHandler |E| Domain 50.21.190.236 not accepted to prevent host header injection 2024-04-28 14:07:43,155 |.0.0.1-8009-exec-492 |ControlServlet |E| Error in request handler: org.apache.ofbiz.webapp.control.RequestHandlerException: Domain 50.21.190.236 not accepted to prevent host header injection at org.apache.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:131) ~[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] 2024-04-28 14:07:43,187 |.0.0.1-8009-exec-492 |ControlServlet |E| An error occurred, going to the errorPage: /error/error.jsp 2024-04-28 14:07:43,187 |.0.0.1-8009-exec-492 |ControlServlet |E| Including errorPage: /error/error.jsp 2024-04-28 17:17:46,589 |.0.0.1-8009-exec-493 |RequestHandler |E| Domain 50.21.190.236 not accepted to prevent host header injection 2024-04-28 17:17:46,589 |.0.0.1-8009-exec-493 |ControlServlet |E| Error in request handler: org.apache.ofbiz.webapp.control.RequestHandlerException: Domain 50.21.190.236 not accepted to prevent host header injection at org.apache.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:131) ~[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] 2024-04-28 17:17:46,636 |.0.0.1-8009-exec-493 |ControlServlet |E| An error occurred, going to the errorPage: /error/error.jsp 2024-04-28 17:17:46,636 |.0.0.1-8009-exec-493 |ControlServlet |E| Including errorPage: /error/error.jsp 2024-04-28 19:14:28,743 |.0.0.1-8009-exec-493 |RequestHandler |E| Domain owa.polluniverse.com not accepted to prevent host header injection 2024-04-28 19:14:28,743 |.0.0.1-8009-exec-493 |ControlServlet |E| Error in request handler: org.apache.ofbiz.webapp.control.RequestHandlerException: Domain owa.polluniverse.com not accepted to prevent host header injection at org.apache.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:131) ~[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] 2024-04-28 19:14:28,821 |.0.0.1-8009-exec-493 |ControlServlet |E| An error occurred, going to the errorPage: /error/error.jsp 2024-04-28 19:14:28,821 |.0.0.1-8009-exec-493 |ControlServlet |E| Including errorPage: /error/error.jsp 2024-04-28 19:15:21,912 |.0.0.1-8009-exec-496 |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 2024-04-28 19:15:21,912 |.0.0.1-8009-exec-496 |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. 2024-04-28 19:45:49,809 |.0.0.1-8009-exec-492 |RequestHandler |E| Domain 50.21.190.236 not accepted to prevent host header injection 2024-04-28 19:45:49,809 |.0.0.1-8009-exec-492 |ControlServlet |E| Error in request handler: org.apache.ofbiz.webapp.control.RequestHandlerException: Domain 50.21.190.236 not accepted to prevent host header injection at org.apache.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:131) ~[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] 2024-04-28 19:45:49,856 |.0.0.1-8009-exec-492 |ControlServlet |E| An error occurred, going to the errorPage: /error/error.jsp 2024-04-28 19:45:49,856 |.0.0.1-8009-exec-492 |ControlServlet |E| Including errorPage: /error/error.jsp 2024-04-28 19:51:22,246 |.0.0.1-8009-exec-493 |ModelService |E| [ModelService.validate] : {signUpForContactList} : (IN) Required test error: org.apache.ofbiz.service.ServiceValidationException: The following required parameter is missing: [IN] [signUpForContactList.contactListId]The following required parameter is missing: [IN] [signUpForContactList.email] 2024-04-28 19:51:22,246 |.0.0.1-8009-exec-493 |ServiceDispatcher |E| Incoming context (in runSync : signUpForContactList) does not match expected requirements org.apache.ofbiz.service.ServiceValidationException: The following required parameter is missing: [IN] [signUpForContactList.contactListId]The following required parameter is missing: [IN] [signUpForContactList.email] at org.apache.ofbiz.service.ModelService.validate(ModelService.java:679) ~[ofbiz.jar:?] at org.apache.ofbiz.service.ModelService.validate(ModelService.java:597) ~[ofbiz.jar:?] at org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:383) [ofbiz.jar:?] at org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:228) [ofbiz.jar:?] at org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:88) [ofbiz.jar:?] at org.apache.ofbiz.webapp.event.ServiceEventHandler.invoke(ServiceEventHandler.java:246) [ofbiz.jar:?] at org.apache.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:741) [ofbiz.jar:?] at org.apache.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:465) [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] 2024-04-28 19:51:22,277 |.0.0.1-8009-exec-493 |RequestHandler |E| Request signUpForContactList caused an error with the following message: [The following required parameter is missing: [IN] [signUpForContactList.contactListId], The following required parameter is missing: [IN] [signUpForContactList.email]] 2024-04-28 22:08:48,753 |.0.0.1-8009-exec-497 |RequestHandler |E| Domain 50.21.190.236 not accepted to prevent host header injection 2024-04-28 22:08:48,753 |.0.0.1-8009-exec-497 |ControlServlet |E| Error in request handler: org.apache.ofbiz.webapp.control.RequestHandlerException: Domain 50.21.190.236 not accepted to prevent host header injection at org.apache.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:131) ~[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.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.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.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] 2024-04-28 22:08:48,816 |.0.0.1-8009-exec-497 |ControlServlet |E| An error occurred, going to the errorPage: file:/C:/Apache24/htdocs/www/polluniverse.com/apache-ofbiz-17.12.03/framework/common/webcommon/error/Error.ftl 2024-04-28 22:12:00,246 |.0.0.1-8009-exec-452 |RequestHandler |E| Domain 50.21.190.236 not accepted to prevent host header injection 2024-04-28 22:12:00,246 |.0.0.1-8009-exec-452 |ControlServlet |E| Error in request handler: org.apache.ofbiz.webapp.control.RequestHandlerException: Domain 50.21.190.236 not accepted to prevent host header injection at org.apache.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:131) ~[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.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.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.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] 2024-04-28 22:12:00,308 |.0.0.1-8009-exec-452 |ControlServlet |E| An error occurred, going to the errorPage: file:/C:/Apache24/htdocs/www/polluniverse.com/apache-ofbiz-17.12.03/framework/common/webcommon/error/Error.ftl 2024-04-28 22:12:47,909 |.0.0.1-8009-exec-492 |RequestHandler |E| Domain 50.21.190.236 not accepted to prevent host header injection 2024-04-28 22:12:47,909 |.0.0.1-8009-exec-492 |ControlServlet |E| Error in request handler: org.apache.ofbiz.webapp.control.RequestHandlerException: Domain 50.21.190.236 not accepted to prevent host header injection at org.apache.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:131) ~[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.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.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.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] 2024-04-28 22:12:47,972 |.0.0.1-8009-exec-492 |ControlServlet |E| An error occurred, going to the errorPage: file:/C:/Apache24/htdocs/www/polluniverse.com/apache-ofbiz-17.12.03/framework/common/webcommon/error/Error.ftl