1190 Database garbage collection?? [#5670]

[chrisjj]

When is MM supposed to remove unused records from the database?

I ask because my MM.DB file has thousands of records in Table: DeviceTracks for a Device that was long ago deleted and does not show in Table: Devices.

Thanks.

[rovingcowboy]

when you go to menu bar >file> clean library
that should find and clear out your trash listings.

[nohitter151]

when you go to menu bar >file> clean library
that should find and clear out your trash listings.

I think RC means File | Maintain Library | Compact database

Whether or not that actually removes the entries I'm not sure.

[rovingcowboy]

when you go to menu bar >file> clean library
that should find and clear out your trash listings.

I think RC means File | Maintain Library | Compact database

Whether or not that actually removes the entries I'm not sure.

sorry for the mix up i just said what it does but it is the maintain library link like nohitter151 reminded me,
getting forgetful more i guess must be low on caffeine

[chrisjj]

> I think RC means File | Maintain Library | Compact database

Thanks both. So MM doesn't do it's own garbase collection? Just lets garbage collect until the use discovers this command?

> Whether or not that actually removes the entries I'm not sure.

It doesn't here. I.e. it leaves DeviceTracks showing 1000-odd records fro Device 13.... though Devices shows only 1 to 11.

[nohitter151]

> I think RC means File | Maintain Library | Compact database

Thanks both. So MM doesn't do it's own garbase collection? Just lets garbage collect until the use discovers this command?

Right.

> Whether or not that actually removes the entries I'm not sure.

It doesn't here. I.e. it leaves DeviceTracks showing 1000-odd records fro Device 13.... though Devices shows only 1 to 11.

Can't say I'm surprised

[chrisjj]

> Right.

That's poor.

> Can't say I'm surprised

Thanks.

[rovingcowboy]

now to be fair monkey will remove them.

you need to have the options checked in the main options panel to remove unused artists and unused albums.

then when you rescan the files monkey will remove the ones that are not used. so he does keep up with them but you need to scan either way. or use the auto organizer and have it remove the unused stuff also.

but you still got to scan or re arrange your library or scan the database to clean it up.

monkey wont' do an automatic garbage pick up. sorry you have to take it to the dump your self, but don't feel bad we're all in the same situation.

oh yeah i got more caffeine

[nynaevelan]

I have to agree with Chris on this one. Although I have not had trouble with the DeviceTracks table, the PlaylistSongs table has alot of garbage left behind in it. Thanks to a script by MoDementia, I am able to keep that table clean of the junk. I won't even waste energy wondering how many other tables have the same problem. But this garbage cleanup should be something that is inherent in MM, rather than having to use scripts and sql statements to clean them up. The monkey should do a better job of keeping it's cage clean.

Nyn

[chrisjj]

> you need to have the options checked in the main options panel to remove unused artists and unused albums.

Uh? We're talking about orphan tracks here NH. Not unused albums or artists. Anyway, I don't want unused nodes removed.

> but you still got to scan or re arrange your library or scan the database to clean it up.

"Scan my database" is fine - how do I do that?

"Rearrange my library" is not fine... and due to the limitations of Add/Rescan, I think there is no way I can easy rescan my library, since it is an irregular clutch of locations.

> don't feel bad we're all in the same situation.

Thanks for the company!

[nohitter151]

> you need to have the options checked in the main options panel to remove unused artists and unused albums.

Uh? We're talking about orphan tracks here NH. Not unused albums or artists. Anyway, I don't want unused nodes removed.

That was RC, not me.

[chrisjj]

> That was RC, not me.

Oops, sorry both.

[rovingcowboy]

it should not remove the nodes it should remove the unused artists and unused albums. i believe it removes the folders that are empty but still in monkeys database, which is what sounds like you are having the trouble with.

• When is MM supposed to remove unused records from the database?
  
  I ask because my MM.DB file has thousands of records in Table: DeviceTracks for a Device that was long ago deleted and does not show in Table: Devices.

in scanning your database it is with the maintance link that nohitter151 pointed out i typed wrong. use his link to it and that should just scan the database file and not the folders.

re scanning the music files and re organizing the library both scan the folders..

[nynaevelan]

I'm a little confused, Chris I thought you were questioning why the tracks were not being removed from the DeviceTracks tables that are linked to devices that no longer exist in your db? How did the subject get to unused albums/artists? These are two different things....

Nyn

[chrisjj]

> it should not remove the nodes it should remove the unused artists and unused albums.

Here each unused artist and unused album does appear as a node.

> i believe it removes the folders that are empty but still in monkeys database,
> which is what sounds like you are having the trouble with.

My trouble is not with folders but tracks, and tracks that are al still 'used' i.e. in the library.

> in scanning your database it is with the maintance link that nohitter151 pointed out i
> typed wrong. use his link to it and that should just scan the database file and not the folders.

OK, but that just does a compact - which normally means simply removing unwanted empty space - it does not remove these orphan records.

> re scanning the music files and re organizing the library both scan the folders..

I tried an Add/Rescan of one HD folder containing some affected tracks and it makes no improvement.

Thanks for the suggestions.