by GeWi » Wed Nov 28, 2007 6:41 am
As I couldn't use dbgview for a few weeks due to a bug in dgbview itself (but now fixed in release 1.74), I couldn't thoroughly check what was happening here.
DBGview tells me much more about this matter. It looks like MM3 (in this case RC3) is trapped in a loop. It keeps on locking and unlocking the same file, reading tags and writing tags over and over again.
What follows is a small part of the dbgview listing. In reality it is of course much longer and it keeps on repeating the same lines.
[2924] Locking file: M:\Mijn Mp3's\Ok\Frank Sinatra\The Legend\17 - Frank Sinatra - My happiness.mp3
[2924] Locked file: M:\Mijn Mp3's\Ok\Frank Sinatra\The Legend\17 - Frank Sinatra - My happiness.mp3
[2924] MP3: Going to write tag to M:\Mijn Mp3's\Ok\Frank Sinatra\The Legend\17 - Frank Sinatra - My happiness.mp3
[2924] MP3: Writing ID3v2
[2924] MP3: Updated ID3v2
[2924] MP3: Writing ID3v1
[2924] MP3: Updated ID3v1
[2924] 1880 DB exec SQL: UPDATE Songs SET FileLength=2263040, TrackModified=39414.523013762,FileModified=39414.523013762 WHERE ID=193248
[2924] 1880 DB lock successful.
[2924] 1880 DB lock finished, took 1060848.
[2924] Unlocking file: M:\Mijn Mp3's\Ok\Frank Sinatra\The Legend\17 - Frank Sinatra - My happiness.mp3
[2924] 1880 DB open SQL: SELECT ID,Album FROM Albums WHERE Album=? AND Artist=?
[2924] 1880 DB lock finished, took 91396.
[2924] 1880 DB exec SQL: UPDATE Songs SET SongPath=?, Artist=?, IdAlbum=?, Album=?, AlbumArtist=?, SongTitle=?, Genre=?, Year=?, IDMedia=?, SongLength=?, PlaybackPos=?, TrackNumber=?, BitRate=?, FileLength=?, Seekable=?, SamplingFrequency=?, Stereo=?, Copyrighted=?, Original=?, VBR=?, BPM=?, Author=?, Rating=?, AudioCDTrack=?, FileModified=?, MaxSample=?, NormalizeTrack=?, NormalizeAlbum=?, DateAdded=?, LastTimePlayed=?, PlayCounter=?, Custom1=?, Custom2=?, Custom3=?, Custom4=?, Custom5=?, SignType=?, SignPart1=?, SignPart2=?, SignPart3=?, SignPart4=?, Copyright=?, Publisher=?, Encoder=?, EncodedBy=?, Lyricist=?, Band=?, Conductor=?, Remixer=?, InvolvedPeople=?, OrigTitle=?, OrigArtist=?, OrigLyricist=?, GroupDesc=?, SubTitle=?, ISRC=?, InitialKey=?, Language=?, MediaType=?, RatingString=?, OrigYear=?, Tempo=?, Mood=?, Occasion=?, Quality=?, Lyrics=?, Comment=?, DiscNumber=?, PreGap=?, PostGap=?, TotalSamples=?, GaplessBytes=?, TrackModified=? WHERE ID=?
[2924] 1880 DB lock successful.
[2924] 1880 DB lock finished, took 923952.
[2924] 1880 DB exec SQL: DELETE FROM ArtistsSongs WHERE IDSong=?
[2924] 1880 DB lock successful.
[2924] 1880 DB lock finished, took 408040.
[2924] 1880 DB exec SQL: DELETE FROM GenresSongs WHERE IDSong=?
[2924] 1880 DB lock successful.
[2924] 1880 DB lock finished, took 206348.
[2924] 1880 DB open SQL: SELECT ID,Artist FROM Artists WHERE Artist=?
[2924] 1880 DB lock finished, took 104292.
[2924] 1880 DB exec SQL: INSERT INTO ArtistsSongs (PersonType,IDArtist,IDSong) VALUES (?,?,?)
[2924] 1880 DB lock successful.
[2924] 1880 DB lock finished, took 354592.
[2924] 1880 DB open SQL: SELECT IDGenre FROM Genres WHERE GenreName='Sconosciuto'
[2924] 1880 DB lock finished, took 444708.
[2924] 1880 DB exec SQL: INSERT INTO GenresSongs (IDGenre,IDSong) VALUES (?,?)
[2924] 1880 DB lock successful.
[2924] 1880 DB lock finished, took 169640.
[2924] 1880 DB open SQL: SELECT Count(*) FROM PathProcessing
[2924] 1880 DB lock finished, took 35836.
[2924] Locking file: M:\Mijn Mp3's\Ok\Frank Sinatra\The Legend\17 - Frank Sinatra - My happiness.mp3
[2924] Locked file: M:\Mijn Mp3's\Ok\Frank Sinatra\The Legend\17 - Frank Sinatra - My happiness.mp3
[2924] MP3: Going to write tag to M:\Mijn Mp3's\Ok\Frank Sinatra\The Legend\17 - Frank Sinatra - My happiness.mp3
[2924] MP3: Writing ID3v2
[2924] MP3: Updated ID3v2
[2924] MP3: Writing ID3v1
[2924] MP3: Updated ID3v1
[2924] 1880 DB exec SQL: UPDATE Songs SET FileLength=2263040, TrackModified=39414.523018287,FileModified=39414.523018287 WHERE ID=193248
[2924] 1880 DB lock successful.
[2924] 1880 DB lock finished, took 1032040.
[2924] Unlocking file: M:\Mijn Mp3's\Ok\Frank Sinatra\The Legend\17 - Frank Sinatra - My happiness.mp3
[2924] 1880 DB open SQL: SELECT ID,Album FROM Albums WHERE Album=? AND Artist=?
[2924] 1880 DB lock finished, took 88056.
[2924] 1880 DB exec SQL: UPDATE Songs SET SongPath=?, Artist=?, IdAlbum=?, Album=?, AlbumArtist=?, SongTitle=?, Genre=?, Year=?, IDMedia=?, SongLength=?, PlaybackPos=?, TrackNumber=?, BitRate=?, FileLength=?, Seekable=?, SamplingFrequency=?, Stereo=?, Copyrighted=?, Original=?, VBR=?, BPM=?, Author=?, Rating=?, AudioCDTrack=?, FileModified=?, MaxSample=?, NormalizeTrack=?, NormalizeAlbum=?, DateAdded=?, LastTimePlayed=?, PlayCounter=?, Custom1=?, Custom2=?, Custom3=?, Custom4=?, Custom5=?, SignType=?, SignPart1=?, SignPart2=?, SignPart3=?, SignPart4=?, Copyright=?, Publisher=?, Encoder=?, EncodedBy=?, Lyricist=?, Band=?, Conductor=?, Remixer=?, InvolvedPeople=?, OrigTitle=?, OrigArtist=?, OrigLyricist=?, GroupDesc=?, SubTitle=?, ISRC=?, InitialKey=?, Language=?, MediaType=?, RatingString=?, OrigYear=?, Tempo=?, Mood=?, Occasion=?, Quality=?, Lyrics=?, Comment=?, DiscNumber=?, PreGap=?, PostGap=?, TotalSamples=?, GaplessBytes=?, TrackModified=? WHERE ID=?
[2924] 1880 DB lock successful.
[2924] 1880 DB lock finished, took 715300.
[2924] 1880 DB exec SQL: DELETE FROM ArtistsSongs WHERE IDSong=?
[2924] 1880 DB lock successful.
[2924] 1880 DB lock finished, took 254140.
[2924] 1880 DB exec SQL: DELETE FROM GenresSongs WHERE IDSong=?
[2924] 1880 DB lock successful.
[2924] 1880 DB lock finished, took 116092.
[2924] 1880 DB open SQL: SELECT ID,Artist FROM Artists WHERE Artist=?
[2924] 1880 DB lock finished, took 70168.
[2924] 1880 DB exec SQL: INSERT INTO ArtistsSongs (PersonType,IDArtist,IDSong) VALUES (?,?,?)
[2924] 1880 DB lock successful.
[2924] 1880 DB lock finished, took 311368.
[2924] 1880 DB open SQL: SELECT IDGenre FROM Genres WHERE GenreName='Sconosciuto'
[2924] 1880 DB lock finished, took 281684.
[2924] 1880 DB exec SQL: INSERT INTO GenresSongs (IDGenre,IDSong) VALUES (?,?)
[2924] 1880 DB lock successful.
[2924] 1880 DB lock finished, took 155748.
[2924] 1880 DB open SQL: SELECT Count(*) FROM PathProcessing
[2924] 1880 DB lock finished, took 34416.
[2924] Locking file: M:\Mijn Mp3's\Ok\Frank Sinatra\The Legend\17 - Frank Sinatra - My happiness.mp3
[2924] Locked file: M:\Mijn Mp3's\Ok\Frank Sinatra\The Legend\17 - Frank Sinatra - My happiness.mp3
I have sent a copy of the MP3 file to Jiri.
As I couldn't use dbgview for a few weeks due to a bug in dgbview itself (but now fixed in release 1.74), I couldn't thoroughly check what was happening here.
DBGview tells me much more about this matter. It looks like MM3 (in this case RC3) is trapped in a loop. It keeps on locking and unlocking the same file, reading tags and writing tags over and over again.
What follows is a small part of the dbgview listing. In reality it is of course much longer and it keeps on repeating the same lines.
[2924] Locking file: M:\Mijn Mp3's\Ok\Frank Sinatra\The Legend\17 - Frank Sinatra - My happiness.mp3
[2924] Locked file: M:\Mijn Mp3's\Ok\Frank Sinatra\The Legend\17 - Frank Sinatra - My happiness.mp3
[2924] MP3: Going to write tag to M:\Mijn Mp3's\Ok\Frank Sinatra\The Legend\17 - Frank Sinatra - My happiness.mp3
[2924] MP3: Writing ID3v2
[2924] MP3: Updated ID3v2
[2924] MP3: Writing ID3v1
[2924] MP3: Updated ID3v1
[2924] 1880 DB exec SQL: UPDATE Songs SET FileLength=2263040, TrackModified=39414.523013762,FileModified=39414.523013762 WHERE ID=193248
[2924] 1880 DB lock successful.
[2924] 1880 DB lock finished, took 1060848.
[2924] Unlocking file: M:\Mijn Mp3's\Ok\Frank Sinatra\The Legend\17 - Frank Sinatra - My happiness.mp3
[2924] 1880 DB open SQL: SELECT ID,Album FROM Albums WHERE Album=? AND Artist=?
[2924] 1880 DB lock finished, took 91396.
[2924] 1880 DB exec SQL: UPDATE Songs SET SongPath=?, Artist=?, IdAlbum=?, Album=?, AlbumArtist=?, SongTitle=?, Genre=?, Year=?, IDMedia=?, SongLength=?, PlaybackPos=?, TrackNumber=?, BitRate=?, FileLength=?, Seekable=?, SamplingFrequency=?, Stereo=?, Copyrighted=?, Original=?, VBR=?, BPM=?, Author=?, Rating=?, AudioCDTrack=?, FileModified=?, MaxSample=?, NormalizeTrack=?, NormalizeAlbum=?, DateAdded=?, LastTimePlayed=?, PlayCounter=?, Custom1=?, Custom2=?, Custom3=?, Custom4=?, Custom5=?, SignType=?, SignPart1=?, SignPart2=?, SignPart3=?, SignPart4=?, Copyright=?, Publisher=?, Encoder=?, EncodedBy=?, Lyricist=?, Band=?, Conductor=?, Remixer=?, InvolvedPeople=?, OrigTitle=?, OrigArtist=?, OrigLyricist=?, GroupDesc=?, SubTitle=?, ISRC=?, InitialKey=?, Language=?, MediaType=?, RatingString=?, OrigYear=?, Tempo=?, Mood=?, Occasion=?, Quality=?, Lyrics=?, Comment=?, DiscNumber=?, PreGap=?, PostGap=?, TotalSamples=?, GaplessBytes=?, TrackModified=? WHERE ID=?
[2924] 1880 DB lock successful.
[2924] 1880 DB lock finished, took 923952.
[2924] 1880 DB exec SQL: DELETE FROM ArtistsSongs WHERE IDSong=?
[2924] 1880 DB lock successful.
[2924] 1880 DB lock finished, took 408040.
[2924] 1880 DB exec SQL: DELETE FROM GenresSongs WHERE IDSong=?
[2924] 1880 DB lock successful.
[2924] 1880 DB lock finished, took 206348.
[2924] 1880 DB open SQL: SELECT ID,Artist FROM Artists WHERE Artist=?
[2924] 1880 DB lock finished, took 104292.
[2924] 1880 DB exec SQL: INSERT INTO ArtistsSongs (PersonType,IDArtist,IDSong) VALUES (?,?,?)
[2924] 1880 DB lock successful.
[2924] 1880 DB lock finished, took 354592.
[2924] 1880 DB open SQL: SELECT IDGenre FROM Genres WHERE GenreName='Sconosciuto'
[2924] 1880 DB lock finished, took 444708.
[2924] 1880 DB exec SQL: INSERT INTO GenresSongs (IDGenre,IDSong) VALUES (?,?)
[2924] 1880 DB lock successful.
[2924] 1880 DB lock finished, took 169640.
[2924] 1880 DB open SQL: SELECT Count(*) FROM PathProcessing
[2924] 1880 DB lock finished, took 35836.
[2924] Locking file: M:\Mijn Mp3's\Ok\Frank Sinatra\The Legend\17 - Frank Sinatra - My happiness.mp3
[2924] Locked file: M:\Mijn Mp3's\Ok\Frank Sinatra\The Legend\17 - Frank Sinatra - My happiness.mp3
[2924] MP3: Going to write tag to M:\Mijn Mp3's\Ok\Frank Sinatra\The Legend\17 - Frank Sinatra - My happiness.mp3
[2924] MP3: Writing ID3v2
[2924] MP3: Updated ID3v2
[2924] MP3: Writing ID3v1
[2924] MP3: Updated ID3v1
[2924] 1880 DB exec SQL: UPDATE Songs SET FileLength=2263040, TrackModified=39414.523018287,FileModified=39414.523018287 WHERE ID=193248
[2924] 1880 DB lock successful.
[2924] 1880 DB lock finished, took 1032040.
[2924] Unlocking file: M:\Mijn Mp3's\Ok\Frank Sinatra\The Legend\17 - Frank Sinatra - My happiness.mp3
[2924] 1880 DB open SQL: SELECT ID,Album FROM Albums WHERE Album=? AND Artist=?
[2924] 1880 DB lock finished, took 88056.
[2924] 1880 DB exec SQL: UPDATE Songs SET SongPath=?, Artist=?, IdAlbum=?, Album=?, AlbumArtist=?, SongTitle=?, Genre=?, Year=?, IDMedia=?, SongLength=?, PlaybackPos=?, TrackNumber=?, BitRate=?, FileLength=?, Seekable=?, SamplingFrequency=?, Stereo=?, Copyrighted=?, Original=?, VBR=?, BPM=?, Author=?, Rating=?, AudioCDTrack=?, FileModified=?, MaxSample=?, NormalizeTrack=?, NormalizeAlbum=?, DateAdded=?, LastTimePlayed=?, PlayCounter=?, Custom1=?, Custom2=?, Custom3=?, Custom4=?, Custom5=?, SignType=?, SignPart1=?, SignPart2=?, SignPart3=?, SignPart4=?, Copyright=?, Publisher=?, Encoder=?, EncodedBy=?, Lyricist=?, Band=?, Conductor=?, Remixer=?, InvolvedPeople=?, OrigTitle=?, OrigArtist=?, OrigLyricist=?, GroupDesc=?, SubTitle=?, ISRC=?, InitialKey=?, Language=?, MediaType=?, RatingString=?, OrigYear=?, Tempo=?, Mood=?, Occasion=?, Quality=?, Lyrics=?, Comment=?, DiscNumber=?, PreGap=?, PostGap=?, TotalSamples=?, GaplessBytes=?, TrackModified=? WHERE ID=?
[2924] 1880 DB lock successful.
[2924] 1880 DB lock finished, took 715300.
[2924] 1880 DB exec SQL: DELETE FROM ArtistsSongs WHERE IDSong=?
[2924] 1880 DB lock successful.
[2924] 1880 DB lock finished, took 254140.
[2924] 1880 DB exec SQL: DELETE FROM GenresSongs WHERE IDSong=?
[2924] 1880 DB lock successful.
[2924] 1880 DB lock finished, took 116092.
[2924] 1880 DB open SQL: SELECT ID,Artist FROM Artists WHERE Artist=?
[2924] 1880 DB lock finished, took 70168.
[2924] 1880 DB exec SQL: INSERT INTO ArtistsSongs (PersonType,IDArtist,IDSong) VALUES (?,?,?)
[2924] 1880 DB lock successful.
[2924] 1880 DB lock finished, took 311368.
[2924] 1880 DB open SQL: SELECT IDGenre FROM Genres WHERE GenreName='Sconosciuto'
[2924] 1880 DB lock finished, took 281684.
[2924] 1880 DB exec SQL: INSERT INTO GenresSongs (IDGenre,IDSong) VALUES (?,?)
[2924] 1880 DB lock successful.
[2924] 1880 DB lock finished, took 155748.
[2924] 1880 DB open SQL: SELECT Count(*) FROM PathProcessing
[2924] 1880 DB lock finished, took 34416.
[2924] Locking file: M:\Mijn Mp3's\Ok\Frank Sinatra\The Legend\17 - Frank Sinatra - My happiness.mp3
[2924] Locked file: M:\Mijn Mp3's\Ok\Frank Sinatra\The Legend\17 - Frank Sinatra - My happiness.mp3
I have sent a copy of the MP3 file to Jiri.