Hi
Whenever my PC goes to sleep with MM running, I get loads of error messages after wake up "Error executing SQL statement" and "disk I/O error (10, 10)".
I can press Cancel, Repeat or Ignore, either way the error messages come again and MM isn't usable.
Sometimes MM doesn't completely close and locks the MM.Db, so at the next start of MM it wants to create a new database.
My MM.DB and files are on a NAS. MM is installed in portable mode on Windows 10 64Bit.
The problem exists since a longer time, don't know how long, but recently I used MM more so it annoys me enough now to post this.
Is it a known problem? Any idea how to solve?
Disk I/O error after PC sleep
Moderator: Gurus
Re: Disk I/O error after PC sleep
The problem is that the connection the NAS is lost/drives on NAS are asleep and thus MediaMonkey can't access the database. This causes the disk I/O problem.
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)
Re: Disk I/O error after PC sleep
Thanks for your reply.
It would be better for MM to:
I tested the availability of the NAS and it takes less than 3 seconds until content on the NAS can be accessed again after wake up.
I think the current behavior of MM is a bug. What do you think?
It would be better for MM to:
- Wait until the NAS is available again or a time out of e.g. 10 seconds is reached
- Display a message like "Database folder not available at the moment. Maybe the system was in sleep mode. Shall we try again? OK/Cancel"
I tested the availability of the NAS and it takes less than 3 seconds until content on the NAS can be accessed again after wake up.
I think the current behavior of MM is a bug. What do you think?
Sync Back Ratings & Play Count, Sync stats for Android PlayerPro XML, Import music stats from Songbird XML
Recognize badly mastered music - detect clipping and compression
MMW Gold since 2009, MMA Pro since 2014.
Recognize badly mastered music - detect clipping and compression
MMW Gold since 2009, MMA Pro since 2014.
Re: Disk I/O error after PC sleep
Hi,
I do not think that is a bug, but as Lowlander explained windows access bug.
Are you using MMW installed portable on NAS or you use custom DB location? Either way can you post path to MM.DB you are accessing?
I do not think that is a bug, but as Lowlander explained windows access bug.
Are you using MMW installed portable on NAS or you use custom DB location? Either way can you post path to MM.DB you are accessing?
Best regards,
Peke
MediaMonkey Team lead QA/Tech Support guru
Admin of Free MediaMonkey addon Site HappyMonkeying
How to attach PICTURE/SCREENSHOTS to forum posts
Peke
MediaMonkey Team lead QA/Tech Support guru
Admin of Free MediaMonkey addon Site HappyMonkeying
How to attach PICTURE/SCREENSHOTS to forum posts
Re: Disk I/O error after PC sleep
Hi
MMW is installed on the local drive C: in portable mode, MM DB has a custom location on the NAS, DBName=\\nas\Music\!MediaMonkeyDB!\MM.DB
MMW is installed on the local drive C: in portable mode, MM DB has a custom location on the NAS, DBName=\\nas\Music\!MediaMonkeyDB!\MM.DB
Sync Back Ratings & Play Count, Sync stats for Android PlayerPro XML, Import music stats from Songbird XML
Recognize badly mastered music - detect clipping and compression
MMW Gold since 2009, MMA Pro since 2014.
Recognize badly mastered music - detect clipping and compression
MMW Gold since 2009, MMA Pro since 2014.
Re: Disk I/O error after PC sleep
Hi,
Hmmm. lets make small test?
Can you copy \\nas\Music\!MediaMonkeyDB!\MM.DB to Portable subfolder -> remove custom location and try to replicate. I tried to replicate and only way I can get I/O error is when NAS HDD was a sleep and it takes 5s to spinup and remount shared folder. That behavior is normal as MM tried 100 to access MM.DB.
Hmmm. lets make small test?
Can you copy \\nas\Music\!MediaMonkeyDB!\MM.DB to Portable subfolder -> remove custom location and try to replicate. I tried to replicate and only way I can get I/O error is when NAS HDD was a sleep and it takes 5s to spinup and remount shared folder. That behavior is normal as MM tried 100 to access MM.DB.
Best regards,
Peke
MediaMonkey Team lead QA/Tech Support guru
Admin of Free MediaMonkey addon Site HappyMonkeying
How to attach PICTURE/SCREENSHOTS to forum posts
Peke
MediaMonkey Team lead QA/Tech Support guru
Admin of Free MediaMonkey addon Site HappyMonkeying
How to attach PICTURE/SCREENSHOTS to forum posts
Re: Disk I/O error after PC sleep
Hi
When the DB is in the Portable folder on the local drive, it works without errors.
What do you mean by "MM tried 100 to access MM.DB"?
When the DB is on the NAS, I get the errors even when the NAS HD wasn't sleeping.
When the DB is in the Portable folder on the local drive, it works without errors.
What do you mean by "MM tried 100 to access MM.DB"?
When the DB is on the NAS, I get the errors even when the NAS HD wasn't sleeping.
Sync Back Ratings & Play Count, Sync stats for Android PlayerPro XML, Import music stats from Songbird XML
Recognize badly mastered music - detect clipping and compression
MMW Gold since 2009, MMA Pro since 2014.
Recognize badly mastered music - detect clipping and compression
MMW Gold since 2009, MMA Pro since 2014.
Re: Disk I/O error after PC sleep
Hi,
Unfortunately if Local copy works something breaks MMW connection to DB, I meant that MMW tries 100 Times to retry to restore connection and access to DB before throw error.
MMW needs to have constant access to DB as some users have DB sized multiple GB and loading that to memory is not an option due the performance issues.
WiFi connection is unstable on many hardware (which I found out once I bought ASUS RT-AX92U duo Air Mesh set and Switched to WiFi 6(AX) band) which due the cycling of channels and devices can cut connection and takes 1-2s restore it.
Something makes things cutting connection for you.
Unfortunately if Local copy works something breaks MMW connection to DB, I meant that MMW tries 100 Times to retry to restore connection and access to DB before throw error.
MMW needs to have constant access to DB as some users have DB sized multiple GB and loading that to memory is not an option due the performance issues.
WiFi connection is unstable on many hardware (which I found out once I bought ASUS RT-AX92U duo Air Mesh set and Switched to WiFi 6(AX) band) which due the cycling of channels and devices can cut connection and takes 1-2s restore it.
Something makes things cutting connection for you.
Best regards,
Peke
MediaMonkey Team lead QA/Tech Support guru
Admin of Free MediaMonkey addon Site HappyMonkeying
How to attach PICTURE/SCREENSHOTS to forum posts
Peke
MediaMonkey Team lead QA/Tech Support guru
Admin of Free MediaMonkey addon Site HappyMonkeying
How to attach PICTURE/SCREENSHOTS to forum posts