Author Topic: RC does not handle message caching consistently  (Read 4817 times)

Offline grpprod

  • Full Member
  • ***
  • Posts: 53
RC does not handle message caching consistently
« on: December 26, 2012, 06:21:12 AM »
Hi,
here are some of my recent RC logs. It seems there are some issues present. Any help would be nice. I use PHP 5.4.10.

It seems there is problem when caching is enabled. Please also note that DB was taken from a previous RC (0.3.1) and was upgraded using mysql.update.sql

Quote
[26-Dec-2012 11:42:18 +0200]: DB Error: MDB2 Error: constraint violation Query: _execute: [Error message: Unable to execute statement] [Last executed query: INSERT INTO cache_messages (user_id, mailbox, uid, flags, changed, data) VALUES (?, ?, ?, ?, now(), ?)] [Native code: 1062] [Native message: Duplicate entry '254-INBOX-1243' for key 'PRIMARY']  in /opt/servers/apache/htdocs/roundcube/program/include/rcube_mdb2.php on line 727 (GET /?_task=mail&_action=preview&_uid=1243&_mbox=INBOX&_framed=1)

« Last Edit: December 26, 2012, 08:57:31 PM by grpprod »

Offline SKaero

  • Administrator
  • Hero Member
  • *****
  • Posts: 5,882
    • SKaero - Custom Roundcube development
Re: RC does not handle message caching consistently
« Reply #1 on: December 27, 2012, 12:12:27 AM »
It can happen after a update, its best to clear the cache tables when doing an upgrade.

Offline grpprod

  • Full Member
  • ***
  • Posts: 53
Re: RC does not handle message caching consistently
« Reply #2 on: December 27, 2012, 03:38:21 AM »
Sorry, I thought it was obvious I already did that. In fact, I do this frequently now, but this still happens after some time.

Offline alec

  • Hero Member
  • *****
  • Posts: 1,365
Re: RC does not handle message caching consistently
« Reply #3 on: December 27, 2012, 05:09:13 AM »
This is most likely fixed in git-master with the new DB layer. We do not bother to fix this for MDB2 package.

Offline grpprod

  • Full Member
  • ***
  • Posts: 53
Re: RC does not handle message caching consistently
« Reply #4 on: December 31, 2012, 10:47:07 AM »
I have no problem with these errors. I just want to ask this: Could this errors mean that when cache is enabled security is compromised? In other words, is there a chance that one user reads other user's cached message under certain circumstances? This is my main concern.

Offline JohnDoh

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 2,856
Re: RC does not handle message caching consistently
« Reply #5 on: December 31, 2012, 11:27:37 AM »
Quote
Could this errors mean that when cache is enabled security is compromised?

entries in the cache are entered with the speicific user id so only that user can see them.

btw the cache only stores message headers, none of the message content.
Roundcube Plugins: Contextmenu, SpamAssassin Prefs, and moreā€¦