Plugins » Katello

I looked into this and I think there's an issue around the timing of the foreman and foreman_tasks being installed and started. I also didn't see this problem exactly as described which also indicates a timing related issue to me.

From foreman production.log:

2018-05-03T00:50:19 [W|dyn|] Error on on_execution_plan_save event
ActiveRecord::StatementInvalid: PG::UndefinedTable: ERROR:  relation "foreman_tasks_tasks" does not exist
LINE 8:                WHERE a.attrelid = '"foreman_tasks_tasks"'::r...
                                          ^
:               SELECT a.attname, format_type(a.atttypid, a.atttypmod),
                     pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod,
                     c.collname, col_description(a.attrelid, a.attnum) AS comment
                FROM pg_attribute a
                LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum
                LEFT JOIN pg_type t ON a.atttypid = t.oid
                LEFT JOIN pg_collation c ON a.attcollation = c.oid AND a.attcollation <> t.typcollation
               WHERE a.attrelid = '"foreman_tasks_tasks"'::regclass
                 AND a.attnum > 0 AND NOT a.attisdropped
               ORDER BY a.attnum

From foreman_proxy proxy.log:

# Logfile created on 2018-05-03 00:54:14 +0000 by logger.rb/41954
I, [2018-05-03T00:54:14.761880 ]  INFO -- : Successfully initialized 'pulp'
I, [2018-05-03T00:54:14.761989 ]  INFO -- : Successfully initialized 'foreman_proxy'
I, [2018-05-03T00:54:14.762027 ]  INFO -- : Successfully initialized 'templates'
I, [2018-05-03T00:54:14.762060 ]  INFO -- : Successfully initialized 'tftp'
I, [2018-05-03T00:54:14.762089 ]  INFO -- : Successfully initialized 'puppetca'
I, [2018-05-03T00:54:14.762250 ]  INFO -- : Started puppet class cache initialization
I, [2018-05-03T00:54:14.769301 ]  INFO -- : Successfully initialized 'puppet_proxy_puppet_api'
I, [2018-05-03T00:54:14.769425 ]  INFO -- : Successfully initialized 'puppet'
I, [2018-05-03T00:54:14.769486 ]  INFO -- : Successfully initialized 'logs'
I, [2018-05-03T00:54:14.783040 ]  INFO -- : WEBrick 1.3.1
I, [2018-05-03T00:54:14.783123 ]  INFO -- : ruby 2.0.0 (2015-12-16) [x86_64-linux]
I, [2018-05-03T00:54:14.783934 ]  INFO -- :

I'm not very familiar with the installer side of things but it looks like foreman is starting and kicking off the jobs when foreman_tasks hasn't been installed & started - see that there is a 4 minute difference in the logs. I will think about what the appropriate fix is and update.

The proxy log is irrelevant - ignore it :)