[
https://issues.apache.org/jira/browse/PHOENIX-2066?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14599523#comment-14599523
]
ASF GitHub Bot commented on PHOENIX-2066:
-----------------------------------------
GitHub user lalinsky opened a pull request:
https://github.com/apache/phoenix/pull/90
[PHOENIX-2066] Fix upgrade from 4.4 to 4.5
Currently it always tries to run an upgrade from 4.1-4.3, but
if the schema is on 4.4, there are no columns to add so the
ALTER TABLE command fails.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/lalinsky/phoenix PHOENIX-2066
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/phoenix/pull/90.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #90
----
commit dc728b6a024bbe579b4acc5b357afefc251863d7
Author: Lukáš Lalinský <[email protected]>
Date: 2015-06-24T14:55:34Z
[PHOENIX-2066] Fix upgrade from 4.4 to 4.5
Currently it always tries to run an upgrade from 4.1-4.3, but
if the schema is on 4.4, there are no columns to add so the
ALTER TABLE command fails.
----
> Query server fails to start (tries to create a column with no name in
> SYSTEM."CATALOG")
> ---------------------------------------------------------------------------------------
>
> Key: PHOENIX-2066
> URL: https://issues.apache.org/jira/browse/PHOENIX-2066
> Project: Phoenix
> Issue Type: Bug
> Reporter: Lukas Lalinsky
> Attachments: 0001-PHOENIX-2066-Fix-upgrade-from-4.4-to-4.5.patch
>
>
> When using the latest version from git, starting the queryserver fails,
> because it tries to run an invalid SQL command on server startup.
> {noformat}
> 2015-06-24 12:45:19,105 WARN
> org.apache.phoenix.query.ConnectionQueryServicesImpl: Add column failed due
> to:org.apache.phoenix.exception.PhoenixParserException: ERROR 601 (42P00):
> Syntax error. Encountered "<EOF>" at line 1, column 49.
> 2015-06-24 12:45:19,106 INFO
> org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation:
> Closing zookeeper sessionid=0x14e1d23182d002f
> 2015-06-24 12:45:19,363 FATAL org.apache.phoenix.queryserver.server.Main:
> Unrecoverable service error. Shutting down.
> java.lang.RuntimeException:
> org.apache.phoenix.exception.PhoenixParserException: ERROR 601 (42P00):
> Syntax error. Encountered "<EOF>" at line 1, column 49.
> at
> org.apache.phoenix.queryserver.server.PhoenixMetaFactoryImpl.create(PhoenixMetaFactoryImpl.java:73)
> at org.apache.phoenix.queryserver.server.Main.run(Main.java:203)
> at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70)
> at org.apache.phoenix.queryserver.server.Main.main(Main.java:226)
> Caused by: org.apache.phoenix.exception.PhoenixParserException: ERROR 601
> (42P00): Syntax error. Encountered "<EOF>" at line 1, column 49.
> at
> org.apache.phoenix.exception.PhoenixParserException.newException(PhoenixParserException.java:33)
> at
> org.apache.phoenix.parse.SQLParser.parseStatement(SQLParser.java:111)
> at
> org.apache.phoenix.jdbc.PhoenixStatement$PhoenixStatementParser.parseStatement(PhoenixStatement.java:1097)
> at
> org.apache.phoenix.jdbc.PhoenixStatement.parseStatement(PhoenixStatement.java:1178)
> at
> org.apache.phoenix.jdbc.PhoenixStatement.executeUpdate(PhoenixStatement.java:1228)
> at
> org.apache.phoenix.query.ConnectionQueryServicesImpl.addColumn(ConnectionQueryServicesImpl.java:1837)
> at
> org.apache.phoenix.query.ConnectionQueryServicesImpl.addColumnsIfNotExists(ConnectionQueryServicesImpl.java:1863)
> at
> org.apache.phoenix.query.ConnectionQueryServicesImpl.access$500(ConnectionQueryServicesImpl.java:174)
> at
> org.apache.phoenix.query.ConnectionQueryServicesImpl$12.call(ConnectionQueryServicesImpl.java:1946)
> at
> org.apache.phoenix.query.ConnectionQueryServicesImpl$12.call(ConnectionQueryServicesImpl.java:1869)
> at
> org.apache.phoenix.util.PhoenixContextExecutor.call(PhoenixContextExecutor.java:77)
> at
> org.apache.phoenix.query.ConnectionQueryServicesImpl.init(ConnectionQueryServicesImpl.java:1869)
> at
> org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(PhoenixDriver.java:180)
> at
> org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.connect(PhoenixEmbeddedDriver.java:132)
> at
> org.apache.phoenix.jdbc.PhoenixDriver.connect(PhoenixDriver.java:151)
> at java.sql.DriverManager.getConnection(DriverManager.java:664)
> at java.sql.DriverManager.getConnection(DriverManager.java:208)
> at org.apache.calcite.avatica.jdbc.JdbcMeta.<init>(JdbcMeta.java:342)
> at
> org.apache.phoenix.queryserver.server.PhoenixMetaFactoryImpl.create(PhoenixMetaFactoryImpl.java:71)
> ... 3 more
> Caused by: NoViableAltException(-1@[])
> at
> org.apache.phoenix.parse.PhoenixSQLParser.column_name(PhoenixSQLParser.java:2316)
> at
> org.apache.phoenix.parse.PhoenixSQLParser.column_def(PhoenixSQLParser.java:3505)
> at
> org.apache.phoenix.parse.PhoenixSQLParser.column_defs(PhoenixSQLParser.java:3430)
> at
> org.apache.phoenix.parse.PhoenixSQLParser.alter_table_node(PhoenixSQLParser.java:3136)
> at
> org.apache.phoenix.parse.PhoenixSQLParser.oneStatement(PhoenixSQLParser.java:810)
> at
> org.apache.phoenix.parse.PhoenixSQLParser.statement(PhoenixSQLParser.java:494)
> at
> org.apache.phoenix.parse.SQLParser.parseStatement(SQLParser.java:108)
> ... 20 more
> {noformat}
> The exact SQL it tries to run is this (no column name)
> {noformat}
> ALTER TABLE SYSTEM."CATALOG" ADD IF NOT EXISTS
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
