Bug 1458339 - It is impossible to identify the source process/appliance for each connection in pg_stat_activity
Summary: It is impossible to identify the source process/appliance for each connection...
Keywords:
Status: CLOSED ERRATA
Alias: None
Product: Red Hat CloudForms Management Engine
Classification: Red Hat
Component: Appliance
Version: 5.7.0
Hardware: Unspecified
OS: Unspecified
unspecified
unspecified
Target Milestone: GA
: 5.8.1
Assignee: Joe Rafaniello
QA Contact: Tasos Papaioannou
URL:
Whiteboard:
Depends On: 1445928
Blocks:
TreeView+ depends on / blocked
 
Reported: 2017-06-02 15:30 UTC by Satoe Imaishi
Modified: 2022-07-09 08:36 UTC (History)
5 users (show)

Fixed In Version: 5.8.1.0
Doc Type: If docs needed, set a value
Doc Text:
Clone Of: 1445928
Environment:
Last Closed: 2017-08-02 17:24:20 UTC
Category: ---
Cloudforms Team: ---
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Product Errata RHSA-2017:1758 0 normal SHIPPED_LIVE Important: Red Hat CloudForms security, bug fix, and enhancement update 2017-08-02 21:23:43 UTC

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


Note You need to log in before you can comment on or make changes to this bug.