Odoo Help

Welcome!

This community 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.

1

OpenERP-Server Freeze/Instability - root cause/solution?

By
David Arnold
on 11/10/13, 5:41 PM 2,560 views

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

Gilles Lehoux
on 1/31/14, 6:31 PM

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
on 1/31/14, 6:34 PM

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

Gilles Lehoux
on 1/31/14, 6:34 PM

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.

Gilles Lehoux
on 1/31/14, 7:07 PM

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

Altınkaya Elektronik Cihaz Kutuları imalat Ticaret ltd sti, Ahmet Altinisik
on 2/1/14, 5:08 AM
0
Christian Eichert
On 2/2/14, 5:44 PM
*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**

Your Answer

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 community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

2 follower(s)

Stats

Asked: 11/10/13, 5:41 PM
Seen: 2560 times
Last updated: 3/16/15, 8:10 AM