How can I avoid the following instability of openerp-server?
Observations about possible correlations (cause and effect unkown):
- Pop ups of "XmlHttpRequestError" (this what the observations usually start with)
- OpenERP Freeze without error Message.
- Browser Title shows "OpenERP" with logo
- Browser window remains simply completely blank
- Adress line transforms - as it should be to http://[IP-ADDRESS]:8069/?db=[DB-NAME] when accessing: http://[IP-ADDRESS]:8069
- On the server are shown several PIDs for the SAME Company Database by the postgres user
- Overall behaviour of OpenERP is rather inconsistent, suddenly it works, then again it doesn't ("XmlHttpRequestError" & blank screen) - and probably a bit slower as usual
- A
service openerp-server restart
it doesnt seem to solve the problem, - After a
reboot
the inconsistent behaviour aparently is not affected. (blank browser content) - Im in Colombia -> Instable Network Connection? - But: other Requests, such as normal homepages seem fast and without delay - during the same timeframe.
- Servers (Company: ChicagoVPS, 2 GB RAM, SSD-HD, VPS) are situated in Atlanta
- I have a
barman
WAL-archiver system of the postgre cluster used by openerp configured
Added after reading about error-message-related time-out issues:
- SSH is blazing fast
-> Please indicate what further useful information I could provide (and if it's server side - e.g. logs, etc. where to find them according to convention)
I've encountered a similar situation for the first time. I installed a module after which the screen when blank. When I re-point a browser to the server, I see a blank page. The source is
<!DOCTYPE html> <html style="height: 100%"> <head> <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"/> <meta http-equiv="content-type" content="text/html; charset=utf-8" /> <title>OpenERP</title> <link rel="shortcut icon" href="/web/static/src/img/favicon.ico" type="image/x-icon"/> <link rel="stylesheet" href="/web/static/src/css/full.css" />
Additional info: The adress link changes correctly, same as the original poster. http://[IP-ADDRESS]:8069/?db=[DB-NAME] Also, FYI, the module was "product_bundle".
I'd like to know what to do in this situation. Kill a process? Reboot the computer?
If there's no sysadmin to restart the server then would some kind of "watch dog" program be a good idea"? A daemon that constantly monitors OpenERP and restarts it if it times out.
What about scheduler tasks? I have such tasks that takes too much cpu time.