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
