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

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

iEYEARECAAYFAlbnWiUACgkQhmBjz394AnmCsgCfeNT7t5/ZtL2qljUTyyxsQDBk
6v8An1Q6joiFAX53llp9DQS7Wqe9wPkr
=vAFX
-----END PGP SIGNATURE-----