touch-packages team mailing list archive

[James Henstridge <james.henstridge@xxxxxxxxxxxxx>]

*** This bug is a duplicate of bug 1501990 ***
    https://bugs.launchpad.net/bugs/1501990

** This bug has been marked 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

-- 
You received this bug notification because you are a member of Ubuntu
Touch seeded packages, which is subscribed to mediascanner2 in Ubuntu.
https://bugs.launchpad.net/bugs/1509916

Title:
  Duplicate key error when archiving

Status in mediascanner2 package in Ubuntu:
  New

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 manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/mediascanner2/+bug/1509916/+subscriptions