Derby
  1. Derby
  2. DERBY-2510

Network server does not release locks on commit and getMoreResults if multiple resultsets are returned by a stored procedure

    Details

    • Urgency:
      Normal
    • Issue & fix info:
      Newcomer
    • Bug behavior facts:
      Embedded/Client difference

      Description

      In converting the procedure.java tests I found that locks were not being released properly after commit and getMoreResults(). See comment at https://issues.apache.org/jira/browse/DERBY-2461#action_12486075 for details. The fixture checkCommitWithMultipleResultSets in the converted test LangProcedureTest will not run with Network Server until this is fixed.

        Issue Links

          Activity

          Hide
          Kathey Marsden added a comment -

          This issue was found when converting procedure.java DERBY-2461

          Show
          Kathey Marsden added a comment - This issue was found when converting procedure.java DERBY-2461
          Hide
          Øystein Grøvlen added a comment -

          What kind of locks are we talking about here? I would assume that network server has no responsibility for releasing row locks and table locks. Such locks are released on transaction commit. Could the problem be that commit is not done?

          Show
          Øystein Grøvlen added a comment - What kind of locks are we talking about here? I would assume that network server has no responsibility for releasing row locks and table locks. Such locks are released on transaction commit. Could the problem be that commit is not done?
          Hide
          Kathey Marsden added a comment -

          Triage for 10.8. This might be a good newcomer issue to analyze the locks.

          Show
          Kathey Marsden added a comment - Triage for 10.8. This might be a good newcomer issue to analyze the locks.

            People

            • Assignee:
              Unassigned
              Reporter:
              Kathey Marsden
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:

                Development