Bug 1079361 - Postgres Plugin - Scheduling A New List Process Statistics Operation Fails
Summary: Postgres Plugin - Scheduling A New List Process Statistics Operation Fails
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: JBoss Operations Network
Classification: JBoss
Component: Plugin -- Other
Version: JON 3.2
Hardware: Unspecified
OS: Unspecified
unspecified
unspecified
Target Milestone: DR01
: JON 3.2.2
Assignee: Thomas Segismont
QA Contact: Mike Foley
URL:
Whiteboard:
: 1073990 (view as bug list)
Depends On:
Blocks: 1082792
TreeView+ depends on / blocked
 
Reported: 2014-03-21 13:20 UTC by Matt Mahoney
Modified: 2014-07-29 00:17 UTC (History)
2 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2014-07-29 00:17:21 UTC
Type: Bug
Embargoed:


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Bugzilla 988800 0 unspecified CLOSED cannot access postgres 9.2 internal statistics 2021-02-22 00:41:40 UTC

Internal Links: 988800

Description Matt Mahoney 2014-03-21 13:20:55 UTC
Description of problem:
When scheduling a new List Process Statistics Operation, the scheduled operation fails with the below error.

"org.postgresql.util.PSQLException: ERROR: column "current_query" does not exist"


Version-Release number of selected component (if applicable):
3.2

How reproducible:
Always

Steps to Reproduce:

1.Click Operations tab
2.Click Schedules button
3.Click New button
4.Create New Operations Schedule:
   - Operation: Select "List Process Statistics" in drop-down menu
   - Select "Run Now"
   - Click "Schedule" button
5. Evaluate the "Status" of the scheduled operations History.

Actual results:
Scheduled operations fails with PSQL error.

Expected results:
Scheduled operations should be successful

Additional info:

Comment 1 Thomas Segismont 2014-04-04 08:04:03 UTC
Fixed in master

78cf9729cb74923a37d98c0d2b51063b23871243
Thomas Segismont at 04/04/14 09:56 (committed at 04/04/14 09:59)

The execution of this operation involves a query on the pg_stat_activity view, which format has changes in 9.2 (see http://wiki.postgresql.org/wiki/What%27s_new_in_PostgreSQL_9.2#pg_stat_activity_and_pg_stat_replication.27s_definitions_have_changed)

Now the server plugin component adapts the query depending on the Postgres server version

Change tested on Postgres 9.1 and 9.3

Comment 2 Thomas Segismont 2014-05-07 14:39:15 UTC
*** Bug 1073990 has been marked as a duplicate of this bug. ***

Comment 3 Thomas Segismont 2014-05-09 15:23:42 UTC
Cherry-picked over to release/jon3.2.x

commit 2fd6b5b0874798a3f1be7431454923a42e9106e1
Author: Thomas Segismont <tsegismo>
Date:   Fri Apr 4 09:56:51 2014 +0200

Comment 4 Simeon Pinder 2014-05-22 15:15:40 UTC
Via product triage, determined that this bug is to be included for DR01 target milestone.

Comment 5 Simeon Pinder 2014-05-30 02:43:39 UTC
Moving to ON_QA as available for test in latest cumulative patch build(DR01):
http://jon01.mw.lab.eng.bos.redhat.com:8042/dist/release/jon/3.2.2.GA/5-29-2014/

Comment 6 Matt Mahoney 2014-05-30 18:56:02 UTC
Tested against JON 3.2.0 GA + CP2 (DR1)

Comment 7 Larry O'Leary 2014-07-29 00:17:21 UTC
This has been verified and released in Red Hat JBoss Operations Network 3.2 Update 02 (3.2.2) available from the Red Hat Customer Portal[1].



[1]: https://access.redhat.com/jbossnetwork/restricted/softwareDetail.html?softwareId=31783


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