sql integrity check show fails with missing index in vifmgr
Applies to
- ONTAP 9
- ANDU
Issue
Unable to run the validate during an ONTAP upgrade
RDB Replica Health Check
Error Error: Replicated database is malformed on node "node 1" in process "vifmgr". Action: Contact technicalsupport for assistance.Cluster::*> debug rdb sql integrity check show
Node Process Integrity
----------------- -------- -----------------
op3sacl01 bcomd ok
crs ok
mgwd ok
vifmgr row 5 missing from index vs_routes_table_index
row 5 missing from index vifmgr_vs_routes_index
vldb ok
op3sacl02 bcomd ok
crs ok
mgwd ok
vifmgr row 5 missing from index vs_routes_table_index
row 5 missing from index vifmgr_vs_routes_index
vldb ok
cluster::*> debug smdb table vs_routes_table show
vsid destination gateway metric ipspaceid routeUuid uuid
---- ----------- ---------- ------ ---------- ------------------------------------ ------------------------------------
3 0.0.0.0/0 10.146.0.1 20 4294967295 3903bb6a-56a9-11ed-8ffc-d039ea910a3d 3903bb6a-56a9-11ed-8ffc-d039ea910a3d
4294967295 0.0.0.0/0 10.146.250.1 20 4294967295 ad4927f3-2867-11ed-8ffc-d039ea910a3d ad4927f3-2867-11ed-8ffc-d039ea910a3d
4294967295 10.122.51.0/24 10.146.51.1 20 4294967295 cc59d71d-4dd8-11ed-8ffc-d039ea910a3d cc59d71d-4dd8-11ed-8ffc-d039ea910a3d
4294967295 10.124.51.0/24 10.146.51.1 20 4294967295 183e750a-4dd9-11ed-8ffc-d039ea910a3d 183e750a-4dd9-11ed-8ffc-d039ea910a3d
4294967295 10.147.0.0/20 10.146.51.1 20 4294967295 04516ea7-6015-11ed-8ffc-d039ea910a3d 04516ea7-6015-11ed-8ffc-d039ea910a3d
Error: show failed: Loop detected in next() for table vs_routes_table. Next on "4294967295 10.147.0.0/20 10.146.51.1" returned "4294967295 10.147.0.0/23
10.146.51.1".
5 entries were displayed.
