OFBiz › OFBiz - Dev

[jira] Created: (OFBIZ-718) creating a link between a product and a category withthe service addProductToCategory causes a deadlock

_‹ Previous Topic Next Topic _›

Classic

List

Threaded

3 messages Options

Nicolas Malin (Jira)

[jira] Created: (OFBIZ-718) creating a link between a product and a category withthe service addProductToCategory causes a deadlock

creating a link between a product and a category withthe service addProductToCategory causes a deadlock
-------------------------------------------------------------------------------------------------------

Key: OFBIZ-718
URL: https://issues.apache.org/jira/browse/OFBIZ-718
Project: OFBiz (The Open for Business Project)
Issue Type: Bug
Components: product
Affects Versions: SVN trunk
Environment: local using derby database
Reporter: Hans Bakker
Assigned To: Al Byers

Hi Al, i have the problem below. I saw inthe log you are working on this?
It is caused in the checkCategoryRelatedPermissionService
in CategoryServices.xml at line 631/632

can you have a look?

the log:

Service [addProductToCategory] threw an unexpected exception/error
Exception: org.ofbiz.service.ServiceAuthException
Message: Error running the simple-method: Error in simple-method operation [<iterate list-name="productCategoryIdList" entry-name="productCategoryId"/>]: java.lang.RuntimeException: Error in simple-method operation [<entity-and/>]: java.lang.IllegalArgumentException: Error getting list from EntityListIterator: org.ofbiz.entity.GenericEntityException: Error getting the next result (A lock could not be obtained within the time requested)<br/>null
---- stack trace ---------------------------------------------------------------
org.ofbiz.service.ServiceAuthException: Error running the simple-method: Error in simple-method operation [<iterate list-name="productCategoryIdList" entry-name="productCategoryId"/>]: java.lang.RuntimeException: Error in simple-method operation [<entity-and/>]: java.lang.IllegalArgumentException: Error getting list from EntityListIterator: org.ofbiz.entity.GenericEntityException: Error getting the next result (A lock could not be obtained within the time requested)<br/>null
org.ofbiz.service.ServiceDispatcher.checkAuth(ServiceDispatcher.java:774)
org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:307)
org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:211)
org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:113)
org.ofbiz.local.convertxls.loadFiles(convertxls.java:211)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:324)
org.ofbiz.webapp.event.JavaEventHandler.invoke(JavaEventHandler.java:88)
org.ofbiz.webapp.event.JavaEventHandler.invoke(JavaEventHandler.java:74)
org.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:409)
org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:240)

caused in program convertXls java code starting from line 200:
Debug.logInfo("=== connection productId: " + productId + " to category: " + rowCategory, module);
results = dispatcher.runSync("addProductToCategory", UtilMisc.toMap(
"userLogin",userLogin,
"productId", productId,
"productCategoryId", rowCategory));

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Nicolas Malin (Jira)

[jira] Commented: (OFBIZ-718) creating a link between a product and a category withthe service addProductToCategory causes a deadlock

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

Jacopo Cappellato commented on OFBIZ-718:
-----------------------------------------

Is it possible that this issue has been recently fixed?

> creating a link between a product and a category withthe service addProductToCategory causes a deadlock
> -------------------------------------------------------------------------------------------------------
>
> Key: OFBIZ-718
> URL: https://issues.apache.org/jira/browse/OFBIZ-718
> Project: OFBiz (The Open for Business Project)
> Issue Type: Bug
> Components: product
> Affects Versions: SVN trunk
> Environment: local using derby database
> Reporter: Hans Bakker
> Assigned To: Al Byers
>
> Hi Al, i have the problem below. I saw inthe log you are working on this?
> It is caused in the checkCategoryRelatedPermissionService
> in CategoryServices.xml at line 631/632
> can you have a look?
> the log:
> Service [addProductToCategory] threw an unexpected exception/error
> Exception: org.ofbiz.service.ServiceAuthException
> Message: Error running the simple-method: Error in simple-method operation [<iterate list-name="productCategoryIdList" entry-name="productCategoryId"/>]: java.lang.RuntimeException: Error in simple-method operation [<entity-and/>]: java.lang.IllegalArgumentException: Error getting list from EntityListIterator: org.ofbiz.entity.GenericEntityException: Error getting the next result (A lock could not be obtained within the time requested)<br/>null
> ---- stack trace ---------------------------------------------------------------
> org.ofbiz.service.ServiceAuthException: Error running the simple-method: Error in simple-method operation [<iterate list-name="productCategoryIdList" entry-name="productCategoryId"/>]: java.lang.RuntimeException: Error in simple-method operation [<entity-and/>]: java.lang.IllegalArgumentException: Error getting list from EntityListIterator: org.ofbiz.entity.GenericEntityException: Error getting the next result (A lock could not be obtained within the time requested)<br/>null
> org.ofbiz.service.ServiceDispatcher.checkAuth(ServiceDispatcher.java:774)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:307)
> org.ofbiz.service.ServiceDispatcher.runSync(ServiceDispatcher.java:211)
> org.ofbiz.service.GenericDispatcher.runSync(GenericDispatcher.java:113)
> org.ofbiz.local.convertxls.loadFiles(convertxls.java:211)
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> java.lang.reflect.Method.invoke(Method.java:324)
> org.ofbiz.webapp.event.JavaEventHandler.invoke(JavaEventHandler.java:88)
> org.ofbiz.webapp.event.JavaEventHandler.invoke(JavaEventHandler.java:74)
> org.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:409)
> org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:240)
> caused in program convertXls java code starting from line 200:
> Debug.logInfo("=== connection productId: " + productId + " to category: " + rowCategory, module);
> results = dispatcher.runSync("addProductToCategory", UtilMisc.toMap(
> "userLogin",userLogin,
> "productId", productId,
> "productCategoryId", rowCategory));

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Nicolas Malin (Jira)

[jira] Closed: (OFBIZ-718) creating a link between a product and a category withthe service addProductToCategory causes a deadlock

In reply to this post by Nicolas Malin (Jira)

[ https://issues.apache.org/jira/browse/OFBIZ-718?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Hans Bakker closed OFBIZ-718.
-----------------------------

Resolution: Cannot Reproduce

in the mean time seems to be resolved

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.