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 11 Jan 2024 at 4:24 PM +0800, 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
> >

Reply via email to