shweta agarwal created CLOUDSTACK-5252:
------------------------------------------
Summary: list router api not giving correct results with zone,
pod, clusters paramenters
Key: CLOUDSTACK-5252
URL: https://issues.apache.org/jira/browse/CLOUDSTACK-5252
Project: CloudStack
Issue Type: Bug
Security Level: Public (Anyone can view this level - this is the default.)
Components: Upgrade
Affects Versions: 4.3.0
Environment: upgrade from 3.0.7 to 4.3
Reporter: shweta agarwal
Priority: Blocker
Fix For: 4.3.0
list router api is not giving correct result when called with any of the
following parameters
Zoneid
clusterid
podid
Cloudmonkey output for
list routers zoneid=1 | more
"count": 1,
"router": [
{
"account": "admin",
"created": "2013-11-22T01:22:28-0500",
"dns1": "10.140.50.6",
"domain": "ROOT",
"domainid": "1",
"gateway": "10.147.51.1",
"guestipaddress": "10.1.1.1",
"guestmacaddress": "02:00:01:99:00:02",
"guestnetmask": "255.255.255.0",
"guestnetworkid": "2cd93b6f-c78a-44ec-93c6-d621744358c8",
"hostid": "ccf22f38-7fec-404c-b250-c209b14694e9",
"hostname": "Rack1Pod1Host27",
"id": "ca7f684d-915f-4d65-8b93-10eab67f8bb7",
"isredundantrouter": false,
"linklocalip": "169.254.2.244",
"linklocalmacaddress": "0e:00:a9:fe:02:f4",
"linklocalnetmask": "255.255.0.0",
"linklocalnetworkid": "ad987a17-2987-4354-80a0-568cdc21678f",
"name": "r-6-VM",
"networkdomain": "cs2cloud.internal",
"nic": [
{
"broadcasturi": "vlan://1059",
"id": "fdf69706-b0f3-4827-8d93-00edc973dfcf",
"ipaddress": "10.1.1.1",
"isdefault": false,
"isolationuri": "vlan://1059",
"macaddress": "02:00:01:99:00:02",
"netmask": "255.255.255.0",
"networkid": "2cd93b6f-c78a-44ec-93c6-d621744358c8",
"networkname": "vr-xen-admin",
"traffictype": "Guest",
"type": "Isolated"
},
{
"gateway": "169.254.0.1",
"id": "ae74a4b2-05c5-4543-8a94-7770626f07dc",
"ipaddress": "169.254.2.244",
"isdefault": false,
"macaddress": "0e:00:a9:fe:02:f4",
"netmask": "255.255.0.0",
"networkid": "ad987a17-2987-4354-80a0-568cdc21678f",
"traffictype": "Control"
},
{
"broadcasturi": "vlan://51",
"gateway": "10.147.51.1",
"id": "cebdf095-b3cd-4053-9dc7-b73ca1eb4f02",
"ipaddress": "10.147.51.21",
"isdefault": true,
"isolationuri": "vlan://51",
"macaddress": "06:bb:aa:00:00:20",
"netmask": "255.255.255.0",
"networkid": "2b27fca6-89ba-441b-a402-3ca9b1fab670",
"traffictype": "Public"
}
],
"podid": "057eb551-1ebc-438f-a960-6958ef5182f4",
"publicip": "10.147.51.21",
"publicmacaddress": "06:bb:aa:00:00:20",
"publicnetmask": "255.255.255.0",
"publicnetworkid": "2b27fca6-89ba-441b-a402-3ca9b1fab670",
"redundantstate": "UNKNOWN",
"requiresupgrade": true,
"role": "VIRTUAL_ROUTER",
"serviceofferingid": "1b56ab92-9d5d-49e1-819c-e938b83e6986",
"serviceofferingname": "System Offering For Software Router",
"state": "Running",
"templateid": "d03705f4-072d-4766-9f61-6ba32524732c",
"version": "3.0",
"zoneid": "2998d037-1956-40a2-b9d5-db144fb87408",
"zonename": "xen"
}
]
}
While DB shows may more routers in zone 1
select * from vm_instance where data_center_id=1 and type="DomainRouter"
"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" "cpu"
"ram" "owner" "speed" "host_name" "display_name" "desired_state"
"dynamically_scalable" "display_vm" "power_state"
"power_state_update_time" "power_state_update_count" "power_host"
"6" "r-6-VM" "ca7f684d-915f-4d65-8b93-10eab67f8bb7" "r-6-VM"
"Running" "202" "133" "0e:00:a9:fe:02:f4" "169.254.2.244" "1"
"1" "1" "1" "" ""
"3QUrICRWH2jBOY7BPi0uVh1xLV2OU86felrN6QWVM6M=" "1" "0" "3"
"2013-11-22 06:23:33" "2013-11-22 06:22:28" "" "DomainRouter"
"DomainRouter" "2" "1" "10" "1093b19d-a78c-4090-846a-461559274783"
"XenServer" "" "" "" "" "" "" "" ""
"0" "1" "PowerUnknown" "" "0" ""
"10" "r-10-VM" "01b4a88f-f5f3-4e9e-a18a-8561c67adb92" "r-10-VM"
"Running" "202" "133" "0e:00:a9:fe:01:3b" "169.254.1.59" "1"
"1" "1" "1" "" ""
"UAl7k4QK76YeWHd2xY06M5e/emPFbZm9CkoZeJwkgL8=" "1" "0" "3"
"2013-11-22 06:28:15" "2013-11-22 06:25:09" "" "DomainRouter"
"DomainRouter" "3" "2" "10" "6a065329-7f04-4bf3-8d92-277c0f9481ea"
"XenServer" "" "" "" "" "" "" "" ""
"0" "1" "PowerUnknown" "" "0" ""
"14" "r-14-VM" "8cc8fd52-bb93-415d-bfe1-b7501d394a1e" "r-14-VM"
"Running" "202" "133" "0e:00:a9:fe:00:0d" "169.254.0.13" "1"
"1" "1" "1" "" ""
"OqMPTak8k9Ix5iflg598iE5pbb1MQUcImsHiVc7q0Jg=" "1" "0" "3"
"2013-11-22 06:29:03" "2013-11-22 06:26:38" "" "DomainRouter"
"DomainRouter" "3" "2" "10" "6d5a487f-9f0c-4cdb-a753-8becd1ebcb9c"
"XenServer" "" "" "" "" "" "" "" ""
"0" "1" "PowerUnknown" "" "0" ""
"18" "r-18-VM" "031ad0c0-b14c-42c0-8031-947e07d03e34" "r-18-VM"
"Running" "202" "133" "0e:00:a9:fe:03:e4" "169.254.3.228" "1"
"1" "1" "1" "" ""
"T2pZfqFuuV+VKV9+6oryuuQ76I5KOx70dkBD/CT/n/8=" "1" "0" "3"
"2013-11-22 08:37:30" "2013-11-22 08:36:24" "" "DomainRouter"
"DomainRouter" "9" "2" "10" "653f8453-a2a5-441f-a7e7-3a38b1fac24e"
"XenServer" "" "" "" "" "" "" "" ""
"0" "1" "PowerUnknown" "" "0" ""
"22" "r-22-VM" "9c0a320c-21f9-4263-9a2f-40e822b853e7" "r-22-VM"
"Running" "202" "133" "0e:00:a9:fe:02:39" "169.254.2.57" "1"
"1" "1" "1" "" ""
"4opE2Kp4YYRUrI+PhNJ/oOEEhKXvPykPcgBwu//dXWk=" "1" "0" "3"
"2013-11-22 08:40:01" "2013-11-22 08:38:55" "" "DomainRouter"
"DomainRouter" "6" "2" "10" "f93657bb-4173-4c25-aed1-55458cb1827d"
"XenServer" "" "" "" "" "" "" "" ""
"0" "1" "PowerUnknown" "" "0" ""
"26" "r-26-VM" "841f8dd5-2f11-4f44-bebb-beac2b948732" "r-26-VM"
"Running" "202" "133" "0e:00:a9:fe:03:e1" "169.254.3.225" "1"
"1" "1" "1" "" ""
"pnCSuZnSnwo8GYa8Ub+/mPkAr6A8SPd5Ko2OgiiRo8Q=" "1" "0" "3"
"2013-11-22 08:41:27" "2013-11-22 08:40:26" "" "DomainRouter"
"DomainRouter" "6" "2" "10" "511dc2f1-3e23-49a7-a90d-23e33306aac2"
"XenServer" "" "" "" "" "" "" "" ""
"0" "1" "PowerUnknown" "" "0" ""
"27" "r-27-VM" "270c8856-b17b-4f16-92da-6f037c3dd113" "r-27-VM"
"Running" "202" "133" "0e:00:a9:fe:01:28" "169.254.1.40" "1"
"1" "1" "1" "" ""
"CNXDEzSwySLr4GnXKXF1tS2kUURCXatoTlsQf5r8gJY=" "1" "0" "3"
"2013-11-22 08:43:01" "2013-11-22 08:42:02" "" "DomainRouter"
"DomainRouter" "9" "2" "10" "08747a7f-c755-48a5-8a15-ff67803091d0"
"XenServer" "" "" "" "" "" "" "" ""
"0" "1" "PowerUnknown" "" "0" ""
"32" "r-32-VM" "bcfbeb32-6a34-4c42-8abc-69f3d3ec8bb2" "r-32-VM"
"Running" "202" "133" "0e:00:a9:fe:01:69" "169.254.1.105" "1"
"1" "1" "1" "" ""
"6i9MmUtdaJ4ErMDrWkKg6MZuLZMrXXju0W4K0bxUF0M=" "1" "0" "3"
"2013-11-22 09:04:13" "2013-11-22 09:02:52" "" "DomainRouter"
"DomainRouter" "5" "3" "10" "afc74183-3b07-4013-a12c-ae5e83743e84"
"XenServer" "" "" "" "" "" "" "" ""
"0" "1" "PowerUnknown" "" "0" ""
"35" "r-35-VM" "bb9aa5ad-9a61-495d-9785-20db9a26f93a" "r-35-VM"
"Running" "202" "133" "0e:00:a9:fe:01:d2" "169.254.1.210" "1"
"1" "1" "1" "" ""
"zNasOdQdRaeGus3W1002xh0d2Tl5iR5OjmqCgcRaTJo=" "1" "0" "3"
"2013-11-22 09:12:27" "2013-11-22 09:11:36" "" "DomainRouter"
"DomainRouter" "5" "3" "10" "899131af-4e96-4c22-8b7f-ebc36138beea"
"XenServer" "" "" "" "" "" "" "" ""
"0" "1" "PowerUnknown" "" "0" ""
"41" "r-41-VM" "6fd6975e-e88a-44cf-9d72-c45cde0f13c3" "r-41-VM"
"Running" "202" "133" "0e:00:a9:fe:02:35" "169.254.2.53" "1"
"1" "1" "1" "" ""
"ShTUP23taEnT5mDfRDNqqkv0/YRurjm4VLsb7pRSu6Q=" "1" "0" "3"
"2013-11-22 09:17:32" "2013-11-22 09:16:26" "" "DomainRouter"
"DomainRouter" "8" "1" "10" "8068c2e8-96e7-426e-99ba-ac1d72ecee8a"
"XenServer" "" "" "" "" "" "" "" ""
"0" "1" "PowerUnknown" "" "0" ""
"45" "r-45-VM" "75bccb73-3553-4183-a76f-2fcd5acba492" "r-45-VM"
"Running" "202" "133" "0e:00:a9:fe:03:9b" "169.254.3.155" "1"
"1" "1" "1" "" ""
"a1WGO0ipLNz+dwJA7PgkPJc//sD5qYHM0gkrRUZdy9Q=" "1" "0" "3"
"2013-11-22 09:19:18" "2013-11-22 09:17:27" "" "DomainRouter"
"DomainRouter" "8" "1" "10" "e4c69405-d584-45c0-b87b-4a9d1c7c769f"
"XenServer" "" "" "" "" "" "" "" ""
"0" "1" "PowerUnknown" "" "0" ""
--
This message was sent by Atlassian JIRA
(v6.1#6144)
