Bug#990146: tracker-store failure when extracting metadata
Philip Stewart
philip.stewart.public at gmail.com
Mon Jun 21 17:54:18 BST 2021
Package: tracker
Version: 2.3.6-2
Dear Maintainer,
I am encountering an error with tracker failing to store metadata and
consuming resources as it repeatedly tries and fails to continue.
A consequence of this is that one can no longer benefit from indexed
data for rapid searching in nautilus.
In the system logs, I observe:
------
Jun 21 14:47:38 kernel: traps: pool-tracker-st[3258] trap int3
ip:7f8801816ca7 sp:7f87fca43be0 error:0 in
libglib-2.0.so.0.6600.8[7f88017da000+88000]
Jun 21 14:47:38 tracker-store[3251]: SQLite error: database disk image
is malformed (errno: Success)
Jun 21 14:47:38 tracker-store[3251]: SQLite experienced an error with
file:'/home/philip/.cache/tracker/meta.db'. It is either NOT a SQLite
database or it is corrupt or there was an IO error accessing the data.
This file has now been removed and will be recreated on the next start.
Shutting down now.
Jun 21 14:47:38 systemd[1604]: tracker-store.service: Main process
exited, code=killed, status=5/TRAP
Jun 21 14:47:38 systemd[1604]: tracker-store.service: Failed with
result 'signal'.
Jun 21 14:47:38 systemd[1604]: tracker-store.service: Consumed 1min
43.874s CPU time.
Jun 21 14:47:38 tracker-extract[3479]: There was an error pushing
metadata: GDBus.Error:org.freedesktop.DBus.Error.NoReply: Message
recipient disconnected from message bus without replying
------
Soon followed by repeated messages, such as:
------
Jun 21 14:53:22 tracker-extract[3479]: Could not insert metadata for
item "file:///usr/share/applications/org.gnome.DiskUtility.desktop":
Subject `urn:uuid:ca70bdea-6f53-4426-89aa-61d87f5c1179' is not in
domain `nie:DataObject' of property `nie:dataSource'
------
I have tried resetting the databases and restarting the tracker daemon,
but the problem persists.
Increasing the log verbosity on the tracker daemon, it identifies the
following is relevant for a bug report:
------
Jun 21 14:49:14 tracker-extract[3479]:
--8<------------------------------
Jun 21 14:49:14 tracker-extract[3479]: The information relevant for a
bug report is between the dotted lines
Jun 21 14:49:15 tracker-extract[3479]: Could not insert metadata for
item
"file:///home/philip/Music/David%20Bowie/The%20Platinum%20Collection/1-17%20-%20Aladdin%20Sane.ogg":
Subject `urn:uuid:1c8c66e4-4895-48fc-ae55-da7bb55a3dc7' is not in
domain `nie:DataObject' of property `nie:dataSource'
Jun 21 14:49:15 tracker-extract[3479]: 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
Jun 21 14:49:15 tracker-extract[3479]: Sparql was:
DELETE WHERE {
GRAPH
<urn:uuid:472ed0cc-40ff-4e37-9c0c-062d78656540> {
<urn:uuid:1c8c66e4-4895-48fc-ae55-da7bb55a3dc7> nfo:genre ?nfo_genre }
};
DELETE WHERE {
GRAPH
<urn:uuid:472ed0cc-40ff-4e37-9c0c-062d78656540> {
<urn:uuid:1c8c66e4-4895-48fc-ae55-da7bb55a3dc7> nmm:trackNumber
?nmm_trackNumber } };
DELETE WHERE {
GRAPH
<urn:uuid:472ed0cc-40ff-4e37-9c0c-062d78656540> {
<urn:uuid:1c8c66e4-4895-48fc-ae55-da7bb55a3dc7> nmm:performer
?nmm_performer } };
DELETE WHERE {
GRAPH
<urn:uuid:472ed0cc-40ff-4e37-9c0c-062d78656540> {
<urn:uuid:1c8c66e4-4895-48fc-ae55-da7bb55a3dc7>
tracker:hasExternalReference ?tracker_hasExternalReference } };
DELETE WHERE {
GRAPH
<urn:uuid:472ed0cc-40ff-4e37-9c0c-062d78656540> {
<urn:uuid:1c8c66e4-4895-48fc-ae55-da7bb55a3dc7> nfo:averageBitrate
?nfo_averageBitrate } };
DELETE WHERE {
GRAPH
<urn:uuid:472ed0cc-40ff-4e37-9c0c-062d78656540> {
<urn:uuid:1c8c66e4-4895-48fc-ae55-da7bb55a3dc7> nie:title ?nie_title }
};
DELETE WHERE {
GRAPH
<urn:uuid:472ed0cc-40ff-4e37-9c0c-062d78656540> {
<urn:uuid:1c8c66e4-4895-48fc-ae55-da7bb55a3dc7> nie:contentCreated
?nie_contentCreated } };
DELETE WHERE {
GRAPH
<urn:uuid:472ed0cc-40ff-4e37-9c0c-062d78656540> {
<urn:uuid:1c8c66e4-4895-48fc-ae55-da7bb55a3dc7> nmm:musicAlbum
?nmm_musicAlbum } };
DELETE WHERE {
GRAPH
<urn:uuid:472ed0cc-40ff-4e37-9c0c-062d78656540> {
<urn:uuid:1c8c66e4-4895-48fc-ae55-da7bb55a3dc7> nmm:musicAlbumDisc
?nmm_musicAlbumDisc } };
DELETE WHERE {
GRAPH
<urn:uuid:472ed0cc-40ff-4e37-9c0c-062d78656540> {
<urn:uuid:1c8c66e4-4895-48fc-ae55-da7bb55a3dc7> nfo:duration
?nfo_duration } };
DELETE WHERE {
GRAPH
<urn:uuid:472ed0cc-40ff-4e37-9c0c-062d78656540> {
<urn:artist:David%20Bowie> tracker:hasExternalReference
?tracker_hasExternalReference } };
DELETE WHERE {
GRAPH
<urn:uuid:472ed0cc-40ff-4e37-9c0c-062d78656540> {
<urn:artist:David%20Bowie> nmm:artistName ?nmm_artistName } };
DELETE WHERE {
GRAPH
<urn:uuid:472ed0cc-40ff-4e37-9c0c-062d78656540> {
<urn:artist:David%20Bowie> rdf:type ?rdf_type } };
DELETE WHERE {
GRAPH
<urn:uuid:472ed0cc-40ff-4e37-9c0c-062d78656540> {
<urn:ExternalReference:https:%2F%2Fmusicbrainz.org%2Fdoc%2FArtist:5441c29d-3602-4898-b1a1-b77fa23b8e50>
tracker:referenceSource ?tracker_referenceSource } };
DELETE WHERE {
GRAPH
<urn:uuid:472ed0cc-40ff-4e37-9c0c-062d78656540> {
<urn:ExternalReference:https:%2F%2Fmusicbrainz.org%2Fdoc%2FArtist:5441c29d-3602-4898-b1a1-b77fa23b8e50>
tracker:referenceIdentifier ?tracker_referenceIdentifier } };
DELETE WHERE {
GRAPH
<urn:uuid:472ed0cc-40ff-4e37-9c0c-062d78656540> {
<urn:ExternalReference:https:%2F%2Fmusicbrainz.org%2Fdoc%2FArtist:5441c29d-3602-4898-b1a1-b77fa23b8e50>
rdf:type ?rdf_type } };
DELETE WHERE {
GRAPH
<urn:uuid:472ed0cc-40ff-4e37-9c0c-062d78656540> {
<urn:ExternalReference:https:%2F%2Fmusicbrainz.org%2Fdoc%2FRecording:20995676-3969-401b-961c-e309d4cfdfed>
tracker:referenceSource ?tracker_referenceSource } };
DELETE WHERE {
GRAPH
<urn:uuid:472ed0cc-40ff-4e37-9c0c-062d78656540> {
<urn:ExternalReference:https:%2F%2Fmusicbrainz.org%2Fdoc%2FRecording:20995676-3969-401b-961c-e309d4cfdfed>
tracker:referenceIdentifier ?tracker_referenceIdentifier } };
DELETE WHERE {
GRAPH
<urn:uuid:472ed0cc-40ff-4e37-9c0c-062d78656540> {
<urn:ExternalReference:https:%2F%2Fmusicbrainz.org%2Fdoc%2FRecording:20995676-3969-401b-961c-e309d4cfdfed>
rdf:type ?rdf_type } };
DELETE WHERE {
GRAPH
<urn:uuid:472ed0cc-40ff-4e37-9c0c-062d78656540> {
<urn:ExternalReference:https:%2F%2Fmusicbrainz.org%2Fdoc%2FTrack:adf4a3e5-6613-364a-9719-3d446f9863ea>
tracker:referenceSource ?tracker_referenceSource } };
DELETE WHERE {
GRAPH
<urn:uuid:472ed0cc-40ff-4e37-9c0c-062d78656540> {
<urn:ExternalReference:https:%2F%2Fmusicbrainz.org%2Fdoc%2FTrack:adf4a3e5-6613-364a-9719-3d446f9863ea>
tracker:referenceIdentifier ?tracker_referenceIdentifier } };
DELETE WHERE {
GRAPH
<urn:uuid:472ed0cc-40ff-4e37-9c0c-062d78656540> {
<urn:ExternalReference:https:%2F%2Fmusicbrainz.org%2Fdoc%2FTrack:adf4a3e5-6613-364a-9719-3d446f9863ea>
rdf:type ?rdf_type } };
DELETE WHERE {
GRAPH
<urn:uuid:472ed0cc-40ff-4e37-9c0c-062d78656540> {
<urn:album:The%20Platinum%20Collection:David%20Bowie:2005-11-07T00:00:00>
nie:title ?nie_title } };
DELETE WHERE {
GRAPH
<urn:uuid:472ed0cc-40ff-4e37-9c0c-062d78656540> {
<urn:album:The%20Platinum%20Collection:David%20Bowie:2005-11-07T00:00:00>
tracker:hasExternalReference ?tracker_hasExternalReference } };
DELETE WHERE {
GRAPH
<urn:uuid:472ed0cc-40ff-4e37-9c0c-062d78656540> {
<urn:album:The%20Platinum%20Collection:David%20Bowie:2005-11-07T00:00:00>
rdf:type ?rdf_type } };
DELETE WHERE {
GRAPH
<urn:uuid:472ed0cc-40ff-4e37-9c0c-062d78656540> {
<urn:ExternalReference:https:%2F%2Fmusicbrainz.org%2Fdoc%2FRelease:a4c4d6dc-ef36-4465-a212-4f1eab33a64d>
tracker:referenceSource ?tracker_referenceSource } };
DELETE WHERE {
GRAPH
<urn:uuid:472ed0cc-40ff-4e37-9c0c-062d78656540> {
<urn:ExternalReference:https:%2F%2Fmusicbrainz.org%2Fdoc%2FRelease:a4c4d6dc-ef36-4465-a212-4f1eab33a64d>
tracker:referenceIdentifier ?tracker_referenceIdentifier } };
DELETE WHERE {
GRAPH
<urn:uuid:472ed0cc-40ff-4e37-9c0c-062d78656540> {
<urn:ExternalReference:https:%2F%2Fmusicbrainz.org%2Fdoc%2FRelease:a4c4d6dc-ef36-4465-a212-4f1eab33a64d>
rdf:type ?rdf_type } };
DELETE WHERE {
GRAPH
<urn:uuid:472ed0cc-40ff-4e37-9c0c-062d78656540> {
<urn:ExternalReference:https:%2F%2Fmusicbrainz.org%2Fdoc%2FRelease_Group:0190b962-ec4f-47a8-977a-8b903f3ac34e>
tracker:referenceSource ?tracker_referenceSource } };
DELETE WHERE {
GRAPH
<urn:uuid:472ed0cc-40ff-4e37-9c0c-062d78656540> {
<urn:ExternalReference:https:%2F%2Fmusicbrainz.org%2Fdoc%2FRelease_Group:0190b962-ec4f-47a8-977a-8b903f3ac34e>
tracker:referenceIdentifier ?tracker_referenceIdentifier } };
DELETE WHERE {
GRAPH
<urn:uuid:472ed0cc-40ff-4e37-9c0c-062d78656540> {
<urn:ExternalReference:https:%2F%2Fmusicbrainz.org%2Fdoc%2FRelease_Group:0190b962-ec4f-47a8-977a-8b903f3ac34e>
rdf:type ?rdf_type } };
DELETE WHERE {
GRAPH
<urn:uuid:472ed0cc-40ff-4e37-9c0c-062d78656540> {
<urn:album-disc:The%20Platinum%20Collection:David%20Bowie:2005-11-07T00:00:00:Disc1>
nmm:setNumber ?nmm_setNumber } };
DELETE WHERE {
GRAPH
<urn:uuid:472ed0cc-40ff-4e37-9c0c-062d78656540> {
<urn:album-disc:The%20Platinum%20Collection:David%20Bowie:2005-11-07T00:00:00:Disc1>
nmm:albumDiscAlbum ?nmm_albumDiscAlbum } };
DELETE WHERE {
GRAPH
<urn:uuid:472ed0cc-40ff-4e37-9c0c-062d78656540> {
<urn:album-disc:The%20Platinum%20Collection:David%20Bowie:2005-11-07T00:00:00:Disc1>
rdf:type ?rdf_type } };
INSERT DATA {
GRAPH
<urn:uuid:472ed0cc-40ff-4e37-9c0c-062d78656540> {
<urn:ExternalReference:https:%2F%2Fmusicbrainz.org%2Fdoc%2FArtist:5441c29d-3602-4898-b1a1-b77fa23b8e50>
a tracker:ExternalReference ;
tracker:referenceSource
<https://musicbrainz.org/doc/Artist> ;
tracker:referenceIdentifier "5441c29d-3602-4898-b1a1-b77fa23b8e50" .
<urn:artist:David%20Bowie>
a nmm:Artist ;
tracker:hasExternalReference
<urn:ExternalReference:https:%2F%2Fmusicbrainz.org%2Fdoc%2FArtist:5441c29d-3602-4898-b1a1-b77fa23b8e50>
;
nmm:artistName "David
Bowie" .
<urn:ExternalReference:https:%2F%2Fmusicbrainz.org%2Fdoc%2FRecording:20995676-3969-401b-961c-e309d4cfdfed>
a tracker:ExternalReference ;
tracker:referenceSource
<https://musicbrainz.org/doc/Recording> ;
tracker:referenceIdentifier "20995676-3969-401b-961c-e309d4cfdfed" .
<urn:ExternalReference:https:%2F%2Fmusicbrainz.org%2Fdoc%2FTrack:adf4a3e5-6613-364a-9719-3d446f9863ea>
a tracker:ExternalReference ;
tracker:referenceSource
<https://musicbrainz.org/doc/Track> ;
tracker:referenceIdentifier "adf4a3e5-6613-364a-9719-3d446f9863ea" .
<urn:ExternalReference:https:%2F%2Fmusicbrainz.org%2Fdoc%2FRelease:a4c4d6dc-ef36-4465-a212-4f1eab33a64d>
a tracker:ExternalReference ;
tracker:referenceSource
<https://musicbrainz.org/doc/Release> ;
tracker:referenceIdentifier "a4c4d6dc-ef36-4465-a212-4f1eab33a64d" .
<urn:ExternalReference:https:%2F%2Fmusicbrainz.org%2Fdoc%2FRelease_Group:0190b962-ec4f-47a8-977a-8b903f3ac34e>
a tracker:ExternalReference ;
tracker:referenceSource
<https://musicbrainz.org/doc/Release_Group> ;
tracker:referenceIdentifier "0190b962-ec4f-47a8-977a-8b903f3ac34e" .
<urn:album:The%20Platinum%20Collection:David%20Bowie:2005-11-07T00:00:00>
a nmm:MusicAlbum ;
nie:title "The Platinum
Collection" ;
tracker:hasExternalReference
<urn:ExternalReference:https:%2F%2Fmusicbrainz.org%2Fdoc%2FRelease:a4c4d6dc-ef36-4465-a212-4f1eab33a64d>
,
<urn:ExternalReference:https:%2F%2Fmusicbrainz.org%2Fdoc%2FRelease_Group:0190b962-ec4f-47a8-977a-8b903f3ac34e>
;
nmm:albumArtist
<urn:artist:David%20Bowie> .
<urn:album-disc:The%20Platinum%20Collection:David%20Bowie:2005-11-07T00:00:00:Disc1>
a nmm:MusicAlbumDisc ;
nmm:setNumber 1 ;
nmm:albumDiscAlbum
<urn:album:The%20Platinum%20Collection:David%20Bowie:2005-11-07T00:00:00>
More information about the pkg-gnome-maintainers
mailing list