This is resolved. I had been testing 3.0.0-SNAPSHOT and it had messed things up bit. Since this is a test cluster, I simply dropped the SYSTEM.TABLE, reconnected via sqlline and recreated my phoenix tables. Underlying HBase data was still intact.
Thanks On Thu, Feb 13, 2014 at 10:40 AM, James Taylor <[email protected]>wrote: > So the NPE happens when you start sqlline? There's nothing Phoenix-related > on the stack. > > Can you send me the output from a scan over your SYSTEM.TABLE from the > HBase shell? > > > > > On Thu, Feb 13, 2014 at 9:30 AM, Justin Workman > <[email protected]>wrote: > >> Connected to: Phoenix (version 2.2) >> Driver: org.apache.phoenix.jdbc.PhoenixDriver (version 2.2) >> Autocommit status: true >> Transaction isolation: TRANSACTION_READ_COMMITTED >> Building list of tables and columns for tab-completion (set fastconnect >> to true to skip)... >> 210/210 (100%) Done >> Done >> java.lang.NullPointerException >> at java.util.TreeMap.put(TreeMap.java:556) >> at java.util.TreeSet.add(TreeSet.java:255) >> at sqlline.SqlLine$SQLLineSQLCompletor.<init>(SqlLine.java:4434) >> at sqlline.SqlLine$DatabaseConnection.setCompletions(SqlLine.java:4574) >> at sqlline.SqlLine$DatabaseConnection.access$700(SqlLine.java:4508) >> at sqlline.SqlLine.setCompletions(SqlLine.java:1814) >> at sqlline.SqlLine.access$2500(SqlLine.java:56) >> at sqlline.SqlLine$Commands.connect(SqlLine.java:3944) >> at sqlline.SqlLine$Commands.connect(SqlLine.java:3851) >> 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.SqlLine$ReflectiveCommandHandler.execute(SqlLine.java:2810) >> at sqlline.SqlLine.dispatch(SqlLine.java:817) >> at sqlline.SqlLine.initArgs(SqlLine.java:633) >> at sqlline.SqlLine.begin(SqlLine.java:680) >> at sqlline.SqlLine.mainWithInputRedirection(SqlLine.java:441) >> at sqlline.SqlLine.main(SqlLine.java:424) >> java.lang.NullPointerException >> at java.util.Properties$LineReader.readLine(Properties.java:434) >> at java.util.Properties.load0(Properties.java:353) >> at java.util.Properties.load(Properties.java:341) >> at sqlline.SqlLine.getApplicationTitle(SqlLine.java:364) >> at sqlline.SqlLine.begin(SqlLine.java:686) >> at sqlline.SqlLine.mainWithInputRedirection(SqlLine.java:441) >> at sqlline.SqlLine.main(SqlLine.java:424) >> 0: jdbc:phoenix:name01.hadoop.test.overstock.> !tables >> >> +------------+-------------+------------+------------+------------+------------+---------------------------+----------------+-------------+----------------+ >> | TABLE_CAT | TABLE_SCHEM | TABLE_NAME | TABLE_TYPE | REMARKS | >> TYPE_NAME | SELF_REFERENCING_COL_NAME | REF_GENERATION | INDEX_STATE | >> IMMUTABLE_ROWS | >> >> +------------+-------------+------------+------------+------------+------------+---------------------------+----------------+-------------+----------------+ >> >> +------------+-------------+------------+------------+------------+------------+---------------------------+----------------+-------------+----------------+ >> 0: jdbc:phoenix:name01.hadoop.test.overstock.> !quit >> >> >> >> On Thu, Feb 13, 2014 at 10:19 AM, James Taylor <[email protected]>wrote: >> >>> Can you send me the NPE you get on startup? >>> >>> On first connection to the cluster, Phoenix will do the following: >>> 1) switch coprocessors on SYSTEM.TABLE to the new org.apache ones >>> 2) scan your SYSTEM.TABLE for any existing tables and switch >>> coprocessors on them too >>> >>> Looks like something went wrong between (1) and (2). >>> >>> Thanks, >>> James >>> >>> >>> >>> On Thu, Feb 13, 2014 at 8:55 AM, Justin Workman < >>> [email protected]> wrote: >>> >>>> I updated phoenix in my test cluster today from 2.2.2 to 2.2.3. Every >>>> thing starts fine, however I when running sqlline I get a Null Pointer >>>> exception on startup and no tables are show when issuing a !tables command. >>>> >>>> When looking at the tables in HBase shell, I can see that the >>>> coprocessor definitions on the SYSTEM.TABLE have been updated to >>>> org.apache.phoenix.XXX but none of the other tables were updated, and the >>>> SYSTEM.TABLE does not show up in sqlline shell either. >>>> >>>> Any pointers on how I would go about updating the coprocessors on these >>>> tables, and what I need to do to get the tables to show via sqlline. When I >>>> connect via sqlline this is the only thing I see in the master servers >>>> logs. >>>> >>>> 2014-02-13 09:47:40,946 INFO >>>> org.apache.phoenix.coprocessor.UngroupedAggregateRegionObserver: Starting >>>> ungrouped coprocessor scan >>>> {"timeRange":[0,7],"batch":-1,"startRow":"","stopRow":"","totalColumns":0,"cacheBlocks":true,"families":{"_0":[]},"maxVersions":1,"caching":1000} >>>> 2014-02-13 09:47:40,962 INFO >>>> org.apache.phoenix.coprocessor.UngroupedAggregateRegionObserver: Finished >>>> scanning 0 rows for ungrouped coprocessor scan >>>> {"timeRange":[0,7],"batch":-1,"startRow":"","stopRow":"","totalColumns":0,"cacheBlocks":true,"families":{"_0":[]},"maxVersions":1,"caching":1000} >>>> >>>> >>> >> >
