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

StackOverflowError with RoundRobinResultIterator

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 4.5.0
    • Labels:
      None

      Description

      EVENTS Table has id,article, and more columns. Id is the primay key
      MAPPING Table has id,article,category columns. Id is the primay key
      There is index on article column of both the tables.

      Below is the query.

      select count(MAPPING.article) as cnt,MAPPING.category from EVENTS
      join
      MAPPING on MAPPING.article = EVENTS.article
      group by category order by cnt ;

      Here's the stack trace:

      Error: Encountered exception in sub plan [0] execution. (state=,code=0)
      java.sql.SQLException: Encountered exception in sub plan [0] execution.
              at org.apache.phoenix.execute.HashJoinPlan.iterator(HashJoinPlan.java:156)
              at org.apache.phoenix.jdbc.PhoenixStatement$1.call(PhoenixStatement.java:251)
              at org.apache.phoenix.jdbc.PhoenixStatement$1.call(PhoenixStatement.java:241)
              at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
              at org.apache.phoenix.jdbc.PhoenixStatement.executeQuery(PhoenixStatement.java:240)
              at org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:1250)
              at sqlline.Commands.execute(Commands.java:822)
              at sqlline.Commands.sql(Commands.java:732)
              at sqlline.SqlLine.dispatch(SqlLine.java:808)
              at sqlline.SqlLine.begin(SqlLine.java:681)
              at sqlline.SqlLine.start(SqlLine.java:398)
              at sqlline.SqlLine.main(SqlLine.java:292)
      Caused by: java.lang.StackOverflowError
              at org.apache.phoenix.iterate.RoundRobinResultIterator$RoundRobinIterator.close(RoundRobinResultIterator.java:298)
              at org.apache.phoenix.iterate.RoundRobinResultIterator$RoundRobinIterator.close(RoundRobinResultIterator.java:298)
      

        Attachments

        1. PHOENIX-2074.patch
          6 kB
          Maryann Xue

          Activity

            People

            • Assignee:
              samarthjain Samarth Jain
              Reporter:
              jamestaylor James Taylor
            • Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: