From dev-return-50529-archive-asf-public=cust-asf.ponee.io@phoenix.apache.org Thu Mar 29 10:21:07 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 48C06180671 for ; Thu, 29 Mar 2018 10:21:06 +0200 (CEST) Received: (qmail 55318 invoked by uid 500); 29 Mar 2018 08:21:05 -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 55291 invoked by uid 99); 29 Mar 2018 08:21:04 -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; Thu, 29 Mar 2018 08:21:04 +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 619801806F0 for ; Thu, 29 Mar 2018 08:21:04 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -109.511 X-Spam-Level: X-Spam-Status: No, score=-109.511 tagged_above=-999 required=6.31 tests=[ENV_AND_HDR_SPF_MATCH=-0.5, KAM_ASCII_DIVIDERS=0.8, RCVD_IN_DNSWL_MED=-2.3, SPF_PASS=-0.001, T_RP_MATCHES_RCVD=-0.01, USER_IN_DEF_SPF_WL=-7.5, USER_IN_WHITELIST=-100] autolearn=disabled Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id LO7RKXAfEViz for ; Thu, 29 Mar 2018 08:21:03 +0000 (UTC) Received: from mailrelay1-us-west.apache.org (mailrelay1-us-west.apache.org [209.188.14.139]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTP id 1DA785FBEA for ; Thu, 29 Mar 2018 08:21: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 8E97BE0252 for ; Thu, 29 Mar 2018 08:21: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 5398C255F6 for ; Thu, 29 Mar 2018 08:21:00 +0000 (UTC) Date: Thu, 29 Mar 2018 08:21:00 +0000 (UTC) From: "Toshihiro Suzuki (JIRA)" To: dev@phoenix.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Updated] (PHOENIX-4669) NoSuchColumnFamilyException when creating index on views that are built on tables which have named column family 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-4669?page=3Dcom.atlass= ian.jira.plugin.system.issuetabpanels:all-tabpanel ] Toshihiro Suzuki updated PHOENIX-4669: -------------------------------------- Attachment: PHOENIX-4669-v2.patch > NoSuchColumnFamilyException when creating index on views that are built o= n tables which have named column family > -------------------------------------------------------------------------= --------------------------------------- > > Key: PHOENIX-4669 > URL: https://issues.apache.org/jira/browse/PHOENIX-4669 > Project: Phoenix > Issue Type: Bug > Affects Versions: 4.14.0 > Reporter: Toshihiro Suzuki > Assignee: Toshihiro Suzuki > Priority: Major > Attachments: PHOENIX-4669-UT.patch, PHOENIX-4669-v2.patch, PHOENI= X-4669.patch > > > Steps to reproduce are as follows: > 1. Create a table with specified column family > {code} > CREATE TABLE TBL (COL1 VARCHAR PRIMARY KEY, CF.COL2 VARCHAR) > {code} > 2. Upsert data into the table > {code} > UPSERT INTO TBL VALUES ('AAA','BBB') > {code} > 3. Create a view on the table > {code} > CREATE VIEW VW AS SELECT * FROM TBL > {code} > 4. Create a index on the view > {code} > CREATE INDEX IDX ON VW (CF.COL2) > {code} > By following the above steps, I faced the following error. > {code} > Exception in thread "main" org.apache.phoenix.execute.CommitException: or= g.apache.hadoop.hbase.client.RetriesExhaustedWithDetailsException: Failed 1= action: org.apache.hadoop.hbase.regionserver.NoSuchColumnFamilyException: = Column family 0 does not exist in region _IDX_TBL,,1521731699609.99c9a48534= aeca079c1ff614293fd13a. in table '_IDX_TBL', {TABLE_ATTRIBUTES =3D> {coproc= essor$1 =3D> '|org.apache.phoenix.coprocessor.ScanRegionObserver|805306366|= ', coprocessor$2 =3D> '|org.apache.phoenix.coprocessor.UngroupedAggregateRe= gionObserver|805306366|', coprocessor$3 =3D> '|org.apache.phoenix.coprocess= or.GroupedAggregateRegionObserver|805306366|', coprocessor$4 =3D> '|org.apa= che.phoenix.coprocessor.ServerCachingEndpointImpl|805306366|', coprocessor$= 5 =3D> '|org.apache.phoenix.hbase.index.Indexer|805306366|org.apache.hadoop= .hbase.index.codec.class=3Dorg.apache.phoenix.index.PhoenixIndexCodec,index= .builder=3Dorg.apache.phoenix.index.PhoenixIndexBuilder', METADATA =3D> {'I= S_VIEW_INDEX_TABLE' =3D> '\x01'}}, {NAME =3D> 'CF', BLOOMFILTER =3D> 'NONE'= , VERSIONS =3D> '1', IN_MEMORY =3D> 'false', KEEP_DELETED_CELLS =3D> 'FALSE= ', DATA_BLOCK_ENCODING =3D> 'FAST_DIFF', TTL =3D> 'FOREVER', COMPRESSION = =3D> 'NONE', MIN_VERSIONS =3D> '0', BLOCKCACHE =3D> 'true', BLOCKSIZE =3D> = '65536', REPLICATION_SCOPE =3D> '0'} > =09at org.apache.hadoop.hbase.regionserver.RSRpcServices.doBatchOp(RSRpcS= ervices.java:903) > =09at org.apache.hadoop.hbase.regionserver.RSRpcServices.doNonAtomicRegio= nMutation(RSRpcServices.java:822) > =09at org.apache.hadoop.hbase.regionserver.RSRpcServices.multi(RSRpcServi= ces.java:2376) > =09at org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientServi= ce$2.callBlockingMethod(ClientProtos.java:36621) > =09at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2352) > =09at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:124) > =09at org.apache.hadoop.hbase.ipc.RpcExecutor$Handler.run(RpcExecutor.jav= a:297) > =09at org.apache.hadoop.hbase.ipc.RpcExecutor$Handler.run(RpcExecutor.jav= a:277) > : 1 time, servers with issues: 10.0.1.3,57208,1521731670016 > =09at org.apache.phoenix.execute.MutationState.send(MutationState.java:11= 07) > =09at org.apache.phoenix.execute.MutationState.send(MutationState.java:14= 32) > =09at org.apache.phoenix.execute.MutationState.commit(MutationState.java:= 1273) > =09at org.apache.phoenix.jdbc.PhoenixConnection$3.call(PhoenixConnection.= java:663) > =09at org.apache.phoenix.jdbc.PhoenixConnection$3.call(PhoenixConnection.= java:659) > =09at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53) > =09at org.apache.phoenix.jdbc.PhoenixConnection.commit(PhoenixConnection.= java:659) > =09at org.apache.phoenix.query.ConnectionQueryServicesImpl.updateData(Con= nectionQueryServicesImpl.java:3513) > =09at org.apache.phoenix.schema.MetaDataClient.buildIndex(MetaDataClient.= java:1362) > =09at org.apache.phoenix.schema.MetaDataClient.createIndex(MetaDataClient= .java:1674) > =09at org.apache.phoenix.compile.CreateIndexCompiler$1.execute(CreateInde= xCompiler.java:85) > =09at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.ja= va:398) > =09at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.ja= va:381) > =09at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53) > =09at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixSta= tement.java:380) > =09at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixSta= tement.java:368) > =09at org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.j= ava:1794) > =09at Case00162740.main(Case00162740.java:20) > Caused by: org.apache.hadoop.hbase.client.RetriesExhaustedWithDetailsExce= ption: Failed 1 action: org.apache.hadoop.hbase.regionserver.NoSuchColumnFa= milyException: Column family 0 does not exist in region _IDX_TBL,,152173169= 9609.99c9a48534aeca079c1ff614293fd13a. in table '_IDX_TBL', {TABLE_ATTRIBUT= ES =3D> {coprocessor$1 =3D> '|org.apache.phoenix.coprocessor.ScanRegionObse= rver|805306366|', coprocessor$2 =3D> '|org.apache.phoenix.coprocessor.Ungro= upedAggregateRegionObserver|805306366|', coprocessor$3 =3D> '|org.apache.ph= oenix.coprocessor.GroupedAggregateRegionObserver|805306366|', coprocessor$4= =3D> '|org.apache.phoenix.coprocessor.ServerCachingEndpointImpl|805306366|= ', coprocessor$5 =3D> '|org.apache.phoenix.hbase.index.Indexer|805306366|or= g.apache.hadoop.hbase.index.codec.class=3Dorg.apache.phoenix.index.PhoenixI= ndexCodec,index.builder=3Dorg.apache.phoenix.index.PhoenixIndexBuilder', ME= TADATA =3D> {'IS_VIEW_INDEX_TABLE' =3D> '\x01'}}, {NAME =3D> 'CF', BLOOMFIL= TER =3D> 'NONE', VERSIONS =3D> '1', IN_MEMORY =3D> 'false', KEEP_DELETED_CE= LLS =3D> 'FALSE', DATA_BLOCK_ENCODING =3D> 'FAST_DIFF', TTL =3D> 'FOREVER',= COMPRESSION =3D> 'NONE', MIN_VERSIONS =3D> '0', BLOCKCACHE =3D> 'true', BL= OCKSIZE =3D> '65536', REPLICATION_SCOPE =3D> '0'} > =09at org.apache.hadoop.hbase.regionserver.RSRpcServices.doBatchOp(RSRpcS= ervices.java:903) > =09at org.apache.hadoop.hbase.regionserver.RSRpcServices.doNonAtomicRegio= nMutation(RSRpcServices.java:822) > =09at org.apache.hadoop.hbase.regionserver.RSRpcServices.multi(RSRpcServi= ces.java:2376) > =09at org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientServi= ce$2.callBlockingMethod(ClientProtos.java:36621) > =09at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2352) > =09at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:124) > =09at org.apache.hadoop.hbase.ipc.RpcExecutor$Handler.run(RpcExecutor.jav= a:297) > =09at org.apache.hadoop.hbase.ipc.RpcExecutor$Handler.run(RpcExecutor.jav= a:277) > : 1 time, servers with issues: 10.0.1.3,57208,1521731670016 > =09at org.apache.hadoop.hbase.client.AsyncProcess$BatchErrors.makeExcepti= on(AsyncProcess.java:297) > =09at org.apache.hadoop.hbase.client.AsyncProcess$BatchErrors.access$2300= (AsyncProcess.java:273) > =09at org.apache.hadoop.hbase.client.AsyncProcess$AsyncRequestFutureImpl.= getErrors(AsyncProcess.java:1781) > =09at org.apache.hadoop.hbase.client.HTable.batch(HTable.java:925) > =09at org.apache.hadoop.hbase.client.HTable.batch(HTable.java:939) > =09at org.apache.phoenix.execute.MutationState.send(MutationState.java:10= 49) > =09... 17 more > {code} > I will attach a unit test patch to reproduce this issue. -- This message was sent by Atlassian JIRA (v7.6.3#76005)