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.
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.
Comment