XMLWordPrintable

    • False
    • False
    • Hide
      = Installation with an external database is failing

      When deploying {prod-short} with an external PostgreSQL database instance, the installation fails during database schema initialization.

      .Workaround

      * Install {prod-short} with the default internal PostgreSQL database instance.
      Show
      = Installation with an external database is failing When deploying {prod-short} with an external PostgreSQL database instance, the installation fails during database schema initialization. .Workaround * Install {prod-short} with the default internal PostgreSQL database instance.
    • Hide

      Make an installation using the external DB procedure.

      Show
      Make an installation using the external DB procedure.

      Customer reports failed installation when using an external PostGres instance.  The log message reads  as seen below:

      -------------------------------------------------------------------------------------------------

      3) [Guice/ErrorInjectingConstructor]: SchemaInitializationException: 
      Migration 1__optimize_user_search.sql failed
      --------------------------------------------
      SQL State  : 58P01
      Error Code : 0
      Message    : ERROR: could not open extension control file "/usr/pgsql-13/share/extension/pg_trgm.control": No such file or directory
      Location   : che-schema/5.11.0/postgresql/1__optimize_user_search.sql (/file:/home/user/codeready/tomcat/webapps/api/WEB-INF/lib/che-core-sql-schema-7.40.3-SNAPSHOT.jar!/che-schema/5.11.0/postgresql/1__optimize_user_search.sql)
      Line       : 15
      Statement  : CREATE EXTENSION IF NOT EXISTS pg_trgm

      --------------------------------------------------------------------------------------------------

       

      Note the customer is using PostGres 13.2, not the 13.3 described in the Installation Guide.

       

      Could we please validate the external db installation still works as described in the docs?

            skabashn Sergii Kabashniuk
            rhn-support-rick Rick Wagner
            Fabrice Flore-Thébault Fabrice Flore-Thébault
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: