Duplicate key error when archiving

Bug #1509916 reported by Dennis O'Flaherty
6
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_error'
  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.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.