@olivierlambert
The /var/lib/xcp/state.db is basically a single line of xml with a half-million characters.
The old egrep or sed or vi searching did not seem to narrow things down likely they normally do. Used xmllint to put the db in a pretty format with line breaks and indentation. Then vi to edit. Of course, as soon as i start xapi, those changes are lost. I assume there must be a massive speedup in lookups when all on a single line.
[23:59 xen-B xcp]# pushd /var/lib/xcp/
[23:59 xen-B xcp]# systemctl stop xapi
[23:59 xen-B xcp]# cp state.db ./state-YYYYMMDD-HHMM.db
[23:59 xen-B xcp]# egrep '(192.168.2.141)' ./state.db | wc
1 11757 454034
[23:59 xen-B xcp]# echo " :( 1 line with over 11,000 words :("
[23:59 xen-B xcp]# xmllint --format state.db >> state.xmllint--pretty.db
[23:59 xen-B xcp]# egrep '(192.168.2.141)' ./state.db | wc
10 193 13526
[23:59 xen-B xcp]# echo "i can deal with 193 words :) and edited with vi"
[23:59 xen-B xcp]# mv state.xmllint--pretty.db ./state.db
[23:59 xen-B xcp]# systemctl start xapi
xe console-list indicates the the proper IP addresses:
[23:59 xen-B xcp]# xe console-list vm-name-label=Control\ domain\ on\ host:\ xen-B
uuid ( RO) : d5039d1a-64ad-c8a9-a309-51e568ba2926
vm-uuid ( RO): 1593da28-8e85-4252-878e-778eb414c549
vm-name-label ( RO): Control domain on host: xen-B
protocol ( RO): VT100
location ( RO): https://192.168.10.192/console?ref=OpaqueRef:7be93ca1-76cf-4649-8276-74891eac0a06
uuid ( RO) : 7bcf725e-ae83-cf6f-7997-7dd63469929f
vm-uuid ( RO): 1593da28-8e85-4252-878e-778eb414c549
vm-name-label ( RO): Control domain on host: xen-B
protocol ( RO): RFB
location ( RO): https://192.168.10.192/console?ref=OpaqueRef:1361b935-2d25-4929-9b27-4b0483cbb0f7
[00:00 xen-B xcp]# ip a show dev xenbr0 | egrep inet
inet 192.168.10.192/16 brd 192.168.255.255 scope global dynamic xenbr0
But there is still a blank host console in both XOA and xcp center. Suppose those OpaqueRefs have to be fixed up as well. EFI starting crashing on this r720, so having many other severe issues to deal with.