Re: SQLException: innodb_log_file_size headache

Jon,

Thank You, Thank You, Thank You!!!! for that investigation and analysis. 
I have been experiencing intermittent message corruption to SOME 
messages with attachments for a number of months. I foolishly and lazily 
didn't investigate my logs and I just put it down to a dbmail error.  I 
had even started thinking of moving away from dbmail after using it for 
over 10 years.

I made the change to the my.cnf file and restarted mysql and I could 
receive a message with attachments that failed to be received properly 
just a few days ago.  I'm running the gentoo version of mysql v5.6.26 
and I only had to change the my.cnf file and restart mysql (no need to 
delete any log files).

Thanks,
Ken.


On 21/03/2016 7:07 PM, Jonathan Feally wrote:
> FYI,
> After performing a number of upgrades on my FreeBSD ports based 
> install on an older release of FreeBSD 9.1-STABLE, I started getting 
> corrupt messages. Since it was seemingly random on message with 
> attachments, and I had upgraded postfix, mailscanner, dbmail, and 
> mysql all the the same time,  it took a while before I could capture a 
> queued message.
> I finally was able to determine that postfix and mailscanner were not 
> to blame, but rather somewhere in dbmail/mysql.
>
> After taking a look in lmtp logs I found:
> Mar 21 01:28:57 mail.consult-sc dbmail-lmtpd[74282]: [0x804c21810] 
> Error:[message] blob_insert(+203): SQLException: The size of BLOB/TEXT 
> data inserted in one transaction is greater than 10% of redo log size. 
> Increase the redo log size using innodb_log_file_size.
>
> Here is a link to explain what changed in MySQL:
> http://dba.stackexchange.com/questions/75328/row-size-error-with-mysql
>
> This message is to make sure that nobody else starts to run into this 
> issue.
>
> My change to my.cnf:
> ###innodb_log_file_size=5242880 # Too Small!!
> innodb_log_file_size=1048576000 # Close to 100MB accepted now which is 
> large enough for most normal email setups
>
> -Jon
>
> _______________________________________________
> DBmail mailing list
> [email protected]
> http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail