VxRail Update hang at 46%

I think that the problem you are facing is a little bit out of scope of community.

But, if i were you, I would check which VM is vm-15, and check VxRail DB (system.system_vm table) , and then compare moref_id with actual moid of VxRail from MOB of vCenter.

Have you ever restored VxRail Manager or vCenter server from backup? this kind of event changes moid of the VM and can cause moid mismatch.

Hello Naoyuki

A mismatch from vxrail database which said about vm-15 under moref_id and uuid

I think the vm-15 is belonging to another vm "vm-3012 VMware vRealize Log Insight”, because I compared the log from vCenter by RVTools and found the mismatch

It could be an old vm-15 from v.4.7

Can I make clone of VMware vRealize Log Insight and delete it or change uuid and moref id?

Could you please tell me how to solve this problem? 

No, I did not restore VxRail Manager or vCenter server from backup

Thanks 

How to connect to VxRail Manager Database on v.7.x.xxx

Open putty and connect to Vxrail Manager --> login with mystic

su

root account

Login

psql -U postgres vxrail

Connect to database

\c vxrail

you are now connected to database "vxrail" as user "postgres"

select * from system.system_vm;

Are you saying that vm-15 is vRealize Log Insight in VxRail DB, but its actual moid is vm-3012?

If yes, i'm not sure why LogInsight VM affects upgrade negatively because it is not managed by VxRail LCM.

> Can I make clone of VMware vRealize Log Insight and delete it or change uuid and moref id?

I'm not sure where you are going to, but uuid and moref id is created when the VM registered.

so you cannot modify them.

Instead, it's not impossible to modify VxRail DB so that uuid and morefid match to actual ones.

But editing DB manually may causes severe impact to the system.

you should be most carefully and if possible, you should open support ticket.

Thanks again

Yes, I created a support ticket about 2 weeks ago and the problem is not solved yet

Hello

Here is the instruction to fix the mismatch vm between VxRail Database and vCenter

1) VxRail Database

select * from system_vm;

You will see id, uuid, server_type and moref_id

2)

Download and Run RVTools (https://www.robware.net/rvtools/) on a PC and type in your vCenter IP

You will see a lot of information.....vm-? and uuid

Compare the logs and if you see a mismatch vm

You have to update vm-? on VxRail Database

update system vm set moref id = 'vm-mismatch' where id = 'id of vm from VxRail database';

Test VxRail update pre-check again. It worked

I did this with Dell-support

Thank you for sharing.
it would be so helpful for everyone involved in VxRail.

One thing to say, I recommend to take a snapshot of VxRail Manager prior to performing any DB modification.
It will keep you in safe side.

This just helped me get my upgrade issue solved. Thanks!

I ran into the same problem but going from 7.0.350 to 7.0.400 had to modify the script a little here.

Error:

Failed to upload bundle: VXRAIL_COMPOSITE-7.0.400-27701512_for_7.0x.zip: Failure occurred in executing the checker: Virtual machine duplicated verification.. Haven`t found any config record of vm vm-18 from VM DO..Please refer to the KB488889 article

update system.system_vm set moref id = 'vm-mismatch' where id = 'id of vm from VxRail database';

vm-mismatch: = new vm-ID from the rv tools

'id of vm from VxRail database:    In my case was  Vm-18  so i entered   "2"

vxrail=# update system.system_vm set moref_id ='vm-186965' where id='2';