Uploaded image for project: 'Tajo'
  1. Tajo
  2. TAJO-1619

JDBC program is stuck after closing

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 0.10.0
    • Fix Version/s: 0.10.1
    • Component/s: JDBC Driver
    • Labels:
      None

      Description

      JdbcTest.java
      public class JdbcTest {
        public static void main(String [] args) throws ClassNotFoundException, SQLException {
          Class.forName("org.apache.tajo.jdbc.TajoDriver");
      
          Connection conn = DriverManager.getConnection("jdbc:tajo://127.0.0.1:26002/tpch");
      
          Statement stmt = null;
          ResultSet rs = null;
          try {
            stmt = conn.createStatement();
            rs = stmt.executeQuery("select count(*) from customer");
            System.out.println(rs.next());
            System.out.println(rs.getInt(1));
      
          } catch (SQLException e) {
            System.err.println(e.getMessage());
          } finally {
            System.out.println("close start");
            if (rs != null) rs.close();
            System.out.println("rs close end");
            if (stmt != null) stmt.close();
            System.out.println("stmt close end");
            if (conn != null) conn.close();
            System.out.println("conn close end");
          }
        }
      }
      

      When the code above is executed, it is stuck after printing 'conn close end'.

      I attache log and thread dump.

      1. dump
        4 kB
        Jongyoung Park
      2. tajo-eminency-master-Jongyoungui-MBP.log
        1.56 MB
        Jongyoung Park
      3. tajo-eminency-worker-Jongyoungui-MBP.log
        1.22 MB
        Jongyoung Park

        Activity

        Hide
        githubbot ASF GitHub Bot added a comment -

        GitHub user jihoonson opened a pull request:

        https://github.com/apache/tajo/pull/584

        TAJO-1619: JDBC program is stuck after closing

        You can merge this pull request into a Git repository by running:

        $ git pull https://github.com/jihoonson/tajo-2 TAJO-1619

        Alternatively you can review and apply these changes as the patch at:

        https://github.com/apache/tajo/pull/584.patch

        To close this pull request, make a commit to your master/trunk branch
        with (at least) the following in the commit message:

        This closes #584


        commit 7033cb452e00fb49b95941fec1f98c96c3e024ec
        Author: Jihoon Son <jihoonson@apache.org>
        Date: 2015-05-26T02:01:27Z

        TAJO-1619


        Show
        githubbot ASF GitHub Bot added a comment - GitHub user jihoonson opened a pull request: https://github.com/apache/tajo/pull/584 TAJO-1619 : JDBC program is stuck after closing You can merge this pull request into a Git repository by running: $ git pull https://github.com/jihoonson/tajo-2 TAJO-1619 Alternatively you can review and apply these changes as the patch at: https://github.com/apache/tajo/pull/584.patch To close this pull request, make a commit to your master/trunk branch with (at least) the following in the commit message: This closes #584 commit 7033cb452e00fb49b95941fec1f98c96c3e024ec Author: Jihoon Son <jihoonson@apache.org> Date: 2015-05-26T02:01:27Z TAJO-1619
        Hide
        githubbot ASF GitHub Bot added a comment -

        Github user jinossy commented on the pull request:

        https://github.com/apache/tajo/pull/584#issuecomment-105418732

        +1 LGTM!!

        Show
        githubbot ASF GitHub Bot added a comment - Github user jinossy commented on the pull request: https://github.com/apache/tajo/pull/584#issuecomment-105418732 +1 LGTM!!
        Hide
        tajoqa Tajo QA added a comment -

        -1 overall. Here are the results of testing the latest attachment
        http://issues.apache.org/jira/secure/attachment/12734770/tajo-eminency-worker-Jongyoungui-MBP.log
        against master revision release-0.9.0-rc0-306-gbbfa076.

        -1 patch. The patch command could not apply the patch.

        -1 patch. The patch command could not apply the patch.

        Console output: https://builds.apache.org/job/PreCommit-TAJO-Build/801//console

        This message is automatically generated.

        Show
        tajoqa Tajo QA added a comment - -1 overall. Here are the results of testing the latest attachment http://issues.apache.org/jira/secure/attachment/12734770/tajo-eminency-worker-Jongyoungui-MBP.log against master revision release-0.9.0-rc0-306-gbbfa076. -1 patch. The patch command could not apply the patch. -1 patch. The patch command could not apply the patch. Console output: https://builds.apache.org/job/PreCommit-TAJO-Build/801//console This message is automatically generated.
        Hide
        jihoonson Jihoon Son added a comment -

        Thanks for quick review.
        Committed to master and 0.10.1 branches.

        Show
        jihoonson Jihoon Son added a comment - Thanks for quick review. Committed to master and 0.10.1 branches.
        Hide
        githubbot ASF GitHub Bot added a comment -

        Github user jihoonson closed the pull request at:

        https://github.com/apache/tajo/pull/584

        Show
        githubbot ASF GitHub Bot added a comment - Github user jihoonson closed the pull request at: https://github.com/apache/tajo/pull/584
        Hide
        hudson Hudson added a comment -

        ABORTED: Integrated in Tajo-master-CODEGEN-build #356 (See https://builds.apache.org/job/Tajo-master-CODEGEN-build/356/)
        TAJO-1619: JDBC program is stuck after closing. (jihoon) (jihoonson: rev 4b2ab61072031ee39565755c285ef267e9451b55)

        • tajo-client/src/main/java/org/apache/tajo/client/SessionConnection.java
        • tajo-jdbc/src/main/java/org/apache/tajo/jdbc/JdbcConnection.java
        • CHANGES
        Show
        hudson Hudson added a comment - ABORTED: Integrated in Tajo-master-CODEGEN-build #356 (See https://builds.apache.org/job/Tajo-master-CODEGEN-build/356/ ) TAJO-1619 : JDBC program is stuck after closing. (jihoon) (jihoonson: rev 4b2ab61072031ee39565755c285ef267e9451b55) tajo-client/src/main/java/org/apache/tajo/client/SessionConnection.java tajo-jdbc/src/main/java/org/apache/tajo/jdbc/JdbcConnection.java CHANGES
        Hide
        hudson Hudson added a comment -

        SUCCESS: Integrated in Tajo-master-build #716 (See https://builds.apache.org/job/Tajo-master-build/716/)
        TAJO-1619: JDBC program is stuck after closing. (jihoon) (jihoonson: rev 4b2ab61072031ee39565755c285ef267e9451b55)

        • tajo-jdbc/src/main/java/org/apache/tajo/jdbc/JdbcConnection.java
        • CHANGES
        • tajo-client/src/main/java/org/apache/tajo/client/SessionConnection.java
        Show
        hudson Hudson added a comment - SUCCESS: Integrated in Tajo-master-build #716 (See https://builds.apache.org/job/Tajo-master-build/716/ ) TAJO-1619 : JDBC program is stuck after closing. (jihoon) (jihoonson: rev 4b2ab61072031ee39565755c285ef267e9451b55) tajo-jdbc/src/main/java/org/apache/tajo/jdbc/JdbcConnection.java CHANGES tajo-client/src/main/java/org/apache/tajo/client/SessionConnection.java

          People

          • Assignee:
            jihoonson Jihoon Son
            Reporter:
            eminency Jongyoung Park
          • Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development