Erro Criação Banco de Dados

Higor Ribeiro

unread,

Dec 9, 2019, 8:04:36 PM12/9/19

to OdooBrasil

Estou testando montar um servidor para testes de configuração sendo que não estou conseguindo criar banco de dados.

Ao iniciar odoo 12, sem nenhum modulo adicional, ele abre a tela de criação de banco de dados, é preenchido os dados e selecionado a linguagem Portugues BR e Pais Brasil.

ele começa a configurar o banco e no final apresenta a seguinte mensagem de erro.

2019-12-10 01:00:39,315 15118 INFO DB_001_CRM odoo.tools.translate: loading /opt/odoo/odoo-server/odoo/addons/base/i18n/pt_BR.po

2019-12-10 01:00:39,737 15118 ERROR DB_001_CRM odoo.sql_db: bad query: INSERT INTO ir_translation(name, lang, res_id, src, type, value, module, state, comments)

SELECT name, lang, res_id, src, type, value, module, state, comments

FROM tmp_ir_translation_import

WHERE type = 'model'

AND noupdate IS NOT TRUE

ON CONFLICT (type, lang, name, res_id) WHERE type = 'model'

DO UPDATE SET (name, lang, res_id, src, type, value, module, state, comments) = (EXCLUDED.name, EXCLUDED.lang, EXCLUDED.res_id, EXCLUDED.src, EXCLUDED.type, EXCLUDED.value, EXCLUDED.module, EXCLUDED.state, EXCLUDED.comments)

WHERE EXCLUDED.value IS NOT NULL AND EXCLUDED.value != '';

ERROR: ON CONFLICT DO UPDATE command cannot affect row a second time

HINT: Ensure that no rows proposed for insertion within the same command have duplicate constrained values.

2019-12-10 01:00:39,755 15118 WARNING DB_001_CRM odoo.modules.loading: Transient module states were reset

2019-12-10 01:00:39,756 15118 ERROR DB_001_CRM odoo.modules.registry: Failed to load registry

Traceback (most recent call last):

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

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

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

report=report, models_to_check=models_to_check)

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

module.with_context(overwrite=overwrite)._update_translations()

File "/opt/odoo/odoo-server/odoo/addons/base/models/ir_module.py", line 885, in _update_translations

self.env['ir.translation'].load_module_terms(mod_names, filter_lang)

File "/opt/odoo/odoo-server/odoo/addons/base/models/ir_translation.py", line 825, in load_module_terms

tools.trans_load(self._cr, trans_file, lang, verbose=False, module_name=module_name, context=context)

File "/opt/odoo/odoo-server/odoo/tools/translate.py", line 1016, in trans_load

result = trans_load_data(cr, fileobj, fileformat, lang, verbose=verbose, module_name=module_name, context=context)

File "/opt/odoo/odoo-server/odoo/tools/translate.py", line 1160, in trans_load_data

irt_cursor.finish()

File "/opt/odoo/odoo-server/odoo/addons/base/models/ir_translation.py", line 156, in finish

""" % (self._model_table, self._table))

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

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

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

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

psycopg2.ProgrammingError: ON CONFLICT DO UPDATE command cannot affect row a second time

HINT: Ensure that no rows proposed for insertion within the same command have duplicate constrained values.

2019-12-10 01:00:39,757 15118 ERROR DB_001_CRM odoo.service.db: CREATE DATABASE failed:

Traceback (most recent call last):

File "/opt/odoo/odoo-server/odoo/service/db.py", line 62, in _initialize_db

registry = odoo.modules.registry.Registry.new(db_name, demo, None, update_module=True)