Limit Search by Category:     Advanced search
Browse by category:
GWAVA Knowledgebase / GWAVA / GWAVA 4 / Quarantine Management System / Preventing Database Corruption

Preventing Database Corruption
Print
Email to friend
Add comment
Views: 1777
Votes: 2
Comments: 0
Posted: 02 Sep, 2008
by: Bailey J.
Updated: 10 Jun, 2010
by: Quintero R.

Applies To:
GWAVA 4 on NetWare (all builds)

Problem/Question:
QMS or GWAVAMAN databases becoming corrupt on a regular basis
Having to perform rebuilds regularly

Resolution:
Most causes of database corruption have been resolved in the latest builds of GWAVA 4.  So, if you are experiencing db corruption, the first thing you'll want to do is make sure you are up-to-date.  Once  you are on the latest build of GWAVA, there are only a few known causes of GWAVA database corruption that you'll want to be aware of:

1)  Backup software - backing up a GWAVA database while it is in use can potentially cause corruption.  The following article describes which GWAVA files and folders should be backed:  http://support2.gwava.com/kb/?View=entry&EntryID=193.

2)  Unexpected termination - any abrupt termination of GWAVA could potentially corruption.  Some examples of this include:  server abend, killing GWAVA4QMS or GWAVA4CFG address spaces, fatal GWAVA errors that cause GWAVA to shutdown, power outage, etc.

3)  Corrupt mail - sometimes a message may come into your system that GWAVA doesn't know how to handle correctly.  These messages (typically spam with abnormal MIME files) can potentially corrupt your QMS database.  However, most of these issues have been resolved in the latest build of GWAVA.

4)  QMS database has grown to be too large - The QMS database was not designed as an archiving solution.  The purpose is to temporarily hold quarantined email so as to provide a user with the option of reviewing any blocked email before it is deleted.  Slow access to the QMS Manager and frequent corruptions is usually a sign that the QMS database has grown to be much too large (over 3 GB).  You can view the size of the database by browsing to \opt\beginfinite\GWAVA4\services\qms\data and look at the qms_data.db file size.  The following steps should be taken to keep the database at a more manageable size:

a)  Reduce the number of days that quarantined email is held You can find that option in your QMS Manager to 7 days:

b)   Disable quarantine for SURBL and RBL blocked mail.  Email that has been returned positive for either of these two will make up the bulk of email that is flagged, and is unnecessary to quarantine since they are nearly always SPAM.

To disable quarantine for SURBL, browse to:



To disable quarantine for RBL:

See also this related article:

Rebuilding corrupt QMS databases - http://support.gwava.com/kb/?View=entry&EntryID=235
Others in this Category
document Digest Report Stopped Getting Delivered
document After Migrating GWAVA to a New Server, The Digest Report Uses The Old Server's Address
document Cannot Access Quarantine or Release Messages From Digest Outside of the Network
document Unable to Login to QMS as Admin, Login Fails
document Cannot Access QMS After a Restart of GWAVA
document After Running a Rebuild Getting 'Page Cannot be Displayed'
document How To Mass Delete Messages From the Quarantine
document Recreating QMS databases
document Users getting duplicate digest reports.
document Able to log in to QMS as the Admin, but not as a user
document Users Unable to Log in to QMS
document Users Cannot Login to Quarantine Manager
document QMS Log showing Malformed database, or file is encrypted or is not in database
document Using LDAP Authentication to Log into GWAVA QMS
document Running a GWAVAQMS Sync on Linux
document Access denied or session expired messages when users try to login to QMS
document Removed Address Space on GWAVA4QMS, Running Thread DigestSchd
document Quarantine Database is Malformed, or Missing Messages. Rebuild QMS Without Mail Flow Interruption.
document Quarantine Database Failed A Nightly Integrity Check
document Messages in QMS with 'unrecognized subject'
document Testing QMS authentication through GWIA
document Troubleshooting the GWAVA Digest (e-mail Archive Report)
document Changing 'Quarantine Manager' link under home pages
document Messages Being Quarantined That Shoudn't Be
document Can't Login To QMS (Admin)
document QMS showing it is 'Closed for Maintenance'
document How to Quarantine All Mail (Global Quarantine)
document Getting a blank page when trying to access the QMS
document QMS Database Corruption (build 100 and earlier)
document QMS Error: The quarantine reported that the requested message does not exist in the system.
document Unable to login to QMS as admin or a user. User field being populated with numbers.
document Upgrade to QMS2 how-to/troubleshooting guide
document Force QMS2 upgrade
document no such table: t_Tokens after upgrading to QMS2
document How To Release a Digest manually in QMS2
document Login as a user to QMS times out
document Number in QMS login box
document How to Change the 'Manage my Quarantine' link
document Users unable to see messages in the QMS, after admin added them on the Users tab
document One User not Getting Digests as Well as not Seeing Any Messages in Their Own QMS
document Timestamp on Quarantined Messages Wrong
document QMS Creates the Digest Report, but it Never Reaches the Inbox
document Slow browser or browser script errors
document Seeing Only a Certain Amount of Messages in the QMS
document Some QMS mail not viewable as a user
document Migrate QMS Data to a GWAVA 4 SMTP Appliance (Linux)
document Admin. of multiple users QMS without giving admin rights/Managed Addresses
document Change the amount of messages viewed on each page.
document Digest releases but does not show up in clients mailbox
document Unable to Find Released Messages in QMS
document Change QMS Authentication Server
document Automatically delete messages from Quarantine.
document Remove messages from users QMS but not from the Administrators QMS
document How can I Prevent a User From Creating new Accounts in QMS?
document How to Exclude a GW Account From Getting a Digest Report
document QMS Unloading by Itself
document QMS is Reindexing After Restarting GWAVA on Linux
document How to rebuild QMS in a cluster environment
document How to Configure Exchange to Allow AUTH LOGIN to work
document Migrate QMS Data to a GWAVA 4 SMTP Appliance
document How can I Change the Amount of Days Before an Account for QMS Expires?
document Increase Mail in Digest Report
document How to add users to the QMS user list
document Quarantined Messages To A Distribution List
document Cannot Login to QMS because of Cookies
document QMS User Unable to Release a Specific Message from the QMS
document Not all events show up in Digest
document How To Log Into QMS as a User When Not Using GroupWise?
document How To Follow Messages/Digests Released From QMS
document How To Follow Messages That Are Sent To Quarantine
document Removed Address Space on GWAVAQMS, Running Thread InQueueManager
document How to Enable Digests to Certain Users
document How to setup a centralized QMS for multiple GWAVA servers
document QMS Login Via Built-In GWAVA Credentials
document How to View a List of Messages That Were Blocked for a Certain Event and Released.
document How to Keep a Copy of ALL Messages for a Specific User
document How to Follow a Message Through GWAVA Logs to Make Sure it Was Released
document Getting an "Application not Found" Error When Trying to Release From a Digest Report.
document If a User Releases a Message, That Has Multiple Recipients, From Their Quarantine, Will it be Released to All The Recipients?
document If a Message, that has Multiple Recipients, is Deleted by a User From Their Quarantine, is it Removed From All the Recipients' Quarantine?
document Getting a Script Error When Trying to Access the QMS.
document Users Unable to Login to the QMS after Moving GW and GWAVA to a New Server


RSS
Powered by KBPublisher (Knowledge base software)