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

As mentioned once before and on the road map: We know that the caching mechanism does not work well with large mailboxes and often reaches the max_allowed_packet and we're working on it.

To cache also complete message sources has one reason: the parser which splits messages into different parts needs the whole message body to work with. Therefore, we put the whole message into the cache (will be deleted when session ends). The advantage of this behavior are shorter loading times for attached files, i.e. images that are displayed right under the text. If the IMAP server is on the same machine or on the LAN, caching can be disabled but if you connect to remote servers, it can be very helpful.

The solution would be to split the folder cache into several records or to have one record per message in the database. We have to make some speed tests in order to choose one of these solutions.

Please be patient!

Thomas

Rob Smith wrote:

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!