Uploaded image for project: 'SonarQube'
  1. SonarQube
  2. SONAR-7386

Error while searching issues with non-GMT timezone

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 5.6
    • Component/s: ElasticSearch, Issues
    • Labels:

      Description

      There's an issue with management of timezones on this ES request :

      java.lang.IllegalStateException: Fail to execute ES search request '{"from":0,"size":1,"query":{"filtered":{"query":{"match_all":{}},"filter":{"bool":{"must":[{"terms":{"modulePath":["AVKiqZxi9XPJ9ECYnfqn"]}},{"missing":{"field":"resolution"}},{"has_parent":{"query":{"filtered":{"query":{"match_all":{}},"filter":{"bool":{"must":{"or":{"filters":[{"term":{"users":"admin"}},{"term":{"groups":"Anyone"}},{"term":{"groups":"sonar-users"}},{"term":{"groups":"sonar-administrators"}}]}},"_cache":true}}}},"parent_type":"authorization"}}]}}}},"sort":[{"issueUpdatedAt":{"order":"desc","missing":"_first"}},{"key":{"order":"asc","missing":"_first"}}],"aggregations":{"createdAt":{"date_histogram":{"field":"issueCreatedAt","interval":"1d","min_doc_count":0,"pre_zone":"America/New_York","post_zone":"America/New_York","format":"yyyy-MM-dd'T'HH:mm:ssZ","extended_bounds":{"min":-9223372036854775808,"max":1454429165088}}}}}' on indices '[issues]' on types '[issue]'
      	at org.sonar.server.es.request.ProxySearchRequestBuilder.get(ProxySearchRequestBuilder.java:47) ~[sonar-server-5.4-SNAPSHOT.jar:na]
      	at org.sonar.server.es.request.ProxySearchRequestBuilder.get(ProxySearchRequestBuilder.java:35) ~[sonar-server-5.4-SNAPSHOT.jar:na]
      	at org.sonar.server.issue.index.IssueIndex.search(IssueIndex.java:215) ~[sonar-server-5.4-SNAPSHOT.jar:na]
      	at org.sonar.server.issue.IssueService.search(IssueService.java:319) ~[sonar-server-5.4-SNAPSHOT.jar:na]
      <snip>
      
      Caused by: org.elasticsearch.action.search.SearchPhaseExecutionException: Failed to execute phase [query], all shards failed; shardFailures {[8kLfREt7S3OPznRMIL11CQ][issues][0]: ArithmeticException[Adding time zone offset caused overflow]}{[8kLfREt7S3OPznRMIL11CQ][issues][1]: ArithmeticException[Adding time zone offset caused overflow]}{[8kLfREt7S3OPznRMIL11CQ][issues][2]: ArithmeticException[Adding time zone offset caused overflow]}{[8kLfREt7S3OPznRMIL11CQ][issues][3]: ArithmeticException[Adding time zone offset caused overflow]}{[8kLfREt7S3OPznRMIL11CQ][issues][4]: ArithmeticException[Adding time zone offset caused overflow]}
      	at org.elasticsearch.action.search.type.TransportSearchTypeAction$BaseAsyncAction.onFirstPhaseResult(TransportSearchTypeAction.java:237) ~[elasticsearch-1.7.2.jar:na]
      	at org.elasticsearch.action.search.type.TransportSearchTypeAction$BaseAsyncAction$1.onFailure(TransportSearchTypeAction.java:183) ~[elasticsearch-1.7.2.jar:na]
      	at org.elasticsearch.search.action.SearchServiceTransportAction$23.run(SearchServiceTransportAction.java:565) ~[elasticsearch-1.7.2.jar:na]
      	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [na:1.8.0_72]
      	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [na:1.8.0_72]
      	... 1 common frames omitted
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              simon.brandhof Simon Brandhof (Inactive)
              Reporter:
              simon.brandhof Simon Brandhof (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Due:
                Created:
                Updated:
                Resolved: