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

Quay Standalone: quay container fails to startup with 'peewee.ProgrammingError: invalid dsn: invalid connection option "keepalivescount"'

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Critical Critical
    • None
    • quay-v3.10.0
    • quay
    • 0

      Description:

      Quay standalone container cannot startup with its config-editor generated config.yaml.

      Quay: quay-registry-container-v3.10.0-146/quay-operator-bundle-container-v3.10.0-145

      Steps:

      1, Get latest Quay/Postgres/redis image from Red Hat Quay v3.10.0 minor release

      2, Follow the steps from Quay 3.9 guide to create standalone Quay instance on a RHEL8 vm

      3, Start Quay Instance with 

      sudo podman run -d --rm -p 80:8080 -p 443:8443 --name=quay -v $QUAY/config:/conf/stack:Z  -v $QUAY/storage:/datastorage:Z brew.registry.redhat.io/rh-osbs/quay-quay-rhel8:v3.10.0-146

      quay can't startup, from log:

      peewee.ProgrammingError: invalid dsn: invalid connection option "keepalivescount"

      full log is attached.

      in the config.yaml file that generated by config editor web UI :

      DB_CONNECTION_ARGS:
          keepalives: 0
          keepalivescount: 0
          keepalivesidle: 0
          keepalivesinterval: 0
          sslcompression: 0
          tcpusertimeout: 0

       

      I checked this part doesn't exist in config.yaml file generated by 3.9 config editor, it is:

      DB_CONNECTION_ARGS: {}

       

      Reference:

      Details steps of the installation

      export QUAY=/home/ec2-user/quay 
      mkdir quay  
      
      #Install postgres db 
      mkdir -p $QUAY/postgres-quay 
      setfacl -m u:26:-wx $QUAY/postgres-quay
      
      sudo podman run -d --rm --name postgresql-quay \
      -e POSTGRESQL_USER=quayuser \
      -e POSTGRESQL_PASSWORD=quaypass \
      -e POSTGRESQL_DATABASE=quay \
      -e POSTGRESQL_ADMIN_PASSWORD=adminpass \
      -p 5432:5432 \
      -v $QUAY/postgres-quay:/var/lib/pgsql/data:Z \
      registry.redhat.io/rhel8/postgresql-13:1-158
      
      sudo podman exec -it postgresql-quay /bin/bash -c 'echo "CREATE EXTENSION IF NOT EXISTS pg_trgm" | psql -d quay -U postgres'
      
      #Install redis
      sudo podman run -d --rm --name redis -p 6379:6379 -e REDIS_PASSWORD=strongpassword registry.redhat.io/rhel8/redis-6:1-156
      
      #Generate config.yaml with config editor
      sudo podman run --rm -it --name quay_config -p 80:8080 -p 443:8443 brew.registry.redhat.io/rh-osbs/quay-quay-rhel8:v3.10.0 config secret
      
      #Install Quay Instance
      mkdir $QUAY/config
      #scp copy quay-config.tar.gz to vm $QUAY/config
      cd $QUAY/config
      tar xvf quay-config.tar.gz
      mkdir $QUAY/storage
      setfacl -m u:1001:-wx $QUAY/storage
      
      sudo podman run -d -p 80:8080 -p 443:8443  \
      --name=quay \
      -v $QUAY/config:/conf/stack:Z \
      -v $QUAY/storage:/datastorage:Z \
      brew.registry.redhat.io/rh-osbs/quay-quay-rhel8:v3.10.0

       
       
       

        1. quay-config.tar.gz
          1 kB
          Sean Zhao
        2. quay_startup.log
          11 kB
          Sean Zhao
        3. config39.yaml
          3 kB
          Sean Zhao

            obulatov@redhat.com Oleg Bulatov
            szhao@redhat.com Sean Zhao
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: