Comment 1 for bug 1357869

Revision history for this message
Pradeep Kilambi (pkilambi) wrote :

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.