Possible bug, Postgres 9.1 max_pred

[Kyle Waid]

I am testing OpenERP 6.1 with postgresql 9.1 all current sources

With postgresql 9.1 they introduce something new, max_pred_locks_per_transaction When trying to import products (500 only) I get an out of shared memory ever time. I tried increasing the limit to 128 from only 10 and I still got the error. I read in the documentation here,

http://www.postgresql.org/docs/9.1/static/runtime-config-locks.html

that this has to do with prepared transactions, Which makes me wonder, is it fully committing when a product record is created. Im having trouble understanding the error,

For your reference

Traceback (most recent call last):
  File "/usr/local/openerp/6.1/openerp-server/openerp/sql_db.py", line 214, in execute
    res = self._obj.execute(query, params)
OperationalError: out of shared memory
HINT: You might need to increase max_pred_locks_per_transaction.

[2012-01-23 03:46:05,462][?] ERROR:web-services:Uncaught exception
Traceback (most recent call last):
  File "/usr/local/openerp/6.1/openerp-server/openerp/osv/osv.py", line 120, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/usr/local/openerp/6.1/openerp-server/openerp/osv/osv.py", line 175, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/usr/local/openerp/6.1/openerp-server/openerp/osv/osv.py", line 163, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/usr/local/openerp/6.1/addons/magentoerpconnect/magerp_core.py", line 247, in sync_products
    res = self._sync_product_storeview(import_cr, uid, referential.id, attr_conn, ext_product_id, storeview, context=ctx)
  File "/usr/local/openerp/6.1/addons/magentoerpconnect/magerp_core.py", line 201, in _sync_product_storeview
    return self.pool.get('product.product').ext_import(cr, uid, [product_info], referential_id, defaults=defaults , context=ctx)
  File "/usr/local/openerp/6.1/addons/base_external_referentials/external_osv.py", line 366, in ext_import
    vals = self.oevals_from_extdata(cr, uid, external_referential_id, each_row, for_key_field, mapping_lines, defaults, context)
  File "/usr/local/openerp/6.1/addons/base_external_referentials/external_osv.py", line 258, in oevals_from_extdata
    raise MappingError(e, each_mapping_line['external_field'], self._name)
MappingError: u'the mapping line : categories for the object product.product have an error : out of shared memory\nHINT: You might need to increase max_pred_locks_per_transaction.\n'

[Alexandre Fayolle - camptocamp (alexandre-fayolle-c2c)]

which branch are you using?

are you still seeing this issue?

[Christophe CHAUVET (christophe-chauvet)]

Hi

I have the same problem with import_data() ORM function, when trying to import 1500 BOM

for each bom created, i commit the result.

I think the problem is not in this connector.

Regards,