Skip to main content
NetApp Knowledge Base

Lost the AQUIM connection to a NetApp node with SQLite errors

Views:
35
Visibility:
Public
Votes:
0
Category:
ontap-9
Specialty:
CORE
Last Updated:

 

Applies to

  • ONTAP 9
  • Active IQ Unified Manager

Issue

  • System Manager is getting hung while loading and goes into unresponsive state.
  • From logs, we get below messages:
AUDIT-MLOG-TXT.GZ
Wed Jan 01 2023 00:00:00 +02:00 [kern_audit:info:11111] 1234e8000001f000 :: Cluster1:ontapi :: 192.168.0.1:11111 :: Cluster1:admin :: POST /servlets/netapp.servlets.admin.XMLrequest_filer HTTP/1.1 :: Error: 502 Proxy Error
 
APACHE-ERROR.GZ
[Wed Jan 01 10:00:00.111111 2023 +0000] [proxy:error] [pid 95609:tid 34402477568] [client 192.168.0.1:54858] AH00898: Error reading from remote server returned by //servlets/netapp.servlets.admin.XMLrequest_filer
[Wed Jan 01 10:00:00.111112 2023 +0000] [proxy_  http:error] [pid 95609:tid 34402477568] (20014)Internal error (specific information not available): [client 192.168.0.1:54858] AH01102: error reading status line from remote server 127.0.0.1:936
 
MGWD.GZ
Wed Jan 01 10:00:00 +02:00 [kern_mgwd:info:3153] A [src/rdb/sql_local_unit.cc 806 (0x823d02000)]: sqlite_logger: SQLite Error: (1) statement aborts at 4: [ATTACH DATABASE '/mroot/etc/cluster_config/rdb/VLDB/_sql/rdb.db' AS vldb;] database vldb is already in use
Wed Jan 01 10:00:00 +02:00 [kern_mgwd:info:3153] 0x823d02000: 8803eb00002a49c4: ERR: SQL_CONTEXT: _execute_setup_stmts:src/sql_context.cc:1056 _execute_setup_stmts: failed to exec statement 'ATTACH DATABASE '/mroot/etc/cluster_config/rdb/VLDB/_sql/rdb.db' AS vldb;' for on demand connection 0x834cabd08: SQL logic error database vldb is already in use
Wed Jan 01 10:00:00 +02:00 [kern_mgwd:info:3153] sqlite exec message: database vldb is already in use
Wed Jan 01 10:00:00 +02:00 [kern_mgwd:info:3153] A [src/rdb/sql_local_unit.cc 806 (0x821a39c00)]: sqlite_logger: SQLite Error: (1) statement aborts at 4: [ATTACH DATABASE '/mroot/etc/cluster_config/rdb/Bcom/_sql/rdb.db' AS bcomd;] database bcomd is already in use
Wed Jan 01 10:00:00 +02:00 [kern_mgwd:info:3153] 0x821a39c00: 8503e80002080bc0: ERR: SQL_CONTEXT: _execute_setup_stmts:src/sql_context.cc:1056 _execute_setup_stmts: failed to exec statement 'ATTACH DATABASE '/mroot/etc/cluster_config/rdb/Bcom/_sql/rdb.db' AS bcomd;' for on demand connection 0x834cabd08: SQL logic error database bcomd is already in use
Wed Jan 01 10:00:00 +02:00 [kern_mgwd:info:3153] sqlite exec message: database bcomd is already in use

Sign in to view the entire content of this KB article.

New to NetApp?

Learn more about our award-winning Support

NetApp provides no representations or warranties regarding the accuracy or reliability or serviceability of any information or recommendations provided in this publication or with respect to any results that may be obtained by the use of the information or observance of any recommendations provided herein. The information in this document is distributed AS IS and the use of this information or the implementation of any recommendations or techniques herein is a customer's responsibility and depends on the customer's ability to evaluate and integrate them into the customer's operational environment. This document and the information contained herein may be used solely in connection with the NetApp products discussed in this document.

 

  • Was this article helpful?