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

Database connections end up in "idle-in-transaction"-mode

XMLWordPrintable

      Got alerted by Contegix.

      We received alerts for confluence.atlassian.com at 05:55 CST on Friday, February 22nd. At that time, the instance was displaying a resin error, and I noted several dozen "idle in transaction" postgres connections. I have captured a ps of the pg connections, taken thread dumps, and attached the logs. I have restarted the instance following, and the site appears good at this time.

      I looked at the access logs, but could not see any obvious patterns. We decided to track this systematically by regularly quiering the database for what statements the idle in transaction connections were trying to execute, to find the root cause.

      See http://wiki.dspace.org/index.php/Idle_In_Transaction_Problem for an explanation

      We need to investigate further.

            [CONFSERVER-10798] Database connections end up in "idle-in-transaction"-mode

            Katherine Yabut made changes -
            Workflow Original: JAC Bug Workflow v3 [ 2902397 ] New: CONFSERVER Bug Workflow v4 [ 2997037 ]
            Owen made changes -
            Workflow Original: JAC Bug Workflow v2 [ 2799709 ] New: JAC Bug Workflow v3 [ 2902397 ]
            Status Original: Resolved [ 5 ] New: Closed [ 6 ]
            Owen made changes -
            Workflow Original: JAC Bug Workflow [ 2733240 ] New: JAC Bug Workflow v2 [ 2799709 ]
            Owen made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2398608 ] New: JAC Bug Workflow [ 2733240 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 [ 2296573 ] New: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2398608 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5.1 - TEMP [ 2232228 ] New: Confluence Workflow - Public Facing - Restricted v5 [ 2296573 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2192037 ] New: Confluence Workflow - Public Facing - Restricted v5.1 - TEMP [ 2232228 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 [ 1929154 ] New: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2192037 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v3 [ 1729685 ] New: Confluence Workflow - Public Facing - Restricted v5 [ 1929154 ]
            Katherine Yabut made changes -
            Workflow Original: CONF Bug Subtask WF (TEMP) [ 1682660 ] New: Confluence Workflow - Public Facing - Restricted v3 [ 1729685 ]

              matt@atlassian.com Matt Ryall
              pfragemann Per Fragemann [Atlassian]
              Affected customers:
              0 This affects my team
              Watchers:
              0 Start watching this issue

                Created:
                Updated:
                Resolved: