SQL errors with large inboxes
venom at venom600.org
Fri Oct 28 18:53:39 CEST 2005
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
Robert Landes wrote:
> Are you using mbox or Mialdir mailbox format?
> On Fri, 28 Oct 2005 08:24:39 -0600, Ben Nelson <lists at venom600.org> wrote:
> 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
More information about the Dev