Duplicated data in database
It seems the miner added item twice into database:
+ tracker3 sparql --dbus-service=org.freedesktop.Tracker3.Miner.Files -q 'SELECT ?p0 ?p1 ?p2 ?p3 ?p4 ?p5 ?p6 ?p7 ?p8 ?p9 WHERE { GRAPH tracker:Video { SELECT ?x as ?p0 nie:isStoredAs(?x) as ?p1 rdf:type(?x) as ?p2 nfo:fileName(nie:isStoredAs(?x)) as ?p3 nfo:fileSize(nie:isStoredAs(?x)) as ?p4 nfo:fileLastModified(nie:isStoredAs(?x)) as ?p5 nie:mimeType(?x) as ?p6 nie:isStoredAs(?x) as ?p7 nfo:duration(?x) as ?p8 nfo:frameRate(?x) as ?p9 WHERE {?x a nmm:Video . ?x nie:isStoredAs ?file GRAPH tracker:FileSystem { ?file nie:dataSource ?dataSource . ?dataSource tracker:available true . } FILTER((fn:starts-with(nie:mimeType(?x),'\''video/'\'')||fn:starts-with(nie:mimeType(?x),'\''image/'\'')))} GROUP BY ?x}}'
Results:
urn:bnode:11c71a5b-7c09-40dc-9bb7-727bd64452d1, file:///home/jmlich/Videos/Raspberry%20PI%20with%20max7219%20and%20buttons-bTEAbe-913M.mp4, http://www.w3.org/2000/01/rdf-schema#Resource,http://tracker.api.gnome.org/ontology/v3/nie#Inf>
urn:bnode:bf4361ab-9184-4035-b7d8-d8c5808d0fc7, file:///home/jmlich/Videos/Raspberry%20PI%20with%20max7219%20and%20buttons-bTEAbe-913M.mp4, http://www.w3.org/2000/01/rdf-schema#Resource,http://tracker.api.gnome.org/ontology/v3/nie#Inf>
After cd ./Videos; cp *.mp4 ..
I can see three records:
+ tracker3 sparql --dbus-service=org.freedesktop.Tracker3.Miner.Files -q 'SELECT ?p0 ?p1 ?p2 ?p3 ?p4 ?p5 ?p6 ?p7 ?p8 ?p9 WHERE { GRAPH tracker:Video { SELECT ?x as ?p0 nie:isStoredAs(?x) as ?p1 rdf:type(?x) as ?p2 nfo:fileName(nie:isStoredAs(?x)) as ?p3 nfo:fileSize(nie:isStoredAs(?x)) as ?p4 nfo:fileLastModified(nie:isStoredAs(?x)) as ?p5 nie:mimeType(?x) as ?p6 nie:isStoredAs(?x) as ?p7 nfo:duration(?x) as ?p8 nfo:frameRate(?x) as ?p9 WHERE {?x a nmm:Video . ?x nie:isStoredAs ?file GRAPH tracker:FileSystem { ?file nie:dataSource ?dataSource . ?dataSource tracker:available true . } FILTER((fn:starts-with(nie:mimeType(?x),'\''video/'\'')||fn:starts-with(nie:mimeType(?x),'\''image/'\'')))} GROUP BY ?x}}'
Results:
urn:bnode:11c71a5b-7c09-40dc-9bb7-727bd64452d1, file:///home/jmlich/Videos/Raspberry%20PI%20with%20max7219%20and%20buttons-bTEAbe-913M.mp4, http://www.w3.org/2000/01/rdf-schema#Resource,http://tracker.api.gnome.org/ontology/v3/nie#Inf>
urn:bnode:bf4361ab-9184-4035-b7d8-d8c5808d0fc7, file:///home/jmlich/Videos/Raspberry%20PI%20with%20max7219%20and%20buttons-bTEAbe-913M.mp4, http://www.w3.org/2000/01/rdf-schema#Resource,http://tracker.api.gnome.org/ontology/v3/nie#Inf>
urn:bnode:9cda4a56-875d-44b1-a231-a9dfd0ae1345, file:///home/jmlich/Raspberry%20PI%20with%20max7219%20and%20buttons-bTEAbe-913M.mp4, http://www.w3.org/2000/01/rdf-schema#Resource,http://tracker.api.gnome.org/ontology/v3/nie#Informatio>
Whole graph is here:
$ tracker3 sparql -b org.freedesktop.Tracker3.Miner.Files -q "SELECT ?x ?y ?z WHERE { GRAPH tracker:Video { ?x ?y ?z } } "
Results:
file:///home/jmlich/Videos/Raspberry%20PI%20with%20max7219%20and%20buttons-bTEAbe-913M.mp4, http://tracker.api.gnome.org/ontology/v3/nfo#fileLastModified, 2020-02-21T13:58:17Z
urn:bnode:11c71a5b-7c09-40dc-9bb7-727bd64452d1, http://tracker.api.gnome.org/ontology/v3/nfo#sampleRate, 44100.0
urn:bnode:bf4361ab-9184-4035-b7d8-d8c5808d0fc7, http://tracker.api.gnome.org/ontology/v3/nfo#sampleRate, 44100.0
file:///home/jmlich/Videos/Raspberry%20PI%20with%20max7219%20and%20buttons-bTEAbe-913M.mp4, http://tracker.api.gnome.org/ontology/v3/nfo#hasHash, urn:bnode:aa03692d-3ffa-4e15-a14b-bf357feed053
urn:bnode:11c71a5b-7c09-40dc-9bb7-727bd64452d1, http://tracker.api.gnome.org/ontology/v3/nfo#width, 1906
urn:bnode:bf4361ab-9184-4035-b7d8-d8c5808d0fc7, http://tracker.api.gnome.org/ontology/v3/nfo#width, 1906
file:///home/jmlich/Videos/Raspberry%20PI%20with%20max7219%20and%20buttons-bTEAbe-913M.mp4, http://tracker.api.gnome.org/ontology/v3/nfo#fileName, Raspberry PI with max7219 and buttons-bTEAbe-913M.mp4
urn:bnode:2fb01317-ed58-4f69-8a14-366c3c24d9ca, http://tracker.api.gnome.org/ontology/v3/nfo#hashAlgorithm, gibest
urn:bnode:6f617183-f3d2-42f5-8910-921796d1890f, http://tracker.api.gnome.org/ontology/v3/nfo#hashAlgorithm, gibest
urn:bnode:41bf8093-a4b6-4716-991f-502f24529e1b, http://tracker.api.gnome.org/ontology/v3/nfo#hashAlgorithm, gibest
urn:bnode:01982aaa-d1fc-44f7-9010-4306d937225e, http://tracker.api.gnome.org/ontology/v3/nfo#hashAlgorithm, gibest
urn:bnode:c38c80dc-bd91-46a9-85d6-d1f140aa5463, http://tracker.api.gnome.org/ontology/v3/nfo#hashAlgorithm, gibest
urn:bnode:aa03692d-3ffa-4e15-a14b-bf357feed053, http://tracker.api.gnome.org/ontology/v3/nfo#hashAlgorithm, gibest
urn:bnode:11c71a5b-7c09-40dc-9bb7-727bd64452d1, http://tracker.api.gnome.org/ontology/v3/nfo#height, 1080
urn:bnode:bf4361ab-9184-4035-b7d8-d8c5808d0fc7, http://tracker.api.gnome.org/ontology/v3/nfo#height, 1080
urn:bnode:2fb01317-ed58-4f69-8a14-366c3c24d9ca, http://tracker.api.gnome.org/ontology/v3/nfo#hashValue, 31924108662da8c2
urn:bnode:6f617183-f3d2-42f5-8910-921796d1890f, http://tracker.api.gnome.org/ontology/v3/nfo#hashValue, 31924108662da8c2
urn:bnode:41bf8093-a4b6-4716-991f-502f24529e1b, http://tracker.api.gnome.org/ontology/v3/nfo#hashValue, c6e739ac154cc69
urn:bnode:01982aaa-d1fc-44f7-9010-4306d937225e, http://tracker.api.gnome.org/ontology/v3/nfo#hashValue, c6e739ac154cc69
urn:bnode:c38c80dc-bd91-46a9-85d6-d1f140aa5463, http://tracker.api.gnome.org/ontology/v3/nfo#hashValue, 1fa54d5b682b5508
urn:bnode:aa03692d-3ffa-4e15-a14b-bf357feed053, http://tracker.api.gnome.org/ontology/v3/nfo#hashValue, 1fa54d5b682b5508
urn:bnode:11c71a5b-7c09-40dc-9bb7-727bd64452d1, http://tracker.api.gnome.org/ontology/v3/nfo#aspectRatio, 1.0
urn:bnode:bf4361ab-9184-4035-b7d8-d8c5808d0fc7, http://tracker.api.gnome.org/ontology/v3/nfo#aspectRatio, 1.0
urn:bnode:11c71a5b-7c09-40dc-9bb7-727bd64452d1, http://tracker.api.gnome.org/ontology/v3/nfo#duration, 31
urn:bnode:bf4361ab-9184-4035-b7d8-d8c5808d0fc7, http://tracker.api.gnome.org/ontology/v3/nfo#duration, 31
urn:bnode:11c71a5b-7c09-40dc-9bb7-727bd64452d1, http://tracker.api.gnome.org/ontology/v3/nfo#frameRate, 30.0
urn:bnode:bf4361ab-9184-4035-b7d8-d8c5808d0fc7, http://tracker.api.gnome.org/ontology/v3/nfo#frameRate, 30.0
urn:bnode:11c71a5b-7c09-40dc-9bb7-727bd64452d1, http://tracker.api.gnome.org/ontology/v3/nfo#channels, 2
urn:bnode:bf4361ab-9184-4035-b7d8-d8c5808d0fc7, http://tracker.api.gnome.org/ontology/v3/nfo#channels, 2
urn:bnode:11c71a5b-7c09-40dc-9bb7-727bd64452d1, http://tracker.api.gnome.org/ontology/v3/nie#isStoredAs, file:///home/jmlich/Videos/Raspberry%20PI%20with%20max7219%20and%20buttons-bTEAbe-913M.mp4
urn:bnode:bf4361ab-9184-4035-b7d8-d8c5808d0fc7, http://tracker.api.gnome.org/ontology/v3/nie#isStoredAs, file:///home/jmlich/Videos/Raspberry%20PI%20with%20max7219%20and%20buttons-bTEAbe-913M.mp4
file:///home/jmlich/Videos/Raspberry%20PI%20with%20max7219%20and%20buttons-bTEAbe-913M.mp4, http://tracker.api.gnome.org/ontology/v3/nie#interpretedAs, urn:bnode:11c71a5b-7c09-40dc-9bb7-727bd64452d1
file:///home/jmlich/Videos/Raspberry%20PI%20with%20max7219%20and%20buttons-bTEAbe-913M.mp4, http://tracker.api.gnome.org/ontology/v3/nie#interpretedAs, urn:bnode:bf4361ab-9184-4035-b7d8-d8c5808d0fc7
urn:bnode:11c71a5b-7c09-40dc-9bb7-727bd64452d1, http://tracker.api.gnome.org/ontology/v3/nie#generator, Lavf58.76.100
urn:bnode:bf4361ab-9184-4035-b7d8-d8c5808d0fc7, http://tracker.api.gnome.org/ontology/v3/nie#generator, Lavf58.76.100
urn:bnode:11c71a5b-7c09-40dc-9bb7-727bd64452d1, http://tracker.api.gnome.org/ontology/v3/nie#mimeType, video/mp4
urn:bnode:bf4361ab-9184-4035-b7d8-d8c5808d0fc7, http://tracker.api.gnome.org/ontology/v3/nie#mimeType, video/mp4
file:///home/jmlich/Videos/Raspberry%20PI%20with%20max7219%20and%20buttons-bTEAbe-913M.mp4, http://purl.org/dc/elements/1.1/date, 2020-02-21T13:58:17Z
urn:bnode:2fb01317-ed58-4f69-8a14-366c3c24d9ca, http://tracker.api.gnome.org/ontology/v3/nrl#modified, 13
urn:bnode:6f617183-f3d2-42f5-8910-921796d1890f, http://tracker.api.gnome.org/ontology/v3/nrl#modified, 13
urn:bnode:41bf8093-a4b6-4716-991f-502f24529e1b, http://tracker.api.gnome.org/ontology/v3/nrl#modified, 1146
urn:bnode:01982aaa-d1fc-44f7-9010-4306d937225e, http://tracker.api.gnome.org/ontology/v3/nrl#modified, 1146
file:///home/jmlich/Videos/Raspberry%20PI%20with%20max7219%20and%20buttons-bTEAbe-913M.mp4, http://tracker.api.gnome.org/ontology/v3/nrl#modified, 1152
urn:bnode:c38c80dc-bd91-46a9-85d6-d1f140aa5463, http://tracker.api.gnome.org/ontology/v3/nrl#modified, 1152
urn:bnode:11c71a5b-7c09-40dc-9bb7-727bd64452d1, http://tracker.api.gnome.org/ontology/v3/nrl#modified, 1152
urn:bnode:aa03692d-3ffa-4e15-a14b-bf357feed053, http://tracker.api.gnome.org/ontology/v3/nrl#modified, 1152
urn:bnode:bf4361ab-9184-4035-b7d8-d8c5808d0fc7, http://tracker.api.gnome.org/ontology/v3/nrl#modified, 1152
urn:bnode:2fb01317-ed58-4f69-8a14-366c3c24d9ca, http://tracker.api.gnome.org/ontology/v3/nrl#added, 2021-05-29T11:03:36Z
urn:bnode:6f617183-f3d2-42f5-8910-921796d1890f, http://tracker.api.gnome.org/ontology/v3/nrl#added, 2021-05-29T11:03:36Z
urn:bnode:41bf8093-a4b6-4716-991f-502f24529e1b, http://tracker.api.gnome.org/ontology/v3/nrl#added, 2021-06-04T16:02:11Z
urn:bnode:01982aaa-d1fc-44f7-9010-4306d937225e, http://tracker.api.gnome.org/ontology/v3/nrl#added, 2021-06-04T16:02:11Z
file:///home/jmlich/Videos/Raspberry%20PI%20with%20max7219%20and%20buttons-bTEAbe-913M.mp4, http://tracker.api.gnome.org/ontology/v3/nrl#added, 2021-06-04T16:03:21Z
urn:bnode:c38c80dc-bd91-46a9-85d6-d1f140aa5463, http://tracker.api.gnome.org/ontology/v3/nrl#added, 2021-06-04T16:03:21Z
urn:bnode:11c71a5b-7c09-40dc-9bb7-727bd64452d1, http://tracker.api.gnome.org/ontology/v3/nrl#added, 2021-06-04T16:03:21Z
urn:bnode:aa03692d-3ffa-4e15-a14b-bf357feed053, http://tracker.api.gnome.org/ontology/v3/nrl#added, 2021-06-04T16:03:21Z
urn:bnode:bf4361ab-9184-4035-b7d8-d8c5808d0fc7, http://tracker.api.gnome.org/ontology/v3/nrl#added, 2021-06-04T16:03:21Z
urn:bnode:2fb01317-ed58-4f69-8a14-366c3c24d9ca, http://www.w3.org/1999/02/22-rdf-syntax-ns#type, http://www.w3.org/2000/01/rdf-schema#Resource
urn:bnode:2fb01317-ed58-4f69-8a14-366c3c24d9ca, http://www.w3.org/1999/02/22-rdf-syntax-ns#type, http://tracker.api.gnome.org/ontology/v3/nfo#FileHash
urn:bnode:6f617183-f3d2-42f5-8910-921796d1890f, http://www.w3.org/1999/02/22-rdf-syntax-ns#type, http://www.w3.org/2000/01/rdf-schema#Resource
urn:bnode:6f617183-f3d2-42f5-8910-921796d1890f, http://www.w3.org/1999/02/22-rdf-syntax-ns#type, http://tracker.api.gnome.org/ontology/v3/nfo#FileHash
urn:bnode:41bf8093-a4b6-4716-991f-502f24529e1b, http://www.w3.org/1999/02/22-rdf-syntax-ns#type, http://www.w3.org/2000/01/rdf-schema#Resource
urn:bnode:41bf8093-a4b6-4716-991f-502f24529e1b, http://www.w3.org/1999/02/22-rdf-syntax-ns#type, http://tracker.api.gnome.org/ontology/v3/nfo#FileHash
urn:bnode:01982aaa-d1fc-44f7-9010-4306d937225e, http://www.w3.org/1999/02/22-rdf-syntax-ns#type, http://www.w3.org/2000/01/rdf-schema#Resource
urn:bnode:01982aaa-d1fc-44f7-9010-4306d937225e, http://www.w3.org/1999/02/22-rdf-syntax-ns#type, http://tracker.api.gnome.org/ontology/v3/nfo#FileHash
file:///home/jmlich/Videos/Raspberry%20PI%20with%20max7219%20and%20buttons-bTEAbe-913M.mp4, http://www.w3.org/1999/02/22-rdf-syntax-ns#type, http://www.w3.org/2000/01/rdf-schema#Resource
file:///home/jmlich/Videos/Raspberry%20PI%20with%20max7219%20and%20buttons-bTEAbe-913M.mp4, http://www.w3.org/1999/02/22-rdf-syntax-ns#type, http://tracker.api.gnome.org/ontology/v3/nie#DataObject
file:///home/jmlich/Videos/Raspberry%20PI%20with%20max7219%20and%20buttons-bTEAbe-913M.mp4, http://www.w3.org/1999/02/22-rdf-syntax-ns#type, http://tracker.api.gnome.org/ontology/v3/nfo#FileDataObject
urn:bnode:c38c80dc-bd91-46a9-85d6-d1f140aa5463, http://www.w3.org/1999/02/22-rdf-syntax-ns#type, http://www.w3.org/2000/01/rdf-schema#Resource
urn:bnode:c38c80dc-bd91-46a9-85d6-d1f140aa5463, http://www.w3.org/1999/02/22-rdf-syntax-ns#type, http://tracker.api.gnome.org/ontology/v3/nfo#FileHash
urn:bnode:11c71a5b-7c09-40dc-9bb7-727bd64452d1, http://www.w3.org/1999/02/22-rdf-syntax-ns#type, http://www.w3.org/2000/01/rdf-schema#Resource
urn:bnode:11c71a5b-7c09-40dc-9bb7-727bd64452d1, http://www.w3.org/1999/02/22-rdf-syntax-ns#type, http://tracker.api.gnome.org/ontology/v3/nie#InformationElement
urn:bnode:11c71a5b-7c09-40dc-9bb7-727bd64452d1, http://www.w3.org/1999/02/22-rdf-syntax-ns#type, http://tracker.api.gnome.org/ontology/v3/nfo#Media
urn:bnode:11c71a5b-7c09-40dc-9bb7-727bd64452d1, http://www.w3.org/1999/02/22-rdf-syntax-ns#type, http://tracker.api.gnome.org/ontology/v3/nfo#Audio
urn:bnode:11c71a5b-7c09-40dc-9bb7-727bd64452d1, http://www.w3.org/1999/02/22-rdf-syntax-ns#type, http://tracker.api.gnome.org/ontology/v3/nfo#Visual
urn:bnode:11c71a5b-7c09-40dc-9bb7-727bd64452d1, http://www.w3.org/1999/02/22-rdf-syntax-ns#type, http://tracker.api.gnome.org/ontology/v3/nfo#Video
urn:bnode:11c71a5b-7c09-40dc-9bb7-727bd64452d1, http://www.w3.org/1999/02/22-rdf-syntax-ns#type, http://tracker.api.gnome.org/ontology/v3/nmm#Video
urn:bnode:aa03692d-3ffa-4e15-a14b-bf357feed053, http://www.w3.org/1999/02/22-rdf-syntax-ns#type, http://www.w3.org/2000/01/rdf-schema#Resource
urn:bnode:aa03692d-3ffa-4e15-a14b-bf357feed053, http://www.w3.org/1999/02/22-rdf-syntax-ns#type, http://tracker.api.gnome.org/ontology/v3/nfo#FileHash
urn:bnode:bf4361ab-9184-4035-b7d8-d8c5808d0fc7, http://www.w3.org/1999/02/22-rdf-syntax-ns#type, http://www.w3.org/2000/01/rdf-schema#Resource
urn:bnode:bf4361ab-9184-4035-b7d8-d8c5808d0fc7, http://www.w3.org/1999/02/22-rdf-syntax-ns#type, http://tracker.api.gnome.org/ontology/v3/nie#InformationElement
urn:bnode:bf4361ab-9184-4035-b7d8-d8c5808d0fc7, http://www.w3.org/1999/02/22-rdf-syntax-ns#type, http://tracker.api.gnome.org/ontology/v3/nfo#Media
urn:bnode:bf4361ab-9184-4035-b7d8-d8c5808d0fc7, http://www.w3.org/1999/02/22-rdf-syntax-ns#type, http://tracker.api.gnome.org/ontology/v3/nfo#Audio
urn:bnode:bf4361ab-9184-4035-b7d8-d8c5808d0fc7, http://www.w3.org/1999/02/22-rdf-syntax-ns#type, http://tracker.api.gnome.org/ontology/v3/nfo#Visual
urn:bnode:bf4361ab-9184-4035-b7d8-d8c5808d0fc7, http://www.w3.org/1999/02/22-rdf-syntax-ns#type, http://tracker.api.gnome.org/ontology/v3/nfo#Video
urn:bnode:bf4361ab-9184-4035-b7d8-d8c5808d0fc7, http://www.w3.org/1999/02/22-rdf-syntax-ns#type, http://tracker.api.gnome.org/ontology/v3/nmm#Video
I am using manjaro on X86_64/kvm with following version of tracker packages:
local/tracker3 3.1.1-2 (gnome)
Desktop-neutral user information store, search tool and indexer
local/tracker3-miners 3.1.1-2 (gnome)
Collection of data extractors for Tracker/Nepomuk