dovecot - Aug 2019 - Autoexpunge not working for Junk?

On Aug 12, 2019, at 12:18 AM, Sami Ketola via dovecot <dovecot at
dovecot.org> wrote:
> 
> "1. What's the first mail's saved-timestamp?
> doveadm fetch -u user date.saved mailbox Junk 1
Well... this is giving me strange results.  For myself, when I run this command,
I get:

[~]# doveadm fetch -u cepheid date.saved mailbox Junk 1
date.saved: 2019-07-15 01:42:56

However, my actual Junk folder shows email from as far back as May 15.  I
checked this with webmail to ensure it wasn't some problem on my local
MUA... this is definitely on the server.  And yes, I checked the Received
headers to make sure the dates were correctly represented (I didn't trust
the Date header alone).

HOWEVER... it looks like something is either corrupted or otherwise messed up,
because messages #2 and 299 have identical timestamps:
[~]# doveadm fetch -u cepheid date.saved mailbox Junk 2
date.saved: 2019-07-25 03:54:14
[~]# doveadm fetch -u cepheid date.saved mailbox Junk 299
date.saved: 2019-07-25 03:54:14

In fact, MANY messages have this same timestamp.

I can't find the "true" first message timestamp, but the first one
not in July is 107:
[~]# doveadm fetch -u cepheid date.saved mailbox Junk 107
date.saved: 2019-05-29 05:57:55

This seems... not right.

The results are similarly strange for my other users.
> 2. That timestamp should also be the same in dovecot.list.index:
> doveadm mailbox status -u user firstsaved Junk"
For this I get:

[~]# doveadm mailbox status -u cepheid firstsaved Junk
Junk firstsaved=1563154976

I can't tell how that timestamp corresponds to a human-readable date,
however.

Cheers and thanks.

--- Amir


-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<https://dovecot.org/pipermail/dovecot/attachments/20190812/5e50a933/attachment.html>

* Amir Caspi via dovecot, 12.08.19 22:01
> [~]# doveadm mailbox status -u cepheid firstsaved Junk
> Junk firstsaved=1563154976
> 
> I can't tell how that timestamp corresponds to a human-readable date,
however.
[zlatko at disclosure:~]$ date -d @1563154976
Mon Jul 15 03:42:56 CEST 2019

HTH,
Thomas

On Aug 12, 2019, at 8:54 PM, Thomas Zajic via dovecot <dovecot at
dovecot.org> wrote:
> 
> * Amir Caspi via dovecot, 12.08.19 22:01
> 
>> [~]# doveadm mailbox status -u cepheid firstsaved Junk
>> Junk firstsaved=1563154976
>> 
>> I can't tell how that timestamp corresponds to a human-readable
date, however.
> 
> [zlatko at disclosure:~]$ date -d @1563154976
> Mon Jul 15 03:42:56 CEST 2019
So this is the same timestamp as date.saved on message 1... as it should be, I
guess.  Except that, as I showed, the timestamps are definitely messed up
somehow.  The timestamps in my MUA (whether webmail or local mail app) show just
fine... so something seems to be corrupted with the timestamps in the dovecot
index file, I think.  But the weird thing is that this is affecting all users,
not just me.

Hopefully we can figure this out.

--- Amir