Re: Deleting "ghost" mailboxes that don't correspond to filesystem directories

Quoting Jay Sekora <[email protected]>:

> On Tue, Mar 04, 2025 at 08:51:42PM +0100, Michael Menge wrote:
>> Check for "space" at the end of the folder name. The columns are "tab"
>> seperated.
>
> Yes, a couple of them had trailing spaces (which I noticed and quoted
> appropriately) but most of them didn't.
>
>> Also you can try to use "reconstruct -r user.[redacted]" or
>> "reconstruct -u [redacted]"
>
> That produces "I/O error".

just to check, the mailbox "user.[redacted]" does still exist?
you can try to create the folder in the filesystem, and set user
and group and then try reconstruct again.

Also you can use "strace -o /tmp/reconstruct.trace reconstruct -r  
user.[redacted]"
this will give you a ton of systemcalls but at the end you will most  
likely see
the directories/files that cyrus does try to access and the error message.

>
>> === !!! WARNING USE WITH CAUTION !!! ====
>>
>> If you are sure that the folder does not exist anymore on the file system
>> and EVERTHING else failed you can try to remove the entries from the
>> mailboxes.db.
>
> Thanks for the instructions!  I think this is what I'll have to do, and
> of course that will require a time when I can schedule downtime.
>
> (I probably won't bother doing it on the old server but will just write
> my tools to prune out known-bad folder names.  But this will be useful
> on the new server, and I can do it as part of the downtime when we cut
> over.)
>
> It would be nice if there were a command-line tool to fix the database when
> it gets out of synch with reality like this (either a tool to remove a
> specific mailbox database entry, or a tool to find mailboxes know to the
> database that don't correspond to a folder in the the filesystem and ask
> what to do about them).
>
> Better yet would be if cyradm's deletemailbox command just worked in this
> case (perhaps if given an "-f" flag or after a warning and confirmation).
>

There is the cyr_dbtool that can manipulate cyrus databases while  
cyrus is running,
It is a powerful tool that can fix some problems if you know what you  
are doing,
but it can also create big problems if you are not very careful.




--
--------------------------------------------------------------------------------
Michael Menge                          Tel.: (49) 7071 / 29-70316
Universität Tübingen                   Fax.: (49) 7071 / 29-5912
Zentrum für Datenverarbeitung          mail:  
[email protected]
Wächterstraße 76
72074 Tübingen


------------------------------------------
Cyrus: Info
Permalink: https://cyrus.topicbox.com/groups/info/Te4b694eca4c5d369-M89a5a95710325b76d1d4c356
Delivery options: https://cyrus.topicbox.com/groups/info/subscription