You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@phoenix.apache.org by "Bulvik, Noam" <No...@teoco.com> on 2016/01/13 13:22:58 UTC

ORDER BY DESC cause query to hang

Hi,

I am using the phoenix parcel for cloudera 5.4. Seems like there is a bug when query has Order by DESC the query hang for long time and after a while it fail with the following error . without DESC the order by works fine


Caused by: org.apache.phoenix.exception.PhoenixIOException: Failed after attempts=35, exceptions:
Wed Jan 13 09:22:09 IST 2016, org.apache.hadoop.hbase.client.RpcRetryingCaller@2935d8d3, java.io.IOException: java.io.IOException
                at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2069)
                at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:107)
                at org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop(RpcExecutor.java:130)
                at org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor.java:107)
                at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.StackOverflowError
                at org.apache.hadoop.hbase.util.Bytes$LexicographicalComparerHolder$UnsafeComparer.compareTo(Bytes.java:1295)
                at org.apache.hadoop.hbase.util.Bytes.compareTo(Bytes.java:1223)
                at org.apache.hadoop.hbase.CellComparator.compareRows(CellComparator.java:186)
                at org.apache.hadoop.hbase.CellComparator.compare(CellComparator.java:63)
                at org.apache.hadoop.hbase.KeyValue$KVComparator.compare(KeyValue.java:1968)
                at org.apache.hadoop.hbase.KeyValue$KVComparator.compare(KeyValue.java:1897)
                at org.apache.hadoop.hbase.util.Bytes.binarySearch(Bytes.java:1901)
                at org.apache.hadoop.hbase.io.hfile.HFileBlockIndex$BlockIndexReader.rootBlockContainingKey(HFileBlockIndex.java:426)
                at org.apache.hadoop.hbase.io.hfile.HFileBlockIndex$BlockIndexReader.loadDataBlockWithScanInfo(HFileBlockIndex.java:215)
                at org.apache.hadoop.hbase.io.hfile.HFileBlockIndex$BlockIndexReader.seekToDataBlock(HFileBlockIndex.java:182)
                at org.apache.hadoop.hbase.io.hfile.HFileReaderV2$AbstractScannerV2.seekBefore(HFileReaderV2.java:642)
                at org.apache.hadoop.hbase.io.hfile.HFileReaderV2$AbstractScannerV2.seekBefore(HFileReaderV2.java:637)
                at org.apache.hadoop.hbase.regionserver.StoreFileScanner.seekToPreviousRow(StoreFileScanner.java:425)
                at org.apache.hadoop.hbase.regionserver.StoreFileScanner.seekToPreviousRow(StoreFileScanner.java:449)

this worked in previous phoenix version

can you check

regards,
Noam

________________________________

PRIVILEGED AND CONFIDENTIAL
PLEASE NOTE: The information contained in this message is privileged and confidential, and is intended only for the use of the individual to whom it is addressed and others who have been specifically authorized to receive it. If you are not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, or if any problems occur with transmission, please contact sender. Thank you.

Re: ORDER BY DESC cause query to hang

Posted by James Taylor <ja...@apache.org>.
Hi Noam,
Please file a JIRA that includes the Phoenix version, the HBase version,
the DDL, query, and sample data (if needed to repro). It's possible you're
hitting an HBase bug in the reverse scan (HBASE-14155).
Thanks,
James

On Wed, Jan 13, 2016 at 4:22 AM, Bulvik, Noam <No...@teoco.com> wrote:

> Hi,
>
>
>
> I am using the phoenix parcel for cloudera 5.4. Seems like there is a bug
> when query has Order by DESC the query hang for long time and after a while
> it fail with the following error . without DESC the order by works fine
>
>
>
>
>
> Caused by: org.apache.phoenix.exception.PhoenixIOException: Failed after
> attempts=35, exceptions:
>
> Wed Jan 13 09:22:09 IST 2016,
> org.apache.hadoop.hbase.client.RpcRetryingCaller@2935d8d3,
> java.io.IOException: java.io.IOException
>
>                 at
> org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2069)
>
>                 at
> org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:107)
>
>                 at
> org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop(RpcExecutor.java:130)
>
>                 at
> org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor.java:107)
>
>                 at java.lang.Thread.run(Thread.java:745)
>
> Caused by: java.lang.StackOverflowError
>
>                 at
> org.apache.hadoop.hbase.util.Bytes$LexicographicalComparerHolder$UnsafeComparer.compareTo(Bytes.java:1295)
>
>                 at
> org.apache.hadoop.hbase.util.Bytes.compareTo(Bytes.java:1223)
>
>                 at
> org.apache.hadoop.hbase.CellComparator.compareRows(CellComparator.java:186)
>
>                 at
> org.apache.hadoop.hbase.CellComparator.compare(CellComparator.java:63)
>
>                 at
> org.apache.hadoop.hbase.KeyValue$KVComparator.compare(KeyValue.java:1968)
>
>                 at
> org.apache.hadoop.hbase.KeyValue$KVComparator.compare(KeyValue.java:1897)
>
>                 at
> org.apache.hadoop.hbase.util.Bytes.binarySearch(Bytes.java:1901)
>
>                 at
> org.apache.hadoop.hbase.io.hfile.HFileBlockIndex$BlockIndexReader.rootBlockContainingKey(HFileBlockIndex.java:426)
>
>                 at
> org.apache.hadoop.hbase.io.hfile.HFileBlockIndex$BlockIndexReader.loadDataBlockWithScanInfo(HFileBlockIndex.java:215)
>
>                 at
> org.apache.hadoop.hbase.io.hfile.HFileBlockIndex$BlockIndexReader.seekToDataBlock(HFileBlockIndex.java:182)
>
>                 at
> org.apache.hadoop.hbase.io.hfile.HFileReaderV2$AbstractScannerV2.seekBefore(HFileReaderV2.java:642)
>
>                 at
> org.apache.hadoop.hbase.io.hfile.HFileReaderV2$AbstractScannerV2.seekBefore(HFileReaderV2.java:637)
>
>                 at
> org.apache.hadoop.hbase.regionserver.StoreFileScanner.seekToPreviousRow(StoreFileScanner.java:425)
>
>                 at
> org.apache.hadoop.hbase.regionserver.StoreFileScanner.seekToPreviousRow(StoreFileScanner.java:449)
>
>
>
> this worked in previous phoenix version
>
>
>
> can you check
>
>
>
> regards,
>
> Noam
>
> ------------------------------
>
> PRIVILEGED AND CONFIDENTIAL
> PLEASE NOTE: The information contained in this message is privileged and
> confidential, and is intended only for the use of the individual to whom it
> is addressed and others who have been specifically authorized to receive
> it. If you are not the intended recipient, you are hereby notified that any
> dissemination, distribution or copying of this communication is strictly
> prohibited. If you have received this communication in error, or if any
> problems occur with transmission, please contact sender. Thank you.
>