Bug 667218 - Operation Scheduling does not work because of missing sequence
Summary: Operation Scheduling does not work because of missing sequence
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: RHQ Project
Classification: Other
Component: Operations
Version: 4.0.0
Hardware: Unspecified
OS: Unspecified
high
urgent
Target Milestone: ---
: ---
Assignee: Heiko W. Rupp
QA Contact: Corey Welton
URL:
Whiteboard:
: 701272 (view as bug list)
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2011-01-04 20:22 UTC by Heiko W. Rupp
Modified: 2011-05-24 01:13 UTC (History)
1 user (show)

Fixed In Version:
Clone Of:
Environment:
Last Closed: 2011-05-24 01:12:48 UTC
Embargoed:

Attachments (Terms of Use)

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.
Note You need to log in before you can comment on or make changes to this bug.