Timeout for database on a different server behind a proxy
we are trying to run an Odoo instance connecting to a database located on a different server, and behind a proxy (HAProxy).
This would be:
Odoo =====> Internet =====> HAProxy ==> PostgreSQL
Everything works fine, except that after a certain time, I get an error:
File "/usr/local/openerp/openerp-buildout/parts/odoo/openerp/sql_db.py", line 499, in borrow
DatabaseError: SSL SYSCALL error: EOF detected
This is certainly due to the proxy terminating the connection after a certain amount of time.
So my questions are:
Isn't there a way to check the connection before trying to use/reset it?
Wouldn't it be a bad practice to set a very high timeout on the proxy (1 hour for instance)? But I think that even after one hour, the same error will be raised.