Cant unlock database after server crushed

Started by SkyRanger, September 18, 2020, 04:05:13 AM

Previous topic - Next topic

SkyRanger

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?

SkyRanger


Filipp Sudanov

Could be something on the database side. What database do you use?