ERROR: relation "conf_setting" does not exist at character 158

Archives AWX Project
1

Hi Team,

I’m getting the following error in postgres logs. Can someone please help me understand why we are getting this error ?

ERROR: relation “conf_setting” does not exist at character 158
STATEMENT: SELECT “conf_setting”.“id”, “conf_setting”.“created”, “conf_setting”.“modified”, “conf_setting”.“key”, “conf_setting”.“value”, “conf_setting”.“user_id” FROM “conf_setting” WHERE (“conf_setting”.“user_id” IS NULL AND “conf_setting”.“key” = ‘SOCIAL_AUTH_SAML_ENABLED_IDPS’) ORDER BY “conf_setting”.“id” ASC LIMIT 1

Thanks,
Sudheer.

2

Hi Sudheer,

Which version of awx are you seeing this problem in? You can find this by running make VERSION in your cloned awx directory.

Thanks,
Christian

3

Hi Christian,

Please find the following details.

Awx version:1.0.6.7
Postgres version: 9.6

Thanks,
Sudheer.

4

Speaking speculatively, this looks like an error that could be related to migration ordering / dependency resolution.

Could you tell us what your migration pathway was to get here?

5

Hi Alan,

I’m getting this error when I’m trying to migrate to different awx version with same Database Dump. I’m able to see this error while migrating from 1.0.4 to 1.0.5 also 1.0.5 to 1.0.6.

Thanks,
Sudheer.