Derby
  1. Derby
  2. DERBY-300

Creation of SQLWarning on a getConnection causes hang on 131 vms when server and client are in same vm.

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Trivial Trivial
    • Resolution: Won't Fix
    • Affects Version/s: 10.1.1.0
    • Fix Version/s: None
    • Component/s: JDBC
    • Labels:
      None
    • Environment:
      seems to occur on 131 vms, hang seen on both sun 1.3.1 and ibm 1.3.1

      Description

      Problem - with 131 vms, if server and client are in the same jvm, on a second get connection with create=true attribute in the url, there is a hang.

      Basically,
      – the first getConnection works ok
      – but on the second getConnection, a SQLWarning needs to be generated to say that the database already exists and in this scenario, it seems like at the point where it is creating a SQLWarning , there is a deadlock. The call to SQLWarning constructor does not return. On doing a java core dump , the thread in question seems to be in a wait state (conditional wait). Guess is it has to do with the driver manager lock

      Also note, this problem is observed only with 131 vms, so I guess it was fixed in the later vms (1.4.1, 1.4.2 1.5)

      Opened this entry to keep track of this.

      1. testNS.java
        3 kB
        Sunitha Kambhampati

        Activity

        Sunitha Kambhampati created issue -
        Hide
        Sunitha Kambhampati added a comment -

        Repro for the hang. To run java testNS

        Show
        Sunitha Kambhampati added a comment - Repro for the hang. To run java testNS
        Sunitha Kambhampati made changes -
        Field Original Value New Value
        Attachment testNS.java [ 20154 ]
        Hide
        Kathey Marsden added a comment -

        Won't fix since 1.3.1 is no longer supported.

        Show
        Kathey Marsden added a comment - Won't fix since 1.3.1 is no longer supported.
        Kathey Marsden made changes -
        Resolution Won't Fix [ 2 ]
        Status Open [ 1 ] Resolved [ 5 ]
        Kathey Marsden made changes -
        Status Resolved [ 5 ] Closed [ 6 ]
        Gavin made changes -
        Workflow jira [ 42719 ] Default workflow, editable Closed status [ 12800369 ]

          People

          • Assignee:
            Unassigned
            Reporter:
            Sunitha Kambhampati
          • Votes:
            1 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development