Netxms 3.x failing to reconnect to database

Started by jermudgeon, December 12, 2019, 06:00:55 PM

Previous topic - Next topic

jermudgeon

I'm running netxms 3.x with Postgresql 10 (timescaledb). Occasionally the database crashes and automatically restarts/recovers. However, netxmsd does not reconnect to the database. Are there any settings to tweak this? My understanding (reading old forum messages) is that netxms *should* reconnect, but it does not, and requires a full restart of netxmsd to reconnect to the db.

Filipp Sudanov

I've tried on my system with Postgres 10 and NetXMS 3.1.261 on Ubuntu 18.04 - the reconnect actually occurs. Can you increase debugging for DB operations, e.g. by running this from command line:
nxadm -c "debug db.* 8"
and show the log during the moment when database stops/restarts.