This question has been flagged
2 Replies
4266 Views

Does anyone know how to fix this problem?



2015-03-24 15:07:03,517 2225 ERROR BDBC openerp.sql_db: bad query: UPDATE "ir_ui_menu" SET "write_uid"=1,"write_date"=(now() at time zone 'UTC') WHERE id IN (62)

Traceback (most recent call last):

File "/opt/odoo/odoo-server/openerp/sql_db.py", line 234, in execute

res = self._obj.execute(query, params)

TransactionRollbackError: could not serialize access due to concurrent update

2015-03-24 15:07:03,518 2225 CRITICAL BDBC openerp.service.server: Failed to initialize database `BDBC`.

Traceback (most recent call last):

File "/opt/odoo/odoo-server/openerp/service/server.py", line 915, in preload_registries

registry = RegistryManager.new(dbname, update_module=update_module)

File "/opt/odoo/odoo-server/openerp/modules/registry.py", line 384, in new

openerp.modules.load_modules(registry._db, force_demo, status, update_module)

File "/opt/odoo/odoo-server/openerp/modules/loading.py", line 351, in load_modules

force, status, report, loaded_modules, update_module)

File "/opt/odoo/odoo-server/openerp/modules/loading.py", line 255, in load_marked_modules

loaded, processed = load_module_graph(cr, graph, progressdict, report=report, skip_modules=loaded_modules, perform_checks=perform_checks)

File "/opt/odoo/odoo-server/openerp/modules/loading.py", line 176, in load_module_graph

_load_data(cr, module_name, idref, mode, kind='data')

File "/opt/odoo/odoo-server/openerp/modules/loading.py", line 118, in _load_data

tools.convert_file(cr, module_name, filename, idref, mode, noupdate, kind, report)

File "/opt/odoo/odoo-server/openerp/tools/convert.py", line 901, in convert_file

convert_xml_import(cr, module, fp, idref, mode, noupdate, report)

File "/opt/odoo/odoo-server/openerp/tools/convert.py", line 987, in convert_xml_import

obj.parse(doc.getroot(), mode=mode)

File "/opt/odoo/odoo-server/openerp/tools/convert.py", line 853, in parse

self._tags[rec.tag](self.cr, rec, n, mode=mode)

File "/opt/odoo/odoo-server/openerp/tools/convert.py", line 763, in _tag_record

id = self.pool['ir.model.data']._update(cr, self.uid, rec_model, self.module, res, rec_id or False, not self.isnoupdate(data_node), noupdate=self.isnoupdate(data_node), mode=self.mode, context=rec_context )

File "/opt/odoo/odoo-server/openerp/api.py", line 241, in wrapper

return old_api(self, *args, **kwargs)

File "/opt/odoo/odoo-server/openerp/addons/base/ir/ir_model.py", line 1046, in _update

model_obj.write(cr, uid, [res_id], values, context=context)

File "/opt/odoo/odoo-server/openerp/api.py", line 241, in wrapper

return old_api(self, *args, **kwargs)

File "/opt/odoo/odoo-server/openerp/addons/base/ir/ir_ui_menu.py", line 169, in write

return super(ir_ui_menu, self).write(cr, uid, ids, values, context=context)

File "/opt/odoo/odoo-server/openerp/api.py", line 241, in wrapper

return old_api(self, *args, **kwargs)

File "/opt/odoo/odoo-server/openerp/api.py", line 363, in old_api

result = method(recs, *args, **kwargs)

File "/opt/odoo/odoo-server/openerp/models.py", line 3756, in write

self._write(old_vals)

File "/opt/odoo/odoo-server/openerp/api.py", line 239, in wrapper

return new_api(self, *args, **kwargs)

File "/opt/odoo/odoo-server/openerp/api.py", line 546, in new_api

result = method(self._model, cr, uid, self.ids, *args, **kwargs)

File "/opt/odoo/odoo-server/openerp/models.py", line 3867, in _write

cr.execute(query, params + (sub_ids,))

File "/opt/odoo/odoo-server/openerp/sql_db.py", line 158, in wrapper

return f(self, *args, **kwargs)

File "/opt/odoo/odoo-server/openerp/sql_db.py", line 234, in execute

res = self._obj.execute(query, params)

ParseError: "could not serialize access due to concurrent update

" while parsing /opt/odoo/odoo-server/addons/base_setup/base_setup_views.xml:6, near

<record id="base.menu_res_company_global" model="ir.ui.menu">

<field name="groups_id" eval="[(3, ref('base.group_no_one'))]"/>

</record>

^C2015-03-24 15:07:35,814 2225 INFO BDBC openerp.service.server: Initiating shutdown

2015-03-24 15:07:35,814 2225 INFO BDBC openerp.service.server: Hit CTRL-C again or send a second signal to force the shutdown.

Avatar
Discard
Author Best Answer

Only running one instances of Odoo


When I try running update again I receive this error....

2015-03-24 15:16:10,995 2724 CRITICAL BDBC openerp.service.server: Failed to initialize database `BDBC`.

Traceback (most recent call last):

File "/opt/odoo/odoo-server/openerp/service/server.py", line 915, in preload_registries

registry = RegistryManager.new(dbname, update_module=update_module)

File "/opt/odoo/odoo-server/openerp/modules/registry.py", line 384, in new

openerp.modules.load_modules(registry._db, force_demo, status, update_module)

File "/opt/odoo/odoo-server/openerp/modules/loading.py", line 351, in load_modules

force, status, report, loaded_modules, update_module)

File "/opt/odoo/odoo-server/openerp/modules/loading.py", line 255, in load_marked_modules

loaded, processed = load_module_graph(cr, graph, progressdict, report=report, skip_modules=loaded_modules, perform_checks=perform_checks)

File "/opt/odoo/odoo-server/openerp/modules/loading.py", line 176, in load_module_graph

_load_data(cr, module_name, idref, mode, kind='data')

File "/opt/odoo/odoo-server/openerp/modules/loading.py", line 118, in _load_data

tools.convert_file(cr, module_name, filename, idref, mode, noupdate, kind, report)

File "/opt/odoo/odoo-server/openerp/tools/convert.py", line 901, in convert_file

convert_xml_import(cr, module, fp, idref, mode, noupdate, report)

File "/opt/odoo/odoo-server/openerp/tools/convert.py", line 974, in convert_xml_import

doc = etree.parse(xmlfile)

File "lxml.etree.pyx", line 3239, in lxml.etree.parse (src/lxml/lxml.etree.c:70141)

File "parser.pxi", line 1770, in lxml.etree._parseDocument (src/lxml/lxml.etree.c:102443)

File "parser.pxi", line 1790, in lxml.etree._parseFilelikeDocument (src/lxml/lxml.etree.c:102702)

File "parser.pxi", line 1685, in lxml.etree._parseDocFromFilelike (src/lxml/lxml.etree.c:101628)

File "parser.pxi", line 1134, in lxml.etree._BaseParser._parseDocFromFilelike (src/lxml/lxml.etree.c:97255)

File "parser.pxi", line 582, in lxml.etree._ParserContext._handleParseResultDoc (src/lxml/lxml.etree.c:91461)

File "parser.pxi", line 683, in lxml.etree._handleParseResult (src/lxml/lxml.etree.c:92647)

File "parser.pxi", line 622, in lxml.etree._raiseParseError (src/lxml/lxml.etree.c:91943)

XMLSyntaxError: expected '>', line 70, column 15


Do you know which area XML file is corrupt..? Or just replace them all?

Avatar
Discard

Now you have the information that one of the xml file is corrupt or contains a mistake. Download the correct version Odoo. Or... your module error.

Best Answer

You probably have a server running multiple instances of Odoo. You stop server and kill all other instances.

In your log, I see:

TransactionRollbackError: could not serialize access due to concurrent update

Avatar
Discard