I havent looked at that code for some time, but there is a unique key on (physmessage_id, headername_id, headervalue(255))
This exact condition is guarded against in the code. The only thing I can think of is that it might happen if you have a message with two headers with the same headername, whose headervalues only differ beyond char 255. Drop the unique key involved or tell me more about your setup. Simon Lange wrote: > Mar 3 14:08:02 primary dbmail/lmtpd[21419]: Message:[serverchild] > serverchild.c,PerformChildTask(+346): incoming connection from > [127.0.0.1 (localhost)] by pid [21419] > > Mar 03 14:08:02 primary dbmail-lmtpd[21419]: Error:[sql] > dbmysql.c,db_query(+290): [Duplicate entry > '[EMAIL PROTECTED]' for key 3] [INSERT INTO > dbmail_headervalue (headername_id, physmessage_id, headervalue) VALUES > (16,303737,'[EMAIL PROTECTED]')] > > Mar 03 14:08:02 primary dbmail-lmtpd[21419]: Error:[message] > dbmail-message.c,_header_cache(+1033): insert headervalue failed > > Mar 3 14:08:02 primary dbmail/lmtpd[21419]: Error:[sql] > dbmysql.c,db_query(+290): [Duplicate entry > '[EMAIL PROTECTED]' for key 3] [INSERT INTO > dbmail_headervalue (headername_id, physmessage_id, headervalue) VALUES > (16,303737,'[EMAIL PROTECTED]')] > > Mar 3 14:08:02 primary dbmail/lmtpd[21419]: Error:[message] > dbmail-message.c,_header_cache(+1033): insert headervalue failed > > Mar 3 14:08:02 primary dbmail/lmtpd[21419]: Message:[sort] > sort.c,sort_deliver_to_mailbox(+196): message id=767905, size=46731 is > inserted > > > > I don’t feeling comfortable seeing these errors. Well at last its > inserted but what about the errors?! How could it come that lmtpd > produces duplicate entries when the id is autoincrement?! > > > > Anyone?! > > > ------------------------------------------------------------------------ > > _______________________________________________ > DBmail mailing list > [email protected] > https://mailman.fastxs.nl/mailman/listinfo/dbmail -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
