mailboxes.db vs IMAP client irregularities

[Bron Gondwana]

On Sat, May 19, 2012, at 11:53 AM, Stephen Ingram wrote:
> On Sat, May 19, 2012 at 10:59 AM, Bron Gondwana <brong at fastmail.fm> wrote:
> > On Sat, May 19, 2012 at 09:51:38AM -0700, Stephen Ingram wrote:
> >> I'm running 2.4.13 from the invoca rpms on CentOS 5.8. I recently had
> >
> > Could be sort order bugs with 2.4.13 if you don't have
> > improved_mboxlist_sort turned on.
> >
> >> I've dumped the mailboxes.db file to a flat file to look and see if
> >> there is anything in there that wasn't visible in cyradm or using
> >> cyr_dbtool show. Everything is as expected except there are some
> >> DELETED.user.xxx.folder entries at the top. Are you not allowed the
> >> create folders with the same name you've just deleted? Where are these
> >> DELETED folders actually stored and how long does it take them to go
> >> away? (I'm not using delayed expunge.)
> >
> > Do you have folder names like:
> >
> > user.xxx
> > user.xxx.fol der
> > user.xxx.fol.stuff
> >
> > rather than:
> >
> > user.xxx
> > user.xxx.fol.stuff
> > user.xxx.fol der
> >
> > A fix is to upgrade to a new version of 2.4.x.
> 
> Are you saying that the sort order could be wrong or that the
> incorrect sort order could be causing the other issues I'm seeing?

The sort order causes LIST to suppress output lines that it should
not - hence the folder doesn't appear in the output - but it can't
be created either, because it's already there.  It can still be
deleted fine.

> Should I just remove those DELETED folder entries? They don't seem to
> exist anywhere in the file system.

They shouldn't matter.  They will be cleaned up by cyr_expire later.

> With your mention of bugs though, I went through the bugs fixed from
> 2.14-2.16 and I see bug 2685. That sort of sounds like what I'm
> experiencing. It sounds like I should upgrade before spending too much
> more time on this.

Yes, that's the best idea :)

Bron.
-- 
  Bron Gondwana
  brong at fastmail.fm