Siirry sisältöön
Sinun on rekisteröidyttävä, jotta voit olla vuorovaikutuksessa yhteisön kanssa.
Kaikki kirjoitukset Ihmiset Merkit
Tunnisteet (Näytä kaikki)
odoo accounting v14 pos v15
Tietoa tästä foorumista
Tämä kysymys on merkitty
databasecronwarning
1 Vastaa
6455 Näkymät
Avatar
Yann MOTTE

We have in aour production postgresql cluster databases for odoo and for other products. By watching odoo log files, we saw that ir_cron try to work with non Odoo db. We have a dbfilter in our conf file : dbfilter='^LIB_.*'

Does exist a way to prevent those warning ?

​2019-06-12 10:50:09,033 36 ERROR zato odoo.sql_db: bad query: b"SELECT latest_version FROM ir_module_module WHERE name='base'"
ERROR: relation "ir_module_module" does not exist
LINE 1: SELECT latest_version FROM ir_module_module WHERE name='base...

Avatar
Hylkää
Avatar
Zbik
Paras vastaus

In standard Odoo should be installed with user = odoo. In this case all Odoo databases has owner = odoo. Your bases must have probably another owner.

ALTER DATABASE name OWNER TO new_owner;


Avatar
Hylkää
Ronald Portier

There are many cases where multiple Odoo instances are sharing a same postgress cluster. It is certainly not a requirement that databases have odoo as owner. If there are multiple instances, that would actually be a security breach. Odoo should respect dbfilter. This not happening is a bug.

Aiheeseen liittyviä artikkeleita Vastaukset Näkymät Toimenpide
Cannot save changes in settings
settings cron warning
Avatar
0
maalisk. 15
5310
Odoov13 server goes down often
server database cron odooV13
Avatar
0
toukok. 21
2392
Database disappeared from list after activating Google Oauth for administrator
database
Avatar
0
heinäk. 25
1528
Setup Odoo with specific database
database
Avatar
Avatar
2
marrask. 24
6548
database locked
database
Avatar
Avatar
Avatar
2
lokak. 24
3495