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, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content