oro:cron:imap-sync [Failed] – duplicate unique key "oro_email_address_uq"

Hi all!

Last time in cron job I see only failed the command “oro:cron:imap-sync”

The folder "[Gmail]/All Mail" is selected. Previous max email UID "0" Found 242 email(s). The synchronization failed. Error: An exception occurred while executing 'INSERT INTO oro_email_address (created, updated, email, has_owner, owner_user_id, owner_mailbox_id) VALUES (?, ?, ?, ?, ?, ?)' with params ["2017-07-13 00:51:06", "2017-07-13 00:51:06", "mail-noreply@google.com", 0, null, null]: SQLSTATE[23505]: Unique violation: 7 ERROR: duplicate key value violates unique constraint "oro_email_address_uq" DETAIL: Key (email)=(mail-noreply@google.com) already exists.

1 2 3 4 5 6 7

The folder "[Gmail]/All Mail" is selected. Previous max email UID "0" Found 242 email(s). The synchronization failed. Error: An exception occurred while executing 'INSERT INTO oro_email_address (created, updated, email, has_owner, owner_user_id, owner_mailbox_id) VALUES (?, ?, ?, ?, ?, ?)' with params ["2017-07-13 00:51:06", "2017-07-13 00:51:06", "mail-noreply@google.com", 0, null, null]:   SQLSTATE[23505]: Unique violation: 7 ERROR:  duplicate key value violates unique constraint "oro_email_address_uq" DETAIL:  Key (email)=(mail-noreply@google.com) already exists.

But it worked fine several month.
How to fix it?

Topic

[vodvudParticipant]

And one more error:

The folder "INBOX" is selected. Previous max email UID "210" Found 1 email(s). Skip "Re: your interest in high yield investment opportunities" (UID: 210) email, because it is already synchronised. The synchronization failed. Error: A new entity was found through the relationship 'Oro\Bundle\ImapBundle\Entity\ImapEmail#email' that was not configured to cascade persist operations for entity: Re: your interest in high yield investment opportunities. To solve this issue: Either explicitly call EntityManager#persist() on this unknown entity or configure cascade persist this association in the mapping for example @ManyToOne(..,cascade={"persist"}). The synchronization failed. Error: A new entity was found through the relationship 'Oro\Bundle\ImapBundle\Entity\ImapEmail#email' that was not configured to cascade persist operations for entity: Re: your interest in high yield investment opportunities. To solve this issue: Either explicitly call EntityManager#persist() on this unknown entity or configure cascade persist this association in the mapping for example @ManyToOne(..,cascade={"persist"}).

1 2 3 4 5 6

The folder "INBOX" is selected. Previous max email UID "210" Found 1 email(s). Skip "Re: your interest in high yield investment opportunities" (UID: 210) email, because it is already synchronised. The synchronization failed. Error: A new entity was found through the relationship 'Oro\Bundle\ImapBundle\Entity\ImapEmail#email' that was not configured to cascade persist operations for entity: Re: your interest in high yield investment opportunities. To solve this issue: Either explicitly call EntityManager#persist() on this unknown entity or configure cascade persist  this association in the mapping for example @ManyToOne(..,cascade={"persist"}). The synchronization failed. Error: A new entity was found through the relationship 'Oro\Bundle\ImapBundle\Entity\ImapEmail#email' that was not configured to cascade persist operations for entity: Re: your interest in high yield investment opportunities. To solve this issue: Either explicitly call EntityManager#persist() on this unknown entity or configure cascade persist  this association in the mapping for example @ManyToOne(..,cascade={"persist"}).

Synchronization stopped due to these errors.
But it worked fine before.

I have not idea…

[wgozdzickiParticipant]

Hello,
Could you give us, please, what version of CRM you use?

Best regards,
Wiktor

[Author]

Replies