[rt-users] issue with attachments table

Hochberg, Keith Keith.Hochberg at mtvn.com
Fri Sep 1 13:05:55 EDT 2006


I was actually mistaken, our dba group found that we did indeed have a
4gb limit on the attachments table in mysql.  This issue is now
resolved.  I appreciate the assistance Jesse.

Keith 

-----Original Message-----
From: Hochberg, Keith 
Sent: Wednesday, August 30, 2006 5:19 PM
To: 'Jesse Vincent'
Cc: rt-users at lists.bestpractical.com
Subject: RE: [rt-users] issue with attachments table

Thanks for the quick reply.  We don't have a limit on either the fs or
mysql.  I believe we've been over 4gb for a while now.  I wish that was
it though! 

-----Original Message-----
From: Jesse Vincent [mailto:jesse at bestpractical.com]
Sent: Wednesday, August 30, 2006 5:12 PM
To: Hochberg, Keith
Cc: rt-users at lists.bestpractical.com
Subject: Re: [rt-users] issue with attachments table




On Wed, Aug 30, 2006 at 05:09:31PM -0400, Hochberg, Keith wrote:
> Hi,
> 
> We run RT3, 20 queues, 110,000 tickets and about 40 users.  Versions 
> are RT 3.2.3, mysql 4.0.20 and apache 2.0.52 on CentOS4.2 with kernel 
> 2.6.9-22.  We recently started experiencing an issue where tickets 
> were being created in our queues with no message body.  We tracked it 
> down to a problem with the attachment table in the RT database.  A 
> mysql maintenance job temporarily fixed the issue and it happened 
> again.  The size of our database is about 4.2GB which doesn't seem too

> large from

Are you 100% sure your filesystem doesn't have a 4GB filesize limit (Or
your mysql build ;)

> what I've read on this mailing list.  Has anyone seen this issue 
> before and have any recommendations?
> 
> We've toyed with the idea of using rtx-shredder or archiving older 
> tickets and making them available via another instance of RT but we 
> don't want to have to do either unless it's absolutely necessary.
> 
> Thanks all!
> 
> Keith Hochberg
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> Community help: http://wiki.bestpractical.com Commercial support: 
> sales at bestpractical.com
> 
> 
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com
> 

-- 



More information about the rt-users mailing list