phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ankit Singhal (JIRA)" <j...@apache.org>
Subject [jira] [Comment Edited] (PHOENIX-3726) Error while upgrading system tables
Date Thu, 08 Jun 2017 19:17:18 GMT

    [ 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)

Mime
View raw message