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 <pranay.akula2...@gmail.com>: > 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 <j...@jonhaddad.com> > 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. >>> >> >
