Skip to Content
This question has been flagged
2 Replies
4348 Views
Avatar
BeautyByMe SAS

Hi,

I am using Odoo with ir_attachment location is in database (db-storage).

Thus i can see the following error very often into my logs :

DELETE FROM ir_attachment WHERE id IN (302496, 302495)
2019-12-09 12:23:35,490 22725 INFO prod odoo.service.model: SERIALIZATION_FAILURE, retry 1/5 in 0.1333 sec...
2019-12-09 12:23:35,552 17067 INFO prod odoo.sql_db: bad query: DELETE FROM ir_attachment WHERE id IN (302496, 302495)
2019-12-09 12:23:35,554 17067 INFO prod odoo.service.model: SERIALIZATION_FAILURE, retry 1/5 in 0.3361 sec...


I noticed that the files web.assets_frontend and web.assets_backend are regenerated very often.
​
Why is it regenerated so often ?
How to avoid that ?
What could be the root cause ?

My Odoo 10 website loading is very slow, and might be related to that also.

Thanks and regards

Avatar
Discard
Avatar
Tg
Best Answer

Hi.. I am also getting the same error.. Any updates on how to fix this ?

Avatar
Discard
Avatar
BeautyByMe SAS
Author Best Answer

Hi,

Can anyone help on this ?

I found another user having the same issue :
https://www.odoo.com/fr_FR/forum/aide-1/question/nginx-loadbalancer-config-161724

On my side i can see that issue occurs each time i am accessing my website with a new subdomain name.

Eg: I am having 2 front servers :
web1.domain.com
backoffice.domain.com

I want backoffice to be directly connected to Database.
web1 is connected to a middle pgbouncer.

Each time i use a different subdomain CSS are rebuilt on Odoo.
Leading to latencies.

It looks forcing nginx header improve, but i still not found the exact fix :
proxy_set_header "Host"                     "domain.com";

Can someone help ?

Avatar
Discard