hmm- dbmail should really be able to cleanup itselfthe errors mentioned in my previous mail leads to never go away until someobody deletes the message displayed without subject - there should be a switch for "dbmail-util" to cleanup and remove that messages without dig through the database
each "E" is one of the currently 4 errors Ok. Found [116] unconnected physmessages. Ok. Orphaned physmessages deleted. Ok. Found [371] unconnected mimeparts. Ok. Orphaned mimeparts deleted. Ok. Orphaned headervalues deleted. Ok. Found [4] missing envelope values. ....Ok. Found [4] un-cached physmessages. EEEE Maintenance done. Errors were found and fixed.We suggest running dbmail-util again to confirm that all errors were repaired.
Ok. Found [4] missing envelope values. ....Ok. Found [4] un-cached physmessages. EEEE Maintenance done. Errors were found and fixed.We suggest running dbmail-util again to confirm that all errors were repaired.
Ok. Found [4] missing envelope values. ....Ok. Found [4] un-cached physmessages. EEEE Maintenance done. Errors were found and fixed.We suggest running dbmail-util again to confirm that all errors were repaired.
Am 08.11.2014 um 22:18 schrieb Reindl Harald:
the "incorrect string value" happens over time randomly and below also
some other errors due "dbmail-util" cleanup (dbmail 3.1.17)
Nov 8 21:54:59 mail dbmail/maintenance[11260]: Error:[message]
dbmail_message_cache_envelope(+1844): SQLException: Incorrect string
value: '\xFDrgio"...' for column 'envelope' at row 1
Nov 8 21:54:59 mail dbmail/maintenance[11260]: Error:[message]
dbmail_message_cache_envelope(+1846): insert envelope failed [("Tue, 04
Nov 2014 10:50:40 +0000" "Re: AnubisNetworks IP Reputation Service
(mailspike.org)" (
Nov 8 21:54:59 mail dbmail/maintenance[11260]: Error:[message]
dbmail_message_cache_envelope(+1844): SQLException: Column 'envelope'
cannot be null
Nov 8 21:54:59 mail dbmail/maintenance[11260]: Error:[message]
dbmail_message_cache_envelope(+1846): insert envelope failed [(null)]
Nov 8 21:54:59 mail dbmail/maintenance[11260]: Error:[message]
dbmail_message_cache_envelope(+1844): SQLException: Column 'envelope'
cannot be null
Nov 8 21:54:59 mail dbmail/maintenance[11260]: Error:[message]
dbmail_message_cache_envelope(+1846): insert envelope failed [(null)]
Nov 8 21:54:59 mail dbmail/maintenance[11260]: Error:[message]
dbmail_message_cache_envelope(+1844): SQLException: Column 'envelope'
cannot be null
Nov 8 21:54:59 mail dbmail/maintenance[11260]: Error:[message]
dbmail_message_cache_envelope(+1846): insert envelope failed [(null)]
Nov 8 21:54:59 mail dbmail/maintenance[11260]: Error:[message]
dbmail_message_cache_envelope(+1844): SQLException: Column 'envelope'
cannot be null
Nov 8 21:54:59 mail dbmail/maintenance[11260]: Error:[message]
dbmail_message_cache_envelope(+1846): insert envelope failed [(null)]
Nov 8 21:54:59 mail dbmail/maintenance[11260]: Error:[message]
dbmail_message_cache_headers(+1324): self->content is not a message
Nov 8 21:54:59 mail dbmail/maintenance[11260]: Warning:[db]
db_set_headercache(+1617): error caching headers for physmessage: [4604600]
Nov 8 21:54:59 mail dbmail/maintenance[11260]: Error:[message]
dbmail_message_cache_headers(+1324): self->content is not a message
Nov 8 21:54:59 mail dbmail/maintenance[11260]: Warning:[db]
db_set_headercache(+1617): error caching headers for physmessage: [4604599]
Nov 8 21:54:59 mail dbmail/maintenance[11260]: Error:[message]
dbmail_message_cache_headers(+1324): self->content is not a message
Nov 8 21:54:59 mail dbmail/maintenance[11260]: Warning:[db]
db_set_headercache(+1617): error caching headers for physmessage: [4604598]
Nov 8 21:54:59 mail dbmail/maintenance[11260]: Error:[message]
dbmail_message_cache_headers(+1324): self->content is not a message
Nov 8 21:54:59 mail dbmail/maintenance[11260]: Warning:[db]
db_set_headercache(+1617): error caching headers for physmessage: [4604597]
signature.asc
Description: OpenPGP digital signature
_______________________________________________ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
