[ 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: an...@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)