All,
Trying to migrate/upgrade an awx 19.2.0 installation with an external postgresql database but having no luck. The awx-operator and awx pods install fine, but its stuck at the db migration indefinitely. Attempting to manually migrate the db with awx-manage migrate throws an error on main.0144_event_partition. Having contraint errors with main_adhoccommandevent. I installed a new instance of 19.2.0 and compared the table in that db against the db being upgraded and they are identical. So stuck with the upgrade/migration. Is there any way to dump all the sql from main.0144_event_partition so it can be runned manually to see what the problem is?
create a new install of 19.2.0 with a new postgresql instance. Set the instance to log all sql. migrated to 19.2.1. Took the sql from the logs for main_0144_event_partition. backup my db, ran the sql and upgrade the required tables for main_0144_event_partition. There were not errors running the sql commands manually, not sure what the issue was. use awx-operator to migrate the install to 19.2.1 and db migrated fine. Everything seem to work as usual. So there’s the fix if someone runs into the same issue… get the sql being run and run it manually to see what the error is and fix them. There were no errors from any of the sql runned in my db when ran manually.