This question has been flagged
1 Reply
7975 Views
pageblankinstabilityfreeze
Avatar
David Arnold

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)

Avatar
Discard
Gilles Lehoux

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" />

Gilles Lehoux

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

Gilles Lehoux

I'd like to know what to do in this situation. Kill a process? Reboot the computer?

Gilles Lehoux

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.

Ahmet Altinisik

What about scheduler tasks? I have such tasks that takes too much cpu time.

Avatar
Christian Eichert
Best Answer 
*there is a workaround.*

if you can access the database go to the table called **ir_module_module** its in /schemata/public/tables.
Then simply search the column **name** and if its set to **installed** set it to **uninstalled** (Do not delete the entry!)
then log out of openerp, restart openerp, log in as admin, go to **Settings** >>  **Update Modules List** and then **Settings** >> **Apply Scheduled Upgrades** 
then be pacient.
depending what modules make trouble you can set also the dependencies on  **uninstalled**
Avatar
Discard