Bug 466461 - "low space usage on Satellite oracle DB" email needs wording changed
Summary: "low space usage on Satellite oracle DB" email needs wording changed
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Spacewalk
Classification: Community
Component: Server
Version: 0.3
Hardware: All
OS: Linux
medium
medium
Target Milestone: ---
Assignee: Michael Mráka
QA Contact: Red Hat Satellite QA List
URL:
Whiteboard:
Depends On:
Blocks: space03
TreeView+ depends on / blocked
 
Reported: 2008-10-10 11:47 UTC by Michael Mráka
Modified: 2009-09-17 07:02 UTC (History)
1 user (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2009-09-17 07:02:01 UTC
Embargoed:


Attachments (Terms of Use)

Description Michael Mráka 2008-10-10 11:47:57 UTC
+++ This bug was initially created as a clone of Bug #210342 +++

Description of problem:
The subject line of the email that gets sent by check-oracle-space-usage.sh
(rhn-dobby) should be reworded.  Currently it says "Warning - low space usage on
Satellite oracle DB" but this says (to me) that there is plenty of space left.

Suggested new wording:
"Warning - running low on free space for your RHN Satellite Oracle database"

Version-Release number of selected component (if applicable):
rhn-dobby-4.1.4-3

How reproducible:
always

Steps to Reproduce:
1.  Install a 415 satellite.
2.  Exceed 90% usage in one of the tablespaces of the satellite db.  An easy way
might be to change /etc/cron.daily/check-oracle-space-usage.sh to say "if [ $num
-gt 5 ]" instead of 90.
3.  Copy /etc/cron.daily/check-oracle-space-usage.sh to
/etc/cron.hourly/check-oracle-space-usage.sh
4.  Restart crond.
5.  Sync a channel.
6.  Wait for the email to the satellite admin warning that one of the
tablespaces is running low.
  
Actual results:


Expected results:
Less confusing wording.

Additional info:

--- Additional comment from bnackash on 2006-10-11 12:39:55 EDT ---

Step 2 above should be "Exceed 5% usage ..."  The default is 90% usage.  But
that might take too long.

--- Additional comment from mmccune on 2006-12-05 16:34:32 EDT ---

moving to uncommitted

Comment 1 Michael Mráka 2008-10-10 11:50:34 UTC
Fixed in git, commit 
f4021f1ed3625aebfed0bedabdb68de1b75325ef.

Comment 2 Devan Goodwin 2008-11-04 18:02:03 UTC
Confirmed the new text by installing spacewalk-dobby and checking the script in question:

   SUBJECT="Warning - high tablespace usage on Satellite oracle DB"



   BODY="This is a notice to let you know that you have gone over 90% usage in

one of the Oracle Tablespaces. We recommend to be proactive and increase the

size of the tablespace  before getting to 100% usage. Please consult

the Satellite documentation on using db-control to increase the size or

contact Red Hat Support for assistance."



Verified in spacewalk 0.3.

Comment 3 Miroslav Suchý 2009-09-17 07:02:01 UTC
Spacewalk has been released for some time.


Note You need to log in before you can comment on or make changes to this bug.