[ https://issues.apache.org/jira/browse/CLOUDSTACK-3953?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Murali Reddy updated CLOUDSTACK-3953: ------------------------------------- Fix Version/s: (was: 4.2.0) Future > [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 > Environment: commit id # 6275d697e340be5b520f37b15d72343fa47c00a9 > Reporter: venkata swamybabu budumuru > Assignee: Murali Reddy > Priority: Critical > Fix For: Future > > Attachments: logs.tgz > > > 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