Duplicate key error when archiving

Bug #1509916 reported by Dennis O'Flaherty on 2015-10-26
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
mediascanner2 (Ubuntu)
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  Edit
Everyone can see this information.

Other bug subscribers