Rebuild Database now running 24 hours.....

[gregorywest]

I did a rebuild of my MMW database. It has been running now for 24 hours. There is no indication as to where it is or how much has been done. Is there any way I can check the database itself a see what is going on? (was a DBA before retiring)

Some of these longer processes like database rebuild should have some sort of indicator that they are still running. Even if just an incremental counter of how many records have been dealt with.

Greg

[Lowlander]

Which build of MedaMonkey are you using?

[gregorywest]

I am build 3517. Same status, and it has been 48 hours.

Greg

P.S. I ran the rebuild kind of hoping it would clean up all the duplicate records I have..... Does not look like that happened.

[Lowlander]

No it wouldn't, you need to use the duplicate management options instead: https://www.mediamonkey.com/wiki/WebHel ... Duplicates

[gregorywest]

Don't think that fits my problem. I do not have duplicate MP3 files. I have duplicate entries in the database for the same file.

[Lowlander]

Still would work the same way.

Did MediaMonkey 2027 create the duplicates?

[gregorywest]

Yes MMW created the duplicates when it did the Manage database -> Convert mapped drives to UNC paths.

I am guessing I have between 90,000 and 150,000 duplicates like this.

Greg

[Peke]

Hi,
I guess you created backups? If yes can you please Upload one of latest backups before you updated MM 2027 to latest build and ZIP your current MM5.DB Then can you please Create support Ticket and supply us with download URL so that we can do analyze. I have Tested remapping Mapped -> UNC on approx 200k of tracks and Mm did not created single duplicate.

[gregorywest]

I am zip up the DB. Then you did the convert did you have the same entries in two places? ie M;\Music and \\10.10.10.10\vol\Music? This is how I got the duplicates.

Greg

[Peke]

Hi,
no all were converted to \\10.10.10.10\vol\Music

[gregorywest]

Tables sent ticket #18363: "MMW 3517 convert paths to UNC duplicated entries".

[Peke]

Tables sent ticket #18363: "MMW 3517 convert paths to UNC duplicated entries".

DL link is not available anymore

[gregorywest]

The link to the two files should be: [Redacted For Privacy].

Thought I sent it before, but do not see it anywhere.....

Greg

[Peke]

Hi,
Well thanks Greg for pointing out MM is not Perfect Really good catch.

Bug added at https://www.ventismedia.com/mantis/view.php?id=22342