Duplicate key error when archiving
Bug #1509916 reported by
Dennis O'Flaherty
This bug report is a duplicate of:
Bug #1501990: Daemon fails to start up when processing removable media if there are duplicate keys in media and media_attic tables.
Edit
Remove
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
mediascanner2 (Ubuntu) |
New
|
Undecided
|
Unassigned |
Bug Description
media scanner daemon crashes when I log into my machine (desktop, wily)
Mediascanner service starting at 2015-10-25 11:22:08.
terminate called after throwing an instance of 'std::runtime_
what(): UNIQUE constraint failed: media_attic.id
Aborted (core dumped)
The service is trying to run this query in archiveItems:
const char *templ = R"(BEGIN TRANSACTION;
INSERT INTO media_attic SELECT * FROM media WHERE filename LIKE %s;
DELETE FROM media WHERE filename LIKE %s;
COMMIT;
)";
If I move/remove mediastore.db, the service runs again and catalogs music I've added since my last run.
To post a comment you must log in.