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} >> >> >
