[
https://issues.apache.org/jira/browse/CLOUDSTACK-5252?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13849924#comment-13849924
]
ASF subversion and git services commented on CLOUDSTACK-5252:
-------------------------------------------------------------
Commit f919441c347f51d618f70c8044b6c00a7a8f72f2 in branch refs/heads/master
from [~jessicawang]
[ https://git-wip-us.apache.org/repos/asf?p=cloudstack.git;h=f919441 ]
CLOUDSTACK-5252: UI > Infrastructure > Virtual Routers > group by
zone/pod/cluster > include project-related routers into calculation.
> 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
> Assignee: Jessica Wang
> 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.4#6159)
