You can try to increase phoenix.query.threadPoolSize & phoenix.query.queueSize in client side configuration file hbase-site.xml. More details you can check http://phoenix.apache.org/tuning.html.
Thanks, -Jeffrey On 10/9/14, 3:56 PM, "Mike Friedman" <[email protected]> wrote: >Hi, > >Using HBase, can use a Phoenix table fine. But as the table's size has >grown to 200M rows, Phoenix JDBC clients now always get an error message. >Here is what we get when we double-click on the table in DB Visualizer: > >An error occurred while executing the database request for: >Phoenix >4.0 >org.apache.phoenix.jdbc.PhoenixDriver >4.0 > >Short message: >An error occurred while performing the operation: >Task org.apache.phoenix.job.JobManager$JobFutureTask@1dbbd6ac rejected >from org.apache.phoenix.job.JobManager$1@170ac574[Running, pool size = >128, active threads = 128, queued tasks = 500, completed tasks = 250] > >The command that caused the problem: >Get result set > >Long Message: >Task org.apache.phoenix.job.JobManager$JobFutureTask@1dbbd6ac rejected >from org.apache.phoenix.job.JobManager$1@170ac574[Running, pool size = >128, active threads = 128, queued tasks = 500, completed tasks = 250] > >Details: > Type: org.apache.phoenix.exception.PhoenixIOException > Error Code: 101 > SQL State: 08000 > >System Information: >Product: DbVisualizer Pro 9.1.10 >Build: #2295 (2014-08-08 18:38:31) >Java VM: Java HotSpot(TM) 64-Bit Server VM > >Java Version: 1.7.0_67 >Java Vendor: Oracle Corporation >OS Name: Windows Server 2008 R2 >OS Arch: amd64 >OS Version: 6.1 > > >We get the same result with Squirrel SQL client. > > > >Mike -- CONFIDENTIALITY NOTICE NOTICE: This message is intended for the use of the individual or entity to which it is addressed and may contain information that is confidential, privileged and exempt from disclosure under applicable law. If the reader of this message is not the intended recipient, you are hereby notified that any printing, copying, dissemination, distribution, disclosure or forwarding of this communication is strictly prohibited. If you have received this communication in error, please contact the sender immediately and delete it from your system. Thank You.
