Uploaded image for project: 'Confluence Data Center'
  1. Confluence Data Center
  2. CONFSERVER-2775

Database connection is not closed and transaction isn't ended

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Highest Highest
    • 1.4
    • 1.3.4
    • None
    • Oracle 10g
      Tomcat 5

      Our Confluence production environment has crashed many times during the last few days because some transaction is never ended and the database connection isn't closed. The transaction has obtained locks to content and therefore blocks all updates to certain rows. This causes connection pool to be exhausted and Confluence is no more able to service any users.

      Checking from the database, there is an open connection with event "SQL*Net message from client" meaning that it waits for the client. The connection has obtained locks to content and other tables as well. The connection is established from the Confluence server for sure and has been idle/waiting for hours.

        1. abandonenConnections.txt
          58 kB
        2. thread-dump.txt
          81 kB

            [CONFSERVER-2775] Database connection is not closed and transaction isn't ended

            Katherine Yabut made changes -
            Workflow Original: JAC Bug Workflow v3 [ 2894878 ] New: CONFSERVER Bug Workflow v4 [ 2987280 ]
            Owen made changes -
            Workflow Original: JAC Bug Workflow v2 [ 2781667 ] New: JAC Bug Workflow v3 [ 2894878 ]
            Status Original: Resolved [ 5 ] New: Closed [ 6 ]
            Owen made changes -
            Workflow Original: JAC Bug Workflow [ 2709739 ] New: JAC Bug Workflow v2 [ 2781667 ]
            Owen made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2374760 ] New: JAC Bug Workflow [ 2709739 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 [ 2260956 ] New: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2374760 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5.1 - TEMP [ 2211414 ] New: Confluence Workflow - Public Facing - Restricted v5 [ 2260956 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2157729 ] New: Confluence Workflow - Public Facing - Restricted v5.1 - TEMP [ 2211414 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 [ 1913482 ] New: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2157729 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v3 [ 1721381 ] New: Confluence Workflow - Public Facing - Restricted v5 [ 1913482 ]
            Katherine Yabut made changes -
            Workflow Original: CONF Bug Subtask WF (TEMP) [ 1679065 ] New: Confluence Workflow - Public Facing - Restricted v3 [ 1721381 ]

              Unassigned Unassigned
              760f629e6819 Jarno Peltoniemi
              Affected customers:
              3 This affects my team
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: