Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-6375

Suggest use of indexes in devguide's deadlock avoidance topic

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.10.1.1
    • Fix Version/s: 10.10.2.0, 10.11.1.1
    • Component/s: Documentation
    • Labels:
      None

      Description

      The developer's guide has a topic called Avoiding deadlocks. That topic should also mention that reasonable indexes may help prevent deadlocks since they make table scans less likely and reduce the number of locks obtained.

        Attachments

        1. cdevconcepts53677.html
          6 kB
          Camilla Haase
        2. cdevconcepts53677.html
          6 kB
          Camilla Haase
        3. DERBY-6375.diff
          1 kB
          Camilla Haase
        4. DERBY-6375-2.diff
          1 kB
          Camilla Haase

          Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. DERBY-6372 ERROR 40001: A lock could not be obtained due to a deadlock

          • Major - Major loss of function.
          • Closed

            Activity

              People

              • Assignee:
                chaase3 Camilla Haase
                Reporter:
                knutanders Knut Anders Hatlen
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: