Roundcube Community Forum

 

Server Error (OK) during search

Started by VeraVault, December 30, 2009, 04:06:00 PM

Previous topic - Next topic

VeraVault

Hello,

I'm using the latest version that just got updated with my cpanel.

I get an error whenever "Entire Message" is checked for searching. There are about 600 messages in the inbox.

It would show "Searching.." then I get the "Server Error (OK)". I looked at the error log i get:

 DB Error: MDB2 Error: constraint violation Query: _doQuery: [Error message: Could not execute statement] [Last executed query: EXECUTE mdb2_statement_mysql_6999fb516629f8724afb7def0ec2b2db31b12938e USING @0, @1, @2, @3, @4, @5, @6, @7, @8, @9, @10] [Native code: 1062] [Native message: Duplicate entry '3-INBOX.msg-6935' for key 2]  in /usr/local/cpanel/base/3rdparty/roundcube/program/include/rcube_mdb2.php on line 627 (GET /3rdparty/roundcube/index.php?_task=mail&_mbox=INBOX)

Unexpected condition from IMAP server, closed or corrupt connection to IMAP. Possible mailbox corruption.

PHP Warning:  fputs(): 40 is not a valid stream resource in /usr/local/cpanel/base/3rdparty/roundcube/program/lib/imap.inc on line 205

SKaero


VeraVault

Quote from: skaero;24320Can you get a imap server log?

where do i find that?

I looked at the var/log/maillog and there was no errors there.

alec

I don't know why you've got "Server error (ok)" message, but "Unexpected condition from IMAP server..." looks not good. Enable imap_debug option in Roundcube and check logs/imap file.

VeraVault

so I did enable the imap log. the log to me seems fine during the search.

[31-Dec-2009 12:09:41 -0500]: S: * SEARCH
[31-Dec-2009 12:09:41 -0500]: S: srch1 OK SEARCH done.
[31-Dec-2009 12:09:41 -0500]: C: sel1 SELECT "INBOX.Trash"
[31-Dec-2009 12:09:41 -0500]: S: * FLAGS (\Draft \Answered \Flagged \Deleted \Seen \Recent)
[31-Dec-2009 12:09:41 -0500]: S: * OK [PERMANENTFLAGS (\* \Draft \Answered \Flagged \Deleted \Seen)] Limited
[31-Dec-2009 12:09:41 -0500]: S: * 1 EXISTS
[31-Dec-2009 12:09:41 -0500]: S: * 0 RECENT
[31-Dec-2009 12:09:41 -0500]: S: * OK [UIDVALIDITY 1254770403] Ok
[31-Dec-2009 12:09:41 -0500]: S: * OK [MYRIGHTS "acdilrsw"] ACL
[31-Dec-2009 12:09:41 -0500]: S: sel1 OK [READ-WRITE] Ok
[31-Dec-2009 12:09:41 -0500]: C: srch1 SEARCH ALL UNSEEN
[31-Dec-2009 12:09:41 -0500]: S: * SEARCH
[31-Dec-2009 12:09:41 -0500]: S: srch1 OK SEARCH done.
[31-Dec-2009 12:09:41 -0500]: C: I LOGOUT

VeraVault

#5
this problem only occurs when doing a search on a folder that has more than 5300 messages. If i do a filter, and only show the unread messages (about 400 of them) the search works.

VeraVault

Any one? this issue is driving me nutz.

alec

There could be "srch1 SEARCH CHARSET UTF-8 HEADER..." in the log. I don't see this nor what returns server for that command.