PG::UndefinedTable: ERROR: relation "miq_servers" does not exist

Solution Verified - Updated -

Issue

  • I am trying to deploy a basic CloudForms scenario through OpenStack. So far I have only made the basic steps of creating the database for the service to initialize, but getting error while starting evmserverd service.
  • Executing the journalctl -f command while the service tries to initialize and the error message that appears is the following:

    Feb 24 09:05:25 host-192-168-0-5 sh[16283]: ActiveRecord::StatementInvalid: PG::UndefinedTable: ERROR:  relation "miq_servers" does not exist
    Feb 24 09:05:25 host-192-168-0-5 sh[16283]: LINE 8:                WHERE a.attrelid = '"miq_servers"'::regclass
    Feb 24 09:05:25 host-192-168-0-5 sh[16283]: ^
    Feb 24 09:05:25 host-192-168-0-5 sh[16283]: :               SELECT a.attname, format_type(a.atttypid, a.atttypmod),
    Feb 24 09:05:25 host-192-168-0-5 sh[16283]: pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod,
    Feb 24 09:05:25 host-192-168-0-5 sh[16283]: (SELECT c.collname FROM pg_collation c, pg_type t
    Feb 24 09:05:25 host-192-168-0-5 sh[16283]: WHERE c.oid = a.attcollation AND t.oid = a.atttypid AND a.attcollation <> t.typcollation),
    Feb 24 09:05:25 host-192-168-0-5 sh[16283]: col_description(a.attrelid, a.attnum) AS comment
    Feb 24 09:05:25 host-192-168-0-5 sh[16283]: FROM pg_attribute a LEFT JOIN pg_attrdef d
    Feb 24 09:05:25 host-192-168-0-5 sh[16283]: ON a.attrelid = d.adrelid AND a.attnum = d.adnum
    Feb 24 09:05:25 host-192-168-0-5 sh[16283]: WHERE a.attrelid = '"miq_servers"'::regclass
    Feb 24 09:05:25 host-192-168-0-5 sh[16283]: AND a.attnum > 0 AND NOT a.attisdropped
    Feb 24 09:05:25 host-192-168-0-5 sh[16283]: ORDER BY a.attnum
    

Environment

  • Red Hat CloudForms 4.7
  • Red Hat OpenStack 14

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In