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:
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
*** Bug 1073990 has been marked as a duplicate of this bug. ***
Cherry-picked over to release/jon3.2.x commit 2fd6b5b0874798a3f1be7431454923a42e9106e1 Author: Thomas Segismont <tsegismo> Date: Fri Apr 4 09:56:51 2014 +0200
Via product triage, determined that this bug is to be included for DR01 target milestone.
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/
Tested against JON 3.2.0 GA + CP2 (DR1)
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