[prev in list] [next in list] [prev in thread] [next in thread] 

List:       kde-bugs-dist
Subject:    [amarok] [Bug 315591] mysql errors in case of duplicate tracks
From:       Kurt Roeckx <kurt () roeckx ! be>
Date:       2013-03-03 13:54:36
Message-ID: bug-315591-17878-KOR3NlmTCz () http ! bugs ! kde ! org/
[Download RAW message or body]

https://bugs.kde.org/show_bug.cgi?id=315591

--- Comment #4 from Kurt Roeckx <kurt@roeckx.be> ---
(In reply to comment #2)
> Can you please repost this without actually editing the paths? (sorry for
> reduced privacy) The problem might be too long file paths which may cause
> duplicate indices.

The incomplete path is just in the mysql error message, and it's limited to 64
chars.  It should should be enough to make that case unique since it starts
with the CD and track number.  But I do have albums where 64 clearly isn't
enough to cover the album title.

In case of a full rescan I get:
GREPME MySQLe query failed! (1062) Duplicate entry
'3-./scratch/kurt/music/cd/100 Non Stop Party Hits/4-20 - The Bea' for key
'urls_id_rpath' on UPDATE LOW_PRIORITY urls SET deviceid=3,
rpath='./scratch/kurt/music/cd/100 Non Stop Party Hits/4-20 - The Beach Boys -
Sloop John B..flac', directory=7114,
uniqueid='amarok-sqltrackuid://mb-a555d5b5-44dc-45c6-b286-183f8ad1f8e2' WHERE
id=16110;

In case of the --newid it was:
GREPME MySQLe query failed! (1062) Duplicate entry
'3-./scratch/kurt/music/cd/De Topcollectie '60, Volume 2/4-16 - L' for key
'urls_id_rpath' on INSERT INTO urls (deviceid,rpath,directory,uniqueid) VALUES
(3,'./scratch/kurt/music/cd/De Topcollectie \'60, Volume 2/5-19 - The Moody
Blues - Nights in White
Satin.flac',7160,'amarok-sqltrackuid://ce19ed1c8c464b581a4752e22213df9a'),(3,'./scratch/kurt/music/cd/De
 Topcollectie \'60, Volume 2/4-16 - Lucille Starr - The French
Song.flac',7160,'amarok-sqltrackuid://mb-1ea758af-ce48-4d3e-94f3-83232890e552');
GREPME MySQLe query failed! (1062) Duplicate entry '0' for key 'tracks_url' on
INSERT INTO tracks
(url,artist,album,genre,composer,year,title,comment,tracknumber,discnumber,bitrate,len \
gth,samplerate,filesize,filetype,bpm,createdate,modifydate,albumgain,albumpeakgain,trackgain,trackpeakgain)
 VALUES (0,3038,6385,218,238,117,'Nights in White
Satin','',19,5,948,264000,44100,31307812,3,NULL,1361123048,1361123042,-1,-1,-1,-1),(1,-1,-1,-1,-1,-1,'The
 French
Song','',16,4,860,172000,44100,18510633,3,NULL,0,1361114924,-1,-1,-1,-1);

The --newid was on Nights in White Satin file.

-- 
You are receiving this mail because:
You are watching all bug changes.


[prev in list] [next in list] [prev in thread] [next in thread]