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

Suggest use of indexes in devguide's deadlock avoidance topic

Attach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    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. DERBY-6375-2.diff
          1 kB
          Camilla Haase
        2. DERBY-6375.diff
          1 kB
          Camilla Haase
        3. cdevconcepts53677.html
          6 kB
          Camilla Haase
        4. cdevconcepts53677.html
          6 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
          $i18n.getText('security.level.explanation', $currentSelection) Viewable by All Users
          Cancel

            People

            • Assignee:
              chaase3 Camilla Haase
              Reporter:
              knutanders Knut Anders Hatlen

              Dates

              • Created:
                Updated:
                Resolved:

                Issue deployment