fetchmail creates several mail.message records for the same email

[Lorenzo Battistini]

OpenERP 6.0 and 6.1

Configure an IMAP incoming mail server that fetches from <email address hidden>
1- The first fetched mail is correctly created (from <email address hidden> to <email address hidden>)
2- Answer to that email through the 'communication & history' tab (from <email address hidden> to <email address hidden>)
3- The customer answers (from <email address hidden> to <email address hidden>)
4- Support team answers (from <email address hidden> to <email address hidden>)
5- The customer answers again (from <email address hidden> to <email address hidden>)

When fetchmail fetches this fifth email, it duplicates the created mail.message
At the next customer's answer, fetchmail will create 3 mail.message for the same email, and so on.

You can notice this behaviour on https://openerp.my.openerp.com too

[Amit Bhavsar (Open ERP) (amb-openerp)]

Hello Lorenzo Battistini,

I have tested your scenario, But I did not face any problem. It's working fine at my end. I have attached the video for your reference. Would you please check it.

So would you please try again and notify us where you have faced the problem.

Thanks and waiting for your reply!

[Lorenzo Battistini (elbati)]

Hello Amit,
if you go to minute 5:43 of your video, you can see the duplicated messages from "customer":
both communications start with
"Amit ... wrote ... on 2012-03-21 14:17:26"

[Amit Parik (amit-parik)]

Hello Lorenzo,

Thanks for your useful response on this.

Now I have reproduce the same at my end. The problem occurs when fetchmail fetches this fifth email, it duplicates the created mail.message.

Thanks again!

[Ronald Portier (Therp) (rportier1962)]

Maybe it might help to have a unique constraint on the message_id field in mail_message_common. Of course warnings should be logged when messages can not be added because of this constraint..