tracker-extract: "Unable to insert multiple values for subject"
tracker-2.1.4-1.fc28.x86_64
. Every time, journalctl -b -0
says:
Oct 02 23:17:56 ac tracker-extract[5471]: Could not insert metadata for item "file:///home/acko/pics/photos/20171207_201303-noga-erez-fluc-vienna.jpg": Unable to insert multiple values for subject `urn:uuid:390251df-4671-2124-fcad-34da9433bd5e' and single valued property `nmm:exposureTime' (old_value: '0.166667', new value: '0.166667')
Oct 02 23:17:56 ac tracker-extract[5471]: If the error above is recurrent for the same item/ID, consider running "tracker-extract" in the terminal with the TRACKER_VERBOSITY=3 environment variable, and filing a bug with the additional information
$:acko\> export TRACKER_VERBOSITY=3
$:acko\> echo $TRACKER_VERBOSITY
3
$:acko\> /usr/libexec/tracker-extract "/home/acko/pics/photos/20171207_201303-noga-erez-fluc-vienna.jpg"
Tracker-Message: 23:24:33.489: Starting tracker-extract 2.1.4
Tracker-Message: 23:24:33.490: General options:
Tracker-Message: 23:24:33.490: Verbosity ............................ 0
Tracker-Message: 23:24:33.490: Sched Idle ........................... 1
Tracker-Message: 23:24:33.490: Max bytes (per file) ................. 1048576
Tracker-Message: 23:24:33.490: Setting scheduler policy to SCHED_IDLE
Tracker-Message: 23:24:33.490: Setting priority nice level to 19
Tracker-Message: 23:24:33.490: Loading extractor rules... (/usr/share/tracker-miners/extract-rules)
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.490: Loaded rule '10-abw.rule'
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.490: Loaded rule '10-bmp.rule'
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.490: Loaded rule '10-comics.rule'
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.490: Loaded rule '10-dvi.rule'
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.490: Loaded rule '10-ebooks.rule'
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.490: Loaded rule '10-epub.rule'
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.490: Loaded rule '10-flac.rule'
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.490: Loaded rule '10-gif.rule'
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.490: Loaded rule '10-html.rule'
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.490: Loaded rule '10-ico.rule'
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.490: Loaded rule '10-jpeg.rule'
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.490: Loaded rule '10-msoffice.rule'
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.490: Loaded rule '10-oasis.rule'
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.491: Loaded rule '10-pdf.rule'
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.491: Loaded rule '10-png.rule'
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.491: Loaded rule '10-ps.rule'
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.491: Loaded rule '10-raw.rule'
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.491: Loaded rule '10-svg.rule'
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.491: Loaded rule '10-tiff.rule'
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.491: Loaded rule '10-vorbis.rule'
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.491: Loaded rule '10-xmp.rule'
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.491: Loaded rule '10-xps.rule'
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.491: Loaded rule '11-iso.rule'
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.491: Loaded rule '11-msoffice-xml.rule'
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.491: Loaded rule '15-gstreamer-guess.rule'
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.491: Loaded rule '15-playlist.rule'
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.491: Loaded rule '15-source-code.rule'
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.491: Loaded rule '90-gstreamer-audio-generic.rule'
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.491: Loaded rule '90-gstreamer-image-generic.rule'
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.491: Loaded rule '90-gstreamer-video-generic.rule'
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.491: Loaded rule '90-text-generic.rule'
Tracker-Message: 23:24:33.491: Extractor rules loaded
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.562: Using backend = 'AUTO'
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.562: Waiting for service to become available...
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.563: Service is ready
Tracker-INFO: 23:24:33.563: Setting database locations
Tracker-INFO: 23:24:33.563: Checking whether database files exist
Tracker-INFO: 23:24:33.563: Opened sqlite3 database:'/home/acko/.cache/tracker/meta.db'
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.563: Resetting collator in db interface 0x55feede20370
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.563: [ICU collation] Initializing collator for locale 'en_US.utf8'
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.563: [ICU collation] Initializing collator for locale 'en_US.utf8'
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.563: Preparing query: 'PRAGMA synchronous = OFF;'
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.572: Preparing query: 'PRAGMA encoding = "UTF-8"'
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.572: Preparing query: 'PRAGMA auto_vacuum = 0;'
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.572: Preparing query: 'PRAGMA temp_store = MEMORY;'
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.572: Preparing query: 'PRAGMA journal_mode = WAL;'
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.572: Preparing query: 'PRAGMA wal_autocheckpoint = 0'
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.572: Preparing query: 'PRAGMA journal_size_limit = 10240000'
Tracker-INFO: 23:24:33.572: Setting page size to 8192
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.572: Preparing query: 'PRAGMA page_size = 8192'
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.572: Preparing query: 'PRAGMA cache_size = 250'
Tracker-INFO: 23:24:33.572: Setting cache size to 250
Tracker-INFO: 23:24:33.573: Closed sqlite3 database:'/home/acko/.cache/tracker/meta.db'
Tracker-INFO: 23:24:33.573: Opened sqlite3 database:'/home/acko/.cache/tracker/meta.db'
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.573: Resetting collator in db interface 0x55feede20420
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.573: [ICU collation] Initializing collator for locale 'en_US.utf8'
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.573: [ICU collation] Initializing collator for locale 'en_US.utf8'
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.573: Preparing query: 'PRAGMA synchronous = OFF;'
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.584: Preparing query: 'PRAGMA encoding = "UTF-8"'
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.584: Preparing query: 'PRAGMA auto_vacuum = 0;'
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.584: Preparing query: 'PRAGMA temp_store = MEMORY;'
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.584: Preparing query: 'PRAGMA journal_mode = WAL;'
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.584: Preparing query: 'PRAGMA wal_autocheckpoint = 0'
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.584: Preparing query: 'PRAGMA journal_size_limit = 10240000'
Tracker-INFO: 23:24:33.584: Setting page size to 8192
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.584: Preparing query: 'PRAGMA page_size = 8192'
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.584: Preparing query: 'PRAGMA cache_size = 250'
Tracker-INFO: 23:24:33.584: Setting cache size to 250
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.587: Tracker.Sparql.Backend.query(): 'SELECT nfo:Document nfo:Audio nfo:Image nfo:Video nfo:FilesystemImage nmm:Playlist {}'
Tracker-INFO: 23:24:33.587: Opened sqlite3 database:'/home/acko/.cache/tracker/meta.db'
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.587: Resetting collator in db interface 0x55feee29f810
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.587: [ICU collation] Initializing collator for locale 'en_US.utf8'
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.587: [ICU collation] Initializing collator for locale 'en_US.utf8'
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.587: Preparing query: 'PRAGMA synchronous = OFF;'
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.597: Preparing query: 'PRAGMA encoding = "UTF-8"'
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.597: Preparing query: 'PRAGMA auto_vacuum = 0;'
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.597: Preparing query: 'PRAGMA temp_store = MEMORY;'
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.597: Preparing query: 'PRAGMA journal_mode = WAL;'
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.597: Preparing query: 'PRAGMA wal_autocheckpoint = 0'
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.597: Preparing query: 'PRAGMA journal_size_limit = 10240000'
Tracker-INFO: 23:24:33.597: Setting page size to 8192
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.597: Preparing query: 'PRAGMA page_size = 8192'
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.597: Preparing query: 'PRAGMA cache_size = 250'
Tracker-INFO: 23:24:33.597: Setting cache size to 250
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.598: Preparing query: 'SELECT (SELECT Uri FROM Resource WHERE ID = COALESCE((SELECT ID FROM Resource WHERE Uri = ?), 0)), (SELECT Uri FROM Resource WHERE ID = COALESCE((SELECT ID FROM Resource WHERE Uri = ?), 0)), (SELECT Uri FROM Resource WHERE ID = COALESCE((SELECT ID FROM Resource WHERE Uri = ?), 0)), (SELECT Uri FROM Resource WHERE ID = COALESCE((SELECT ID FROM Resource WHERE Uri = ?), 0)), (SELECT Uri FROM Resource WHERE ID = COALESCE((SELECT ID FROM Resource WHERE Uri = ?), 0)), (SELECT Uri FROM Resource WHERE ID = COALESCE((SELECT ID FROM Resource WHERE Uri = ?), 0)) FROM (SELECT 1)'
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.599: Tracker.Sparql.Backend.query(): 'SELECT tracker:id(rdf:type) {}'
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.599: Preparing query: 'SELECT COALESCE((SELECT ID FROM Resource WHERE Uri = ?), 0) FROM (SELECT 1)'
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.599: Tracker.Sparql.Backend.query(): 'SELECT tracker:id(nie:dataSource) {}'
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.599: Tracker.Sparql.Backend.query(): 'SELECT tracker:id(tracker:extractor-data-source) {}'
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.620: Tracker.Sparql.Backend.query(): 'SELECT nfo:Document nfo:Audio nfo:Image nfo:Video nfo:FilesystemImage nmm:Playlist {}'
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.620: Tracker.Sparql.Backend.query(): 'SELECT tracker:id(rdf:type) {}'
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.620: Tracker.Sparql.Backend.query(): 'SELECT tracker:id(nie:dataSource) {}'
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.620: Tracker.Sparql.Backend.query(): 'SELECT tracker:id(tracker:extractor-data-source) {}'
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.622: Tracker.Sparql.Backend.query(): 'SELECT tracker:id(?urn) tracker:id(?type) { ?urn a ?type; nie:url "file:///home/acko/musik/mp3/new%20order%20(best%20of)%2002%20-%20bizarre%20love%20triangle.mp3" }'
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.622: Preparing query: 'SELECT "1_u", "2_u" FROM (SELECT "rdfs:Resource_rdf:type1"."ID" AS "1_u", "rdfs:Resource_rdf:type1"."rdf:type" AS "2_u", 1 FROM "rdfs:Resource_rdf:type" AS "rdfs:Resource_rdf:type1", "nie:DataObject" AS "nie:DataObject2" WHERE "rdfs:Resource_rdf:type1"."ID" = "nie:DataObject2"."ID" AND "nie:DataObject2"."nie:url" = ?)'
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.622: Tracker.Sparql.Backend.query_async(): 'SELECT COUNT(?urn) { SELECT ?urn WHERE {{ ?urn a rdfs:Resource; a ?type ; tracker:available true . FILTER (! EXISTS { ?urn nie:dataSource <http://www.tracker-project.org/ontologies/tracker#extractor-data-source> } && ?type IN (nfo:Document,nfo:Audio,nfo:Image,nfo:Video,nfo:FilesystemImage,nmm:Playlist))}}} LIMIT 100'
(tracker-extract:6497): Tracker-CRITICAL **: 23:24:33.623: Could not request DBus name 'org.freedesktop.Tracker1.Miner.Extract': D-Bus service name:'org.freedesktop.Tracker1.Miner.Extract' is already taken, perhaps the application is already running?
(tracker-extract:6497): Tracker-DEBUG: 23:24:33.624: Preparing query: 'SELECT COUNT("1_u") FROM (SELECT "1_u" FROM (SELECT * FROM (SELECT "rdfs:Resource1"."ID" AS "1_u", "rdfs:Resource_rdf:type2"."rdf:type" AS "2_u", 1 FROM "rdfs:Resource" AS "rdfs:Resource1", "rdfs:Resource_rdf:type" AS "rdfs:Resource_rdf:type2", "nie:DataObject" AS "nie:DataObject3" WHERE "rdfs:Resource1"."ID" = "rdfs:Resource_rdf:type2"."ID" AND "rdfs:Resource_rdf:type2"."ID" = "nie:DataObject3"."ID" AND "nie:DataObject3"."tracker:available" = ? AND (NOT ((EXISTS (SELECT 1 FROM "nie:DataObject_nie:dataSource" AS "nie:DataObject_nie:dataSource4" WHERE "1_u" = "nie:DataObject_nie:dataSource4"."ID" AND "nie:DataObject_nie:dataSource4"."nie:dataSource" = (SELECT ID FROM Resource WHERE Uri = ?)))) AND "2_u" IN (COALESCE((SELECT ID FROM Resource WHERE Uri = ?), 0), COALESCE((SELECT ID FROM Resource WHERE Uri = ?), 0), COALESCE((SELECT ID FROM Resource WHERE Uri = ?), 0), COALESCE((SELECT ID FROM Resource WHERE Uri = ?), 0), COALESCE((SELECT ID FROM Resource WHERE Uri = ?), 0), COALESCE((SELECT ID FROM Resource WHERE Uri = ?), 0)))))) LIMIT ?'