You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "James Taylor (JIRA)" <ji...@apache.org> on 2014/03/09 20:03:45 UTC

[jira] [Resolved] (PHOENIX-7) after Connection close, there are still 10 phoenix threads alive

     [ https://issues.apache.org/jira/browse/PHOENIX-7?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

James Taylor resolved PHOENIX-7.
--------------------------------

       Resolution: Fixed
    Fix Version/s: 3.0.0
         Assignee: James Taylor

Set our threads as daemon threads, so this should be better now. Please confirm

> after Connection close, there are still 10 phoenix threads alive
> ----------------------------------------------------------------
>
>                 Key: PHOENIX-7
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-7
>             Project: Phoenix
>          Issue Type: Bug
>    Affects Versions: 2.2.3
>         Environment: jdk 1.7_upate 45 Ubuntu 11.10
> phoenix 2.2.2
> hbase 0.94.11
>            Reporter: LiLi
>            Assignee: James Taylor
>             Fix For: 3.0.0
>
>
> public class TestJDBC {
>     public static void main(String[] args) throws Exception {
>         Statement stmt = null;
>         ResultSet rset = null;
>         Class.forName("com.salesforce.phoenix.jdbc.PhoenixDriver");
>         Connection con = DriverManager.getConnection("jdbc:phoenix:localhost");
>         stmt = con.createStatement();
>         stmt.executeUpdate("create table test (mykey integer not null primary key, mycolumn varchar)");
>         stmt.executeUpdate("upsert into test values (1,'Hello')");
>         stmt.executeUpdate("upsert into test values (2,'world!')");
>         con.commit();
>         PreparedStatement statement = con.prepareStatement("select * from test");
>         rset = statement.executeQuery();
>         while (rset.next()) {
>             System.out.println(rset.getString("mycolumn"));
>         }
>         statement.close();
>         con.close();
>     }
> }
> after main thread finish, phoenix threads are still waiting about 60s.
> Thread [phoenix-1-thread-0] (Suspended)	
> 	waiting for: Object  (id=42)	
> 	Object.wait(long) line: not available [native method]	
> 	JobManager<T>(AbstractRoundRobinQueue<E>).poll(long, TimeUnit) line: 146	
> 	JobManager$1(ThreadPoolExecutor).getTask() line: 1068	
> 	JobManager$1(ThreadPoolExecutor).runWorker(ThreadPoolExecutor$Worker) line: 1130	
> 	ThreadPoolExecutor$Worker.run() line: 615	
> 	Thread.run() line: 744	



--
This message was sent by Atlassian JIRA
(v6.2#6252)