Hangs when network drops if DB is stored on NW drive [#6672]

[grantdavis]

I have the MM ini file specified to use a DB stored on a network drive, so the DB can be shared between pcs and the instance of MM monitoring the files will be local to the files.

I've just upgraded to 3.05.1187 and confirmed this behavior exists, and previously observed it with 3.04.1185. Using Gold release.

Steps to Repro;
1. Configure MM ini to use DB file on network drive
2. Play song from library, also located on a network share
3. Unplug network cable (or turn off wireless radio)
4. MM stops playing after reaching end of buffer, and the Pause Button goes back to Play. (GOOD!)
5. Click Play again (with or without reconnecting to network).
6. Play button goes back to Pause, but app is unresponsive now.
7. Attempt to Click the Pause button again, or Close the app by clicking the X, and it does not respond.
8. Menus do drop-down, but other than Help->About, clicking most menu items does not respond
9. Must terminate application using taskmgr

This pc is running xpsp3, with no portable devices installed or attached.
I haven't installed debug mode, but I can if it is necessary. All the satellite pcs I have that connect to the DB over the network are running xpsp3 and it happens 10/10 times with these pcs so I don't think it should be difficult to reproduce in-house. Also occurred prior to sp3 installations.

[grantdavis]

Follow-up:

This issue occurs with the MM.ini file specifying the DB location in both UNC format and using a Mapped Network Drive.
The issue also occurs with the library referring to the network location of files in booth UNC format and using a Mapped Network Drive.

(I prefer to use mapped network drives for the library file locations, because then the local machine that is running MM and has the files local does not have to use the network protocal for monitoring files, and is much faster).

I installed debug MM on the client pc which hangs and have the dbgview logs avialble as well.

Below is the area in question

Code: Select all

[2020] Winamp sim - End of track message.
[2020] Track has ended.
[2020] Going to stop playback in dll: C:\Program Files\MediaMonkey\Plugins\in_wmp3.dll
[2020] INWMP3: Stop() started
[2020] INWMP3: Close() started
[2020] INWMP3: StopStream() started
[2020] INWMP3: StopStream() finished
[2020] INWMP3: OnStatus 12.
[2020] INWMP3: OnEndOfStream
[2020] INWMP3: OnStatus 13.
[2020] INWMP3: Close() 1
[2020] INWMP3: Close() 2
[2020] INWMP3: Close() 3
[2020] INWMP3: Close() finished
[2020] INWMP3: StopOutput() started
[2020] MMDS: Close starts
[2020] MMDS: Going to crossfade
[2020] MMDS: Close ends
[2020] INWMP3: StopOutput() finished
[2020] INWMP3: Stop() finished
[2020] Winamp sim - WM_USER message 603
[2020] 5108 DB exec SQL: INSERT INTO Played (IdSong,PlayDate) VALUES (115396,39730.656305937) 
[2020] 5108 DB lock successful.
[2020] MMDS: Crossfaded to the end of track, terminating it now
[2020] MMDS: Buffer.Close() starting.
[2020] MMDS: Buffer.Close() finished.
[2020] Thread has started 4400
[2020] Thread registered, going to initialize 4400
[2020] Thread initialized 4400
[2020] 5108 DB open SQL: SELECT Songs.ID FROM Songs WHERE Songs.ID=? AND ( ( exists (SELECT idTrack FROM PodcastEpisodes WHERE PodcastEpisodes.idTrack = Songs.id)  OR  exists (SELECT null FROM GenresSongs, Genres WHERE GenresSongs.IDSong = Songs.ID AND GenresSongs.IDGenre = Genres.IDGenre AND (Genres.GenreName like '%podcast%'))) ) 
[2272] ftpext: DllMain()
[2272] ftpext: DllCanUnloadNow()
[2272] ftpext: DllMain()
[2272] ftpext: DllMain()
[2020] Forms: Received WM_ACTIVATEAPP
[2020] Forms: Accepted WM_ACTIVATEAPP +
[2020] Forms: RestoreTopMost: Level: 1
[2020] Forms: RestoreTopMost: Starting
[2020] Winamp sim - ignoring.
[2020] Winamp simulation window received messsage 28
[2020] Winamp sim - ignoring.
[2020] Thread has started 3460
[2020] Thread registered, going to initialize 3460
[2020] Thread initialized 3460
[2020] Player: _Play() procedure entering.
[2020] We were asked to finish.
[2020] Delay terminate, we yet have to finish some message processing.
[2020] Forms: Received WM_ACTIVATEAPP
[2020] Forms: Accepted WM_ACTIVATEAPP -
[2020] Forms: NormalizeTopMosts: Level: 0
[2020] Forms: NormalizeTopMost: Starting
[2020] Winamp sim - ignoring.
[2020] Winamp simulation window received messsage 28
[2020] Winamp sim - ignoring.
[2020] Forms: Received WM_ACTIVATEAPP
[2020] Forms: Accepted WM_ACTIVATEAPP +
[2020] Forms: RestoreTopMost: Level: 1
[2020] Forms: RestoreTopMost: Starting
[2020] Winamp sim - ignoring.
[2020] Winamp simulation window received messsage 28
[2020] Winamp sim - ignoring.
[2020] We were asked to finish.
[2020] Delay terminate, we yet have to finish some message processing.
[2020] We were asked to finish.
[2020] Delay terminate, we yet have to finish some message processing.

[adb]

This network problem is easily reproducable in a number of ways. It happens at least once a week to me when

a) I forget to exit MM before I connect my VPN (which prevents local network access). In this case when I disconnect the VPN MM is stuffed. It can still actually play the track I was listening too, but gives the cascading errors reported in b)
b) I put the machine in standby without exiting MM. Overnight my NAS box shuts down an restarts again in the morning. When I bring my machine out of standby it gives problems. I get cascading errors where it typically gives SQL INSERT failure errors. None of cancel/retry/ignore can help the situation and like you I have to kill the process with taskmgr. I'm on XPSP2.

Antony

[adb]

Can this NAS issue be looked at for 3.1??

[adb]

Bump
Still a problem with latest MM and Windows 7

[Lowlander]

Although I'm not surprised that this happens as a major component of the program is taken out when the DB is unavailable I do agree that MediaMonkey should better handle this exception.

I've added it to the bug tracker: http://www.ventismedia.com/mantis/view.php?id=6672

[adb]

Although I'm not surprised that this happens as a major component of the program is taken out when the DB is unavailable I do agree that MediaMonkey should better handle this exception.

I've added it to the bug tracker: http://www.ventismedia.com/mantis/view.php?id=6672

Still a problem with 4.0.6

Seems like nothing has happened in the last 4 years. I don't really understand why others don't have a problem. I'd given up running the DB on a network drive for the last couple of years, but after rebuilding my machine due to a motherboard failure, I thought I'd have another go at a portable network installation - portable - sounds like it should handle these things right..???

1. Start playing a track
2. Stop the track
3. Put machine to sleep
4. Bring out of sleep
5. Continue playing track

The track plays for a while (I assume due to already buffered data) then stops. MM "stops responding" for a while, but then I can start the track playing again. However, at that point the DB just no longer works and I get SQL errors due to the DB locked. Can't see or do anything with any data at that point.

It's really quite frustrating that in 2012, I can't have a simple installation, where I can have a single DB on a network drive, so I only have to scan new tracks once and the play counts and other stats can remain up to date.

MM is a great tool for managing and tagging, but now I've gone back to using Twonky on my ReadyNAS as my Onkyo amp is a DLNA controller, the latest Twonky is quite good, but I'd like to find a simple player that can survive between OS standby without these frustrating problems.

Any suggestions?