Hi Sun, I believe this means you have exhausted the thread pool and the queue that buffers the tasks to service Phoenix queries. Each query will have different characteristics in terms of the level of parallelism that Phoenix will use to service that query. For example some queries require few (or 1) tasks, such as a query with LIMIT 10, other queries that hit many regions and guideposts require a higher number of tasks. As you use up the queue and get near the max some queries may run if they are enough slots left in the queue to service it. So queries requiring a low number of slots like a LIMIT 10 query might run but others won't.
Hope this helps. --Jan On Wed, Jan 28, 2015 at 6:44 PM, [email protected] < [email protected]> wrote: > Hi, all > > I got strange exception hints when doing query like SELECT COUNT(*) FROM > SOME_TABLE; through sqlline and the info is > > java.lang.RuntimeException: > org.apache.phoenix.exception.PhoenixIOException: Task > org.apache.phoenix.job.JobManager$JobFutureTask@f55dfff rejected from > > > org.apache.phoenix.job.JobManager$1@165e96e[Running, pool size = 64, > active threads = 64, queued tasks = 5000, completed tasks = 5162] > > at sqlline.SqlLine$IncrementalRows.hasNext(SqlLine.java:2440) > at sqlline.SqlLine$TableOutputFormat.print(SqlLine.java:2074) > at sqlline.SqlLine.print(SqlLine.java:1735) > at sqlline.SqlLine$Commands.execute(SqlLine.java:3683) > at sqlline.SqlLine$Commands.sql(SqlLine.java:3584) > at sqlline.SqlLine.dispatch(SqlLine.java:821) > at sqlline.SqlLine.begin(SqlLine.java:699) > at sqlline.SqlLine.mainWithInputRedirection(SqlLine.java:441) > at sqlline.SqlLine.main(SqlLine.java:424) > > > However, such query like SELECT * FROM SOME_TABLE LIMIT 10 works. Also, > other table count query works too. Don't know what causes this kind of > issue. Any > available hints are appreciated. > > Thanks, > Sun. > > > > > ------------------------------ > ------------------------------ > > CertusNet > > >
