[ngw] Maximum Physical Database Size

Hinchman Consulting gregg at hinchmanconsulting.com
Fri Jun 21 18:38:19 UTC 2019


I vote corrupt. 5 users should fill them up.  What file system is the gw po on?

Ext3/4 or nfs. Ok.  Btrfs. Not good.  

So one other thing you could do.  And not a fun one.  Move the users to a new post office.  That will spread them out in the new po msg dbs.  It may be that once done the old msg will be good.  Then you could move them back or off load more users to the new po.  

Sometimes cleaning house with user moves does refresh the system.  Not a great amount of fun but I have seen it work many times.  

Good luck.  

Sent while mobile.

Gregg A. Hinchman, PMP
Salesforce Certified Administrator
765.653.8099

> On Jun 21, 2019, at 2:31 PM, Michael Statman <Mike at emesconsulting.net> wrote:
> 
> on the other hand, maybe the msg3.db is actually corrupt and a stand-alone ngwcheck rebuild is in order.
> 
> 
>>>> "Marvin Huffaker" <mhuffaker at redjuju.com> 6/21/2019 1:28 PM >>>
> This is what I have.. There are only 5 users on the msg3.db database file..   
> 
> Userid    (FID / DiskID)  #recs Highest Deleted  Setup DB size (bytes)  (Name [Dept]
> 
> aaaaaaaaaaaa (eyf /  3)  64227 (122623)      2      9        89509888  (xxxxxxxxxxxxx])
> bbbbbbbbbb (qyi /  3)  31180 ( 34851)      2      9        59015168  (xxxxxxxxxxxxxx[])
> ccccccccccccc (u3u /  3) 138467 (1006528)      5      9       238934016  (xxxxxxxxxxxxxxxx])
> dddddddddd (1kr /  3)   3744 (  9986)      0      9         5977088  (xxxxxxxxxxxxxxx])
> eeeeeeeeeee  (ato /  3)  47573 (119263)      0     8       65929216  (xxxxxxxxxxxxxxxxxxx]
> 
> 
> What are the numbers in the Parenthesis under #recs Highest Deleted?     These 5 accounts do not look like they could consume 4GB of space in the msg3.db file.   Am I missing something? 
>>>> "Michael Statman" <Mike at EMESConsulting.Net> 6/21/2019 12:45 PM >>>
> 2014r2 doc states: "User databases (userxxx.db files) might contain large numbers of contacts and folders. Contacts and folders affect the size of the user databases, which have a maximum size of 4 GB, but do not count against the mailbox size for users."   I didn't find it stated as such, but presumably this is a hard limit that applies to the message db as well.
> 
> As to resolution... find out which users are associated to msg3.db ( see e.g.  https://support.microfocus.com/kb/doc.php?id=7013421 ) and then take a look at those mailboxes in particular for cleanup.  I'd suspect just one or maybe a couple users are the culprits.
> 
> 
> 
> -Mike
>>>> "Marvin Huffaker" <mhuffaker at redjuju.com> 6/21/2019 12:07 PM >>>
> Is there a hardset limit on the maximum physical size of the message databases?  Either in the ofmsg or ofuser folders?  (I'm not talking user quotas, I'm talking raw database files).
> 
> In all the years I've worked with GroupWise I've never run into this situation.   I have one file in the ofmsg folder that is 4GB and that seems to be the problem.. So is it a hardset limit of 4GB?   How would I go about resolving this?  I think I could probably do a reduce expire to get some temporary relief but it doesn't seem like a long term fix.
> 
> Here's the error:
> 
> "Error that occurred: C05C-The Database has reached its maximum size"
> 
> 
> Look at the file below "msg3.db" is 4.0GB in size..
> 
> 
> 
> mdlxgw01:/srv/gwdata/bannerpo/ofmsg # ls -alh | grep G
> total 103G
> -rw-r--r--  1 root root 1.1G Jun 21 12:01 msg120.db
> -rw-r--r--  1 root root 1.3G Jun 21 12:02 msg136.db
> -rw-r--r--  1 root root 1.7G Jun 21 12:01 msg148.db
> -rw-r--r--  1 root root 1.1G Jun 21 12:03 msg152.db
> -rw-r--r--  1 root root 1.1G Jun 21 12:04 msg178.db
> -rw-r--r--  1 root root 1.1G Jun 21 11:52 msg211.db
> -rw-r--r--  1 root root 1.5G Jun 21 11:57 msg246.db
> -rw-r--r--  1 root root 4.0G Jun 21 12:04 msg3.db
> 
> _______________________________________________
> ngw mailing list
> ngw at ngwlist.com
> http://ngwlist.com/mailman/listinfo/ngw



More information about the ngw mailing list