hello,
at playing around with roundcube i frequently get error messages reported to the error log. it seems like some unique database field has duplicate entries:
[04-Aug-2009 13:33:45 +0200]: DB Error: MDB2 Error: constraint violation Query: _doQuery: [Error message: Could not execute statement] [Last executed query: EXECUTE mdb2_statement_mysql_67b6ccf278247ff949428129a77d7eaa3e5949f68 USING @0, @1, @2, @3, @4, @5, @6, @7, @8, @9, @10] [Native code: 1062] [Native message: Duplicate entry '1-jonas.msg-10692' for key 'uniqueness'] in /roundcubemail/program/include/rcube_mdb2.php on line 623 (GET /roundcubedev/?_task=mail&_mbox=jonas&_page=1) [...] [04-Aug-2009 13:33:59 +0200]: DB Error: MDB2 Error: constraint violation Query: _doQuery: [Error message: Could not execute statement] [Last executed query: EXECUTE mdb2_statement_mysql_5a4c05dcaeb347f40aba233c2ae23a42d53391a2d USING @0, @1, @2, @3, @4, @5, @6, @7, @8, @9, @10] [Native code: 1062] [Native message: Duplicate entry '1-jonas.msg-10666' for key 'uniqueness'] in /roundcubemail/program/include/rcube_mdb2.php on line 623 (GET /roundcubedev/?_task=mail&_action=list&_mbox=jonas&_page=1&_remote=1&_=1249385638967&_unlock=1)
greetings, jonas
--- 8< --- detachments --- 8< --- The following attachments have been detached and are available for viewing. http://detached.gigo.com/rc/Hv/8TJbwoeY/signature.asc Only click these links if you trust the sender, as well as this message. --- 8< --- detachments --- 8< ---
List info: http://lists.roundcube.net/dev/
Jonas Meurer wrote:
at playing around with roundcube i frequently get error messages reported to the error log. it seems like some unique database field has duplicate entries:
[04-Aug-2009 13:33:45 +0200]: DB Error: MDB2 Error: constraint violation Query:
This happens when roundcube is trying to add twice the same message to cache. This may happen when you have got two roundcube sessions opened. I don't know if this happens in single session use. We've removed "message exists in cache" check for performance reasons, but maybe there are some other related bugs. Are you got this with current svn-trunk version?
On 04/08/2009 A.L.E.C wrote:
Jonas Meurer wrote:
at playing around with roundcube i frequently get error messages reported to the error log. it seems like some unique database field has duplicate entries:
[04-Aug-2009 13:33:45 +0200]: DB Error: MDB2 Error: constraint violation Query:
This happens when roundcube is trying to add twice the same message to cache. This may happen when you have got two roundcube sessions opened. I don't know if this happens in single session use. We've removed "message exists in cache" check for performance reasons, but maybe there are some other related bugs. Are you got this with current svn-trunk version?
yes, it's with current svn trunk. and to my knowledge only one session is open.
i have the preview_pane option enabled, maybe it is related to that one? i.e. both preview and read message try to add the message to cache?
greetings, jonas
--- 8< --- detachments --- 8< --- The following attachments have been detached and are available for viewing. http://detached.gigo.com/rc/Vh/c5xUCbe6/signature.asc Only click these links if you trust the sender, as well as this message. --- 8< --- detachments --- 8< ---
List info: http://lists.roundcube.net/dev/
-
A.L.E.C -
Jonas Meurer