Description of problem: Newly introduced postgres plugin operation 'Remove orphan large objects' sometimes fails. Version-Release number of selected component (if applicable): JON3.3.8 How reproducible: Sometimes Steps to Reproduce: 1. navigate to rhq Postgres Server->rhq Database->Operations 2. schedule new Remove orphan large objects 3. repeat step 2 for several times Actual results: Operation fails with: java.lang.Exception: ERROR: relation "vacuum_l" already exists There is no exception in serve.log Expected results: Operation is successful
This appears to be some sort of undeterministic behavior of certain Postgres versions (found multiple occurences in the mailing lists). Fixed in the master: commit a96f180a1f3db7c6595b6c57b2acd049512f9de6 Author: Michael Burman <miburman> Date: Wed Feb 1 12:53:29 2017 +0200 [BZ 1418039] Call the drop temp table in the end of the vacuumLo process
Moving to ON_QA as available for test with the latest build: JON 3.3.8 CR01 artifacts are available for test from here: http://download.eng.bos.redhat.com/brewroot/packages/org.jboss.on-jboss-on-parent/3.3.0.GA/114/maven/org/jboss/on/jon-server-patch/3.3.0.GA/jon-server-patch-3.3.0.GA.zip *Note: jon-server-patch-3.3.0.GA.zip maps to CR01 build of jon-server-3.3.0.GA-update-08.zip. https://brewweb.engineering.redhat.com/brew/buildinfo?buildID=537179
Moving to ON_QA as available for testing with the following build: http://download.eng.bos.redhat.com/brewroot/packages/org.jboss.on-jboss-on-parent/3.3.0.GA/117/maven/org/jboss/on/jon-server-patch/3.3.0.GA/jon-server-patch-3.3.0.GA.zip *Note: jon-server-patch-3.3.0.GA.zip maps to CR02 build of jon-server-3.3.0.GA-update-08.zip.