search

instedd / telemetry_rails

GNU General Public License v3.0
0 stars 1 forks source link

Pollit reports multiple lifespans for an account #105

Closed pmallol closed 8 years ago

pmallol commented 8 years ago

Found in version with last commit [f3b966e482ed6cea349e43965a46034997b05f46]

  1. Open tab Discover in Telemetry-stg
  2. Query: application:pollit AND metric:account_lifespan AND key.account_id:33

Obtained: There are several entries for the same day with different values in key 'dates' also, this appears in the "instedd_telemetry_timespans" table:

mysql> select  key_attributes, count(*) from instedd_telemetry_timespans group by key_attributes;
+-------------------+----------+
| key_attributes    | count(*) |
+-------------------+----------+
| {"account_id":14} |        1 |
| {"account_id":28} |       31 |
| {"account_id":30} |        3 |
| {"account_id":33} |       23 |
| {"account_id":3}  |        1 |
| {"account_id":44} |        1 |
| {"account_id":45} |       23 |
| {"account_id":53} |        1 |
| {"account_id":54} |        1 |
| {"account_id":55} |        2 |
| {"account_id":56} |        2 |
+-------------------+----------+
11 rows in set (0.01 sec)