Hi Bryan, If 'taken' / other columns are NULL, you should see different error. Can you confirm if it is still the same error for that physical network? What's the cloudstack version you are using?
Regards, Suresh On Thu, Jan 11, 2024 at 2:13 PM Bryan Tiang <[email protected]> wrote: > Hi Suresh, > > We set it Null and got the same error: > > i. Updated 'taken' to NULL - same error > ii. Updated the other columns to NULL - same error > iii. Restarted management service and retry - same error > > Did we do something wrong? > <> > > Regards, > Bryan On Thu, Jan 11, 2024 at 1:53 PM Suresh Kumar Anaparti < [email protected]> wrote: > Hi Bryan, > > If there are no network / nics for the vlan, you can update 'taken' to > NULL for that vlan in the op_dc_vnet_alloc table. > > Check network / nics usage with the below queries before update. > SELECT * FROM cloud.networks WHERE broadcast_uri LIKE '%<vlan id>%'; > SELECT * FROM cloud.nics where broadcast_uri LIKE '%<vlan id>%'; > > Regards, > Suresh > > On Thu, Jan 11, 2024 at 1:25 PM Bryan Tiang <[email protected]> > wrote: > >> Hi Suresh, >> >> Thank you! In this case, should we clear the data directly? >> >> Clear or amend to something else? >> >> Regards, >> Bryan >> On 11 Jan 2024 at 3:50 PM +0800, Suresh Kumar Anaparti < >> [email protected]>, wrote: >> > Hi Bryan, >> > >> > It seems there are still some vlans allocated. You can manually confirm >> from the db table 'op_dc_vnet_alloc'. >> > >> > Check with the query below. >> > SELECT vnet, taken FROM cloud.op_dc_vnet_alloc WHERE >> physical_network_id = (SELECT id FROM cloud.physical_network WHERE uuid = >> '<physical network uuid>') >> > >> > Regards, >> > Suresh >> > >> > > On Thu, Jan 11, 2024 at 11:19 AM Bryan Tiang < >> [email protected]> wrote: >> > > > Hi Guys, >> > > > >> > > > Our setup is using VXLAN For Guest Networks. >> > > > >> > > > We're trying to delete physical network but encountered this error. >> > > > >> > > > We've deleted all the instances, networks, system vms, hosts, pods >> and clusters and left with only the zone (disabled). >> > > > >> > > > Can someone please help tell us what we are missing? >> > > > >> > > > <> >> > > > <> >> > > > Regards, >> > > > Bryan >> >
