Tool for display setup - also recovery after db corruption

Any ideas about how to improve MediaMonkey? Let us know!

Moderator: Gurus

terryo
Posts: 127
Joined: Thu Oct 06, 2011 9:11 pm

Tool for display setup - also recovery after db corruption

Post by terryo » Wed Dec 14, 2016 11:26 am

I wish there was a way to standardize the arrangement of columns for all libraries and playlists. I use the same configuration on everything and wish I could fix it outside the database.

Just had to do my third recovery from a corrupted database by deleting mm.db (happens about once a year). Despite the notice that this "will not delete any of your... configurations", a recovery done by deleting mm.db wipes all the layout configurations I've arranged on all my libraries and playlists. Resetting all these individually is a real pain in the ass.

NewtonBoy
Posts: 134
Joined: Tue Nov 23, 2010 1:52 pm

Re: Tool for display setup - also recovery after db corrupti

Post by NewtonBoy » Thu Dec 15, 2016 7:57 am

That has always been one of my frustrations as well.

Every time I have to re-configure from scratch I get more irritated with the columns behavior when I setup a new collection.
Media Monkey Gold 4.1.14.1813 Portable
Windows 10 anniversary, i5, 8GB Ram, 256GB SSD, Library on External drive
14MB Media Monkey Database
929 GB Library

Peke
Posts: 12195
Joined: Tue Jun 10, 2003 7:21 pm
Location: Serbia
Contact:

Re: Tool for display setup - also recovery after db corrupti

Post by Peke » Thu Dec 15, 2016 7:37 pm

What Addons/plugins you use? Any of them directly Manipulate MM.DB?
Best regards,
Pavle
MediaMonkey Team lead QA/Tech Support guru
Admin of Free MediaMonkey addon Site HappyMonkeying
Image
Image
How to add SCREENSHOTS to forum

terryo
Posts: 127
Joined: Thu Oct 06, 2011 9:11 pm

Re: Tool for display setup - also recovery after db corrupti

Post by terryo » Thu Dec 15, 2016 8:26 pm

I have no plug-ins installed.

Peke
Posts: 12195
Joined: Tue Jun 10, 2003 7:21 pm
Location: Serbia
Contact:

Re: Tool for display setup - also recovery after db corrupti

Post by Peke » Mon Dec 19, 2016 7:50 pm

I assume you are not using Portable version of MMW?
Best regards,
Pavle
MediaMonkey Team lead QA/Tech Support guru
Admin of Free MediaMonkey addon Site HappyMonkeying
Image
Image
How to add SCREENSHOTS to forum

terryo
Posts: 127
Joined: Thu Oct 06, 2011 9:11 pm

Re: Tool for display setup - also recovery after db corrupti

Post by terryo » Fri Jan 13, 2017 1:31 pm

I am using the full current version.

And today I just received the message that the database could not be opened. So I'm faced with a rebuild again.

This time I have a month old backup of the database and current backups of my playlists, so it will be less painful. I haven't started the restoration yet. Do you want me to send the corrupted database via Dropbox or do anything else?

I will need to restore MMW this weekend so I can start to prepare for my radio next week.

terryo
Posts: 127
Joined: Thu Oct 06, 2011 9:11 pm

Re: Tool for display setup - also recovery after db corrupti

Post by terryo » Fri Jan 13, 2017 1:37 pm

My database file is 514 MB for ~160,000 songs.

When I opened the folder with MM.DB, today it contains a file called MM.DB-journal. This file has never been there before. It is 0 KB.

Lowlander
Posts: 45907
Joined: Sat Sep 06, 2003 5:53 pm
Location: MediaMonkey 5

Re: Tool for display setup - also recovery after db corrupti

Post by Lowlander » Fri Jan 13, 2017 2:32 pm

journal is the temp file where transactions are store before they're committed to the database.

What exact error did you get when the database failed to open. I've seen database locked errors, but they don't prevent the database from being used in the end.
Lowlander (MediaMonkey user since 2003)

terryo
Posts: 127
Joined: Thu Oct 06, 2011 9:11 pm

Re: Tool for display setup - also recovery after db corrupti

Post by terryo » Fri Jan 13, 2017 7:24 pm

I was doing a wi-fi sync and I inadvertently closed MMW. No warning message appeared as I did.

A bit later I noticed MMA said incomplete or failed sync.

When I tried to reopen MMW, I got the message the DB was unopenable.

This kind of human activity should be adequately protected by code. It's not like I popped the hood and loaded a bunch of plug-ins and tweaks or something.

MMW really needs a way to store layout templates that can be loaded onto any window displaying part of the music library. I need it as an individual and the radio station where I do my show can't consider MMW for their software unless simple displays can be locked to the same column format every time MMW is opened. Otherwise the programmers will freak out every time the display looks slightly different. I love the customizable aspects of MMW, but there are a lot of reasons to be able to rein that in.

terryo
Posts: 127
Joined: Thu Oct 06, 2011 9:11 pm

Re: Tool for display setup - also recovery after db corrupti

Post by terryo » Sat Jan 14, 2017 11:20 am

This morning when I started MMW it inexplicably opened the DB and started up. Took over two minutes of thrashing my SSD C: drive at 100% before anything appeared on the screen. Then it was "reading files" slowly in tiny blocks of 100-200. Took 12 minutes for MMW to become fully usable. C: drive activity was driven to the ceiling the whole time.

dtsig
Posts: 2989
Joined: Mon Jan 24, 2011 6:34 pm

Re: Tool for display setup - also recovery after db corrupti

Post by dtsig » Sat Jan 14, 2017 2:24 pm

Try a backup then a full library maintenance
Where's the db and ini stored
Reporting Bugs
Where tags are stored

Not affiliated with MediaMonkey ... just a RABID user/lover
DTSig

rivorson
Posts: 594
Joined: Thu Jul 25, 2013 4:17 am

Re: Tool for display setup - also recovery after db corrupti

Post by rivorson » Sat Jan 14, 2017 5:28 pm

There are only two times I have seen db corruption. One was when I was running file sync software similar to Dropbox which would try to write the db file while MM was writing to it. The other is when a hard drive was dying and the corruption was caused by drive failure.

I recommend running chkdsk and a SMART test on your drive.
https://hddguardian.codeplex.com/wikipa ... umentation

Post Reply