Odoo is the world's easiest all-in-one management software. It includes hundreds of business apps:
CRM | e-Commerce | Accounting | Inventory | PoS | Project management | MRP | etc.
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.
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.Register
Odoo Training Center
Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.Test it now
|Asked: 6/24/15, 3:04 PM|
|Seen: 1176 times|
|Last updated: 6/24/15, 3:04 PM|