[rt-users] issue with attachments table
jesse at bestpractical.com
Wed Aug 30 17:11:37 EDT 2006
On Wed, Aug 30, 2006 at 05:09:31PM -0400, Hochberg, Keith wrote:
> 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
> 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