You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@ofbiz.apache.org by "Jacques Le Roux (JIRA)" <ji...@apache.org> on 2018/06/11 12:28:00 UTC

[jira] [Commented] (OFBIZ-10418) createShoppingListItem service fails

    [ https://issues.apache.org/jira/browse/OFBIZ-10418?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16507962#comment-16507962 ] 

Jacques Le Roux commented on OFBIZ-10418:
-----------------------------------------

This is not blocking but it makes checking out very long because you have to wait for the time out to occur and it takes 1 minute.

> 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. 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)