Uploaded image for project: 'Project Quay'
  1. Project Quay
  2. PROJQUAY-6806

Quay 3.12 APP POD was crashed when using pgbouncer as unmanaged postgres component

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • None
    • quay-v3.11.0, quay-v3.12.0
    • quay
    • False
    • Hide

      None

      Show
      None
    • False
    • Proposed

      Description:

      This is an issue found in Quay 3.11, when configuring Quay to use unmanaged postgres component, here choose to use Crunchy Postgres Pgbouncer, the results is Quay APP POD was crashed with error message "peewee.ProgrammingError: invalid dsn: invalid connection option "prepareThreshold", pls review this issue.

      Quay: quay-operator-bundle-container-v3.8.11-21

      Example of Quay config.yaml:

      DB_CONNECTION_ARGS:
  autorollback: true
  threadlocals: true
  prepareThreshold: 0
DB_URI: postgresql://quaydb:a%2B%28D%3Al6k2MF5nDkvdkB8k%2AMh@57.151.58.217:5432/quaydb
      "Prepared statements" is enabled at Crunchy PostgresSQL Pgbouncer, following screenshot display error when not specifying "prepareThreshold=0" in Quay config.yaml:

      When specify the db connections with "prepareThreshold: 0", hit following error:

       

        1. image-2024-03-06-14-12-13-400.png
          2.08 MB
          luffy zhang
        2. image-2024-03-06-14-08-49-377.png
          2.83 MB
          luffy zhang

              Unassigned Unassigned
              lzha1981 luffy zhang
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Created:
                Updated:
                Resolved: