Derby
  1. Derby
  2. DERBY-2010

Unsetting derby.locks.waitTimeout as a database property does not reset the wait timeout to the default value.

    Details

    • Type: Bug Bug
    • Status: Open
    • Priority: Minor Minor
    • Resolution: Unresolved
    • Affects Version/s: 10.2.1.6, 10.3.1.4
    • Fix Version/s: None
    • Component/s: Services
    • Urgency:
      Normal
    • Issue & fix info:
      Repro attached

      Description

      Simple script that shows the problem, requires a database db with a table T.
      First timeout wait is 60 seconds (default), next is 4 seconds (the setting), next is 4 seconds when it should be 60 the default.

      connect 'jdbc:derby:db' AS C1;
      AUTOCOMMIT OFF;
      LOCK TABLE T IN EXCLUSIVE MODE;
      connect 'jdbc:derby:db' AS C2;
      – Default wait;
      VALUES CURRENT TIMESTAMP;
      LOCK TABLE T IN EXCLUSIVE MODE;
      VALUES CURRENT TIMESTAMP;

      – 4 second wait
      CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(
      'derby.locks.waitTimeout', '4');
      VALUES CURRENT TIMESTAMP;
      LOCK TABLE T IN EXCLUSIVE MODE;
      VALUES CURRENT TIMESTAMP;

      – back to default
      CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(
      'derby.locks.waitTimeout', null);
      VALUES CURRENT TIMESTAMP;
      LOCK TABLE T IN EXCLUSIVE MODE;
      VALUES CURRENT TIMESTAMP;

        Issue Links

          Activity

          Daniel John Debrunner created issue -
          Daniel John Debrunner made changes -
          Field Original Value New Value
          Link This issue is related to DERBY-1762 [ DERBY-1762 ]
          Hide
          Knut Anders Hatlen added a comment -

          Triaged for 10.5.2.

          Show
          Knut Anders Hatlen added a comment - Triaged for 10.5.2.
          Knut Anders Hatlen made changes -
          Urgency Normal
          Issue & fix info [Repro attached]
          Kathey Marsden made changes -
          Labels derby_triage10_5_2
          Gavin made changes -
          Workflow jira [ 12387925 ] Default workflow, editable Closed status [ 12798785 ]

            People

            • Assignee:
              Unassigned
              Reporter:
              Daniel John Debrunner
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:

                Development