[
https://issues.apache.org/jira/browse/OFBIZ-10418?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jacques Le Roux updated OFBIZ-10418:
------------------------------------
Description:
This issue does not exist in R16, is reproductible locally and on demo in trunk
and R17. Here is the stack trace:
{code}
2018-05-27 09:28:51,708 |ajp-nio-8009-exec-4 |EntityListIterator
|W| Warning: auto-closed EntityListIterator because of exception:
java.sql.SQLTransactionRollbackException: A lock could not be obtained within
the time requested
2018-05-27 09:28:51,709 |ajp-nio-8009-exec-4 |EntityListIterator
|W| This EntityListIterator for Entity [ShoppingList] has already been closed,
not closing again.
2018-05-27 09:28:51,709 |ajp-nio-8009-exec-4 |GenericDelegator
|E| Failure in findByCondition operation for entity [ShoppingList]:
org.apache.ofbiz.entity.GenericEntityException: Error getting the next result
(A lock could not be obtained within the time requested). Rolling back
transaction.
org.apache.ofbiz.entity.GenericEntityException: Error getting the next result
(A lock could not be obtained within the time requested)
at
org.apache.ofbiz.entity.util.EntityListIterator.getCompleteList(EntityListIterator.java:429)
~[ofbiz.jar:?]
at
org.apache.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1581)
[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.entity.util.EntityQuery.queryOne(EntityQuery.java:423)
[ofbiz.jar:?]
at
org.apache.ofbiz.entity.finder.PrimaryKeyFinder.runFind(PrimaryKeyFinder.java:152)
[ofbiz.jar:?]
at
org.apache.ofbiz.entity.finder.PrimaryKeyFinder.runFind(PrimaryKeyFinder.java:87)
[ofbiz.jar:?]
at
org.apache.ofbiz.minilang.method.entityops.EntityOne.exec(EntityOne.java:58)
[ofbiz.jar:?]
at
org.apache.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:310)
[ofbiz.jar:?]
at org.apache.ofbiz.minilang.SimpleMethod.exec(SimpleMethod.java:457)
[ofbiz.jar:?]
at
org.apache.ofbiz.minilang.SimpleMethod.runSimpleMethod(SimpleMethod.java:274)
[ofbiz.jar:?]
at
org.apache.ofbiz.minilang.SimpleMethod.runSimpleService(SimpleMethod.java:293)
[ofbiz.jar:?]
at
org.apache.ofbiz.minilang.SimpleServiceEngine.serviceInvoker(SimpleServiceEngine.java:79)
[ofbiz.jar:?]
at
org.apache.ofbiz.minilang.SimpleServiceEngine.runSync(SimpleServiceEngine.java:48)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:400)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:228)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:103)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.ModelService.evalPermission(ModelService.java:1020)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.ServiceDispatcher.checkAuth(ServiceDispatcher.java:934)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:357)
[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.order.shoppinglist.ShoppingListEvents.addBulkFromCart(ShoppingListEvents.java:157)
[ofbiz.jar:?]
at
org.apache.ofbiz.order.shoppinglist.ShoppingListEvents.fillAutoSaveList(ShoppingListEvents.java:414)
[ofbiz.jar:?]
at
org.apache.ofbiz.order.shoppinglist.ShoppingListEvents.saveCartToAutoSaveList(ShoppingListEvents.java:432)
[ofbiz.jar:?]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[?:1.8.0_171]
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
~[?:1.8.0_171]
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[?:1.8.0_171]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_171]
at
org.apache.ofbiz.webapp.event.JavaEventHandler.invoke(JavaEventHandler.java:86)
[ofbiz.jar:?]
at
org.apache.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:730)
[ofbiz.jar:?]
at
org.apache.ofbiz.webapp.control.RequestHandler.runAfterLoginEvents(RequestHandler.java:1205)
[ofbiz.jar:?]
at
org.apache.ofbiz.webapp.control.LoginWorker.doMainLogin(LoginWorker.java:574)
[ofbiz.jar:?]
at
org.apache.ofbiz.webapp.control.LoginWorker.login(LoginWorker.java:521)
[ofbiz.jar:?]
at
org.apache.ofbiz.securityext.login.LoginEvents.storeLogin(LoginEvents.java:416)
[ofbiz.jar:?]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[?:1.8.0_171]
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
~[?:1.8.0_171]
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[?:1.8.0_171]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_171]
at
org.apache.ofbiz.webapp.event.JavaEventHandler.invoke(JavaEventHandler.java:86)
[ofbiz.jar:?]
at
org.apache.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:730)
[ofbiz.jar:?]
at
org.apache.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:454)
[ofbiz.jar:?]
at
org.apache.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:213)
[ofbiz.jar:?]
at
org.apache.ofbiz.product.category.SeoControlServlet.doGet(SeoControlServlet.java:89)
[ofbiz.jar:?]
at
org.apache.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:87)
[ofbiz.jar:?]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:706)
[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.7.jar:9.0.7]
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
[tomcat-catalina-9.0.7.jar:9.0.7]
at
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
[tomcat-embed-websocket-9.0.7.jar:9.0.7]
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
[tomcat-catalina-9.0.7.jar:9.0.7]
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
[tomcat-catalina-9.0.7.jar:9.0.7]
at
org.apache.ofbiz.product.category.SeoContextFilter.doFilter(SeoContextFilter.java:208)
[ofbiz.jar:?]
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
[tomcat-catalina-9.0.7.jar:9.0.7]
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
[tomcat-catalina-9.0.7.jar:9.0.7]
at
org.apache.ofbiz.product.category.SeoContentUrlFilter.doFilter(SeoContentUrlFilter.java:101)
[ofbiz.jar:?]
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
[tomcat-catalina-9.0.7.jar:9.0.7]
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
[tomcat-catalina-9.0.7.jar:9.0.7]
at
org.apache.ofbiz.product.category.CatalogUrlFilter.doFilter(CatalogUrlFilter.java:337)
[ofbiz.jar:?]
at
org.apache.ofbiz.product.category.CatalogUrlSeoFilter.doFilter(CatalogUrlSeoFilter.java:68)
[ofbiz.jar:?]
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
[tomcat-catalina-9.0.7.jar:9.0.7]
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
[tomcat-catalina-9.0.7.jar:9.0.7]
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.7.jar:9.0.7]
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
[tomcat-catalina-9.0.7.jar:9.0.7]
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
[tomcat-catalina-9.0.7.jar:9.0.7]
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
[tomcat-catalina-9.0.7.jar:9.0.7]
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494)
[tomcat-catalina-9.0.7.jar:9.0.7]
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
[tomcat-catalina-9.0.7.jar:9.0.7]
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
[tomcat-catalina-9.0.7.jar:9.0.7]
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
[tomcat-catalina-9.0.7.jar:9.0.7]
at
org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:651)
[tomcat-catalina-9.0.7.jar:9.0.7]
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
[tomcat-catalina-9.0.7.jar:9.0.7]
at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:394)
[tomcat-coyote-9.0.7.jar:9.0.7]
at
org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
[tomcat-coyote-9.0.7.jar:9.0.7]
at
org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:754)
[tomcat-coyote-9.0.7.jar:9.0.7]
at
org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1376)
[tomcat-coyote-9.0.7.jar:9.0.7]
at
org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
[tomcat-coyote-9.0.7.jar:9.0.7]
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
[?:1.8.0_171]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
[?:1.8.0_171]
at
org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
[tomcat-util-9.0.7.jar:9.0.7]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_171]
{code}
was:
This issue does not exist in R16, is reproductible locally and on demo. Here is
the stack trace:
{code}
2018-05-27 09:28:51,708 |ajp-nio-8009-exec-4 |EntityListIterator
|W| Warning: auto-closed EntityListIterator because of exception:
java.sql.SQLTransactionRollbackException: A lock could not be obtained within
the time requested
2018-05-27 09:28:51,709 |ajp-nio-8009-exec-4 |EntityListIterator
|W| This EntityListIterator for Entity [ShoppingList] has already been closed,
not closing again.
2018-05-27 09:28:51,709 |ajp-nio-8009-exec-4 |GenericDelegator
|E| Failure in findByCondition operation for entity [ShoppingList]:
org.apache.ofbiz.entity.GenericEntityException: Error getting the next result
(A lock could not be obtained within the time requested). Rolling back
transaction.
org.apache.ofbiz.entity.GenericEntityException: Error getting the next result
(A lock could not be obtained within the time requested)
at
org.apache.ofbiz.entity.util.EntityListIterator.getCompleteList(EntityListIterator.java:429)
~[ofbiz.jar:?]
at
org.apache.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1581)
[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.entity.util.EntityQuery.queryOne(EntityQuery.java:423)
[ofbiz.jar:?]
at
org.apache.ofbiz.entity.finder.PrimaryKeyFinder.runFind(PrimaryKeyFinder.java:152)
[ofbiz.jar:?]
at
org.apache.ofbiz.entity.finder.PrimaryKeyFinder.runFind(PrimaryKeyFinder.java:87)
[ofbiz.jar:?]
at
org.apache.ofbiz.minilang.method.entityops.EntityOne.exec(EntityOne.java:58)
[ofbiz.jar:?]
at
org.apache.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:310)
[ofbiz.jar:?]
at org.apache.ofbiz.minilang.SimpleMethod.exec(SimpleMethod.java:457)
[ofbiz.jar:?]
at
org.apache.ofbiz.minilang.SimpleMethod.runSimpleMethod(SimpleMethod.java:274)
[ofbiz.jar:?]
at
org.apache.ofbiz.minilang.SimpleMethod.runSimpleService(SimpleMethod.java:293)
[ofbiz.jar:?]
at
org.apache.ofbiz.minilang.SimpleServiceEngine.serviceInvoker(SimpleServiceEngine.java:79)
[ofbiz.jar:?]
at
org.apache.ofbiz.minilang.SimpleServiceEngine.runSync(SimpleServiceEngine.java:48)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:400)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:228)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:103)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.ModelService.evalPermission(ModelService.java:1020)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.ServiceDispatcher.checkAuth(ServiceDispatcher.java:934)
[ofbiz.jar:?]
at
org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:357)
[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.order.shoppinglist.ShoppingListEvents.addBulkFromCart(ShoppingListEvents.java:157)
[ofbiz.jar:?]
at
org.apache.ofbiz.order.shoppinglist.ShoppingListEvents.fillAutoSaveList(ShoppingListEvents.java:414)
[ofbiz.jar:?]
at
org.apache.ofbiz.order.shoppinglist.ShoppingListEvents.saveCartToAutoSaveList(ShoppingListEvents.java:432)
[ofbiz.jar:?]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[?:1.8.0_171]
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
~[?:1.8.0_171]
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[?:1.8.0_171]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_171]
at
org.apache.ofbiz.webapp.event.JavaEventHandler.invoke(JavaEventHandler.java:86)
[ofbiz.jar:?]
at
org.apache.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:730)
[ofbiz.jar:?]
at
org.apache.ofbiz.webapp.control.RequestHandler.runAfterLoginEvents(RequestHandler.java:1205)
[ofbiz.jar:?]
at
org.apache.ofbiz.webapp.control.LoginWorker.doMainLogin(LoginWorker.java:574)
[ofbiz.jar:?]
at
org.apache.ofbiz.webapp.control.LoginWorker.login(LoginWorker.java:521)
[ofbiz.jar:?]
at
org.apache.ofbiz.securityext.login.LoginEvents.storeLogin(LoginEvents.java:416)
[ofbiz.jar:?]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[?:1.8.0_171]
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
~[?:1.8.0_171]
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[?:1.8.0_171]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_171]
at
org.apache.ofbiz.webapp.event.JavaEventHandler.invoke(JavaEventHandler.java:86)
[ofbiz.jar:?]
at
org.apache.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:730)
[ofbiz.jar:?]
at
org.apache.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:454)
[ofbiz.jar:?]
at
org.apache.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:213)
[ofbiz.jar:?]
at
org.apache.ofbiz.product.category.SeoControlServlet.doGet(SeoControlServlet.java:89)
[ofbiz.jar:?]
at
org.apache.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:87)
[ofbiz.jar:?]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:706)
[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.7.jar:9.0.7]
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
[tomcat-catalina-9.0.7.jar:9.0.7]
at
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
[tomcat-embed-websocket-9.0.7.jar:9.0.7]
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
[tomcat-catalina-9.0.7.jar:9.0.7]
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
[tomcat-catalina-9.0.7.jar:9.0.7]
at
org.apache.ofbiz.product.category.SeoContextFilter.doFilter(SeoContextFilter.java:208)
[ofbiz.jar:?]
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
[tomcat-catalina-9.0.7.jar:9.0.7]
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
[tomcat-catalina-9.0.7.jar:9.0.7]
at
org.apache.ofbiz.product.category.SeoContentUrlFilter.doFilter(SeoContentUrlFilter.java:101)
[ofbiz.jar:?]
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
[tomcat-catalina-9.0.7.jar:9.0.7]
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
[tomcat-catalina-9.0.7.jar:9.0.7]
at
org.apache.ofbiz.product.category.CatalogUrlFilter.doFilter(CatalogUrlFilter.java:337)
[ofbiz.jar:?]
at
org.apache.ofbiz.product.category.CatalogUrlSeoFilter.doFilter(CatalogUrlSeoFilter.java:68)
[ofbiz.jar:?]
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
[tomcat-catalina-9.0.7.jar:9.0.7]
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
[tomcat-catalina-9.0.7.jar:9.0.7]
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.7.jar:9.0.7]
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
[tomcat-catalina-9.0.7.jar:9.0.7]
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
[tomcat-catalina-9.0.7.jar:9.0.7]
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
[tomcat-catalina-9.0.7.jar:9.0.7]
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494)
[tomcat-catalina-9.0.7.jar:9.0.7]
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
[tomcat-catalina-9.0.7.jar:9.0.7]
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
[tomcat-catalina-9.0.7.jar:9.0.7]
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
[tomcat-catalina-9.0.7.jar:9.0.7]
at
org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:651)
[tomcat-catalina-9.0.7.jar:9.0.7]
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
[tomcat-catalina-9.0.7.jar:9.0.7]
at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:394)
[tomcat-coyote-9.0.7.jar:9.0.7]
at
org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
[tomcat-coyote-9.0.7.jar:9.0.7]
at
org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:754)
[tomcat-coyote-9.0.7.jar:9.0.7]
at
org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1376)
[tomcat-coyote-9.0.7.jar:9.0.7]
at
org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
[tomcat-coyote-9.0.7.jar:9.0.7]
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
[?:1.8.0_171]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
[?:1.8.0_171]
at
org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
[tomcat-util-9.0.7.jar:9.0.7]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_171]
{code}
> createShoppingListItem service fails
> ------------------------------------
>
> Key: OFBIZ-10418
> URL: https://issues.apache.org/jira/browse/OFBIZ-10418
> Project: OFBiz
> Issue Type: Bug
> Components: ecommerce
> Affects Versions: Trunk
> Reporter: Jacques Le Roux
> Priority: Minor
>
> This issue does not exist in R16, is reproductible locally and on demo in
> trunk and R17. Here is the stack trace:
> {code}
> 2018-05-27 09:28:51,708 |ajp-nio-8009-exec-4 |EntityListIterator
> |W| Warning: auto-closed EntityListIterator because of exception:
> java.sql.SQLTransactionRollbackException: A lock could not be obtained within
> the time requested
> 2018-05-27 09:28:51,709 |ajp-nio-8009-exec-4 |EntityListIterator
> |W| This EntityListIterator for Entity [ShoppingList] has already been
> closed, not closing again.
> 2018-05-27 09:28:51,709 |ajp-nio-8009-exec-4 |GenericDelegator
> |E| Failure in findByCondition operation for entity [ShoppingList]:
> org.apache.ofbiz.entity.GenericEntityException: Error getting the next result
> (A lock could not be obtained within the time requested). Rolling back
> transaction.
> org.apache.ofbiz.entity.GenericEntityException: Error getting the next result
> (A lock could not be obtained within the time requested)
> at
> org.apache.ofbiz.entity.util.EntityListIterator.getCompleteList(EntityListIterator.java:429)
> ~[ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1581)
> [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.entity.util.EntityQuery.queryOne(EntityQuery.java:423)
> [ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.finder.PrimaryKeyFinder.runFind(PrimaryKeyFinder.java:152)
> [ofbiz.jar:?]
> at
> org.apache.ofbiz.entity.finder.PrimaryKeyFinder.runFind(PrimaryKeyFinder.java:87)
> [ofbiz.jar:?]
> at
> org.apache.ofbiz.minilang.method.entityops.EntityOne.exec(EntityOne.java:58)
> [ofbiz.jar:?]
> at
> org.apache.ofbiz.minilang.SimpleMethod.runSubOps(SimpleMethod.java:310)
> [ofbiz.jar:?]
> at org.apache.ofbiz.minilang.SimpleMethod.exec(SimpleMethod.java:457)
> [ofbiz.jar:?]
> at
> org.apache.ofbiz.minilang.SimpleMethod.runSimpleMethod(SimpleMethod.java:274)
> [ofbiz.jar:?]
> at
> org.apache.ofbiz.minilang.SimpleMethod.runSimpleService(SimpleMethod.java:293)
> [ofbiz.jar:?]
> at
> org.apache.ofbiz.minilang.SimpleServiceEngine.serviceInvoker(SimpleServiceEngine.java:79)
> [ofbiz.jar:?]
> at
> org.apache.ofbiz.minilang.SimpleServiceEngine.runSync(SimpleServiceEngine.java:48)
> [ofbiz.jar:?]
> at
> org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:400)
> [ofbiz.jar:?]
> at
> org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:228)
> [ofbiz.jar:?]
> at
> org.apache.ofbiz.service.GenericDispatcherFactory$GenericDispatcher.runSync(GenericDispatcherFactory.java:103)
> [ofbiz.jar:?]
> at
> org.apache.ofbiz.service.ModelService.evalPermission(ModelService.java:1020)
> [ofbiz.jar:?]
> at
> org.apache.ofbiz.service.ServiceDispatcher.checkAuth(ServiceDispatcher.java:934)
> [ofbiz.jar:?]
> at
> org.apache.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:357)
> [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.order.shoppinglist.ShoppingListEvents.addBulkFromCart(ShoppingListEvents.java:157)
> [ofbiz.jar:?]
> at
> org.apache.ofbiz.order.shoppinglist.ShoppingListEvents.fillAutoSaveList(ShoppingListEvents.java:414)
> [ofbiz.jar:?]
> at
> org.apache.ofbiz.order.shoppinglist.ShoppingListEvents.saveCartToAutoSaveList(ShoppingListEvents.java:432)
> [ofbiz.jar:?]
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> ~[?:1.8.0_171]
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> ~[?:1.8.0_171]
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> ~[?:1.8.0_171]
> at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_171]
> at
> org.apache.ofbiz.webapp.event.JavaEventHandler.invoke(JavaEventHandler.java:86)
> [ofbiz.jar:?]
> at
> org.apache.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:730)
> [ofbiz.jar:?]
> at
> org.apache.ofbiz.webapp.control.RequestHandler.runAfterLoginEvents(RequestHandler.java:1205)
> [ofbiz.jar:?]
> at
> org.apache.ofbiz.webapp.control.LoginWorker.doMainLogin(LoginWorker.java:574)
> [ofbiz.jar:?]
> at
> org.apache.ofbiz.webapp.control.LoginWorker.login(LoginWorker.java:521)
> [ofbiz.jar:?]
> at
> org.apache.ofbiz.securityext.login.LoginEvents.storeLogin(LoginEvents.java:416)
> [ofbiz.jar:?]
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> ~[?:1.8.0_171]
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> ~[?:1.8.0_171]
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> ~[?:1.8.0_171]
> at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_171]
> at
> org.apache.ofbiz.webapp.event.JavaEventHandler.invoke(JavaEventHandler.java:86)
> [ofbiz.jar:?]
> at
> org.apache.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:730)
> [ofbiz.jar:?]
> at
> org.apache.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:454)
> [ofbiz.jar:?]
> at
> org.apache.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:213)
> [ofbiz.jar:?]
> at
> org.apache.ofbiz.product.category.SeoControlServlet.doGet(SeoControlServlet.java:89)
> [ofbiz.jar:?]
> at
> org.apache.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:87)
> [ofbiz.jar:?]
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:706)
> [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.7.jar:9.0.7]
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
> [tomcat-catalina-9.0.7.jar:9.0.7]
> at
> org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
> [tomcat-embed-websocket-9.0.7.jar:9.0.7]
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
> [tomcat-catalina-9.0.7.jar:9.0.7]
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
> [tomcat-catalina-9.0.7.jar:9.0.7]
> at
> org.apache.ofbiz.product.category.SeoContextFilter.doFilter(SeoContextFilter.java:208)
> [ofbiz.jar:?]
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
> [tomcat-catalina-9.0.7.jar:9.0.7]
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
> [tomcat-catalina-9.0.7.jar:9.0.7]
> at
> org.apache.ofbiz.product.category.SeoContentUrlFilter.doFilter(SeoContentUrlFilter.java:101)
> [ofbiz.jar:?]
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
> [tomcat-catalina-9.0.7.jar:9.0.7]
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
> [tomcat-catalina-9.0.7.jar:9.0.7]
> at
> org.apache.ofbiz.product.category.CatalogUrlFilter.doFilter(CatalogUrlFilter.java:337)
> [ofbiz.jar:?]
> at
> org.apache.ofbiz.product.category.CatalogUrlSeoFilter.doFilter(CatalogUrlSeoFilter.java:68)
> [ofbiz.jar:?]
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
> [tomcat-catalina-9.0.7.jar:9.0.7]
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
> [tomcat-catalina-9.0.7.jar:9.0.7]
> 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.7.jar:9.0.7]
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
> [tomcat-catalina-9.0.7.jar:9.0.7]
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
> [tomcat-catalina-9.0.7.jar:9.0.7]
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
> [tomcat-catalina-9.0.7.jar:9.0.7]
> at
> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494)
> [tomcat-catalina-9.0.7.jar:9.0.7]
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
> [tomcat-catalina-9.0.7.jar:9.0.7]
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
> [tomcat-catalina-9.0.7.jar:9.0.7]
> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
> [tomcat-catalina-9.0.7.jar:9.0.7]
> at
> org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:651)
> [tomcat-catalina-9.0.7.jar:9.0.7]
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
> [tomcat-catalina-9.0.7.jar:9.0.7]
> at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:394)
> [tomcat-coyote-9.0.7.jar:9.0.7]
> at
> org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
> [tomcat-coyote-9.0.7.jar:9.0.7]
> at
> org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:754)
> [tomcat-coyote-9.0.7.jar:9.0.7]
> at
> org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1376)
> [tomcat-coyote-9.0.7.jar:9.0.7]
> at
> org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
> [tomcat-coyote-9.0.7.jar:9.0.7]
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
> [?:1.8.0_171]
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
> [?:1.8.0_171]
> at
> org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
> [tomcat-util-9.0.7.jar:9.0.7]
> at java.lang.Thread.run(Thread.java:748) [?:1.8.0_171]
> {code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
