Mailing List Archive

SQLException: Column 'envelope' cannot be null / self->content is not a message
dbmail-3.1.17 with latest fixes

what's that for new stuff below flooding our server?
looks like some crazy client is trying to save drafts or something like
that, however, the result is that the number of this errors grows day
for day with each dbmail-util run
___________________________________________________________

Mar 10 16:28:13 caladan dbmail/maintenance[14421]: Error:[message]
dbmail_message_cache_envelope(+1844): SQLException: Column 'envelope'
cannot be null
Mar 10 16:28:13 caladan dbmail/maintenance[14421]: Error:[message]
dbmail_message_cache_envelope(+1846): insert envelope failed [(null)]
Mar 10 16:28:13 caladan dbmail/maintenance[14421]: Error:[message]
dbmail_message_cache_envelope(+1844): SQLException: Column 'envelope'
cannot be null
Mar 10 16:28:13 caladan dbmail/maintenance[14421]: Error:[message]
dbmail_message_cache_envelope(+1846): insert envelope failed [(null)]
Mar 10 16:28:13 caladan dbmail/maintenance[14421]: Error:[message]
dbmail_message_cache_headers(+1324): self->content is not a message
Mar 10 16:28:13 caladan dbmail/maintenance[14421]: Warning:[db]
db_set_headercache(+1617): error caching headers for physmessage: [853193]
Mar 10 16:28:13 caladan dbmail/maintenance[14421]: Error:[message]
dbmail_message_cache_headers(+1324): self->content is not a message
Mar 10 16:28:13 caladan dbmail/maintenance[14421]: Warning:[db]
db_set_headercache(+1617): error caching headers for physmessage: [853192]
Mar 10 16:28:14 caladan dbmail/maintenance[14423]: Error:[message]
dbmail_message_cache_envelope(+1844): SQLException: Column 'envelope'
cannot be null
Mar 10 16:28:14 caladan dbmail/maintenance[14423]: Error:[message]
dbmail_message_cache_envelope(+1846): insert envelope failed [(null)]
Mar 10 16:28:14 caladan dbmail/maintenance[14423]: Error:[message]
dbmail_message_cache_envelope(+1844): SQLException: Column 'envelope'
cannot be null
Mar 10 16:28:14 caladan dbmail/maintenance[14423]: Error:[message]
dbmail_message_cache_envelope(+1846): insert envelope failed [(null)]
Mar 10 16:28:14 caladan dbmail/maintenance[14423]: Error:[message]
dbmail_message_cache_headers(+1324): self->content is not a message
Mar 10 16:28:14 caladan dbmail/maintenance[14423]: Warning:[db]
db_set_headercache(+1617): error caching headers for physmessage: [853193]
Mar 10 16:28:14 caladan dbmail/maintenance[14423]: Error:[message]
dbmail_message_cache_headers(+1324): self->content is not a message
Mar 10 16:28:14 caladan dbmail/maintenance[14423]: Warning:[db]
db_set_headercache(+1617): error caching headers for physmessage: [853192]
Mar 10 16:28:14 caladan dbmail/maintenance[14425]: Error:[message]
dbmail_message_cache_envelope(+1844): SQLException: Column 'envelope'
cannot be null
Mar 10 16:28:14 caladan dbmail/maintenance[14425]: Error:[message]
dbmail_message_cache_envelope(+1846): insert envelope failed [(null)]
Mar 10 16:28:14 caladan dbmail/maintenance[14425]: Error:[message]
dbmail_message_cache_envelope(+1844): SQLException: Column 'envelope'
cannot be null
Mar 10 16:28:14 caladan dbmail/maintenance[14425]: Error:[message]
dbmail_message_cache_envelope(+1846): insert envelope failed [(null)]
Mar 10 16:28:14 caladan dbmail/maintenance[14425]: Error:[message]
dbmail_message_cache_headers(+1324): self->content is not a message
Mar 10 16:28:14 caladan dbmail/maintenance[14425]: Warning:[db]
db_set_headercache(+1617): error caching headers for physmessage: [853193]
Mar 10 16:28:14 caladan dbmail/maintenance[14425]: Error:[message]
dbmail_message_cache_headers(+1324): self->content is not a message
Mar 10 16:28:14 caladan dbmail/maintenance[14425]: Warning:[db]
db_set_headercache(+1617): error caching headers for physmessage: [853192]
___________________________________________________________

Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[message]
dbmail_message_cache_headers(+1324): self->content is not a message
Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[message]
dbmail_message_cache_headers(+1324): self->content is not a message
Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[message]
dbmail_message_cache_headers(+1324): self->content is not a message
Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[message]
dbmail_message_cache_headers(+1324): self->content is not a message
Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[message]
dbmail_message_cache_headers(+1324): self->content is not a message
Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[message]
dbmail_message_cache_headers(+1324): self->content is not a message
Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[message]
dbmail_message_cache_headers(+1324): self->content is not a message
Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[message]
dbmail_message_cache_headers(+1324): self->content is not a message
Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[message]
dbmail_message_cache_headers(+1324): self->content is not a message
Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[imap]
_ic_append_enter(+1316): [0x55dce60f65b0] error appending msg
Re: SQLException: Column 'envelope' cannot be null / self->content is not a message [ In reply to ]
in fact all this "messages" are in mailbox_idnr 2 / owner_idnr 1 which
is "__@!internal_delivery_user!@__" and so *why* is that not cleaned up
when whatever client operation fails?

looks like a partial delivery

Am 10.03.2016 um 16:33 schrieb Reindl Harald:
> dbmail-3.1.17 with latest fixes
>
> what's that for new stuff below flooding our server?
> looks like some crazy client is trying to save drafts or something like
> that, however, the result is that the number of this errors grows day
> for day with each dbmail-util run
> ___________________________________________________________
>
> Mar 10 16:28:13 caladan dbmail/maintenance[14421]: Error:[message]
> dbmail_message_cache_envelope(+1844): SQLException: Column 'envelope'
> cannot be null
> Mar 10 16:28:13 caladan dbmail/maintenance[14421]: Error:[message]
> dbmail_message_cache_envelope(+1846): insert envelope failed [(null)]
> Mar 10 16:28:13 caladan dbmail/maintenance[14421]: Error:[message]
> dbmail_message_cache_envelope(+1844): SQLException: Column 'envelope'
> cannot be null
> Mar 10 16:28:13 caladan dbmail/maintenance[14421]: Error:[message]
> dbmail_message_cache_envelope(+1846): insert envelope failed [(null)]
> Mar 10 16:28:13 caladan dbmail/maintenance[14421]: Error:[message]
> dbmail_message_cache_headers(+1324): self->content is not a message
> Mar 10 16:28:13 caladan dbmail/maintenance[14421]: Warning:[db]
> db_set_headercache(+1617): error caching headers for physmessage: [853193]
> Mar 10 16:28:13 caladan dbmail/maintenance[14421]: Error:[message]
> dbmail_message_cache_headers(+1324): self->content is not a message
> Mar 10 16:28:13 caladan dbmail/maintenance[14421]: Warning:[db]
> db_set_headercache(+1617): error caching headers for physmessage: [853192]
> Mar 10 16:28:14 caladan dbmail/maintenance[14423]: Error:[message]
> dbmail_message_cache_envelope(+1844): SQLException: Column 'envelope'
> cannot be null
> Mar 10 16:28:14 caladan dbmail/maintenance[14423]: Error:[message]
> dbmail_message_cache_envelope(+1846): insert envelope failed [(null)]
> Mar 10 16:28:14 caladan dbmail/maintenance[14423]: Error:[message]
> dbmail_message_cache_envelope(+1844): SQLException: Column 'envelope'
> cannot be null
> Mar 10 16:28:14 caladan dbmail/maintenance[14423]: Error:[message]
> dbmail_message_cache_envelope(+1846): insert envelope failed [(null)]
> Mar 10 16:28:14 caladan dbmail/maintenance[14423]: Error:[message]
> dbmail_message_cache_headers(+1324): self->content is not a message
> Mar 10 16:28:14 caladan dbmail/maintenance[14423]: Warning:[db]
> db_set_headercache(+1617): error caching headers for physmessage: [853193]
> Mar 10 16:28:14 caladan dbmail/maintenance[14423]: Error:[message]
> dbmail_message_cache_headers(+1324): self->content is not a message
> Mar 10 16:28:14 caladan dbmail/maintenance[14423]: Warning:[db]
> db_set_headercache(+1617): error caching headers for physmessage: [853192]
> Mar 10 16:28:14 caladan dbmail/maintenance[14425]: Error:[message]
> dbmail_message_cache_envelope(+1844): SQLException: Column 'envelope'
> cannot be null
> Mar 10 16:28:14 caladan dbmail/maintenance[14425]: Error:[message]
> dbmail_message_cache_envelope(+1846): insert envelope failed [(null)]
> Mar 10 16:28:14 caladan dbmail/maintenance[14425]: Error:[message]
> dbmail_message_cache_envelope(+1844): SQLException: Column 'envelope'
> cannot be null
> Mar 10 16:28:14 caladan dbmail/maintenance[14425]: Error:[message]
> dbmail_message_cache_envelope(+1846): insert envelope failed [(null)]
> Mar 10 16:28:14 caladan dbmail/maintenance[14425]: Error:[message]
> dbmail_message_cache_headers(+1324): self->content is not a message
> Mar 10 16:28:14 caladan dbmail/maintenance[14425]: Warning:[db]
> db_set_headercache(+1617): error caching headers for physmessage: [853193]
> Mar 10 16:28:14 caladan dbmail/maintenance[14425]: Error:[message]
> dbmail_message_cache_headers(+1324): self->content is not a message
> Mar 10 16:28:14 caladan dbmail/maintenance[14425]: Warning:[db]
> db_set_headercache(+1617): error caching headers for physmessage: [853192]
> ___________________________________________________________
>
> Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[message]
> dbmail_message_cache_headers(+1324): self->content is not a message
> Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[message]
> dbmail_message_cache_headers(+1324): self->content is not a message
> Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[message]
> dbmail_message_cache_headers(+1324): self->content is not a message
> Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[message]
> dbmail_message_cache_headers(+1324): self->content is not a message
> Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[message]
> dbmail_message_cache_headers(+1324): self->content is not a message
> Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[message]
> dbmail_message_cache_headers(+1324): self->content is not a message
> Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[message]
> dbmail_message_cache_headers(+1324): self->content is not a message
> Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[message]
> dbmail_message_cache_headers(+1324): self->content is not a message
> Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[message]
> dbmail_message_cache_headers(+1324): self->content is not a message
> Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[imap]
> _ic_append_enter(+1316): [0x55dce60f65b0] error appending msg
Re: SQLException: Column 'envelope' cannot be null / self->content is not a message [ In reply to ]
that's not funny, grwing and not redueable without handmade scripts
thowing away anything owned by user_idnr 2 which should be the job of
dbmail-util (and is prone for race-conditions that way) as last ressort
(normally it should be cleaned automatically)

Found [890] un-cached physmessages.
EEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEE
Maintenance done. Errors were found and fixed.
We suggest running dbmail-util again to confirm that all errors were
repaired.
Ok. Found [890] missing envelope values.

Am 10.03.2016 um 16:37 schrieb Reindl Harald:
> in fact all this "messages" are in mailbox_idnr 2 / owner_idnr 1 which
> is "__@!internal_delivery_user!@__" and so *why* is that not cleaned up
> when whatever client operation fails?
>
> looks like a partial delivery
>
> Am 10.03.2016 um 16:33 schrieb Reindl Harald:
>> dbmail-3.1.17 with latest fixes
>>
>> what's that for new stuff below flooding our server?
>> looks like some crazy client is trying to save drafts or something like
>> that, however, the result is that the number of this errors grows day
>> for day with each dbmail-util run
>> ___________________________________________________________
>>
>> Mar 10 16:28:13 caladan dbmail/maintenance[14421]: Error:[message]
>> dbmail_message_cache_envelope(+1844): SQLException: Column 'envelope'
>> cannot be null
>> Mar 10 16:28:13 caladan dbmail/maintenance[14421]: Error:[message]
>> dbmail_message_cache_envelope(+1846): insert envelope failed [(null)]
>> Mar 10 16:28:13 caladan dbmail/maintenance[14421]: Error:[message]
>> dbmail_message_cache_envelope(+1844): SQLException: Column 'envelope'
>> cannot be null
>> Mar 10 16:28:13 caladan dbmail/maintenance[14421]: Error:[message]
>> dbmail_message_cache_envelope(+1846): insert envelope failed [(null)]
>> Mar 10 16:28:13 caladan dbmail/maintenance[14421]: Error:[message]
>> dbmail_message_cache_headers(+1324): self->content is not a message
>> Mar 10 16:28:13 caladan dbmail/maintenance[14421]: Warning:[db]
>> db_set_headercache(+1617): error caching headers for physmessage:
>> [853193]
>> Mar 10 16:28:13 caladan dbmail/maintenance[14421]: Error:[message]
>> dbmail_message_cache_headers(+1324): self->content is not a message
>> Mar 10 16:28:13 caladan dbmail/maintenance[14421]: Warning:[db]
>> db_set_headercache(+1617): error caching headers for physmessage:
>> [853192]
>> Mar 10 16:28:14 caladan dbmail/maintenance[14423]: Error:[message]
>> dbmail_message_cache_envelope(+1844): SQLException: Column 'envelope'
>> cannot be null
>> Mar 10 16:28:14 caladan dbmail/maintenance[14423]: Error:[message]
>> dbmail_message_cache_envelope(+1846): insert envelope failed [(null)]
>> Mar 10 16:28:14 caladan dbmail/maintenance[14423]: Error:[message]
>> dbmail_message_cache_envelope(+1844): SQLException: Column 'envelope'
>> cannot be null
>> Mar 10 16:28:14 caladan dbmail/maintenance[14423]: Error:[message]
>> dbmail_message_cache_envelope(+1846): insert envelope failed [(null)]
>> Mar 10 16:28:14 caladan dbmail/maintenance[14423]: Error:[message]
>> dbmail_message_cache_headers(+1324): self->content is not a message
>> Mar 10 16:28:14 caladan dbmail/maintenance[14423]: Warning:[db]
>> db_set_headercache(+1617): error caching headers for physmessage:
>> [853193]
>> Mar 10 16:28:14 caladan dbmail/maintenance[14423]: Error:[message]
>> dbmail_message_cache_headers(+1324): self->content is not a message
>> Mar 10 16:28:14 caladan dbmail/maintenance[14423]: Warning:[db]
>> db_set_headercache(+1617): error caching headers for physmessage:
>> [853192]
>> Mar 10 16:28:14 caladan dbmail/maintenance[14425]: Error:[message]
>> dbmail_message_cache_envelope(+1844): SQLException: Column 'envelope'
>> cannot be null
>> Mar 10 16:28:14 caladan dbmail/maintenance[14425]: Error:[message]
>> dbmail_message_cache_envelope(+1846): insert envelope failed [(null)]
>> Mar 10 16:28:14 caladan dbmail/maintenance[14425]: Error:[message]
>> dbmail_message_cache_envelope(+1844): SQLException: Column 'envelope'
>> cannot be null
>> Mar 10 16:28:14 caladan dbmail/maintenance[14425]: Error:[message]
>> dbmail_message_cache_envelope(+1846): insert envelope failed [(null)]
>> Mar 10 16:28:14 caladan dbmail/maintenance[14425]: Error:[message]
>> dbmail_message_cache_headers(+1324): self->content is not a message
>> Mar 10 16:28:14 caladan dbmail/maintenance[14425]: Warning:[db]
>> db_set_headercache(+1617): error caching headers for physmessage:
>> [853193]
>> Mar 10 16:28:14 caladan dbmail/maintenance[14425]: Error:[message]
>> dbmail_message_cache_headers(+1324): self->content is not a message
>> Mar 10 16:28:14 caladan dbmail/maintenance[14425]: Warning:[db]
>> db_set_headercache(+1617): error caching headers for physmessage:
>> [853192]
>> ___________________________________________________________
>>
>> Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[message]
>> dbmail_message_cache_headers(+1324): self->content is not a message
>> Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[message]
>> dbmail_message_cache_headers(+1324): self->content is not a message
>> Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[message]
>> dbmail_message_cache_headers(+1324): self->content is not a message
>> Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[message]
>> dbmail_message_cache_headers(+1324): self->content is not a message
>> Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[message]
>> dbmail_message_cache_headers(+1324): self->content is not a message
>> Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[message]
>> dbmail_message_cache_headers(+1324): self->content is not a message
>> Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[message]
>> dbmail_message_cache_headers(+1324): self->content is not a message
>> Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[message]
>> dbmail_message_cache_headers(+1324): self->content is not a message
>> Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[message]
>> dbmail_message_cache_headers(+1324): self->content is not a message
>> Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[imap]
>> _ic_append_enter(+1316): [0x55dce60f65b0] error appending msg
Re: SQLException: Column 'envelope' cannot be null / self->content is not a message [ In reply to ]
can dbmail at least get a patch to mention the *user* which triggers
that bug?

Mar 20 15:13:39 caladan dbmail/imap4d[1194]: Error:[message]
dbmail_message_cache_headers(+1324): self->content is not a message
Mar 20 15:13:39 caladan dbmail/imap4d[1194]: Error:[message]
dbmail_message_cache_headers(+1324): self->content is not a message
Mar 20 15:13:39 caladan dbmail/imap4d[1194]: Error:[message]
dbmail_message_cache_headers(+1324): self->content is not a message
Mar 20 15:13:39 caladan dbmail/imap4d[1194]: Error:[message]
dbmail_message_cache_headers(+1324): self->content is not a message
Mar 20 15:13:39 caladan dbmail/imap4d[1194]: Error:[message]
dbmail_message_cache_headers(+1324): self->content is not a message
Mar 20 15:13:39 caladan dbmail/imap4d[1194]: Error:[message]
dbmail_message_cache_headers(+1324): self->content is not a message
Mar 20 15:13:39 caladan dbmail/imap4d[1194]: Error:[message]
dbmail_message_cache_headers(+1324): self->content is not a message
Mar 20 15:13:39 caladan dbmail/imap4d[1194]: Error:[message]
dbmail_message_cache_headers(+1324): self->content is not a message
Mar 20 15:13:39 caladan dbmail/imap4d[1194]: Error:[message]
dbmail_message_cache_headers(+1324): self->content is not a message
Mar 20 15:13:39 caladan dbmail/imap4d[1194]: Error:[imap]
_ic_append_enter(+1316): [0x55cd52bfaf70] error appending msg

Am 15.03.2016 um 01:41 schrieb Reindl Harald:
> that's not funny, grwing and not redueable without handmade scripts
> thowing away anything owned by user_idnr 2 which should be the job of
> dbmail-util (and is prone for race-conditions that way) as last ressort
> (normally it should be cleaned automatically)
>
> Found [890] un-cached physmessages.
> EEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEE
>
> Maintenance done. Errors were found and fixed.
> We suggest running dbmail-util again to confirm that all errors were
> repaired.
> Ok. Found [890] missing envelope values.
>
> Am 10.03.2016 um 16:37 schrieb Reindl Harald:
>> in fact all this "messages" are in mailbox_idnr 2 / owner_idnr 1 which
>> is "__@!internal_delivery_user!@__" and so *why* is that not cleaned up
>> when whatever client operation fails?
>>
>> looks like a partial delivery
>>
>> Am 10.03.2016 um 16:33 schrieb Reindl Harald:
>>> dbmail-3.1.17 with latest fixes
>>>
>>> what's that for new stuff below flooding our server?
>>> looks like some crazy client is trying to save drafts or something like
>>> that, however, the result is that the number of this errors grows day
>>> for day with each dbmail-util run
>>> ___________________________________________________________
>>>
>>> Mar 10 16:28:13 caladan dbmail/maintenance[14421]: Error:[message]
>>> dbmail_message_cache_envelope(+1844): SQLException: Column 'envelope'
>>> cannot be null
>>> Mar 10 16:28:13 caladan dbmail/maintenance[14421]: Error:[message]
>>> dbmail_message_cache_envelope(+1846): insert envelope failed [(null)]
>>> Mar 10 16:28:13 caladan dbmail/maintenance[14421]: Error:[message]
>>> dbmail_message_cache_envelope(+1844): SQLException: Column 'envelope'
>>> cannot be null
>>> Mar 10 16:28:13 caladan dbmail/maintenance[14421]: Error:[message]
>>> dbmail_message_cache_envelope(+1846): insert envelope failed [(null)]
>>> Mar 10 16:28:13 caladan dbmail/maintenance[14421]: Error:[message]
>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>> Mar 10 16:28:13 caladan dbmail/maintenance[14421]: Warning:[db]
>>> db_set_headercache(+1617): error caching headers for physmessage:
>>> [853193]
>>> Mar 10 16:28:13 caladan dbmail/maintenance[14421]: Error:[message]
>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>> Mar 10 16:28:13 caladan dbmail/maintenance[14421]: Warning:[db]
>>> db_set_headercache(+1617): error caching headers for physmessage:
>>> [853192]
>>> Mar 10 16:28:14 caladan dbmail/maintenance[14423]: Error:[message]
>>> dbmail_message_cache_envelope(+1844): SQLException: Column 'envelope'
>>> cannot be null
>>> Mar 10 16:28:14 caladan dbmail/maintenance[14423]: Error:[message]
>>> dbmail_message_cache_envelope(+1846): insert envelope failed [(null)]
>>> Mar 10 16:28:14 caladan dbmail/maintenance[14423]: Error:[message]
>>> dbmail_message_cache_envelope(+1844): SQLException: Column 'envelope'
>>> cannot be null
>>> Mar 10 16:28:14 caladan dbmail/maintenance[14423]: Error:[message]
>>> dbmail_message_cache_envelope(+1846): insert envelope failed [(null)]
>>> Mar 10 16:28:14 caladan dbmail/maintenance[14423]: Error:[message]
>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>> Mar 10 16:28:14 caladan dbmail/maintenance[14423]: Warning:[db]
>>> db_set_headercache(+1617): error caching headers for physmessage:
>>> [853193]
>>> Mar 10 16:28:14 caladan dbmail/maintenance[14423]: Error:[message]
>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>> Mar 10 16:28:14 caladan dbmail/maintenance[14423]: Warning:[db]
>>> db_set_headercache(+1617): error caching headers for physmessage:
>>> [853192]
>>> Mar 10 16:28:14 caladan dbmail/maintenance[14425]: Error:[message]
>>> dbmail_message_cache_envelope(+1844): SQLException: Column 'envelope'
>>> cannot be null
>>> Mar 10 16:28:14 caladan dbmail/maintenance[14425]: Error:[message]
>>> dbmail_message_cache_envelope(+1846): insert envelope failed [(null)]
>>> Mar 10 16:28:14 caladan dbmail/maintenance[14425]: Error:[message]
>>> dbmail_message_cache_envelope(+1844): SQLException: Column 'envelope'
>>> cannot be null
>>> Mar 10 16:28:14 caladan dbmail/maintenance[14425]: Error:[message]
>>> dbmail_message_cache_envelope(+1846): insert envelope failed [(null)]
>>> Mar 10 16:28:14 caladan dbmail/maintenance[14425]: Error:[message]
>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>> Mar 10 16:28:14 caladan dbmail/maintenance[14425]: Warning:[db]
>>> db_set_headercache(+1617): error caching headers for physmessage:
>>> [853193]
>>> Mar 10 16:28:14 caladan dbmail/maintenance[14425]: Error:[message]
>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>> Mar 10 16:28:14 caladan dbmail/maintenance[14425]: Warning:[db]
>>> db_set_headercache(+1617): error caching headers for physmessage:
>>> [853192]
>>> ___________________________________________________________
>>>
>>> Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[message]
>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>> Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[message]
>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>> Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[message]
>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>> Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[message]
>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>> Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[message]
>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>> Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[message]
>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>> Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[message]
>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>> Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[message]
>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>> Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[message]
>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>> Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[imap]
>>> _ic_append_enter(+1316): [0x55dce60f65b0] error appending msg
Re: SQLException: Column 'envelope' cannot be null / self->content is not a message [ In reply to ]
Hi Harald,

I didn't see your issue earlier, sorry for that. Don't you post @
github issues ?

Did this never happened before and can how high is your logging at the moment ?

Cheers,

Matt

2016-03-20 15:17 GMT+01:00 Reindl Harald <h.reindl@thelounge.net>:
> can dbmail at least get a patch to mention the *user* which triggers that
> bug?
>
> Mar 20 15:13:39 caladan dbmail/imap4d[1194]: Error:[message]
> dbmail_message_cache_headers(+1324): self->content is not a message
> Mar 20 15:13:39 caladan dbmail/imap4d[1194]: Error:[message]
> dbmail_message_cache_headers(+1324): self->content is not a message
> Mar 20 15:13:39 caladan dbmail/imap4d[1194]: Error:[message]
> dbmail_message_cache_headers(+1324): self->content is not a message
> Mar 20 15:13:39 caladan dbmail/imap4d[1194]: Error:[message]
> dbmail_message_cache_headers(+1324): self->content is not a message
> Mar 20 15:13:39 caladan dbmail/imap4d[1194]: Error:[message]
> dbmail_message_cache_headers(+1324): self->content is not a message
> Mar 20 15:13:39 caladan dbmail/imap4d[1194]: Error:[message]
> dbmail_message_cache_headers(+1324): self->content is not a message
> Mar 20 15:13:39 caladan dbmail/imap4d[1194]: Error:[message]
> dbmail_message_cache_headers(+1324): self->content is not a message
> Mar 20 15:13:39 caladan dbmail/imap4d[1194]: Error:[message]
> dbmail_message_cache_headers(+1324): self->content is not a message
> Mar 20 15:13:39 caladan dbmail/imap4d[1194]: Error:[message]
> dbmail_message_cache_headers(+1324): self->content is not a message
> Mar 20 15:13:39 caladan dbmail/imap4d[1194]: Error:[imap]
> _ic_append_enter(+1316): [0x55cd52bfaf70] error appending msg
>
>
> Am 15.03.2016 um 01:41 schrieb Reindl Harald:
>>
>> that's not funny, grwing and not redueable without handmade scripts
>> thowing away anything owned by user_idnr 2 which should be the job of
>> dbmail-util (and is prone for race-conditions that way) as last ressort
>> (normally it should be cleaned automatically)
>>
>> Found [890] un-cached physmessages.
>>
>> EEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEE
>>
>> Maintenance done. Errors were found and fixed.
>> We suggest running dbmail-util again to confirm that all errors were
>> repaired.
>> Ok. Found [890] missing envelope values.
>>
>> Am 10.03.2016 um 16:37 schrieb Reindl Harald:
>>>
>>> in fact all this "messages" are in mailbox_idnr 2 / owner_idnr 1 which
>>> is "__@!internal_delivery_user!@__" and so *why* is that not cleaned up
>>> when whatever client operation fails?
>>>
>>> looks like a partial delivery
>>>
>>> Am 10.03.2016 um 16:33 schrieb Reindl Harald:
>>>>
>>>> dbmail-3.1.17 with latest fixes
>>>>
>>>> what's that for new stuff below flooding our server?
>>>> looks like some crazy client is trying to save drafts or something like
>>>> that, however, the result is that the number of this errors grows day
>>>> for day with each dbmail-util run
>>>> ___________________________________________________________
>>>>
>>>> Mar 10 16:28:13 caladan dbmail/maintenance[14421]: Error:[message]
>>>> dbmail_message_cache_envelope(+1844): SQLException: Column 'envelope'
>>>> cannot be null
>>>> Mar 10 16:28:13 caladan dbmail/maintenance[14421]: Error:[message]
>>>> dbmail_message_cache_envelope(+1846): insert envelope failed [(null)]
>>>> Mar 10 16:28:13 caladan dbmail/maintenance[14421]: Error:[message]
>>>> dbmail_message_cache_envelope(+1844): SQLException: Column 'envelope'
>>>> cannot be null
>>>> Mar 10 16:28:13 caladan dbmail/maintenance[14421]: Error:[message]
>>>> dbmail_message_cache_envelope(+1846): insert envelope failed [(null)]
>>>> Mar 10 16:28:13 caladan dbmail/maintenance[14421]: Error:[message]
>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>> Mar 10 16:28:13 caladan dbmail/maintenance[14421]: Warning:[db]
>>>> db_set_headercache(+1617): error caching headers for physmessage:
>>>> [853193]
>>>> Mar 10 16:28:13 caladan dbmail/maintenance[14421]: Error:[message]
>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>> Mar 10 16:28:13 caladan dbmail/maintenance[14421]: Warning:[db]
>>>> db_set_headercache(+1617): error caching headers for physmessage:
>>>> [853192]
>>>> Mar 10 16:28:14 caladan dbmail/maintenance[14423]: Error:[message]
>>>> dbmail_message_cache_envelope(+1844): SQLException: Column 'envelope'
>>>> cannot be null
>>>> Mar 10 16:28:14 caladan dbmail/maintenance[14423]: Error:[message]
>>>> dbmail_message_cache_envelope(+1846): insert envelope failed [(null)]
>>>> Mar 10 16:28:14 caladan dbmail/maintenance[14423]: Error:[message]
>>>> dbmail_message_cache_envelope(+1844): SQLException: Column 'envelope'
>>>> cannot be null
>>>> Mar 10 16:28:14 caladan dbmail/maintenance[14423]: Error:[message]
>>>> dbmail_message_cache_envelope(+1846): insert envelope failed [(null)]
>>>> Mar 10 16:28:14 caladan dbmail/maintenance[14423]: Error:[message]
>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>> Mar 10 16:28:14 caladan dbmail/maintenance[14423]: Warning:[db]
>>>> db_set_headercache(+1617): error caching headers for physmessage:
>>>> [853193]
>>>> Mar 10 16:28:14 caladan dbmail/maintenance[14423]: Error:[message]
>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>> Mar 10 16:28:14 caladan dbmail/maintenance[14423]: Warning:[db]
>>>> db_set_headercache(+1617): error caching headers for physmessage:
>>>> [853192]
>>>> Mar 10 16:28:14 caladan dbmail/maintenance[14425]: Error:[message]
>>>> dbmail_message_cache_envelope(+1844): SQLException: Column 'envelope'
>>>> cannot be null
>>>> Mar 10 16:28:14 caladan dbmail/maintenance[14425]: Error:[message]
>>>> dbmail_message_cache_envelope(+1846): insert envelope failed [(null)]
>>>> Mar 10 16:28:14 caladan dbmail/maintenance[14425]: Error:[message]
>>>> dbmail_message_cache_envelope(+1844): SQLException: Column 'envelope'
>>>> cannot be null
>>>> Mar 10 16:28:14 caladan dbmail/maintenance[14425]: Error:[message]
>>>> dbmail_message_cache_envelope(+1846): insert envelope failed [(null)]
>>>> Mar 10 16:28:14 caladan dbmail/maintenance[14425]: Error:[message]
>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>> Mar 10 16:28:14 caladan dbmail/maintenance[14425]: Warning:[db]
>>>> db_set_headercache(+1617): error caching headers for physmessage:
>>>> [853193]
>>>> Mar 10 16:28:14 caladan dbmail/maintenance[14425]: Error:[message]
>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>> Mar 10 16:28:14 caladan dbmail/maintenance[14425]: Warning:[db]
>>>> db_set_headercache(+1617): error caching headers for physmessage:
>>>> [853192]
>>>> ___________________________________________________________
>>>>
>>>> Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[message]
>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>> Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[message]
>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>> Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[message]
>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>> Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[message]
>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>> Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[message]
>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>> Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[message]
>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>> Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[message]
>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>> Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[message]
>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>> Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[message]
>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>> Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[imap]
>>>> _ic_append_enter(+1316): [0x55dce60f65b0] error appending msg
>
>
>
> _______________________________________________
> DBmail mailing list
> DBmail@dbmail.org
> http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
>
_______________________________________________
DBmail mailing list
DBmail@dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: SQLException: Column 'envelope' cannot be null / self->content is not a message [ In reply to ]
Am 20.03.2016 um 19:11 schrieb Matt.:
> Hi Harald,
>
> I didn't see your issue earlier, sorry for that. Don't you post @
> github issues ?

no - sorry, i hate github

> Did this never happened before and can how high is your logging at the moment ?

not that often as now
dbmail-3.1.17-3.fc23.20160319.rh.2874f497fb429ed139e94342ca1c84325b20b3f1.x86_64

syslog_logging_levels = 31

in other words - dbmail logging is nearly disabled since there is a
dovecot proxy in front


Mar 20 18:27:46 caladan dbmail/imap4d[1194]: Error:[message]
dbmail_message_cache_headers(+1324): self->content is not a message
Mar 20 18:27:46 caladan dbmail/imap4d[1194]: Error:[message]
dbmail_message_cache_headers(+1324): self->content is not a message
Mar 20 18:27:46 caladan dbmail/imap4d[1194]: Error:[message]
dbmail_message_cache_headers(+1324): self->content is not a message
Mar 20 18:27:46 caladan dbmail/imap4d[1194]: Error:[message]
dbmail_message_cache_headers(+1324): self->content is not a message
Mar 20 18:27:46 caladan dbmail/imap4d[1194]: Error:[message]
dbmail_message_cache_headers(+1324): self->content is not a message
Mar 20 18:27:46 caladan dbmail/imap4d[1194]: Error:[message]
dbmail_message_cache_headers(+1324): self->content is not a message
Mar 20 18:27:46 caladan dbmail/imap4d[1194]: Error:[message]
dbmail_message_cache_headers(+1324): self->content is not a message
Mar 20 18:27:46 caladan dbmail/imap4d[1194]: Error:[message]
dbmail_message_cache_headers(+1324): self->content is not a message
Mar 20 18:27:46 caladan dbmail/imap4d[1194]: Error:[message]
dbmail_message_cache_headers(+1324): self->content is not a message
Mar 20 18:27:46 caladan dbmail/imap4d[1194]: Error:[imap]
_ic_append_enter(+1316): [0x55cd52aa79a0] error appending msg
_________________________

one problem is that this errors just don't go away and i don't
understand why that broken stuff is inserted for the temp-user and never
cleaned up

Mar 20 19:15:36 caladan dbmail/maintenance[22304]: Warning:[db]
db_set_headercache(+1617): error caching headers for physmessage: [853200]
Mar 20 19:15:36 caladan dbmail/maintenance[22304]: Warning:[db]
db_set_headercache(+1617): error caching headers for physmessage: [853199]
Mar 20 19:15:36 caladan dbmail/maintenance[22304]: Warning:[db]
db_set_headercache(+1617): error caching headers for physmessage: [853197]
Mar 20 19:15:36 caladan dbmail/maintenance[22304]: Warning:[db]
db_set_headercache(+1617): error caching headers for physmessage: [853196]
Mar 20 19:15:36 caladan dbmail/maintenance[22304]: Warning:[db]
db_set_headercache(+1617): error caching headers for physmessage: [853195]
Mar 20 19:15:36 caladan dbmail/maintenance[22304]: Warning:[db]
db_set_headercache(+1617): error caching headers for physmessage: [853194]
Mar 20 19:15:36 caladan dbmail/maintenance[22304]: Warning:[db]
db_set_headercache(+1617): error caching headers for physmessage: [853193]
Mar 20 19:15:36 caladan dbmail/maintenance[22304]: Warning:[db]
db_set_headercache(+1617): error caching headers for physmessage: [853192]

Ok. Found [1915] missing envelope values.
.......................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................
....................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................
Repairing DBMAIL for cached header values...
Ok. Found [1915] un-cached physmessages.
EEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEE
EEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEE


> 2016-03-20 15:17 GMT+01:00 Reindl Harald <h.reindl@thelounge.net>:
>> can dbmail at least get a patch to mention the *user* which triggers that
>> bug?
>>
>> Mar 20 15:13:39 caladan dbmail/imap4d[1194]: Error:[message]
>> dbmail_message_cache_headers(+1324): self->content is not a message
>> Mar 20 15:13:39 caladan dbmail/imap4d[1194]: Error:[message]
>> dbmail_message_cache_headers(+1324): self->content is not a message
>> Mar 20 15:13:39 caladan dbmail/imap4d[1194]: Error:[message]
>> dbmail_message_cache_headers(+1324): self->content is not a message
>> Mar 20 15:13:39 caladan dbmail/imap4d[1194]: Error:[message]
>> dbmail_message_cache_headers(+1324): self->content is not a message
>> Mar 20 15:13:39 caladan dbmail/imap4d[1194]: Error:[message]
>> dbmail_message_cache_headers(+1324): self->content is not a message
>> Mar 20 15:13:39 caladan dbmail/imap4d[1194]: Error:[message]
>> dbmail_message_cache_headers(+1324): self->content is not a message
>> Mar 20 15:13:39 caladan dbmail/imap4d[1194]: Error:[message]
>> dbmail_message_cache_headers(+1324): self->content is not a message
>> Mar 20 15:13:39 caladan dbmail/imap4d[1194]: Error:[message]
>> dbmail_message_cache_headers(+1324): self->content is not a message
>> Mar 20 15:13:39 caladan dbmail/imap4d[1194]: Error:[message]
>> dbmail_message_cache_headers(+1324): self->content is not a message
>> Mar 20 15:13:39 caladan dbmail/imap4d[1194]: Error:[imap]
>> _ic_append_enter(+1316): [0x55cd52bfaf70] error appending msg
>>
>>
>> Am 15.03.2016 um 01:41 schrieb Reindl Harald:
>>>
>>> that's not funny, grwing and not redueable without handmade scripts
>>> thowing away anything owned by user_idnr 2 which should be the job of
>>> dbmail-util (and is prone for race-conditions that way) as last ressort
>>> (normally it should be cleaned automatically)
>>>
>>> Found [890] un-cached physmessages.
>>>
>>> EEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEE
>>>
>>> Maintenance done. Errors were found and fixed.
>>> We suggest running dbmail-util again to confirm that all errors were
>>> repaired.
>>> Ok. Found [890] missing envelope values.
>>>
>>> Am 10.03.2016 um 16:37 schrieb Reindl Harald:
>>>>
>>>> in fact all this "messages" are in mailbox_idnr 2 / owner_idnr 1 which
>>>> is "__@!internal_delivery_user!@__" and so *why* is that not cleaned up
>>>> when whatever client operation fails?
>>>>
>>>> looks like a partial delivery
>>>>
>>>> Am 10.03.2016 um 16:33 schrieb Reindl Harald:
>>>>>
>>>>> dbmail-3.1.17 with latest fixes
>>>>>
>>>>> what's that for new stuff below flooding our server?
>>>>> looks like some crazy client is trying to save drafts or something like
>>>>> that, however, the result is that the number of this errors grows day
>>>>> for day with each dbmail-util run
>>>>> ___________________________________________________________
>>>>>
>>>>> Mar 10 16:28:13 caladan dbmail/maintenance[14421]: Error:[message]
>>>>> dbmail_message_cache_envelope(+1844): SQLException: Column 'envelope'
>>>>> cannot be null
>>>>> Mar 10 16:28:13 caladan dbmail/maintenance[14421]: Error:[message]
>>>>> dbmail_message_cache_envelope(+1846): insert envelope failed [(null)]
>>>>> Mar 10 16:28:13 caladan dbmail/maintenance[14421]: Error:[message]
>>>>> dbmail_message_cache_envelope(+1844): SQLException: Column 'envelope'
>>>>> cannot be null
>>>>> Mar 10 16:28:13 caladan dbmail/maintenance[14421]: Error:[message]
>>>>> dbmail_message_cache_envelope(+1846): insert envelope failed [(null)]
>>>>> Mar 10 16:28:13 caladan dbmail/maintenance[14421]: Error:[message]
>>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>>> Mar 10 16:28:13 caladan dbmail/maintenance[14421]: Warning:[db]
>>>>> db_set_headercache(+1617): error caching headers for physmessage:
>>>>> [853193]
>>>>> Mar 10 16:28:13 caladan dbmail/maintenance[14421]: Error:[message]
>>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>>> Mar 10 16:28:13 caladan dbmail/maintenance[14421]: Warning:[db]
>>>>> db_set_headercache(+1617): error caching headers for physmessage:
>>>>> [853192]
>>>>> Mar 10 16:28:14 caladan dbmail/maintenance[14423]: Error:[message]
>>>>> dbmail_message_cache_envelope(+1844): SQLException: Column 'envelope'
>>>>> cannot be null
>>>>> Mar 10 16:28:14 caladan dbmail/maintenance[14423]: Error:[message]
>>>>> dbmail_message_cache_envelope(+1846): insert envelope failed [(null)]
>>>>> Mar 10 16:28:14 caladan dbmail/maintenance[14423]: Error:[message]
>>>>> dbmail_message_cache_envelope(+1844): SQLException: Column 'envelope'
>>>>> cannot be null
>>>>> Mar 10 16:28:14 caladan dbmail/maintenance[14423]: Error:[message]
>>>>> dbmail_message_cache_envelope(+1846): insert envelope failed [(null)]
>>>>> Mar 10 16:28:14 caladan dbmail/maintenance[14423]: Error:[message]
>>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>>> Mar 10 16:28:14 caladan dbmail/maintenance[14423]: Warning:[db]
>>>>> db_set_headercache(+1617): error caching headers for physmessage:
>>>>> [853193]
>>>>> Mar 10 16:28:14 caladan dbmail/maintenance[14423]: Error:[message]
>>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>>> Mar 10 16:28:14 caladan dbmail/maintenance[14423]: Warning:[db]
>>>>> db_set_headercache(+1617): error caching headers for physmessage:
>>>>> [853192]
>>>>> Mar 10 16:28:14 caladan dbmail/maintenance[14425]: Error:[message]
>>>>> dbmail_message_cache_envelope(+1844): SQLException: Column 'envelope'
>>>>> cannot be null
>>>>> Mar 10 16:28:14 caladan dbmail/maintenance[14425]: Error:[message]
>>>>> dbmail_message_cache_envelope(+1846): insert envelope failed [(null)]
>>>>> Mar 10 16:28:14 caladan dbmail/maintenance[14425]: Error:[message]
>>>>> dbmail_message_cache_envelope(+1844): SQLException: Column 'envelope'
>>>>> cannot be null
>>>>> Mar 10 16:28:14 caladan dbmail/maintenance[14425]: Error:[message]
>>>>> dbmail_message_cache_envelope(+1846): insert envelope failed [(null)]
>>>>> Mar 10 16:28:14 caladan dbmail/maintenance[14425]: Error:[message]
>>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>>> Mar 10 16:28:14 caladan dbmail/maintenance[14425]: Warning:[db]
>>>>> db_set_headercache(+1617): error caching headers for physmessage:
>>>>> [853193]
>>>>> Mar 10 16:28:14 caladan dbmail/maintenance[14425]: Error:[message]
>>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>>> Mar 10 16:28:14 caladan dbmail/maintenance[14425]: Warning:[db]
>>>>> db_set_headercache(+1617): error caching headers for physmessage:
>>>>> [853192]
>>>>> ___________________________________________________________
>>>>>
>>>>> Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[message]
>>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>>> Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[message]
>>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>>> Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[message]
>>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>>> Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[message]
>>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>>> Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[message]
>>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>>> Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[message]
>>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>>> Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[message]
>>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>>> Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[message]
>>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>>> Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[message]
>>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>>> Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[imap]
>>>>> _ic_append_enter(+1316): [0x55dce60f65b0] error appending msg
Re: SQLException: Column 'envelope' cannot be null / self->content is not a message [ In reply to ]
It's very easy to add a issue @ github, pleasse try to keep issues
there also as it's a very good repo. I'm an SVN guy also but I love
their site and it's very clear!

Why is there a dovecot proxy in front ? does it also happen when it's
not in front ?



2016-03-20 19:16 GMT+01:00 Reindl Harald <h.reindl@thelounge.net>:
>
>
> Am 20.03.2016 um 19:11 schrieb Matt.:
>>
>> Hi Harald,
>>
>> I didn't see your issue earlier, sorry for that. Don't you post @
>> github issues ?
>
>
> no - sorry, i hate github
>
>> Did this never happened before and can how high is your logging at the
>> moment ?
>
>
> not that often as now
> dbmail-3.1.17-3.fc23.20160319.rh.2874f497fb429ed139e94342ca1c84325b20b3f1.x86_64
>
> syslog_logging_levels = 31
>
> in other words - dbmail logging is nearly disabled since there is a dovecot
> proxy in front
>
>
> Mar 20 18:27:46 caladan dbmail/imap4d[1194]: Error:[message]
> dbmail_message_cache_headers(+1324): self->content is not a message
> Mar 20 18:27:46 caladan dbmail/imap4d[1194]: Error:[message]
> dbmail_message_cache_headers(+1324): self->content is not a message
> Mar 20 18:27:46 caladan dbmail/imap4d[1194]: Error:[message]
> dbmail_message_cache_headers(+1324): self->content is not a message
> Mar 20 18:27:46 caladan dbmail/imap4d[1194]: Error:[message]
> dbmail_message_cache_headers(+1324): self->content is not a message
> Mar 20 18:27:46 caladan dbmail/imap4d[1194]: Error:[message]
> dbmail_message_cache_headers(+1324): self->content is not a message
> Mar 20 18:27:46 caladan dbmail/imap4d[1194]: Error:[message]
> dbmail_message_cache_headers(+1324): self->content is not a message
> Mar 20 18:27:46 caladan dbmail/imap4d[1194]: Error:[message]
> dbmail_message_cache_headers(+1324): self->content is not a message
> Mar 20 18:27:46 caladan dbmail/imap4d[1194]: Error:[message]
> dbmail_message_cache_headers(+1324): self->content is not a message
> Mar 20 18:27:46 caladan dbmail/imap4d[1194]: Error:[message]
> dbmail_message_cache_headers(+1324): self->content is not a message
> Mar 20 18:27:46 caladan dbmail/imap4d[1194]: Error:[imap]
> _ic_append_enter(+1316): [0x55cd52aa79a0] error appending msg
> _________________________
>
> one problem is that this errors just don't go away and i don't understand
> why that broken stuff is inserted for the temp-user and never cleaned up
>
> Mar 20 19:15:36 caladan dbmail/maintenance[22304]: Warning:[db]
> db_set_headercache(+1617): error caching headers for physmessage: [853200]
> Mar 20 19:15:36 caladan dbmail/maintenance[22304]: Warning:[db]
> db_set_headercache(+1617): error caching headers for physmessage: [853199]
> Mar 20 19:15:36 caladan dbmail/maintenance[22304]: Warning:[db]
> db_set_headercache(+1617): error caching headers for physmessage: [853197]
> Mar 20 19:15:36 caladan dbmail/maintenance[22304]: Warning:[db]
> db_set_headercache(+1617): error caching headers for physmessage: [853196]
> Mar 20 19:15:36 caladan dbmail/maintenance[22304]: Warning:[db]
> db_set_headercache(+1617): error caching headers for physmessage: [853195]
> Mar 20 19:15:36 caladan dbmail/maintenance[22304]: Warning:[db]
> db_set_headercache(+1617): error caching headers for physmessage: [853194]
> Mar 20 19:15:36 caladan dbmail/maintenance[22304]: Warning:[db]
> db_set_headercache(+1617): error caching headers for physmessage: [853193]
> Mar 20 19:15:36 caladan dbmail/maintenance[22304]: Warning:[db]
> db_set_headercache(+1617): error caching headers for physmessage: [853192]
>
> Ok. Found [1915] missing envelope values.
> .......................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................
> ....................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................
> Repairing DBMAIL for cached header values...
> Ok. Found [1915] un-cached physmessages.
> EEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEE
> EEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEE
>
>
>
>> 2016-03-20 15:17 GMT+01:00 Reindl Harald <h.reindl@thelounge.net>:
>>>
>>> can dbmail at least get a patch to mention the *user* which triggers that
>>> bug?
>>>
>>> Mar 20 15:13:39 caladan dbmail/imap4d[1194]: Error:[message]
>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>> Mar 20 15:13:39 caladan dbmail/imap4d[1194]: Error:[message]
>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>> Mar 20 15:13:39 caladan dbmail/imap4d[1194]: Error:[message]
>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>> Mar 20 15:13:39 caladan dbmail/imap4d[1194]: Error:[message]
>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>> Mar 20 15:13:39 caladan dbmail/imap4d[1194]: Error:[message]
>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>> Mar 20 15:13:39 caladan dbmail/imap4d[1194]: Error:[message]
>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>> Mar 20 15:13:39 caladan dbmail/imap4d[1194]: Error:[message]
>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>> Mar 20 15:13:39 caladan dbmail/imap4d[1194]: Error:[message]
>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>> Mar 20 15:13:39 caladan dbmail/imap4d[1194]: Error:[message]
>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>> Mar 20 15:13:39 caladan dbmail/imap4d[1194]: Error:[imap]
>>> _ic_append_enter(+1316): [0x55cd52bfaf70] error appending msg
>>>
>>>
>>> Am 15.03.2016 um 01:41 schrieb Reindl Harald:
>>>>
>>>>
>>>> that's not funny, grwing and not redueable without handmade scripts
>>>> thowing away anything owned by user_idnr 2 which should be the job of
>>>> dbmail-util (and is prone for race-conditions that way) as last ressort
>>>> (normally it should be cleaned automatically)
>>>>
>>>> Found [890] un-cached physmessages.
>>>>
>>>>
>>>> EEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEE
>>>>
>>>> Maintenance done. Errors were found and fixed.
>>>> We suggest running dbmail-util again to confirm that all errors were
>>>> repaired.
>>>> Ok. Found [890] missing envelope values.
>>>>
>>>> Am 10.03.2016 um 16:37 schrieb Reindl Harald:
>>>>>
>>>>>
>>>>> in fact all this "messages" are in mailbox_idnr 2 / owner_idnr 1 which
>>>>> is "__@!internal_delivery_user!@__" and so *why* is that not cleaned up
>>>>> when whatever client operation fails?
>>>>>
>>>>> looks like a partial delivery
>>>>>
>>>>> Am 10.03.2016 um 16:33 schrieb Reindl Harald:
>>>>>>
>>>>>>
>>>>>> dbmail-3.1.17 with latest fixes
>>>>>>
>>>>>> what's that for new stuff below flooding our server?
>>>>>> looks like some crazy client is trying to save drafts or something
>>>>>> like
>>>>>> that, however, the result is that the number of this errors grows day
>>>>>> for day with each dbmail-util run
>>>>>> ___________________________________________________________
>>>>>>
>>>>>> Mar 10 16:28:13 caladan dbmail/maintenance[14421]: Error:[message]
>>>>>> dbmail_message_cache_envelope(+1844): SQLException: Column 'envelope'
>>>>>> cannot be null
>>>>>> Mar 10 16:28:13 caladan dbmail/maintenance[14421]: Error:[message]
>>>>>> dbmail_message_cache_envelope(+1846): insert envelope failed [(null)]
>>>>>> Mar 10 16:28:13 caladan dbmail/maintenance[14421]: Error:[message]
>>>>>> dbmail_message_cache_envelope(+1844): SQLException: Column 'envelope'
>>>>>> cannot be null
>>>>>> Mar 10 16:28:13 caladan dbmail/maintenance[14421]: Error:[message]
>>>>>> dbmail_message_cache_envelope(+1846): insert envelope failed [(null)]
>>>>>> Mar 10 16:28:13 caladan dbmail/maintenance[14421]: Error:[message]
>>>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>>>> Mar 10 16:28:13 caladan dbmail/maintenance[14421]: Warning:[db]
>>>>>> db_set_headercache(+1617): error caching headers for physmessage:
>>>>>> [853193]
>>>>>> Mar 10 16:28:13 caladan dbmail/maintenance[14421]: Error:[message]
>>>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>>>> Mar 10 16:28:13 caladan dbmail/maintenance[14421]: Warning:[db]
>>>>>> db_set_headercache(+1617): error caching headers for physmessage:
>>>>>> [853192]
>>>>>> Mar 10 16:28:14 caladan dbmail/maintenance[14423]: Error:[message]
>>>>>> dbmail_message_cache_envelope(+1844): SQLException: Column 'envelope'
>>>>>> cannot be null
>>>>>> Mar 10 16:28:14 caladan dbmail/maintenance[14423]: Error:[message]
>>>>>> dbmail_message_cache_envelope(+1846): insert envelope failed [(null)]
>>>>>> Mar 10 16:28:14 caladan dbmail/maintenance[14423]: Error:[message]
>>>>>> dbmail_message_cache_envelope(+1844): SQLException: Column 'envelope'
>>>>>> cannot be null
>>>>>> Mar 10 16:28:14 caladan dbmail/maintenance[14423]: Error:[message]
>>>>>> dbmail_message_cache_envelope(+1846): insert envelope failed [(null)]
>>>>>> Mar 10 16:28:14 caladan dbmail/maintenance[14423]: Error:[message]
>>>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>>>> Mar 10 16:28:14 caladan dbmail/maintenance[14423]: Warning:[db]
>>>>>> db_set_headercache(+1617): error caching headers for physmessage:
>>>>>> [853193]
>>>>>> Mar 10 16:28:14 caladan dbmail/maintenance[14423]: Error:[message]
>>>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>>>> Mar 10 16:28:14 caladan dbmail/maintenance[14423]: Warning:[db]
>>>>>> db_set_headercache(+1617): error caching headers for physmessage:
>>>>>> [853192]
>>>>>> Mar 10 16:28:14 caladan dbmail/maintenance[14425]: Error:[message]
>>>>>> dbmail_message_cache_envelope(+1844): SQLException: Column 'envelope'
>>>>>> cannot be null
>>>>>> Mar 10 16:28:14 caladan dbmail/maintenance[14425]: Error:[message]
>>>>>> dbmail_message_cache_envelope(+1846): insert envelope failed [(null)]
>>>>>> Mar 10 16:28:14 caladan dbmail/maintenance[14425]: Error:[message]
>>>>>> dbmail_message_cache_envelope(+1844): SQLException: Column 'envelope'
>>>>>> cannot be null
>>>>>> Mar 10 16:28:14 caladan dbmail/maintenance[14425]: Error:[message]
>>>>>> dbmail_message_cache_envelope(+1846): insert envelope failed [(null)]
>>>>>> Mar 10 16:28:14 caladan dbmail/maintenance[14425]: Error:[message]
>>>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>>>> Mar 10 16:28:14 caladan dbmail/maintenance[14425]: Warning:[db]
>>>>>> db_set_headercache(+1617): error caching headers for physmessage:
>>>>>> [853193]
>>>>>> Mar 10 16:28:14 caladan dbmail/maintenance[14425]: Error:[message]
>>>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>>>> Mar 10 16:28:14 caladan dbmail/maintenance[14425]: Warning:[db]
>>>>>> db_set_headercache(+1617): error caching headers for physmessage:
>>>>>> [853192]
>>>>>> ___________________________________________________________
>>>>>>
>>>>>> Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[message]
>>>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>>>> Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[message]
>>>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>>>> Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[message]
>>>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>>>> Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[message]
>>>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>>>> Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[message]
>>>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>>>> Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[message]
>>>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>>>> Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[message]
>>>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>>>> Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[message]
>>>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>>>> Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[message]
>>>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>>>> Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[imap]
>>>>>> _ic_append_enter(+1316): [0x55dce60f65b0] error appending msg
>
>
>
> _______________________________________________
> DBmail mailing list
> DBmail@dbmail.org
> http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
>
_______________________________________________
DBmail mailing list
DBmail@dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: SQLException: Column 'envelope' cannot be null / self->content is not a message [ In reply to ]
Am 20.03.2016 um 19:25 schrieb Matt.:
> It's very easy to add a issue @ github, pleasse try to keep issues
> there also as it's a very good repo. I'm an SVN guy also but I love
> their site and it's very clear!

sorry, my primary repo is http://git.dbmail.eu/paul/dbmail as i have in
the hundrets of hours trying to help debug dbmail built infrastructure
around it

> Why is there a dovecot proxy in front ? does it also happen when it's
> not in front ?

because dbmail has proven to be very unstable when it comes to TLS in
the past, as the servers was installed did not support TLS or anything
but plain login at all and docevot solves all that problems while at the
sam etime offer a unified SASL-layer for postfix offering the same
encryption and auth-methods for POP3/IMAP and SMTP

when you look at the errors the question "does it also happen when it's
not in front?" superfluous becaus ewhat happens here MUST NEVER happen
at all, store partly messages and not able to cleanup themself with
dbmail-util is a nogo

please take a look at the start of this thread especially at "in fact
all this "messages" are in mailbox_idnr 2 / owner_idnr 1 which is
"__@!internal_delivery_user!@__" and so *why* is that not cleaned up
when whatever client operation fails?"

> 2016-03-20 19:16 GMT+01:00 Reindl Harald <h.reindl@thelounge.net>:
>>
>>
>> Am 20.03.2016 um 19:11 schrieb Matt.:
>>>
>>> Hi Harald,
>>>
>>> I didn't see your issue earlier, sorry for that. Don't you post @
>>> github issues ?
>>
>>
>> no - sorry, i hate github
>>
>>> Did this never happened before and can how high is your logging at the
>>> moment ?
>>
>>
>> not that often as now
>> dbmail-3.1.17-3.fc23.20160319.rh.2874f497fb429ed139e94342ca1c84325b20b3f1.x86_64
>>
>> syslog_logging_levels = 31
>>
>> in other words - dbmail logging is nearly disabled since there is a dovecot
>> proxy in front
>>
>>
>> Mar 20 18:27:46 caladan dbmail/imap4d[1194]: Error:[message]
>> dbmail_message_cache_headers(+1324): self->content is not a message
>> Mar 20 18:27:46 caladan dbmail/imap4d[1194]: Error:[message]
>> dbmail_message_cache_headers(+1324): self->content is not a message
>> Mar 20 18:27:46 caladan dbmail/imap4d[1194]: Error:[message]
>> dbmail_message_cache_headers(+1324): self->content is not a message
>> Mar 20 18:27:46 caladan dbmail/imap4d[1194]: Error:[message]
>> dbmail_message_cache_headers(+1324): self->content is not a message
>> Mar 20 18:27:46 caladan dbmail/imap4d[1194]: Error:[message]
>> dbmail_message_cache_headers(+1324): self->content is not a message
>> Mar 20 18:27:46 caladan dbmail/imap4d[1194]: Error:[message]
>> dbmail_message_cache_headers(+1324): self->content is not a message
>> Mar 20 18:27:46 caladan dbmail/imap4d[1194]: Error:[message]
>> dbmail_message_cache_headers(+1324): self->content is not a message
>> Mar 20 18:27:46 caladan dbmail/imap4d[1194]: Error:[message]
>> dbmail_message_cache_headers(+1324): self->content is not a message
>> Mar 20 18:27:46 caladan dbmail/imap4d[1194]: Error:[message]
>> dbmail_message_cache_headers(+1324): self->content is not a message
>> Mar 20 18:27:46 caladan dbmail/imap4d[1194]: Error:[imap]
>> _ic_append_enter(+1316): [0x55cd52aa79a0] error appending msg
>> _________________________
>>
>> one problem is that this errors just don't go away and i don't understand
>> why that broken stuff is inserted for the temp-user and never cleaned up
>>
>> Mar 20 19:15:36 caladan dbmail/maintenance[22304]: Warning:[db]
>> db_set_headercache(+1617): error caching headers for physmessage: [853200]
>> Mar 20 19:15:36 caladan dbmail/maintenance[22304]: Warning:[db]
>> db_set_headercache(+1617): error caching headers for physmessage: [853199]
>> Mar 20 19:15:36 caladan dbmail/maintenance[22304]: Warning:[db]
>> db_set_headercache(+1617): error caching headers for physmessage: [853197]
>> Mar 20 19:15:36 caladan dbmail/maintenance[22304]: Warning:[db]
>> db_set_headercache(+1617): error caching headers for physmessage: [853196]
>> Mar 20 19:15:36 caladan dbmail/maintenance[22304]: Warning:[db]
>> db_set_headercache(+1617): error caching headers for physmessage: [853195]
>> Mar 20 19:15:36 caladan dbmail/maintenance[22304]: Warning:[db]
>> db_set_headercache(+1617): error caching headers for physmessage: [853194]
>> Mar 20 19:15:36 caladan dbmail/maintenance[22304]: Warning:[db]
>> db_set_headercache(+1617): error caching headers for physmessage: [853193]
>> Mar 20 19:15:36 caladan dbmail/maintenance[22304]: Warning:[db]
>> db_set_headercache(+1617): error caching headers for physmessage: [853192]
>>
>> Ok. Found [1915] missing envelope values.
>> ....................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................

> ...
>> ....................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................
>> Repairing DBMAIL for cached header values...
>> Ok. Found [1915] un-cached physmessages.
>> EEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEE

> EEE
>> EEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEE
>>
>>
>>
>>> 2016-03-20 15:17 GMT+01:00 Reindl Harald <h.reindl@thelounge.net>:
>>>>
>>>> can dbmail at least get a patch to mention the *user* which triggers that
>>>> bug?
>>>>
>>>> Mar 20 15:13:39 caladan dbmail/imap4d[1194]: Error:[message]
>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>> Mar 20 15:13:39 caladan dbmail/imap4d[1194]: Error:[message]
>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>> Mar 20 15:13:39 caladan dbmail/imap4d[1194]: Error:[message]
>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>> Mar 20 15:13:39 caladan dbmail/imap4d[1194]: Error:[message]
>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>> Mar 20 15:13:39 caladan dbmail/imap4d[1194]: Error:[message]
>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>> Mar 20 15:13:39 caladan dbmail/imap4d[1194]: Error:[message]
>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>> Mar 20 15:13:39 caladan dbmail/imap4d[1194]: Error:[message]
>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>> Mar 20 15:13:39 caladan dbmail/imap4d[1194]: Error:[message]
>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>> Mar 20 15:13:39 caladan dbmail/imap4d[1194]: Error:[message]
>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>> Mar 20 15:13:39 caladan dbmail/imap4d[1194]: Error:[imap]
>>>> _ic_append_enter(+1316): [0x55cd52bfaf70] error appending msg
>>>>
>>>>
>>>> Am 15.03.2016 um 01:41 schrieb Reindl Harald:
>>>>>
>>>>>
>>>>> that's not funny, grwing and not redueable without handmade scripts
>>>>> thowing away anything owned by user_idnr 2 which should be the job of
>>>>> dbmail-util (and is prone for race-conditions that way) as last ressort
>>>>> (normally it should be cleaned automatically)
>>>>>
>>>>> Found [890] un-cached physmessages.
>>>>>
>>>>>
>>>>> EEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEE
>>>>>
>>>>> Maintenance done. Errors were found and fixed.
>>>>> We suggest running dbmail-util again to confirm that all errors were
>>>>> repaired.
>>>>> Ok. Found [890] missing envelope values.
>>>>>
>>>>> Am 10.03.2016 um 16:37 schrieb Reindl Harald:
>>>>>>
>>>>>>
>>>>>> in fact all this "messages" are in mailbox_idnr 2 / owner_idnr 1 which
>>>>>> is "__@!internal_delivery_user!@__" and so *why* is that not cleaned up
>>>>>> when whatever client operation fails?
>>>>>>
>>>>>> looks like a partial delivery
>>>>>>
>>>>>> Am 10.03.2016 um 16:33 schrieb Reindl Harald:
>>>>>>>
>>>>>>>
>>>>>>> dbmail-3.1.17 with latest fixes
>>>>>>>
>>>>>>> what's that for new stuff below flooding our server?
>>>>>>> looks like some crazy client is trying to save drafts or something
>>>>>>> like
>>>>>>> that, however, the result is that the number of this errors grows day
>>>>>>> for day with each dbmail-util run
>>>>>>> ___________________________________________________________
>>>>>>>
>>>>>>> Mar 10 16:28:13 caladan dbmail/maintenance[14421]: Error:[message]
>>>>>>> dbmail_message_cache_envelope(+1844): SQLException: Column 'envelope'
>>>>>>> cannot be null
>>>>>>> Mar 10 16:28:13 caladan dbmail/maintenance[14421]: Error:[message]
>>>>>>> dbmail_message_cache_envelope(+1846): insert envelope failed [(null)]
>>>>>>> Mar 10 16:28:13 caladan dbmail/maintenance[14421]: Error:[message]
>>>>>>> dbmail_message_cache_envelope(+1844): SQLException: Column 'envelope'
>>>>>>> cannot be null
>>>>>>> Mar 10 16:28:13 caladan dbmail/maintenance[14421]: Error:[message]
>>>>>>> dbmail_message_cache_envelope(+1846): insert envelope failed [(null)]
>>>>>>> Mar 10 16:28:13 caladan dbmail/maintenance[14421]: Error:[message]
>>>>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>>>>> Mar 10 16:28:13 caladan dbmail/maintenance[14421]: Warning:[db]
>>>>>>> db_set_headercache(+1617): error caching headers for physmessage:
>>>>>>> [853193]
>>>>>>> Mar 10 16:28:13 caladan dbmail/maintenance[14421]: Error:[message]
>>>>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>>>>> Mar 10 16:28:13 caladan dbmail/maintenance[14421]: Warning:[db]
>>>>>>> db_set_headercache(+1617): error caching headers for physmessage:
>>>>>>> [853192]
>>>>>>> Mar 10 16:28:14 caladan dbmail/maintenance[14423]: Error:[message]
>>>>>>> dbmail_message_cache_envelope(+1844): SQLException: Column 'envelope'
>>>>>>> cannot be null
>>>>>>> Mar 10 16:28:14 caladan dbmail/maintenance[14423]: Error:[message]
>>>>>>> dbmail_message_cache_envelope(+1846): insert envelope failed [(null)]
>>>>>>> Mar 10 16:28:14 caladan dbmail/maintenance[14423]: Error:[message]
>>>>>>> dbmail_message_cache_envelope(+1844): SQLException: Column 'envelope'
>>>>>>> cannot be null
>>>>>>> Mar 10 16:28:14 caladan dbmail/maintenance[14423]: Error:[message]
>>>>>>> dbmail_message_cache_envelope(+1846): insert envelope failed [(null)]
>>>>>>> Mar 10 16:28:14 caladan dbmail/maintenance[14423]: Error:[message]
>>>>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>>>>> Mar 10 16:28:14 caladan dbmail/maintenance[14423]: Warning:[db]
>>>>>>> db_set_headercache(+1617): error caching headers for physmessage:
>>>>>>> [853193]
>>>>>>> Mar 10 16:28:14 caladan dbmail/maintenance[14423]: Error:[message]
>>>>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>>>>> Mar 10 16:28:14 caladan dbmail/maintenance[14423]: Warning:[db]
>>>>>>> db_set_headercache(+1617): error caching headers for physmessage:
>>>>>>> [853192]
>>>>>>> Mar 10 16:28:14 caladan dbmail/maintenance[14425]: Error:[message]
>>>>>>> dbmail_message_cache_envelope(+1844): SQLException: Column 'envelope'
>>>>>>> cannot be null
>>>>>>> Mar 10 16:28:14 caladan dbmail/maintenance[14425]: Error:[message]
>>>>>>> dbmail_message_cache_envelope(+1846): insert envelope failed [(null)]
>>>>>>> Mar 10 16:28:14 caladan dbmail/maintenance[14425]: Error:[message]
>>>>>>> dbmail_message_cache_envelope(+1844): SQLException: Column 'envelope'
>>>>>>> cannot be null
>>>>>>> Mar 10 16:28:14 caladan dbmail/maintenance[14425]: Error:[message]
>>>>>>> dbmail_message_cache_envelope(+1846): insert envelope failed [(null)]
>>>>>>> Mar 10 16:28:14 caladan dbmail/maintenance[14425]: Error:[message]
>>>>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>>>>> Mar 10 16:28:14 caladan dbmail/maintenance[14425]: Warning:[db]
>>>>>>> db_set_headercache(+1617): error caching headers for physmessage:
>>>>>>> [853193]
>>>>>>> Mar 10 16:28:14 caladan dbmail/maintenance[14425]: Error:[message]
>>>>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>>>>> Mar 10 16:28:14 caladan dbmail/maintenance[14425]: Warning:[db]
>>>>>>> db_set_headercache(+1617): error caching headers for physmessage:
>>>>>>> [853192]
>>>>>>> ___________________________________________________________
>>>>>>>
>>>>>>> Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[message]
>>>>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>>>>> Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[message]
>>>>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>>>>> Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[message]
>>>>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>>>>> Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[message]
>>>>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>>>>> Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[message]
>>>>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>>>>> Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[message]
>>>>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>>>>> Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[message]
>>>>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>>>>> Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[message]
>>>>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>>>>> Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[message]
>>>>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>>>>> Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[imap]
>>>>>>> _ic_append_enter(+1316): [0x55dce60f65b0] error appending msg
Re: SQLException: Column 'envelope' cannot be null / self->content is not a message [ In reply to ]
Hi Harald,

Paul commits also to the github repo and as he also get's the
pullrequests from there I suggest you focus on that repo, they are
actually the same.

I need to check that out, maybe tonisgh but otherwise tomorrow. I'm
releasing some part of my cluster upgrade here and need to get back to
mail as well and already tested some parts as I need to some "fancy"
sender_bcc_reply so I can take this directly.

If I'm right I can remember this from the end of 2013 and I thought
Paul got it fixed already by than, you can lookup the mailinglist for
it around november that year. I had something with that user also.

Don't lose faith, Paul is around :)

Cheers,

Matt



2016-03-20 19:34 GMT+01:00 Reindl Harald <h.reindl@thelounge.net>:
>
>
> Am 20.03.2016 um 19:25 schrieb Matt.:
>>
>> It's very easy to add a issue @ github, pleasse try to keep issues
>> there also as it's a very good repo. I'm an SVN guy also but I love
>> their site and it's very clear!
>
>
> sorry, my primary repo is http://git.dbmail.eu/paul/dbmail as i have in the
> hundrets of hours trying to help debug dbmail built infrastructure around it
>
>> Why is there a dovecot proxy in front ? does it also happen when it's
>> not in front ?
>
>
> because dbmail has proven to be very unstable when it comes to TLS in the
> past, as the servers was installed did not support TLS or anything but plain
> login at all and docevot solves all that problems while at the sam etime
> offer a unified SASL-layer for postfix offering the same encryption and
> auth-methods for POP3/IMAP and SMTP
>
> when you look at the errors the question "does it also happen when it's not
> in front?" superfluous becaus ewhat happens here MUST NEVER happen at all,
> store partly messages and not able to cleanup themself with dbmail-util is a
> nogo
>
> please take a look at the start of this thread especially at "in fact all
> this "messages" are in mailbox_idnr 2 / owner_idnr 1 which is
> "__@!internal_delivery_user!@__" and so *why* is that not cleaned up when
> whatever client operation fails?"
>
>
>> 2016-03-20 19:16 GMT+01:00 Reindl Harald <h.reindl@thelounge.net>:
>>>
>>>
>>>
>>> Am 20.03.2016 um 19:11 schrieb Matt.:
>>>>
>>>>
>>>> Hi Harald,
>>>>
>>>> I didn't see your issue earlier, sorry for that. Don't you post @
>>>> github issues ?
>>>
>>>
>>>
>>> no - sorry, i hate github
>>>
>>>> Did this never happened before and can how high is your logging at the
>>>> moment ?
>>>
>>>
>>>
>>> not that often as now
>>>
>>> dbmail-3.1.17-3.fc23.20160319.rh.2874f497fb429ed139e94342ca1c84325b20b3f1.x86_64
>>>
>>> syslog_logging_levels = 31
>>>
>>> in other words - dbmail logging is nearly disabled since there is a
>>> dovecot
>>> proxy in front
>>>
>>>
>>> Mar 20 18:27:46 caladan dbmail/imap4d[1194]: Error:[message]
>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>> Mar 20 18:27:46 caladan dbmail/imap4d[1194]: Error:[message]
>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>> Mar 20 18:27:46 caladan dbmail/imap4d[1194]: Error:[message]
>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>> Mar 20 18:27:46 caladan dbmail/imap4d[1194]: Error:[message]
>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>> Mar 20 18:27:46 caladan dbmail/imap4d[1194]: Error:[message]
>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>> Mar 20 18:27:46 caladan dbmail/imap4d[1194]: Error:[message]
>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>> Mar 20 18:27:46 caladan dbmail/imap4d[1194]: Error:[message]
>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>> Mar 20 18:27:46 caladan dbmail/imap4d[1194]: Error:[message]
>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>> Mar 20 18:27:46 caladan dbmail/imap4d[1194]: Error:[message]
>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>> Mar 20 18:27:46 caladan dbmail/imap4d[1194]: Error:[imap]
>>> _ic_append_enter(+1316): [0x55cd52aa79a0] error appending msg
>>> _________________________
>>>
>>> one problem is that this errors just don't go away and i don't understand
>>> why that broken stuff is inserted for the temp-user and never cleaned up
>>>
>>> Mar 20 19:15:36 caladan dbmail/maintenance[22304]: Warning:[db]
>>> db_set_headercache(+1617): error caching headers for physmessage:
>>> [853200]
>>> Mar 20 19:15:36 caladan dbmail/maintenance[22304]: Warning:[db]
>>> db_set_headercache(+1617): error caching headers for physmessage:
>>> [853199]
>>> Mar 20 19:15:36 caladan dbmail/maintenance[22304]: Warning:[db]
>>> db_set_headercache(+1617): error caching headers for physmessage:
>>> [853197]
>>> Mar 20 19:15:36 caladan dbmail/maintenance[22304]: Warning:[db]
>>> db_set_headercache(+1617): error caching headers for physmessage:
>>> [853196]
>>> Mar 20 19:15:36 caladan dbmail/maintenance[22304]: Warning:[db]
>>> db_set_headercache(+1617): error caching headers for physmessage:
>>> [853195]
>>> Mar 20 19:15:36 caladan dbmail/maintenance[22304]: Warning:[db]
>>> db_set_headercache(+1617): error caching headers for physmessage:
>>> [853194]
>>> Mar 20 19:15:36 caladan dbmail/maintenance[22304]: Warning:[db]
>>> db_set_headercache(+1617): error caching headers for physmessage:
>>> [853193]
>>> Mar 20 19:15:36 caladan dbmail/maintenance[22304]: Warning:[db]
>>> db_set_headercache(+1617): error caching headers for physmessage:
>>> [853192]
>>>
>>> Ok. Found [1915] missing envelope values.
>>>
>>> ....................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................
>
>
>> ...
>>>
>>>
>>> ....................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................
>>> Repairing DBMAIL for cached header values...
>>> Ok. Found [1915] un-cached physmessages.
>>>
>>> EEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEE
>
>
>> EEE
>>>
>>>
>>> EEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEE
>>>
>>>
>>>
>>>> 2016-03-20 15:17 GMT+01:00 Reindl Harald <h.reindl@thelounge.net>:
>>>>>
>>>>>
>>>>> can dbmail at least get a patch to mention the *user* which triggers
>>>>> that
>>>>> bug?
>>>>>
>>>>> Mar 20 15:13:39 caladan dbmail/imap4d[1194]: Error:[message]
>>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>>> Mar 20 15:13:39 caladan dbmail/imap4d[1194]: Error:[message]
>>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>>> Mar 20 15:13:39 caladan dbmail/imap4d[1194]: Error:[message]
>>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>>> Mar 20 15:13:39 caladan dbmail/imap4d[1194]: Error:[message]
>>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>>> Mar 20 15:13:39 caladan dbmail/imap4d[1194]: Error:[message]
>>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>>> Mar 20 15:13:39 caladan dbmail/imap4d[1194]: Error:[message]
>>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>>> Mar 20 15:13:39 caladan dbmail/imap4d[1194]: Error:[message]
>>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>>> Mar 20 15:13:39 caladan dbmail/imap4d[1194]: Error:[message]
>>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>>> Mar 20 15:13:39 caladan dbmail/imap4d[1194]: Error:[message]
>>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>>> Mar 20 15:13:39 caladan dbmail/imap4d[1194]: Error:[imap]
>>>>> _ic_append_enter(+1316): [0x55cd52bfaf70] error appending msg
>>>>>
>>>>>
>>>>> Am 15.03.2016 um 01:41 schrieb Reindl Harald:
>>>>>>
>>>>>>
>>>>>>
>>>>>> that's not funny, grwing and not redueable without handmade scripts
>>>>>> thowing away anything owned by user_idnr 2 which should be the job of
>>>>>> dbmail-util (and is prone for race-conditions that way) as last
>>>>>> ressort
>>>>>> (normally it should be cleaned automatically)
>>>>>>
>>>>>> Found [890] un-cached physmessages.
>>>>>>
>>>>>>
>>>>>>
>>>>>> EEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEE
>>>>>>
>>>>>> Maintenance done. Errors were found and fixed.
>>>>>> We suggest running dbmail-util again to confirm that all errors were
>>>>>> repaired.
>>>>>> Ok. Found [890] missing envelope values.
>>>>>>
>>>>>> Am 10.03.2016 um 16:37 schrieb Reindl Harald:
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> in fact all this "messages" are in mailbox_idnr 2 / owner_idnr 1
>>>>>>> which
>>>>>>> is "__@!internal_delivery_user!@__" and so *why* is that not cleaned
>>>>>>> up
>>>>>>> when whatever client operation fails?
>>>>>>>
>>>>>>> looks like a partial delivery
>>>>>>>
>>>>>>> Am 10.03.2016 um 16:33 schrieb Reindl Harald:
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> dbmail-3.1.17 with latest fixes
>>>>>>>>
>>>>>>>> what's that for new stuff below flooding our server?
>>>>>>>> looks like some crazy client is trying to save drafts or something
>>>>>>>> like
>>>>>>>> that, however, the result is that the number of this errors grows
>>>>>>>> day
>>>>>>>> for day with each dbmail-util run
>>>>>>>> ___________________________________________________________
>>>>>>>>
>>>>>>>> Mar 10 16:28:13 caladan dbmail/maintenance[14421]: Error:[message]
>>>>>>>> dbmail_message_cache_envelope(+1844): SQLException: Column
>>>>>>>> 'envelope'
>>>>>>>> cannot be null
>>>>>>>> Mar 10 16:28:13 caladan dbmail/maintenance[14421]: Error:[message]
>>>>>>>> dbmail_message_cache_envelope(+1846): insert envelope failed
>>>>>>>> [(null)]
>>>>>>>> Mar 10 16:28:13 caladan dbmail/maintenance[14421]: Error:[message]
>>>>>>>> dbmail_message_cache_envelope(+1844): SQLException: Column
>>>>>>>> 'envelope'
>>>>>>>> cannot be null
>>>>>>>> Mar 10 16:28:13 caladan dbmail/maintenance[14421]: Error:[message]
>>>>>>>> dbmail_message_cache_envelope(+1846): insert envelope failed
>>>>>>>> [(null)]
>>>>>>>> Mar 10 16:28:13 caladan dbmail/maintenance[14421]: Error:[message]
>>>>>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>>>>>> Mar 10 16:28:13 caladan dbmail/maintenance[14421]: Warning:[db]
>>>>>>>> db_set_headercache(+1617): error caching headers for physmessage:
>>>>>>>> [853193]
>>>>>>>> Mar 10 16:28:13 caladan dbmail/maintenance[14421]: Error:[message]
>>>>>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>>>>>> Mar 10 16:28:13 caladan dbmail/maintenance[14421]: Warning:[db]
>>>>>>>> db_set_headercache(+1617): error caching headers for physmessage:
>>>>>>>> [853192]
>>>>>>>> Mar 10 16:28:14 caladan dbmail/maintenance[14423]: Error:[message]
>>>>>>>> dbmail_message_cache_envelope(+1844): SQLException: Column
>>>>>>>> 'envelope'
>>>>>>>> cannot be null
>>>>>>>> Mar 10 16:28:14 caladan dbmail/maintenance[14423]: Error:[message]
>>>>>>>> dbmail_message_cache_envelope(+1846): insert envelope failed
>>>>>>>> [(null)]
>>>>>>>> Mar 10 16:28:14 caladan dbmail/maintenance[14423]: Error:[message]
>>>>>>>> dbmail_message_cache_envelope(+1844): SQLException: Column
>>>>>>>> 'envelope'
>>>>>>>> cannot be null
>>>>>>>> Mar 10 16:28:14 caladan dbmail/maintenance[14423]: Error:[message]
>>>>>>>> dbmail_message_cache_envelope(+1846): insert envelope failed
>>>>>>>> [(null)]
>>>>>>>> Mar 10 16:28:14 caladan dbmail/maintenance[14423]: Error:[message]
>>>>>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>>>>>> Mar 10 16:28:14 caladan dbmail/maintenance[14423]: Warning:[db]
>>>>>>>> db_set_headercache(+1617): error caching headers for physmessage:
>>>>>>>> [853193]
>>>>>>>> Mar 10 16:28:14 caladan dbmail/maintenance[14423]: Error:[message]
>>>>>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>>>>>> Mar 10 16:28:14 caladan dbmail/maintenance[14423]: Warning:[db]
>>>>>>>> db_set_headercache(+1617): error caching headers for physmessage:
>>>>>>>> [853192]
>>>>>>>> Mar 10 16:28:14 caladan dbmail/maintenance[14425]: Error:[message]
>>>>>>>> dbmail_message_cache_envelope(+1844): SQLException: Column
>>>>>>>> 'envelope'
>>>>>>>> cannot be null
>>>>>>>> Mar 10 16:28:14 caladan dbmail/maintenance[14425]: Error:[message]
>>>>>>>> dbmail_message_cache_envelope(+1846): insert envelope failed
>>>>>>>> [(null)]
>>>>>>>> Mar 10 16:28:14 caladan dbmail/maintenance[14425]: Error:[message]
>>>>>>>> dbmail_message_cache_envelope(+1844): SQLException: Column
>>>>>>>> 'envelope'
>>>>>>>> cannot be null
>>>>>>>> Mar 10 16:28:14 caladan dbmail/maintenance[14425]: Error:[message]
>>>>>>>> dbmail_message_cache_envelope(+1846): insert envelope failed
>>>>>>>> [(null)]
>>>>>>>> Mar 10 16:28:14 caladan dbmail/maintenance[14425]: Error:[message]
>>>>>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>>>>>> Mar 10 16:28:14 caladan dbmail/maintenance[14425]: Warning:[db]
>>>>>>>> db_set_headercache(+1617): error caching headers for physmessage:
>>>>>>>> [853193]
>>>>>>>> Mar 10 16:28:14 caladan dbmail/maintenance[14425]: Error:[message]
>>>>>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>>>>>> Mar 10 16:28:14 caladan dbmail/maintenance[14425]: Warning:[db]
>>>>>>>> db_set_headercache(+1617): error caching headers for physmessage:
>>>>>>>> [853192]
>>>>>>>> ___________________________________________________________
>>>>>>>>
>>>>>>>> Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[message]
>>>>>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>>>>>> Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[message]
>>>>>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>>>>>> Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[message]
>>>>>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>>>>>> Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[message]
>>>>>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>>>>>> Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[message]
>>>>>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>>>>>> Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[message]
>>>>>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>>>>>> Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[message]
>>>>>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>>>>>> Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[message]
>>>>>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>>>>>> Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[message]
>>>>>>>> dbmail_message_cache_headers(+1324): self->content is not a message
>>>>>>>> Mar 10 16:29:20 caladan dbmail/imap4d[1128]: Error:[imap]
>>>>>>>> _ic_append_enter(+1316): [0x55dce60f65b0] error appending msg
>
>
>
> _______________________________________________
> DBmail mailing list
> DBmail@dbmail.org
> http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
>
_______________________________________________
DBmail mailing list
DBmail@dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: SQLException: Column 'envelope' cannot be null / self->content is not a message [ In reply to ]
Hi

Am 20.03.2016 um 20:00 schrieb Matt.:
> Hi Harald,
>
> Paul commits also to the github repo and as he also get's the
> pullrequests from there I suggest you focus on that repo, they are
> actually the same.

"problem" is that i can build dbmail snapshots from webinterfaces on
testing-environment by just submit
http://git.dbmail.eu/paul/dbmail/commit/?h=dbmail_3_1&id=2874f497fb429ed139e94342ca1c84325b20b3f1
and modify a rpmbuild-specfile-template and don't want to lose that

> I need to check that out, maybe tonisgh but otherwise tomorrow. I'm
> releasing some part of my cluster upgrade here and need to get back to
> mail as well and already tested some parts as I need to some "fancy"
> sender_bcc_reply so I can take this directly.

no stress, it annyos me for weeks now :-)

> If I'm right I can remember this from the end of 2013 and I thought
> Paul got it fixed already by than, you can lookup the mailinglist for
> it around november that year. I had something with that user also.

pretty sure i was the reporter also and i can't remember it got fixed

the short ago fixed "prevent assertion in p_string_erase" was also
mutliple times reported over the years and responsible for times where
dbmail crashed multiple times each day and luckily whatever triggered
that pasued for weeks and months

http://dbmail.10918.n7.nabble.com/sql-and-other-errors-td34905.html

> Don't lose faith, Paul is around :)

good to hear, sometimes really hard to believe which makes me somehow
sorry and surely hesitant to try out dbmail-3.2 at all because i have
nort the energy to save the same amount of debugging time and customer
complaints as with 3.0/3.1 where i would need really support and not
talking to myself about issues if things go wrong :-)
Re: SQLException: Column 'envelope' cannot be null / self->content is not a message [ In reply to ]
it starts to become annoying - the whole purpose of dbmail-util is to
clean such stuff but the numbers are growing daily

should be zero:
[root@caladan:~]$ cat maillog | grep dbmail | wc -l: 276268

should log the damned username or just shutup:
Mar 18 14:20:05 caladan dbmail/imap4d[18388]: Error:[imap]
_ic_append_enter(+1316): [0x563117e4c4f0] error appending msg


Ok. Found [2870] missing envelope values.
.......................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................
.......................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................
........................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................Ok.
Found [2870] un-cached physmessages.
EEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEE
EEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEE
EEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEE

Am 20.03.2016 um 20:12 schrieb Reindl Harald:
> Hi
>
> Am 20.03.2016 um 20:00 schrieb Matt.:
>> Hi Harald,
>>
>> Paul commits also to the github repo and as he also get's the
>> pullrequests from there I suggest you focus on that repo, they are
>> actually the same.
>
> "problem" is that i can build dbmail snapshots from webinterfaces on
> testing-environment by just submit
> http://git.dbmail.eu/paul/dbmail/commit/?h=dbmail_3_1&id=2874f497fb429ed139e94342ca1c84325b20b3f1
> and modify a rpmbuild-specfile-template and don't want to lose that
>
>> I need to check that out, maybe tonisgh but otherwise tomorrow. I'm
>> releasing some part of my cluster upgrade here and need to get back to
>> mail as well and already tested some parts as I need to some "fancy"
>> sender_bcc_reply so I can take this directly.
>
> no stress, it annyos me for weeks now :-)
>
>> If I'm right I can remember this from the end of 2013 and I thought
>> Paul got it fixed already by than, you can lookup the mailinglist for
>> it around november that year. I had something with that user also.
>
> pretty sure i was the reporter also and i can't remember it got fixed
>
> the short ago fixed "prevent assertion in p_string_erase" was also
> mutliple times reported over the years and responsible for times where
> dbmail crashed multiple times each day and luckily whatever triggered
> that pasued for weeks and months
>
> http://dbmail.10918.n7.nabble.com/sql-and-other-errors-td34905.html
>
>> Don't lose faith, Paul is around :)
>
> good to hear, sometimes really hard to believe which makes me somehow
> sorry and surely hesitant to try out dbmail-3.2 at all because i have
> nort the energy to save the same amount of debugging time and customer
> complaints as with 3.0/3.1 where i would need really support and not
> talking to myself about issues if things go wrong :-)
Re: SQLException: Column 'envelope' cannot be null / self->content is not a message [ In reply to ]
Hi,

I didn't had time yet because of the flu, that annoyed me also ;)

Please bugreport @ github, that is the place to do and Paul can catch
up from there (or someone else).

I try to test here asap!

Have a good easter!

Cheers,

Matt

2016-03-26 22:37 GMT+01:00 Reindl Harald <h.reindl@thelounge.net>:
> it starts to become annoying - the whole purpose of dbmail-util is to clean
> such stuff but the numbers are growing daily
>
> should be zero:
> [root@caladan:~]$ cat maillog | grep dbmail | wc -l: 276268
>
> should log the damned username or just shutup:
> Mar 18 14:20:05 caladan dbmail/imap4d[18388]: Error:[imap]
> _ic_append_enter(+1316): [0x563117e4c4f0] error appending msg
>
>
> Ok. Found [2870] missing envelope values.
> .......................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................
> .......................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................
> ........................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................Ok.
> Found [2870] un-cached physmessages.
> EEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEE
> EEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEE
> EEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEE
>
>
> Am 20.03.2016 um 20:12 schrieb Reindl Harald:
>>
>> Hi
>>
>> Am 20.03.2016 um 20:00 schrieb Matt.:
>>>
>>> Hi Harald,
>>>
>>> Paul commits also to the github repo and as he also get's the
>>> pullrequests from there I suggest you focus on that repo, they are
>>> actually the same.
>>
>>
>> "problem" is that i can build dbmail snapshots from webinterfaces on
>> testing-environment by just submit
>>
>> http://git.dbmail.eu/paul/dbmail/commit/?h=dbmail_3_1&id=2874f497fb429ed139e94342ca1c84325b20b3f1
>> and modify a rpmbuild-specfile-template and don't want to lose that
>>
>>> I need to check that out, maybe tonisgh but otherwise tomorrow. I'm
>>> releasing some part of my cluster upgrade here and need to get back to
>>> mail as well and already tested some parts as I need to some "fancy"
>>> sender_bcc_reply so I can take this directly.
>>
>>
>> no stress, it annyos me for weeks now :-)
>>
>>> If I'm right I can remember this from the end of 2013 and I thought
>>> Paul got it fixed already by than, you can lookup the mailinglist for
>>> it around november that year. I had something with that user also.
>>
>>
>> pretty sure i was the reporter also and i can't remember it got fixed
>>
>> the short ago fixed "prevent assertion in p_string_erase" was also
>> mutliple times reported over the years and responsible for times where
>> dbmail crashed multiple times each day and luckily whatever triggered
>> that pasued for weeks and months
>>
>> http://dbmail.10918.n7.nabble.com/sql-and-other-errors-td34905.html
>>
>>> Don't lose faith, Paul is around :)
>>
>>
>> good to hear, sometimes really hard to believe which makes me somehow
>> sorry and surely hesitant to try out dbmail-3.2 at all because i have
>> nort the energy to save the same amount of debugging time and customer
>> complaints as with 3.0/3.1 where i would need really support and not
>> talking to myself about issues if things go wrong :-)
>
>
>
> _______________________________________________
> DBmail mailing list
> DBmail@dbmail.org
> http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
>
_______________________________________________
DBmail mailing list
DBmail@dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
Re: SQLException: Column 'envelope' cannot be null / self->content is not a message [ In reply to ]
besides that it shouldn't happen at all dbmail-utils should do the same
as below.... looks whatever triggered it is gone for now, no idea since
the logging don't mention a user

MariaDB [dbmail]> select count(*) from dbmail_messages where mailbox_idnr=2;
+----------+
| count(*) |
+----------+
| 2870 |
+----------+
1 row in set (0.00 sec)

MariaDB [dbmail]> delete from dbmail_messages where mailbox_idnr=2;
Query OK, 2870 rows affected (0.07 sec)

Am 27.03.2016 um 00:08 schrieb Matt.:
> Hi,
>
> I didn't had time yet because of the flu, that annoyed me also ;)
>
> Please bugreport @ github, that is the place to do and Paul can catch
> up from there (or someone else).
>
> I try to test here asap!
>
> Have a good easter!
>
> Cheers,
>
> Matt
>
> 2016-03-26 22:37 GMT+01:00 Reindl Harald <h.reindl@thelounge.net>:
>> it starts to become annoying - the whole purpose of dbmail-util is to clean
>> such stuff but the numbers are growing daily
>>
>> should be zero:
>> [root@caladan:~]$ cat maillog | grep dbmail | wc -l: 276268
>>
>> should log the damned username or just shutup:
>> Mar 18 14:20:05 caladan dbmail/imap4d[18388]: Error:[imap]
>> _ic_append_enter(+1316): [0x563117e4c4f0] error appending msg
>>
>>
>> Ok. Found [2870] missing envelope values.
>> ....................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................

> ...
>> ....................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................

> ...
>> ........................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................Ok.
>> Found [2870] un-cached physmessages.
>> EEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEE

> EEE
>> EEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEE

> EEE
>> EEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEE
>>
>>
>> Am 20.03.2016 um 20:12 schrieb Reindl Harald:
>>>
>>> Hi
>>>
>>> Am 20.03.2016 um 20:00 schrieb Matt.:
>>>>
>>>> Hi Harald,
>>>>
>>>> Paul commits also to the github repo and as he also get's the
>>>> pullrequests from there I suggest you focus on that repo, they are
>>>> actually the same.
>>>
>>>
>>> "problem" is that i can build dbmail snapshots from webinterfaces on
>>> testing-environment by just submit
>>>
>>> http://git.dbmail.eu/paul/dbmail/commit/?h=dbmail_3_1&id=2874f497fb429ed139e94342ca1c84325b20b3f1
>>> and modify a rpmbuild-specfile-template and don't want to lose that
>>>
>>>> I need to check that out, maybe tonisgh but otherwise tomorrow. I'm
>>>> releasing some part of my cluster upgrade here and need to get back to
>>>> mail as well and already tested some parts as I need to some "fancy"
>>>> sender_bcc_reply so I can take this directly.
>>>
>>>
>>> no stress, it annyos me for weeks now :-)
>>>
>>>> If I'm right I can remember this from the end of 2013 and I thought
>>>> Paul got it fixed already by than, you can lookup the mailinglist for
>>>> it around november that year. I had something with that user also.
>>>
>>>
>>> pretty sure i was the reporter also and i can't remember it got fixed
>>>
>>> the short ago fixed "prevent assertion in p_string_erase" was also
>>> mutliple times reported over the years and responsible for times where
>>> dbmail crashed multiple times each day and luckily whatever triggered
>>> that pasued for weeks and months
>>>
>>> http://dbmail.10918.n7.nabble.com/sql-and-other-errors-td34905.html
>>>
>>>> Don't lose faith, Paul is around :)
>>>
>>>
>>> good to hear, sometimes really hard to believe which makes me somehow
>>> sorry and surely hesitant to try out dbmail-3.2 at all because i have
>>> nort the energy to save the same amount of debugging time and customer
>>> complaints as with 3.0/3.1 where i would need really support and not
>>> talking to myself about issues if things go wrong :-)
Re: SQLException: Column 'envelope' cannot be null / self->content is not a message [ In reply to ]
i need that damned USER LOGGED reposible for "dbmail/imap4d[1194]:
Error:[message] dbmail_message_cache_headers(+1324): self->content is
not a message" and finally for 242378 log-entries

[root@caladan:~]$ cat maillog | grep "dbmail/maintenance" | wc -l
242378

Mar 16 01:35:10 caladan dbmail/maintenance[5148]: Warning:[db]
db_set_headercache(+1617): error caching headers for physmessage: [853255]
__________________________________________

MariaDB [dbmail]> select * from dbmail_users limit 1;
+-----------+--------------------------------+------------------+-------------+--------------+--------------+---------------+---------------+-----------------+---------------------+---------------+
| user_idnr | userid | passwd | client_idnr | maxmail_size |
curmail_size | maxsieve_size | cursieve_size | encryption_type |
last_login | user_realname |
+-----------+--------------------------------+------------------+-------------+--------------+--------------+---------------+---------------+-----------------+---------------------+---------------+
| 1 | __@!internal_delivery_user!@__ | 5BXDRcCeUWdKjPKY | 0 | 314572800
| 0 | 0 | 0 | md5 | 1979-11-03 22:05:58 | |
+-----------+--------------------------------+------------------+-------------+--------------+--------------+---------------+---------------+-----------------+---------------------+---------------+
1 row in set (0.00 sec)
MariaDB [dbmail]> select mailbox_idnr from dbmail_mailboxes where
owner_idnr=1;
+--------------+
| mailbox_idnr |
+--------------+
| 2 |
+--------------+
1 row in set (0.00 sec)
MariaDB [dbmail]> select count(*) from dbmail_messages where mailbox_idnr=2;
+----------+
| count(*) |
+----------+
| 391 |
+----------+
1 row in set (0.00 sec)

Am 27.03.2016 um 00:12 schrieb Reindl Harald:
> besides that it shouldn't happen at all dbmail-utils should do the same
> as below.... looks whatever triggered it is gone for now, no idea since
> the logging don't mention a user
>
> MariaDB [dbmail]> select count(*) from dbmail_messages where
> mailbox_idnr=2;
> +----------+
> | count(*) |
> +----------+
> | 2870 |
> +----------+
> 1 row in set (0.00 sec)
>
> MariaDB [dbmail]> delete from dbmail_messages where mailbox_idnr=2;
> Query OK, 2870 rows affected (0.07 sec)
>
> Am 27.03.2016 um 00:08 schrieb Matt.:
>> Hi,
>>
>> I didn't had time yet because of the flu, that annoyed me also ;)
>>
>> Please bugreport @ github, that is the place to do and Paul can catch
>> up from there (or someone else).
>>
>> I try to test here asap!
>>
>> Have a good easter!
>>
>> Cheers,
>>
>> Matt
>>
>> 2016-03-26 22:37 GMT+01:00 Reindl Harald <h.reindl@thelounge.net>:
>>> it starts to become annoying - the whole purpose of dbmail-util is to
>>> clean
>>> such stuff but the numbers are growing daily
>>>
>>> should be zero:
>>> [root@caladan:~]$ cat maillog | grep dbmail | wc -l: 276268
>>>
>>> should log the damned username or just shutup:
>>> Mar 18 14:20:05 caladan dbmail/imap4d[18388]: Error:[imap]
>>> _ic_append_enter(+1316): [0x563117e4c4f0] error appending msg
>>>
>>>
>>> Ok. Found [2870] missing envelope values.
>>> ...................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................
.
>>>
>
>> ...
>>> ...................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................
.
>>>
>
>> ...
>>> ........................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................Ok.
>>>
>>> Found [2870] un-cached physmessages.
>>> EEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEE
E
>>>
>
>> EEE
>>> EEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEE
E
>>>
>
>> EEE
>>> EEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEE
>>>
>>>
>>>
>>> Am 20.03.2016 um 20:12 schrieb Reindl Harald:
>>>>
>>>> Hi
>>>>
>>>> Am 20.03.2016 um 20:00 schrieb Matt.:
>>>>>
>>>>> Hi Harald,
>>>>>
>>>>> Paul commits also to the github repo and as he also get's the
>>>>> pullrequests from there I suggest you focus on that repo, they are
>>>>> actually the same.
>>>>
>>>>
>>>> "problem" is that i can build dbmail snapshots from webinterfaces on
>>>> testing-environment by just submit
>>>>
>>>> http://git.dbmail.eu/paul/dbmail/commit/?h=dbmail_3_1&id=2874f497fb429ed139e94342ca1c84325b20b3f1
>>>>
>>>> and modify a rpmbuild-specfile-template and don't want to lose that
>>>>
>>>>> I need to check that out, maybe tonisgh but otherwise tomorrow. I'm
>>>>> releasing some part of my cluster upgrade here and need to get back to
>>>>> mail as well and already tested some parts as I need to some "fancy"
>>>>> sender_bcc_reply so I can take this directly.
>>>>
>>>>
>>>> no stress, it annyos me for weeks now :-)
>>>>
>>>>> If I'm right I can remember this from the end of 2013 and I thought
>>>>> Paul got it fixed already by than, you can lookup the mailinglist for
>>>>> it around november that year. I had something with that user also.
>>>>
>>>>
>>>> pretty sure i was the reporter also and i can't remember it got fixed
>>>>
>>>> the short ago fixed "prevent assertion in p_string_erase" was also
>>>> mutliple times reported over the years and responsible for times where
>>>> dbmail crashed multiple times each day and luckily whatever triggered
>>>> that pasued for weeks and months
>>>>
>>>> http://dbmail.10918.n7.nabble.com/sql-and-other-errors-td34905.html
>>>>
>>>>> Don't lose faith, Paul is around :)
>>>>
>>>>
>>>> good to hear, sometimes really hard to believe which makes me somehow
>>>> sorry and surely hesitant to try out dbmail-3.2 at all because i have
>>>> nort the energy to save the same amount of debugging time and customer
>>>> complaints as with 3.0/3.1 where i would need really support and not
>>>> talking to myself about issues if things go wrong :-)