← Back to team overview

openerp-india team mailing list archive

[Bug 770243] Re: Creating 4000+ locations slow down the mrp module installations and confirming sale order.

 

Attached the patch Olivier Dony (OpenERP) (odo-openerp) patch for
version lp:openobject-addons/6.1 on revision 6793

** Patch added: "product_reserve.patch"
   https://bugs.launchpad.net/openobject-addons/+bug/770243/+attachment/3140968/+files/product_reserve.patch

-- 
You received this bug notification because you are a member of OpenERP
Indian Team, which is subscribed to OpenERP Addons.
https://bugs.launchpad.net/bugs/770243

Title:
  Creating 4000+ locations slow down the mrp module installations and
  confirming sale order.

Status in OpenERP Addons (modules):
  Fix Released

Bug description:
  Hi,
  We imported 4197 locations in openerp. After that installation of mrp modules taking hours and conforming one sale order taking more than one minute. The system is slowing down on the function _product_reserve which is in "bin/addons/stock/stock.py" in class stock_location line 362.

  Sometimes it is throwing the following error
  OperationalError: out of shared memory
  HINT: You might need to increase max_locks_per_transaction.

  The server we are using 6.0.2 stable.
  The locations we used to import is attached with this bug report.

  Please improve the performance of _product_reserve function so that it
  will not hang when the number of locations are in thousands range.

  Thank you.

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-addons/+bug/770243/+subscriptions