MM4 DB 24GB after Optimize (Complete)

[Clouseau]

Okay, thoroughly confused now. Started with a 900MB database and thought I needed an Optimize (Complete) run since MM was a bit sluggish on startup.

I watched it for 4 hours as the DB grew in size, eventually growing to 24GB!

I killed the MM process and performed a SQLite Vacuum command which only dropped it to 22GB.

Has anyone experienced this and/or have a potential solution other than (1) reverting to a backup from 2wks ago; or (2) starting over with a clean database?

[Peke]

Hi,
My best suggestion would be to install MM5 portable -> Copy MM.DB -> MM5.DB in Portable folder and after start do Rebuild library. As fro MM4, I guess the best approach would be to revert to week old DB and se eif it will happen again along with full text search reindex.

This is the first time I have ever heard such case.

[Clouseau]

Thanks, Peke.

It seems my database even killed MM5, it's currently a white window not responding to clicks (but still minimizes and restores, so odd).

Steps taken (from gathered research):

• install clean portable version of MM5
• start MM5 once to fully create its INI file
• cancel to 1st time wizard and close MM5
• update MM5 ini file in portable:

[Options]
ForceMM4Compatibility=1
[Portable]
IsPortable=1

• copy MM4 MM.db to MM5 portable directory and rename db to MM5.db
• start MM5
  >>> NOTE: even with "ForceMM4Compatibility" set MM5 still upgraded the database!
• Manage Database, run with:
  • rebuild database checked
  • FTS rebuild checked
  >>> My MM5 session is hung-up HERE
• close MM5
• copy MM5.db to MM4 portable and rename db to MM.db
• open MM4 portable (and hope for the best)

The Portable directory currently has:
an MM5.DB-journal file that has not been updated in over an hour 10MB
an MM5.db file that also has not been updated in over an hour 21GB

So, no way to have MM4 just rebuild the database (without losing play counts, etc.)? Or do you think something was funky when it was only 900MB and the re-index made it grow appropriately to 25GB? Curious.

[Clouseau]

UPDATE: I killed the MM5 process, re-ran the MM5 maintenance, closed MM5 and copied/renamed the DB back to MM4 and I think I'm in business.

The file size is back down to 641MB, but need to have MM4 do search indexing (because nothing comes up on a search)