Hi Suresh, So sorry for this. But we ran the query and this was the result.
Could it be something else? Regards, Bryan On 11 Jan 2024 at 8:39 PM +0800, Suresh Kumar Anaparti <sureshkumar.anapa...@gmail.com>, wrote: > Hi Bryan, > > From the code, the error is due to some allocated vlans found through the > below query. If the result is empty, that error doesn't appear. > > SELECT * FROM cloud.op_dc_vnet_alloc WHERE physical_network_id = <physical > network id> AND taken IS NOT NULL > > Regards, > Suresh > > On Thu, Jan 11, 2024 at 3:57 PM Bryan Tiang <bryantian...@hotmail.com> > wrote: > > > Hi Suresh, > > > > Sorry, its Version 4.18.1 > > > > Yes its the same error message as before: > > > > Delete physical network: (Physical Network 1) The Physical Network is not > > deletable because there are allocated vnets for this physical network > > > > Version: 4.18.1 > > Hypervisor: Linux Ubuntu > > Storage: Linbit > > > > Regards, > > Bryan > > On 11 Jan 2024 at 5:46 PM +0800, Suresh Kumar Anaparti < > > sureshkumar.anapa...@gmail.com>, wrote: > > > 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 <bryantian...@hotmail.com> > > > 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 < > > > sureshkumar.anapa...@gmail.com> 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 <bryantian...@hotmail.com> > > > > 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 < > > > > > sureshkumar.anapa...@gmail.com>, 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 < > > > > > bryantian...@hotmail.com> 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 > > > > > > > > > > >
