Since dev-db/sqlite-3.11.1, tracker search does not work and syslog is hammered with messages of the type org.freedesktop.Tracker1[2483]: (tracker-store:2656): Tracker-WARNING **: Could not create FTS delete statement: unknown tokenizer: TrackerTokenizer Gnome Tracker 1.7.4 possibly fixes this issue by including support for FTS5. https://bugzilla.gnome.org/show_bug.cgi?id=762226
I think the changes are too big to try to backport them for 1.6.x cycle, we should probably wait for the next cycle (as upstream will do)
Created attachment 427976 [details, diff] tracker-1.6.1-sqlite-3.11.patch Untested but probably working patch.
(In reply to Arfrever Frehtes Taifersar Arahesis from comment #2) > Created attachment 427976 [details, diff] [details, diff] > tracker-1.6.1-sqlite-3.11.patch > > Untested but probably working patch. Tried it - applies cleanly and after restarting tracker, GTK searching now works - thanks!
Please try with 1.6.2 version
Upstream of app-misc/tracker worked around problem by bundling SQLite 3.11.0 and building it with -DSQLITE_ENABLE_FTS3_TOKENIZER. However new versions of SQLite often contain fixes for security problems. And such fixes are also in SQLite 3.12.0 (bug #578940).
They did what they were able to do taking care our sqlite version is applying some custom patches to allow the other way :/
(In reply to Pacho Ramos from comment #6) > They did what they were able to do taking care our sqlite version is > applying some custom patches to allow the other way :/ Are we still applying that patches in sqlite-3.12? If that is not the case and they can really rely on some official/upstream sqlite version they maybe could change it back to using the system copy
Also, dropping the blockers are only causing to cause breakage on this as you are hiding the regression :|
I have reported it to upstream: https://bugzilla.gnome.org/show_bug.cgi?id=764554
The patch in SQLite 3.11.0 and 3.11.1 is straight backport from SQLite upstream repository and is included in vanilla SQLite 3.12.0. It seems that bundling of SQLite 3.11.0 is in Tracker 1.6.*, but not in Tracker 1.8.*. https://git.gnome.org/browse/tracker/log/configure.ac?h=tracker-1.6 https://git.gnome.org/browse/tracker/commit/?h=tracker-1.6&id=49d0cb55c35a9c97c42ba815f7f52ba9f5416857 https://git.gnome.org/browse/tracker/log/configure.ac?h=tracker-1.8
dev-db/sqlite-3.11.1 is already stable on all architectures on which app-misc/tracker-1.6.1 is stable. (No other version of app-misc/tracker is stable on any architecture.) Security fixes in dev-db/sqlite-3.12.0 are completely unrelated and no point in attempting to block stabilization of dev-db/sqlite-3.12.0.
Only 1.8 included the real fixes from 1.7.x branch for not needing the DSQLITE_ENABLE_FTS3_TOKENIZER (In reply to Arfrever Frehtes Taifersar Arahesis from comment #11) > dev-db/sqlite-3.11.1 is already stable on all architectures on which > app-misc/tracker-1.6.1 is stable. right, I see arch teams simply ignored the block, I will need to remember to unCC them next time too :@
(In reply to Pacho Ramos from comment #12) > Only 1.8 included the real fixes from 1.7.x branch for not needing the > DSQLITE_ENABLE_FTS3_TOKENIZER I recommend to add app-misc/tracker-1.8.0... > (In reply to Arfrever Frehtes Taifersar Arahesis from comment #11) > > dev-db/sqlite-3.11.1 is already stable on all architectures on which > > app-misc/tracker-1.6.1 is stable. > > right, I see arch teams simply ignored the block, I will need to remember to > unCC them next time too :@ app-misc/tracker-1.6.1 is stable only on amd64 and x86. Stabilization of dev-db/sqlite-3.11.1 on amd64 and x86 finished before block was added.
(In reply to Arfrever Frehtes Taifersar Arahesis from comment #13) > (In reply to Pacho Ramos from comment #12) > > Only 1.8 included the real fixes from 1.7.x branch for not needing the > > DSQLITE_ENABLE_FTS3_TOKENIZER > > I recommend to add app-misc/tracker-1.8.0... I disagree with now pushing 1.8.x (and the changes that upstream decided to not apply to older tracker versions as they wanted them to be tested in 1.7.x cycle) without thinking in reverse tracker deps and, then, moving the breakage to other apps :| Lets see if upstream refixes the older branches to handle this in a better way (it should do as all the other distributions are still needing to have a fixed tracker-1.6 too)
I will try to revert the upstream configure changes to let us use system sqlite again and apply Arfrever patch since upstream looks to not care :S
Created attachment 431718 [details] tracker-1.6.2-r1.ebuild ebuild trying to use system sqlite
Created attachment 431720 [details, diff] tracker-1.6.2-system-sqlite.patch
I have tried but tracker fails at runtime: abr 23 19:12:24 belkin5 org.freedesktop.Tracker1[637]: (tracker-store:1606): Tracker-CRITICAL **: Cannot initialize database: Could not open sqlite3 database:'/home/pacho/.cache/tracker/meta.db': library routine called out of name='org.freedesktop.Tracker1'
1.6.2 and 1.8.0 in the tree for this
