From dev-return-57652-archive-asf-public=cust-asf.ponee.io@phoenix.apache.org Tue Jul 30 08:56:02 2019 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 [207.244.88.153]) by mx-eu-01.ponee.io (Postfix) with SMTP id 18B2D180607 for ; Tue, 30 Jul 2019 10:56:02 +0200 (CEST) Received: (qmail 27907 invoked by uid 500); 30 Jul 2019 08:56:01 -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 27894 invoked by uid 99); 30 Jul 2019 08:56:01 -0000 Received: from mailrelay1-us-west.apache.org (HELO mailrelay1-us-west.apache.org) (209.188.14.139) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 30 Jul 2019 08:56:01 +0000 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 64903E0F8F for ; Tue, 30 Jul 2019 08:56:00 +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 141392662E for ; Tue, 30 Jul 2019 08:56:00 +0000 (UTC) Date: Tue, 30 Jul 2019 08:56:00 +0000 (UTC) From: "ivanliu (JIRA)" To: dev@phoenix.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Created] (PHOENIX-5417) Error upgrading from 4.7.x to 4.14.x MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 ivanliu created PHOENIX-5417: -------------------------------- Summary: Error upgrading from 4.7.x to 4.14.x Key: PHOENIX-5417 URL: https://issues.apache.org/jira/browse/PHOENIX-5417 Project: Phoenix Issue Type: Bug Reporter: ivanliu Hi to all,=C2=A0 I've recently updated my Cloudera + Phoenix from CDH 5.7 + Phoenix 4.7.0-1.= clabs_phoenix1.3.0.p0.000 to CDH 5.14.2 + Phoenix 4.14.0-cdh5.14.2.p0.3=C2= =A0but now I can't connect with Phoenix anymore. When I run=C2=A0sqlline.py= I get: =C2=A0 [root@test-cassandra-01 bin]# ./sqlline.py=20 Setting property: [incremental, false] Setting property: [isolation, TRANSACTION_READ_COMMITTED] issuing: !connect jdbc:phoenix: none none org.apache.phoenix.jdbc.PhoenixDr= iver Connecting to jdbc:phoenix: SLF4J: Class path contains multiple SLF4J bindings. SLF4J: Found binding in [jar:file:/opt/cloudera/parcels/APACHE_PHOENIX-4.14= .0-cdh5.14.2.p0.3/lib/phoenix/phoenix-4.14.0-cdh5.14.2-client.jar!/org/slf4= j/impl/StaticLoggerBinder.class] SLF4J: Found binding in [jar:file:/opt/cloudera/parcels/CDH-5.14.2-1.cdh5.1= 4.2.p0.3/jars/slf4j-log4j12-1.7.5.jar!/org/slf4j/impl/StaticLoggerBinder.cl= ass] SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explana= tion. SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory] 19/07/30 15:41:32 WARN util.NativeCodeLoader: Unable to load native-hadoop = library for your platform... using builtin-java classes where applicable 19/07/30 15:41:56 WARN iterate.BaseResultIterators: Unable to find parent t= able "IVAN_SECONDARY_INDEX_TEST" of table "IVANLIU_TEST_AGE_R" to determine= USE_STATS_FOR_PARALLELIZATION org.apache.phoenix.schema.TableNotFoundException: ERROR 1012 (42M03): Table= undefined. tableName=3DIVAN_SECONDARY_INDEX_TEST at org.apache.phoenix.schema.PMetaDataImpl.getTableRef(PMetaDataImpl.java:= 71) at org.apache.phoenix.schema.PSynchronizedMetaData.getTableRef(PSynchroniz= edMetaData.java:89) at org.apache.phoenix.jdbc.PhoenixConnection.getTable(PhoenixConnection.ja= va:581) at org.apache.phoenix.mapreduce.util.PhoenixConfigurationUtil.getStatsForP= arallelizationProp(PhoenixConfigurationUtil.java:646) at org.apache.phoenix.iterate.BaseResultIterators.(BaseResultIterato= rs.java:504) at org.apache.phoenix.iterate.ParallelIterators.(ParallelIterators.j= ava:62) at org.apache.phoenix.iterate.ParallelIterators.(ParallelIterators.j= ava:69) at org.apache.phoenix.execute.AggregatePlan.newIterator(AggregatePlan.java= :271) at org.apache.phoenix.execute.BaseQueryPlan.iterator(BaseQueryPlan.java:36= 4) at org.apache.phoenix.execute.BaseQueryPlan.iterator(BaseQueryPlan.java:21= 7) at org.apache.phoenix.execute.BaseQueryPlan.iterator(BaseQueryPlan.java:21= 2) at org.apache.phoenix.execute.BaseQueryPlan.iterator(BaseQueryPlan.java:20= 7) at org.apache.phoenix.compile.PostDDLCompiler$2.execute(PostDDLCompiler.ja= va:288) at org.apache.phoenix.query.ConnectionQueryServicesImpl.updateData(Connect= ionQueryServicesImpl.java:3664) at org.apache.phoenix.schema.MetaDataClient.dropTable(MetaDataClient.java:= 2996) at org.apache.phoenix.schema.MetaDataClient.dropIndex(MetaDataClient.java:= 2865) at org.apache.phoenix.jdbc.PhoenixStatement$ExecutableDropIndexStatement$1= .execute(PhoenixStatement.java:1234) at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:4= 08) at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:3= 91) at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53) at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStateme= nt.java:389) at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStateme= nt.java:378) at org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:= 1825) at org.apache.phoenix.util.UpgradeUtil.upgradeLocalIndexes(UpgradeUtil.jav= a:452) at org.apache.phoenix.query.ConnectionQueryServicesImpl.upgradeSystemCatal= ogIfRequired(ConnectionQueryServicesImpl.java:2899) at org.apache.phoenix.query.ConnectionQueryServicesImpl.upgradeSystemTable= s(ConnectionQueryServicesImpl.java:3050) at org.apache.phoenix.query.ConnectionQueryServicesImpl$12.call(Connection= QueryServicesImpl.java:2584) at org.apache.phoenix.query.ConnectionQueryServicesImpl$12.call(Connection= QueryServicesImpl.java:2491) at org.apache.phoenix.util.PhoenixContextExecutor.call(PhoenixContextExecu= tor.java:76) at org.apache.phoenix.query.ConnectionQueryServicesImpl.init(ConnectionQue= ryServicesImpl.java:2491) at org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(Phoeni= xDriver.java:255) at org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.createConnection(PhoenixE= mbeddedDriver.java:150) at org.apache.phoenix.jdbc.PhoenixDriver.connect(PhoenixDriver.java:221) at sqlline.DatabaseConnection.connect(DatabaseConnection.java:157) at sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:203) at sqlline.Commands.connect(Commands.java:1064) at sqlline.Commands.connect(Commands.java:996) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.ja= va:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccesso= rImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:= 38) at sqlline.SqlLine.dispatch(SqlLine.java:809) at sqlline.SqlLine.initArgs(SqlLine.java:588) at sqlline.SqlLine.begin(SqlLine.java:661) at sqlline.SqlLine.start(SqlLine.java:398) at sqlline.SqlLine.main(SqlLine.java:291) 19/07/30 15:41:56 WARN iterate.BaseResultIterators: Unable to find parent t= able "IVAN_SECONDARY_INDEX_TEST" of table "IVANLIU_TEST_AGE_R" to determine= USE_STATS_FOR_PARALLELIZATION org.apache.phoenix.schema.TableNotFoundException: ERROR 1012 (42M03): Table= undefined. tableName=3DIVAN_SECONDARY_INDEX_TEST at org.apache.phoenix.schema.PMetaDataImpl.getTableRef(PMetaDataImpl.java:= 71) at org.apache.phoenix.schema.PSynchronizedMetaData.getTableRef(PSynchroniz= edMetaData.java:89) at org.apache.phoenix.jdbc.PhoenixConnection.getTable(PhoenixConnection.ja= va:581) at org.apache.phoenix.mapreduce.util.PhoenixConfigurationUtil.getStatsForP= arallelizationProp(PhoenixConfigurationUtil.java:646) at org.apache.phoenix.iterate.BaseResultIterators.(BaseResultIterato= rs.java:504) at org.apache.phoenix.iterate.ParallelIterators.(ParallelIterators.j= ava:62) at org.apache.phoenix.iterate.ParallelIterators.(ParallelIterators.j= ava:69) at org.apache.phoenix.execute.AggregatePlan.newIterator(AggregatePlan.java= :271) at org.apache.phoenix.execute.BaseQueryPlan.iterator(BaseQueryPlan.java:36= 4) at org.apache.phoenix.execute.BaseQueryPlan.iterator(BaseQueryPlan.java:21= 7) at org.apache.phoenix.execute.BaseQueryPlan.iterator(BaseQueryPlan.java:21= 2) at org.apache.phoenix.execute.BaseQueryPlan.iterator(BaseQueryPlan.java:20= 7) at org.apache.phoenix.compile.PostDDLCompiler$2.execute(PostDDLCompiler.ja= va:288) at org.apache.phoenix.query.ConnectionQueryServicesImpl.updateData(Connect= ionQueryServicesImpl.java:3664) at org.apache.phoenix.schema.MetaDataClient.dropTable(MetaDataClient.java:= 2996) at org.apache.phoenix.schema.MetaDataClient.dropIndex(MetaDataClient.java:= 2865) at org.apache.phoenix.jdbc.PhoenixStatement$ExecutableDropIndexStatement$1= .execute(PhoenixStatement.java:1234) at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:4= 08) at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:3= 91) at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53) at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStateme= nt.java:389) at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStateme= nt.java:378) at org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:= 1825) at org.apache.phoenix.util.UpgradeUtil.upgradeLocalIndexes(UpgradeUtil.jav= a:452) at org.apache.phoenix.query.ConnectionQueryServicesImpl.upgradeSystemCatal= ogIfRequired(ConnectionQueryServicesImpl.java:2899) at org.apache.phoenix.query.ConnectionQueryServicesImpl.upgradeSystemTable= s(ConnectionQueryServicesImpl.java:3050) at org.apache.phoenix.query.ConnectionQueryServicesImpl$12.call(Connection= QueryServicesImpl.java:2584) at org.apache.phoenix.query.ConnectionQueryServicesImpl$12.call(Connection= QueryServicesImpl.java:2491) at org.apache.phoenix.util.PhoenixContextExecutor.call(PhoenixContextExecu= tor.java:76) at org.apache.phoenix.query.ConnectionQueryServicesImpl.init(ConnectionQue= ryServicesImpl.java:2491) at org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(Phoeni= xDriver.java:255) at org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.createConnection(PhoenixE= mbeddedDriver.java:150) at org.apache.phoenix.jdbc.PhoenixDriver.connect(PhoenixDriver.java:221) at sqlline.DatabaseConnection.connect(DatabaseConnection.java:157) at sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:203) at sqlline.Commands.connect(Commands.java:1064) at sqlline.Commands.connect(Commands.java:996) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.ja= va:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccesso= rImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:= 38) at sqlline.SqlLine.dispatch(SqlLine.java:809) at sqlline.SqlLine.initArgs(SqlLine.java:588) at sqlline.SqlLine.begin(SqlLine.java:661) at sqlline.SqlLine.start(SqlLine.java:398) at sqlline.SqlLine.main(SqlLine.java:291) 19/07/30 15:41:56 WARN query.ConnectionQueryServicesImpl: Starting restore = of SYSTEM.CATALOG using snapshot SNAPSHOT_SYSTEM.CATALOG_4.7.x_TO_4.14.0_20= 190730154134 because upgrade failed 19/07/30 15:41:59 WARN query.ConnectionQueryServicesImpl: Successfully rest= ored SYSTEM.CATALOG using snapshot SNAPSHOT_SYSTEM.CATALOG_4.7.x_TO_4.14.0_= 20190730154134 19/07/30 15:42:04 WARN query.ConnectionQueryServicesImpl: Successfully rest= ored and enabled SYSTEM.CATALOG using snapshot SNAPSHOT_SYSTEM.CATALOG_4.7.= x_TO_4.14.0_20190730154134 Error: ERROR 504 (42703): Undefined column. columnName=3DIVAN_SECONDARY_IND= EX_TEST.AGE (state=3D42703,code=3D504) org.apache.phoenix.schema.ColumnNotFoundException: ERROR 504 (42703): Undef= ined column. columnName=3DIVAN_SECONDARY_INDEX_TEST.AGE at org.apache.phoenix.schema.PTableImpl.getColumnForColumnName(PTableImpl.= java:828) at org.apache.phoenix.compile.FromCompiler$SingleTableColumnResolver.resol= veColumn(FromCompiler.java:475) at org.apache.phoenix.compile.ExpressionCompiler.resolveColumn(ExpressionC= ompiler.java:372) at org.apache.phoenix.compile.IndexExpressionCompiler.resolveColumn(IndexE= xpressionCompiler.java:39) at org.apache.phoenix.compile.ExpressionCompiler.visit(ExpressionCompiler.= java:408) at org.apache.phoenix.compile.ExpressionCompiler.visit(ExpressionCompiler.= java:146) at org.apache.phoenix.parse.ColumnParseNode.accept(ColumnParseNode.java:56= ) at org.apache.phoenix.schema.MetaDataClient.createIndex(MetaDataClient.jav= a:1580) at org.apache.phoenix.compile.CreateIndexCompiler$1.execute(CreateIndexCom= piler.java:85) at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:4= 08) at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:3= 91) at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53) at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStateme= nt.java:389) at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStateme= nt.java:378) at org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:= 1825) at org.apache.phoenix.util.UpgradeUtil.upgradeLocalIndexes(UpgradeUtil.jav= a:456) at org.apache.phoenix.query.ConnectionQueryServicesImpl.upgradeSystemCatal= ogIfRequired(ConnectionQueryServicesImpl.java:2899) at org.apache.phoenix.query.ConnectionQueryServicesImpl.upgradeSystemTable= s(ConnectionQueryServicesImpl.java:3050) at org.apache.phoenix.query.ConnectionQueryServicesImpl$12.call(Connection= QueryServicesImpl.java:2584) at org.apache.phoenix.query.ConnectionQueryServicesImpl$12.call(Connection= QueryServicesImpl.java:2491) at org.apache.phoenix.util.PhoenixContextExecutor.call(PhoenixContextExecu= tor.java:76) at org.apache.phoenix.query.ConnectionQueryServicesImpl.init(ConnectionQue= ryServicesImpl.java:2491) at org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(Phoeni= xDriver.java:255) at org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.createConnection(PhoenixE= mbeddedDriver.java:150) at org.apache.phoenix.jdbc.PhoenixDriver.connect(PhoenixDriver.java:221) at sqlline.DatabaseConnection.connect(DatabaseConnection.java:157) at sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:203) at sqlline.Commands.connect(Commands.java:1064) at sqlline.Commands.connect(Commands.java:996) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.ja= va:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccesso= rImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:= 38) at sqlline.SqlLine.dispatch(SqlLine.java:809) at sqlline.SqlLine.initArgs(SqlLine.java:588) at sqlline.SqlLine.begin(SqlLine.java:661) at sqlline.SqlLine.start(SqlLine.java:398) at sqlline.SqlLine.main(SqlLine.java:291) sqlline version 1.2.0 0: jdbc:phoenix:> =C2=A0 How can I repair=C2=A0it?=C2=A0 =C2=A0 -- This message was sent by Atlassian JIRA (v7.6.14#76016)