Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-1463

phoenix.query.timeoutMs doesn't work as expected

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 4.2.0
    • 4.3.0, 3.3.0, 3.2.2, 4.2.2
    • None
    • None

    Description

      In doing performance testing with Phoenix I noticed that under heavy load we saw queries taking as long as 300 secs even though we had set phoenix.query.timeoutMs to 120 secs. It looks like the timeout is applied when the parent thread waits for all the parallel scans to complete. Each time we call rs.next() and need a to load a new chunk of data from HBase we again run parallel scans with a new 120 sec timeout. Therefore total query time could be timeout * # chunks scanned. I think it would be more intuitive if the query timeout applied to the query as a whole versus resetting for each chunk.

      Attachments

        1. PHOENIX-1463.patch
          10 kB
          Samarth Jain
        2. PHOENIX-1463_v5.patch
          10 kB
          Samarth Jain
        3. PHOENIX-1463_v4.patch
          9 kB
          Samarth Jain
        4. PHOENIX-1463_v3.patch
          8 kB
          Samarth Jain
        5. PHOENIX-1463_v2.patch
          9 kB
          Samarth Jain

        Activity

          People

            samarthjain Samarth Jain
            jfernando_sfdc Jan Fernando
            Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: