Uploaded image for project: 'Red Hat 3scale API Management'
  1. Red Hat 3scale API Management
  2. THREESCALE-4226

Installation fails due to a DB structure problem

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Obsolete
    • Icon: Major Major
    • None
    • 2.7 GA
    • System
    • Not Started
    • Not Started
    • Not Started
    • Not Started
    • Not Started
    • Not Started

      We had multiple cases of 3Scale installation failure in RHMI/Integreatly.
      Failure manifests by a system-sphinx pod in Failed state, with following error:

      ActiveRecord::StatementInvalid: PG::UndefinedTable: ERROR:  relation "accounts" does not exist
      LINE 5:                WHERE a.attrelid = '"accounts"'::regclass
                                                ^
      :               SELECT a.attname, format_type(a.atttypid, a.atttypmod),
                           pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod
                      FROM pg_attribute a LEFT JOIN pg_attrdef d
                        ON a.attrelid = d.adrelid AND a.attnum = d.adnum
                     WHERE a.attrelid = '"accounts"'::regclass
                       AND a.attnum > 0 AND NOT a.attisdropped
                     ORDER BY a.attnum
      

      Full logs here - https://gist.github.com/matskiv/17738917cf457473ce572dff39871282

      Environment: OSD 4.x Staging. DB is "external" Postgres 10 provisioned in the same cluster.

              Unassigned Unassigned
              omatskiv@redhat.com Oleg Matskiv (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Created:
                Updated:
                Resolved: