Hello,

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
cnx.reset()
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.

Thank you!