Comment 47 for bug 1519527

I'm on PTO today and tomorrow, and sprint next week. I do have some hours
to kill at the airport, so I might be able to get you this info before next
week.
On Dec 3, 2015 04:05, "Mike Pontillo" <email address hidden> wrote:

> Also (sorry) there is a typo in the SQL commands above. That should be:
>
> sudo maas-region-admin dbshell
> delete from maasserver_staticipaddress ip
> where ip.id in (
> select ip.id from maasserver_staticipaddress ip
> left outer join maasserver_interface_ip_addresses iip
> on ip.id = iip.staticipaddress_id
> where iip.id is null and ip.alloc_type=1
> );
>
> --
> You received this bug notification because you are a member of
> Landscape, which is subscribed to the bug report.
> https://bugs.launchpad.net/bugs/1519527
>
> Title:
> juju 1.25.1: lxc units all have the same IP address - changed to
> claim_sticky_ip_address
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/maas/+bug/1519527/+subscriptions
>