Return-Path: X-Original-To: apmail-cloudstack-issues-archive@www.apache.org Delivered-To: apmail-cloudstack-issues-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 22EB210FD8 for ; Fri, 13 Dec 2013 11:06:11 +0000 (UTC) Received: (qmail 75032 invoked by uid 500); 13 Dec 2013 11:06:10 -0000 Delivered-To: apmail-cloudstack-issues-archive@cloudstack.apache.org Received: (qmail 75016 invoked by uid 500); 13 Dec 2013 11:06:10 -0000 Mailing-List: contact issues-help@cloudstack.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@cloudstack.apache.org Delivered-To: mailing list issues@cloudstack.apache.org Received: (qmail 75004 invoked by uid 500); 13 Dec 2013 11:06:08 -0000 Delivered-To: apmail-incubator-cloudstack-issues@incubator.apache.org Received: (qmail 74993 invoked by uid 99); 13 Dec 2013 11:06:08 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 13 Dec 2013 11:06:08 +0000 Date: Fri, 13 Dec 2013 11:06:08 +0000 (UTC) From: "shweta agarwal (JIRA)" To: cloudstack-issues@incubator.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Reopened] (CLOUDSTACK-5252) list router api not giving correct results with zone, pod, clusters paramenters MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/CLOUDSTACK-5252?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] shweta agarwal reopened CLOUDSTACK-5252: ---------------------------------------- you need to still consider Project relate routers need to make additional call with projectid=-1 > 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)