You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@phoenix.apache.org by Serega Sheypak <se...@gmail.com> on 2015/10/06 18:16:30 UTC
Can't understand reason for rejected from org.apache.phoenix.job.JobManager:
Running, pool size = 128, active threads = 128, queued tasks = 5000,
completed tasks = 204
Hi, found smth similar here:
http://mail-archives.apache.org/mod_mbox/phoenix-user/201501.mbox/%3CCAAF1Jdg-E4=54e5dC3WazL=MVUe8C93E4zoHobiYWaOVs86TCA@mail.gmail.com%3E
My queries are:
1. insert into TABLE(KEY_COL, A, B,C) values(?, ?,?,?)
2. select A, B, C, KEY_COL from TABLE where KEY_COL=?
Why do I get so huge queue?
Re: Can't understand reason for rejected from org.apache.phoenix.job.JobManager:
Running, pool size = 128, active threads = 128, queued tasks = 5000,
completed tasks = 204
Posted by Serega Sheypak <se...@gmail.com>.
I'm using 4.3.0-clabs-phoenix-1.0.0 (phoenix for CDH)
2015-10-06 20:41 GMT+02:00 Serega Sheypak <se...@gmail.com>:
> Hi, It's web-app.
> There are many concurrent web-threads (100 per app). Each thread:
> 1. create connection
> 2. execute statement
> 3. close statement
> 4. close connection.
> Nothing is shared.
>
> I have 20K requests per minute. It's basically nothing.
> Previous pure HBase implementation didn't have such problems.
>
>
>
> 2015-10-06 18:52 GMT+02:00 Samarth Jain <sa...@apache.org>:
>
>> Sergea, any chance you have other queries concurrently executing on the
>> client? What version of Phoenix you are on?
>>
>>
>> On Tuesday, October 6, 2015, Serega Sheypak <se...@gmail.com>
>> wrote:
>>
>>> Hi, found smth similar here:
>>>
>>> http://mail-archives.apache.org/mod_mbox/phoenix-user/201501.mbox/%3CCAAF1Jdg-E4=54e5dC3WazL=MVUe8C93E4zoHobiYWaOVs86TCA@mail.gmail.com%3E
>>>
>>>
>>> My queries are:
>>> 1. insert into TABLE(KEY_COL, A, B,C) values(?, ?,?,?)
>>> 2. select A, B, C, KEY_COL from TABLE where KEY_COL=?
>>>
>>> Why do I get so huge queue?
>>>
>>
>
Re: Can't understand reason for rejected from org.apache.phoenix.job.JobManager:
Running, pool size = 128, active threads = 128, queued tasks = 5000,
completed tasks = 204
Posted by Serega Sheypak <se...@gmail.com>.
Hi, It's web-app.
There are many concurrent web-threads (100 per app). Each thread:
1. create connection
2. execute statement
3. close statement
4. close connection.
Nothing is shared.
I have 20K requests per minute. It's basically nothing.
Previous pure HBase implementation didn't have such problems.
2015-10-06 18:52 GMT+02:00 Samarth Jain <sa...@apache.org>:
> Sergea, any chance you have other queries concurrently executing on the
> client? What version of Phoenix you are on?
>
>
> On Tuesday, October 6, 2015, Serega Sheypak <se...@gmail.com>
> wrote:
>
>> Hi, found smth similar here:
>>
>> http://mail-archives.apache.org/mod_mbox/phoenix-user/201501.mbox/%3CCAAF1Jdg-E4=54e5dC3WazL=MVUe8C93E4zoHobiYWaOVs86TCA@mail.gmail.com%3E
>>
>>
>> My queries are:
>> 1. insert into TABLE(KEY_COL, A, B,C) values(?, ?,?,?)
>> 2. select A, B, C, KEY_COL from TABLE where KEY_COL=?
>>
>> Why do I get so huge queue?
>>
>
Re: Can't understand reason for rejected from org.apache.phoenix.job.JobManager:
Running, pool size = 128, active threads = 128, queued tasks = 5000,
completed tasks = 204
Posted by Samarth Jain <sa...@apache.org>.
Sergea, any chance you have other queries concurrently executing on the
client? What version of Phoenix you are on?
On Tuesday, October 6, 2015, Serega Sheypak <se...@gmail.com>
wrote:
> Hi, found smth similar here:
>
> http://mail-archives.apache.org/mod_mbox/phoenix-user/201501.mbox/%3CCAAF1Jdg-E4=54e5dC3WazL=MVUe8C93E4zoHobiYWaOVs86TCA@mail.gmail.com%3E
>
>
> My queries are:
> 1. insert into TABLE(KEY_COL, A, B,C) values(?, ?,?,?)
> 2. select A, B, C, KEY_COL from TABLE where KEY_COL=?
>
> Why do I get so huge queue?
>