Quantcast

Can't connect to Apache Phoenix

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Can't connect to Apache Phoenix

jeremy p
Hello all,

I'm running Apache Phoenix 4.2 on top of HBase .98 and Hadoop 2.5.  I'm running the whole stack on my workstation in "pseudo distributed mode" (essentially a single-node cluster).  I'm trying to use SquirrelSQL 2.6 Standard to connect to Phoenix, however I keep getting an exception.

I followed the directions here :

I know that Haddop/HBase/Phoenix is running fine, because I can connect to Phoenix using the command line utilities that ship with it.

When I try to connect to Phoenix with SquirrelSql, I get this error : 
Unexpected Error occurred attempting to open an SQL connection.

And this stack trace :
java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.lang.IllegalAccessError: class org.apache.commons.collections.iterators.EmptyOrderedIterator cannot access its superclass org.apache.commons.collections.iterators.AbstractEmptyIterator
at java.util.concurrent.FutureTask.report(FutureTask.java:122)
at java.util.concurrent.FutureTask.get(FutureTask.java:202)
at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.awaitConnection(OpenConnectionCommand.java:132)
at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.access$100(OpenConnectionCommand.java:45)
at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand$2.run(OpenConnectionCommand.java:115)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.RuntimeException: java.lang.IllegalAccessError: class org.apache.commons.collections.iterators.EmptyOrderedIterator cannot access its superclass org.apache.commons.collections.iterators.AbstractEmptyIterator
at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.executeConnect(OpenConnectionCommand.java:175)
at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.access$000(OpenConnectionCommand.java:45)
at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand$1.run(OpenConnectionCommand.java:104)
... 5 more
Caused by: java.lang.IllegalAccessError: class org.apache.commons.collections.iterators.EmptyOrderedIterator cannot access its superclass org.apache.commons.collections.iterators.AbstractEmptyIterator
at java.lang.ClassLoader.defineClass1(Native Method)
at java.lang.ClassLoader.defineClass(ClassLoader.java:800)
at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:142)
at java.net.URLClassLoader.defineClass(URLClassLoader.java:449)
at java.net.URLClassLoader.access$100(URLClassLoader.java:71)
at java.net.URLClassLoader$1.run(URLClassLoader.java:361)
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 net.sourceforge.squirrel_sql.fw.util.MyURLClassLoader.findClass(MyURLClassLoader.java:209)
at java.lang.ClassLoader.loadClass(ClassLoader.java:425)
at java.lang.ClassLoader.loadClass(ClassLoader.java:358)
at org.apache.commons.collections.map.AbstractLinkedMap.createKeySetIterator(AbstractLinkedMap.java:445)
at org.apache.commons.collections.map.AbstractHashedMap$KeySet.iterator(AbstractHashedMap.java:924)
at org.apache.commons.configuration.BaseConfiguration.getKeys(BaseConfiguration.java:151)
at org.apache.commons.configuration.AbstractFileConfiguration.getKeys(AbstractFileConfiguration.java:964)
at org.apache.commons.configuration.AbstractConfiguration.getKeys(AbstractConfiguration.java:563)
at org.apache.commons.configuration.SubsetConfiguration.getKeys(SubsetConfiguration.java:189)
at org.apache.commons.configuration.SubsetConfiguration.getKeys(SubsetConfiguration.java:200)
at org.apache.hadoop.metrics2.impl.MetricsConfig$1.iterator(MetricsConfig.java:164)
at org.apache.hadoop.metrics2.impl.MetricsConfig.getInstanceConfigs(MetricsConfig.java:147)
at org.apache.hadoop.metrics2.impl.MetricsSystemImpl.configureSinks(MetricsSystemImpl.java:457)
at org.apache.hadoop.metrics2.impl.MetricsSystemImpl.configure(MetricsSystemImpl.java:447)
at org.apache.hadoop.metrics2.impl.MetricsSystemImpl.start(MetricsSystemImpl.java:180)
at org.apache.hadoop.metrics2.impl.MetricsSystemImpl.init(MetricsSystemImpl.java:156)
at org.apache.phoenix.metrics.Metrics.initialize(Metrics.java:45)
at org.apache.phoenix.trace.TraceMetricSource.<init>(TraceMetricSource.java:86)
at org.apache.phoenix.trace.util.Tracing.addTraceMetricsSource(Tracing.java:315)
at org.apache.phoenix.jdbc.PhoenixConnection.<clinit>(PhoenixConnection.java:130)
at org.apache.phoenix.query.ConnectionQueryServicesImpl$9.call(ConnectionQueryServicesImpl.java:1519)
at org.apache.phoenix.query.ConnectionQueryServicesImpl$9.call(ConnectionQueryServicesImpl.java:1491)
at org.apache.phoenix.util.PhoenixContextExecutor.call(PhoenixContextExecutor.java:77)
at org.apache.phoenix.query.ConnectionQueryServicesImpl.init(ConnectionQueryServicesImpl.java:1491)
at org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(PhoenixDriver.java:162)
at org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.connect(PhoenixEmbeddedDriver.java:126)
at org.apache.phoenix.jdbc.PhoenixDriver.connect(PhoenixDriver.java:133)
at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:133)
at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.executeConnect(OpenConnectionCommand.java:167)
... 7 more


Any idea what's going on here?

Thanks for taking a look!

--Jeremy

------------------------------------------------------------------------------
Comprehensive Server Monitoring with Site24x7.
Monitor 10 servers for $9/Month.
Get alerted through email, SMS, voice calls or mobile push notifications.
Take corrective actions from your mobile device.
http://pubads.g.doubleclick.net/gampad/clk?id=154624111&iu=/4140/ostg.clktrk
_______________________________________________
Squirrel-sql-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
Loading...