Bug 736168

Summary: JOPR 2.3.1 upgrade to RHQ 4.1.1 fails (oracle as repo)
Product: [Other] RHQ Project Reporter: Mike Foley <mfoley>
Component: InstallerAssignee: Charles Crouch <ccrouch>
Status: CLOSED NOTABUG QA Contact: Mike Foley <mfoley>
Severity: high Docs Contact:
Priority: high    
Version: 4.1CC: hbrock, hrupp
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2011-09-26 18:48:40 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Bug Depends On:    
Bug Blocks: 720674    
Attachments:
Description Flags
RHQ Server log of upgrade failure
none
image of error
none
rhq-installer-dbupgrade.log none

Description Mike Foley 2011-09-06 21:28:39 UTC
Created attachment 521765 [details]
RHQ Server log of upgrade failure

Description of problem:  JOPR 2.3.1 upgrade to RHQ 4.1.1 fails (oracle as repo)


Version-Release number of selected component (if applicable):
JOPR 2.3.1 final to RHQ 4.1.1



Steps to Reproduce:
1.  install JOPR 2.3.1.  use oracle repo.
2.  upgrade to RHQ 4.1
3.  observe failure (see attachments)
  
Actual results:
failed upgrade.

Expected results:
successful upgrade.

Additional info:
attachments

Comment 1 Mike Foley 2011-09-06 21:29:10 UTC
Created attachment 521766 [details]
image of error

Comment 2 Mike Foley 2011-09-06 21:29:53 UTC
Created attachment 521767 [details]
rhq-installer-dbupgrade.log

Comment 7 Mike Foley 2011-09-26 18:32:03 UTC
this BZ was invalid, based on pilot error.  improper cleaning of the database.  the (incorrect) assumption was that a SQL script used to drop all tables with cascade constraints cleaned the database.  this assumption proved invalid because sequences were not deleted.  the existing sequence is in the logs attached to this BZ.  schema changes are covered by the  existing jenkins job ... https://hudson.qa.jboss.com/hudson/view/RHQ%20Core/job/rhq-master-ora-dbupgrade/  
...which is passing now, and was passing at the time this BZ was logged on 9/6.