1346: Optimize database (Complete) Never Ends [#7316]
Moderator: Gurus
-
- Posts: 106
- Joined: Mon Jun 27, 2005 2:47 pm
1346: Optimize database (Complete) Never Ends [#7316]
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
Now the bigger issue is the library maintenance never completes when the "Complete" option is selected. "Quick" works fine.
Mike
Re: Optimize database (Complete) Never Ends
It seems to be taking really long so far, so it seems you might be right.
Download MediaMonkey | License
Help: Knowledge Base | MediaMonkey for Windows 5 | MediaMonkey for Android
Lowlander (MediaMonkey user since 2003)
Help: Knowledge Base | MediaMonkey for Windows 5 | MediaMonkey for Android
Lowlander (MediaMonkey user since 2003)
-
- Posts: 106
- Joined: Mon Jun 27, 2005 2:47 pm
Re: 1346: Optimize database (Complete) Never Ends
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.
-
- Posts: 23640
- Joined: Wed Aug 09, 2006 10:20 am
- Location: NJ, USA
- Contact:
Re: 1346: Optimize database (Complete) Never Ends
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.
Need help? Got a suggestion? Can't find something?
Please no PMs in reply to a post. Just reply in the thread.
Re: 1346: Optimize database (Complete) Never Ends
It did eventually finish here on a 25MB database.
Download MediaMonkey | License
Help: Knowledge Base | MediaMonkey for Windows 5 | MediaMonkey for Android
Lowlander (MediaMonkey user since 2003)
Help: Knowledge Base | MediaMonkey for Windows 5 | MediaMonkey for Android
Lowlander (MediaMonkey user since 2003)
-
- Posts: 106
- Joined: Mon Jun 27, 2005 2:47 pm
Re: 1346: Optimize database (Complete) Never Ends
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).
-
- Posts: 106
- Joined: Mon Jun 27, 2005 2:47 pm
Re: 1346: Optimize database (Complete) Never Ends
Guess patience is a virtue, huh? It took just over 1 hour to complete.
Re: 1346: Optimize database (Complete) Never Ends
Wow 1h seems excessively long.
Seven Ultimate X64 SP1 / Sansa Clip 2go (with RockBox)
Re: 1346: Optimize database (Complete) Never Ends
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
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
-
- Posts: 106
- Joined: Mon Jun 27, 2005 2:47 pm
Re: 1346: Optimize database (Complete) Never Ends
Yeah, even though it finally completed, there's definitely something wrong here.
-
- Posts: 23640
- Joined: Wed Aug 09, 2006 10:20 am
- Location: NJ, USA
- Contact:
Re: 1346: Optimize database (Complete) Never Ends
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...
I don't know, did you see the tooltip?Dreadlau wrote:Wow 1h seems excessively long.
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.
Need help? Got a suggestion? Can't find something?
Please no PMs in reply to a post. Just reply in the thread.
Re: 1346: Optimize database (Complete) Never Ends
But it never took this long in MM3, so it does seem something has changed.
Download MediaMonkey | License
Help: Knowledge Base | MediaMonkey for Windows 5 | MediaMonkey for Android
Lowlander (MediaMonkey user since 2003)
Help: Knowledge Base | MediaMonkey for Windows 5 | MediaMonkey for Android
Lowlander (MediaMonkey user since 2003)
-
- Posts: 106
- Joined: Mon Jun 27, 2005 2:47 pm
Re: 1346: Optimize database (Complete) Never Ends
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.
Re: 1346: Optimize database (Complete) Never Ends
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.
-
- Posts: 106
- Joined: Mon Jun 27, 2005 2:47 pm
Re: 1346: Optimize database (Complete) Never Ends
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.