Tool for display setup - also recovery after db corruption

Post a reply


In an effort to prevent automatic submissions, we require that you complete the following challenge.
Smilies
:D :) :( :o :-? 8) :lol: :x :P :oops: :cry: :evil: :roll: :wink:

BBCode is ON
[img] is ON
[flash] is OFF
[url] is ON
Smilies are ON

Topic review
   

Expand view Topic review: Tool for display setup - also recovery after db corruption

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

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

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

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

Try a backup then a full library maintenance

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

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.

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

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.

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

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.

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

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.

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

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.

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

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

I assume you are not using Portable version of MMW?

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

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

I have no plug-ins installed.

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

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

What Addons/plugins you use? Any of them directly Manipulate MM.DB?

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

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.

Tool for display setup - also recovery after db corruption

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.

Top