You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@cloudstack.apache.org by "venkata swamybabu budumuru (JIRA)" <ji...@apache.org> on 2013/07/30 15:47:49 UTC

[jira] [Created] (CLOUDSTACK-3953) [USAGE] [GSLB] Need collect and update the usage statistics for GSLB rules

venkata swamybabu budumuru created CLOUDSTACK-3953:
------------------------------------------------------

             Summary: [USAGE] [GSLB] Need collect and update the usage statistics for GSLB rules
                 Key: CLOUDSTACK-3953
                 URL: https://issues.apache.org/jira/browse/CLOUDSTACK-3953
             Project: CloudStack
          Issue Type: Bug
      Security Level: Public (Anyone can view this level - this is the default.)
          Components: Usage
    Affects Versions: 4.2.0
            Reporter: venkata swamybabu budumuru
            Priority: Critical
             Fix For: 4.2.0


Steps to reproduce:

(1) Have latest CloudStack setup with at least 2 advanced zones.

Note : Make sure usage server as well running

(2) Configure GSLB provider in each zone.
(3) As a non-ROOT domain user, create a GSLB rule and map LB rules to it.
(4) check for usage information 

Observations:

(i) I can see usage_event created for the above but, didn't see any stats getting update for the same in user_statistics table.


mysql> select * from usage_event where id>=39;
+----+------------------+------------+---------------------+---------+-------------+---------------+-------------+-------------+------+----------------+-----------+--------------+
| id | type             | account_id | created             | zone_id | resource_id | resource_name | offering_id | template_id | size | resource_type  | processed | virtual_size |
+----+------------------+------------+---------------------+---------+-------------+---------------+-------------+-------------+------+----------------+-----------+--------------+
| 39 | GLOBAL.LB.CREATE |          3 | 2013-07-30 12:33:50 |       0 |           1 | GSLB1         |        NULL |        NULL | NULL | NULL           |         0 |         NULL |
| 40 | NET.IPASSIGN     |          3 | 2013-07-30 12:35:56 |       1 |           5 | 10.147.44.64  |        NULL |           0 |    0 | VirtualNetwork |         0 |         NULL |
| 41 | LB.CREATE        |          3 | 2013-07-30 12:36:13 |       1 |           1 | NULL          |        NULL |        NULL | NULL | NULL           |         0 |         NULL |
| 42 | NET.IPASSIGN     |          3 | 2013-07-30 12:36:36 |       2 |          14 | 10.147.54.63  |        NULL |           0 |    0 | VirtualNetwork |         0 |         NULL |
| 43 | LB.CREATE        |          3 | 2013-07-30 12:36:54 |       2 |           3 | NULL          |        NULL |        NULL | NULL | NULL           |         0 |         NULL |
+----+------------------+------------+---------------------+---------+-------------+---------------+-------------+-------------+------+----------------+-----------+--------------+


mysql> select * from user_statistics;
+----+----------------+------------+-------------------+-----------+--------------+------------+--------------------+----------------+------------------------+--------------------+--------------------+----------------+
| id | data_center_id | account_id | public_ip_address | device_id | device_type  | network_id | net_bytes_received | net_bytes_sent | current_bytes_received | current_bytes_sent | agg_bytes_received | agg_bytes_sent |
+----+----------------+------------+-------------------+-----------+--------------+------------+--------------------+----------------+------------------------+--------------------+--------------------+----------------+
|  1 |              1 |          3 | NULL              |         6 | DomainRouter |        208 |                  0 |              0 |                 100192 |              76132 |                  0 |           5760 |
|  2 |              1 |          2 | NULL              |         8 | DomainRouter |        209 |                  0 |              0 |                      0 |                  0 |                  0 |              0 |
|  3 |              2 |          3 | NULL              |        10 | DomainRouter |        210 |                  0 |              0 |                      0 |                  0 |                  0 |              0 |
|  4 |              2 |          3 | NULL              |        13 | DomainRouter |        210 |                  0 |              0 |                      0 |                900 |                  0 |              0 |
+----+----------------+------------+-------------------+-----------+--------------+------------+--------------------+----------------+------------------------+--------------------+--------------------+----------------+
4 rows in set (0.00 sec)

Attaching all the logs along with db dump to the bug.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira