AIQUM acquisition of cluster fails in db Update Operation due to ONTAP having stale vserver peer relationship entries
Applies to
- ActiveIQ Unified Manager(AIQUM) 9.x
- Any OS version
- ONTAP 9.x
Issue
- Acquisition of cluster fails in AIQUM
- Error in
au.log:
ERROR [common-pool-471] c.o.s.a.f.d.BaseDataSource (DataSourceErrorException.java:246) - <cluster name>[Internal error] - General Message ([Device name General Device]: Cannot update server (com.netapp.oci.server.UpdateTaskException [127-70-34-1674] Failed execute task: class com.netapp.oci.platform.originator.OriginatorUpdateTask com.netapp.oci.server.UpdateTaskException [127-70-34-1674] Failed to run NewOriginatorUpdateTask, origin:3 originatorName:edinasc02.ad.cirrus.com com.netapp.oci.platform.common.table.TableException: Failed to execUpdate: com.netapp.oci.platform.originator.db.UpdateOperation@657a347b after 10 retries))server_mega.log:
ERROR [default task-244] c.n.o.p.o.db (AbstractBatchOperation.java:120) - retry 5 for originId 3 for sql UPDATE netapp_model.vserver_peer SET originid=?,resourcekey=?,clusterid=?,vserverid=?,peervserveruuid=?,peerclustername=?,peervservername=?,peerstate=?,peerstateraw=?,applications=?,checksum=?,changeDetailChecksum=?,updatetime=? WHERE objid=? with error (conn=1185) Column 'vServerId' cannot be nullnetapp_model.vserver_peertable shows non-existing peer relationship entries with NULL peerVServerID as in:
mysql> SELECT objid, originid, clusterid, vServerId, peervserveruuid, peerclustername, peervservername, peerstate, peerVServerId, peerClusterId FROM netapp_model.vserver_peer WHERE peervservername LIKE ’testdr';+---------+----------+-----------+-----------+--------------------------------------+-----------------+-----------------+-----------+---------------+---------------+| objid | originid | clusterid | vServerId | peervserveruuid | peerclustername | peervservername | peerstate | peerVServerId | peerClusterId |+---------+----------+-----------+-----------+--------------------------------------+-----------------+-----------------+-----------+---------------+---------------+| 5637973 | 1 | 1 | 1234 | dcb4d091-a8f1-11f0-aa08-d039ead0cf90 | <cluster> | testdr | PEERED | NULL | NULL | +---------+----------+-----------+-----------+--------------------------------------+-----------------+-----------------+-----------+---------------+---------------+1 row in set (0.00 sec)- Source SVM is removed but the peer relationship removal fails on the destination cluster with
local vserver doesn't exist
