[rt-users] Large Attachments being processed

[Jesse Vincent]

On Wed, Sep 23, 2009 at 11:24:58AM -0400, Mike Johnson wrote:
> Greetings,
>  
> So I did my homework... and I"m looking for anyone that has tested large attachments.


I've put attachments of a couple hundred megs into RT. The biggest
thing you'll want to do is to turn the timeouts on the mail gateway
and the webserver processes way up.  It should work, but I don't really
_recommend_ filling your RT instance with giant attachments.


>  
> The Attachment table's content field in the rt3 database uses longtext as the datatype.  This means it can hold a 4GB file.  However in the default RT_SiteConfig.pm it has it cut off at 10mb.
>  
> Now, I have come to realize that fetchmail is the reason why this is low.  Our fetchmail tried to parse a 100mb file into an RT ticket, and it ended up forking perl processes until the server ran out of memory and started using swap memory, and eventually crippled the server.
>  
> My question is, what is the biggest size file fetchmail can parse without the above happening?  Is it dependent on RAM?  Our box has 4GB of ram, and it chewed through that in a matter of seconds....
>  
> Also, if the user manually attaches a file through the Web Interface, is there any limitation with RT itself, now that I know mysql can handle a 4GB file?
>  
> We are on an older version, but this question remains the same for the latest version.  The latest version of RT's default config has attachments of 10mb truncated.
>  
> Thanks!
>  
>  
> Mike Johnson
> Datatel Programmer/Analyst
> Northern Ontario School of Medicine
> 955 Oliver Road
> Thunder Bay, ON   P7B 5E1
> Phone: 807.766.7331
> Email: mike.johnson at normed.ca 
> Technology assistance: email nosmhelpdesk at normed.ca 
> Technology Emergency Contact (TEC) Mon-Fri, 8am to 5pm excluding stat holidays: 
> Off campus toll free 1-800-461-8777, option 8, or locally either 
> (705)-662-7120 or (807)-766-7500

> _______________________________________________
> 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

--