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

Error on upgrading database after pulling newest version from Git

By
Marius Stedjan
on 6/16/16, 1:06 PM 346 views

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 ?

Jérémy Kersten (jke)
on 6/16/16, 4:54 PM

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.

Marius Stedjan
on 6/20/16, 8:54 AM

I get the error when trying "-u all" as well.

Marius Stedjan
on 6/20/16, 8:57 AM

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

Marius Stedjan
on 6/20/16, 11:35 AM

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.

Marius Stedjan
on 6/20/16, 1:18 PM

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

2 follower(s)

Stats

Asked: 6/16/16, 1:06 PM
Seen: 346 times
Last updated: 6/16/16, 4:54 PM