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?
Hello Everyone,
Go through https:/ /bugs.launchpad .net/openobject -addons/ +bug/507389 bazaar. launchpad. net/~openerp/ openobject- addons/ 6.0/revision/ 3164.54. 66.
Solution was implemented as http://
As a part of investigation, note the following things:
1. User might need to increase max_locks_ per_transaction . (From config of postgres) www.postgresql. org/docs/ 8.4/static/ kernel- resources. html#SYSVIPC)
2. User might need to increase SHMMAX memory as well (http://
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.