Re: SQLException: Column 'envelope' cannot be null / self->content is not a message

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
[email protected]
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2

iEYEARECAAYFAlbusP0ACgkQhmBjz394Ank4OACfbKcqVdl279Wc065mzoLIbnSH
9VcAoJblnWMzubfgzQVS997YdafujNPl
=1gvu
-----END PGP SIGNATURE-----