c2c-oerpscenario team mailing list archive

[Cesitar Jones <682298@xxxxxxxxxxxxxxxxxx>]

Restart the server using the --update=all switch. See bug #682651.

-- 
[trunk] [3050] Crash on update modules on existing Database
https://bugs.launchpad.net/bugs/682298
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to the OpenERP Project Group.

Status in OpenObject Server: New

Bug description:
Hi,

when I try to update the modules List in an existing Database, where I already added some data i get the following error in the openerp-server.log:

ERROR:web-services:Uncaught exception
Traceback (most recent call last):
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/osv/osv.py", line 119, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/osv/osv.py", line 203, in execute
    res = pool.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/osv/osv.py", line 193, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/addons/base/module/wizard/base_module_update.py", line 42, in update_module
    update, add = module_obj.update_list(cr, uid,)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/addons/base/module/module.py", line 385, in update_list
    self.write(cr, uid, mod.id, updated_values)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/osv/orm.py", line 3564, in write
    self.pool.get(object)._store_set_values(cr, user, todo, fields, context)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/osv/orm.py", line 3856, in _store_set_values
    ','.join(upd0) + ' where id = %s', upd1)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/sql_db.py", line 76, in wrapper
    return f(self, *args, **kwargs)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/sql_db.py", line 129, in execute
    res = self._obj.execute(query, params)
InternalError: current transaction is aborted, commands ignored until end of transaction block

The postgres-main log shows a bit more:

2010-11-28 08:59:13 CET ERROR:  column ir_ui_menu.web_icon_data does not exist at character 8
2010-11-28 08:59:13 CET STATEMENT:  SELECT ir_ui_menu.web_icon_data,ir_ui_menu.name,ir_ui_menu.web_icon,ir_ui_menu.sequence,ir_ui_menu.web_icon_hover,ir_ui_menu.parent_id,ir_ui_menu.web_icon_hover_data,ir_ui_menu.icon,ir_ui_menu.id FROM "ir_ui_menu" WHERE ir_ui_menu.id IN (568) ORDER BY sequence,id
2010-11-28 08:59:13 CET ERROR:  current transaction is aborted, commands ignored until end of transaction block
2010-11-28 08:59:13 CET STATEMENT:  SELECT ir_act_report_xml.report_rml_content_data,ir_act_report_xml.auto,ir_act_report_xml.header,ir_act_report_xml.report_type,ir_act_report_xml.report_file,ir_act_report_xml.multi,ir_act_report_xml.report_xsl,ir_act_report_xml.name,ir_act_report_xml.report_rml,ir_act_report_xml.report_name,ir_act_report_xml.attachment,ir_act_report_xml.usage,ir_act_report_xml.model,ir_act_report_xml.report_sxw_content_data,ir_act_report_xml.type,ir_act_report_xml.report_xml,ir_act_report_xml.attachment_use,ir_act_report_xml.id FROM "ir_act_report_xml" WHERE ir_act_report_xml.id IN (842) ORDER BY id
2010-11-28 08:59:13 CET ERROR:  current transaction is aborted, commands ignored until end of transaction block
2010-11-28 08:59:13 CET STATEMENT:  update "ir_module_module" set "menus_by_module"=E'',"views_by_module"=E'Cancel Repair(form)
	Make Invoice(form)
	mrp.repair.form(form)
	mrp.repair.select(search)
	mrp.repair.tree(tree)',"reports_by_module"=E'' where id = 2

Is does not only relate to the mrp_repair module, e.g. when I remove the whole mrp_repair dir in the addons folder I get the following error:

2010-11-28 09:01:33 CET STATEMENT:  update "ir_module_module" set "menus_by_module"=E'',"views_by_module"=E'Account voucher unreconcile(form)
	account.statement.from.invoice.form(form)
	account.statement.from.invoice.lines.form(form)
	account.voucher.form(form)
	account.voucher.graph(graph)
	account.voucher.select(search)
	account.voucher.tree(tree)',"reports_by_module"=E'Voucher
	Voucher Print' where id = 7

It does work in new databases.

Any suggestions?

Python 2.6.5
PostgreSQL 8.4.5
Ubuntu Lucix Lynx