Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

[11] "bad query: b'INSERT INTO "res_groups"..." / duplicate key value violates unique constraint "res_groups_name_uniq" #1243

Closed
E-HO opened this issue Dec 26, 2017 · 1 comment
Closed

[11] "bad query: b'INSERT INTO "res_groups"..." / duplicate key value violates unique constraint "res_groups_name_uniq" #1243

E-HO opened this issue Dec 26, 2017 · 1 comment

Comments

@E-HO
Copy link

E-HO commented Dec 26, 2017 •
edited
Loading

Hi,

Impacted versions: 11

Get an error after migrating from a small v10 database with CRM / Inventory / Sales / Invoicing / Accounting.

On the webpage :

`odoo.tools.convert.ParseError

odoo.tools.convert.ParseError: "duplicate key value violates unique constraint "res_groups_name_uniq"
DETAIL: Key (category_id, name)=(13, Pro-forma Invoices) already exists.
" while parsing /usr/local/src/odoo-source/addons/sale/security/sale_security.xml:48, near

Pro-forma Invoices


`

In the logs :
`2017-12-26 10:24:47,061 8640 INFO ? odoo: Odoo version 11.0
2017-12-26 10:24:47,062 8640 INFO ? odoo: Using configuration file at /usr/local/src/odoo-source/odoo-server.conf
2017-12-26 10:24:47,062 8640 INFO ? odoo: addons paths: ['/opt/odoo/.local/share/Odoo/addons/11.0', '/usr/local/src/odoo-source/addons', '/usr/local/src/odoo-extra-addons/addons-test', '/usr/local/src/odoo-extra-addons/it-projects-llc/access-addons', '/usr/local/src/odoo-extra-addons/it-projects-llc/mail-addons', '/usr/local/src/odoo-extra-addons/it-projects-llc/misc-addons', '/usr/local/src/odoo-extra-addons/it-projects-llc/pos-addons', '/usr/local/src/odoo-extra-addons/it-projects-llc/stock-logistics-barcode', '/usr/local/src/odoo-extra-addons/it-projects-llc/website-addons', '/usr/local/src/odoo-source/odoo/addons']
2017-12-26 10:24:47,062 8640 INFO ? odoo: database: odoo@default:default
2017-12-26 10:24:47,076 8640 WARNING ? odoo.service.server: 'watchdog' module not installed. Code autoreload feature is disabled
2017-12-26 10:24:47,077 8640 INFO ? odoo.service.server: HTTP service (werkzeug) running on 0.0.0.0:8069
2017-12-26 10:24:47,083 8640 INFO test odoo.modules.loading: loading 1 modules...
2017-12-26 10:24:47,174 8640 INFO test odoo.addons.base.ir.ir_actions_report: Will use the Wkhtmltopdf binary at /usr/local/bin/wkhtmltopdf
2017-12-26 10:24:47,273 8640 INFO test odoo.modules.loading: 1 modules loaded in 0.19s, 0 queries
2017-12-26 10:24:47,362 8640 INFO test odoo.modules.loading: updating modules list
2017-12-26 10:24:47,363 8640 INFO test odoo.addons.base.module.module: ALLOW access to module.update_list on [] to user info@ #1 via n/a
2017-12-26 10:24:48,039 8640 INFO test odoo.addons.base.module.module: ALLOW access to module.button_upgrade on ['todo_app'] to user info@ #1 via n/a
2017-12-26 10:24:48,039 8640 INFO test odoo.addons.base.module.module: ALLOW access to module.update_list on ['todo_app'] to user info@ #1 via n/a
2017-12-26 10:24:48,616 8640 INFO test odoo.addons.base.module.module: ALLOW access to module.button_install on [] to user info@ #1 via n/a
2017-12-26 10:24:48,663 8640 INFO test odoo.modules.loading: loading 28 modules...
2017-12-26 10:24:48,706 8640 INFO test odoo.modules.registry: module todo_app: creating or updating database tables
2017-12-26 10:24:48,722 8640 WARNING test odoo.modules.registry: Models have no table: test.config.settings.
2017-12-26 10:24:48,722 8640 INFO test odoo.modules.registry: Recreate table of model test.config.settings.
2017-12-26 10:24:48,723 8640 ERROR test odoo.modules.registry: Model test.config.settings has no table.
2017-12-26 10:24:48,782 8640 INFO test odoo.modules.loading: loading todo_app/security/ir.model.access.csv
2017-12-26 10:24:48,797 8640 INFO test odoo.modules.loading: loading todo_app/security/todo_access_rules.xml
2017-12-26 10:24:48,800 8640 INFO test odoo.modules.loading: loading todo_app/views/todo_menu.xml
2017-12-26 10:24:48,812 8640 INFO test odoo.modules.loading: loading todo_app/views/todo_view.xml
2017-12-26 10:24:49,183 8640 INFO test odoo.modules.registry: module todo_user: creating or updating database tables
2017-12-26 10:24:49,194 8640 WARNING test odoo.modules.registry: Models have no table: test.config.settings.
2017-12-26 10:24:49,195 8640 INFO test odoo.modules.registry: Recreate table of model test.config.settings.
2017-12-26 10:24:49,196 8640 ERROR test odoo.modules.registry: Model test.config.settings has no table.
2017-12-26 10:24:49,206 8640 INFO test odoo.modules.loading: loading todo_user/views/todo_task.xml
2017-12-26 10:24:49,276 8640 INFO test odoo.modules.loading: loading todo_user/security/todo_access_rules.xml
2017-12-26 10:24:49,279 8640 INFO test odoo.modules.loading: loading todo_user/data/todo.task.csv
2017-12-26 10:24:49,350 8640 INFO test odoo.modules.loading: 28 modules loaded in 0.69s, 0 queries
2017-12-26 10:24:49,403 8640 WARNING test odoo.modules.loading: The model openacademy.course has no access rules, consider adding one. E.g. access_openacademy_course,access_openacademy_course,model_openacademy_course,,1,0,0,0
2017-12-26 10:24:49,404 8640 WARNING test odoo.modules.loading: The model openacademy.session has no access rules, consider adding one. E.g. access_openacademy_session,access_openacademy_session,model_openacademy_session,,1,0,0,0
2017-12-26 10:24:49,529 8640 INFO test odoo.modules.loading: Modules loaded.
2017-12-26 10:25:01,850 8640 INFO ? odoo.http: HTTP Configuring static files
2017-12-26 10:25:01,859 8640 INFO import_migrated odoo.modules.loading: loading 1 modules...
2017-12-26 10:25:01,871 8640 INFO import_migrated odoo.modules.loading: 1 modules loaded in 0.01s, 0 queries
2017-12-26 10:25:01,877 8640 WARNING import_migrated odoo.modules.graph: module account_accountant: not installable, skipped
2017-12-26 10:25:01,884 8640 WARNING import_migrated odoo.modules.graph: module portal_sale: not installable, skipped
2017-12-26 10:25:01,899 8640 ERROR import_migrated odoo.modules.graph: module sale_crm: Unmet dependencies: sale_management
2017-12-26 10:25:01,903 8640 INFO import_migrated odoo.modules.loading: loading 51 modules...
2017-12-26 10:25:02,400 8640 INFO import_migrated odoo.modules.registry: module sale: creating or updating database tables
2017-12-26 10:25:02,575 8640 INFO import_migrated odoo.addons.auth_crypt.models.res_users: Hashing passwords, may be slow for databases with many users...
2017-12-26 10:25:02,965 8640 INFO import_migrated odoo.modules.loading: loading sale/data/ir_sequence_data.xml
2017-12-26 10:25:02,968 8640 INFO import_migrated odoo.modules.loading: loading sale/data/sale_data.xml
2017-12-26 10:25:02,981 8640 INFO import_migrated odoo.modules.loading: loading sale/report/sale_report.xml
2017-12-26 10:25:02,997 8640 INFO import_migrated odoo.modules.loading: loading sale/data/mail_template_data.xml
2017-12-26 10:25:03,001 8640 INFO import_migrated odoo.modules.loading: loading sale/report/sale_report_views.xml
2017-12-26 10:25:03,088 8640 INFO import_migrated odoo.modules.loading: loading sale/report/sale_report_templates.xml
2017-12-26 10:25:03,119 8640 INFO import_migrated odoo.models.unlink: User #1 deleted ir.translation records with IDs: [4049, 4058, 4136, 4417]
2017-12-26 10:25:03,171 8640 INFO import_migrated odoo.modules.loading: loading sale/report/invoice_report_templates.xml
2017-12-26 10:25:03,204 8640 INFO import_migrated odoo.models.unlink: User #1 deleted ir.translation records with IDs: [4048, 4135, 4416]
2017-12-26 10:25:03,269 8640 INFO import_migrated odoo.modules.loading: loading sale/report/report_all_channels_sales_views.xml
2017-12-26 10:25:03,325 8640 INFO import_migrated odoo.modules.loading: loading sale/security/sale_security.xml
2017-12-26 10:25:04,834 8640 ERROR import_migrated odoo.sql_db: bad query: b'INSERT INTO "res_groups" ("id", "name", "category_id", "share", "is_portal", "create_uid", "write_uid", "create_date", "write_date") VALUES(nextval('res_groups_id_seq'), 'Pro-forma Invoices', 13, false, false, 1, 1, (now() at time zone 'UTC'), (now() at time zone 'UTC')) RETURNING id'
ERROR: duplicate key value violates unique constraint "res_groups_name_uniq"
DETAIL: Key (category_id, name)=(13, Pro-forma Invoices) already exists.

2017-12-26 10:25:04,835 8640 ERROR import_migrated odoo.modules.registry: Failed to load registry
Traceback (most recent call last):
File "/usr/local/src/odoo-source/odoo/tools/convert.py", line 741, in parse
self._tags[rec.tag](rec, de, mode=mode)
File "/usr/local/src/odoo-source/odoo/tools/convert.py", line 651, in _tag_record
id = self.env(context=rec_context)['ir.model.data']._update(rec_model, self.module, res, rec_id or False, not self.isnoupdate(data_node), noupdate=self.isnoupdate(data_node), mode=self.mode)
File "/usr/local/src/odoo-source/odoo/addons/base/ir/ir_model.py", line 1467, in _update
record = record.create(values)
File "/usr/local/src/odoo-source/odoo/addons/base/res/res_users.py", line 682, in create
user = super(GroupsView, self).create(values)
File "/usr/local/src/odoo-source/odoo/addons/base/res/res_users.py", line 615, in create
group = super(GroupsImplied, self).create(values)
File "/usr/local/src/odoo-source/odoo/models.py", line 3281, in create
record = self.browse(self._create(old_vals))
File "/usr/local/src/odoo-source/odoo/models.py", line 3374, in _create
cr.execute(query, tuple(u[2] for u in updates if len(u) > 2))
File "/usr/local/src/odoo-source/odoo/sql_db.py", line 155, in wrapper
return f(self, *args, **kwargs)
File "/usr/local/src/odoo-source/odoo/sql_db.py", line 232, in execute
res = self._obj.execute(query, params)
psycopg2.IntegrityError: duplicate key value violates unique constraint "res_groups_name_uniq"
DETAIL: Key (category_id, name)=(13, Pro-forma Invoices) already exists.

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/usr/local/src/odoo-source/odoo/modules/registry.py", line 84, in new
odoo.modules.load_modules(registry._db, force_demo, status, update_module)
File "/usr/local/src/odoo-source/odoo/modules/loading.py", line 348, in load_modules
force, status, report, loaded_modules, update_module)
File "/usr/local/src/odoo-source/odoo/modules/loading.py", line 242, in load_marked_modules
loaded, processed = load_module_graph(cr, graph, progressdict, report=report, skip_modules=loaded_modules, perform_checks=perform_checks)
File "/usr/local/src/odoo-source/odoo/modules/loading.py", line 156, in load_module_graph
_load_data(cr, module_name, idref, mode, kind='data')
File "/usr/local/src/odoo-source/odoo/modules/loading.py", line 94, in _load_data
tools.convert_file(cr, module_name, filename, idref, mode, noupdate, kind, report)
File "/usr/local/src/odoo-source/odoo/tools/convert.py", line 788, in convert_file
convert_xml_import(cr, module, fp, idref, mode, noupdate, report)
File "/usr/local/src/odoo-source/odoo/tools/convert.py", line 849, in convert_xml_import
obj.parse(doc.getroot(), mode=mode)
File "/usr/local/src/odoo-source/odoo/tools/convert.py", line 748, in parse
exc_info[2]
File "/usr/local/src/odoo-source/odoo/tools/pycompat.py", line 86, in reraise
raise value.with_traceback(tb)
File "/usr/local/src/odoo-source/odoo/tools/convert.py", line 741, in parse
self._tags[rec.tag](rec, de, mode=mode)
File "/usr/local/src/odoo-source/odoo/tools/convert.py", line 651, in _tag_record
id = self.env(context=rec_context)['ir.model.data']._update(rec_model, self.module, res, rec_id or False, not self.isnoupdate(data_node), noupdate=self.isnoupdate(data_node), mode=self.mode)
File "/usr/local/src/odoo-source/odoo/addons/base/ir/ir_model.py", line 1467, in _update
record = record.create(values)
File "/usr/local/src/odoo-source/odoo/addons/base/res/res_users.py", line 682, in create
user = super(GroupsView, self).create(values)
File "/usr/local/src/odoo-source/odoo/addons/base/res/res_users.py", line 615, in create
group = super(GroupsImplied, self).create(values)
File "/usr/local/src/odoo-source/odoo/models.py", line 3281, in create
record = self.browse(self._create(old_vals))
File "/usr/local/src/odoo-source/odoo/models.py", line 3374, in _create
cr.execute(query, tuple(u[2] for u in updates if len(u) > 2))
File "/usr/local/src/odoo-source/odoo/sql_db.py", line 155, in wrapper
return f(self, *args, **kwargs)
File "/usr/local/src/odoo-source/odoo/sql_db.py", line 232, in execute
res = self._obj.execute(query, params)
odoo.tools.convert.ParseError: "duplicate key value violates unique constraint "res_groups_name_uniq"
DETAIL: Key (category_id, name)=(13, Pro-forma Invoices) already exists.
" while parsing /usr/local/src/odoo-source/addons/sale/security/sale_security.xml:48, near

Pro-forma Invoices


2017-12-26 10:25:04,842 8640 INFO import_migrated odoo.modules.loading: loading 1 modules...
2017-12-26 10:25:04,868 8640 INFO import_migrated werkzeug: 192.168.0.18 - - [26/Dec/2017 10:25:04] "POST /longpolling/poll HTTP/1.1" 500 -
2017-12-26 10:25:04,869 8640 INFO import_migrated odoo.modules.loading: 1 modules loaded in 0.03s, 0 queries
2017-12-26 10:25:04,878 8640 WARNING import_migrated odoo.modules.graph: module account_accountant: not installable, skipped
2017-12-26 10:25:04,886 8640 WARNING import_migrated odoo.modules.graph: module portal_sale: not installable, skipped
2017-12-26 10:25:04,906 8640 ERROR import_migrated odoo.modules.graph: module sale_crm: Unmet dependencies: sale_management
2017-12-26 10:25:04,912 8640 INFO import_migrated odoo.modules.loading: loading 51 modules...
2017-12-26 10:25:05,100 8640 INFO import_migrated odoo.modules.registry: module sale: creating or updating database tables
2017-12-26 10:25:05,267 8640 INFO import_migrated odoo.addons.auth_crypt.models.res_users: Hashing passwords, may be slow for databases with many users...
2017-12-26 10:25:05,530 8640 INFO import_migrated odoo.modules.loading: loading sale/data/ir_sequence_data.xml
2017-12-26 10:25:05,533 8640 INFO import_migrated odoo.modules.loading: loading sale/data/sale_data.xml
2017-12-26 10:25:05,545 8640 INFO import_migrated odoo.modules.loading: loading sale/report/sale_report.xml
2017-12-26 10:25:05,558 8640 INFO import_migrated odoo.modules.loading: loading sale/data/mail_template_data.xml
2017-12-26 10:25:05,562 8640 INFO import_migrated odoo.modules.loading: loading sale/report/sale_report_views.xml
2017-12-26 10:25:05,625 8640 INFO import_migrated odoo.modules.loading: loading sale/report/sale_report_templates.xml
2017-12-26 10:25:05,649 8640 INFO import_migrated odoo.models.unlink: User #1 deleted ir.translation records with IDs: [4049, 4058, 4136, 4417]
2017-12-26 10:25:05,687 8640 INFO import_migrated odoo.modules.loading: loading sale/report/invoice_report_templates.xml
2017-12-26 10:25:05,710 8640 INFO import_migrated odoo.models.unlink: User #1 deleted ir.translation records with IDs: [4048, 4135, 4416]
2017-12-26 10:25:05,769 8640 INFO import_migrated odoo.modules.loading: loading sale/report/report_all_channels_sales_views.xml
2017-12-26 10:25:05,829 8640 INFO import_migrated odoo.modules.loading: loading sale/security/sale_security.xml
2017-12-26 10:25:07,322 8640 ERROR import_migrated odoo.sql_db: bad query: b'INSERT INTO "res_groups" ("id", "name", "category_id", "share", "is_portal", "create_uid", "write_uid", "create_date", "write_date") VALUES(nextval('res_groups_id_seq'), 'Pro-forma Invoices', 13, false, false, 1, 1, (now() at time zone 'UTC'), (now() at time zone 'UTC')) RETURNING id'
ERROR: duplicate key value violates unique constraint "res_groups_name_uniq"
DETAIL: Key (category_id, name)=(13, Pro-forma Invoices) already exists.

2017-12-26 10:25:07,323 8640 ERROR import_migrated odoo.modules.registry: Failed to load registry
Traceback (most recent call last):
File "/usr/local/src/odoo-source/odoo/tools/convert.py", line 741, in parse
self._tags[rec.tag](rec, de, mode=mode)
File "/usr/local/src/odoo-source/odoo/tools/convert.py", line 651, in _tag_record
id = self.env(context=rec_context)['ir.model.data']._update(rec_model, self.module, res, rec_id or False, not self.isnoupdate(data_node), noupdate=self.isnoupdate(data_node), mode=self.mode)
File "/usr/local/src/odoo-source/odoo/addons/base/ir/ir_model.py", line 1467, in _update
record = record.create(values)
File "/usr/local/src/odoo-source/odoo/addons/base/res/res_users.py", line 682, in create
user = super(GroupsView, self).create(values)
File "/usr/local/src/odoo-source/odoo/addons/base/res/res_users.py", line 615, in create
group = super(GroupsImplied, self).create(values)
File "/usr/local/src/odoo-source/odoo/models.py", line 3281, in create
record = self.browse(self._create(old_vals))
File "/usr/local/src/odoo-source/odoo/models.py", line 3374, in _create
cr.execute(query, tuple(u[2] for u in updates if len(u) > 2))
File "/usr/local/src/odoo-source/odoo/sql_db.py", line 155, in wrapper
return f(self, *args, **kwargs)
File "/usr/local/src/odoo-source/odoo/sql_db.py", line 232, in execute
res = self._obj.execute(query, params)
psycopg2.IntegrityError: duplicate key value violates unique constraint "res_groups_name_uniq"
DETAIL: Key (category_id, name)=(13, Pro-forma Invoices) already exists.

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/usr/local/src/odoo-source/odoo/modules/registry.py", line 84, in new
odoo.modules.load_modules(registry._db, force_demo, status, update_module)
File "/usr/local/src/odoo-source/odoo/modules/loading.py", line 348, in load_modules
force, status, report, loaded_modules, update_module)
File "/usr/local/src/odoo-source/odoo/modules/loading.py", line 242, in load_marked_modules
loaded, processed = load_module_graph(cr, graph, progressdict, report=report, skip_modules=loaded_modules, perform_checks=perform_checks)
File "/usr/local/src/odoo-source/odoo/modules/loading.py", line 156, in load_module_graph
_load_data(cr, module_name, idref, mode, kind='data')
File "/usr/local/src/odoo-source/odoo/modules/loading.py", line 94, in _load_data
tools.convert_file(cr, module_name, filename, idref, mode, noupdate, kind, report)
File "/usr/local/src/odoo-source/odoo/tools/convert.py", line 788, in convert_file
convert_xml_import(cr, module, fp, idref, mode, noupdate, report)
File "/usr/local/src/odoo-source/odoo/tools/convert.py", line 849, in convert_xml_import
obj.parse(doc.getroot(), mode=mode)
File "/usr/local/src/odoo-source/odoo/tools/convert.py", line 748, in parse
exc_info[2]
File "/usr/local/src/odoo-source/odoo/tools/pycompat.py", line 86, in reraise
raise value.with_traceback(tb)
File "/usr/local/src/odoo-source/odoo/tools/convert.py", line 741, in parse
self._tags[rec.tag](rec, de, mode=mode)
File "/usr/local/src/odoo-source/odoo/tools/convert.py", line 651, in _tag_record
id = self.env(context=rec_context)['ir.model.data']._update(rec_model, self.module, res, rec_id or False, not self.isnoupdate(data_node), noupdate=self.isnoupdate(data_node), mode=self.mode)
File "/usr/local/src/odoo-source/odoo/addons/base/ir/ir_model.py", line 1467, in _update
record = record.create(values)
File "/usr/local/src/odoo-source/odoo/addons/base/res/res_users.py", line 682, in create
user = super(GroupsView, self).create(values)
File "/usr/local/src/odoo-source/odoo/addons/base/res/res_users.py", line 615, in create
group = super(GroupsImplied, self).create(values)
File "/usr/local/src/odoo-source/odoo/models.py", line 3281, in create
record = self.browse(self._create(old_vals))
File "/usr/local/src/odoo-source/odoo/models.py", line 3374, in _create
cr.execute(query, tuple(u[2] for u in updates if len(u) > 2))
File "/usr/local/src/odoo-source/odoo/sql_db.py", line 155, in wrapper
return f(self, *args, **kwargs)
File "/usr/local/src/odoo-source/odoo/sql_db.py", line 232, in execute
res = self._obj.execute(query, params)
odoo.tools.convert.ParseError: "duplicate key value violates unique constraint "res_groups_name_uniq"
DETAIL: Key (category_id, name)=(13, Pro-forma Invoices) already exists.
" while parsing /usr/local/src/odoo-source/addons/sale/security/sale_security.xml:48, near

Pro-forma Invoices


2017-12-26 10:25:07,325 8640 INFO import_migrated odoo.modules.loading: loading 1 modules...
2017-12-26 10:25:07,346 8640 INFO import_migrated odoo.modules.loading: 1 modules loaded in 0.02s, 0 queries
2017-12-26 10:25:07,352 8640 WARNING import_migrated odoo.modules.graph: module account_accountant: not installable, skipped
2017-12-26 10:25:07,355 8640 INFO import_migrated werkzeug: 192.168.0.18 - - [26/Dec/2017 10:25:07] "POST /longpolling/poll HTTP/1.1" 500 -
2017-12-26 10:25:07,372 8640 WARNING import_migrated odoo.modules.graph: module portal_sale: not installable, skipped
2017-12-26 10:25:07,390 8640 ERROR import_migrated odoo.modules.graph: module sale_crm: Unmet dependencies: sale_management
2017-12-26 10:25:07,392 8640 INFO import_migrated odoo.modules.loading: loading 51 modules...
2017-12-26 10:25:07,572 8640 INFO import_migrated odoo.modules.registry: module sale: creating or updating database tables
2017-12-26 10:25:07,832 8640 INFO import_migrated odoo.addons.auth_crypt.models.res_users: Hashing passwords, may be slow for databases with many users...
2017-12-26 10:25:08,136 8640 INFO import_migrated odoo.modules.loading: loading sale/data/ir_sequence_data.xml
2017-12-26 10:25:08,138 8640 INFO import_migrated odoo.modules.loading: loading sale/data/sale_data.xml
2017-12-26 10:25:08,153 8640 INFO import_migrated odoo.modules.loading: loading sale/report/sale_report.xml
2017-12-26 10:25:08,166 8640 INFO import_migrated odoo.modules.loading: loading sale/data/mail_template_data.xml
2017-12-26 10:25:08,170 8640 INFO import_migrated odoo.modules.loading: loading sale/report/sale_report_views.xml
2017-12-26 10:25:08,246 8640 INFO import_migrated odoo.modules.loading: loading sale/report/sale_report_templates.xml
2017-12-26 10:25:08,278 8640 INFO import_migrated odoo.models.unlink: User #1 deleted ir.translation records with IDs: [4049, 4058, 4136, 4417]
2017-12-26 10:25:08,315 8640 INFO import_migrated odoo.modules.loading: loading sale/report/invoice_report_templates.xml
2017-12-26 10:25:08,337 8640 INFO import_migrated odoo.models.unlink: User #1 deleted ir.translation records with IDs: [4048, 4135, 4416]
2017-12-26 10:25:08,386 8640 INFO import_migrated odoo.modules.loading: loading sale/report/report_all_channels_sales_views.xml
2017-12-26 10:25:08,419 8640 INFO import_migrated odoo.modules.loading: loading sale/security/sale_security.xml
2017-12-26 10:25:09,975 8640 ERROR import_migrated odoo.sql_db: bad query: b'INSERT INTO "res_groups" ("id", "name", "category_id", "share", "is_portal", "create_uid", "write_uid", "create_date", "write_date") VALUES(nextval('res_groups_id_seq'), 'Pro-forma Invoices', 13, false, false, 1, 1, (now() at time zone 'UTC'), (now() at time zone 'UTC')) RETURNING id'
ERROR: duplicate key value violates unique constraint "res_groups_name_uniq"
DETAIL: Key (category_id, name)=(13, Pro-forma Invoices) already exists.

2017-12-26 10:25:09,975 8640 ERROR import_migrated odoo.modules.registry: Failed to load registry
Traceback (most recent call last):
File "/usr/local/src/odoo-source/odoo/tools/convert.py", line 741, in parse
self._tags[rec.tag](rec, de, mode=mode)
File "/usr/local/src/odoo-source/odoo/tools/convert.py", line 651, in _tag_record
id = self.env(context=rec_context)['ir.model.data']._update(rec_model, self.module, res, rec_id or False, not self.isnoupdate(data_node), noupdate=self.isnoupdate(data_node), mode=self.mode)
File "/usr/local/src/odoo-source/odoo/addons/base/ir/ir_model.py", line 1467, in _update
record = record.create(values)
File "/usr/local/src/odoo-source/odoo/addons/base/res/res_users.py", line 682, in create
user = super(GroupsView, self).create(values)
File "/usr/local/src/odoo-source/odoo/addons/base/res/res_users.py", line 615, in create
group = super(GroupsImplied, self).create(values)
File "/usr/local/src/odoo-source/odoo/models.py", line 3281, in create
record = self.browse(self._create(old_vals))
File "/usr/local/src/odoo-source/odoo/models.py", line 3374, in _create
cr.execute(query, tuple(u[2] for u in updates if len(u) > 2))
File "/usr/local/src/odoo-source/odoo/sql_db.py", line 155, in wrapper
return f(self, *args, **kwargs)
File "/usr/local/src/odoo-source/odoo/sql_db.py", line 232, in execute
res = self._obj.execute(query, params)
psycopg2.IntegrityError: duplicate key value violates unique constraint "res_groups_name_uniq"
DETAIL: Key (category_id, name)=(13, Pro-forma Invoices) already exists.

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/usr/local/src/odoo-source/odoo/modules/registry.py", line 84, in new
odoo.modules.load_modules(registry._db, force_demo, status, update_module)
File "/usr/local/src/odoo-source/odoo/modules/loading.py", line 348, in load_modules
force, status, report, loaded_modules, update_module)
File "/usr/local/src/odoo-source/odoo/modules/loading.py", line 242, in load_marked_modules
loaded, processed = load_module_graph(cr, graph, progressdict, report=report, skip_modules=loaded_modules, perform_checks=perform_checks)
File "/usr/local/src/odoo-source/odoo/modules/loading.py", line 156, in load_module_graph
_load_data(cr, module_name, idref, mode, kind='data')
File "/usr/local/src/odoo-source/odoo/modules/loading.py", line 94, in _load_data
tools.convert_file(cr, module_name, filename, idref, mode, noupdate, kind, report)
File "/usr/local/src/odoo-source/odoo/tools/convert.py", line 788, in convert_file
convert_xml_import(cr, module, fp, idref, mode, noupdate, report)
File "/usr/local/src/odoo-source/odoo/tools/convert.py", line 849, in convert_xml_import
obj.parse(doc.getroot(), mode=mode)
File "/usr/local/src/odoo-source/odoo/tools/convert.py", line 748, in parse
exc_info[2]
File "/usr/local/src/odoo-source/odoo/tools/pycompat.py", line 86, in reraise
raise value.with_traceback(tb)
File "/usr/local/src/odoo-source/odoo/tools/convert.py", line 741, in parse
self._tags[rec.tag](rec, de, mode=mode)
File "/usr/local/src/odoo-source/odoo/tools/convert.py", line 651, in _tag_record
id = self.env(context=rec_context)['ir.model.data']._update(rec_model, self.module, res, rec_id or False, not self.isnoupdate(data_node), noupdate=self.isnoupdate(data_node), mode=self.mode)
File "/usr/local/src/odoo-source/odoo/addons/base/ir/ir_model.py", line 1467, in _update
record = record.create(values)
File "/usr/local/src/odoo-source/odoo/addons/base/res/res_users.py", line 682, in create
user = super(GroupsView, self).create(values)
File "/usr/local/src/odoo-source/odoo/addons/base/res/res_users.py", line 615, in create
group = super(GroupsImplied, self).create(values)
File "/usr/local/src/odoo-source/odoo/models.py", line 3281, in create
record = self.browse(self._create(old_vals))
File "/usr/local/src/odoo-source/odoo/models.py", line 3374, in _create
cr.execute(query, tuple(u[2] for u in updates if len(u) > 2))
File "/usr/local/src/odoo-source/odoo/sql_db.py", line 155, in wrapper
return f(self, *args, **kwargs)
File "/usr/local/src/odoo-source/odoo/sql_db.py", line 232, in execute
res = self._obj.execute(query, params)
odoo.tools.convert.ParseError: "duplicate key value violates unique constraint "res_groups_name_uniq"
DETAIL: Key (category_id, name)=(13, Pro-forma Invoices) already exists.
" while parsing /usr/local/src/odoo-source/addons/sale/security/sale_security.xml:48, near

Pro-forma Invoices


2017-12-26 10:25:09,982 8640 INFO import_migrated werkzeug: 192.168.0.18 - - [26/Dec/2017 10:25:09] "POST /longpolling/poll HTTP/1.1" 500 -
2017-12-26 10:25:11,173 8640 INFO import_migrated odoo.modules.loading: loading 1 modules...
2017-12-26 10:25:11,186 8640 INFO import_migrated odoo.modules.loading: 1 modules loaded in 0.01s, 0 queries
2017-12-26 10:25:11,191 8640 WARNING import_migrated odoo.modules.graph: module account_accountant: not installable, skipped
2017-12-26 10:25:11,198 8640 WARNING import_migrated odoo.modules.graph: module portal_sale: not installable, skipped
2017-12-26 10:25:11,209 8640 ERROR import_migrated odoo.modules.graph: module sale_crm: Unmet dependencies: sale_management
2017-12-26 10:25:11,213 8640 INFO import_migrated odoo.modules.loading: loading 51 modules...
2017-12-26 10:25:11,398 8640 INFO import_migrated odoo.modules.registry: module sale: creating or updating database tables
2017-12-26 10:25:11,590 8640 INFO import_migrated odoo.addons.auth_crypt.models.res_users: Hashing passwords, may be slow for databases with many users...
2017-12-26 10:25:11,946 8640 INFO import_migrated odoo.modules.loading: loading sale/data/ir_sequence_data.xml
2017-12-26 10:25:11,948 8640 INFO import_migrated odoo.modules.loading: loading sale/data/sale_data.xml
2017-12-26 10:25:11,962 8640 INFO import_migrated odoo.modules.loading: loading sale/report/sale_report.xml
2017-12-26 10:25:11,975 8640 INFO import_migrated odoo.modules.loading: loading sale/data/mail_template_data.xml
2017-12-26 10:25:11,978 8640 INFO import_migrated odoo.modules.loading: loading sale/report/sale_report_views.xml
2017-12-26 10:25:12,046 8640 INFO import_migrated odoo.modules.loading: loading sale/report/sale_report_templates.xml
2017-12-26 10:25:12,072 8640 INFO import_migrated odoo.models.unlink: User #1 deleted ir.translation records with IDs: [4049, 4058, 4136, 4417]
2017-12-26 10:25:12,118 8640 INFO import_migrated odoo.modules.loading: loading sale/report/invoice_report_templates.xml
2017-12-26 10:25:12,147 8640 INFO import_migrated odoo.models.unlink: User #1 deleted ir.translation records with IDs: [4048, 4135, 4416]
2017-12-26 10:25:12,211 8640 INFO import_migrated odoo.modules.loading: loading sale/report/report_all_channels_sales_views.xml
2017-12-26 10:25:12,248 8640 INFO import_migrated odoo.modules.loading: loading sale/security/sale_security.xml
2017-12-26 10:25:13,967 8640 ERROR import_migrated odoo.sql_db: bad query: b'INSERT INTO "res_groups" ("id", "name", "category_id", "share", "is_portal", "create_uid", "write_uid", "create_date", "write_date") VALUES(nextval('res_groups_id_seq'), 'Pro-forma Invoices', 13, false, false, 1, 1, (now() at time zone 'UTC'), (now() at time zone 'UTC')) RETURNING id'
ERROR: duplicate key value violates unique constraint "res_groups_name_uniq"
DETAIL: Key (category_id, name)=(13, Pro-forma Invoices) already exists.

2017-12-26 10:25:13,967 8640 ERROR import_migrated odoo.modules.registry: Failed to load registry
Traceback (most recent call last):
File "/usr/local/src/odoo-source/odoo/tools/convert.py", line 741, in parse
self._tags[rec.tag](rec, de, mode=mode)
File "/usr/local/src/odoo-source/odoo/tools/convert.py", line 651, in _tag_record
id = self.env(context=rec_context)['ir.model.data']._update(rec_model, self.module, res, rec_id or False, not self.isnoupdate(data_node), noupdate=self.isnoupdate(data_node), mode=self.mode)
File "/usr/local/src/odoo-source/odoo/addons/base/ir/ir_model.py", line 1467, in _update
record = record.create(values)
File "/usr/local/src/odoo-source/odoo/addons/base/res/res_users.py", line 682, in create
user = super(GroupsView, self).create(values)
File "/usr/local/src/odoo-source/odoo/addons/base/res/res_users.py", line 615, in create
group = super(GroupsImplied, self).create(values)
File "/usr/local/src/odoo-source/odoo/models.py", line 3281, in create
record = self.browse(self._create(old_vals))
File "/usr/local/src/odoo-source/odoo/models.py", line 3374, in _create
cr.execute(query, tuple(u[2] for u in updates if len(u) > 2))
File "/usr/local/src/odoo-source/odoo/sql_db.py", line 155, in wrapper
return f(self, *args, **kwargs)
File "/usr/local/src/odoo-source/odoo/sql_db.py", line 232, in execute
res = self._obj.execute(query, params)
psycopg2.IntegrityError: duplicate key value violates unique constraint "res_groups_name_uniq"
DETAIL: Key (category_id, name)=(13, Pro-forma Invoices) already exists.

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "/usr/local/src/odoo-source/odoo/modules/registry.py", line 84, in new
odoo.modules.load_modules(registry._db, force_demo, status, update_module)
File "/usr/local/src/odoo-source/odoo/modules/loading.py", line 348, in load_modules
force, status, report, loaded_modules, update_module)
File "/usr/local/src/odoo-source/odoo/modules/loading.py", line 242, in load_marked_modules
loaded, processed = load_module_graph(cr, graph, progressdict, report=report, skip_modules=loaded_modules, perform_checks=perform_checks)
File "/usr/local/src/odoo-source/odoo/modules/loading.py", line 156, in load_module_graph
_load_data(cr, module_name, idref, mode, kind='data')
File "/usr/local/src/odoo-source/odoo/modules/loading.py", line 94, in _load_data
tools.convert_file(cr, module_name, filename, idref, mode, noupdate, kind, report)
File "/usr/local/src/odoo-source/odoo/tools/convert.py", line 788, in convert_file
convert_xml_import(cr, module, fp, idref, mode, noupdate, report)
File "/usr/local/src/odoo-source/odoo/tools/convert.py", line 849, in convert_xml_import
obj.parse(doc.getroot(), mode=mode)
File "/usr/local/src/odoo-source/odoo/tools/convert.py", line 748, in parse
exc_info[2]
File "/usr/local/src/odoo-source/odoo/tools/pycompat.py", line 86, in reraise
raise value.with_traceback(tb)
File "/usr/local/src/odoo-source/odoo/tools/convert.py", line 741, in parse
self._tags[rec.tag](rec, de, mode=mode)
File "/usr/local/src/odoo-source/odoo/tools/convert.py", line 651, in _tag_record
id = self.env(context=rec_context)['ir.model.data']._update(rec_model, self.module, res, rec_id or False, not self.isnoupdate(data_node), noupdate=self.isnoupdate(data_node), mode=self.mode)
File "/usr/local/src/odoo-source/odoo/addons/base/ir/ir_model.py", line 1467, in _update
record = record.create(values)
File "/usr/local/src/odoo-source/odoo/addons/base/res/res_users.py", line 682, in create
user = super(GroupsView, self).create(values)
File "/usr/local/src/odoo-source/odoo/addons/base/res/res_users.py", line 615, in create
group = super(GroupsImplied, self).create(values)
File "/usr/local/src/odoo-source/odoo/models.py", line 3281, in create
record = self.browse(self._create(old_vals))
File "/usr/local/src/odoo-source/odoo/models.py", line 3374, in _create
cr.execute(query, tuple(u[2] for u in updates if len(u) > 2))
File "/usr/local/src/odoo-source/odoo/sql_db.py", line 155, in wrapper
return f(self, *args, **kwargs)
File "/usr/local/src/odoo-source/odoo/sql_db.py", line 232, in execute
res = self._obj.execute(query, params)
odoo.tools.convert.ParseError: "duplicate key value violates unique constraint "res_groups_name_uniq"
DETAIL: Key (category_id, name)=(13, Pro-forma Invoices) already exists.
" while parsing /usr/local/src/odoo-source/addons/sale/security/sale_security.xml:48, near

Pro-forma Invoices


2017-12-26 10:25:13,975 8640 INFO import_migrated werkzeug: 192.168.0.18 - - [26/Dec/2017 10:25:13] "POST /longpolling/poll HTTP/1.1" 500 -
`
@pedrobaeza
Copy link
Member

OpenUpgrade v11 is far from being complete, so this error is expected if you are trying to migrate a non convered module. Check https://github.com/OCA/OpenUpgrade/blob/11.0/odoo/openupgrade/doc/source/modules100-110.rst

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@pedrobaeza @E-HO