[imp] "Integrity constraint violation" messages when moving emails

[Arjen de Korte]

Citeren "Jens-U. Mozdzen" <jmozdzen at nde.ag>:

> Hi *,
>
> I have dug deeper into this problem, as it seems to affect several  
> areas of operation. Looking at the list of tables, I noticed that  
> there's "horde_imap_client_message" with nearly 36000 entries - 13  
> of which have a "messageid" of zero:
>
> --- cut here ---
> mysql> select count(*) from horde_imap_client_message where messageid=0;
> +----------+
> | count(*) |
> +----------+
> |       13 |
> +----------+
> 1 row in set (0.01 sec)
>
> mysql> select count(*) from horde_imap_client_message;
> +----------+
> | count(*) |
> +----------+
> |    35804 |
> +----------+
> 1 row in set (0.02 sec)
>
> mysql>
> --- cut here ---
>
> Might it be that not handling of new horde_imap_client_data entries  
> is the root cause, but those 13 entries above? How would I proceed  
> to clean up the entries (with messageid==0) in  
> horde_imap_client_message without disturbing data integrity?

I saw this too a couple of days ago. Since these tables contain only  
cached information from the IMAP server, I just DROPped the tables and  
created new ones. After that, the error message was gone.

Best regards, Arjen
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 5849 bytes
Desc: S/MIME Signature
URL: <http://lists.horde.org/archives/imp/attachments/20140314/06f5e586/attachment-0001.bin>