The source of his problem was the same as my mysql errors when I first started using RC. RoundCube caches the attachments from emails, which easily surpasses mysql's default max packet size.
This ties in with the other emails that have been going around about RoundCube's caching. I don't care what database the cache is being stored in, I figure mysql works fine, but if files are faster, I guess we can do it that way. More importantly, why are we caching attachments? They are large, and usually only downloaded once by the user. Additionally, this means RoundCube is downloading the attachment before I even try to download. Overall, caching attachments seems like an unecessary waste of resources. If we change it to only cache the actual emails, we should be able to void these mysql configuration issues, and save a lot of bandwidth and database room.

Rob

Ben Nelson wrote:

maildir

I got a suggestion earlier today from an individual who just suggested
that I increase the max_allowed_packet size in MySQL.  That seems to
have fixed the problem.  Apparently the SQL query to update the cache
was exceeding the 1M packet limit that my MySQL installation was
configured for.

thanks,
--Ben

Robert Landes wrote:

Are you using mbox or Mialdir mailbox format?

On Fri, 28 Oct 2005 08:24:39 -0600, Ben Nelson <lists@venom600.org> wrote:

Hello,
I recently started taking a look at RoundCube to handle me webmail and
must say that I really like the interface.  Much cleaner and easier to
use than any webmail I've seen to date (including commercial varieties).

One problem I noticed immediately, however, is that I get SQL errors
with large mailboxes.  I'm not sure exactly what the upper limit is, but
I had 2000+ emails in my inbox and it seems that roundcube was
attempting to issue a very large insert into the cache table.  That
entry failed.

I moved some mail around to see if it was an issue w/ the number of
emails in my inbox and was able to get the error to go away by reducing
the size of my inbox.  As I said, I don't know what the upper limit is,
but for mailboxes with only a couple hundred emails in them it works
just fine.

I'm running:
RoundCube v0.1-20051021
Apache 2.0.54
PHP 4.4.0
MySQL 4.1.14

Thanks,
--Ben




!DSPAM:4362592523361268324477!