Dear All,
The odoo 8 server under debian gets crashed from time to time, bellow Odoo and Postrgresql error message:
Odoo:
error_proto: -ERR failed: Could not determine server
2018-08-03 08:55:51,463 32023 ERROR ? openerp.addons.bus.bus: Bus.loop error, sleep and retry
Traceback (most recent call last):
File "/opt/odoo/addons/bus/bus.py", line 136, in run
self.loop()
File "/opt/odoo/addons/bus/bus.py", line 131, in loop
e.set()
File "/opt/odoo/openerp/sql_db.py", line 399, in __exit__
self.close()
File "/opt/odoo/openerp/sql_db.py", line 171, in wrapper
return f(self, *args, **kwargs)
File "/opt/odoo/openerp/sql_db.py", line 311, in close
return self._close(False)
File "/opt/odoo/openerp/sql_db.py", line 341, in _close
self._cnx.rollback()
InterfaceError: connection already closed
Postgres:
2018-08-03 08:55:51 UTC [16598-77] odoo@xxx FATAL: terminating connection due to administrator command
2018-08-03 08:55:51 UTC [365-1] LOG: shutting down
2018-08-03 08:55:51 UTC [365-2] LOG: database system is shut down
2018-08-03 08:55:59 UTC [410-1] LOG: database system was shut down at 2018-08-03 08:55:51 UTC
2018-08-03 08:55:59 UTC [410-2] LOG: MultiXact member wraparound protections are now enabled
2018-08-03 08:55:59 UTC [401-1] LOG: database system is ready to accept connections
2018-08-03 08:55:59 UTC [414-1] LOG: autovacuum launcher started
2018-08-03 08:56:00 UTC [429-1] [unknown]@[unknown] LOG: incomplete startup packet
2018-08-03 08:59:04 UTC [547-1] odoo@xxx ERROR: could not obtain lock on row in relation "ir_cron"
2018-08-03 08:59:04 UTC [547-2] odoo@xxx STATEMENT: SELECT *
FROM ir_cron
WHERE numbercall != 0
AND active
AND nextcall <= (now() at time zone 'UTC')
AND id=30
FOR UPDATE NOWAIT
2018-08-03 09:00:05 UTC [547-3] odoo@xxx ERROR: could not obtain lock on row in relation "ir_cron"
Anny help please
Thank you
