Changes are not saved after reboot or restart service

[d-ray]

Hi,

I'm running 1.2.10 for some time.. and have found that my changes are not saved.
When I create for example a new template the template is not saved after reboot. Also when I create a new parameter on a template or direct on node.
Also when I crate a new dashboard.

I don't know how long it is. But I just upgraded to version 1.2.11 and it is still the same.
How can I debug or find what is going wrong.

Running on ubunto 12.4 > pgsql

Regards
Denis

[d-ray]

I did some more debugging

When I start the netxms manualy with netxmsd -D 3 -c /etc/netxmsd.conf

Do some changes. Create new template... add some Data collection parameters.

then I press down in the console.
(sometimes its takes a while until I get the command prompt back)

It looks the data is stored when I restart everything.

When I use the /etc/init.d/netxmsd start and /etc/init.d/netxmsd stop nothing is saved.

Is it true that data only will be saved when you stop the netxmsd service?

[alk]

It should save in both cases. All data is saved into DB by separate thread (so server can collect and process data) — check value of "Database writer's ..." DCIs on the server node, if it's too high — your DB can' handle load.

[d-ray]

Hi,

Thanks for your help.

Config poller last min max:210.58 avg:148.25
status poller last min max:70 avg 14.55
avg time to queue dci for polling last min max:0
DB writer's request queue (other queries) last min max:0
DB writer's request queue (DCI data) last min max:0
DB writer's request queue for last min max:0
Data Collection poller's request queue for last min max:0

[alk]

Seems fine. Make sure you have "LogFailedSQLQueries=yes" in netxmsd.conf (it's enabled by default) and check log file for failed queries.