NetXMS Support Forum

English Support => General Support => Topic started by: SkyRanger on September 18, 2020, 04:05:13 AM

Title: Cant unlock database after server crushed
Post by: SkyRanger on September 18, 2020, 04:05:13 AM
I run NETXMS inside Hyper-V and forgot to set for virtual machine dyn memory limit when i set it up. So eventually VM just eats all free server RAM and i forced to stop it.

Now i cant run NETXMS server it says:

Database is locked

I run server packages upgrade

When i try to upgrade database

NetXMS Database Manager Version 3.5.90 Build 3.5-90-g215397d8e7 (UNICODE)

Upgrading database...
Database is locked

When i try to unlock it:

nxdbmgr unlock
NetXMS Database Manager Version 3.5.90 Build 3.5-90-g215397d8e7 (UNICODE)

Database is locked by server 192.168.x.x [xxxxx.xxxxxxx.ru Linux Release 4.19.0-8-amd64]
Do you wish to force database unlock? (Yes/No) Yes

Ind it just stuck and nothing happens, when i kill it after 30 minutes and tru to upgrade DB still locked. Is there a way to unlock it other way?
Title: Re: Cant unlock database after server crushed
Post by: SkyRanger on September 18, 2020, 04:17:16 AM
It strange reboot helped:)
Title: Re: Cant unlock database after server crushed
Post by: Filipp Sudanov on September 18, 2020, 12:34:12 PM
Could be something on the database side. What database do you use?