1346: Optimize database (Complete) Never Ends [#7316]

Beta Testing for Windows Products and plugins

Moderator: Gurus

MDominik13
Posts: 106
Joined: Mon Jun 27, 2005 2:47 pm

1346: Optimize database (Complete) Never Ends [#7316]

Post by MDominik13 » Tue Feb 01, 2011 11:47 am

I previously reported that there was a problem in that the process took a while and the cancel option didn't work. The cancel part of the bug has been resolved as the button has been disabled.

Now the bigger issue is the library maintenance never completes when the "Complete" option is selected. "Quick" works fine.

Mike

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

Re: Optimize database (Complete) Never Ends

Post by Lowlander » Tue Feb 01, 2011 12:02 pm

It seems to be taking really long so far, so it seems you might be right.
Lowlander (MediaMonkey user since 2003)

MDominik13
Posts: 106
Joined: Mon Jun 27, 2005 2:47 pm

Re: 1346: Optimize database (Complete) Never Ends

Post by MDominik13 » Tue Feb 01, 2011 12:08 pm

It appears to be stuck in a loop... I'm not sure what (if any) tools there are to monitor activity on a SQLite database but I have been capturing snapshots of the journal files. What little I can read in the file seems to be repeating.

nohitter151
Posts: 23640
Joined: Wed Aug 09, 2006 10:20 am
Location: NJ, USA
Contact:

Re: 1346: Optimize database (Complete) Never Ends

Post by nohitter151 » Tue Feb 01, 2011 12:11 pm

I am able to finish it here, it took between 5 and 10 minutes for a database that is about 34 MB.
MediaMonkey user since 2006
Need help? Got a suggestion? Can't find something?

Please no PMs in reply to a post. Just reply in the thread.

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

Re: 1346: Optimize database (Complete) Never Ends

Post by Lowlander » Tue Feb 01, 2011 12:22 pm

It did eventually finish here on a 25MB database.
Lowlander (MediaMonkey user since 2003)

MDominik13
Posts: 106
Joined: Mon Jun 27, 2005 2:47 pm

Re: 1346: Optimize database (Complete) Never Ends

Post by MDominik13 » Tue Feb 01, 2011 12:31 pm

Ok, I'll try again and let it go to see what happens... my database is over 200MB so it may be a while. I'll let you know once it completes (or I give up).

MDominik13
Posts: 106
Joined: Mon Jun 27, 2005 2:47 pm

Re: 1346: Optimize database (Complete) Never Ends

Post by MDominik13 » Tue Feb 01, 2011 1:40 pm

Guess patience is a virtue, huh? It took just over 1 hour to complete.

Dreadlau
Posts: 1967
Joined: Sun Nov 25, 2007 6:49 am

Re: 1346: Optimize database (Complete) Never Ends

Post by Dreadlau » Thu Feb 03, 2011 8:51 am

Wow 1h seems excessively long.
Seven Ultimate X64 SP1 / Sansa Clip 2go (with RockBox)

vpsaxman
Posts: 288
Joined: Sun Oct 03, 2010 7:39 pm

Re: 1346: Optimize database (Complete) Never Ends

Post by vpsaxman » Thu Feb 03, 2011 10:18 am

Last time I did the complete optimization it took almost 4 hours...
Windows 7 Ultimate 64bit
AMD Phenom II x4 940 (3GHz)
ASRock A780
4GB DDR2 333
ATI Radeon HD 3200
Library on two disks : Western Digital Caviar 1.5TB - WDC 640GB

MDominik13
Posts: 106
Joined: Mon Jun 27, 2005 2:47 pm

Re: 1346: Optimize database (Complete) Never Ends

Post by MDominik13 » Thu Feb 03, 2011 11:16 am

Yeah, even though it finally completed, there's definitely something wrong here.

nohitter151
Posts: 23640
Joined: Wed Aug 09, 2006 10:20 am
Location: NJ, USA
Contact:

Re: 1346: Optimize database (Complete) Never Ends

Post by nohitter151 » Thu Feb 03, 2011 2:44 pm

MDominik13 wrote:Yeah, even though it finally completed, there's definitely something wrong here.
vpsaxman wrote:Last time I did the complete optimization it took almost 4 hours...
Dreadlau wrote:Wow 1h seems excessively long.
I don't know, did you see the tooltip?
Image
MediaMonkey user since 2006
Need help? Got a suggestion? Can't find something?

Please no PMs in reply to a post. Just reply in the thread.

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

Re: 1346: Optimize database (Complete) Never Ends

Post by Lowlander » Thu Feb 03, 2011 2:46 pm

But it never took this long in MM3, so it does seem something has changed.
Lowlander (MediaMonkey user since 2003)

MDominik13
Posts: 106
Joined: Mon Jun 27, 2005 2:47 pm

Re: 1346: Optimize database (Complete) Never Ends

Post by MDominik13 » Thu Feb 03, 2011 4:35 pm

No, I didn't see the tooltip. Was it in MM3 as well? As Lowlander pointed out, it never took this long for me in MM3. Pretty much the same database took several minutes but not hours.

Ludek
Posts: 3011
Joined: Fri Mar 09, 2007 9:00 am

Re: 1346: Optimize database (Complete) Never Ends

Post by Ludek » Thu Feb 03, 2011 8:55 pm

MDominik13 wrote:No, I didn't see the tooltip. Was it in MM3 as well? As Lowlander pointed out, it never took this long for me in MM3. Pretty much the same database took several minutes but not hours.

When complete optimizing is performed then there is re-created also the full-text search index for each song, this was added in MM 3.1 and can take quite a lot of time.
You can run DbgView and if you will see instant "INSERT INTO SongText .... " SQL queries then it is the full-text search index recreating.

MDominik13
Posts: 106
Joined: Mon Jun 27, 2005 2:47 pm

Re: 1346: Optimize database (Complete) Never Ends

Post by MDominik13 » Thu Feb 03, 2011 9:49 pm

I'll try that to see what's going on. I definitely ran the full optimization in 3.1 and it didn't take this long.

Post Reply