search cancel

NAS 9.31 down, restarting and sqlite3_exec errors are thrown

book

Article ID: 215342

calendar_today

Updated On:

Products

DX Unified Infrastructure Management (Nimsoft / UIM) Unified Infrastructure Management for Mainframe CA Unified Infrastructure Management SaaS (Nimsoft / UIM)

Issue/Introduction

nas v9.31 is not working properly and is restarting over and over again as per the nas.log.

Errors include:

5 nas: SqliteExecute: sqlite3_exec failed with error:5
5 nas: SqliteExecute: sqlite3_exec failed with error:5
5 nas: SqliteExecute: sqlite3_exec failed with error:5
etc
etc

Scripts interrupted and failed to execute:

0 nas: Script 'examples\restart_all_robot_mandatory' failed, error: script interrupted.
0 nas: (AO) failed to execute script 'examples\MQ_Cluster_verify-Activo-Pasivo', error: script interrupted.
0 nas: (AO) failed to execute script 'examples\failed_start_probe', error: script interrupted.
...
etc
etc

Then client session errors:

1 nas: nimSessionWaitMsg: got error on client session: nims=000000A920B52060 fd=1672 10054
0 nas: SpoolerConnector - post 'alarm_update' failed 1(error)
1 nas: nimSessionWaitMsg: got error on client session: nims=000000A920B59290 fd=352 10054
nas: nimSession - failed to connect session to 10.xx.xx.xxx:48001, error code 10061
0 nas: nimSession - failed to connect session to 10.xx.xx.xxx:48001, error code 10061
0 nas: SpoolerConnector - failed to create session, 1(error)

and

0 nas: QosBridge - post 'qos_alarm_update' failed 32768(unknown error)
etc
etc

Cause

- changes in nas

Environment

Release : 20.3

Component : UIM NAS

nas v9.31

Resolution

Redeployed the nas probe v9.31 and it recovered and no longer threw the same errors on execution or showed multiple script failures.

Also upgraded to nas v9.32 HF1 and the nas remained stable.

Additional Information

1. nas 9.30 (UIM 20.1 and below) -> Uses old expression matching
2. nas 9.31 and nas 9.32 (UIM 20.x) -> Uses regular expression matching
3. nas 9.32 HF1 (can be applied for UIM 20.x or higher) -> default behaviour uses previous/old expression matching as well as new. Can change to regular expression matching using config parameter.
UseRegexOnly = no (default, both string pattern/regex matching)
UseRegexOnly = yes (regex matching only)