NetXMS Support Forum

English Support => General Support => Topic started by: vmgracia on September 02, 2013, 09:36:23 PM

Title: netxms hangs every 7-8 days
Post by: vmgracia on September 02, 2013, 09:36:23 PM
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?
Title: Re: netxms hangs every 7-8 days
Post by: Victor Kirhenshtein on September 03, 2013, 10:02:55 AM
Hi!

Please enable crash dumps on the server (see this page for instructions: http://wiki.netxms.org/wiki/UM::Troubleshooting (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
Title: Re: netxms hangs every 7-8 days
Post by: vmgracia on September 03, 2013, 01:52:12 PM
thanks a lot for your support


i do......
Title: Re: netxms hangs every 7-8 days
Post by: vmgracia on September 08, 2013, 12:51:04 PM
Hi Victor


here is the dump as you request...
Title: Re: netxms hangs every 7-8 days
Post by: Victor Kirhenshtein on September 10, 2013, 09:35:24 AM
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
Title: Re: netxms hangs every 7-8 days
Post by: vmgracia on September 10, 2013, 12:08:52 PM
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
Title: Re: netxms hangs every 7-8 days
Post by: Victor Kirhenshtein on September 10, 2013, 01:08:43 PM
Sorry, I forgot that it was intentional crash :)
Title: Re: netxms hangs every 7-8 days
Post by: Victor Kirhenshtein on September 10, 2013, 06:27:07 PM
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
Title: Re: netxms hangs every 7-8 days
Post by: vmgracia on September 10, 2013, 08:59:46 PM
Hi Victor

Thanks very much for this excelent work.

1. sqllite
2. EnableMultipleDBConnections is set to 1
Title: Re: netxms hangs every 7-8 days
Post by: Victor Kirhenshtein on September 11, 2013, 08:50:17 AM
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
Title: Re: netxms hangs every 7-8 days
Post by: vmgracia on September 11, 2013, 02:26:08 PM
I'm thinking to migrate to MySql, does this improve the situation?

Regards

V.G.
Title: Re: netxms hangs every 7-8 days
Post by: Victor Kirhenshtein on September 11, 2013, 07:24:51 PM
Deadlock is already fixed, so if you don't have performance issues with sqlite, you can keep running server on it.

Best regards,
Victor
Title: Re: netxms hangs every 7-8 days
Post by: Sympology on September 16, 2013, 11:00:21 AM
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!