On Tue, Sep 20, 2022 at 12:14 PM KhajaAsmath Mohammed < mdkhajaasm...@gmail.com> wrote:
> Hi, > > I am new to phoenix. I am doing simple count(*) on view and it throws me > exception. Select * from table limit 5 works though. Any suggestions on > this please? > > *select count(*) from "prewards_event";* > > Error: Error -1 (00000) : Error while executing SQL "select count(*) from > "prewards_event"": Remote driver error: RuntimeException: > org.apache.phoenix.exception.PhoenixIOException: Task > org.apache.phoenix.job.JobManager$InstrumentedJobFutureTask@4fd9684e > rejected from org.apache.phoenix.job.JobManager$1@32a702c8[Running, pool > size = 128, active threads = 128, queued tasks = 5000, completed tasks = > 102519] -> PhoenixIOException: Task > org.apache.phoenix.job.JobManager$InstrumentedJobFutureTask@4fd9684e > rejected from org.apache.phoenix.job.JobManager$1@32a702c8[Running, pool > size = 128, active threads = 128, queued tasks = 5000, completed tasks = > 102519] -> RejectedExecutionException: Task > org.apache.phoenix.job.JobManager$InstrumentedJobFutureTask@4fd9684e > rejected from org.apache.phoenix.job.JobManager$1@32a702c8[Running, pool > size = 128, active threads = 128, queued tasks = 5000, completed tasks = > 102519] (state=00000,code=-1) > org.apache.phoenix.shaded.org.apache.calcite.avatica.AvaticaSqlException: > Error -1 (00000) : Error while executing SQL "select count(*) from > "prewards_event"": Remote driver error: RuntimeException: > org.apache.phoenix.exception.PhoenixIOException: Task > org.apache.phoenix.job.JobManager$InstrumentedJobFutureTask@4fd9684e > rejected from org.apache.phoenix.job.JobManager$1@32a702c8[Running, pool > size = 128, active threads = 128, queued tasks = 5000, completed tasks = > 102519] -> PhoenixIOException: Task > org.apache.phoenix.job.JobManager$InstrumentedJobFutureTask@4fd9684e > rejected from org.apache.phoenix.job.JobManager$1@32a702c8[Running, pool > size = 128, active threads = 128, queued tasks = 5000, completed tasks = > 102519] -> RejectedExecutionException: Task > org.apache.phoenix.job.JobManager$InstrumentedJobFutureTask@4fd9684e > rejected from org.apache.phoenix.job.JobManager$1@32a702c8[Running, pool > size = 128, active threads = 128, queued tasks = 5000, completed tasks = > 102519] > at > org.apache.phoenix.shaded.org.apache.calcite.avatica.Helper.createException(Helper.java:54) > at > org.apache.phoenix.shaded.org.apache.calcite.avatica.Helper.createException(Helper.java:41) > at > org.apache.phoenix.shaded.org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:163) > at > org.apache.phoenix.shaded.org.apache.calcite.avatica.AvaticaStatement.execute(AvaticaStatement.java:217) > at sqlline.Commands.execute(Commands.java:822) > at sqlline.Commands.sql(Commands.java:732) > at sqlline.SqlLine.dispatch(SqlLine.java:813) > at sqlline.SqlLine.begin(SqlLine.java:686) > at sqlline.SqlLine.start(SqlLine.java:398) > at sqlline.SqlLine.main(SqlLine.java:291) > at > org.apache.phoenix.queryserver.client.SqllineWrapper.main(SqllineWrapper.java:93) > java.lang.RuntimeException: > org.apache.phoenix.exception.PhoenixIOException: Task > org.apache.phoenix.job.JobManager$InstrumentedJobFutureTask@4fd9684e > rejected from org.apache.phoenix.job.JobManager$1@32a702c8[Running, pool > size = 128, active threads = 128, queued tasks = 5000, completed tasks = > 102519] > at > org.apache.calcite.avatica.jdbc.JdbcResultSet.create(JdbcResultSet.java:109) > at > org.apache.calcite.avatica.jdbc.JdbcResultSet.create(JdbcResultSet.java:81) > at > org.apache.calcite.avatica.jdbc.JdbcMeta.prepareAndExecute(JdbcMeta.java:759) > at > org.apache.calcite.avatica.remote.LocalService.apply(LocalService.java:206) > at > org.apache.calcite.avatica.remote.Service$PrepareAndExecuteRequest.accept(Service.java:927) > at > org.apache.calcite.avatica.remote.Service$PrepareAndExecuteRequest.accept(Service.java:879) > at > org.apache.calcite.avatica.remote.AbstractHandler.apply(AbstractHandler.java:94) > at > org.apache.calcite.avatica.remote.ProtobufHandler.apply(ProtobufHandler.java:46) > at > org.apache.calcite.avatica.server.AvaticaProtobufHandler.handle(AvaticaProtobufHandler.java:127) > at > org.apache.phoenix.shaded.org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:52) >
