← Back to team overview

openerp-india team mailing list archive

[Bug 1104982] Re: Wizard multi charts accounts bug

 

2013-01-30 01:54:45,140 2645 ERROR seodb openerp.addons.base.ir.ir_cron: Unexpected exception while processing cron job {'function': u'power_on', 'create_uid': 1, 'args': u'()', 'create_date': '2013-01-28 21:54:33.045812', 'name': u'AutoVacuum osv_memory objects', 'interval_type': u'minutes', 'numbercall': -1, 'write_uid': 1, 'priority': 5, 'model': u'osv_memory.autovacuum', 'doall': False, 'write_date': '2013-01-28 21:54:33.045812', 'active': True, 'user_id': 1, 'interval_number': 30, 'nextcall': '2013-01-30 01:54:38', 'id': 1}
Traceback (most recent call last):
  File "/opt/openerp/server/openerp/addons/base/ir/ir_cron.py", line 221, in _acquire_job
    registry[cls._name]._process_job(job_cr, job, lock_cr)
  File "/opt/openerp/server/openerp/addons/base/ir/ir_cron.py", line 165, in _process_job
    (nextcall.strftime(DEFAULT_SERVER_DATETIME_FORMAT), numbercall, job['id']))
  File "/opt/openerp/server/openerp/sql_db.py", line 162, in wrapper
    return f(self, *args, **kwargs)
  File "/opt/openerp/server/openerp/sql_db.py", line 227, in execute
    res = self._obj.execute(query, params)
TransactionRollbackError: no se pudo serializar el acceso debido a dependencias read/write entre transacciones
DETALLE:  Reason code: Canceled on identification as a pivot, during write.
SUGERENCIA:  La transacción podría tener éxito si es reintentada.

2013-01-30 01:54:48,407 2645 ERROR seodb openerp.sql_db: bad query: delete from wizard_multi_charts_accounts where id IN (1)
Traceback (most recent call last):
  File "/opt/openerp/server/openerp/sql_db.py", line 227, in execute
    res = self._obj.execute(query, params)
IntegrityError: el valor null para la columna «bank_account_id» viola la restricción not null
CONTEXTO:  sentencia SQL: «UPDATE ONLY "public"."account_bank_accounts_wizard" SET "bank_account_id" = NULL WHERE $1 OPERATOR(pg_catalog.=) "bank_account_id"»

Traceback (most recent call last):
  File "/usr/lib/python2.6/logging/__init__.py", line 768, in emit
    msg = self.format(record)
  File "/usr/lib/python2.6/logging/__init__.py", line 648, in format
    return fmt.format(record)
  File "/opt/openerp/server/openerp/netsvc.py", line 151, in format
    return DBFormatter.format(self, record)
  File "/opt/openerp/server/openerp/netsvc.py", line 145, in format
    return logging.Formatter.format(self, record)
  File "/usr/lib/python2.6/logging/__init__.py", line 448, in format
    s = s + record.exc_text
UnicodeDecodeError: 'ascii' codec can't decode byte

-- 
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/1104982

Title:
  Wizard multi charts accounts bug

Status in OpenERP Addons (modules):
  Incomplete

Bug description:
  Os: Ubuntu 12.04 LTS
  Branch: 7.0 (openobject-addons/7.0 + server & web)
  Server revno: 4840
  Web revno: 3719
  Addons revno: 8609

  Stack trace:

  2013-01-25 11:18:55,670 3926 ERROR Aluart openerp.sql_db: bad query: delete from wizard_multi_charts_accounts where id IN (1)
  Traceback (most recent call last):
    File "/opt/openerp/7.0/server/openerp/sql_db.py", line 227, in execute
      res = self._obj.execute(query, params)
  IntegrityError: null value in column "bank_account_id" violates not-null constraint
  CONTEXT:  SQL statement "UPDATE ONLY "public"."account_bank_accounts_wizard" SET "bank_account_id" = NULL WHERE $1 OPERATOR(pg_catalog.=) "bank_account_id""

  2013-01-25 11:18:55,670 3926 ERROR Aluart openerp.addons.base.ir.ir_cron: Call of self.pool.get('osv_memory.autovacuum').power_on(cr, uid, *()) failed in Job 1
  Traceback (most recent call last):
    File "/opt/openerp/7.0/server/openerp/addons/base/ir/ir_cron.py", line 132, in _callback
      method(cr, uid, *args)
    File "/opt/openerp/7.0/server/openerp/addons/base/ir/osv_memory_autovacuum.py", line 31, in power_on
      model._transient_vacuum(cr, uid, force=True)
    File "/opt/openerp/7.0/server/openerp/osv/orm.py", line 5191, in _transient_vacuum
      self._transient_clean_rows_older_than(cr, self._transient_max_hours * 60 * 60)
    File "/opt/openerp/7.0/server/openerp/osv/orm.py", line 5155, in _transient_clean_rows_older_than
      self.unlink(cr, SUPERUSER_ID, ids)
    File "/opt/openerp/7.0/server/openerp/osv/orm.py", line 3976, in unlink
      'where id IN %s', (sub_ids,))
    File "/opt/openerp/7.0/server/openerp/sql_db.py", line 162, in wrapper
      return f(self, *args, **kwargs)
    File "/opt/openerp/7.0/server/openerp/sql_db.py", line 227, in execute
      res = self._obj.execute(query, params)
  IntegrityError: null value in column "bank_account_id" violates not-null constraint
  CONTEXT:  SQL statement "UPDATE ONLY "public"."account_bank_accounts_wizard" SET "bank_account_id" = NULL WHERE $1 OPERATOR(pg_catalog.=) "bank_account_id""

  Stepts to reproduce bug:

  1. Create new database
  2. Edit company info, set Name,Image,Country to Switzerland, Mobile, Phone, Contact
  3. Install MRP

  The wizard skips the accounting package step where you select General
  COA or a country-specific one and it goes traight to accounting
  options

  4. Chose save Plan Comptabile STERCHI

  After a short while the cron tries to run and that shows up...

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


References