Skip to Content
You need to be registered to interact with the community.
All Posts People Badges
Ključne besede (View all)
odoo accounting v14 pos v15
About this forum
This question has been flagged
databasecronwarning
1 Odgovori
6445 Prikazi
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
Opusti
Avatar
Zbik
Best Answer

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
Opusti
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.

Related Posts Odgovori Prikazi Aktivnost
Cannot save changes in settings
settings cron warning
Avatar
0
mar. 15
5306
Odoov13 server goes down often
server database cron odooV13
Avatar
0
maj 21
2391
Database disappeared from list after activating Google Oauth for administrator
database
Avatar
0
jul. 25
1518
Setup Odoo with specific database
database
Avatar
Avatar
2
nov. 24
6539
database locked
database
Avatar
Avatar
Avatar
2
okt. 24
3483