Bug 1079361

Summary:	Postgres Plugin - Scheduling A New List Process Statistics Operation Fails
Product:	[JBoss] JBoss Operations Network	Reporter:	Matt Mahoney <mmahoney>
Component:	Plugin -- Other	Assignee:	Thomas Segismont <tsegismo>
Status:	CLOSED CURRENTRELEASE	QA Contact:	Mike Foley <mfoley>
Severity:	unspecified	Docs Contact:
Priority:	unspecified
Version:	JON 3.2	CC:	mfoley, tsegismo
Target Milestone:	DR01
Target Release:	JON 3.2.2
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2014-07-29 00:17:21 UTC	Type:	Bug
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:
Bug Blocks:	1082792

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