Lighthouse has a new layout. Prefer the old one? Return to the old layout, and switch back any time from the link at the top of each page.

Rebuild Database Endless Loop

#821

MailMate crashed pretty badly for me about 10 days ago and I ended up downloading all my messages again. It's just crashed again (or, at least, my Mac crashed and MailMate now has a DB inconsistency). When I click on the Rebuild from cache option on startup and restart, I just get presented with that same window again, over and over and over. I know from last time that the only option will be to re-download all my message (several GB), which I want to avoid.

I've tried both the terminal command for rebuilding the DB and also restarting MailMate via the Terminal, neither of which helped. I'm still stuck in this loop.

Any ideas?

Best,

Andy

Reported by Andy Polaine · June 19th, 2014 @ 10:50 AM

State: new
Milestone: none
Assigned to: benny benny

Activity

  1. benny
    benny

    Sorry to hear about your troubles with MailMate.

    Which revision of MailMate are you using? (See the About window.)

    Have you allowed MailMate to send crash reports? (General Preferences pane.)

    You can use the Software Update preferences pane to get the latest beta, but you might want to use the latest revision I've uploaded although it hasn't been tested much (more about this in ticket #816).

    June 19th, 2014 @ 11:01 AM

  2. Andy Polaine
    Andy Polaine

    Hi Benny,

    I’m using 1.7.2 according to the app info. I can’t open the app itself because I get stuck at the database rebuild window, so I can’t check whether crash reports are being sent. I’m not seeing any Console crash reports though.

    Is the latest beta going to help if my database isn’t working?

    Best,

    Andy

    June 19th, 2014 @ 11:29 AM

  3. benny
    benny

    I did fix a bug related to the rebuild window at some point, but it's not certain that it fixes your problem. In any case, since it's not working then it doesn't hurt to try the cutting edge release linked to in ticket #816: http://updates.mailmate-app.com/archives/MailMate_r4334.tbz

    If that doesn't work then I'll provide further instructions.

    June 19th, 2014 @ 11:32 AM

  4. Andy Polaine
    Andy Polaine

    The latest release didn't get me out of the loop unfortunately. The next option would be to re-download the mail I guess, but I'd prefer to avoid that at all costs!

    Best,

    Andy

    June 19th, 2014 @ 11:51 AM

  5. benny
    benny

    Thanks for trying. What is the error reported in the rebuild window?

    How many messages do you have in MailMate (estimated)?

    June 19th, 2014 @ 11:58 AM

  6. Andy Polaine
    Andy Polaine

    I get:

    Real size is smaller than expected size (1093 < 1130): /Users/andypolaine/Library/Application Support/MailMate/FilesForRebuilding/Database.noindex/Headers/#flags.cache

    I have a lot of mail (I re-downloaded it ready to archive some it actually, but then had a crash). Around 57,000 message.

    Best,

    Andy

    June 19th, 2014 @ 01:37 PM

  7. benny
    benny

    Ah, I can see why that would lead to a loop. MailMate cannot rebuild from cache if this file is corrupt (and a few others). Some of the other files like this are vital, but this one I believe can be deleted manually. You can do that by removing any files named like this:

    /Users/andypolaine/Library/Application Support/MailMate/FilesForRebuilding/Database.noindex/Headers/#flags.*
    

    Don't do that if the same happens for files named #uid or #source! Worst case, I think you'll risk uploading all of your messages to the server and generate duplicates.

    (The fact that the file is corrupt is a bad sign though. I don't know how that could have happened without a hardware crash or restoring from a backup.)

    57K messages should be fine, but it could of course be slow to fetch all messages with some IMAP servers (such as Gmail because of throttling).

    June 19th, 2014 @ 01:52 PM

  8. Andy Polaine
    Andy Polaine

    Thanks, that triggered the rebuild. I have about 20 mins of rebuilding to wait for and I'll let you know how it goes.

    The crash may have been something else, but I had to force restart my laptop and that probably corrupted things.

    June 19th, 2014 @ 02:06 PM

  9. Andy Polaine
    Andy Polaine

    This worked, by the way. Sorry, I forgot to respond. I'm still getting frequent crashes (and subsequent long rebuilds) though.

    September 5th, 2014 @ 01:23 PM

  10. benny
    benny
    • State changed from new to resolved

    You should update to the latest test release. You may be suffering some bugs in the test version you have now: Hold down ⌥ when clicking “Check Now” in the Software Update preferences pane. Let me know if it doesn't help. Rebuilds should happen very rarely and it is always fine to contact me when it happens.

    September 5th, 2014 @ 01:27 PM

Please Sign in or create a free account to add a new ticket.

With your very own profile, you can contribute to projects, track your activity, watch tickets, receive and update tickets through your email and much more.