Uploaded image for project: 'MidPoint'
  1. MidPoint
  2. MID-5213

PSQLException: FATAL: sorry, too many clients already

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 4.0
    • Fix Version/s: 4.1
    • Component/s: Repository
    • Labels:
      None
    • Environment:

      3 x 3 clustered Nodes against 3 Postgres Databases (all Dockerized)

    • Subscription:
      Active subscription
    • Milestone:
      M4

      Description

      The Nodes are working fine initially but after a few hours without doing anything just leaving them running (overnight) they start blocking the databases with idle sessions.

      I increased the connection limit from 50 to 200. That delayed the effect but it still happens.

      In pgAdmin (once i manage to get a free session) there are multiple entries for the following statements:

      SET application_name = 'PostgreSQL JDBC Driver'
      
      SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL SERIALIZABLE
      

      Best regards,
      Martin Hoffmann

        Attachments

        1. HikariPool-DEBUG.log
          66 kB
        2. image-2019-04-09-17-28-23-047.png
          image-2019-04-09-17-28-23-047.png
          7 kB
        3. midpoint-d2edc0f3f6f1.log
          1.10 MB
        4. pgadmin.PNG
          pgadmin.PNG
          160 kB
        5. screenshot-1.png
          screenshot-1.png
          8 kB

          Activity

            People

            • Assignee:
              mederly Pavol Mederly
              Reporter:
              hoffm_ma Martin Hoffmann
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated: