GNOME Bugzilla – Bug 764783
Warning: Could not create FTS delete statement: table fts5 has no column named nco:hobby
Last modified: 2016-05-07 19:42:27 UTC
I am getting this warning quite often, and Torben Andresen [1] is, too. Full warning: org.freedesktop.Tracker1[1773]: (tracker-store:2119): Tracker-WARNING **: Could not create FTS delete statement: table fts5 has no column named nco:hobby This warning started occurring after a full tracker database initialization was done and isn't connected (meaning: is no direct result of) any user interaction. As with [2] those warnings are useless without a file path. Please make the warning more specific or don't warn at all. [1] https://bugzilla.gnome.org/show_bug.cgi?id=764737#c1 [2] https://bugzilla.gnome.org/show_bug.cgi?id=764740
This warning means that the tracker 1.6 (using FTS4) -> 1.8 (using FTS5) transition hasn't been that smooth for your case... In order to trigger the change in 1.8, there had to be an ontology change so FTS tables are recreated with the new version. I chose removing that "nco:hobby" property from being fulltext-indexed. So it seems that on one hand your tracker database was successfully updated to FTS5, and that property is effectively non-fts. But OTOH, tracker seems to internally think the property is still fts, and thus the warnings. Could you paste the output of: tracker info http://www.semanticdesktop.org/ontologies/2007/03/22/nco#hobby It should have no traces of the tracker:fulltextIndexed property, although I suspect it does. In that case I'm mostly sure that running the following command once would remove the warning for good: tracker sparql -u -q "DELETE { <http://www.semanticdesktop.org/ontologies/2007/03/22/nco#hobby> tracker:fulltextIndexed ?any } WHERE { <http://www.semanticdesktop.org/ontologies/2007/03/22/nco#hobby> tracker:fulltextIndexed ?any }" Nonetheless would be great to know why didn't this happen automatically, as it should have been the case when modifying the database in response to the ontology changes.
*** This bug has been marked as a duplicate of bug 764737 ***
(In reply to Carlos Garnacho from comment #1) > This warning means that the tracker 1.6 (using FTS4) -> 1.8 (using FTS5) > transition hasn't been that smooth for your case... > > In order to trigger the change in 1.8, there had to be an ontology change so > FTS tables are recreated with the new version. I chose removing that > "nco:hobby" property from being fulltext-indexed. > > So it seems that on one hand your tracker database was successfully updated > to FTS5, and that property is effectively non-fts. But OTOH, tracker seems > to internally think the property is still fts, and thus the warnings. I deleted this database after upgrading from Fedora 23. No reason for any transition. > Could you paste the output of: > > tracker info http://www.semanticdesktop.org/ontologies/2007/03/22/nco#hobby How should I do that? I have no clue of how tracker works. > It should have no traces of the tracker:fulltextIndexed property, although I > suspect it does. In that case I'm mostly sure that running the following > command once would remove the warning for good: > > tracker sparql -u -q "DELETE { > <http://www.semanticdesktop.org/ontologies/2007/03/22/nco#hobby> > tracker:fulltextIndexed ?any } WHERE { > <http://www.semanticdesktop.org/ontologies/2007/03/22/nco#hobby> > tracker:fulltextIndexed ?any }" Should I still do that?