besides that the first message at least should contain the messageid to have a change kill the mail without force debug-mode and dig through tables i'm unsure about the others below
dbmail_message_cache_envelope should just strip the data to the maximum length, that are most likely broken messages and we are talking about cache tables ___________________________________________ Jul 17 04:08:13 mail dbmail/maintenance[20931]: Error:[message] dbmail_message_cache_envelope(+1922): SQLException: Data too long for column 'envelope' at row 1 Jul 17 04:08:13 mail dbmail/maintenance[20931]: Error:[message] dbmail_message_cache_envelope(+1924): insert envelope failed [("Fri, 11 Jul 2014 14:25:39 +0000" "=?iso-8859-1?Q?Diplomarbeit_Dominik_B=FCschl,_bitte_um_Ihre ___________________________________________ Jul 5 10:08:08 mail dbmail/lmtpd[2694]: Error:[message] _header_value_get_id(+1618): SQLException: Incorrect string value: '\xF0\x9F\x92\x8B\xE2\x9D...' for column 'headervalue' at row 1 Jul 5 10:08:09 mail dbmail/lmtpd[2694]: Error:[message] _header_value_get_id(+1618): SQLException: Incorrect string value: '\xF0\x9F\x92\x8B\xE2\x9D...' for column 'headervalue' at row 1 Jul 5 14:52:59 mail dbmail/lmtpd[2694]: Error:[message] _header_value_get_id(+1618): SQLException: Incorrect string value: '\xF0\x9F\x98\x8A' for column 'headervalue' at row 1 Jul 5 20:13:13 mail dbmail/lmtpd[2694]: Error:[message] _header_value_get_id(+1618): SQLException: Incorrect string value: '\xF3\xBE\x8C\xA9\xF3\xBE...' for column 'headervalue' at row 1 Jul 5 20:38:58 mail dbmail/lmtpd[2694]: Error:[message] _header_value_get_id(+1618): SQLException: Incorrect string value: '\xF0\x9F\x92\x8B\xE2\x9D...' for column 'headervalue' at row 1 Jul 7 09:37:46 mail dbmail/imap4d[22693]: Error:[message] _header_value_get_id(+1618): SQLException: Incorrect string value: '\xF0\x9F\x98\x8A' for column 'headervalue' at row 1 Jul 7 09:41:33 mail dbmail/imap4d[22693]: Error:[message] _header_value_get_id(+1618): SQLException: Incorrect string value: '\xF0\x9F\x98\x8A' for column 'headervalue' at row 1 Jul 9 08:56:36 mail dbmail/lmtpd[15878]: Error:[message] _header_value_get_id(+1618): SQLException: Incorrect string value: '\xF0\x9F\x98\x82' for column 'headervalue' at row 1 Jul 9 08:56:48 mail dbmail/imap4d[22693]: Error:[message] _header_value_get_id(+1618): SQLException: Incorrect string value: '\xF0\x9F\x98\x82' for column 'headervalue' at row 1 Jul 11 00:05:06 mail dbmail/lmtpd[20408]: Error:[message] _header_value_get_id(+1618): SQLException: Incorrect string value: '\xF0\x9F\x8C\xBF\xF0\x9F...' for column 'headervalue' at row 1 Jul 11 10:15:41 mail dbmail/lmtpd[25469]: Error:[message] _header_value_get_id(+1618): SQLException: Incorrect string value: '\xF0\x9F\x8D\x80\xF0\x9F...' for column 'headervalue' at row 1 Jul 11 10:19:23 mail dbmail/lmtpd[25469]: Error:[message] _header_value_get_id(+1618): SQLException: Incorrect string value: '\xF0\x9F\x8C\xBA\xF0\x9F...' for column 'headervalue' at row 1 Jul 11 10:37:04 mail dbmail/lmtpd[25469]: Error:[message] _header_value_get_id(+1618): SQLException: Incorrect string value: '\xF0\x9F\x8C\xBA\xF0\x9F...' for column 'headervalue' at row 1 Jul 14 15:24:20 mail dbmail/lmtpd[24593]: Error:[message] _header_value_get_id(+1618): SQLException: Incorrect string value: '\xF0\x9F\x8F\x86 W...' for column 'headervalue' at row 1 Jul 18 09:15:27 mail dbmail/lmtpd[20093]: Error:[message] _header_value_get_id(+1618): SQLException: Incorrect string value: '\xF0\x9F\x8C\xBA\xF0\x9F...' for column 'headervalue' at row 1
signature.asc
Description: OpenPGP digital signature
_______________________________________________ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail