Created attachment 925781 [details] server.log Description of problem: JON server throws "rhq_agent_install_id_seq" does not exist exception during upgrade from JON3.2.0 to JON3.3 and RHQ Agent resources remain in unknown status. Version-Release number of selected component (if applicable): Version : 3.3.0.DR01 Build Number : 6468454:dda0a47 How reproducible: 2/2 Steps to Reproduce: 1. JON3.2.0.GA is running (I had two remote agents registered but it might not be necessary) 2. upgrade JON to version 3.3.DR01: a. stop jon3.2.0.GA (rhqctl stop) b. unzip jon-server-3.3.0.DR01.zip c. unzip plugins and copy jars to jon-server-3.3.0.DR01/plugins/ (might not be necessary) d. edit rhq-server.properties and set rhq.autoinstall.server.admin.password to workaround bz 1128151 (this can be any string) e. run upgrade (./rhqctl upgrade --from-server-dir /home/hudson/jon-server-3.2.0.GA/ --from-agent-dir /home/hudson/rhq-agent) 3. start JON (rhqctl start) Actual results: Following exception is thrown to server.log and RHQ Agent resources remain in status unknown Caused by: org.postgresql.util.PSQLException: ERROR: relation "rhq_agent_install_id_seq" does not exist Expected results: No errors, resources are up Additional info: RHQ Agent resources become up after agent restart Full logs attached (search for rhq_agent_install_id_seq)
Created attachment 925782 [details] agent.log
Marking this as triaged, as the issues prevents updating any JON version earlier than 3.3 to 3.3
Fixed in master: commit c7d22c367a373dfd51485b13c814565bb0818287 Author: Michael Burman <miburman> Date: Thu Aug 14 19:01:34 2014 +0300 [BZ 1095970] Reapplying patch to fix incorrect sequence name
Moving to ON_QA as available to test in the following brew build: https://brewweb.devel.redhat.com//buildinfo?buildID=379025
Moving to VERIFIED. All RHQ Agent resources are up and the error message in question is not logged after upgrade. Version:3.3.0.ER01.1 Build Number:9941660:f3aa7e7