-
Feature Request
-
Resolution: Unresolved
-
Undefined
-
None
-
2.5
-
False
-
-
False
- What is the nature and description of the request?
- controller sets application_name on database connections, which helps with understanding where database connections are coming from when doing deployment planning or debugging bad database connections
- We should set the application_name on all other database connections made by AAP applications
- Why does the customer need this? (List the business requirements here)
- having application_name set helps with understanding where database connections are coming from when doing deployment planning or debugging bad database connections
- This is important now that it is standard that all AAP components may share a database instance for understanding where database connections are coming from and for deployment planning if running into issues with having enough connections (which is a global limit in postgres and may require changes to postgres instance size to accommodate more connections.
- How would you like to achieve this? (List the functional requirements here)
- when applications create databse connection, set application name indicating what service and what instance it is coming from. Controller has a pattern for this
- List any affected known dependencies:
- could be used to update admin docs
automationcontroller=> SELECT
application_name,
count(*) AS connection_count
FROM
pg_stat_activity
GROUP BY
application_name
ORDER BY
connection_count DESC;
application_name | connection_count
-----------------------------------------------------------------+------------------
| 41
awx-35-wsrelay-elijah-26-vanilla-controller-task-5bc5d8b7d6-smv | 27
psql | 2
awx-13-cache_clear-elijah-26-vanilla-controller-web-779b57d4b6- | 1
awx-22-rsyslog_configurer-elijah-26-vanilla-controller-task-5bc | 1
awx-12-ws_heartbeat-elijah-26-vanilla-controller-web-779b57d4b6 | 1
awx-1828-dispatcher_worker-elijah-26-vanilla-controller-task-5b | 1
awx-33-dispatcher-elijah-26-vanilla-controller-task-5bc5d8b7d6- | 1
awx-1774-dispatcher_worker-elijah-26-vanilla-controller-task-5b | 1
awx-33-dispatcher_listener-elijah-26-vanilla-controller-task-5b | 1
awx-6744-dbshell-elijah-26-vanilla-controller-web-779b57d4b6-w9 | 1
awx-6807-dbshell-elijah-26-vanilla-controller-web-779b57d4b6-w9 | 1
awx-11-/var/lib/awx/venv/awx/bin/daphne-elijah-26-vanilla-contr | 1
awx-1825-dispatcher_worker-elijah-26-vanilla-controller-task-5b | 1
awx-22-rsyslog_configurer-elijah-26-vanilla-controller-web-779b | 1
(15 rows)
This first blank row is likely the GRPC service from gateway but it is unclear from here, likely could be some from gateway gRPC as well as some from its web server.