Advanced
Mailing List Archive

Mailing List Archive

  1. Home >
  2. DBMail>
  3. users
sql and other errors
h.reindl at thelounge
Nov 8, 2014, 1:18 PM
Post #1 of 2 (925 views)
Permalink
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]

Attached Files:

Re: sql and other errors [ In reply to ]
h.reindl at thelounge
Nov 11, 2014, 12:30 PM
Post #2 of 2 (896 views)
Permalink
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]

Attached Files:

©2024 GT.net. A Gossamer Threads company.
5th Floor, 455 Granville St., Vancouver, BC V6C 1T1, Canada | Legal