[
https://issues.apache.org/jira/browse/PHOENIX-56?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13904877#comment-13904877
]
Russell Jurney commented on PHOENIX-56:
---------------------------------------
James: we ran your class. Here is what it does:
[2/18/14, 3:26:02 PM] Lance Riedel: [hivedata@hiveapp1 phoenix-debug]$ java -cp
/home/hivedata/phoenix-2.2.2/target/phoenix-2.2.2-client.jar:/home/hivedata/phoenix-debug/target/phoenix-debug-1.0-SNAPSHOT.jar
com.hivedata.phoenix.PhoenixSqlline -u jdbc:phoenix:localhost -n none -p none
--color=true --fastConnect=false --silent=false --verbose=true
--isolation=TRANSACTION_READ_COMMITTED
Setting property: [isolation, TRANSACTION_READ_COMMITTED]
issuing: !connect jdbc:phoenix:localhost none none
Connecting to jdbc:phoenix:localhost
log4j:WARN No appenders could be found for logger
(org.apache.hadoop.conf.Configuration).
log4j:WARN Please initialize the log4j system properly.
log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more
info.
then it hangs
[2/18/14, 3:26:59 PM] Lance Riedel: then every 10 seconds, there is another one
of these:
[2/18/14, 3:26:59 PM] Lance Riedel: java 21975 hivedata 24u IPv6
22534609 0t0 TCP hiveapp1:58596->hiveapp1:60000
(ESTABLISHED)
java 21975 hivedata 25u IPv6 22534625 0t0
TCP hiveapp1:58599->hiveapp1:60000 (ESTABLISHED)
java 21975 hivedata 26u IPv6 22534632 0t0
TCP hiveapp1:58601->hiveapp1:60000 (ESTABLISHED)
java 21975 hivedata 27u IPv6 22534644 0t0
TCP hiveapp1:58603->hiveapp1:60000 (ESTABLISHED)
java 21975 hivedata 28u IPv6 22534657 0t0
TCP hiveapp1:58607->hiveapp1:60000 (ESTABLISHED)
java 21975 hivedata 29u IPv6 22534695 0t0
TCP hiveapp1:58612->hiveapp1:60000 (ESTABLISHED)
java 21975 hivedata 30u IPv6 22534783 0t0
TCP hiveapp1:58637->hiveapp1:60000 (ESTABLISHED)
It stops at 8-9 connections. This is where it is hanging i think:
"main" prio=10 tid=0x00007f9350008800 nid=0x55d8 in Object.wait()
[0x00007f9356b52000]
java.lang.Thread.State: TIMED_WAITING (on object monitor)
at java.lang.Object.wait(Native Method)
- waiting on <0x000000075d59dc20> (a java.lang.Object)
at
org.apache.hadoop.hbase.client.HConnectionManager$HConnectionImplementation.getMaster(HConnectionManager.java:834)
- locked <0x000000075d59dc20> (a java.lang.Object)
at org.apache.hadoop.hbase.client.HBaseAdmin.<init>(HBaseAdmin.java:127)
at
com.salesforce.phoenix.query.ConnectionQueryServicesImpl.ensureTableCreated(ConnectionQueryServicesImpl.java:610)
at
com.salesforce.phoenix.query.ConnectionQueryServicesImpl.createTable(ConnectionQueryServicesImpl.java:1048)
at
com.salesforce.phoenix.schema.MetaDataClient.createTable(MetaDataClient.java:783)
at
com.salesforce.phoenix.schema.MetaDataClient.createTable(MetaDataClient.java:338)
at
com.salesforce.phoenix.compile.CreateTableCompiler$1.execute(CreateTableCompiler.java:83)
at
com.salesforce.phoenix.jdbc.PhoenixStatement$ExecutableCreateTableStatement.executeUpdate(PhoenixStatement.java:357)
at
com.salesforce.phoenix.jdbc.PhoenixStatement.executeUpdate(PhoenixStatement.java:1036)
at
com.salesforce.phoenix.query.ConnectionQueryServicesImpl.init(ConnectionQueryServicesImpl.java:1205)
at
com.salesforce.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(PhoenixDriver.java:87)
at
com.salesforce.phoenix.jdbc.PhoenixEmbeddedDriver.connect(PhoenixEmbeddedDriver.java:115)
at sqlline.SqlLine$DatabaseConnection.connect(SqlLine.java:4650)
at sqlline.SqlLine$DatabaseConnection.getConnection(SqlLine.java:4701)
at sqlline.SqlLine$Commands.connect(SqlLine.java:3942)
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:622)
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)
at com.hivedata.phoenix.PhoenixSqlline.main(PhoenixSqlline.java:16)
It is freezing here:
admin = new HBaseAdmin(config);
> Phoenix/JDBC becomes unresponsive
> ---------------------------------
>
> Key: PHOENIX-56
> URL: https://issues.apache.org/jira/browse/PHOENIX-56
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 2.2.3
> Environment: HBase 0.94.6
> Reporter: Russell Jurney
> Attachments: hbase-site.xml, hbase.dump, sqlline.jstack
>
>
> After some hours or days, our Phoenix JDBC connection becomes unresponsive.
> It can't be reached unless we remove all tables, including SYSTEM.TABLE and
> restart HBase.
> There are no errors that accompany this problem, so we don't know how to
> debug it. Is anyone else seeing this behavior?
> Using a different client version of the JAR does result in an error saying
> version mismatch... so at some level we think the service is running. It just
> can't complete a connection. sqlline.sh freezes when we connect.
--
This message was sent by Atlassian JIRA
(v6.1.5#6160)
