netxms hangs every 7-8 days

[vmgracia]

i have a netxms version 1.2.8 running on dedicated windows server 2003.
works very fine but every 7 or 8 days the core process hangs and stops any netxms activities, also stops the nxmc console response.

no error logged on the log file.

how can i start the troubleshooting?

[victor]

Hi!

Please enable crash dumps on the server (see this page for instructions: http://wiki.netxms.org/wiki/UM::Troubleshooting).
When server hangs next time, try to connect to it with nxadm tool and force server crash by entering command raise access. Then send resulting dump to me for analysis.

Best regards,
Victor

[vmgracia]

thanks a lot for your support

i do......

[vmgracia]

Hi Victor

here is the dump as you request...

---

NetxmsLog.zip

[victor]

Hi!

Are you using nxadm either manually or from some scripts? According to crash dump server crashed hen processing some command from nxadm.

Best regards,
Victor

[vmgracia]

Hi Victor

I did as you suggested above.

Once the server stopped responding to any nxmc (locally, W7 and android) i used manually the nxadm tool and forced server crash by entering command raise access

[victor]

Sorry, I forgot that it was intentional crash

[victor]

I probably found the deadlock. I'll fix it in upcoming 1.2.9 release. I have some additional questions though:

1. what database you are using as backend?
2. do you have option EnableMultipleDBConnections set to 1?

Best regards,
Victor

[vmgracia]

Hi Victor

Thanks very much for this excelent work.

1. sqllite
2. EnableMultipleDBConnections is set to 1

[victor]

Internal state was a bit strange at first glance, this is why I was asking. But SQLite backend explains it. SQLite driver is different from all other drivers and having multiple db connections has no effect on it because internally all queries done from single thread anyway. Because of that systems with sqlite backend had much more chance to encounter deadlock you encountered.

Best regards,
Victor

[vmgracia]

I'm thinking to migrate to MySql, does this improve the situation?

Regards

V.G.

[victor]

Deadlock is already fixed, so if you don't have performance issues with sqlite, you can keep running server on it.

Best regards,
Victor

[Sympology]

Hi just found this thread, I'm also having issues with this version stopping about once a week. I'm running MySQL as backend, but I'll wait to see if the next version fixes it and give you feedback then.
Keep up the good work, you're doing a great job!