Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 466461

Summary:	"low space usage on Satellite oracle DB" email needs wording changed
Product:	[Community] Spacewalk	Reporter:	Michael Mráka <mmraka>
Component:	Server	Assignee:	Michael Mráka <mmraka>
Status:	CLOSED CURRENTRELEASE	QA Contact:	Red Hat Satellite QA List <satqe-list>
Severity:	medium	Docs Contact:
Priority:	medium
Version:	0.3	CC:	dgoodwin
Target Milestone:	---
Target Release:	---
Hardware:	All
OS:	Linux
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2009-09-17 07:02:01 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:
Bug Depends On:
Bug Blocks:	456551

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.