I have pulled the newest version of odoo 9 and enterprise from Git.
The previous commit i pulled was d467238 on April 10th 2016.
When trying to upgrade all the modules for my database I get this error:
2016-06-16 16:55:36,809 11782 CRITICAL NST-150616-2 openerp.service.server: Failed to initialize database `NST-150616-2`. Traceback (most recent call last): File "/opt/odoo/odoo/openerp/service/server.py", line 892, in preload_registries registry = RegistryManager.new(dbname, update_module=update_module) File "/opt/odoo/odoo/openerp/modules/registry.py", line 386, in new openerp.modules.load_modules(registry._db, force_demo, status, update_module) File "/opt/odoo/odoo/openerp/modules/loading.py", line 365, in load_modules registry['ir.model.data']._process_end(cr, SUPERUSER_ID, processed_modules) File "/opt/odoo/odoo/openerp/api.py", line 250, in wrapper return old_api(self, *args, **kwargs) File "/opt/odoo/odoo/openerp/addons/base/ir/ir_model.py", line 1301, in _process_end self.pool[model].unlink(cr, uid, [res_id], context=context) File "/opt/odoo/odoo/openerp/api.py", line 250, in wrapper return old_api(self, *args, **kwargs) File "/opt/odoo/odoo/addons/product/product.py", line 1018, in unlink res = super(product_product, self).unlink(cr, uid, unlink_ids, context=context) File "/opt/odoo/odoo/openerp/api.py", line 250, in wrapper return old_api(self, *args, **kwargs) File "/opt/odoo/odoo/openerp/api.py", line 381, in old_api result = method(recs, *args, **kwargs) File "/opt/odoo/odoo/addons/mail/models/mail_thread.py", line 295, in unlink res = super(MailThread, self).unlink() File "/opt/odoo/odoo/openerp/api.py", line 248, in wrapper return new_api(self, *args, **kwargs) File "/opt/odoo/odoo/openerp/api.py", line 574, in new_api result = method(self._model, cr, uid, self.ids, *args, **old_kwargs) File "/opt/odoo/odoo/openerp/models.py", line 3677, in unlink 'where id IN %s', (sub_ids,)) File "/opt/odoo/odoo/openerp/sql_db.py", line 141, in wrapper return f(self, *args, **kwargs) File "/opt/odoo/odoo/openerp/sql_db.py", line 220, in execute res = self._obj.execute(query, params) IntegrityError: null value in column "product_id" violates not-null constraint DETAIL: Failing row contains (15964, 1, 2016-06-15 13:49:01.823414, null, 1, 1, LAYERS WARM NECKTUBE, 2016-12-31, 2016-01-01, 1, 1.00, 15, 2, 2016-06-15 13:49:01.823414, 72.00, 1, LA560, 4900, 33). CONTEXT: SQL statement "UPDATE ONLY "public"."product_supplierinfo" SET "product_id" = NULL WHERE $1 OPERATOR(pg_catalog.=) "product_id""
First of all, why is Odoo trying to delete all the products?
And does anyone know how to fix this?
very strange...
What are the command that you are doing ? -u base ?
There are no reason that we delete all products...
And in stable version like v9... we don't change model... So it should not happend...
Are you sure that you have pulled both community and enterprise V9 ?
It happens when i try to use -u base, -u web and -u website
The log says that it is unlinking all products. When it gets to a product with a product_supplierinfo record, attribute record, sales_order record, or any other record linked to the product, I get the same error.
I have pulled both community and enterprise. However, last time I upgraded, I upgraded only enterprise. This has been working for almost two months, until I try to upgrade again.
I get the error when trying "-u all" as well.
Here is a bit more of the log. I've now pulled latest odoo and enterprise.
2016-06-20 15:31:11,277 2139 INFO NST openerp.modules.loading: loading theme_nst/views/website_sale_template.xml
2016-06-20 15:31:11,385 2139 INFO NST openerp.addons.base.ir.ir_translation: module theme_nst: no translation for language nb_NO
2016-06-20 15:31:11,611 2139 INFO NST openerp.modules.loading: 134 modules loaded in 185.59s, 490 queries
2016-06-20 15:31:11,904 2139 WARNING NST openerp.modules.loading: The model x_cookiebar_config has no access rules, consider adding one. E.g. access_x_cookiebar_config,access_x_cookiebar_config,model_x_cookiebar_config,,1,0,0,0
2016-06-20 15:31:12,241 2139 INFO NST openerp.addons.base.ir.ir_model: Deleting 24502@product.product (product.product_variant_OF4054)
2016-06-20 15:31:12,265 2139 INFO NST openerp.models.unlink: User #1 deleted mail.message records with IDs: [23459]
2016-06-20 15:31:12,280 2139 INFO NST openerp.models.unlink: User #1 deleted ir.property records with IDs: [16589]
2016-06-20 15:31:12,303 2139 INFO NST openerp.sql_db: bad query: delete from product_product where id IN (24502)
2016-06-20 15:31:12,307 2139 ERROR NST openerp.modules.registry: Failed to load registry
Traceback (most recent call last):
File "/opt/odoo/odoo/openerp/modules/registry.py", line 386, in new
openerp.modules.load_modules(registry._db, force_demo, status, update_module)
File "/opt/odoo/odoo/openerp/modules/loading.py", line 365, in load_modules
registry['ir.model.data']._process_end(cr, SUPERUSER_ID, processed_modules)
File "/opt/odoo/odoo/openerp/api.py", line 250, in wrapper
return old_api(self, *args, **kwargs)
File "/opt/odoo/odoo/openerp/addons/base/ir/ir_model.py", line 1301, in _process_end
self.pool[model].unlink(cr, uid, [res_id], context=context)
File "/opt/odoo/odoo/openerp/api.py", line 250, in wrapper
return old_api(self, *args, **kwargs)
File "/opt/odoo/odoo/addons/product/product.py", line 1019, in unlink
res = super(product_product, self).unlink(cr, uid, unlink_ids, context=context)
File "/opt/odoo/odoo/openerp/api.py", line 250, in wrapper
return old_api(self, *args, **kwargs)
File "/opt/odoo/odoo/openerp/api.py", line 381, in old_api
result = method(recs, *args, **kwargs)
File "/opt/odoo/odoo/addons/mail/models/mail_thread.py", line 295, in unlink
res = super(MailThread, self).unlink()
File "/opt/odoo/odoo/openerp/api.py", line 248, in wrapper
return new_api(self, *args, **kwargs)
File "/opt/odoo/odoo/openerp/api.py", line 574, in new_api
result = method(self._model, cr, uid, self.ids, *args, **old_kwargs)
File "/opt/odoo/odoo/openerp/models.py", line 3677, in unlink
'where id IN %s', (sub_ids,))
File "/opt/odoo/odoo/openerp/sql_db.py", line 141, in wrapper
return f(self, *args, **kwargs)
File "/opt/odoo/odoo/openerp/sql_db.py", line 220, in execute
res = self._obj.execute(query, params)
IntegrityError: null value in column "product_id" violates not-null constraint
DETAIL: Failing row contains (16039, 1, 2016-06-15 16:56:17.556828, null, 1, 1, OXFORD BRIGHT TOP 4XL, 2016-12-31, 2016-01-01, 1, 1.00, 15, 2, 2016-06-15 16:56:17.556828, 209.40, 1, OF4054, 4921, 33).
CONTEXT: SQL statement "UPDATE ONLY "public"."product_supplierinfo" SET "product_id" = NULL WHERE $1 OPERATOR(pg_catalog.=) "product_id""
2016-06-20 15:31:12,313 2139 CRITICAL NST openerp.service.server: Failed to initialize database `NST`.
Traceback (most recent call last):
File "/opt/odoo/odoo/openerp/service/server.py", line 892, in preload_registries
registry = RegistryManager.new(dbname, update_module=update_module)
File "/opt/odoo/odoo/openerp/modules/registry.py", line 386, in new
openerp.modules.load_modules(registry._db, force_demo, status, update_module)
File "/opt/odoo/odoo/openerp/modules/loading.py", line 365, in load_modules
registry['ir.model.data']._process_end(cr, SUPERUSER_ID, processed_modules)
File "/opt/odoo/odoo/openerp/api.py", line 250, in wrapper
return old_api(self, *args, **kwargs)
File "/opt/odoo/odoo/openerp/addons/base/ir/ir_model.py", line 1301, in _process_end
self.pool[model].unlink(cr, uid, [res_id], context=context)
File "/opt/odoo/odoo/openerp/api.py", line 250, in wrapper
return old_api(self, *args, **kwargs)
File "/opt/odoo/odoo/addons/product/product.py", line 1019, in unlink
res = super(product_product, self).unlink(cr, uid, unlink_ids, context=context)
File "/opt/odoo/odoo/openerp/api.py", line 250, in wrapper
return old_api(self, *args, **kwargs)
File "/opt/odoo/odoo/openerp/api.py", line 381, in old_api
result = method(recs, *args, **kwargs)
File "/opt/odoo/odoo/addons/mail/models/mail_thread.py", line 295, in unlink
res = super(MailThread, self).unlink()
File "/opt/odoo/odoo/openerp/api.py", line 248, in wrapper
return new_api(self, *args, **kwargs)
File "/opt/odoo/odoo/openerp/api.py", line 574, in new_api
result = method(self._model, cr, uid, self.ids, *args, **old_kwargs)
File "/opt/odoo/odoo/openerp/models.py", line 3677, in unlink
'where id IN %s', (sub_ids,))
File "/opt/odoo/odoo/openerp/sql_db.py", line 141, in wrapper
return f(self, *args, **kwargs)
File "/opt/odoo/odoo/openerp/sql_db.py", line 220, in execute
res = self._obj.execute(query, params)
IntegrityError: null value in column "product_id" violates not-null constraint
DETAIL: Failing row contains (16039, 1, 2016-06-15 16:56:17.556828, null, 1, 1, OXFORD BRIGHT TOP 4XL, 2016-12-31, 2016-01-01, 1, 1.00, 15, 2, 2016-06-15 16:56:17.556828, 209.40, 1, OF4054, 4921, 33).
CONTEXT: SQL statement "UPDATE ONLY "public"."product_supplierinfo" SET "product_id" = NULL WHERE $1 OPERATOR(pg_catalog.=) "product_id""
2016-06-20 15:31:12,314 2139 INFO NST openerp.sql_db: ConnectionPool(used=0/count=0/max=64): Closed 2 connections
2016-06-20 15:31:12,330 2159 INFO NST openerp.service.server: Worker WorkerHTTP (2159) alive
2016-06-20 15:31:12,354 2160 INFO NST openerp.service.server: Worker WorkerHTTP (2160) alive
2016-06-20 15:31:12,389 2161 INFO NST openerp.service.server: Worker WorkerHTTP (2161) alive
2016-06-20 15:31:12,426 2162 INFO NST openerp.service.server: Worker WorkerHTTP (2162) alive
2016-06-20 15:31:12,501 2164 INFO NST openerp.service.server: Worker WorkerCron (2164) alive
2016-06-20 15:31:12,503 2165 INFO NST openerp.service.server: Worker WorkerCron (2165) alive
2016-06-20 15:31:13,091 2163 INFO ? openerp: OpenERP version 9.0c
2016-06-20 15:31:13,091 2163 INFO ? openerp: addons paths: ['/opt/odoo/.local/share/Odoo/addons/9.0', u'/opt/odoo/enterprise', u'/opt/odoo/odoo/addons', u'/opt/odoo/custom/themes', u'/opt/odoo/custom/addons', '/opt/odoo/odoo/openerp/addons']
2016-06-20 15:31:13,091 2163 INFO ? openerp: database: odoo@default:default
2016-06-20 15:31:13,273 2163 INFO ? openerp.service.server: Evented Service (longpolling) running on 127.0.0.1:8072
It seems like the upgrade if modules is successful, but for some reason, odoo starts unlinking stuff after the upgrade:
2016-06-20 17:12:05,652 3103 INFO NST openerp.addons.base.ir.ir_model: Deleting 24502@product.product (product.product_variant_OF4054)
2016-06-20 17:12:05,675 3103 INFO NST openerp.models.unlink: User #1 deleted mail.message records with IDs: [23459]
2016-06-20 17:12:05,693 3103 INFO NST openerp.models.unlink: User #1 deleted ir.property records with IDs: [16589]
2016-06-20 17:12:05,720 3103 INFO NST openerp.models.unlink: User #1 deleted ir.model.data records with IDs: [31067]
2016-06-20 17:12:05,742 3103 INFO NST openerp.models.unlink: User #1 deleted ir.attachment records with IDs: [19215]
2016-06-20 17:12:05,757 3103 INFO NST openerp.models.unlink: User #1 deleted product.product records with IDs: [24502]
2016-06-20 17:12:05,766 3103 INFO NST openerp.models.unlink: User #1 deleted mail.followers records with IDs: [23343]
2016-06-20 17:12:05,771 3103 INFO NST openerp.addons.base.ir.ir_model: Deleting 24501@product.product (product.product_variant_OF405)
2016-06-20 17:12:05,787 3103 INFO NST openerp.models.unlink: User #1 deleted mail.message records with IDs: [23458]
2016-06-20 17:12:05,800 3103 INFO NST openerp.models.unlink: User #1 deleted ir.property records with IDs: [16588]
2016-06-20 17:12:05,814 3103 INFO NST openerp.models.unlink: User #1 deleted ir.model.data records with IDs: [31066]
2016-06-20 17:12:05,833 3103 INFO NST openerp.models.unlink: User #1 deleted ir.attachment records with IDs: [19214]
2016-06-20 17:12:05,842 3103 INFO NST openerp.models.unlink: User #1 deleted product.product records with IDs: [24501]
2016-06-20 17:12:05,847 3103 INFO NST openerp.models.unlink: User #1 deleted mail.followers records with IDs: [23342]
2016-06-20 17:12:05,849 3103 INFO NST openerp.addons.base.ir.ir_model: Deleting 24500@product.product (product.product_variant_OF404)
2016-06-20 17:12:05,859 3103 INFO NST openerp.models.unlink: User #1 deleted mail.message records with IDs: [23457]
2016-06-20 17:12:05,870 3103 INFO NST openerp.models.unlink: User #1 deleted ir.property records with IDs: [16587]
2016-06-20 17:12:05,882 3103 INFO NST openerp.models.unlink: User #1 deleted ir.model.data records with IDs: [31065]
2016-06-20 17:12:05,897 3103 INFO NST openerp.models.unlink: User #1 deleted ir.attachment records with IDs: [19213]
2016-06-20 17:12:05,906 3103 INFO NST openerp.models.unlink: User #1 deleted product.product records with IDs: [24500]
2016-06-20 17:12:05,911 3103 INFO NST openerp.models.unlink: User #1 deleted mail.followers records with IDs: [23341]
Eventually it finds a product linked to a sales order, attribute or product_supplierinfo record, and throws an error.
I can stop Odoo with Ctrl-C, and restart without the upgrade command, and Odoo works.
The only thing I can see is wrong, is that Odoo has deleted image attachments for a lot of products.