Re: [rt-users] Attachment size issue?

2014-12-04 Thread Christian Loos 
Am 04.12.2014 um 21:32 schrieb Alex Vandiver:
> Thus, in addition to setting max_allowed_packet, you will need to
> increase innodb_log_file_size, or you'll only be able to insert files
> which are < 5M (or, on 5.6.22 or higher, < 10M).  Note that increasing
> innodb_log_file_size is slightly complex:
> 
> http://www.percona.com/blog/2011/07/09/how-to-change-innodb_log_file_size-safely/

MySQL 5.6.8 resize the log files automatically:

http://dev.mysql.com/doc/refman/5.6/en/innodb-data-log-reconfiguration.html

Chris

Re: [rt-users] Attachment size issue?

2014-12-04 Thread Alex Vandiver 
On 12/04/2014 02:16 PM, Karres, Dean wrote:
> I was looking in my RT log file for a different issue and found the
> following [snip]
>
> I thought I raised the attachment size limit when I installed RT.   Do I
> need to do that again?  We provide a few specialized, internal services
> and our customers insist on emailing us super giant attachments.

This is caused by changes in MySQL 5.6 (see the first IMPORTANT CHANGE):

http://dev.mysql.com/doc/relnotes/mysql/5.6/en/news-5-6-20.html

Thus, in addition to setting max_allowed_packet, you will need to
increase innodb_log_file_size, or you'll only be able to insert files
which are < 5M (or, on 5.6.22 or higher, < 10M).  Note that increasing
innodb_log_file_size is slightly complex:

http://www.percona.com/blog/2011/07/09/how-to-change-innodb_log_file_size-safely/

 - Alex

[rt-users] Attachment size issue?

2014-12-04 Thread Karres, Dean 
Hi,

RT 4.2.6
RHEL 6.6
MySQL 5.6

I was looking in my RT log file for a different issue and found the following.

eval {...} called at -e line 0 (/usr/local/share/perl5/Carp.pm:169)
[3523] [Thu Dec  4 18:24:43 2014] [critical]: Attachment insert failed: Row size
too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=D
YNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of
768 bytes is stored inline. (/opt/rt-4.2.6/sbin/../lib/RT/Attachment.pm:221)
[3523] [Thu Dec  4 18:24:43 2014] [critical]: Attachment insert failed: Row size
too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=D
YNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of
768 bytes is stored inline. (/opt/rt-4.2.6/sbin/../lib/RT/Attachment.pm:191)


I thought I raised the attachment size limit when I installed RT.   Do I need 
to do that again?  We provide a few specialized, internal services and our 
customers insist on emailing us super giant attachments.

Dean...K...