As a first time user of AWX using local_docker install option version 11.2.0 I am staring the get curious about the way database setup / migrations are setup and supposed to work.
I made several attempts to get AWX up and running. Results vary.
At one time I was able to login and make some configuration changes. However I noticed that the awx_web container was still barfing up error messages similar to the one below at a high rate.
This behavior is consisted characteristic of AWX installation it looks like. Containers are starting before installation is finished causing lots of error messages without providing any info on what the root cause is.
Peeking directly in the database I noticed that some table where present. So the migration seems to run up to a certain point. I see for example 6 tables prefixed with auth, 2 table prefixed django and 2 prefixed taggit.
Of course the logs are of little or no use, they just are repeating at a rate the fact that a table is missing. This doesn’t tell us why the table is not there.
Is there a way to troubleshoot AWX installations?
return self.cursor.execute(sql, params)
django.db.utils.ProgrammingError: relation “main_instance” does not exist
LINE 1: SELECT (1) AS “a” FROM “main_instance” WHERE “main_instance”.