Comment 2 for bug 770243

Revision history for this message
SnippetBucket.com (tta-openerp) wrote :

Hello Everyone,

Go through https://bugs.launchpad.net/openobject-addons/+bug/507389
Solution was implemented as http://bazaar.launchpad.net/~openerp/openobject-addons/6.0/revision/3164.54.66.

As a part of investigation, note the following things:

1. User might need to increase max_locks_per_transaction. (From config of postgres)
2. User might need to increase SHMMAX memory as well (http://www.postgresql.org/docs/8.4/static/kernel-resources.html#SYSVIPC)
3. Should not the Savepoint be written before the loop starts? (Instead of having it for each location)
4. I am not completely sure, but will it have a trouble when more than one users access the same function with large no. of locations?

Thanks.