Which RC build are you using (0.98 or 1.0)? Does your HBase deploy match the Phoenix version? Can you compare the class path for the process (use `ps aux | grep -i sqlline` or similar) to the actual jars on disk -- everything is there?
Thanks, Nick On Wed, May 6, 2015 at 2:42 AM, Biyuhao <byh0...@gmail.com> wrote: > Hello everyone, > > When I trying to use sqlline.py I got this error. > Am i doing something wrong? Or there is some miss configuration in my > environment? > > > > 0: jdbc:phoenix:localhost> Error: ERROR 103 (08004): Unable to establish > connection. (state=08004,code=103) > java.sql.SQLException: ERROR 103 (08004): Unable to establish connection. > at > > org.apache.phoenix.exception.SQLExceptionCode$Factory$1.newException(SQLExceptionCode.java:386) > at > > org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo.java:145) > at > > org.apache.phoenix.query.ConnectionQueryServicesImpl.openConnection(ConnectionQueryServicesImpl.java:288) > at > > org.apache.phoenix.query.ConnectionQueryServicesImpl.access$300(ConnectionQueryServicesImpl.java:171) > at > > org.apache.phoenix.query.ConnectionQueryServicesImpl$12.call(ConnectionQueryServicesImpl.java:1881) > at > > org.apache.phoenix.query.ConnectionQueryServicesImpl$12.call(ConnectionQueryServicesImpl.java:1860) > at > > org.apache.phoenix.util.PhoenixContextExecutor.call(PhoenixContextExecutor.java:77) > at > > org.apache.phoenix.query.ConnectionQueryServicesImpl.init(ConnectionQueryServicesImpl.java:1860) > at > > org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(PhoenixDriver.java:162) > at > > org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.connect(PhoenixEmbeddedDriver.java:131) > at org.apache.phoenix.jdbc.PhoenixDriver.connect(PhoenixDriver.java:133) > at sqlline.DatabaseConnection.connect(DatabaseConnection.java:157) > at sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:203) > at sqlline.Commands.close(Commands.java:906) > at sqlline.Commands.closeall(Commands.java:880) > at sqlline.SqlLine.begin(SqlLine.java:709) > at sqlline.SqlLine.start(SqlLine.java:398) > at sqlline.SqlLine.main(SqlLine.java:292) > Caused by: java.io.IOException: java.lang.reflect.InvocationTargetException > at > > org.apache.hadoop.hbase.client.ConnectionFactory.createConnection(ConnectionFactory.java:240) > at > > org.apache.hadoop.hbase.client.ConnectionManager.createConnection(ConnectionManager.java:414) > at > > org.apache.hadoop.hbase.client.ConnectionManager.createConnectionInternal(ConnectionManager.java:323) > at > > org.apache.hadoop.hbase.client.HConnectionManager.createConnection(HConnectionManager.java:144) > at > > org.apache.phoenix.query.HConnectionFactory$HConnectionFactoryImpl.createConnection(HConnectionFactory.java:47) > at > > org.apache.phoenix.query.ConnectionQueryServicesImpl.openConnection(ConnectionQueryServicesImpl.java:286) > ... 15 more > Caused by: java.lang.reflect.InvocationTargetException > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) > at > > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) > at > > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) > at java.lang.reflect.Constructor.newInstance(Constructor.java:526) > at > > org.apache.hadoop.hbase.client.ConnectionFactory.createConnection(ConnectionFactory.java:238) > ... 20 more > Caused by: java.lang.NoClassDefFoundError: > org/jboss/netty/channel/ChannelFactory > at java.lang.Class.forName0(Native Method) > at java.lang.Class.forName(Class.java:278) > at > > org.apache.hadoop.conf.Configuration.getClassByNameOrNull(Configuration.java:2051) > at > > org.apache.hadoop.conf.Configuration.getClassByName(Configuration.java:2016) > at org.apache.hadoop.conf.Configuration.getClass(Configuration.java:2110) > at org.apache.hadoop.conf.Configuration.getClass(Configuration.java:2136) > at > > org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation.<init>(ConnectionManager.java:643) > ... 25 more > Caused by: java.lang.ClassNotFoundException: > org.jboss.netty.channel.ChannelFactory > at java.net.URLClassLoader$1.run(URLClassLoader.java:366) > at java.net.URLClassLoader$1.run(URLClassLoader.java:355) > at java.security.AccessController.doPrivileged(Native Method) > at java.net.URLClassLoader.findClass(URLClassLoader.java:354) > at java.lang.ClassLoader.loadClass(ClassLoader.java:425) > at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308) > at java.lang.ClassLoader.loadClass(ClassLoader.java:358) > ... 32 more > > Thank all of you, >
