Possible bug, Postgres 9.1 max_pred

Bug #920305 reported by Kyle Waid
10
This bug affects 2 people
Affects Status Importance Assigned to Milestone
Magento OpenERP Connector
Incomplete
Undecided
Unassigned

Bug Description

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'

Revision history for this message
Alexandre Fayolle - camptocamp (alexandre-fayolle-c2c) wrote :

which branch are you using?

are you still seeing this issue?

Changed in magentoerpconnect:
status: New → Incomplete
Revision history for this message
Christophe CHAUVET (christophe-chauvet) wrote :

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,

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.