List Info

Thread: Re: AW: AW: HMM got lmtp dupicate entries HOW and WHY?




Re: AW: AW: HMM got lmtp dupicate entries HOW and WHY?
country flaguser name
Netherlands
2008-03-03 10:10:23
I looked at it.

Something strange caught my eye. The headername_id values in
the logs are
strictly ascending. That should not be the case because that
implies the message
inserted in the logs is very much like the first message you
ever inserted into
dbmail.  Could you post another l5 log for a message that is
*not* dbmail
related perhaps?

Also, I noticed that in the logs, the collision only occurs
on the
headername_id=16 insertion, which appears to be for
'return-path'. But the
return-path header doesn't even occur twice in that
message.

Which glib/gmime versions are you using?


Simon Lange wrote:
> http://www.sim
onlange.de/lmtp-lvl5.log
> 
> you may fetch it if you want. Disabled lvl5 again ;)
> 
> regards
> 
> Simon
> 
> -----Ursprüngliche Nachricht-----
> Von: dbmail-bouncesdbmail.org
[mailto:dbmail-bouncesdbmail.org] Im Auftrag von Paul J Stevens
> Gesendet: Montag, 3. März 2008 16:00
> An: DBMail mailinglist
> Betreff: Re: AW: [Dbmail] HMM got lmtp dupicate entries
HOW and WHY?
> 
> Simon Lange wrote:
>> Hi Paul,
>>
>> i did update from 2.2.6rc1 to most recent version
2.2.9
>> before and after I did run a full maintenance of
dbmail.
>> I already tried remove the specific row but the
error came up again for another mail then.
>> So its somehow related to lmtp but don’t know why
and how.
>> There is only one instance of dbmail running
(imapd,pop3d,lmtpd,timsieved) and lmtp is exclusive storing
mails (no dbmail-smtp running or using).
> 
> I'd appreciate a level=5 log of such an event (the log
for the complete message,
> not just the error)
> 


-- 
 
____________________________________________________________
____
  Paul Stevens                                      paul at
nfg.nl
  NET FACILITIES GROUP                     GPG/PGP:
1024D/11F8CD31
  The Netherlands________________________________http://www.nfg.nl
_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

AW: AW: AW: HMM got lmtp dupicate entries HOW and WHY?
user name
2008-03-03 14:00:36
NOT DBMAIL RELATED?!
THE DB STRUCTURE IS STRICTLY DBMAIL 2.2. 
SO WHAT KIND OF LOG YOU WANT? ITS ALWAYS THE SAME ERROR:
SEVERAL DUPLICATE KEY ERRORS AND THEN ITS STORED ANYWAY. ;)
OR DO YOU WANT SOME MAIL WHICH IS NOT CONTAINING SOME
DBMAIL-CONTENT?! (E.G. THIS MAILINGLIST MAIL)

IF I UNDERSTAND YOU CORRECT YOU SAY THAT IF I DON€™T GET A
MAIL WITH RETURN-PATH IT WONT HAPPEN?
MY TABLESTRUCTURE OF THE DBMAIL_HEADERVALUE TABLE IS:
HEADERNAME_ID (BIGINT 20) INDEXED
PHYSMESSAGE_ID (BIGINT 20) INDEXED
ID (BIGINT 20) PRIMARY AUTO_INCREMENT
HEADERVALUE TEXT

DBMAIL 2.2.9 HAS BEEN BUILD WITH MYSQL AND SIEVE SUPPORT.
GLIB 1.2.10-595
GLIB2 2.8.1-3
GMIME 2.1.16-5

REGARDS

SIMON

-----URSPRüNGLICHE NACHRICHT-----
VON: DBMAIL-BOUNCESDBMAIL.ORG [MAILTOBMAIL-BO
UNCESDBMAIL.ORG] IM AUFTRAG VON PAUL J STEVENS
GESENDET: MONTAG, 3. MäRZ 2008 17:10
AN: DBMAIL MAILINGLIST
BETREFF: RE: AW: AW: [DBMAIL] HMM GOT LMTP DUPICATE ENTRIES
HOW AND WHY?

I LOOKED AT IT.

SOMETHING STRANGE CAUGHT MY EYE. THE HEADERNAME_ID VALUES IN
THE LOGS ARE
STRICTLY ASCENDING. THAT SHOULD NOT BE THE CASE BECAUSE THAT
IMPLIES THE MESSAGE
INSERTED IN THE LOGS IS VERY MUCH LIKE THE FIRST MESSAGE YOU
EVER INSERTED INTO
DBMAIL.  COULD YOU POST ANOTHER L5 LOG FOR A MESSAGE THAT IS
*NOT* DBMAIL
RELATED PERHAPS?

ALSO, I NOTICED THAT IN THE LOGS, THE COLLISION ONLY OCCURS
ON THE
HEADERNAME_ID=16 INSERTION, WHICH APPEARS TO BE FOR
'RETURN-PATH'. BUT THE
RETURN-PATH HEADER DOESN'T EVEN OCCUR TWICE IN THAT
MESSAGE.

WHICH GLIB/GMIME VERSIONS ARE YOU USING?


SIMON LANGE WROTE:
> HTTP://WWW.SIMONLANGE.DE/LMTP-LVL5.LOG
> 
> YOU MAY FETCH IT IF YOU WANT. DISABLED LVL5 AGAIN ;)
> 
> REGARDS
> 
> SIMON
> 
> -----URSPRüNGLICHE NACHRICHT-----
> VON: DBMAIL-BOUNCESDBMAIL.ORG [MAILTOBMAIL-BO
UNCESDBMAIL.ORG] IM AUFTRAG VON PAUL J STEVENS
> GESENDET: MONTAG, 3. MäRZ 2008 16:00
> AN: DBMAIL MAILINGLIST
> BETREFF: RE: AW: [DBMAIL] HMM GOT LMTP DUPICATE ENTRIES
HOW AND WHY?
> 
> SIMON LANGE WROTE:
>> HI PAUL,
>>
>> I DID UPDATE FROM 2.2.6RC1 TO MOST RECENT VERSION
2.2.9
>> BEFORE AND AFTER I DID RUN A FULL MAINTENANCE OF
DBMAIL.
>> I ALREADY TRIED REMOVE THE SPECIFIC ROW BUT THE
ERROR CAME UP AGAIN FOR ANOTHER MAIL THEN.
>> SO ITS SOMEHOW RELATED TO LMTP BUT DON€™T KNOW WHY
AND HOW.
>> THERE IS ONLY ONE INSTANCE OF DBMAIL RUNNING
(IMAPD,POP3D,LMTPD,TIMSIEVED) AND LMTP IS EXCLUSIVE STORING
MAILS (NO DBMAIL-SMTP RUNNING OR USING).
> 
> I'D APPRECIATE A LEVEL=5 LOG OF SUCH AN EVENT (THE LOG
FOR THE COMPLETE MESSAGE,
> NOT JUST THE ERROR)
> 


-- 
 
____________________________________________________________
____
  PAUL STEVENS                                      PAUL AT
NFG.NL
  NET FACILITIES GROUP                     GPG/PGP:
1024D/11F8CD31
  THE
NETHERLANDS________________________________HTTP://WWW.NFG.NL

_______________________________________________
DBMAIL MAILING LIST
DBMAILDBMAIL.ORG
HTTPS://MAILMAN.FASTXS.NL/MAILMAN/LISTINFO/DBMAIL

_______________________________________________
DBMAIL MAILING LIST
DBMAILDBMAIL.ORG
HTTPS://MAILMAN.FASTXS.NL/MAILMAN/LISTINFO/DBMAIL

Re: AW: AW: HMM got lmtp dupicate entries HOW and WHY?
country flaguser name
Italy
2008-03-04 05:27:44
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Paul J Stevens wrote:
> I looked at it.
> 
> Something strange caught my eye. The headername_id
values in the logs are
> strictly ascending. That should not be the case because
that implies the message
> inserted in the logs is very much like the first
message you ever inserted into
> dbmail.  Could you post another l5 log for a message
that is *not* dbmail
> related perhaps?
> 
> Also, I noticed that in the logs, the collision only
occurs on the
> headername_id=16 insertion, which appears to be for
'return-path'. But the
> return-path header doesn't even occur twice in that
message.
> 
Paul
just to pick up on this. You saw from the log insert that
there was only
one Return-Path header. However from my limited experience
the
Return-Path header added by dbmail is only stored in
dbmail_headervalues
and never added to the phymessage. Up to now I was using
cyrus and all
my migrated messages have Return-Path in phymessage. New
messages
received with dbmail do not have Return-Path in phymessage,
but there
is always a value in dbmail_headervalues for Return-Path.

It would be nice if the Return-Path also got added to
the phymessage too, but though I would point out how dbmail
is currently handling Return-Path since Simon's
problem also looks like duplicate headers.

John
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.4-svn0 (GNU/Linux)
Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org


iD8DBQFHzTIwd4I3jTtt9EIRAsfrAJ9S/zRK0BY6EgCr2lEZbrfakBLVOACe
NHii
yo9wxuopEaGtYF8O7WO9YEA=
=qynZ
-----END PGP SIGNATURE-----
_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

[1-3]

about | contact  Other archives ( Real Estate discussion Medical topics )