View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0005013 | MMW v4 | Other | public | 2008-12-08 17:56 | 2009-01-13 20:02 |
| Reporter | Assigned To | ||||
| Priority | immediate | Severity | major | Reproducibility | sometimes |
| Status | resolved | Resolution | unable to reproduce | ||
| Product Version | 3.1 | ||||
| Fixed in Version | 3.1 | ||||
| Summary | 0005013: Podcast: Some downloaded episodes are mal-linked in Library | ||||
| Description | Intermittent problems with downloaded episodes incorrectly updated in Library. Restarting MM3 may be a temporary fix to the problem. | ||||
| Additional Information | http://www.mediamonkey.com/forum/viewtopic.php?f=6&t=34729 http://www.mediamonkey.com/forum/viewtopic.php?f=6&t=34825 | ||||
| Tags | No tags attached. | ||||
| Attached Files | |||||
| Fixed in build | 1203 | ||||
|
|
Added additional info as requested. http://www.mediamonkey.com/forum/viewtopic.php?f=6&t=34729&p=178943#p178943 |
|
|
Uploaded zipped debug log of 3 Update Podcast's. All 3 ended up with new track playable from Location node but NOT available from Podcast node. |
|
|
Just realized that the PodcastEpisodes.IDTrack of (many?/all?) of the problem episodes are junk. SELECT * FROM PodcastEpisodes WHERE IDTrack > (SELECT MAX(ID) FROM Songs) Found 24 rows. |
|
|
Owyn, that is really strange. I have made a code review and I don't see any clue. Could you send me your DB, please? Hopefully I will be able to reproduce this strange issue then. You can use e.g. www.yousendit.com |
|
|
See http://www.mediamonkey.com/forum/viewtopic.php?f=6&t=34729&p=179173#p179154 |
|
|
I found a clue, if a track is deleted from library (via location node, not via podcast node) then the idTrack in PocdastEpisodes table doesn't seem to be updated, this might be the reason why there are some rows for the query "SELECT * FROM PodcastEpisodes WHERE IDTrack > (SELECT MAX(ID) FROM Songs)" I will investigate further later. |
|
|
Uploaded debug log for Re-scan of Podcasts abort. DELL530.081212.0833.LOG.zip |
|
|
Fixed the clue I found out: if an episode is not deleted from podcast node, but from location node then idTrack in PodcastEpisodes table is not properly updated. Fixed in build 1203. Re: the log, I agree that re-scan could do something with this but only when the "associate tracks to podcast subscriptions" process is running, but it is not seen from the log, althoug I believe that the process run, but you might just didn't catch it. Re: the rest: see http://www.mediamonkey.com/forum/viewtopic.php?f=6&t=34729&p=179173#p179154 |
|
|
New log uploaded (081212.1306). Started DbugView Started MM3 Re-Scanned Podcasts via Computer node (Nothing left in Location to point to) Stopped again after 54 tracks Exited MM3 Saved log in DebugView and exited. Checked log in editor. Looks complete. Zipped and uploaded. |
|
|
As discovered in the forum post: When unsubscribing there is 'DELETE FROM PodcastEpisodes WHERE idPodcast = x AND idTrack < 0 ', BUT there should rather be 'DELETE FROM PodcastEpisodes WHERE idPodcast = x AND ((idTrack < 0) OR NOT EXISTS (SELECT ID FROM Songs WHERE ID = idTrack ))) ' Fixed in 1203. i.e. Episodes with broken link to the Songs table should be deleted when unsubscribing. |
|
|
As discussed here: http://www.mediamonkey.com/forum/viewtopic.php?f=6&t=34729&st=0&sk=t&sd=a&start=60 It was caused by DB corruption. Nevertheless there were added the 2 auto-corrections I mentioned (added in build 1203) in the case the PodcastEpisodes.idTrack is damaged. |
|
|
Not just a database corruption issue. I renamed my AppData\Local\MediaMonkey folder and then started 1202. This created a new empty database. Scanned Podcasts folder tree and re-created same error as in previous database. |
|
|
Note: This was done before adding any Podcast subscriptions. |
|
|
Owyn, I has not been able to reproduce any issues you had on the corrupted DB, if you have any steps to reproduce on a clean DB then put it down and re-open the issue. Note: If you mean the scan error then we should rather re-open another mantis issue for this. Is the 0005038 the issue? |
|
|
Yes. I am running through a test plan for Podcasts starting with an empty database. |
|
|
Problem recurred on re-built database. See comments starting here: http://www.mediamonkey.com/forum/viewtopic.php?f=6&t=34729&start=45#p180661 |
|
|
I have not been able to reproduce. As discussed in the forum link: http://www.mediamonkey.com/forum/viewtopic.php?f=6&t=34729&start=45#p180661 it was caused by corrupted DB from Owyn, but there is not known what could cause the DB corruption. Owyn, any new foundations? |
