Public bug reported:
While tracker is indexing, I can obtain search results from the "super"
key menu or using tracker search, e.g. "tracker search Magnetic". After
a few minutes, this stops working and further searches yield no results.
tracker status reports:
Currently indexed: 2 files, 0 folders
Remaining space on database partition: 729.7 GB (82.65%)
All data miners are idle, indexing complete
To investigate, I ran:
tracker daemon --set-log-verbosity debug
tracker daemon --terminate
tracker reset --hard
tracker daemon --start
This reproduces the issue.
The system log then contains many entries like the following (this is
the first):
May 23 11:35:30 Minmus tracker-store[22586]: Preparing query: 'SELECT
"v_nfo_manufacturer" AS "nfo_manufacturer" FROM (SELECT
"nfo:Equipment1"."nfo:manufacturer" AS "v_nfo_manufacturer" FROM
"nfo:Equipment" AS "nfo:Equipment1" WHERE "v_nfo_manufacturer" IS NOT NULL AND
"nfo:Equipment1"."ID" = COALESCE ((SELECT ID FROM Resource WHERE Uri = ?1 ), 0)
AND "nfo:Equipment1"."nfo:manufacturer:graph" = COALESCE ((SELECT ID FROM
Resource WHERE Uri = ?2 ), 0) )'
May 23 11:35:30 Minmus tracker-store[22586]: Preparing query: 'ROLLBACK'
May 23 11:35:30 Minmus tracker-store[22586]: Preparing query: 'PRAGMA
cache_size = 250'
May 23 11:35:30 Minmus tracker-store[22586]: ---> [1|tracker-extract|21687]
Success, no error given
May 23 11:35:30 Minmus tracker-extract[21687]: Tracker.Sparql.Backend.query():
'SELECT COALESCE (nie:url (?u), ?u) { ?u a rdfs:Resource. FILTER (tracker:id
(?u) = 120987)}'
May 23 11:35:30 Minmus tracker-extract[21687]: Preparing query: 'SELECT
COALESCE ((SELECT "nie:url" FROM "nie:DataObject" WHERE ID = "v_u" ) , (SELECT
Uri FROM Resource WHERE ID = "v_u" ) ) FROM (SELECT * FROM (SELECT
"rdfs:Resource1"."ID" AS "v_u" FROM "rdfs:Resource" AS "rdfs:Resource1" ) WHERE
("v_u" = ?1 ) ) 'May 23 11:35:30 Minmus tracker-extract[21687]:
--8<------------------------------
May 23 11:35:30 Minmus tracker-extract[21687]: The information relevant for a
bug report is between the dotted lines
May 23 11:35:30 Minmus tracker-extract[21687]: Could not insert metadata for
item
"file:///home/merlin/Pictures/Places/Egypt_Jan09/040109_PyramidsSphinx/DSC00994.JPG":
Subject `urn:uuid:6b7dd0fd-6a9c-42d9-b308-18c60d0043fb' is not in domain
`nie:DataObject' of property `nie:dataSource'
May 23 11:35:30 Minmus tracker-extract[21687]: 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
May 23 11:35:30 Minmus tracker-extract[21687]: Sparql was:
DELETE WHERE {
GRAPH
<urn:uuid:472ed0cc-40ff-4e37-9c0c-062d78656540> {
<urn:uuid:6b7dd0fd-6a9c-42d9-b308-18c60d0043fb> nmm:fnumber ?nmm_fnumber } };
DELETE WHERE {
GRAPH
<urn:uuid:472ed0cc-40ff-4e37-9c0c-062d78656540> {
<urn:uuid:6b7dd0fd-6a9c-42d9-b308-18c60d0043fb> nfo:orientation
?nfo_orientation } };
DELETE WHERE {
GRAPH
<urn:uuid:472ed0cc-40ff-4e37-9c0c-062d78656540> {
<urn:uuid:6b7dd0fd-6a9c-42d9-b308-18c60d0043fb> nfo:width ?nfo_width } };
DELETE WHERE {
GRAPH
<urn:uuid:472ed0cc-40ff-4e37-9c0c-062d78656540> {
<urn:uuid:6b7dd0fd-6a9c-42d9-b308-18c60d0043fb> nfo:verticalResolution
?nfo_verticalResolution } };
DELETE WHERE {
GRAPH
<urn:uuid:472ed0cc-40ff-4e37-9c0c-062d78656540> {
<urn:uuid:6b7dd0fd-6a9c-42d9-b308-18c60d0043fb> nmm:dlnaProfile
?nmm_dlnaProfile } };
DELETE WHERE {
GRAPH
<urn:uuid:472ed0cc-40ff-4e37-9c0c-062d78656540> {
<urn:uuid:6b7dd0fd-6a9c-42d9-b308-18c60d0043fb> nmm:exposureTime
?nmm_exposureTime } };
DELETE WHERE {
GRAPH
<urn:uuid:472ed0cc-40ff-4e37-9c0c-062d78656540> {
<urn:uuid:6b7dd0fd-6a9c-42d9-b308-18c60d0043fb> nmm:dlnaMime ?nmm_dlnaMime } };
DELETE WHERE {
GRAPH
<urn:uuid:472ed0cc-40ff-4e37-9c0c-062d78656540> {
<urn:uuid:6b7dd0fd-6a9c-42d9-b308-18c60d0043fb> nmm:whiteBalance
?nmm_whiteBalance } };
DELETE WHERE {
GRAPH
<urn:uuid:472ed0cc-40ff-4e37-9c0c-062d78656540> {
<urn:uuid:6b7dd0fd-6a9c-42d9-b308-18c60d0043fb> nmm:isoSpeed ?nmm_isoSpeed } };
DELETE WHERE {
GRAPH
<urn:uuid:472ed0cc-40ff-4e37-9c0c-062d78656540> {
<urn:uuid:6b7dd0fd-6a9c-42d9-b308-18c60d0043fb> nie:contentCreated
?nie_contentCreated } };
DELETE WHERE {
GRAPH
<urn:uuid:472ed0cc-40ff-4e37-9c0c-062d78656540> {
<urn:uuid:6b7dd0fd-6a9c-42d9-b308-18c60d0043fb> nfo:equipment ?nfo_equipment }
};
DELETE WHERE {
GRAPH
<urn:uuid:472ed0cc-40ff-4e37-9c0c-062d78656540> {
<urn:uuid:6b7dd0fd-6a9c-42d9-b308-18c60d0043fb> nmm:flash ?nmm_flash } };
DELETE WHERE {
GRAPH
<urn:uuid:472ed0cc-40ff-4e37-9c0c-062d78656540> {
<urn:uuid:6b7dd0fd-6a9c-42d9-b308-18c60d0043fb> nmm:meteringMode
?nmm_meteringMode } };
DELETE WHERE {
GRAPH
<urn:uuid:472ed0cc-40ff-4e37-9c0c-062d78656540> {
<urn:uuid:6b7dd0fd-6a9c-42d9-b308-18c60d0043fb> nmm:focalLength
?nmm_focalLength } };
DELETE WHERE {
GRAPH
<urn:uuid:472ed0cc-40ff-4e37-9c0c-062d78656540> {
<urn:uuid:6b7dd0fd-6a9c-42d9-b308-18c60d0043fb> nfo:horizontalResolution
?nfo_horizontalResolution } };
DELETE WHERE {
GRAPH
<urn:uuid:472ed0cc-40ff-4e37-9c0c-062d78656540> {
<urn:uuid:6b7dd0fd-6a9c-42d9-b308-18c60d0043fb> nfo:height ?nfo_height } };
DELETE WHERE {
GRAPH
<urn:uuid:472ed0cc-40ff-4e37-9c0c-062d78656540> {
<urn:equipment:SONY:DSC-H2:>
nfo:model ?nfo_model } };
DELETE WHERE {
GRAPH
<urn:uuid:472ed0cc-40ff-4e37-9c0c-062d78656540> {
<urn:equipment:SONY:DSC-H2:>
rdf:type ?rdf_type } };
DELETE WHERE {
GRAPH
<urn:uuid:472ed0cc-40ff-4e37-9c0c-062d78656540> {
<urn:equipment:SONY:DSC-H2:>
nfo:manufacturer ?nfo_manufacturer } };
INSERT DATA {
GRAPH
<urn:uuid:472ed0cc-40ff-4e37-9c0c-062d78656540> {
<urn:equipment:SONY:DSC-H2:> a
nfo:Equipment ;
nfo:model "DSC-H2" ;
nfo:manufacturer "SONY" .
<urn:uuid:6b7dd0fd-6a9c-42d9-b308-18c60d0043fb> a nfo:Image , nmm:Photo ;
nmm:fnumber 4.5 ;
nfo:orientation
nfo:orientation-top ;
nfo:width 2816 ;
nfo:verticalResolution 72 ;
nmm:dlnaProfile "JPEG_LRG" ;
nie:dataSource
<http://www.tracker-project.org/ontologies/tracker#extractor-data-source> ;
nmm:exposureTime 0.001 ;
nmm:dlnaMime "image/jpeg" ;
nmm:whiteBalance
nmm:white-balance-auto ;
nmm:isoSpeed 80 ;
nie:contentCreated
"2009-01-04T10:32:52+0000" ;
nfo:equipment
<urn:equipment:SONY:DSC-H2:> ;
nmm:flash nmm:flash-off ;
nmm:meteringMode
nmm:metering-mode-pattern ;
nmm:focalLength
21.100000000000001 ;
nfo:horizontalResolution 72 ;
nfo:height 2112 .
}
};
May 23 11:35:30 Minmus tracker-extract[21687]: NOTE: The information above may
contain data you consider sensitive. Feel free to edit it out, but please keep
it as unmodified as you possibly can.
May 23 11:35:30 Minmus tracker-extract[21687]:
------------------------------>8--
Timing is at least roughly consistent with the loss of tracker results.
tracker --version gives:
Tracker 2.3.6
~/.cache/tracker contains a reasonably sized database (4.5 MB).
lsb_release -rd:
Description: Ubuntu 21.04
Release: 21.04
apt-cache policy tracker gives:
tracker:
Installed: 2.3.6-2
Candidate: 2.3.6-2
Version table:
*** 2.3.6-2 500
500 http://gb.archive.ubuntu.com/ubuntu hirsute/main amd64 Packages
100 /var/lib/dpkg/status
** Affects: tracker-miners (Ubuntu)
Importance: Undecided
Status: New
--
You received this bug notification because you are a member of Desktop
Packages, which is subscribed to tracker-miners in Ubuntu.
https://bugs.launchpad.net/bugs/1929328
Title:
No tracker search results
Status in tracker-miners package in Ubuntu:
New
Bug description:
While tracker is indexing, I can obtain search results from the
"super" key menu or using tracker search, e.g. "tracker search
Magnetic". After a few minutes, this stops working and further
searches yield no results. tracker status reports:
Currently indexed: 2 files, 0 folders
Remaining space on database partition: 729.7 GB (82.65%)
All data miners are idle, indexing complete
To investigate, I ran:
tracker daemon --set-log-verbosity debug
tracker daemon --terminate
tracker reset --hard
tracker daemon --start
This reproduces the issue.
The system log then contains many entries like the following (this is
the first):
May 23 11:35:30 Minmus tracker-store[22586]: Preparing query: 'SELECT
"v_nfo_manufacturer" AS "nfo_manufacturer" FROM (SELECT
"nfo:Equipment1"."nfo:manufacturer" AS "v_nfo_manufacturer" FROM
"nfo:Equipment" AS "nfo:Equipment1" WHERE "v_nfo_manufacturer" IS NOT NULL AND
"nfo:Equipment1"."ID" = COALESCE ((SELECT ID FROM Resource WHERE Uri = ?1 ), 0)
AND "nfo:Equipment1"."nfo:manufacturer:graph" = COALESCE ((SELECT ID FROM
Resource WHERE Uri = ?2 ), 0) )'
May 23 11:35:30 Minmus tracker-store[22586]: Preparing query: 'ROLLBACK'
May 23 11:35:30 Minmus tracker-store[22586]: Preparing query: 'PRAGMA
cache_size = 250'
May 23 11:35:30 Minmus tracker-store[22586]: ---> [1|tracker-extract|21687]
Success, no error given
May 23 11:35:30 Minmus tracker-extract[21687]:
Tracker.Sparql.Backend.query(): 'SELECT COALESCE (nie:url (?u), ?u) { ?u a
rdfs:Resource. FILTER (tracker:id (?u) = 120987)}'
May 23 11:35:30 Minmus tracker-extract[21687]: Preparing query: 'SELECT
COALESCE ((SELECT "nie:url" FROM "nie:DataObject" WHERE ID = "v_u" ) , (SELECT
Uri FROM Resource WHERE ID = "v_u" ) ) FROM (SELECT * FROM (SELECT
"rdfs:Resource1"."ID" AS "v_u" FROM "rdfs:Resource" AS "rdfs:Resource1" ) WHERE
("v_u" = ?1 ) ) 'May 23 11:35:30 Minmus tracker-extract[21687]:
--8<------------------------------
May 23 11:35:30 Minmus tracker-extract[21687]: The information relevant for a
bug report is between the dotted lines
May 23 11:35:30 Minmus tracker-extract[21687]: Could not insert metadata for
item
"file:///home/merlin/Pictures/Places/Egypt_Jan09/040109_PyramidsSphinx/DSC00994.JPG":
Subject `urn:uuid:6b7dd0fd-6a9c-42d9-b308-18c60d0043fb' is not in domain
`nie:DataObject' of property `nie:dataSource'
May 23 11:35:30 Minmus tracker-extract[21687]: 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
May 23 11:35:30 Minmus tracker-extract[21687]: Sparql was:
DELETE WHERE {
GRAPH
<urn:uuid:472ed0cc-40ff-4e37-9c0c-062d78656540> {
<urn:uuid:6b7dd0fd-6a9c-42d9-b308-18c60d0043fb> nmm:fnumber ?nmm_fnumber } };
DELETE WHERE {
GRAPH
<urn:uuid:472ed0cc-40ff-4e37-9c0c-062d78656540> {
<urn:uuid:6b7dd0fd-6a9c-42d9-b308-18c60d0043fb> nfo:orientation
?nfo_orientation } };
DELETE WHERE {
GRAPH
<urn:uuid:472ed0cc-40ff-4e37-9c0c-062d78656540> {
<urn:uuid:6b7dd0fd-6a9c-42d9-b308-18c60d0043fb> nfo:width ?nfo_width } };
DELETE WHERE {
GRAPH
<urn:uuid:472ed0cc-40ff-4e37-9c0c-062d78656540> {
<urn:uuid:6b7dd0fd-6a9c-42d9-b308-18c60d0043fb> nfo:verticalResolution
?nfo_verticalResolution } };
DELETE WHERE {
GRAPH
<urn:uuid:472ed0cc-40ff-4e37-9c0c-062d78656540> {
<urn:uuid:6b7dd0fd-6a9c-42d9-b308-18c60d0043fb> nmm:dlnaProfile
?nmm_dlnaProfile } };
DELETE WHERE {
GRAPH
<urn:uuid:472ed0cc-40ff-4e37-9c0c-062d78656540> {
<urn:uuid:6b7dd0fd-6a9c-42d9-b308-18c60d0043fb> nmm:exposureTime
?nmm_exposureTime } };
DELETE WHERE {
GRAPH
<urn:uuid:472ed0cc-40ff-4e37-9c0c-062d78656540> {
<urn:uuid:6b7dd0fd-6a9c-42d9-b308-18c60d0043fb> nmm:dlnaMime ?nmm_dlnaMime } };
DELETE WHERE {
GRAPH
<urn:uuid:472ed0cc-40ff-4e37-9c0c-062d78656540> {
<urn:uuid:6b7dd0fd-6a9c-42d9-b308-18c60d0043fb> nmm:whiteBalance
?nmm_whiteBalance } };
DELETE WHERE {
GRAPH
<urn:uuid:472ed0cc-40ff-4e37-9c0c-062d78656540> {
<urn:uuid:6b7dd0fd-6a9c-42d9-b308-18c60d0043fb> nmm:isoSpeed ?nmm_isoSpeed } };
DELETE WHERE {
GRAPH
<urn:uuid:472ed0cc-40ff-4e37-9c0c-062d78656540> {
<urn:uuid:6b7dd0fd-6a9c-42d9-b308-18c60d0043fb> nie:contentCreated
?nie_contentCreated } };
DELETE WHERE {
GRAPH
<urn:uuid:472ed0cc-40ff-4e37-9c0c-062d78656540> {
<urn:uuid:6b7dd0fd-6a9c-42d9-b308-18c60d0043fb> nfo:equipment ?nfo_equipment }
};
DELETE WHERE {
GRAPH
<urn:uuid:472ed0cc-40ff-4e37-9c0c-062d78656540> {
<urn:uuid:6b7dd0fd-6a9c-42d9-b308-18c60d0043fb> nmm:flash ?nmm_flash } };
DELETE WHERE {
GRAPH
<urn:uuid:472ed0cc-40ff-4e37-9c0c-062d78656540> {
<urn:uuid:6b7dd0fd-6a9c-42d9-b308-18c60d0043fb> nmm:meteringMode
?nmm_meteringMode } };
DELETE WHERE {
GRAPH
<urn:uuid:472ed0cc-40ff-4e37-9c0c-062d78656540> {
<urn:uuid:6b7dd0fd-6a9c-42d9-b308-18c60d0043fb> nmm:focalLength
?nmm_focalLength } };
DELETE WHERE {
GRAPH
<urn:uuid:472ed0cc-40ff-4e37-9c0c-062d78656540> {
<urn:uuid:6b7dd0fd-6a9c-42d9-b308-18c60d0043fb> nfo:horizontalResolution
?nfo_horizontalResolution } };
DELETE WHERE {
GRAPH
<urn:uuid:472ed0cc-40ff-4e37-9c0c-062d78656540> {
<urn:uuid:6b7dd0fd-6a9c-42d9-b308-18c60d0043fb> nfo:height ?nfo_height } };
DELETE WHERE {
GRAPH
<urn:uuid:472ed0cc-40ff-4e37-9c0c-062d78656540> {
<urn:equipment:SONY:DSC-H2:>
nfo:model ?nfo_model } };
DELETE WHERE {
GRAPH
<urn:uuid:472ed0cc-40ff-4e37-9c0c-062d78656540> {
<urn:equipment:SONY:DSC-H2:>
rdf:type ?rdf_type } };
DELETE WHERE {
GRAPH
<urn:uuid:472ed0cc-40ff-4e37-9c0c-062d78656540> {
<urn:equipment:SONY:DSC-H2:>
nfo:manufacturer ?nfo_manufacturer } };
INSERT DATA {
GRAPH
<urn:uuid:472ed0cc-40ff-4e37-9c0c-062d78656540> {
<urn:equipment:SONY:DSC-H2:> a
nfo:Equipment ;
nfo:model "DSC-H2" ;
nfo:manufacturer "SONY" .
<urn:uuid:6b7dd0fd-6a9c-42d9-b308-18c60d0043fb> a nfo:Image , nmm:Photo ;
nmm:fnumber 4.5 ;
nfo:orientation
nfo:orientation-top ;
nfo:width 2816 ;
nfo:verticalResolution 72 ;
nmm:dlnaProfile "JPEG_LRG" ;
nie:dataSource
<http://www.tracker-project.org/ontologies/tracker#extractor-data-source> ;
nmm:exposureTime 0.001 ;
nmm:dlnaMime "image/jpeg" ;
nmm:whiteBalance
nmm:white-balance-auto ;
nmm:isoSpeed 80 ;
nie:contentCreated
"2009-01-04T10:32:52+0000" ;
nfo:equipment
<urn:equipment:SONY:DSC-H2:> ;
nmm:flash nmm:flash-off ;
nmm:meteringMode
nmm:metering-mode-pattern ;
nmm:focalLength
21.100000000000001 ;
nfo:horizontalResolution 72
;
nfo:height 2112 .
}
};
May 23 11:35:30 Minmus tracker-extract[21687]: NOTE: The information above
may contain data you consider sensitive. Feel free to edit it out, but please
keep it as unmodified as you possibly can.
May 23 11:35:30 Minmus tracker-extract[21687]:
------------------------------>8--
Timing is at least roughly consistent with the loss of tracker
results.
tracker --version gives:
Tracker 2.3.6
~/.cache/tracker contains a reasonably sized database (4.5 MB).
lsb_release -rd:
Description: Ubuntu 21.04
Release: 21.04
apt-cache policy tracker gives:
tracker:
Installed: 2.3.6-2
Candidate: 2.3.6-2
Version table:
*** 2.3.6-2 500
500 http://gb.archive.ubuntu.com/ubuntu hirsute/main amd64 Packages
100 /var/lib/dpkg/status
To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/tracker-miners/+bug/1929328/+subscriptions
--
Mailing list: https://launchpad.net/~desktop-packages
Post to : [email protected]
Unsubscribe : https://launchpad.net/~desktop-packages
More help : https://help.launchpad.net/ListHelp
