Bug 797325 - RHQ_ALERT_NOTIFICATION created with NOLOGGING option in Oracle
Summary: RHQ_ALERT_NOTIFICATION created with NOLOGGING option in Oracle
Keywords:
Status: CLOSED DUPLICATE of bug 814839
Alias: None
Product: RHQ Project
Classification: Other
Component: Database
Version: 4.2
Hardware: All
OS: All
high
high
Target Milestone: ---
: JON 3.1.0
Assignee: John Mazzitelli
QA Contact: Mike Foley
URL:
Whiteboard:
Depends On: 814839
Blocks: jon310-sprint11, rhq44-sprint11
TreeView+ depends on / blocked
 
Reported: 2012-02-24 23:17 UTC by Marc Shirley
Modified: 2018-11-27 20:50 UTC (History)
2 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2012-04-25 12:50:28 UTC
Embargoed:

Attachments (Terms of Use)
logging in oracle schema (27.27 KB, image/png)
2012-04-20 18:35 UTC, Mike Foley 		no flags Details
my server log (574.91 KB, application/octet-stream)
2012-04-20 19:38 UTC, Mike Foley 		no flags Details
turn on oracle logging on relevant tables (6.46 KB, text/x-sql)
2012-04-24 19:51 UTC, John Mazzitelli 		no flags Details
View All

Description Marc Shirley 2012-02-24 23:17:51 UTC 
Description of problem:
RHQ_ALERT_NOTIFICATION table is created with the NOLOGGING option in an Oracle schema, but should be created without the option as it concerns configuration.  In the case of a database issue on the user side and the user relying on redo logging to rebuild the database, the usage of NOLOGGING means that the user will have to manually review the alert notification configuration for every alert in order to confirm that their notifications are properly configured.  

Depending upon the number of alerts, this could require many man hours to verify, or could mean that a user relying on the notifications for monitoring will overlook error/warning states that they should have been aware of if they do not check that the RHQ_ALERT_NOTIFICATION table was restored properly.

Version-Release number of selected component (if applicable):
RHQ 4.2.0/JON 3.0.0
Comment 1 Mike Foley 2012-02-27 17:03:36 UTC 
triage asantos, mfoley, crouch, loleary  ...JON 3.1
Comment 2 John Mazzitelli 2012-04-04 20:59:07 UTC 
looks like we should be removing the NOLOGGING option from RHQ_ALERT_NOTIFICATION table.

The work around until we patch the dbsetup/dbupgrade code is to run the SQL:

alter table rhq_alert_notification logging
Comment 3 John Mazzitelli 2012-04-05 15:17:47 UTC 
master commit aea4f08 adds dbsetup and dbupgrade code to enable oracle logging on rhq_alert_notification table.
Comment 4 Mike Foley 2012-04-20 18:35:00 UTC 
attaching an image which shows RHQ_ALERT_NOTIFICATION table still has LOGGING=NO.

marking failed to verify.
Comment 5 Mike Foley 2012-04-20 18:35:29 UTC 
Created attachment 579078 [details]
logging in oracle schema
Comment 6 Mike Foley 2012-04-20 19:38:17 UTC 
Created attachment 579091 [details]
my server log
Comment 7 John Mazzitelli 2012-04-20 20:06:56 UTC 
I'm reverting this until bug #814839 is discussed. It turns out, EVERY table has NOLOGGING enabled. Read bug #814839 for the conversation. Teh current thinking is we do not want or need LOGGING.
Comment 8 John Mazzitelli 2012-04-20 20:13:14 UTC 
revert 6ef74e9
Comment 9 John Mazzitelli 2012-04-24 19:51:50 UTC 
Created attachment 579978 [details]
turn on oracle logging on relevant tables

see attached for a .sql file you can execute to turn on LOGGING on all relevent tables. Use this if you want to enable LOGGING on RHQ database tables if you already have RHQ installed.

See bug 814839 for tracking the issue of fixing this on initial install.
Comment 10 John Mazzitelli 2012-04-25 12:50:28 UTC 
closing this as duplicate - see bug #814839

*** This bug has been marked as a duplicate of bug 814839 ***
Note You need to log in before you can comment on or make changes to this bug.