Re: sql and other errors

hmm- dbmail should really be able to cleanup itself

the 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]

_______________________________________________
DBmail mailing list
[email protected]
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1

iEYEARECAAYFAlRicdcACgkQhmBjz394AnlWEACgleEVROl8HgC/bsYBjIWZmzt2
d1kAoJ2Q1yhvFtKqoKhS0KsuXQl1c6LQ
=wil/
-----END PGP SIGNATURE-----