GNOME Bugzilla – Bug 787853
tracker-store process consume 100% CPU and logs filled with message "Could not insert FTS text: constraint failed"
Last modified: 2021-05-26 22:24:17 UTC
systemd[1667]: Starting Tracker metadata database store and lookup manager... systemd[1667]: Started Tracker metadata database store and lookup manager. tracker-store[5035]: Unable to insert multiple values for subject `http://www.tracker-project.org/temp/nmm#albumTitle' and single valued property `rdfs:comment' (old_value: tracker-store[5035]: Could not insert FTS text: constraint failed tracker-store[5035]: Could not insert FTS text: constraint failed tracker-store[5035]: Could not insert FTS text: constraint failed tracker-store[5035]: Could not insert FTS text: constraint failed tracker-store[5035]: Could not insert FTS text: constraint failed tracker-store[5035]: Could not insert FTS text: constraint failed tracker-store[5035]: Could not insert FTS text: constraint failed tracker-store[5035]: Could not insert FTS text: constraint failed tracker-store[5035]: Could not insert FTS text: constraint failed tracker-store[5035]: Could not insert FTS text: constraint failed tracker-store[5035]: Could not insert FTS text: constraint failed tracker-store[5035]: Could not insert FTS text: constraint failed tracker-store[5035]: Could not insert FTS text: constraint failed tracker-store[5035]: Transaction rollback failed: cannot rollback - no transaction is active tracker-store[5035]: Cannot initialize database: constraint failed systemd[1667]: tracker-store.service: Main process exited, code=exited, status=1/FAILURE systemd[1667]: tracker-store.service: Unit entered failed state. systemd[1667]: tracker-store.service: Failed with result 'exit-code'. systemd[1667]: tracker-store.service: Service hold-off time over, scheduling restart. systemd[1667]: Stopped Tracker metadata database store and lookup manager. $ tracker --version Tracker 2.0.0 This program is free software and comes without any warranty. It is licensed under version 2 or later of the General Public License which can be viewed at: http://www.gnu.org/licenses/gpl.txt
log with verbosity debug: Sep 26 23:57:42 localhost.localdomain systemd[1561]: Starting Tracker metadata database store and lookup manager... Sep 26 23:57:42 localhost.localdomain tracker-store[28869]: Starting tracker-store 2.0.0 Sep 26 23:57:42 localhost.localdomain tracker-store[28869]: General options: Sep 26 23:57:42 localhost.localdomain tracker-store[28869]: Verbosity ............................ 3 Sep 26 23:57:42 localhost.localdomain tracker-store[28869]: Store options: Sep 26 23:57:42 localhost.localdomain tracker-store[28869]: Readonly mode ........................ no Sep 26 23:57:42 localhost.localdomain tracker-store[28869]: GraphUpdated Delay .................... 1000 Sep 26 23:57:42 localhost.localdomain tracker-store[28869]: Domain................................. org.freedesktop.Tracker1 Sep 26 23:57:42 localhost.localdomain tracker-store[28869]: Cache location......................... file:///home/mikhail/.cache/tracker Sep 26 23:57:42 localhost.localdomain tracker-store[28869]: Data location.......................... file:///home/mikhail/.local/share/tracker/data Sep 26 23:57:42 localhost.localdomain tracker-store[28869]: Ontology location...................... file:///usr/share/tracker/ontologies/nepomuk Sep 26 23:57:42 localhost.localdomain tracker-store[28869]: Log verbosity is set to 3, enabling D-Bus client lookup Sep 26 23:57:42 localhost.localdomain tracker-store[28869]: Registering D-Bus object... Sep 26 23:57:42 localhost.localdomain tracker-store[28869]: Path:'/org/freedesktop/Tracker1/Status' Sep 26 23:57:42 localhost.localdomain tracker-store[28869]: Type:'TrackerStatus' Sep 26 23:57:42 localhost.localdomain tracker-store[28869]: Registering D-Bus object... Sep 26 23:57:42 localhost.localdomain tracker-store[28869]: Path:'/org/freedesktop/Tracker1/Statistics' Sep 26 23:57:42 localhost.localdomain tracker-store[28869]: Type:'TrackerStatistics' Sep 26 23:57:42 localhost.localdomain tracker-store[28869]: Registering D-Bus object... Sep 26 23:57:42 localhost.localdomain tracker-store[28869]: Path:'/org/freedesktop/Tracker1/Resources' Sep 26 23:57:42 localhost.localdomain tracker-store[28869]: Type:'TrackerResources' Sep 26 23:57:42 localhost.localdomain tracker-store[28869]: Registering D-Bus object... Sep 26 23:57:42 localhost.localdomain tracker-store[28869]: Path:'/org/freedesktop/Tracker1/Steroids' Sep 26 23:57:42 localhost.localdomain tracker-store[28869]: Type:'TrackerSteroids' Sep 26 23:57:42 localhost.localdomain tracker-store[28869]: Registering D-Bus object... Sep 26 23:57:42 localhost.localdomain tracker-store[28869]: Path:'/org/freedesktop/Tracker1/Backup' Sep 26 23:57:42 localhost.localdomain tracker-store[28869]: Type:'TrackerBackup' Sep 26 23:57:42 localhost.localdomain tracker-store[28869]: Registering D-Bus service... Name:'org.freedesktop.Tracker1' Sep 26 23:57:42 localhost.localdomain systemd[1561]: Started Tracker metadata database store and lookup manager. Sep 26 23:57:42 localhost.localdomain tracker-store[28869]: Setting database locations Sep 26 23:57:42 localhost.localdomain tracker-store[28869]: Checking database directories exist Sep 26 23:57:42 localhost.localdomain tracker-store[28869]: Checking database version Sep 26 23:57:42 localhost.localdomain tracker-store[28869]: Checking whether database files exist Sep 26 23:57:42 localhost.localdomain tracker-store[28869]: Loading databases files... Sep 26 23:57:42 localhost.localdomain tracker-store[28869]: Didn't shut down cleanly last time, doing integrity checks Sep 26 23:57:42 localhost.localdomain tracker-store[28869]: Opened sqlite3 database:'/home/mikhail/.cache/tracker/meta.db' Sep 26 23:57:42 localhost.localdomain tracker-store[28869]: Setting page size to 8192 Sep 26 23:57:42 localhost.localdomain tracker-store[28869]: Setting cache size to 250 Sep 26 23:57:46 localhost.localdomain tracker-store[28869]: Opened sqlite3 database:'/home/mikhail/.cache/tracker/meta.db' Sep 26 23:57:46 localhost.localdomain tracker-store[28869]: Setting page size to 8192 Sep 26 23:57:46 localhost.localdomain tracker-store[28869]: Setting cache size to 250 Sep 26 23:57:46 localhost.localdomain tracker-store[28869]: Closed sqlite3 database:'/home/mikhail/.cache/tracker/meta.db' Sep 26 23:57:58 localhost.localdomain tracker-store[28869]: Unable to insert multiple values for subject `http://www.tracker-project.org/temp/nmm#albumTitle' and single valued property `rdfs:comment' (old_value: 'nmm:albumTitle is deprecated, use nie:title instead, extractors still need updating', new value: 'nmm:albumTitle is deprecated, use nie:title instead') Sep 26 23:57:58 localhost.localdomain tracker-store[28869]: Could not insert FTS text: constraint failed Sep 26 23:57:58 localhost.localdomain tracker-store[28869]: Could not insert FTS text: constraint failed Sep 26 23:57:58 localhost.localdomain tracker-store[28869]: Could not insert FTS text: constraint failed Sep 26 23:57:58 localhost.localdomain tracker-store[28869]: Could not insert FTS text: constraint failed Sep 26 23:57:58 localhost.localdomain tracker-store[28869]: Could not insert FTS text: constraint failed Sep 26 23:57:58 localhost.localdomain tracker-store[28869]: Could not insert FTS text: constraint failed Sep 26 23:57:58 localhost.localdomain tracker-store[28869]: Could not insert FTS text: constraint failed Sep 26 23:57:58 localhost.localdomain tracker-store[28869]: Could not insert FTS text: constraint failed Sep 26 23:57:58 localhost.localdomain tracker-store[28869]: Could not insert FTS text: constraint failed Sep 26 23:57:58 localhost.localdomain tracker-store[28869]: Could not insert FTS text: constraint failed Sep 26 23:57:58 localhost.localdomain tracker-store[28869]: Could not insert FTS text: constraint failed Sep 26 23:57:58 localhost.localdomain tracker-store[28869]: Could not insert FTS text: constraint failed Sep 26 23:57:58 localhost.localdomain tracker-store[28869]: Could not insert FTS text: constraint failed Sep 26 23:57:58 localhost.localdomain tracker-store[28869]: Transaction rollback failed: cannot rollback - no transaction is active Sep 26 23:57:58 localhost.localdomain tracker-store[28869]: Cannot initialize database: constraint failed Sep 26 23:57:58 localhost.localdomain systemd[1561]: tracker-store.service: Main process exited, code=exited, status=1/FAILURE Sep 26 23:57:58 localhost.localdomain systemd[1561]: tracker-store.service: Unit entered failed state. Sep 26 23:57:58 localhost.localdomain systemd[1561]: tracker-store.service: Failed with result 'exit-code'. Sep 26 23:57:58 localhost.localdomain systemd[1561]: tracker-store.service: Service hold-off time over, scheduling restart. Sep 26 23:57:58 localhost.localdomain systemd[1561]: Stopped Tracker metadata database store and lookup manager.
Created attachment 360481 [details] system log
GNOME is going to shut down bugzilla.gnome.org in favor of gitlab.gnome.org. As part of that, we are mass-closing older open tickets in bugzilla.gnome.org which have not seen updates for a longer time (resources are unfortunately quite limited so not every ticket can get handled). If you can still reproduce the situation described in this ticket in a recent and supported software version, then please follow https://wiki.gnome.org/GettingInTouch/BugReportingGuidelines and create a new enhancement request ticket at https://gitlab.gnome.org/GNOME/tracker/-/issues/ Thank you for your understanding and your help.