You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Ankit Singhal (JIRA)" <ji...@apache.org> on 2017/06/08 19:17:18 UTC
[jira] [Comment Edited] (PHOENIX-3726) Error while upgrading system
tables
[ https://issues.apache.org/jira/browse/PHOENIX-3726?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16043270#comment-16043270 ]
Ankit Singhal edited comment on PHOENIX-3726 at 6/8/17 7:17 PM:
----------------------------------------------------------------
[~bhaveshvv109], you can follow below steps
{code}
* Clone repository locally (git clone https://github.com/apache/phoenix.git)
* apply attached patch (patch -p1<PHOENIX-3726) and resolve if there are conflicts(in .rej files)
*build it (using mvn clean package -DskipTests)
{code}
Just a dirty fix(or workaround without building the whole package), you can drop SYSTEM.MUTEX table and see if it works.
was (Author: ankit@apache.org):
[~bhaveshvv109], you can follow below steps
{code}
* Clone repository locally (git clone https://github.com/apache/phoenix.git)
* apply attached patch (patch -p1<PHOENIX-3726) and resolve if there are conflicts(in .rej files)
*build it (using mvn clean package -DskipTests)
{code}
Just a dirty fix, you can drop SYSTEM.MUTEX table and try.
> Error while upgrading system tables
> -----------------------------------
>
> Key: PHOENIX-3726
> URL: https://issues.apache.org/jira/browse/PHOENIX-3726
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 4.10.0
> Reporter: Ankit Singhal
> Assignee: Ankit Singhal
> Priority: Blocker
> Fix For: 4.10.0
>
> Attachments: PHOENIX-3726_addendum.patch, PHOENIX-3726.patch
>
>
> {code}
> Error: java.lang.IllegalArgumentException: Expected 4 system table only but found 5:[SYSTEM.CATALOG, SYSTEM.FUNCTION, SYSTEM.MUTEX, SYSTEM.SEQUENCE, SYSTEM.STATS] (state=,code=0)
> java.sql.SQLException: java.lang.IllegalArgumentException: Expected 4 system table only but found 5:[SYSTEM.CATALOG, SYSTEM.FUNCTION, SYSTEM.MUTEX, SYSTEM.SEQUENCE, SYSTEM.STATS]
> at org.apache.phoenix.query.ConnectionQueryServicesImpl$12.call(ConnectionQueryServicesImpl.java:2465)
> at org.apache.phoenix.query.ConnectionQueryServicesImpl$12.call(ConnectionQueryServicesImpl.java:2382)
> at org.apache.phoenix.util.PhoenixContextExecutor.call(PhoenixContextExecutor.java:76)
> at org.apache.phoenix.query.ConnectionQueryServicesImpl.init(ConnectionQueryServicesImpl.java:2382)
> at org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(PhoenixDriver.java:255)
> at org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.createConnection(PhoenixEmbeddedDriver.java:149)
> 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.java:57)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606)
> 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)
> Caused by: java.lang.IllegalArgumentException: Expected 4 system table only but found 5:[SYSTEM.CATALOG, SYSTEM.FUNCTION, SYSTEM.MUTEX, SYSTEM.SEQUENCE, SYSTEM.STATS]
> at org.apache.phoenix.query.ConnectionQueryServicesImpl.ensureSystemTablesUpgraded(ConnectionQueryServicesImpl.java:3091)
> at org.apache.phoenix.query.ConnectionQueryServicesImpl.access$600(ConnectionQueryServicesImpl.java:260)
> at org.apache.phoenix.query.ConnectionQueryServicesImpl$12.call(ConnectionQueryServicesImpl.java:2418)
> ... 20 more
> {code}
> ping [~giacomotaylor]
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)