Duplicate entry error email

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • joy11
    Active Community Member
    • Jan 2017
    • 113

    Duplicate entry error email

    I'm not sure this is truly a bug, but I have an error in my log and I can't find it in my database. I believe it has something to do with the email_user table because I can actually find these pairs in that table, but I don't see duplicates for them in that table. The email account is a totally different user than what I think is the corresponding user_id from the pair in the error message.
    Any help figuring out how I can correct these would be great. I think it causes some duplicate emails to come in and go out of the system at those times. I've seen duplicate cases generated from group email at similar times to these errors. I do have some workflows sending emails out from cases, maybe that has something to do with it?


    []
    [2017-12-28 03:22:03] Espo.ERROR: EmailAccount 58ac9d53a0be407d1 (Import Message w/ MailMimeParser): [23000] SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '5a4462ed2539a8bcc-58750e87ac9db5f09' for key 'UNIQ_12A5F6CCA832C1C9A76ED395' []
    []
    [2017-12-28 03:22:16] Espo.ERROR: EmailAccount 58ad8b8986860b500 (Import Message w/ MailMimeParser): [23000] SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '5a4462ed2539a8bcc-586e9b5f536d5c131' for key 'UNIQ_12A5F6CCA832C1C9A76ED395' []
    []
    [2017-12-28 12:51:28] Espo.ERROR: EmailAccount 58ac506c06f9cdeaf (Import Message w/ MailMimeParser): [23000] SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '5a44e89140d013787-58750ef206b7957d7' for key 'UNIQ_12A5F6CCA832C1C9A76ED395' []
    []
    [2017-12-28 12:51:50] Espo.ERROR: EmailAccount 58ac506c06f9cdeaf (Import Message w/ MailMimeParser): [23000] SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '5a44e8a2eba44eff5-58750ef206b7957d7' for key 'UNIQ_12A5F6CCA832C1C9A76ED395' []
    []
    [2017-12-28 12:52:01] Espo.ERROR: EmailAccount 58ac506c06f9cdeaf (Import Message w/ MailMimeParser): [23000] SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '5a44e8aba576a649f-58750ef206b7957d7' for key 'UNIQ_12A5F6CCA832C1C9A76ED395' [] []


    I did a database search for this last one '5a44e8aba576a649f' and it appears that id is found in the following tables:
    1 attachment
    1 email
    1 email_email_account
    2 email_email_address
    2 email_user

    The second one '58750ef206b7957d7' is the user whose email account is referenced in the same message.
    Last edited by joy11; 12-28-2017, 03:41 PM.
  • joy11
    Active Community Member
    • Jan 2017
    • 113

    #2
    I did find the 'UNIQ_12A5F6CCA832C1C9A76ED395' key in the 'email_user' table. I tried to change this to an index key instead of a unique key and it reverted back to unique. I'm not finding the duplicate entry mentioned in the error message.
    Keyname Type Unique Packed Column Cardinality Collation Null
    UNIQ_12A5F6CCA832C1C9A76ED395 BTREE Yes No email_id
    user_id
    286296
    286296
    A
    A
    Yes
    Yes
    Last edited by joy11; 01-02-2018, 02:26 PM.

    Comment

    Working...