[ 
https://issues.apache.org/jira/browse/PHOENIX-6050?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17289497#comment-17289497
 ] 

chaoWang commented on PHOENIX-6050:
-----------------------------------

oh,thanks big brother ,I know your meaning,or we could provide one new 
parameter?which control scan parallel thead pool .



---Original---
From: "Istvan Toth (Jira)"<j...@apache.org&gt;
Date: Wed, Jan 6, 2021 20:21 PM
To: "576749262"<576749...@qq.com&gt;;
Subject: [jira] [Commented] (PHOENIX-6050) Set properties is invalid



&nbsp;&nbsp;&nbsp; [ 
https://issues.apache.org/jira/browse/PHOENIX-6050?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&amp;focusedCommentId=17259664#comment-17259664
 ] 

Istvan Toth commented on PHOENIX-6050:
--------------------------------------

This has nothing to with using Query Server or not.

If your Phoenix thick client is configured correctly, it has access to the 
cluster's hbase-site.xml, and will pick up the parameter from there.
If you are not doing this already, you need to copy the cluster's 
hbase-site.xml to your client, and it to the classpath.

&gt; Set properties is invalid
&gt; -------------------------
&gt;
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 Key: PHOENIX-6050
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 URL: https://issues.apache.org/jira/browse/PHOENIX-6050
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
Project: Phoenix
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Issue Type: Bug
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Components: core
&gt;&nbsp;&nbsp;&nbsp; Affects Versions: 4.13.1, 5.0.0
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Environment: phoenix 4.13.1
&gt; hbase 1.3.1
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
Reporter: Chao Wang
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
Assignee: Chao Wang
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
Priority: Major
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
Fix For: 5.1.0
&gt;
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Attachments: 
PHOENIX-6050.master.001.patch, PHOENIX-6050.master.002.patch
&gt;
&gt;
&gt; I set properties in client, which are "phoenix.query.threadPoolSize", but 
this is invalid.&nbsp; ThreadPool always use default value (128).&nbsp;
&gt; code is:
&gt; Properties properties = new Properties();
&gt;&nbsp; properties.setProperty("phoenix.query.threadPoolSize","300");
&gt;&nbsp; PropertiesResolve phoenixpr = new PropertiesResolve();
&gt;&nbsp; String phoenixdriver = 
phoenixpr.readMapByKey("com/main/SyncData.properties", "phoenix_driver");
&gt;&nbsp; String phoenixjdbc = 
phoenixpr.readMapByKey("com/main/SyncData.properties", "phoenix_jdbc");
&gt;&nbsp; Class.forName(phoenixdriver);
&gt;&nbsp; return DriverManager.getConnection(phoenixjdbc,properties);
&gt; throw is:
&gt; Error: Task 
org.apache.phoenix.job.JobManager$InstrumentedJobFutureTask@6e91893 rejected 
from org.apache.phoenix.job.JobManager$1@26ae880a[Running, pool size = 128, 
active threads = 128, queued tasks = 5000, completed tasks = 36647] 
(state=08000,code=101)
&gt; org.apache.phoenix.exception.PhoenixIOException: Task 
org.apache.phoenix.job.JobManager$InstrumentedJobFutureTask@6e91893 rejected 
from org.apache.phoenix.job.JobManager$1@26ae880a[Running, pool size = 128, 
active threads = 128, queued tasks = 5000, completed tasks = 36647]
&gt; at 
org.apache.phoenix.util.ServerUtil.parseServerException(ServerUtil.java:120)
&gt; at 
org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:1024)
&gt; at 
org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:916)
&gt; ^Reason:^
&gt; I find PhoenixDriver create threadpool before init config from properties. 
when create threadpool ,&nbsp;&nbsp;config is always default value .



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


> Set properties is invalid
> -------------------------
>
>                 Key: PHOENIX-6050
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-6050
>             Project: Phoenix
>          Issue Type: Bug
>          Components: core
>    Affects Versions: 4.13.1, 5.0.0
>         Environment: phoenix 4.13.1
> hbase 1.3.1
>            Reporter: Chao Wang
>            Assignee: Chao Wang
>            Priority: Major
>             Fix For: 5.1.0
>
>         Attachments: PHOENIX-6050.master.001.patch, 
> PHOENIX-6050.master.002.patch
>
>
> I set properties in client, which are "phoenix.query.threadPoolSize", but 
> this is invalid.  ThreadPool always use default value (128). 
> code is:
> Properties properties = new Properties();
>  properties.setProperty("phoenix.query.threadPoolSize","300");
>  PropertiesResolve phoenixpr = new PropertiesResolve();
>  String phoenixdriver = 
> phoenixpr.readMapByKey("com/main/SyncData.properties", "phoenix_driver");
>  String phoenixjdbc = phoenixpr.readMapByKey("com/main/SyncData.properties", 
> "phoenix_jdbc");
>  Class.forName(phoenixdriver);
>  return DriverManager.getConnection(phoenixjdbc,properties);
> throw is:
> Error: Task 
> org.apache.phoenix.job.JobManager$InstrumentedJobFutureTask@6e91893 rejected 
> from org.apache.phoenix.job.JobManager$1@26ae880a[Running, pool size = 128, 
> active threads = 128, queued tasks = 5000, completed tasks = 36647] 
> (state=08000,code=101)
> org.apache.phoenix.exception.PhoenixIOException: Task 
> org.apache.phoenix.job.JobManager$InstrumentedJobFutureTask@6e91893 rejected 
> from org.apache.phoenix.job.JobManager$1@26ae880a[Running, pool size = 128, 
> active threads = 128, queued tasks = 5000, completed tasks = 36647]
> at 
> org.apache.phoenix.util.ServerUtil.parseServerException(ServerUtil.java:120)
> at 
> org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:1024)
> at 
> org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:916)
> ^Reason:^
> I find PhoenixDriver create threadpool before init config from properties. 
> when create threadpool ,  config is always default value .



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Reply via email to