database writer possibly hanging

[mgthump]

I've been having a problem where my netxms service seems to be running but stops recording data after an hour or two.    I've tried turning off discovery, and playing with the collector values, i haven't had any success in resolving this. 

here is what my queues look like in the morning after its freezes up:

netxmsd: show queues
Data collector                  : 0
DCI cache loader                : 0
Template updates                : 0
Database writer                    : 1146
Database writer (IData)          : 4742949
Database writer (raw DCI values) : 34542
Event processor                    : 799
Event log writer                    : 656
Poller                                    : 1181
Node discovery poller            : 0
Syslog processing                : 0
Syslog writer                        : 0
Scheduler                            : 0

when it's working normally, my raw DCI values will jump to 10,000 or so, but quickly go back to zero, Idata will do the same even log writer seems to fluctuate up to 1,000 sometimes and very slowly comes back. usually, I see less than 100 for the log writer.

where should I check next?

Thanks!

[victor]

Hi,

you probably should check database health and performance first - it could be that for some reason database is unable to handle INSERTs for collected data. Also, check that database connection pool is not exhausted (you can check log file for DB connection pool related errors as well as check active pool connections with show dbcp command in server debug console). You may also try to increase value of server configuration parameter DBWriter.DataQueues.

Best regards,
Victor