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

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 <[email protected]>:
>> 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 :-)

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

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

iEYEARECAAYFAlb3F00ACgkQhmBjz394AnmObACcD24byKoDo40CA+r2Nj8WbZ64
ac0An0FUO8yO9Bpce0tMZHMZQlZObzLs
=lCeH
-----END PGP SIGNATURE-----