Uploaded image for project: 'Crowd Data Center'
  1. Crowd Data Center
  2. CWD-3768

A failure in a single DB connection causes deadlock in Crowd

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Medium Medium
    • 2.7.2
    • 2.7.1
    • None
    • None

      Symptoms

      Crowd becomes unresponsive. A thread dump shows that all threads are in WAITING state, except one which is RUNNABLE and reading from the JDBC socket (SocketInputStream.read) while at the same time holding the WRITE lock in SwitchableTokenManagerImpl.

      Postgres logs contain "LOG: could not send data to client: Broken pipe".

      Steps to reproduce

      This issue is affecting some customers. I haven't been able to reproduce it locally. The key to reproduce this issue seems to be able to kill a connection between Crowd and Postgres in such way that Postgres believes it's closed ("broken pipe"), while Crowd keeps waiting to read from the socket.

      This issue seems to happen only when using database token storage.

            [CWD-3768] A failure in a single DB connection causes deadlock in Crowd

            Monique Khairuliana (Inactive) made changes -
            Workflow Original: Simplified Crowd Development Workflow v2 - restricted [ 1510283 ] New: JAC Bug Workflow v3 [ 3365479 ]
            Status Original: Resolved [ 5 ] New: Closed [ 6 ]
            Owen made changes -
            Workflow Original: Simplified Crowd Development Workflow v2 [ 1393410 ] New: Simplified Crowd Development Workflow v2 - restricted [ 1510283 ]
            Owen made changes -
            Workflow Original: Crowd Development Workflow v2 [ 619450 ] New: Simplified Crowd Development Workflow v2 [ 1393410 ]
            Ferd made changes -
            Remote Link New: This issue links to "Page (Extranet)" [ 139229 ]
            Jonathan G made changes -
            Remote Link Original: This issue links to "Page (Extranet)" [ 63059 ] New: This issue links to "Page (Extranet)" [ 63059 ]
            Caspar Krieger (Inactive) made changes -
            Remote Link Original: This issue links to "Page (Extranet)" [ 63059 ] New: This issue links to "Page (Extranet)" [ 63059 ]
            Caspar Krieger (Inactive) made changes -
            Remote Link Original: This issue links to "Page (Extranet)" [ 63059 ] New: This issue links to "Page (Extranet)" [ 63059 ]
            Diego Berrueta made changes -
            Remote Link New: This issue links to "Page (Extranet)" [ 63059 ]
            Diego Berrueta made changes -
            Fix Version/s New: 2.7.2 [ 37493 ]
            Resolution New: Fixed [ 1 ]
            Status Original: In Progress [ 3 ] New: Resolved [ 5 ]
            Caspar Krieger (Inactive) made changes -
            Remote Link New: This issue links to "Page (Extranet)" [ 62297 ]

              dberrueta Diego Berrueta
              dberrueta Diego Berrueta
              Affected customers:
              29 This affects my team
              Watchers:
              49 Start watching this issue

                Created:
                Updated:
                Resolved: