Hi Folks,
Bit more info here, It seems that after a network restart with the clean
option, one of the router ip's is not being reserved correctly:
mysql> select id,account_id,domain_id,public_ip_address,state,allocated
from user_ip_address where public_ip_address in
('192.168.188.60','192.168.186.203');
+------+------------+-----------+-------------------+-----------+---------------------+
| id | account_id | domain_id | public_ip_address | state | allocated
|
+------+------------+-----------+-------------------+-----------+---------------------+
| 1013 | 1 | 1 | 192.168.186.203 | Allocated |
2015-06-09 11:59:48 |
| 2771 | NULL | NULL | 192.168.188.60 | Free | NULL
|
+------+------------+-----------+-------------------+-----------+---------------------+
2 rows in set (0.00 sec)
The two addresses above are the two IP's of the router's in each pod. This
is with basic networking. The second one has not been reserved correctly,
and so instances are are being assigned the same IP.
Cheers
On Wed, Jul 15, 2015 at 10:51 AM, cs user <acldstk...@gmail.com> wrote:
> Hi Folks,
>
> Been testing with 4.5.1, all looks fine. However we have just hit an issue
> where a guest has been allocated the same IP as the eth0 address of the
> router for the pod.
>
> Has anyone come across this issue before?
>
> Here is how the db looks (Apologies for the formatting)!
>
> mysql> select * from nics where ip4_address='192.168.188.60';
>
> +-------+--------------------------------------+-------------+-------------------+---------------+---------------+----------------+---------+-----------------+------------+------+--------------+-------------+---------------------------+--------------------------------------+-----------+---------------------+---------------+-------------+-------------+--------------+---------------------+---------------------+-------------+----------+--------------+-------------+
> | id | uuid | instance_id | mac_address
> | ip4_address | netmask | gateway | ip_type |
> broadcast_uri | network_id | mode | state | strategy |
> reserver_name | reservation_id |
> device_id | update_time | isolation_uri | ip6_address | default_nic
> | vm_type | created | removed | ip6_gateway |
> ip6_cidr | secondary_ip | display_nic |
>
> +-------+--------------------------------------+-------------+-------------------+---------------+---------------+----------------+---------+-----------------+------------+------+--------------+-------------+---------------------------+--------------------------------------+-----------+---------------------+---------------+-------------+-------------+--------------+---------------------+---------------------+-------------+----------+--------------+-------------+
> | 51 | 17f22eb2-5937-423e-9aeb-946e895310e4 | 5 |
> 06:41:2a:00:02:58 | 192.168.188.60 | 255.255.254.0 | 192.168.189.254 | Ip4
> | vlan://untagged | 204 | Dhcp | Deallocating | Start |
> DirectPodBasedNetworkGuru | 52b54070-d8bb-4f63-8ae5-6053d404dc7b |
> 0 | 2015-06-09 15:37:43 | NULL | NULL | 1 |
> DomainRouter | 2015-06-09 12:01:02 | 2015-06-09 14:37:43 | NULL |
> NULL | 0 | 1 |
> | 61 | 94ff4fce-557a-4035-adb4-62df44db3057 | NULL | NULL
> | 192.168.188.60 | NULL | NULL | NULL | NULL
> | 204 | NULL | Reserved | PlaceHolder | NULL
> | NULL | 0 | 2015-06-09
> 13:01:03 | NULL | NULL | 0 | DomainRouter |
> 2015-06-09 12:01:03 | NULL | NULL | NULL |
> 0 | 1 |
> | 2988 | 43be41d8-a19e-4610-a27e-720aabc4da05 | 645 |
> 06:ba:5c:00:02:58 | 192.168.188.60 | 255.255.254.0 | 192.168.189.254 | Ip4
> | vlan://untagged | 204 | Dhcp | Deallocating | Start |
> DirectPodBasedNetworkGuru | 8f442303-7a7b-4fd2-a33e-56f312f5f526 |
> 0 | 2015-07-09 14:24:40 | NULL | NULL | 1 |
> DomainRouter | 2015-07-07 07:48:33 | 2015-07-09 13:24:40 | NULL |
> NULL | 0 | 1 |
> | 5358 | 18c1caed-00a9-4d58-b698-31ff186843e6 | 1262 |
> 06:66:3a:00:02:58 | 192.168.188.60 | 255.255.254.0 | 192.168.189.254 | Ip4
> | vlan://untagged | 204 | Dhcp | Deallocating | Start |
> DirectPodBasedNetworkGuru | dcf9c27f-4bf1-4ea1-870f-075eed81d021 |
> 0 | 2015-07-07 18:58:38 | NULL | NULL | 1 | User
> | 2015-07-07 14:43:05 | 2015-07-07 17:58:38 | NULL | NULL
> | 0 | 1 |
> | 6208 | bfcd8921-1270-4ecb-b877-83ead6661d62 | 1461 |
> 06:0d:96:00:02:58 | 192.168.188.60 | 255.255.254.0 | 192.168.189.254 | Ip4
> | vlan://untagged | 204 | Dhcp | Deallocating | Start |
> DirectPodBasedNetworkGuru | 245c5451-85a4-4ed1-b302-1075dd6bb064 |
> 0 | 2015-07-10 11:46:57 | NULL | NULL | 1 |
> DomainRouter | 2015-07-09 14:30:43 | 2015-07-10 10:46:57 | NULL |
> NULL | 0 | 1 |
> | 6296 | 1622e49a-0008-4753-9b3a-deb76010aeef | 1482 |
> 06:88:1e:00:02:58 | 192.168.188.60 | 255.255.254.0 | 192.168.189.254 | Ip4
> | vlan://untagged | 204 | Dhcp | Deallocating | Start |
> DirectPodBasedNetworkGuru | ef8bcd64-083f-4ff8-bfa9-7948409d3e6d |
> 0 | 2015-07-09 16:40:34 | NULL | NULL | 1 | User
> | 2015-07-09 14:40:51 | 2015-07-09 15:40:34 | NULL | NULL
> | 0 | 1 |
> | 7163 | e82597d6-090c-4745-a3da-db7ebbf042f9 | 1716 |
> 06:c5:56:00:02:58 | 192.168.188.60 | 255.255.254.0 | 192.168.189.254 | Ip4
> | vlan://untagged | 204 | Dhcp | Deallocating | Start |
> DirectPodBasedNetworkGuru | 25d22aa0-da55-471a-976e-d1c595d2295d |
> 0 | 2015-07-10 11:51:07 | NULL | NULL | 1 |
> DomainRouter | 2015-07-10 10:49:40 | 2015-07-10 10:51:07 | NULL |
> NULL | 0 | 1 |
> | 7178 | 0f07cda5-cd9d-4c2c-9b19-d2079c17eb7f | 1719 |
> 06:a7:04:00:02:58 | 192.168.188.60 | 255.255.254.0 | 192.168.189.254 | Ip4
> | vlan://untagged | 204 | Dhcp | Deallocating | Start |
> DirectPodBasedNetworkGuru | 749b5fde-5b08-4e3d-aab2-2ce8296c9f56 |
> 0 | 2015-07-10 12:08:03 | NULL | NULL | 1 |
> DomainRouter | 2015-07-10 10:53:02 | 2015-07-10 11:08:03 | NULL |
> NULL | 0 | 1 |
> | 7561 | acb34e0e-6aaa-456f-b78d-3bc878c9cf57 | 1743 |
> 06:fc:9a:00:02:58 | 192.168.188.60 | 255.255.254.0 | 192.168.189.254 | Ip4
> | vlan://untagged | 204 | Dhcp | Reserved | Start |
> DirectPodBasedNetworkGuru | 9d4a595f-792f-45d9-a6d2-376905b03f87 |
> 0 | 2015-07-13 13:06:33 | NULL | NULL | 1 |
> DomainRouter | 2015-07-10 12:19:03 | NULL | NULL |
> NULL | 0 | 1 |
> | 8731 | 5eaa2c45-9e87-458e-a0ee-0cef47ee56d2 | 2023 |
> 06:6f:34:00:02:58 | 192.168.188.60 | 255.255.254.0 | 192.168.189.254 | Ip4
> | vlan://untagged | 204 | Dhcp | Deallocating | Start |
> DirectPodBasedNetworkGuru | bef0328f-3026-4713-9ab8-25f044964562 |
> 0 | 2015-07-13 12:28:08 | NULL | NULL | 1 | User
> | 2015-07-13 09:56:19 | 2015-07-13 11:28:08 | NULL | NULL
> | 0 | 1 |
> | 9826 | 3fde86fd-98d5-4577-84cd-64cefb58a80f | 2317 |
> 06:2b:08:00:02:58 | 192.168.188.60 | 255.255.254.0 | 192.168.189.254 | Ip4
> | vlan://untagged | 204 | Dhcp | Deallocating | Start |
> DirectPodBasedNetworkGuru | 2f16495c-dfa0-4fa0-8cc8-37ea471ace57 |
> 0 | 2015-07-13 15:20:56 | NULL | NULL | 1 | User
> | 2015-07-13 13:38:44 | 2015-07-13 14:20:56 | NULL | NULL
> | 0 | 1 |
> | 10976 | fd3c75e0-03f4-491a-ab8a-56423f19b7a1 | 2619 |
> 06:65:70:00:02:58 | 192.168.188.60 | 255.255.254.0 | 192.168.189.254 | Ip4
> | vlan://untagged | 204 | Dhcp | Deallocating | Start |
> DirectPodBasedNetworkGuru | b7ae777e-0343-4ef7-8f04-3bd6574e68b1 |
> 0 | 2015-07-14 08:51:40 | NULL | NULL | 1 | User
> | 2015-07-13 16:34:52 | 2015-07-14 07:51:39 | NULL | NULL
> | 0 | 1 |
> | 12414 | 077d0612-516c-4f6e-bfab-e341bfe1c968 | 3384 |
> 06:4b:1e:00:02:58 | 192.168.188.60 | 255.255.254.0 | 192.168.189.254 | Ip4
> | vlan://untagged | 204 | Dhcp | Deallocating | Start |
> DirectPodBasedNetworkGuru | ae793f2f-4cb3-46be-b179-53a7aaf1aa8a |
> 0 | 2015-07-14 15:34:36 | NULL | NULL | 1 | User
> | 2015-07-14 13:48:41 | 2015-07-14 14:34:36 | NULL | NULL
> | 0 | 1 |
> | 12722 | aba0a0dd-90cf-44c0-92e8-0e69b6d00347 | 3692 |
> 06:8a:9e:00:02:58 | 192.168.188.60 | 255.255.254.0 | 192.168.189.254 | Ip4
> | vlan://untagged | 204 | Dhcp | Deallocating | Start |
> DirectPodBasedNetworkGuru | d934f096-337d-4705-9be7-38063191f055 |
> 0 | 2015-07-14 17:28:50 | NULL | NULL | 1 | User
> | 2015-07-14 15:14:42 | 2015-07-14 16:28:50 | NULL | NULL
> | 0 | 1 |
> | 13200 | fb116e28-002c-4659-80bd-76a7972ca406 | 4170 |
> 06:98:b0:00:02:58 | 192.168.188.60 | 255.255.254.0 | 192.168.189.254 | Ip4
> | vlan://untagged | 204 | Dhcp | Reserved | Start |
> DirectPodBasedNetworkGuru | 6955c8dd-9fe4-4e04-ac7f-9c9fe48340cf |
> 0 | 2015-07-15 08:52:33 | NULL | NULL | 1 | User
> | 2015-07-15 07:52:31 | NULL | NULL | NULL
> | 0 | 1 |
>
> +-------+--------------------------------------+-------------+-------------------+---------------+---------------+----------------+---------+-----------------+------------+------+--------------+-------------+---------------------------+--------------------------------------+-----------+---------------------+---------------+-------------+-------------+--------------+---------------------+---------------------+-------------+----------+--------------+-------------+
> 15 rows in set (0.02 sec)
>
>
> mysql> select * from user_ip_address where public_ip_address =
> '192.168.188.60';
>
> +------+--------------------------------------+------------+-----------+-------------------+----------------+------------+---------------------+------------+----------------+-------+-----------+-------------+-------------------+------------+---------------------+-----------+--------+-----------+-------------+---------+---------+---------+
> | id | uuid | account_id | domain_id |
> public_ip_address | data_center_id | source_nat | allocated |
> vlan_db_id | one_to_one_nat | vm_id | state | mac_address |
> source_network_id | network_id | physical_network_id | is_system | vpc_id |
> dnat_vmip | is_portable | display | removed | created |
>
> +------+--------------------------------------+------------+-----------+-------------------+----------------+------------+---------------------+------------+----------------+-------+-----------+-------------+-------------------+------------+---------------------+-----------+--------+-----------+-------------+---------+---------+---------+
> | 2771 | 8751030c-c279-4334-8082-c036acabe00a | 2 | 1 |
> 192.168.188.60 | 1 | 0 | 2015-07-15 07:52:33 |
> 6 | 0 | NULL | Allocated | 600 |
> 204 | NULL | 200 | 0 | NULL | NULL |
> 0 | 1 | NULL | NULL |
>
> +------+--------------------------------------+------------+-----------+-------------------+----------------+------------+---------------------+------------+----------------+-------+-----------+-------------+-------------------+------------+---------------------+-----------+--------+-----------+-------------+---------+---------+---------+
> 1 row in set (0.00 sec)
>
>
> mysql> select * from vm_instance where instance_name='i-2-4170-VM';
>
> +------+-----------------------------------------+--------------------------------------+---------------+---------+----------------+-------------+---------------------+--------------------+--------+----------------+---------+--------------+----------+-------------------+----------------------------------------------------------+------------+---------------+--------------+---------------------+---------------------+---------+------+---------+------------+-----------+---------------------+--------------------------------------+-----------------+------------------+-------+-----------------------------------------+--------------------------------------+---------------+----------------------+------------+-------------+-------------------------+--------------------------+------------+
> | id | name | uuid
> | instance_name | state | vm_template_id | guest_os_id |
> private_mac_address | private_ip_address | pod_id | data_center_id |
> host_id | last_host_id | proxy_id | proxy_assign_time | vnc_password
> | ha_enabled | limit_cpu_use |
> update_count | update_time | created | removed | type |
> vm_type | account_id | domain_id | service_offering_id | reservation_id
> | hypervisor_type | disk_offering_id | owner | host_name
> | display_name |
> desired_state | dynamically_scalable | display_vm | power_state |
> power_state_update_time | power_state_update_count | power_host |
>
> +------+-----------------------------------------+--------------------------------------+---------------+---------+----------------+-------------+---------------------+--------------------+--------+----------------+---------+--------------+----------+-------------------+----------------------------------------------------------+------------+---------------+--------------+---------------------+---------------------+---------+------+---------+------------+-----------+---------------------+--------------------------------------+-----------------+------------------+-------+-----------------------------------------+--------------------------------------+---------------+----------------------+------------+-------------+-------------------------+--------------------------+------------+
> | 4170 | VM-2a6e41d0-bc9f-4b04-9fd2-bd6a8a2744bc |
> 2a6e41d0-bc9f-4b04-9fd2-bd6a8a2744bc | i-2-4170-VM | Running |
> 217 | 144 | 06:98:b0:00:02:58 | 192.168.188.60 | 6 |
> 1 | 16 | 16 | NULL | NULL |
> sdsdsdsdsdsdsdsdsdfdfdf3534r3f3r3f3f3r3f3f3f3f3f3f3f3f3 | 1 |
> 0 | 3 | 2015-07-15 07:53:56 | 2015-07-15 07:52:31 | NULL
> | User | User | 2 | 1 | 93 |
> 6955c8dd-9fe4-4e04-ac7f-9c9fe48340cf | XenServer | NULL |
> 2 | VM-2a6e41d0-bc9f-4b04-9fd2-bd6a8a2744bc |
> e3274915-6666-4a91-a2be-071f2176d1d7 | NULL | 0
> | 1 | PowerOn | 2015-07-15 07:56:07 |
> 3 | 16 |
>
> +------+-----------------------------------------+--------------------------------------+---------------+---------+----------------+-------------+---------------------+--------------------+--------+----------------+---------+--------------+----------+-------------------+----------------------------------------------------------+------------+---------------+--------------+---------------------+---------------------+---------+------+---------+------------+-----------+---------------------+--------------------------------------+-----------------+------------------+-------+-----------------------------------------+--------------------------------------+---------------+----------------------+------------+-------------+-------------------------+--------------------------+------------+
> 1 row in set (0.02 sec)
>
>
> mysql> select * from vm_instance where instance_name='r-1743-VM';
>
> +------+-----------+--------------------------------------+---------------+---------+----------------+-------------+---------------------+--------------------+--------+----------------+---------+--------------+----------+-------------------+----------------------------------------------------------+------------+---------------+--------------+---------------------+---------------------+---------+--------------+--------------+------------+-----------+---------------------+--------------------------------------+-----------------+------------------+-------+-----------+--------------+---------------+----------------------+------------+-------------+-------------------------+--------------------------+------------+
> | id | name | uuid | instance_name
> | state | vm_template_id | guest_os_id | private_mac_address |
> private_ip_address | pod_id | data_center_id | host_id | last_host_id |
> proxy_id | proxy_assign_time | vnc_password
> | ha_enabled | limit_cpu_use | update_count | update_time
> | created | removed | type | vm_type |
> account_id | domain_id | service_offering_id | reservation_id
> | hypervisor_type | disk_offering_id | owner | host_name |
> display_name | desired_state | dynamically_scalable | display_vm |
> power_state | power_state_update_time | power_state_update_count |
> power_host |
>
> +------+-----------+--------------------------------------+---------------+---------+----------------+-------------+---------------------+--------------------+--------+----------------+---------+--------------+----------+-------------------+----------------------------------------------------------+------------+---------------+--------------+---------------------+---------------------+---------+--------------+--------------+------------+-----------+---------------------+--------------------------------------+-----------------+------------------+-------+-----------+--------------+---------------+----------------------+------------+-------------+-------------------------+--------------------------+------------+
> | 1743 | r-1743-VM | c6a6def4-820f-4233-bb7c-fa3df61cb6c0 | r-1743-VM
> | Running | 215 | 184 | 0e:00:a9:fe:01:c5 |
> 169.254.1.197 | 6 | 1 | 11 | 11 |
> NULL | NULL |
> sdsdsdsdsdsdsdsdsdfdfdf3534r3f3r3f3f3r3f3f3f3f3f3f3f3f3 | 1 |
> 0 | 8 | 2015-07-13 12:07:52 | 2015-07-10 12:19:03 | NULL
> | DomainRouter | DomainRouter | 1 | 1 |
> 43 | 9d4a595f-792f-45d9-a6d2-376905b03f87 | XenServer |
> NULL | NULL | NULL | NULL | NULL |
> 0 | 1 | PowerOn | 2015-07-15 07:13:05 |
> 3 | 11 |
>
> +------+-----------+--------------------------------------+---------------+---------+----------------+-------------+---------------------+--------------------+--------+----------------+---------+--------------+----------+-------------------+----------------------------------------------------------+------------+---------------+--------------+---------------------+---------------------+---------+--------------+--------------+------------+-----------+---------------------+--------------------------------------+-----------------+------------------+-------+-----------+--------------+---------------+----------------------+------------+-------------+-------------------------+--------------------------+------------+
> 1 row in set (0.02 sec)
>
> Cheers!
>
>
