Bug 667218

Summary: Operation Scheduling does not work because of missing sequence
Product: [Other] RHQ Project Reporter: Heiko W. Rupp <hrupp>
Component: OperationsAssignee: Heiko W. Rupp <hrupp>
Status: CLOSED CURRENTRELEASE QA Contact: Corey Welton <cwelton>
Severity: urgent Docs Contact:
Priority: high    
Version: 4.0.0CC: mfoley
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-05-24 01:12:48 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Description Heiko W. Rupp 2011-01-04 20:22:11 UTC 
Install RHQ4 (on a database before version 2.102) and try to schedule an operation (any).
This will fail with an error that a sequence is missing.

db-upgrade v2.102 is changing the PK of the rhq_operarations_schedule table to 'id' column and defines this in the domain (and in dbsetup) as sequence.
The db-upgrade task does not create the sequence though.
v2.102 should either be changed to include the sequence - or a v2.103 should be created to create the sequence

<schema-createSequence name="RHQ_OPERATION_SCHEDULE_ID_SEQ" initial="10001"/>

Initial value is depended on the previous db content I think.
Comment 1 Mike Foley 2011-05-02 12:35:06 UTC 
reproduced with RHQ4.0 release candidate #1, after upgrading from RHQ3 database, with group operations.  see bz 701272.
Comment 2 Heiko W. Rupp 2011-05-02 13:53:25 UTC 
Pushed as ae4f1ec7485c7a15de42a9a5554069867e7a1a7d to master and cherry-picked into release-4.0.0 as 5b57930288f32cbaf0bb190dfed50e78390a402d
Comment 3 Mike Foley 2011-05-02 14:14:22 UTC 
*** Bug 701272 has been marked as a duplicate of this bug. ***
Comment 4 Mike Foley 2011-05-02 19:45:05 UTC 
verified in RHQ 4.0 monday 5/2 release, on oracle.  by creating a group, and scheduling group operations.
Comment 5 Corey Welton 2011-05-24 01:12:48 UTC 
Bookkeeping - closing bug - fixed in recent release.
Comment 6 Corey Welton 2011-05-24 01:12:48 UTC 
Bookkeeping - closing bug - fixed in recent release.
Comment 7 Corey Welton 2011-05-24 01:13:04 UTC 
Bookkeeping - closing bug - fixed in recent release.