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?
MM4 DB 24GB after Optimize (Complete)
Moderator: Gurus
MM4 DB 24GB after Optimize (Complete)
JClouseau
artist in all things
programmer/analyst by trade
cowboy at heart
artist in all things
programmer/analyst by trade
cowboy at heart
Re: MM4 DB 24GB after Optimize (Complete)
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.
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.
Best regards,
Peke
MediaMonkey Team lead QA/Tech Support guru
Admin of Free MediaMonkey addon Site HappyMonkeying
How to attach PICTURE/SCREENSHOTS to forum posts
Peke
MediaMonkey Team lead QA/Tech Support guru
Admin of Free MediaMonkey addon Site HappyMonkeying
How to attach PICTURE/SCREENSHOTS to forum posts
Re: MM4 DB 24GB after Optimize (Complete)
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):
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.
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
- close MM5
- copy MM5.db to MM4 portable and rename db to MM.db
- open MM4 portable (and hope for the best)
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.
JClouseau
artist in all things
programmer/analyst by trade
cowboy at heart
artist in all things
programmer/analyst by trade
cowboy at heart
Re: MM4 DB 24GB after Optimize (Complete)
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)
The file size is back down to 641MB, but need to have MM4 do search indexing (because nothing comes up on a search)
JClouseau
artist in all things
programmer/analyst by trade
cowboy at heart
artist in all things
programmer/analyst by trade
cowboy at heart