Re: Private IP allocation

2012-06-22 Thread Diego Spinola Castro
Worked! Tks Alena. 2012/6/22 Alena Prokharchyk > You need to mark them as free: > > > Update op_dc_address_alloc set nic_id=null, reservation_id=null, > taken=null where id in (list of ids of orphaned nics) > > > > -Alena. > > On 6/22/12 9:58 AM, "Diego Spinola Castro" > wrote: > > >Alena, i di

Re: Private IP allocation

2012-06-22 Thread Alena Prokharchyk
You need to mark them as free: Update op_dc_address_alloc set nic_id=null, reservation_id=null, taken=null where id in (list of ids of orphaned nics) -Alena. On 6/22/12 9:58 AM, "Diego Spinola Castro" wrote: >Alena, i did what you said. >Now i have a few orphan ips, what should i do with th

Re: Private IP allocation

2012-06-22 Thread Diego Spinola Castro
Alena, i did what you said. Now i have a few orphan ips, what should i do with they? mysql> SELECT * FROM op_dc_ip_address_alloc a WHERE a.nic_id IS NOT NULL AND (SELECT COUNT(*) FROM op_dc_ip_address_alloc b WHERE a.nic_id = b.nic_id)>1 order by nic_id; +-+---++---

Re: Private IP allocation

2012-06-18 Thread Alena Prokharchyk
On 6/18/12 6:36 AM, "Diego Spinola Castro" wrote: >Hi, i have a vsphere and xenserver cluster in same pod with cs 2.2.13. > >Looking in resources dashboard i figured out that there a lot of private >ips allocated and it is incompatible with systemvm's number. > >i don't know what caused it but op