hmm I verified in the DB and i don't see duplicate samples in mysql. For example,
mysql> select * from sample where meter_id = 13\G; *************************** 1. row *************************** id: 83 user_id: NULL project_id: 05808ee2515e4623ad33420a94500907 resource_id: 0bdd7b5a-b92a-44cb-a351-b7c78938cc3a resource_metadata: {"status": "ACTIVE", "status_description": null, "protocol": "HTTP", "description": "", "admin_state_up": true, "subnet_id": "fd782ef4-c502-46aa-a04e-0ea77e0f23cc", "connection_limit": -1, "pool_id": "648d29af-767a-4cc6-9f0b-2344f7503339", "session_persistence": {"type": "SOURCE_IP"}, "address": "10.0.0.5", "protocol_port": 80, "port_id": "a03648c3-ad65-415b-a47d-d292924dc8e0", "name": "myvip"} volume: 1 message_signature: a5d223d19ad689cc85a915532dfc81d5d1dd5c21d987fee204f13f39e516dd6d message_id: 5bb22bb4-26ec-11e4-9077-000c295e3c02 timestamp: 1408375732.049707 recorded_at: 1408375732.065283 meter_id: 13 source_id: openstack *************************** 2. row *************************** id: 84 user_id: NULL project_id: 05808ee2515e4623ad33420a94500907 resource_id: 0bdd7b5a-b92a-44cb-a351-b7c78938cc3a resource_metadata: {"status": "ACTIVE", "status_description": null, "protocol": "HTTP", "description": "", "admin_state_up": true, "subnet_id": "fd782ef4-c502-46aa-a04e-0ea77e0f23cc", "connection_limit": -1, "pool_id": "648d29af-767a-4cc6-9f0b-2344f7503339", "session_persistence": {"type": "SOURCE_IP"}, "address": "10.0.0.5", "protocol_port": 80, "port_id": "a03648c3-ad65-415b-a47d-d292924dc8e0", "name": "myvip"} volume: 1 message_signature: a5d223d19ad689cc85a915532dfc81d5d1dd5c21d987fee204f13f39e516dd6d message_id: 5bb22bb4-26ec-11e4-9077-000c295e3c02 timestamp: 1408375732.049707 recorded_at: 1408375732.169598 meter_id: 13 source_id: openstack *************************** 3. row *************************** id: 166 user_id: NULL project_id: 05808ee2515e4623ad33420a94500907 resource_id: 0bdd7b5a-b92a-44cb-a351-b7c78938cc3a resource_metadata: {"status": "ACTIVE", "status_description": null, "protocol": "HTTP", "description": "", "admin_state_up": true, "subnet_id": "fd782ef4-c502-46aa-a04e-0ea77e0f23cc", "connection_limit": -1, "pool_id": "648d29af-767a-4cc6-9f0b-2344f7503339", "session_persistence": {"type": "SOURCE_IP"}, "address": "10.0.0.5", "protocol_port": 80, "port_id": "a03648c3-ad65-415b-a47d-d292924dc8e0", "name": "myvip"} volume: 1 message_signature: 8204c3320aa20fc1e1d25bf98fb47af375a576afda9363ef5affee7cc7f1ef12 message_id: 4b0a9d18-26ed-11e4-8521-000c295e3c02 timestamp: 1408376133.604812 recorded_at: 1408376133.625570 meter_id: 13 source_id: openstack *************************** 4. row *************************** id: 167 user_id: NULL project_id: 05808ee2515e4623ad33420a94500907 resource_id: 0bdd7b5a-b92a-44cb-a351-b7c78938cc3a resource_metadata: {"status": "ACTIVE", "status_description": null, "protocol": "HTTP", "description": "", "admin_state_up": true, "subnet_id": "fd782ef4-c502-46aa-a04e-0ea77e0f23cc", "connection_limit": -1, "pool_id": "648d29af-767a-4cc6-9f0b-2344f7503339", "session_persistence": {"type": "SOURCE_IP"}, "address": "10.0.0.5", "protocol_port": 80, "port_id": "a03648c3-ad65-415b-a47d-d292924dc8e0", "name": "myvip"} volume: 1 message_signature: 8204c3320aa20fc1e1d25bf98fb47af375a576afda9363ef5affee7cc7f1ef12 message_id: 4b0a9d18-26ed-11e4-8521-000c295e3c02 timestamp: 1408376133.604812 recorded_at: 1408376133.786031 meter_id: 13 source_id: openstack 4 rows in set (0.00 sec)
where id 13 is network.services.lb.vip
So looks to me like CLI/API is incorrectly showing/returning duplicate rows perhaps.
hmm I verified in the DB and i don't see duplicate samples in mysql. For example,
mysql> select * from sample where meter_id = 13\G; ******* ******* ****** 1. row ******* ******* ******* ****** 3ad33420a945009 07 b92a-44cb- a351-b7c78938cc 3a description" : null, "protocol": "HTTP", "description": "", "admin_state_up": true, "subnet_id": "fd782ef4- c502-46aa- a04e-0ea77e0f23 cc", "connection_limit": -1, "pool_id": "648d29af- 767a-4cc6- 9f0b-2344f75033 39", "session_ persistence" : {"type": "SOURCE_IP"}, "address": "10.0.0.5", "protocol_port": 80, "port_id": "a03648c3- ad65-415b- a47d-d292924dc8 e0", "name": "myvip"} c85a915532dfc81 d5d1dd5c21d987f ee204f13f39e516 dd6d 26ec-11e4- 9077-000c295e3c 02 ******* ******* ****** 2. row ******* ******* ******* ****** 3ad33420a945009 07 b92a-44cb- a351-b7c78938cc 3a description" : null, "protocol": "HTTP", "description": "", "admin_state_up": true, "subnet_id": "fd782ef4- c502-46aa- a04e-0ea77e0f23 cc", "connection_limit": -1, "pool_id": "648d29af- 767a-4cc6- 9f0b-2344f75033 39", "session_ persistence" : {"type": "SOURCE_IP"}, "address": "10.0.0.5", "protocol_port": 80, "port_id": "a03648c3- ad65-415b- a47d-d292924dc8 e0", "name": "myvip"} c85a915532dfc81 d5d1dd5c21d987f ee204f13f39e516 dd6d 26ec-11e4- 9077-000c295e3c 02 ******* ******* ****** 3. row ******* ******* ******* ****** 3ad33420a945009 07 b92a-44cb- a351-b7c78938cc 3a description" : null, "protocol": "HTTP", "description": "", "admin_state_up": true, "subnet_id": "fd782ef4- c502-46aa- a04e-0ea77e0f23 cc", "connection_limit": -1, "pool_id": "648d29af- 767a-4cc6- 9f0b-2344f75033 39", "session_ persistence" : {"type": "SOURCE_IP"}, "address": "10.0.0.5", "protocol_port": 80, "port_id": "a03648c3- ad65-415b- a47d-d292924dc8 e0", "name": "myvip"} 1e1d25bf98fb47a f375a576afda936 3ef5affee7cc7f1 ef12 26ed-11e4- 8521-000c295e3c 02 ******* ******* ****** 4. row ******* ******* ******* ****** 3ad33420a945009 07 b92a-44cb- a351-b7c78938cc 3a description" : null, "protocol": "HTTP", "description": "", "admin_state_up": true, "subnet_id": "fd782ef4- c502-46aa- a04e-0ea77e0f23 cc", "connection_limit": -1, "pool_id": "648d29af- 767a-4cc6- 9f0b-2344f75033 39", "session_ persistence" : {"type": "SOURCE_IP"}, "address": "10.0.0.5", "protocol_port": 80, "port_id": "a03648c3- ad65-415b- a47d-d292924dc8 e0", "name": "myvip"} 1e1d25bf98fb47a f375a576afda936 3ef5affee7cc7f1 ef12 26ed-11e4- 8521-000c295e3c 02
*******
id: 83
user_id: NULL
project_id: 05808ee2515e462
resource_id: 0bdd7b5a-
resource_metadata: {"status": "ACTIVE", "status_
volume: 1
message_signature: a5d223d19ad689c
message_id: 5bb22bb4-
timestamp: 1408375732.049707
recorded_at: 1408375732.065283
meter_id: 13
source_id: openstack
*******
id: 84
user_id: NULL
project_id: 05808ee2515e462
resource_id: 0bdd7b5a-
resource_metadata: {"status": "ACTIVE", "status_
volume: 1
message_signature: a5d223d19ad689c
message_id: 5bb22bb4-
timestamp: 1408375732.049707
recorded_at: 1408375732.169598
meter_id: 13
source_id: openstack
*******
id: 166
user_id: NULL
project_id: 05808ee2515e462
resource_id: 0bdd7b5a-
resource_metadata: {"status": "ACTIVE", "status_
volume: 1
message_signature: 8204c3320aa20fc
message_id: 4b0a9d18-
timestamp: 1408376133.604812
recorded_at: 1408376133.625570
meter_id: 13
source_id: openstack
*******
id: 167
user_id: NULL
project_id: 05808ee2515e462
resource_id: 0bdd7b5a-
resource_metadata: {"status": "ACTIVE", "status_
volume: 1
message_signature: 8204c3320aa20fc
message_id: 4b0a9d18-
timestamp: 1408376133.604812
recorded_at: 1408376133.786031
meter_id: 13
source_id: openstack
4 rows in set (0.00 sec)
where id 13 is network. services. lb.vip
So looks to me like CLI/API is incorrectly showing/returning duplicate rows perhaps.