Upgrade to Satellite 6.9 fails at db:migrate stage with 'could not create unique index "index_lookup_values_on_lookup_key_id_and_match"' error

Solution Verified - Updated -

Issue

  • Red Hat Satellite upgrade to 6.9 fails with the following error.

    # satellite-maintain upgrade run --target-version 6.9
    ..
    ..
    2021-05-11 15:50:15 [NOTICE] [configure] 1700 out of 2326 done.
    2021-05-11 15:51:17 [ERROR ] [configure] '/usr/sbin/foreman-rake db:migrate' returned 1 instead of one of [0]
    2021-05-11 15:51:17 [ERROR ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]/returns: change from 'notrun' to ['0'] failed: '/usr/sbin/foreman-rake db:migrate' returned 1 instead of one of [0]
    2021-05-11 15:52:14 [ERROR ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]: Failed to call refresh: '/usr/sbin/foreman-rake db:migrate' returned 1 instead of one of [0]
    2021-05-11 15:52:14 [ERROR ] [configure] /Stage[main]/Foreman::Database/Foreman::Rake[db:migrate]/Exec[foreman-rake-db:migrate]: '/usr/sbin/foreman-rake db:migrate' returned 1 instead of one of [0]
    2021-05-11 15:52:39 [NOTICE] [configure] 1800 out of 2326 done.
    ..
    2021-05-11 15:52:40 [NOTICE] [configure] 2200 out of 2326 done.
    2021-05-11 15:52:47 [NOTICE] [configure] 2300 out of 2326 done.
    2021-05-11 15:52:51 [NOTICE] [configure] System configuration has finished.
    

Environment

  • Red Hat Satellite 6.9

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