Bug 1458339

Summary:	It is impossible to identify the source process/appliance for each connection in pg_stat_activity
Product:	Red Hat CloudForms Management Engine	Reporter:	Satoe Imaishi <simaishi>
Component:	Appliance	Assignee:	Joe Rafaniello <jrafanie>
Status:	CLOSED ERRATA	QA Contact:	Tasos Papaioannou <tpapaioa>
Severity:	unspecified	Docs Contact:
Priority:	unspecified
Version:	5.7.0	CC:	abellott, jhardy, obarenbo, simaishi, tpapaioa
Target Milestone:	GA	Keywords:	ZStream
Target Release:	5.8.1
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:	5.8.1.0	Doc Type:	If docs needed, set a value
Doc Text:		Story Points:	---
Clone Of:	1445928	Environment:
Last Closed:	2017-08-02 17:24:20 UTC	Type:	---
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:
Bug Depends On:	1445928
Bug Blocks:

Comment 2 CFME Bot 2017-06-02 15:36:16 UTC

New commit detected on ManageIQ/manageiq/fine:
https://github.com/ManageIQ/manageiq/commit/c8701b6f6508bfd17e22b652ec2d1ed3b7f213ad

commit c8701b6f6508bfd17e22b652ec2d1ed3b7f213ad
Author:     Gregg Tanzillo <gtanzill>
AuthorDate: Mon Apr 24 21:56:40 2017 -0400
Commit:     Satoe Imaishi <simaishi>
CommitDate: Fri Jun 2 11:30:44 2017 -0400

    Merge pull request #13856 from jrafanie/set_database_application_name
    
    Set database application name in workers and server
    (cherry picked from commit f241df45cc9ef588bd4c9041249ec59264f117f9)
    
    https://bugzilla.redhat.com/show_bug.cgi?id=1458339

 app/models/embedded_ansible_worker/runner.rb   |  1 +
 app/models/miq_server.rb                       |  4 ++++
 app/models/miq_worker.rb                       | 15 +++++++++++++++
 app/models/miq_worker/runner.rb                | 16 ++++++++++++----
 lib/extensions/ar_application_name.rb          | 16 ++++++++++++++++
 lib/workers/evm_server.rb                      |  9 +++++++++
 spec/lib/workers/evm_server_spec.rb            |  2 ++
 spec/models/miq_schedule_worker/runner_spec.rb |  2 +-
 8 files changed, 60 insertions(+), 5 deletions(-)
 create mode 100644 lib/extensions/ar_application_name.rb

Comment 3 CFME Bot 2017-06-02 15:36:21 UTC

New commit detected on ManageIQ/manageiq/fine:
https://github.com/ManageIQ/manageiq/commit/451dbfc9822110eba3052342efc58e7c34e36a55

commit 451dbfc9822110eba3052342efc58e7c34e36a55
Author:     Gregg Tanzillo <gtanzill>
AuthorDate: Wed Apr 26 15:40:41 2017 -0400
Commit:     Satoe Imaishi <simaishi>
CommitDate: Fri Jun 2 11:32:49 2017 -0400

    Merge pull request #14904 from jrafanie/set_db_application_name_after_server_row_created
    
    Set the db application_name after the server row is created
    (cherry picked from commit 90197b1485c6fe03649be3bfb51e48fda3aab9b7)
    
    https://bugzilla.redhat.com/show_bug.cgi?id=1458339

 app/models/miq_server.rb  | 5 +++++
 lib/workers/evm_server.rb | 9 ---------
 2 files changed, 5 insertions(+), 9 deletions(-)

Comment 4 Tasos Papaioannou 2017-06-26 14:48:33 UTC

Verified on 5.8.1.0. With two appliances, processes for workers on local server (2) and remote server (34) are shown in pg_stat_activity:

vmdb_production=# select pid, application_name from pg_stat_activity;
  pid  |               application_name                
-------+-----------------------------------------------
 24832 | MIQ 12237 Server[34], default[2]
 24856 | MIQ 15226 Generic[46], s[34], default[2]
 24855 | MIQ 15218 Generic[45], s[34], default[2]
 24857 | MIQ 15234 Priority[47], s[34], default[2]
 24858 | MIQ 15242 Priority[48], s[34], default[2]
 24859 | MIQ 15250 Schedule[49], s[34], default[2]
 25040 | MIQ 24870 Server[2], default[2]
 24891 | MIQ 15268 EventHandler[50], s[34], default[2]
 24897 | MIQ 15293 Websocket[53], s[34], default[2]
 24894 | MIQ 15284 Reporting[52], s[34], default[2]
 24893 | MIQ 15276 Reporting[51], s[34], default[2]
 24898 | MIQ 15293 Websocket[53], s[34], default[2]
 24899 | MIQ 15312 WebService[55], s[34], default[2]
 24900 | MIQ 15303 Ui[54], s[34], default[2]
 24901 | MIQ 15312 WebService[55], s[34], default[2]
 24902 | MIQ 15303 Ui[54], s[34], default[2]
 25171 | MIQ 25148 Priority[59], s[2], default[2]
 25167 | MIQ 25122 Generic[56], s[2], default[2]
 25174 | MIQ 25140 Priority[58], s[2], default[2]
 25177 | MIQ 25131 Generic[57], s[2], default[2]
 25179 | MIQ 25158 Schedule[60], s[2], default[2]
 25214 | psql
(22 rows)

Comment 6 errata-xmlrpc 2017-08-02 17:24:20 UTC

Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory, and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

https://access.redhat.com/errata/RHSA-2017:1758