[
https://issues.apache.org/jira/browse/CLOUDSTACK-5493?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13849074#comment-13849074
]
manasaveloori commented on CLOUDSTACK-5493:
-------------------------------------------
applies to group by account as well.
> Group by cluster options in router page shows count for only running routers
> ----------------------------------------------------------------------------
>
> Key: CLOUDSTACK-5493
> URL: https://issues.apache.org/jira/browse/CLOUDSTACK-5493
> Project: CloudStack
> Issue Type: Bug
> Security Level: Public(Anyone can view this level - this is the
> default.)
> Components: UI
> Affects Versions: 4.3.0
> Reporter: shweta agarwal
> Fix For: 4.3.0
>
>
> Group by cluster options in router pages shows count for only running routers
> while pod , zone considers both running and stopped routers
> API :
> http://10.147.40.27:8080/client/api?command=listRouters&response=json&sessionkey=lDWk06sWJovcFLDuw3MHaS00N4Q%3D&clusterid=3e27c364-4f21-4eda-9ef8-ac7af9b123c0&listAll=true&page=1&pagesize=20&_=1386935231874
> Response :
> Notice response shows only 4 routers though in my setup I have 10 routers : 4
> running, 5 stopped , 1 project related and only one cluster
> { "listroutersresponse" : { "count":4 ,"router" : [
> {"id":"3d05883f-3089-449a-84a2-bb7d758f1e82","zoneid":"60e7f3ce-cb9c-45e1-8c8b-9d93d2adf060","zonename":"xen","dns1":"10.140.50.6","gateway":"10.147.51.1","name":"r-19-VM","podid":"a5d5234e-86d6-41f8-ac8c-5bdf24288231","hostid":"90ac48de-eb48-4283-b2f9-1a6581a92fb6","hostname":"Rack1Pod1Host24","linklocalip":"169.254.1.123","linklocalmacaddress":"0e:00:a9:fe:01:7b","linklocalnetmask":"255.255.0.0","linklocalnetworkid":"d73e3fa7-c561-4e04-be13-d242832a9f3f","publicip":"10.147.51.21","publicmacaddress":"06:bd:38:00:00:20","publicnetmask":"255.255.255.0","publicnetworkid":"b5b1260c-30a0-4a6e-9780-ca4ae4809373","templateid":"ce21f5d6-630f-11e3-9a2f-97407caff5c2","created":"2013-12-12T17:56:08+0530","state":"Running","account":"admin","domainid":"94814869-1330-42b9-8e74-77a407a3cd7e","domain":"child1","serviceofferingid":"72743e39-323d-4aba-9076-6c43b72252c1","serviceofferingname":"System
> Offering For Software
> Router","isredundantrouter":false,"redundantstate":"UNKNOWN","version":"3.0","vpcid":"07fcf168-3086-40c0-bd9b-eddb70396aaa","role":"VIRTUAL_ROUTER","nic":[{"id":"87f6bfb3-f993-4cc6-8332-4b25efd298a3","networkid":"d73e3fa7-c561-4e04-be13-d242832a9f3f","netmask":"255.255.0.0","gateway":"169.254.0.1","ipaddress":"169.254.1.123","traffictype":"Control","isdefault":false,"macaddress":"0e:00:a9:fe:01:7b"},{"id":"8066d1e0-ee16-4ade-898e-3a232efb8345","networkid":"b5b1260c-30a0-4a6e-9780-ca4ae4809373","netmask":"255.255.255.0","gateway":"10.147.51.1","ipaddress":"10.147.51.21","isolationuri":"vlan://51","broadcasturi":"vlan://51","traffictype":"Public","isdefault":true,"macaddress":"06:bd:38:00:00:20"}],"requiresupgrade":true},
>
> {"id":"e934a9a2-c205-47fb-9844-98c95fdcd9a4","zoneid":"60e7f3ce-cb9c-45e1-8c8b-9d93d2adf060","zonename":"xen","dns1":"10.140.50.6","gateway":"10.147.51.1","name":"r-8-VM","podid":"a5d5234e-86d6-41f8-ac8c-5bdf24288231","hostid":"90ac48de-eb48-4283-b2f9-1a6581a92fb6","hostname":"Rack1Pod1Host24","linklocalip":"169.254.3.171","linklocalmacaddress":"0e:00:a9:fe:03:ab","linklocalnetmask":"255.255.0.0","linklocalnetworkid":"d73e3fa7-c561-4e04-be13-d242832a9f3f","publicip":"10.147.51.14","publicmacaddress":"06:f3:fe:00:00:19","publicnetmask":"255.255.255.0","publicnetworkid":"b5b1260c-30a0-4a6e-9780-ca4ae4809373","templateid":"ce21f5d6-630f-11e3-9a2f-97407caff5c2","created":"2013-12-12T17:49:40+0530","state":"Running","account":"shweta","domainid":"226fe5b1-c1be-45bf-a3d4-5bb6ca08ee87","domain":"child","serviceofferingid":"72743e39-323d-4aba-9076-6c43b72252c1","serviceofferingname":"System
> Offering For Software
> Router","isredundantrouter":false,"redundantstate":"UNKNOWN","version":"3.0","vpcid":"6e00939b-2db8-4227-904f-07dc954ae353","role":"VIRTUAL_ROUTER","nic":[{"id":"e0e4fa7d-2bd6-4d56-967d-9f021bffb34a","networkid":"d73e3fa7-c561-4e04-be13-d242832a9f3f","netmask":"255.255.0.0","gateway":"169.254.0.1","ipaddress":"169.254.3.171","traffictype":"Control","isdefault":false,"macaddress":"0e:00:a9:fe:03:ab"},{"id":"5c2f5398-b3a6-403b-82c9-cf4a00461a0d","networkid":"b5b1260c-30a0-4a6e-9780-ca4ae4809373","netmask":"255.255.255.0","gateway":"10.147.51.1","ipaddress":"10.147.51.14","isolationuri":"vlan://51","broadcasturi":"vlan://51","traffictype":"Public","isdefault":true,"macaddress":"06:f3:fe:00:00:19"}],"requiresupgrade":true},
>
> {"id":"27e5c26c-5101-4b13-b8c0-666e7f0adf72","zoneid":"60e7f3ce-cb9c-45e1-8c8b-9d93d2adf060","zonename":"xen","dns1":"10.140.50.6","gateway":"10.147.51.1","name":"r-16-VM","podid":"a5d5234e-86d6-41f8-ac8c-5bdf24288231","hostid":"90ac48de-eb48-4283-b2f9-1a6581a92fb6","hostname":"Rack1Pod1Host24","linklocalip":"169.254.2.220","linklocalmacaddress":"0e:00:a9:fe:02:dc","linklocalnetmask":"255.255.0.0","linklocalnetworkid":"d73e3fa7-c561-4e04-be13-d242832a9f3f","publicip":"10.147.51.19","publicmacaddress":"06:da:72:00:00:1e","publicnetmask":"255.255.255.0","publicnetworkid":"b5b1260c-30a0-4a6e-9780-ca4ae4809373","templateid":"ce21f5d6-630f-11e3-9a2f-97407caff5c2","created":"2013-12-12T17:54:37+0530","state":"Running","account":"admin","domainid":"226fe5b1-c1be-45bf-a3d4-5bb6ca08ee87","domain":"child","serviceofferingid":"72743e39-323d-4aba-9076-6c43b72252c1","serviceofferingname":"System
> Offering For Software
> Router","isredundantrouter":false,"redundantstate":"UNKNOWN","version":"3.0","vpcid":"5b4d16a7-846b-4b9f-acf1-984d218bc39d","role":"VIRTUAL_ROUTER","nic":[{"id":"fffe3f80-1aae-4624-814f-4cb56213daa5","networkid":"d73e3fa7-c561-4e04-be13-d242832a9f3f","netmask":"255.255.0.0","gateway":"169.254.0.1","ipaddress":"169.254.2.220","traffictype":"Control","isdefault":false,"macaddress":"0e:00:a9:fe:02:dc"},{"id":"3dd56b09-02ab-48ba-800b-156cda3489b1","networkid":"b5b1260c-30a0-4a6e-9780-ca4ae4809373","netmask":"255.255.255.0","gateway":"10.147.51.1","ipaddress":"10.147.51.19","isolationuri":"vlan://51","broadcasturi":"vlan://51","traffictype":"Public","isdefault":true,"macaddress":"06:da:72:00:00:1e"}],"requiresupgrade":true},
>
> {"id":"61f5b917-db93-4152-bac7-e92b1cfe4119","zoneid":"60e7f3ce-cb9c-45e1-8c8b-9d93d2adf060","zonename":"xen","dns1":"10.140.50.6","gateway":"10.147.51.1","name":"r-11-VM","podid":"a5d5234e-86d6-41f8-ac8c-5bdf24288231","hostid":"90ac48de-eb48-4283-b2f9-1a6581a92fb6","hostname":"Rack1Pod1Host24","linklocalip":"169.254.0.80","linklocalmacaddress":"0e:00:a9:fe:00:50","linklocalnetmask":"255.255.0.0","linklocalnetworkid":"d73e3fa7-c561-4e04-be13-d242832a9f3f","publicip":"10.147.51.16","publicmacaddress":"06:13:d2:00:00:1b","publicnetmask":"255.255.255.0","publicnetworkid":"b5b1260c-30a0-4a6e-9780-ca4ae4809373","templateid":"ce21f5d6-630f-11e3-9a2f-97407caff5c2","created":"2013-12-12T17:51:29+0530","state":"Running","account":"shweta","domainid":"94814869-1330-42b9-8e74-77a407a3cd7e","domain":"child1","serviceofferingid":"72743e39-323d-4aba-9076-6c43b72252c1","serviceofferingname":"System
> Offering For Software
> Router","isredundantrouter":false,"redundantstate":"UNKNOWN","version":"3.0","vpcid":"dbbefce8-c399-45ef-b953-0cfe7b5c3ab7","role":"VIRTUAL_ROUTER","nic":[{"id":"5b113001-8c29-45cb-8c35-381fe91b73e6","networkid":"d73e3fa7-c561-4e04-be13-d242832a9f3f","netmask":"255.255.0.0","gateway":"169.254.0.1","ipaddress":"169.254.0.80","traffictype":"Control","isdefault":false,"macaddress":"0e:00:a9:fe:00:50"},{"id":"a12ecff5-ebda-4534-acae-d3558f9186bb","networkid":"b5b1260c-30a0-4a6e-9780-ca4ae4809373","netmask":"255.255.255.0","gateway":"10.147.51.1","ipaddress":"10.147.51.16","isolationuri":"vlan://51","broadcasturi":"vlan://51","traffictype":"Public","isdefault":true,"macaddress":"06:13:d2:00:00:1b"}],"requiresupgrade":true}
> ] } }
> DB entries from domain_router table:
> "id" "element_id" "public_mac_address" "public_ip_address"
> "public_netmask" "guest_netmask" "guest_ip_address"
> "is_redundant_router" "priority" "is_priority_bumpup"
> "redundant_state" "stop_pending" "role" "template_version"
> "scripts_version" "vpc_id"
> "4" "1" "06:c5:e8:00:00:17" "10.147.51.12" "255.255.255.0" ""
> "" "0" "0" "0" "UNKNOWN" "0" "VIRTUAL_ROUTER"
> "Cloudstack Release 3.0 Mon Feb 6 15:10:04 PST 2012"
> "972eca6116176f8e4bb91bdd65c7f677" ""
> "7" "1" "06:91:00:00:00:18" "10.147.51.13" "255.255.255.0" ""
> "" "0" "0" "0" "UNKNOWN" "0" "VIRTUAL_ROUTER"
> "Cloudstack Release 3.0 Mon Feb 6 15:10:04 PST 2012"
> "972eca6116176f8e4bb91bdd65c7f677" ""
> "10" "1" "06:40:4c:00:00:1a" "10.147.51.15" "255.255.255.0" ""
> "" "0" "0" "0" "UNKNOWN" "0" "VIRTUAL_ROUTER"
> "Cloudstack Release 3.0 Mon Feb 6 15:10:04 PST 2012"
> "972eca6116176f8e4bb91bdd65c7f677" ""
> "13" "1" "06:16:9e:00:00:1c" "10.147.51.17" "255.255.255.0" ""
> "" "0" "0" "0" "UNKNOWN" "0" "VIRTUAL_ROUTER"
> "Cloudstack Release 3.0 Mon Feb 6 15:10:04 PST 2012"
> "972eca6116176f8e4bb91bdd65c7f677" ""
> "15" "1" "06:a4:b2:00:00:1d" "10.147.51.18" "255.255.255.0" ""
> "" "0" "0" "0" "UNKNOWN" "0" "VIRTUAL_ROUTER"
> "Cloudstack Release 3.0 Mon Feb 6 15:10:04 PST 2012"
> "972eca6116176f8e4bb91bdd65c7f677" ""
> "18" "1" "06:bc:86:00:00:1f" "10.147.51.20" "255.255.255.0" ""
> "" "0" "0" "0" "UNKNOWN" "0" "VIRTUAL_ROUTER"
> "Cloudstack Release 3.0 Mon Feb 6 15:10:04 PST 2012"
> "972eca6116176f8e4bb91bdd65c7f677" ""
> "8" "2" "06:f3:fe:00:00:19" "10.147.51.14" "255.255.255.0" ""
> "" "0" "0" "0" "UNKNOWN" "0" "VIRTUAL_ROUTER"
> "Cloudstack Release 3.0 Mon Feb 6 15:10:04 PST 2012"
> "972eca6116176f8e4bb91bdd65c7f677" "1"
> "11" "2" "06:13:d2:00:00:1b" "10.147.51.16" "255.255.255.0" ""
> "" "0" "0" "0" "UNKNOWN" "0" "VIRTUAL_ROUTER"
> "Cloudstack Release 3.0 Mon Feb 6 15:10:04 PST 2012"
> "972eca6116176f8e4bb91bdd65c7f677" "2"
> "16" "2" "06:da:72:00:00:1e" "10.147.51.19" "255.255.255.0" ""
> "" "0" "0" "0" "UNKNOWN" "0" "VIRTUAL_ROUTER"
> "Cloudstack Release 3.0 Mon Feb 6 15:10:04 PST 2012"
> "972eca6116176f8e4bb91bdd65c7f677" "3"
> "19" "2" "06:bd:38:00:00:20" "10.147.51.21" "255.255.255.0" ""
> "" "0" "0" "0" "UNKNOWN" "0" "VIRTUAL_ROUTER"
> "Cloudstack Release 3.0 Mon Feb 6 15:10:04 PST 2012"
> "972eca6116176f8e4bb91bdd65c7f677" "4"
--
This message was sent by Atlassian JIRA
(v6.1.4#6159)
