Re: Is it possible to repair a single partition.

[Pranay akula]

Yeah i am running with paging on, and the output rows returned are not
consistent the max rows i got returned is 7 and i am running with tracing
on and i don't see any tombstones as well. Hpw can i determine if my
partition is large or not ??

 i was able to figure out the token from one node and traced which other
nodes are containing that partiton and started running repair, hopefully
that fixes it.



Thanks
pranay.

On Tue, Jun 27, 2017 at 3:28 PM, benjamin roth  wrote:

Then the partition is too big or has too many sstables that contain data
> for that partition so that the query times out. You can run a manual
> compaction on that table. That helped me several times.
>
> + I hope you are not trying to read that parition at once. Please use
> paging to query large partitions.
>
> 2017-06-27 21:25 GMT+02:00 Pranay akula :
>
>> Hi Jonathan,
>> I tried multiple times running the query at consistency all, every time i
>> run it i getting the same output that co-ordinator is timing out. I can see
>> it wasn't helping much there were multiple read repair drops. Is there any
>> other way to get that partition fixed ??
>>
>>
>> Thanks
>> Pranay.
>>
>>
>> On Tue, Jun 27, 2017 at 3:13 PM, Jonathan Haddad 
>> wrote:
>>
>>> Query it at consistency ALL and let read repair do its thing.
>>> On Tue, Jun 27, 2017 at 11:48 AM Pranay akula <
>>> pranay.akula2...@gmail.com> wrote:
>>>
 I have a CF with composite partition key, partition key consists of
 blob and text data types.
 The select query against this particular partition is timing out so to
 debug it further i ran nodetool getendpoints i am getting error like below

 error: Non-hex characters in 0xbbdcbf21ffb72115599ca915634fcb85
 -- StackTrace --
 java.lang.NumberFormatException: Non-hex characters in
 0xbbdcbf21ffb72115599ca915634fcb85


 so how can i get the endpoints for that particular partition and token
 as well to run repairs to that token range.







 Thanks
 Pranay.

>>>
>>
>

Re: Is it possible to repair a single partition.

[benjamin roth]

Then the partition is too big or has too many sstables that contain data
for that partition so that the query times out. You can run a manual
compaction on that table. That helped me several times.

+ I hope you are not trying to read that parition at once. Please use
paging to query large partitions.

2017-06-27 21:25 GMT+02:00 Pranay akula :

> Hi Jonathan,
> I tried multiple times running the query at consistency all, every time i
> run it i getting the same output that co-ordinator is timing out. I can see
> it wasn't helping much there were multiple read repair drops. Is there any
> other way to get that partition fixed ??
>
>
> Thanks
> Pranay.
>
>
> On Tue, Jun 27, 2017 at 3:13 PM, Jonathan Haddad 
> wrote:
>
>> Query it at consistency ALL and let read repair do its thing.
>> On Tue, Jun 27, 2017 at 11:48 AM Pranay akula 
>> wrote:
>>
>>> I have a CF with composite partition key, partition key consists of blob
>>> and text data types.
>>> The select query against this particular partition is timing out so to
>>> debug it further i ran nodetool getendpoints i am getting error like below
>>>
>>> error: Non-hex characters in 0xbbdcbf21ffb72115599ca915634fcb85
>>> -- StackTrace --
>>> java.lang.NumberFormatException: Non-hex characters in
>>> 0xbbdcbf21ffb72115599ca915634fcb85
>>>
>>>
>>> so how can i get the endpoints for that particular partition and token
>>> as well to run repairs to that token range.
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> Thanks
>>> Pranay.
>>>
>>
>

Re: Is it possible to repair a single partition.

[Pranay akula]

Hi Jonathan,
I tried multiple times running the query at consistency all, every time i
run it i getting the same output that co-ordinator is timing out. I can see
it wasn't helping much there were multiple read repair drops. Is there any
other way to get that partition fixed ??


Thanks
Pranay.


On Tue, Jun 27, 2017 at 3:13 PM, Jonathan Haddad  wrote:

> Query it at consistency ALL and let read repair do its thing.
> On Tue, Jun 27, 2017 at 11:48 AM Pranay akula 
> wrote:
>
>> I have a CF with composite partition key, partition key consists of blob
>> and text data types.
>> The select query against this particular partition is timing out so to
>> debug it further i ran nodetool getendpoints i am getting error like below
>>
>> error: Non-hex characters in 0xbbdcbf21ffb72115599ca915634fcb85
>> -- StackTrace --
>> java.lang.NumberFormatException: Non-hex characters in
>> 0xbbdcbf21ffb72115599ca915634fcb85
>>
>>
>> so how can i get the endpoints for that particular partition and token as
>> well to run repairs to that token range.
>>
>>
>>
>>
>>
>>
>>
>> Thanks
>> Pranay.
>>
>

Re: Is it possible to repair a single partition.

[Jonathan Haddad]

Query it at consistency ALL and let read repair do its thing.
On Tue, Jun 27, 2017 at 11:48 AM Pranay akula 
wrote:

> I have a CF with composite partition key, partition key consists of blob
> and text data types.
> The select query against this particular partition is timing out so to
> debug it further i ran nodetool getendpoints i am getting error like below
>
> error: Non-hex characters in 0xbbdcbf21ffb72115599ca915634fcb85
> -- StackTrace --
> java.lang.NumberFormatException: Non-hex characters in
> 0xbbdcbf21ffb72115599ca915634fcb85
>
>
> so how can i get the endpoints for that particular partition and token as
> well to run repairs to that token range.
>
>
>
>
>
>
>
> Thanks
> Pranay.
>

Is it possible to repair a single partition.

[Pranay akula]

I have a CF with composite partition key, partition key consists of blob
and text data types.
The select query against this particular partition is timing out so to
debug it further i ran nodetool getendpoints i am getting error like below

error: Non-hex characters in 0xbbdcbf21ffb72115599ca915634fcb85
-- StackTrace --
java.lang.NumberFormatException: Non-hex characters in
0xbbdcbf21ffb72115599ca915634fcb85


so how can i get the endpoints for that particular partition and token as
well to run repairs to that token range.







Thanks
Pranay.