From dev-return-54438-archive-asf-public=cust-asf.ponee.io@phoenix.apache.org Wed Oct 31 01:46:10 2018 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by mx-eu-01.ponee.io (Postfix) with SMTP id EE53A180652 for ; Wed, 31 Oct 2018 01:46:08 +0100 (CET) Received: (qmail 63810 invoked by uid 500); 31 Oct 2018 00:46:08 -0000 Mailing-List: contact dev-help@phoenix.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@phoenix.apache.org Delivered-To: mailing list dev@phoenix.apache.org Received: (qmail 63799 invoked by uid 99); 31 Oct 2018 00:46:07 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 31 Oct 2018 00:46:07 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id 670A519398B for ; Wed, 31 Oct 2018 00:46:07 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -110.301 X-Spam-Level: X-Spam-Status: No, score=-110.301 tagged_above=-999 required=6.31 tests=[ENV_AND_HDR_SPF_MATCH=-0.5, RCVD_IN_DNSWL_MED=-2.3, SPF_PASS=-0.001, USER_IN_DEF_SPF_WL=-7.5, USER_IN_WHITELIST=-100] autolearn=disabled Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id M7zsNsdppIaT for ; Wed, 31 Oct 2018 00:46:03 +0000 (UTC) Received: from mailrelay1-us-west.apache.org (mailrelay1-us-west.apache.org [209.188.14.139]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTP id 143C15F58F for ; Wed, 31 Oct 2018 00:46:02 +0000 (UTC) Received: from jira-lw-us.apache.org (unknown [207.244.88.139]) by mailrelay1-us-west.apache.org (ASF Mail Server at mailrelay1-us-west.apache.org) with ESMTP id 1545AE00E0 for ; Wed, 31 Oct 2018 00:46:01 +0000 (UTC) Received: from jira-lw-us.apache.org (localhost [127.0.0.1]) by jira-lw-us.apache.org (ASF Mail Server at jira-lw-us.apache.org) with ESMTP id A223E27764 for ; Wed, 31 Oct 2018 00:46:00 +0000 (UTC) Date: Wed, 31 Oct 2018 00:46:00 +0000 (UTC) From: "Xu Cang (JIRA)" To: dev@phoenix.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Updated] (PHOENIX-4830) order by primary key desc return wrong results MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/PHOENIX-4830?page=3Dcom.atlass= ian.jira.plugin.system.issuetabpanels:all-tabpanel ] Xu Cang updated PHOENIX-4830: ----------------------------- Attachment: PHOENIX-4830-4.x-HBase-1.3.007.patch > order by primary key desc return wrong results > ---------------------------------------------- > > Key: PHOENIX-4830 > URL: https://issues.apache.org/jira/browse/PHOENIX-4830 > Project: Phoenix > Issue Type: Bug > Affects Versions: 4.14.0 > Environment: phoenix-4.14-hbase-1.2 > Reporter: JieChen > Assignee: Xu Cang > Priority: Major > Labels: DESC > Attachments: PHOENIX-4830-4.x-HBase-1.3.001.patch, PHOENIX-4830-4= .x-HBase-1.3.002.patch, PHOENIX-4830-4.x-HBase-1.3.003.patch, PHOENIX-4830-= 4.x-HBase-1.3.004.patch, PHOENIX-4830-4.x-HBase-1.3.005.patch, PHOENIX-4830= -4.x-HBase-1.3.006.patch, PHOENIX-4830-4.x-HBase-1.3.007.patch > > > {code:java} > 0: jdbc:phoenix:localhost>=C2=A0 create table test(id bigint not null pri= mary key, a bigint); > No rows affected (1.242 seconds) > 0: jdbc:phoenix:localhost> upsert into test values(1,11); > 1 row affected (0.01 seconds) > 0: jdbc:phoenix:localhost> upsert into test values(2,22); > 1 row affected (0.007 seconds) > 0: jdbc:phoenix:localhost> upsert into test values(3,33); > 1 row affected (0.005 seconds) > 0: jdbc:phoenix:localhost> select * from test; > +-----+-----+ > | ID=C2=A0 |=C2=A0 A=C2=A0 | > +-----+-----+ > | 1=C2=A0 =C2=A0| 11=C2=A0 | > | 2=C2=A0 =C2=A0| 22=C2=A0 | > | 3=C2=A0 =C2=A0| 33=C2=A0 | > +-----+-----+ > 3 rows selected (0.015 seconds) > 0: jdbc:phoenix:localhost> select * from test order by id desc limit 2 of= fset 0; > +-----+-----+ > | ID=C2=A0 |=C2=A0 A=C2=A0 | > +-----+-----+ > | 3=C2=A0 =C2=A0| 33=C2=A0 | > | 2=C2=A0 =C2=A0| 22=C2=A0 | > +-----+-----+ > 2 rows selected (0.018 seconds) > 0: jdbc:phoenix:localhost> select * from test where id in (select id from= test ) order by id desc limit 2 offset 0; > +-----+-----+ > | ID=C2=A0 |=C2=A0 A=C2=A0 | > +-----+-----+ > | 2=C2=A0 =C2=A0| 22=C2=A0 | > | 1=C2=A0 =C2=A0| 11=C2=A0 | > +-----+-----+ > wrong results.=C2=A0 > {code} > there may be some=C2=A0errors. ScanUtil.setupReverseScan code. > =C2=A0then > {code:java} > 0: jdbc:phoenix:localhost> upsert into test values(4,33); > 1 row affected (0.005 seconds) > 0: jdbc:phoenix:localhost> upsert into test values(5,23); > 1 row affected (0.005 seconds) > 0: jdbc:phoenix:localhost> upsert into test values(6,23); > 1 row affected (0.005 seconds) > 0: jdbc:phoenix:localhost> upsert into test values(7,33); > 1 row affected (0.006 seconds) > {code} > execute sql > {code:java} > select * from test where id in (select id from test where a=3D33) order b= y id desc; > {code} > throw exception > {code:java} > Error: org.apache.phoenix.exception.PhoenixIOException: org.apache.hadoop= .hbase.DoNotRetryIOException: TEST,,1533266754845.b8e521d4dc8e8b8f18c69cc7e= f76973d.: The next hint must come after previous hint (prev=3D\x80\x00\x00\= x00\x00\x00\x00\x07//LATEST_TIMESTAMP/Maximum/vlen=3D0/seqid=3D0, next=3D\x= 80\x00\x00\x00\x00\x00\x00\x07//LATEST_TIMESTAMP/Maximum/vlen=3D0/seqid=3D0= , kv=3D\x80\x00\x00\x00\x00\x00\x00\x06/0:\x00\x00\x00\x00/1533266778944/Pu= t/vlen=3D1/seqid=3D9) > at org.apache.phoenix.util.ServerUtil.createIOException(ServerUtil.java:9= 6) > at org.apache.phoenix.util.ServerUtil.throwIOException(ServerUtil.java:62= ) > at org.apache.phoenix.iterate.RegionScannerFactory$1.nextRaw(RegionScanne= rFactory.java:212) > at org.apache.phoenix.coprocessor.HashJoinRegionScanner.nextRaw(HashJoinR= egionScanner.java:264) > at org.apache.phoenix.coprocessor.DelegateRegionScanner.nextRaw(DelegateR= egionScanner.java:82) > at org.apache.phoenix.coprocessor.DelegateRegionScanner.nextRaw(DelegateR= egionScanner.java:82) > at org.apache.phoenix.coprocessor.BaseScannerRegionObserver$RegionScanner= Holder.nextRaw(BaseScannerRegionObserver.java:293) > at org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.= java:2541) > at org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$= 2.callBlockingMethod(ClientProtos.java:33648) > at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2183) > at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:112) > at org.apache.hadoop.hbase.ipc.RpcExecutor$Handler.run(RpcExecutor.java:1= 83) > at org.apache.hadoop.hbase.ipc.RpcExecutor$Handler.run(RpcExecutor.java:1= 63) > Caused by: java.lang.IllegalStateException: The next hint must come after= previous hint (prev=3D\x80\x00\x00\x00\x00\x00\x00\x07//LATEST_TIMESTAMP/M= aximum/vlen=3D0/seqid=3D0, next=3D\x80\x00\x00\x00\x00\x00\x00\x07//LATEST_= TIMESTAMP/Maximum/vlen=3D0/seqid=3D0, kv=3D\x80\x00\x00\x00\x00\x00\x00\x06= /0:\x00\x00\x00\x00/1533266778944/Put/vlen=3D1/seqid=3D9) > at org.apache.phoenix.filter.SkipScanFilter.setNextCellHint(SkipScanFilte= r.java:171) > at org.apache.phoenix.filter.SkipScanFilter.filterKeyValue(SkipScanFilter= .java:145) > at org.apache.hadoop.hbase.regionserver.ScanQueryMatcher.match(ScanQueryM= atcher.java:427) > at org.apache.hadoop.hbase.regionserver.StoreScanner.next(StoreScanner.ja= va:529) > at org.apache.hadoop.hbase.regionserver.KeyValueHeap.next(KeyValueHeap.ja= va:147) > at org.apache.hadoop.hbase.regionserver.HRegion$RegionScannerImpl.populat= eResult(HRegion.java:5735) > at org.apache.hadoop.hbase.regionserver.HRegion$RegionScannerImpl.nextInt= ernal(HRegion.java:5891) > at org.apache.hadoop.hbase.regionserver.HRegion$RegionScannerImpl.nextRaw= (HRegion.java:5669) > at org.apache.hadoop.hbase.regionserver.HRegion$RegionScannerImpl.nextRaw= (HRegion.java:5654) > at org.apache.phoenix.iterate.RegionScannerFactory$1.nextRaw(RegionScanne= rFactory.java:175) > ... 10 more (state=3D08000,code=3D101) > org.apache.phoenix.exception.PhoenixIOException: org.apache.phoenix.excep= tion.PhoenixIOException: org.apache.hadoop.hbase.DoNotRetryIOException: TES= T,,1533266754845.b8e521d4dc8e8b8f18c69cc7ef76973d.: The next hint must come= after previous hint (prev=3D\x80\x00\x00\x00\x00\x00\x00\x07//LATEST_TIMES= TAMP/Maximum/vlen=3D0/seqid=3D0, next=3D\x80\x00\x00\x00\x00\x00\x00\x07//L= ATEST_TIMESTAMP/Maximum/vlen=3D0/seqid=3D0, kv=3D\x80\x00\x00\x00\x00\x00\x= 00\x06/0:\x00\x00\x00\x00/1533266778944/Put/vlen=3D1/seqid=3D9) > at org.apache.phoenix.util.ServerUtil.createIOException(ServerUtil.java:9= 6) > at org.apache.phoenix.util.ServerUtil.throwIOException(ServerUtil.java:62= ) > at org.apache.phoenix.iterate.RegionScannerFactory$1.nextRaw(RegionScanne= rFactory.java:212) > at org.apache.phoenix.coprocessor.HashJoinRegionScanner.nextRaw(HashJoinR= egionScanner.java:264) > at org.apache.phoenix.coprocessor.DelegateRegionScanner.nextRaw(DelegateR= egionScanner.java:82) > at org.apache.phoenix.coprocessor.DelegateRegionScanner.nextRaw(DelegateR= egionScanner.java:82) > at org.apache.phoenix.coprocessor.BaseScannerRegionObserver$RegionScanner= Holder.nextRaw(BaseScannerRegionObserver.java:293) > at org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.= java:2541) > at org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$= 2.callBlockingMethod(ClientProtos.java:33648) > at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2183) > at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:112) > at org.apache.hadoop.hbase.ipc.RpcExecutor$Handler.run(RpcExecutor.java:1= 83) > at org.apache.hadoop.hbase.ipc.RpcExecutor$Handler.run(RpcExecutor.java:1= 63) > Caused by: java.lang.IllegalStateException: The next hint must come after= previous hint (prev=3D\x80\x00\x00\x00\x00\x00\x00\x07//LATEST_TIMESTAMP/M= aximum/vlen=3D0/seqid=3D0, next=3D\x80\x00\x00\x00\x00\x00\x00\x07//LATEST_= TIMESTAMP/Maximum/vlen=3D0/seqid=3D0, kv=3D\x80\x00\x00\x00\x00\x00\x00\x06= /0:\x00\x00\x00\x00/1533266778944/Put/vlen=3D1/seqid=3D9) > at org.apache.phoenix.filter.SkipScanFilter.setNextCellHint(SkipScanFilte= r.java:171) > at org.apache.phoenix.filter.SkipScanFilter.filterKeyValue(SkipScanFilter= .java:145) > at org.apache.hadoop.hbase.regionserver.ScanQueryMatcher.match(ScanQueryM= atcher.java:427) > at org.apache.hadoop.hbase.regionserver.StoreScanner.next(StoreScanner.ja= va:529) > at org.apache.hadoop.hbase.regionserver.KeyValueHeap.next(KeyValueHeap.ja= va:147) > at org.apache.hadoop.hbase.regionserver.HRegion$RegionScannerImpl.populat= eResult(HRegion.java:5735) > at org.apache.hadoop.hbase.regionserver.HRegion$RegionScannerImpl.nextInt= ernal(HRegion.java:5891) > at org.apache.hadoop.hbase.regionserver.HRegion$RegionScannerImpl.nextRaw= (HRegion.java:5669) > at org.apache.hadoop.hbase.regionserver.HRegion$RegionScannerImpl.nextRaw= (HRegion.java:5654) > at org.apache.phoenix.iterate.RegionScannerFactory$1.nextRaw(RegionScanne= rFactory.java:175) > ... 10 more > at org.apache.phoenix.util.ServerUtil.parseServerException(ServerUtil.jav= a:120) > at org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResult= Iterators.java:970) > at org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResult= Iterators.java:912) > at org.apache.phoenix.iterate.ConcatResultIterator.getIterators(ConcatRes= ultIterator.java:50) > at org.apache.phoenix.iterate.ConcatResultIterator.currentIterator(Concat= ResultIterator.java:97) > at org.apache.phoenix.iterate.ConcatResultIterator.next(ConcatResultItera= tor.java:117) > at org.apache.phoenix.jdbc.PhoenixResultSet.next(PhoenixResultSet.java:77= 9) > at sqlline.BufferedRows.(BufferedRows.java:37) > at sqlline.SqlLine.print(SqlLine.java:1660) > at sqlline.Commands.execute(Commands.java:833) > at sqlline.Commands.sql(Commands.java:732) > at sqlline.SqlLine.dispatch(SqlLine.java:813) > at sqlline.SqlLine.begin(SqlLine.java:686) > at sqlline.SqlLine.start(SqlLine.java:398) > at sqlline.SqlLine.main(SqlLine.java:291) > Caused by: java.util.concurrent.ExecutionException: org.apache.phoenix.ex= ception.PhoenixIOException: org.apache.hadoop.hbase.DoNotRetryIOException: = TEST,,1533266754845.b8e521d4dc8e8b8f18c69cc7ef76973d.: The next hint must c= ome after previous hint (prev=3D\x80\x00\x00\x00\x00\x00\x00\x07//LATEST_TI= MESTAMP/Maximum/vlen=3D0/seqid=3D0, next=3D\x80\x00\x00\x00\x00\x00\x00\x07= //LATEST_TIMESTAMP/Maximum/vlen=3D0/seqid=3D0, kv=3D\x80\x00\x00\x00\x00\x0= 0\x00\x06/0:\x00\x00\x00\x00/1533266778944/Put/vlen=3D1/seqid=3D9) > at org.apache.phoenix.util.ServerUtil.createIOException(ServerUtil.java:9= 6) > at org.apache.phoenix.util.ServerUtil.throwIOException(ServerUtil.java:62= ) > at org.apache.phoenix.iterate.RegionScannerFactory$1.nextRaw(RegionScanne= rFactory.java:212) > at org.apache.phoenix.coprocessor.HashJoinRegionScanner.nextRaw(HashJoinR= egionScanner.java:264) > at org.apache.phoenix.coprocessor.DelegateRegionScanner.nextRaw(DelegateR= egionScanner.java:82) > at org.apache.phoenix.coprocessor.DelegateRegionScanner.nextRaw(DelegateR= egionScanner.java:82) > at org.apache.phoenix.coprocessor.BaseScannerRegionObserver$RegionScanner= Holder.nextRaw(BaseScannerRegionObserver.java:293) > at org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.= java:2541) > at org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$= 2.callBlockingMethod(ClientProtos.java:33648) > at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2183) > at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:112) > at org.apache.hadoop.hbase.ipc.RpcExecutor$Handler.run(RpcExecutor.java:1= 83) > at org.apache.hadoop.hbase.ipc.RpcExecutor$Handler.run(RpcExecutor.java:1= 63) > Caused by: java.lang.IllegalStateException: The next hint must come after= previous hint (prev=3D\x80\x00\x00\x00\x00\x00\x00\x07//LATEST_TIMESTAMP/M= aximum/vlen=3D0/seqid=3D0, next=3D\x80\x00\x00\x00\x00\x00\x00\x07//LATEST_= TIMESTAMP/Maximum/vlen=3D0/seqid=3D0, kv=3D\x80\x00\x00\x00\x00\x00\x00\x06= /0:\x00\x00\x00\x00/1533266778944/Put/vlen=3D1/seqid=3D9) > at org.apache.phoenix.filter.SkipScanFilter.setNextCellHint(SkipScanFilte= r.java:171) > at org.apache.phoenix.filter.SkipScanFilter.filterKeyValue(SkipScanFilter= .java:145) > at org.apache.hadoop.hbase.regionserver.ScanQueryMatcher.match(ScanQueryM= atcher.java:427) > at org.apache.hadoop.hbase.regionserver.StoreScanner.next(StoreScanner.ja= va:529) > at org.apache.hadoop.hbase.regionserver.KeyValueHeap.next(KeyValueHeap.ja= va:147) > at org.apache.hadoop.hbase.regionserver.HRegion$RegionScannerImpl.populat= eResult(HRegion.java:5735) > at org.apache.hadoop.hbase.regionserver.HRegion$RegionScannerImpl.nextInt= ernal(HRegion.java:5891) > at org.apache.hadoop.hbase.regionserver.HRegion$RegionScannerImpl.nextRaw= (HRegion.java:5669) > at org.apache.hadoop.hbase.regionserver.HRegion$RegionScannerImpl.nextRaw= (HRegion.java:5654) > at org.apache.phoenix.iterate.RegionScannerFactory$1.nextRaw(RegionScanne= rFactory.java:175) > ... 10 more > at java.util.concurrent.FutureTask.report(FutureTask.java:122) > at java.util.concurrent.FutureTask.get(FutureTask.java:206) > at org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResult= Iterators.java:965) > ... 13 more > Caused by: org.apache.phoenix.exception.PhoenixIOException: org.apache.ha= doop.hbase.DoNotRetryIOException: TEST,,1533266754845.b8e521d4dc8e8b8f18c69= cc7ef76973d.: The next hint must come after previous hint (prev=3D\x80\x00\= x00\x00\x00\x00\x00\x07//LATEST_TIMESTAMP/Maximum/vlen=3D0/seqid=3D0, next= =3D\x80\x00\x00\x00\x00\x00\x00\x07//LATEST_TIMESTAMP/Maximum/vlen=3D0/seqi= d=3D0, kv=3D\x80\x00\x00\x00\x00\x00\x00\x06/0:\x00\x00\x00\x00/15332667789= 44/Put/vlen=3D1/seqid=3D9) > at org.apache.phoenix.util.ServerUtil.createIOException(ServerUtil.java:9= 6) > at org.apache.phoenix.util.ServerUtil.throwIOException(ServerUtil.java:62= ) > at org.apache.phoenix.iterate.RegionScannerFactory$1.nextRaw(RegionScanne= rFactory.java:212) > at org.apache.phoenix.coprocessor.HashJoinRegionScanner.nextRaw(HashJoinR= egionScanner.java:264) > at org.apache.phoenix.coprocessor.DelegateRegionScanner.nextRaw(DelegateR= egionScanner.java:82) > at org.apache.phoenix.coprocessor.DelegateRegionScanner.nextRaw(DelegateR= egionScanner.java:82) > at org.apache.phoenix.coprocessor.BaseScannerRegionObserver$RegionScanner= Holder.nextRaw(BaseScannerRegionObserver.java:293) > at org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.= java:2541) > at org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$= 2.callBlockingMethod(ClientProtos.java:33648) > at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2183) > at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:112) > at org.apache.hadoop.hbase.ipc.RpcExecutor$Handler.run(RpcExecutor.java:1= 83) > at org.apache.hadoop.hbase.ipc.RpcExecutor$Handler.run(RpcExecutor.java:1= 63) > Caused by: java.lang.IllegalStateException: The next hint must come after= previous hint (prev=3D\x80\x00\x00\x00\x00\x00\x00\x07//LATEST_TIMESTAMP/M= aximum/vlen=3D0/seqid=3D0, next=3D\x80\x00\x00\x00\x00\x00\x00\x07//LATEST_= TIMESTAMP/Maximum/vlen=3D0/seqid=3D0, kv=3D\x80\x00\x00\x00\x00\x00\x00\x06= /0:\x00\x00\x00\x00/1533266778944/Put/vlen=3D1/seqid=3D9) > at org.apache.phoenix.filter.SkipScanFilter.setNextCellHint(SkipScanFilte= r.java:171) > at org.apache.phoenix.filter.SkipScanFilter.filterKeyValue(SkipScanFilter= .java:145) > at org.apache.hadoop.hbase.regionserver.ScanQueryMatcher.match(ScanQueryM= atcher.java:427) > at org.apache.hadoop.hbase.regionserver.StoreScanner.next(StoreScanner.ja= va:529) > at org.apache.hadoop.hbase.regionserver.KeyValueHeap.next(KeyValueHeap.ja= va:147) > at org.apache.hadoop.hbase.regionserver.HRegion$RegionScannerImpl.populat= eResult(HRegion.java:5735) > at org.apache.hadoop.hbase.regionserver.HRegion$RegionScannerImpl.nextInt= ernal(HRegion.java:5891) > at org.apache.hadoop.hbase.regionserver.HRegion$RegionScannerImpl.nextRaw= (HRegion.java:5669) > at org.apache.hadoop.hbase.regionserver.HRegion$RegionScannerImpl.nextRaw= (HRegion.java:5654) > at org.apache.phoenix.iterate.RegionScannerFactory$1.nextRaw(RegionScanne= rFactory.java:175) > ... 10 more > at org.apache.phoenix.util.ServerUtil.parseServerException(ServerUtil.jav= a:120) > at org.apache.phoenix.iterate.TableResultIterator.next(TableResultIterato= r.java:173) > at org.apache.phoenix.iterate.LookAheadResultIterator$1.advance(LookAhead= ResultIterator.java:47) > at org.apache.phoenix.iterate.LookAheadResultIterator.init(LookAheadResul= tIterator.java:59) > at org.apache.phoenix.iterate.LookAheadResultIterator.peek(LookAheadResul= tIterator.java:73) > at org.apache.phoenix.iterate.ParallelIterators$1.call(ParallelIterators.= java:128) > at org.apache.phoenix.iterate.ParallelIterators$1.call(ParallelIterators.= java:113) > at java.util.concurrent.FutureTask.run(FutureTask.java:266) > at org.apache.phoenix.job.JobManager$InstrumentedJobFutureTask.run(JobMan= ager.java:183) > at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.j= ava:1149) > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.= java:624) > at java.lang.Thread.run(Thread.java:748) > Caused by: org.apache.phoenix.exception.PhoenixIOException: org.apache.ha= doop.hbase.DoNotRetryIOException: TEST,,1533266754845.b8e521d4dc8e8b8f18c69= cc7ef76973d.: The next hint must come after previous hint (prev=3D\x80\x00\= x00\x00\x00\x00\x00\x07//LATEST_TIMESTAMP/Maximum/vlen=3D0/seqid=3D0, next= =3D\x80\x00\x00\x00\x00\x00\x00\x07//LATEST_TIMESTAMP/Maximum/vlen=3D0/seqi= d=3D0, kv=3D\x80\x00\x00\x00\x00\x00\x00\x06/0:\x00\x00\x00\x00/15332667789= 44/Put/vlen=3D1/seqid=3D9) > at org.apache.phoenix.util.ServerUtil.createIOException(ServerUtil.java:9= 6) > at org.apache.phoenix.util.ServerUtil.throwIOException(ServerUtil.java:62= ) > at org.apache.phoenix.iterate.RegionScannerFactory$1.nextRaw(RegionScanne= rFactory.java:212) > at org.apache.phoenix.coprocessor.HashJoinRegionScanner.nextRaw(HashJoinR= egionScanner.java:264) > at org.apache.phoenix.coprocessor.DelegateRegionScanner.nextRaw(DelegateR= egionScanner.java:82) > at org.apache.phoenix.coprocessor.DelegateRegionScanner.nextRaw(DelegateR= egionScanner.java:82) > at org.apache.phoenix.coprocessor.BaseScannerRegionObserver$RegionScanner= Holder.nextRaw(BaseScannerRegionObserver.java:293) > at org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.= java:2541) > at org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$= 2.callBlockingMethod(ClientProtos.java:33648) > at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2183) > at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:112) > at org.apache.hadoop.hbase.ipc.RpcExecutor$Handler.run(RpcExecutor.java:1= 83) > at org.apache.hadoop.hbase.ipc.RpcExecutor$Handler.run(RpcExecutor.java:1= 63) > Caused by: java.lang.IllegalStateException: The next hint must come after= previous hint (prev=3D\x80\x00\x00\x00\x00\x00\x00\x07//LATEST_TIMESTAMP/M= aximum/vlen=3D0/seqid=3D0, next=3D\x80\x00\x00\x00\x00\x00\x00\x07//LATEST_= TIMESTAMP/Maximum/vlen=3D0/seqid=3D0, kv=3D\x80\x00\x00\x00\x00\x00\x00\x06= /0:\x00\x00\x00\x00/1533266778944/Put/vlen=3D1/seqid=3D9) > at org.apache.phoenix.filter.SkipScanFilter.setNextCellHint(SkipScanFilte= r.java:171) > at org.apache.phoenix.filter.SkipScanFilter.filterKeyValue(SkipScanFilter= .java:145) > at org.apache.hadoop.hbase.regionserver.ScanQueryMatcher.match(ScanQueryM= atcher.java:427) > at org.apache.hadoop.hbase.regionserver.StoreScanner.next(StoreScanner.ja= va:529) > at org.apache.hadoop.hbase.regionserver.KeyValueHeap.next(KeyValueHeap.ja= va:147) > at org.apache.hadoop.hbase.regionserver.HRegion$RegionScannerImpl.populat= eResult(HRegion.java:5735) > at org.apache.hadoop.hbase.regionserver.HRegion$RegionScannerImpl.nextInt= ernal(HRegion.java:5891) > at org.apache.hadoop.hbase.regionserver.HRegion$RegionScannerImpl.nextRaw= (HRegion.java:5669) > at org.apache.hadoop.hbase.regionserver.HRegion$RegionScannerImpl.nextRaw= (HRegion.java:5654) > at org.apache.phoenix.iterate.RegionScannerFactory$1.nextRaw(RegionScanne= rFactory.java:175) > ... 10 more > at org.apache.phoenix.util.ServerUtil.parseServerException(ServerUtil.jav= a:120) > at org.apache.phoenix.iterate.ScanningResultIterator.next(ScanningResultI= terator.java:127) > at org.apache.phoenix.iterate.TableResultIterator.next(TableResultIterato= r.java:166) > ... 10 more > Caused by: org.apache.hadoop.hbase.DoNotRetryIOException: org.apache.hado= op.hbase.DoNotRetryIOException: TEST,,1533266754845.b8e521d4dc8e8b8f18c69cc= 7ef76973d.: The next hint must come after previous hint (prev=3D\x80\x00\x0= 0\x00\x00\x00\x00\x07//LATEST_TIMESTAMP/Maximum/vlen=3D0/seqid=3D0, next=3D= \x80\x00\x00\x00\x00\x00\x00\x07//LATEST_TIMESTAMP/Maximum/vlen=3D0/seqid= =3D0, kv=3D\x80\x00\x00\x00\x00\x00\x00\x06/0:\x00\x00\x00\x00/153326677894= 4/Put/vlen=3D1/seqid=3D9) > at org.apache.phoenix.util.ServerUtil.createIOException(ServerUtil.java:9= 6) > at org.apache.phoenix.util.ServerUtil.throwIOException(ServerUtil.java:62= ) > at org.apache.phoenix.iterate.RegionScannerFactory$1.nextRaw(RegionScanne= rFactory.java:212) > at org.apache.phoenix.coprocessor.HashJoinRegionScanner.nextRaw(HashJoinR= egionScanner.java:264) > at org.apache.phoenix.coprocessor.DelegateRegionScanner.nextRaw(DelegateR= egionScanner.java:82) > at org.apache.phoenix.coprocessor.DelegateRegionScanner.nextRaw(DelegateR= egionScanner.java:82) > at org.apache.phoenix.coprocessor.BaseScannerRegionObserver$RegionScanner= Holder.nextRaw(BaseScannerRegionObserver.java:293) > at org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.= java:2541) > at org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$= 2.callBlockingMethod(ClientProtos.java:33648) > at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2183) > at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:112) > at org.apache.hadoop.hbase.ipc.RpcExecutor$Handler.run(RpcExecutor.java:1= 83) > at org.apache.hadoop.hbase.ipc.RpcExecutor$Handler.run(RpcExecutor.java:1= 63) > Caused by: java.lang.IllegalStateException: The next hint must come after= previous hint (prev=3D\x80\x00\x00\x00\x00\x00\x00\x07//LATEST_TIMESTAMP/M= aximum/vlen=3D0/seqid=3D0, next=3D\x80\x00\x00\x00\x00\x00\x00\x07//LATEST_= TIMESTAMP/Maximum/vlen=3D0/seqid=3D0, kv=3D\x80\x00\x00\x00\x00\x00\x00\x06= /0:\x00\x00\x00\x00/1533266778944/Put/vlen=3D1/seqid=3D9) > at org.apache.phoenix.filter.SkipScanFilter.setNextCellHint(SkipScanFilte= r.java:171) > at org.apache.phoenix.filter.SkipScanFilter.filterKeyValue(SkipScanFilter= .java:145) > at org.apache.hadoop.hbase.regionserver.ScanQueryMatcher.match(ScanQueryM= atcher.java:427) > at org.apache.hadoop.hbase.regionserver.StoreScanner.next(StoreScanner.ja= va:529) > at org.apache.hadoop.hbase.regionserver.KeyValueHeap.next(KeyValueHeap.ja= va:147) > at org.apache.hadoop.hbase.regionserver.HRegion$RegionScannerImpl.populat= eResult(HRegion.java:5735) > at org.apache.hadoop.hbase.regionserver.HRegion$RegionScannerImpl.nextInt= ernal(HRegion.java:5891) > at org.apache.hadoop.hbase.regionserver.HRegion$RegionScannerImpl.nextRaw= (HRegion.java:5669) > at org.apache.hadoop.hbase.regionserver.HRegion$RegionScannerImpl.nextRaw= (HRegion.java:5654) > at org.apache.phoenix.iterate.RegionScannerFactory$1.nextRaw(RegionScanne= rFactory.java:175) > ... 10 more > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) > at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructo= rAccessorImpl.java:62) > at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingCo= nstructorAccessorImpl.java:45) > at java.lang.reflect.Constructor.newInstance(Constructor.java:423) > at org.apache.hadoop.ipc.RemoteException.instantiateException(RemoteExcep= tion.java:106) > at org.apache.hadoop.ipc.RemoteException.unwrapRemoteException(RemoteExce= ption.java:95) > at org.apache.hadoop.hbase.protobuf.ProtobufUtil.getRemoteException(Proto= bufUtil.java:332) > at org.apache.hadoop.hbase.client.ScannerCallable.call(ScannerCallable.ja= va:263) > at org.apache.hadoop.hbase.client.ScannerCallable.call(ScannerCallable.ja= va:65) > at org.apache.hadoop.hbase.client.RpcRetryingCaller.callWithoutRetries(Rp= cRetryingCaller.java:210) > at org.apache.hadoop.hbase.client.ScannerCallableWithReplicas$RetryingRPC= .call(ScannerCallableWithReplicas.java:381) > at org.apache.hadoop.hbase.client.ScannerCallableWithReplicas$RetryingRPC= .call(ScannerCallableWithReplicas.java:355) > at org.apache.hadoop.hbase.client.RpcRetryingCaller.callWithRetries(RpcRe= tryingCaller.java:136) > at org.apache.hadoop.hbase.client.ResultBoundedCompletionService$Queueing= Future.run(ResultBoundedCompletionService.java:80) > ... 3 more > Caused by: org.apache.hadoop.hbase.ipc.RemoteWithExtrasException(org.apac= he.hadoop.hbase.DoNotRetryIOException): org.apache.hadoop.hbase.DoNotRetryI= OException: TEST,,1533266754845.b8e521d4dc8e8b8f18c69cc7ef76973d.: The next= hint must come after previous hint (prev=3D\x80\x00\x00\x00\x00\x00\x00\x0= 7//LATEST_TIMESTAMP/Maximum/vlen=3D0/seqid=3D0, next=3D\x80\x00\x00\x00\x00= \x00\x00\x07//LATEST_TIMESTAMP/Maximum/vlen=3D0/seqid=3D0, kv=3D\x80\x00\x0= 0\x00\x00\x00\x00\x06/0:\x00\x00\x00\x00/1533266778944/Put/vlen=3D1/seqid= =3D9) > at org.apache.phoenix.util.ServerUtil.createIOException(ServerUtil.java:9= 6) > at org.apache.phoenix.util.ServerUtil.throwIOException(ServerUtil.java:62= ) > at org.apache.phoenix.iterate.RegionScannerFactory$1.nextRaw(RegionScanne= rFactory.java:212) > at org.apache.phoenix.coprocessor.HashJoinRegionScanner.nextRaw(HashJoinR= egionScanner.java:264) > at org.apache.phoenix.coprocessor.DelegateRegionScanner.nextRaw(DelegateR= egionScanner.java:82) > at org.apache.phoenix.coprocessor.DelegateRegionScanner.nextRaw(DelegateR= egionScanner.java:82) > at org.apache.phoenix.coprocessor.BaseScannerRegionObserver$RegionScanner= Holder.nextRaw(BaseScannerRegionObserver.java:293) > at org.apache.hadoop.hbase.regionserver.RSRpcServices.scan(RSRpcServices.= java:2541) > at org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$= 2.callBlockingMethod(ClientProtos.java:33648) > at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2183) > at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:112) > at org.apache.hadoop.hbase.ipc.RpcExecutor$Handler.run(RpcExecutor.java:1= 83) > at org.apache.hadoop.hbase.ipc.RpcExecutor$Handler.run(RpcExecutor.java:1= 63) > Caused by: java.lang.IllegalStateException: The next hint must come after= previous hint (prev=3D\x80\x00\x00\x00\x00\x00\x00\x07//LATEST_TIMESTAMP/M= aximum/vlen=3D0/seqid=3D0, next=3D\x80\x00\x00\x00\x00\x00\x00\x07//LATEST_= TIMESTAMP/Maximum/vlen=3D0/seqid=3D0, kv=3D\x80\x00\x00\x00\x00\x00\x00\x06= /0:\x00\x00\x00\x00/1533266778944/Put/vlen=3D1/seqid=3D9) > at org.apache.phoenix.filter.SkipScanFilter.setNextCellHint(SkipScanFilte= r.java:171) > at org.apache.phoenix.filter.SkipScanFilter.filterKeyValue(SkipScanFilter= .java:145) > at org.apache.hadoop.hbase.regionserver.ScanQueryMatcher.match(ScanQueryM= atcher.java:427) > at org.apache.hadoop.hbase.regionserver.StoreScanner.next(StoreScanner.ja= va:529) > at org.apache.hadoop.hbase.regionserver.KeyValueHeap.next(KeyValueHeap.ja= va:147) > at org.apache.hadoop.hbase.regionserver.HRegion$RegionScannerImpl.populat= eResult(HRegion.java:5735) > at org.apache.hadoop.hbase.regionserver.HRegion$RegionScannerImpl.nextInt= ernal(HRegion.java:5891) > at org.apache.hadoop.hbase.regionserver.HRegion$RegionScannerImpl.nextRaw= (HRegion.java:5669) > at org.apache.hadoop.hbase.regionserver.HRegion$RegionScannerImpl.nextRaw= (HRegion.java:5654) > at org.apache.phoenix.iterate.RegionScannerFactory$1.nextRaw(RegionScanne= rFactory.java:175) > ... 10 more > at org.apache.hadoop.hbase.ipc.RpcClientImpl.call(RpcClientImpl.java:1269= ) > at org.apache.hadoop.hbase.ipc.AbstractRpcClient.callBlockingMethod(Abstr= actRpcClient.java:227) > at org.apache.hadoop.hbase.ipc.AbstractRpcClient$BlockingRpcChannelImplem= entation.callBlockingMethod(AbstractRpcClient.java:336) > at org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$= BlockingStub.scan(ClientProtos.java:34094) > at org.apache.hadoop.hbase.client.ScannerCallable.call(ScannerCallable.ja= va:220) > ... 9 more > {code} > =C2=A0 -- This message was sent by Atlassian JIRA (v7.6.3#76005)