Hello Mailinglist Members
Today one of our customer and webmail user had a problem viewing his
inbox. I've could track down the problem in our test installation.
Roundcube tried to INSERT a new record to the message table. But a
duplication error (constraint violation) occurred. The constraint
violation happened in the "UNIQUE KEY uniqueness
(user_id,cache_key,uid)" constraint. We upgraded on Monday to v0.4
and this is the first time we experience this error. I solved the
problem by deleting the messages from this user with the certain cache_key.
I can provide some SQL-Data and query that caused the problem.
It could be a problem that has to do with the upgrade. I've done all the upgrade instructions.
Thank you for your help and suggestions.
Dominic Luechinger _______________________________________________ List info: http://lists.roundcube.net/dev/ BT/aba52c80
On 26.08.2010 20:58, Dominic Lüchinger wrote:
It could be a problem that has to do with the upgrade. I've done all the upgrade instructions.
I don't think so. It is a known issue http://trac.roundcube.net/ticket/1486748, but no solution yet. From my point of view this is not a big issue. The constraint violation like errors should be ignored and not logged, but I don't found an option in MDB2 to do this.
-
A.L.E.C -
Dominic Lüchinger