Skip to main content
NetApp Knowledge Base

AIQUM acquisition of cluster fails in db Update Operation due to ONTAP having stale vserver peer relationship entries

Views:
26
Visibility:
Public
Votes:
0
Category:
active-iq-unified-manager
Specialty:
om
Last Updated:

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 null
  • netapp_model.vserver_peer table 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

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.