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

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 <[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.
>>> 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 :-)

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

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

iEYEARECAAYFAlb6Rd8ACgkQhmBjz394AnlIhQCbB25BuSPhRXJx1gULWFjqAI0f
8xwAn36LyHuZDSj7+cFNnqgnt16E1LSt
=NJy8
-----END PGP SIGNATURE-----