Wow, this night is going awefully bad. Now I get constant errors: Sep 18 03:44:53 mail0 postfix/lmtp[4768]: A63ED8502D0: to=, relay=localhost[127.0.0.1]:24, delay=0.48, delays=0.27/0/0/0.2, dsn=4.4.2, status=deferred (lost connection with localhost[127.0.0.1] while sending end of data -- message may be sent more than once) dbmail-lmtpd: misc.c:534: dm_strnesc: Assertion `from' failed. Sep 18 03:45:04 mail0 dbmail-imapd[4800]: Error:[imap] imap4.c,IMAPClientHandler(+139): [Illegal seek] on read-stream
it seems to only happen on messages with bodies(ie. and not just subjects) but not always, i cannot seem to trace this down In a larger context: Sep 18 02:37:47 mail0 dbmail-lmtpd[4425]: Debug:[db] dbmodule.c,db_query(+145): last query took [0] seconds Sep 18 02:37:47 mail0 dbmail-lmtpd[4425]: Debug:[sql] dbpgsql.c,db_query(+279): [INSERT INTO dbmail_headervalue (headername_id, physmessage_id, headervalue) VALUES (5,612611,'')] Sep 18 02:37:47 mail0 dbmail-lmtpd[4425]: Debug:[db] dbmodule.c,db_query(+145): last query took [0] seconds Sep 18 02:37:47 mail0 dbmail-lmtpd[4425]: Debug:[sql] dbpgsql.c,db_query(+279): [SELECT id FROM dbmail_headername WHERE LOWER(headername)='received'] Sep 18 02:37:47 mail0 dbmail-lmtpd[4425]: Debug:[db] dbmodule.c,db_query(+145): last query took [0] seconds Sep 18 02:37:47 mail0 dbmail-lmtpd[4425]: Debug:[sql] dbpgsql.c,db_query(+279): [INSERT INTO dbmail_headervalue (headername_id, physmessage_id, headervalue) VALUES (6,612611,'by 8.boundaryminus.com id htu04m0bbos4 for ; Tue, 18 Sep 2007 01:37:15 -0600 (envelope-from )')] Sep 18 02:37:47 mail0 dbmail-lmtpd[4425]: Debug:[db] dbmodule.c,db_query(+145): last query took [0] seconds Sep 18 02:37:47 mail0 dbmail-lmtpd[4425]: Debug:[sql] dbpgsql.c,db_query(+279): [INSERT INTO dbmail_headervalue (headername_id, physmessage_id, headervalue) VALUES (6,612611,'from 8.boundaryminus.com (unknown [67.207.179.8]) by xxx (Postfix) with ESMTP id 8A1A3850229 for ; Tue, 18 Sep 2007 02:37:47 -0500 (CDT)')] Sep 18 02:37:47 mail0 dbmail-lmtpd[4425]: Debug:[db] dbmodule.c,db_query(+145): last query took [0] seconds Sep 18 02:37:47 mail0 dbmail-lmtpd[4425]: Debug:[sql] dbpgsql.c,db_query(+279): [SELECT id FROM dbmail_headername WHERE LOWER(headername)='subject'] Sep 18 02:37:47 mail0 dbmail-lmtpd[4425]: Debug:[db] dbmodule.c,db_query(+145): last query took [0] seconds Sep 18 02:37:47 mail0 dbmail-lmtpd[4425]: Debug:[sql] dbpgsql.c,db_query(+279): [INSERT INTO dbmail_headervalue (headername_id, physmessage_id, headervalue) VALUES (9,612611,'2007 Government Grant Money Available-Claim Yours')] Sep 18 02:37:47 mail0 dbmail-lmtpd[4425]: Debug:[db] dbmodule.c,db_query(+145): last query took [0] seconds Sep 18 02:37:47 mail0 dbmail-lmtpd[4425]: Debug:[sql] dbpgsql.c,db_query(+279): [SELECT id FROM dbmail_headername WHERE LOWER(headername)='to'] Sep 18 02:37:47 mail0 dbmail-lmtpd[4425]: Debug:[db] dbmodule.c,db_query(+145): last query took [0] seconds Sep 18 02:37:47 mail0 dbmail-lmtpd[4425]: Debug:[sql] dbpgsql.c,db_query(+279): [INSERT INTO dbmail_headervalue (headername_id, physmessage_id, headervalue) VALUES (10,612611,'xxx')] Sep 18 02:37:47 mail0 dbmail-lmtpd[4425]: Debug:[db] dbmodule.c,db_query(+145): last query took [0] seconds dbmail-lmtpd: misc.c:534: dm_strnesc: Assertion `from' failed. Please let me know, any help would be greatly appreciated! -Eric ----------------------------------------> Date: Tue, 18 Sep 2007 08:58:42 +0200> From: [EMAIL PROTECTED]> To: [email protected]> Subject: Re: [Dbmail] dbmail cache corrupt>> Eric Hiller wrote:>> I am having a number of problems after upgrading to newest dbmail off of>> apt (from 2.2.1) alot of physmessages refuse to cache, so i emptied the>> tables: headervalue, headername, envelope, and referencesfield and am>> going to run dbmail-util -by to restore this. If this doesnt work any>> ideas?>>>> Is there a way I can export to mbox and reimport, or is that a bad idea?>> You can, but then you will loose all meta-information on messages, such as> read/unread, replied, flagged, etc.>> Also, that will most likely not solve you problem. Please try to provide level 5> logs if some messages keep hanging up the cache.>>> --> ________________________________________________________________> 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 _________________________________________________________________ Kick back and relax with hot games and cool activities at the Messenger Café. http://www.cafemessenger.com?ocid=TXT_TAGLM_SeptWLtagline_______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
