IntegrityError: could not create unique index
Hi
Great software.. but maybe it breaks in a multi company instance...
I backuped 6.0.4 db (pgsql8.4) with GTK 6.0 client and imported it in a 6.1 db (pgsql 9.1) with GTK 6.1 client.. so far so good.
Then i run following, see also output and check all the lines with DETAIL:.... dublicated...
./server/
2012-10-16 11:49:01,653 7496 INFO ? openerp: OpenERP version 6.1
2012-10-16 11:49:01,653 7496 INFO ? openerp: addons paths: /home/thomi/
2012-10-16 11:49:01,653 7496 INFO ? openerp: database hostname: localhost
2012-10-16 11:49:01,654 7496 INFO ? openerp: database port: 5433
2012-10-16 11:49:01,654 7496 INFO ? openerp: database user: openerp-testing
2012-10-16 11:49:01,782 7496 INFO ? openerp.addons.web: embedded mode
2012-10-16 11:49:02,191 7496 INFO winsoft_20121013 openerp.
2012-10-16 11:49:02,193 7496 INFO winsoft_20121013 openerp.
2012-10-16 11:49:02,193 7496 INFO winsoft_20121013 OpenUpgrade: /home/thomi/
2012-10-16 11:49:02,195 7496 WARNING winsoft_20121013 OpenUpgrade: No rows affected for query "ALTER TABLE ir_model_fields ADD COLUMN serialization_
2012-10-16 11:49:02,196 7496 INFO winsoft_20121013 OpenUpgrade: table res_users: drop column user_email
2012-10-16 11:49:02,197 7496 WARNING winsoft_20121013 OpenUpgrade: table res_users: column user_email did not exist
2012-10-16 11:49:02,197 7496 INFO winsoft_20121013 OpenUpgrade: table res_users, column email: renaming to user_email
2012-10-16 11:49:02,200 7496 WARNING winsoft_20121013 OpenUpgrade: No rows affected for query "UPDATE ir_module_module SET name = plugin_outlook WHERE name = outlook"
2012-10-16 11:49:02,201 7496 WARNING winsoft_20121013 OpenUpgrade: No rows affected for query "UPDATE ir_model_data SET module = plugin_outlook WHERE module = outlook "
2012-10-16 11:49:02,202 7496 WARNING winsoft_20121013 OpenUpgrade: No rows affected for query "UPDATE ir_module_module SET name = plugin_thunderbird WHERE name = thunderbird"
2012-10-16 11:49:02,254 7496 WARNING winsoft_20121013 OpenUpgrade: No rows affected for query "UPDATE ir_model_data SET module = plugin_thunderbird WHERE module = thunderbird "
2012-10-16 11:49:02,254 7496 WARNING winsoft_20121013 OpenUpgrade: No rows affected for query "UPDATE ir_module_module SET name = mail WHERE name = mail_gateway"
2012-10-16 11:49:02,358 7496 WARNING winsoft_20121013 OpenUpgrade: No rows affected for query "UPDATE ir_model_data SET module = mail WHERE module = mail_gateway "
2012-10-16 11:49:02,469 7496 WARNING winsoft_20121013 OpenUpgrade: No rows affected for query "UPDATE ir_module_module SET demo = false"
2012-10-16 11:49:02,588 7496 INFO winsoft_20121013 openerp.
2012-10-16 11:49:02,816 7496 ERROR winsoft_20121013 openerp.sql_db: bad query: ALTER TABLE "ir_sequence_type" ADD CONSTRAINT "ir_sequence_
Traceback (most recent call last):
File "/home/
res = self._obj.
IntegrityError: could not create unique index "ir_sequence_
DETAIL: Key (code)=(g&v_n) is duplicated.
2012-10-16 11:49:02,816 7496 WARNING winsoft_20121013 openerp.
If you want to have it, you should update the records and execute manually:
ALTER TABLE "ir_sequence_type" ADD CONSTRAINT "ir_sequence_
2012-10-16 11:49:07,534 7496 ERROR winsoft_20121013 openerp.sql_db: bad query: ALTER TABLE "res_currency" ADD CONSTRAINT "res_currency_
Traceback (most recent call last):
File "/home/
res = self._obj.
IntegrityError: could not create unique index "res_currency_
DETAIL: Key (name, company_id)=(kr, 1) is duplicated.
2012-10-16 11:49:07,535 7496 WARNING winsoft_20121013 openerp.
If you want to have it, you should update the records and execute manually:
ALTER TABLE "res_currency" ADD CONSTRAINT "res_currency_
2012-10-16 11:49:07,539 7496 ERROR winsoft_20121013 openerp.sql_db: bad query: CREATE UNIQUE INDEX res_currency_
Traceback (most recent call last):
File "/home/
res = self._obj.
IntegrityError: could not create unique index "res_currency_
DETAIL: Key (name, (COALESCE(
2012-10-16 11:49:07,659 7496 ERROR winsoft_20121013 openerp: Failed to initialize database `winsoft_20121013`.
Traceback (most recent call last):
File "./server/
db, registry = openerp.
File "/home/
registry = RegistryManager
File "/home/
update_module, pooljobs)
File "/home/
openerp.
File "/home/
loaded_modules, processed_modules = load_module_
File "/home/
init_
File "/home/
obj.init(cr)
File "/home/
(name, (COALESCE(
File "/home/
return f(self, *args, **kwargs)
File "/home/
res = self._obj.
IntegrityError: could not create unique index "res_currency_
DETAIL: Key (name, (COALESCE(
Is it real, that i breaks on a multi company instance?
additional information..
I checked out res_currency and we use one currency (CHF) for two companies.. in res_currency the company_id column is empty, so we can use the same currency for both companies.. same happens on a customer of us which has about 6 companies sharing the same currency...
Thanks for feedback...
regards from swiss-german
thomi
Question information
- Language:
- English Edit question
- Status:
- Solved
- Assignee:
- No assignee Edit question
- Solved by:
- Stefan Rijnhart (Opener)
- Solved:
- Last query:
- Last reply: