Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

0

Update error..?

By
Angelo Labate
on 3/24/15, 11:11 AM 1,162 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.

0
Angelo Labate
On 3/24/15, 11:17 AM

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?

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.

zbik
on 3/24/15, 2:19 PM
0

zbik

--zbik--
5941
| 6 4 7
Lodz, Poland
--zbik--


zbik
On 3/24/15, 11:18 AM

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

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

Asked: 3/24/15, 11:11 AM
Seen: 1162 times
Last updated: 3/24/15, 2:27 PM