Skip to main content
NetApp Knowledge Base

VLDB offline on the node due to huge WAL file size on the partner node

Views:
1,504
Visibility:
Public
Votes:
0
Category:
ontap-9
Specialty:
core
Last Updated:

Applies to

ONTAP 9

Issue

  • Node goes down due to a panic and boots up.
  • After the boot, the VLDB is offline on the node:

::> set advanced
::*> cluster ring show
Node      UnitName Epoch    DB Epoch DB Trnxs Master    Online
--------- -------- -------- -------- -------- --------- ---------
Node-01     mgmt    35       35       130      Node-01     master
Node-01     vldb    21       21       932755   Node-01     master
Node-01     vifmgr  37       37       79       Node-01     master
Node-01     bcomd   34       34       3        Node-01     master
Node-01     crs     35       35       1        Node-01     master
Node-02     mgmt    35       35       130      Node-01     secondary
Node-02     vldb    0        21       932644   -           offline
Node-02     vifmgr  37       37       79       Node-01     secondary
Node-02     bcomd   34       34       3        Node-01     secondary
Node-02     crs     35       35       1        Node-01     secondary
10 entries were displayed.

  • Partner node VLDB Data Grows to Gigabyte Level.

::> set diag
::*> systemshell * "ls -lh /mroot/etc/cluster_config/rdb/*/_sql/rdb.db-wal"

Node: Node-01
-rw-r--r--  1 root  wheel   676K Nov 10 13:36 /mroot/etc/cluster_config/rdb/Bcom/_sql/rdb.db-wal
-rw-r--r--  1 root  wheel   255K Nov 10 13:36 /mroot/etc/cluster_config/rdb/Crs/_sql/rdb.db-wal
-rw-r--r--  1 root  wheel   2.1M Nov 10 13:38 /mroot/etc/cluster_config/rdb/Management/_sql/rdb.db-wal
-rw-r--r--  1 root  wheel    19G Nov 10 13:39 /mroot/etc/cluster_config/rdb/VLDB/_sql/rdb.db-wal
-rw-r--r--  1 root  wheel   2.1M Nov 10 13:38 /mroot/etc/cluster_config/rdb/VifMgr/_sql/rdb.db-wal

Node: Node-02
-rw-r--r--  1 root  wheel    10K Nov 10 12:48 /mroot/etc/cluster_config/rdb/Bcom/_sql/rdb.db-wal
-rw-r--r--  1 root  wheel   4.1K Nov 10 12:48 /mroot/etc/cluster_config/rdb/Crs/_sql/rdb.db-wal
-rw-r--r--  1 root  wheel   427K Nov 10 13:15 /mroot/etc/cluster_config/rdb/Management/_sql/rdb.db-wal
-rw-r--r--  1 root  wheel   6.1K Nov 10 13:11 /mroot/etc/cluster_config/rdb/VLDB/_sql/rdb.db-wal
-rw-r--r--  1 root  wheel   641K Nov 10 13:15 /mroot/etc/cluster_config/rdb/VifMgr/_sql/rdb.db-wal

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.