968848 - The public ETL seems to have stopped working after 05-Feb-2014 18:09:45 (GMT)

Status: RESOLVED INVALID

(Infrastructure & Operations :: IT-Managed Tools, task)

Description

[Kyle Lahnakoski [:ekyle]]

POST to 

> http://elasticsearch1.bugs.scl3.mozilla.com:9200/public_bugs/bug_version/_search

with content

> {
>   "query": {
>     "match_all": {}
>   },
>   "from": 0,
>   "size": 0,
>   "sort": [],
>   "facets": {
>     "0": {
>       "statistical": {
>         "field": "modified_ts"
>       }
>     }
>   }
> }

results in 

> {
>     took: 2889
>     timed_out: false
>     _shards: {
>         total: 3
>         successful: 3
>         failed: 0
>     }
>     hits: {
>         total: 8123853
>         max_score: 0
>         hits: [ ]
>     }
>     facets: {
>         0: {
>             _type: statistical
>             count: 8123853
>             total: 9824183184848607000
>             min: 779119200000
>             max: 1391702342000
>             mean: 1209300954220.689
>             sum_of_squares: 1.203152748398593e+31
>             variance: 1.8603658154531162e+22
>             std_deviation: 136395227755.70691
>         }
>     }
> }


facet.max == 1391702342000 which is the last updated record.  Unfortunately for me it now reads 06-Feb-2014 15:59:02 (GMT), which is up to date.