External AWS RDS Postgres DB refreshment connection MAX AGE query

Archives AWX Project
,
1

Hi Team,
We are getting this Error as per awx container logs every sunday afternoon around 2 pm and it causes the Jobs to be stuck for two hours and then jobs failures occurs.

WARNING [6d97f00587c644f3aa02de547d109bb1] awx.conf.settings Database settings are not available, using defaults. error: server closed the connection unexpectedly\n",“stream”:“stderr”,“time”:“2023-03-19T01:02:25.109390476Z”}
{“log”:“\u0009This probably means the server terminated abnormally\n”,“stream”:“stderr”,“time”:“2023-03-19T01:02:25.109429958Z”}
{“log”:“\u0009before or while processing the request.\n”,“stream”:“stderr”,“time”:“2023-03-19T01:02:25.109435613Z”}
{“log”:“\n”,“stream”:“stderr”,“time”:“2023-03-19T01:02:25.109439891Z”}
{“log”:“2023-03-19 01:02:25,111 WARNING [6d97f00587c644f3aa02de547d109bb1] awx.conf.settings Database settings are not available, using defaults. error: connection already closed\n”,“stream”:“stderr”,“time”:“2023-03-19T01:02:25.111480038Z”}

  • Do you think that specifying “CONN_MAX_AGE”: __ parameter on the client side will mitigate this issue?
  • How to add this config change in the AWX conf file?
  • It would be great if you could provide the instructions. Can you also suggest if we need to update the Postgres session timeout on PG Server Side.
    Thanks,

Jagruti Belani

2

Hi Team,
Any update on this?
Does management scheduled cleanup jobs cause these database errors?