nas 23.4.4 nas crashed - queue not connected - nas: SqliteExecute: sqlite3_exec

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

Nas probe version 23.4.3.2 / 23.4.4 crashed and cannot start properly, alarm queue is growing. 

 

Errors:

 

Dec  9 12:54:22:044 [263528] 3 nas: dbBeginTransaction dbsRun, AGAIN - rc:7
Dec  9 12:54:22:567 [263528] 5 nas: SqliteExecute: sqlite3_exec with retry:1
Dec  9 12:54:23:182 [263528] 5 nas: SqliteExecute: sqlite3_exec with retry:2
Dec  9 12:54:23:906 [263528] 5 nas: SqliteExecute: sqlite3_exec with retry:3
Dec  9 12:54:24:521 [263528] 5 nas: SqliteExecute: sqlite3_exec with retry:4
Dec  9 12:54:24:724 [76232] 5 nas: SqliteExecuteCallback: sqlite3_finalize returned:0
Dec  9 12:54:24:724 [76232] 5 nas: SqliteExecuteCallback: sqlite3_finalize returned:0
Dec  9 12:54:25:136 [263528] 5 nas: SqliteExecute: sqlite3_exec with retry:5

 

Deleting database files does not help

Environment

DX UIM 23.4.3/4

Cause

non-reproducible issue

Resolution

In the rare case these errors in the nas are not matched with other errors or known scenario try the following steps: 

 

1) Redeploy the same version 23.4.4 and cold start the nas (stop nas and alarm_enrichment - start both again)

 

if it doesn't work

 

2) Backup the nas.cfg (and nas folder)

3) Delete the nas completely (remove nas folder - this will remove all current open and historic alarms) 

4) Deploy 23.4.4.1 (available on support.nimsoft.com/ )

5) restore the nas.cfg

 

If the issue persists, open a support case.