MDB2 Error: constraint violation

[floeff]

Hello,

I run RoundCube 0.2-stable on a Dovecot IMAP server, and every now and then I receive errors like these:

Code Select Expand

[07-Jan-2009 12:51:32 +0100] DB Error: MDB2 Error: constraint violation Query: _doQuery: [Error message: Could not execute statement] [Last exec
uted query: EXECUTE mdb2_statement_mysql_528670db03153d30e9e7a0ce2f9c5d458226c0344 USING @0, @1, @2, @3, @4, @5, @6, @7, @8, @9, @10] [Native co
de: 1062] [Native message: Doppelter Eintrag '29-INBOX.msg-57' f<FC>r Schl<FC>ssel 2]  in /var/www/roundcube/program/include/rcube_mdb2.php on l
ine 540 (GET /roundcube/?_task=mail&_action=get&_uid=57&_mbox=INBOX&_part=1.2.2)

[08-Jan-2009 09:51:48 +0100] DB Error: MDB2 Error: constraint violation Query: _doQuery: [Error message: Could not execute statement] [Last exec
uted query: EXECUTE mdb2_statement_mysql_538877e25f0655975d9c587963411154925db5ade USING @0, @1, @2, @3, @4, @5, @6, @7, @8, @9, @10] [Native co
de: 1062] [Native message: Doppelter Eintrag '17-INBOX.msg-2' f<FC>r Schl<FC>ssel 2]  in /var/www/roundcube/program/include/rcube_mdb2.php on li
ne 540 (GET /roundcube/?_task=mail&_action=get&_uid=2&_mbox=INBOX&_part=1.2.2)


Anyone knows what the problem might be?

Thanks!
floeff

[eagle1]

The same here on Debian with Courier-IMAP....

Any hints?

[JohnDoh]

do you have caching enabled? it looks like one of your messages has something in the headers which is breaking the SQL statement. I suggest if you can find which message it is then open a ticket on trac and attach the message for the devs to look at.

[floeff]

Hi John,

thanks for your reply. Do you mean the configuration directive

$rcmail_config['enable_caching'] = TRUE;

?

floeff

[JohnDoh]

thats the one

[floeff]

Thanks! I will monitor it and try it out. I guess it's not a single message causing the issue, given the frequency the error occurs.

[eagle1]

I've turned off the CACHE feature, now the errors goes away.

It's possible that is an issue caused by upgrading from older version?

I see this after the MDB2 error: [Native message: Duplicate entry 'INBOX.msg-256' for key 2]

[floeff]

I've turned off the CACHE feature, now the errors goes away.

It's possible that is an issue caused by upgrading from older version?

I upgraded from 0.2-trunk (beta) to 0.2-stable. Database scheme had the same version, but maybe the beta made some faulty entries. Can I simply empty the cache table, or is this a risk?

Florian

[d00s7w]

i have the same issue but i have enable_cache = false.


[03-Aug-2011 17:06:55 +0100]: DB Error: MDB2 Error: constraint violation Query: _doQuery: [Error message: Could not execute statement] [Last executed query: INSERT INTO session (sess_id, vars, ip, created, changed) VALUES ('92114e1b1fd0efe3b6f847872a1c5261', 'bGFuZ3VhZ2V8czo1OiJlbl9HQiI7YXV0aF90aW1lfGk6MTMxMjM4NzYxNTt0ZW1wfGI6MTs=', '82.30.37.166', FROM_UNIXTIME(1312387615), FROM_UNIXTIME(1312387615))] [Native code: 1062] [Native message: Duplicate entry '92114e1b1fd0efe3b6f847872a1c5261' for key 'PRIMARY']  in C:\Inetwww\webmail\program\include\rcube_mdb2.php on line 650 (GET /?_task=mail&_remote=1&_action=list&_mbox=INBOX&_refresh=1&_=1312387611986&_unlock=loading1312387611984)

[d00s7w]

i have the same issue but i have enable_cache = false.


[03-Aug-2011 17:06:55 +0100]: DB Error: MDB2 Error: constraint violation Query: _doQuery: [Error message: Could not execute statement] [Last executed query: INSERT INTO session (sess_id, vars, ip, created, changed) VALUES ('92114e1b1fd0efe3b6f847872a1c5261', 'bGFuZ3VhZ2V8czo1OiJlbl9HQiI7YXV0aF90aW1lfGk6MTMxMjM4NzYxNTt0ZW1wfGI6MTs=', '82.30.37.166', FROM_UNIXTIME(1312387615), FROM_UNIXTIME(1312387615))] [Native code: 1062] [Native message: Duplicate entry '92114e1b1fd0efe3b6f847872a1c5261' for key 'PRIMARY']  in C:\Inetwww\webmail\program\include\rcube_mdb2.php on line 650 (GET /?_task=mail&_remote=1&_action=list&_mbox=INBOX&_refresh=1&_=1312387611986&_unlock=loading1312387611984)