From dev-return-58919-archive-asf-public=cust-asf.ponee.io@phoenix.apache.org Sat Dec 7 05:12:03 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 85A0418065D for ; Sat, 7 Dec 2019 06:12:03 +0100 (CET) Received: (qmail 91014 invoked by uid 500); 7 Dec 2019 05:12:02 -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 91002 invoked by uid 99); 7 Dec 2019 05:12:02 -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; Sat, 07 Dec 2019 05:12:02 +0000 Received: from jira-he-de.apache.org (static.172.67.40.188.clients.your-server.de [188.40.67.172]) by mailrelay1-us-west.apache.org (ASF Mail Server at mailrelay1-us-west.apache.org) with ESMTP id 095BCE2DEB for ; Sat, 7 Dec 2019 05:12:01 +0000 (UTC) Received: from jira-he-de.apache.org (localhost.localdomain [127.0.0.1]) by jira-he-de.apache.org (ASF Mail Server at jira-he-de.apache.org) with ESMTP id 15F22780548 for ; Sat, 7 Dec 2019 05:12:00 +0000 (UTC) Date: Sat, 7 Dec 2019 05:12:00 +0000 (UTC) From: "Jacob Isaac (Jira)" To: dev@phoenix.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Created] (PHOENIX-5606) Upgrade from 4.14 -> 4.15 fails MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 Jacob Isaac created PHOENIX-5606: ------------------------------------ Summary: Upgrade from 4.14 -> 4.15 fails Key: PHOENIX-5606 URL: https://issues.apache.org/jira/browse/PHOENIX-5606 Project: Phoenix Issue Type: Bug Affects Versions: 4.15.0 Reporter: Jacob Isaac Disable ns mapping and set autoUpgrade to true initially 1. Connect to a 4.14 server with a 4.14 client --> This will create SYSTEM.CATALOG with the 4.14 timestamp 2. Upgrade server jar to 4.15 3. Connect with a 4.15 client for the first time with autoUpgrade disabled (or doNotUpgrade property set) --> This should fail to upgrade SYSTEM.CATALOG and should throw an UpgradeRequiredException 4. Now, sqlline should show the UpgradeRequiredException, but not kill the connection, then run EXECUTE UPGRADE Fails with the following exception :- 0: jdbc:phoenix:localhost> EXECUTE UPGRADE; Error: ERROR 504 (42703): Undefined column. columnName=SYSTEM.CATALOG.VIEW_INDEX_ID_DATA_TYPE (state=42703,code=504) org.apache.phoenix.schema.ColumnNotFoundException: ERROR 504 (42703): Undefined column. columnName=SYSTEM.CATALOG.VIEW_INDEX_ID_DATA_TYPE at org.apache.phoenix.schema.PTableImpl.getColumnForColumnName(PTableImpl.java:1106) at org.apache.phoenix.compile.FromCompiler$SingleTableColumnResolver.resolveColumn(FromCompiler.java:528) at org.apache.phoenix.compile.UpsertCompiler.compile(UpsertCompiler.java:483) at org.apache.phoenix.jdbc.PhoenixStatement$ExecutableUpsertStatement.compilePlan(PhoenixStatement.java:797) at org.apache.phoenix.jdbc.PhoenixStatement$ExecutableUpsertStatement.compilePlan(PhoenixStatement.java:783) at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:404) at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:394) at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53) at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:393) at org.apache.phoenix.jdbc.PhoenixStatement.access$700(PhoenixStatement.java:215) at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:434) at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:394) at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53) at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:393) at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:381) at org.apache.phoenix.jdbc.PhoenixPreparedStatement.execute(PhoenixPreparedStatement.java:173) at org.apache.phoenix.jdbc.PhoenixPreparedStatement.execute(PhoenixPreparedStatement.java:183) at org.apache.phoenix.schema.MetaDataClient.createTableInternal(MetaDataClient.java:2908) at org.apache.phoenix.schema.MetaDataClient.createTable(MetaDataClient.java:1064) at org.apache.phoenix.compile.CreateTableCompiler$1.execute(CreateTableCompiler.java:217) at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:411) at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:394) at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53) at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:393) at org.apache.phoenix.jdbc.PhoenixStatement.access$700(PhoenixStatement.java:215) at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:434) at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:394) at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53) at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:393) at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:381) at org.apache.phoenix.jdbc.PhoenixStatement.executeUpdate(PhoenixStatement.java:1824) at org.apache.phoenix.query.ConnectionQueryServicesImpl.upgradeSystemChildLink(ConnectionQueryServicesImpl.java:3732) at org.apache.phoenix.query.ConnectionQueryServicesImpl.upgradeOtherSystemTablesIfRequired(ConnectionQueryServicesImpl.java:3719) at org.apache.phoenix.query.ConnectionQueryServicesImpl.upgradeSystemTables(ConnectionQueryServicesImpl.java:3648) at org.apache.phoenix.jdbc.PhoenixStatement$ExecutableExecuteUpgradeStatement$1.execute(PhoenixStatement.java:1403) at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:411) at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:394) at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53) at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:393) at org.apache.phoenix.jdbc.PhoenixStatement.access$700(PhoenixStatement.java:215) at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:434) at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:394) at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53) at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:393) at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:381) at org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:1843) at sqlline.Commands.execute(Commands.java:822) at sqlline.Commands.sql(Commands.java:732) at sqlline.SqlLine.dispatch(SqlLine.java:807) at sqlline.SqlLine.begin(SqlLine.java:681) at sqlline.SqlLine.start(SqlLine.java:398) at sqlline.SqlLine.main(SqlLine.java:292) 0: jdbc:phoenix:localhost> !quit Closing: org.apache.phoenix.jdbc.PhoenixConnection -- This message was sent by Atlassian Jira (v8.3.4#803005)