Bug ID 1131229
Summary [Build 441.4] openQA test fails in gnome_music - tracker cannot handle new path properly with updated sqlite3
Classification openSUSE
Product openSUSE Distribution
Version Leap 15.1
Hardware Other
URL https://openqa.opensuse.org/tests/896911/modules/gnome_music/steps/22
OS Other
Status NEW
Severity Normal
Priority P5 - None
Component GNOME
Assignee bnc-team-gnome@forge.provo.novell.com
Reporter mlin@suse.com
QA Contact qa-bugs@suse.de
Found By ---
Blocker --- 

## Observation

openQA test in scenario opensuse-15.1-DVD-x86_64-update_Leap_42.3_gnome@64bit
fails in
[gnome_music](https://openqa.opensuse.org/tests/896911/modules/gnome_music/steps/22)

## Reproducible

Fails since (at least) Build [441.4](https://openqa.opensuse.org/tests/896911)
(current job)


## Expected result

Last good: [440.5](https://openqa.opensuse.org/tests/896183) (or more recent)


## Further details

Always latest result in this scenario:
[latest](https://openqa.opensuse.org/tests/latest?machine=64bit&distri=opensuse&arch=x86_64&version=15.1&test=update_Leap_42.3_gnome&flavor=DVD)


After sqlite3 updated to 3.27, tracker looks cannot handle new path properly
then stopped to work,

    Apr 01 23:05:33 susetest dbus-daemon[18496]: [session uid=1000 pid=18496]
Activating via systemd: service name='org.freedesktop.Tracker1'
unit='tracker-store.service' requested by ':1.131' (uid=1000 pid=29589
comm="python3 /usr/bin/gnome-music ")
    Apr 01 23:05:33 susetest systemd[18478]: Starting Tracker metadata database
store and lookup manager...
    Apr 01 23:05:33 susetest dbus-daemon[18496]: [session uid=1000 pid=18496]
Successfully activated service 'org.freedesktop.Tracker1'
    Apr 01 23:05:33 susetest systemd[18478]: Started Tracker metadata database
store and lookup manager.
    Apr 01 23:05:34 susetest tracker-store[29592]: Cannot initialize database:
error in view fts_view: no such table:
main.nie:InformationElement_nie:keyword_TEMP (strerror of errno (not
necessarily related): No such file or directory)
    Apr 01 23:05:34 susetest /usr/lib/gdm/gdm-x-session[18492]: 23:05:34 ERROR 
      Cannot connect to tracker, error 'tracker_sparql_error-quark: Failed to
load SPARQL backend: GDBus.Error:org.freedesktop.DBus.Error.NoReply: Message
recipient disconnected from message bus without replying (6)'\Exiting
    Apr 01 23:05:34 susetest systemd[18478]: tracker-store.service: Main
process exited, code=exited, status=1/FAILURE
    Apr 01 23:05:34 susetest systemd[18478]: tracker-store.service: Unit
entered failed state.
    Apr 01 23:05:34 susetest systemd[18478]: tracker-store.service: Failed with
result 'exit-code'.
    Apr 01 23:05:34 susetest systemd[18478]: tracker-store.service: Service
RestartSec=100ms expired, scheduling restart.
    Apr 01 23:05:34 susetest systemd[18478]: Stopped Tracker metadata database
store and lookup manager.
    Apr 01 23:05:34 susetest systemd[18478]: Starting Tracker metadata database
store and lookup manager...
    Apr 01 23:05:34 susetest systemd[18478]: Started Tracker metadata database
store and lookup manager.
    Apr 01 23:05:35 susetest tracker-store[29600]: Cannot initialize database:
error in view fts_view: no such table:
main.nie:InformationElement_nie:keyword_TEMP (strerror of errno (not
necessarily related): No such file or directory)
    Apr 01 23:05:35 susetest systemd[18478]: tracker-store.service: Main
process exited, code=exited, status=1/FAILURE
    Apr 01 23:05:35 susetest systemd[18478]: tracker-store.service: Unit
entered failed state.
    Apr 01 23:05:35 susetest systemd[18478]: tracker-store.service: Failed with
result 'exit-code'.
    Apr 01 23:05:35 susetest systemd[18478]: tracker-store.service: Service
RestartSec=100ms expired, scheduling restart.
    Apr 01 23:05:35 susetest systemd[18478]: Stopped Tracker metadata database
store and lookup manager.
    Apr 01 23:05:35 susetest systemd[18478]: Starting Tracker metadata database
store and lookup manager...
    Apr 01 23:05:35 susetest systemd[18478]: Started Tracker metadata database
store and lookup manager.
    Apr 01 23:05:36 susetest tracker-store[29608]: Cannot initialize database:
error in view fts_view: no such table:
main.nie:InformationElement_nie:keyword_TEMP (strerror of errno (not
necessarily related): No such file or directory)
    Apr 01 23:05:36 susetest systemd[18478]: tracker-store.service: Main
process exited, code=exited, status=1/FAILURE
    Apr 01 23:05:36 susetest systemd[18478]: tracker-store.service: Unit
entered failed state.
    Apr 01 23:05:36 susetest systemd[18478]: tracker-store.service: Failed with
result 'exit-code'.
    Apr 01 23:05:36 susetest systemd[18478]: tracker-store.service: Service
RestartSec=100ms expired, scheduling restart.
    Apr 01 23:05:36 susetest systemd[18478]: Stopped Tracker metadata database
store and lookup manager.
    Apr 01 23:05:36 susetest systemd[18478]: Starting Tracker metadata database
store and lookup manager...
    Apr 01 23:05:36 susetest systemd[18478]: Started Tracker metadata database
store and lookup manager.
    Apr 01 23:05:37 susetest tracker-store[29616]: Cannot initialize database:
error in view fts_view: no such table:
main.nie:InformationElement_nie:keyword_TEMP (strerror of errno (not
necessarily related): No such file or directory)
    Apr 01 23:05:37 susetest systemd[18478]: tracker-store.service: Main
process exited, code=exited, status=1/FAILURE
    Apr 01 23:05:37 susetest systemd[18478]: tracker-store.service: Unit
entered failed state.
    Apr 01 23:05:37 susetest systemd[18478]: tracker-store.service: Failed with
result 'exit-code'.
    Apr 01 23:05:37 susetest systemd[18478]: tracker-store.service: Service
RestartSec=100ms expired, scheduling restart.
    Apr 01 23:05:37 susetest systemd[18478]: Stopped Tracker metadata database
store and lookup manager.
    Apr 01 23:05:37 susetest systemd[18478]: Starting Tracker metadata database
store and lookup manager...
    Apr 01 23:05:37 susetest systemd[18478]: Started Tracker metadata database
store and lookup manager.
    Apr 01 23:05:38 susetest tracker-store[29624]: Cannot initialize database:
error in view fts_view: no such table:
main.nie:InformationElement_nie:keyword_TEMP (strerror of errno (not
necessarily related): No such file or directory)
    Apr 01 23:05:38 susetest systemd[18478]: tracker-store.service: Main
process exited, code=exited, status=1/FAILURE
    Apr 01 23:05:38 susetest systemd[18478]: tracker-store.service: Unit
entered failed state.
    Apr 01 23:05:38 susetest systemd[18478]: tracker-store.service: Failed with
result 'exit-code'.
    Apr 01 23:05:38 susetest systemd[18478]: tracker-store.service: Service
RestartSec=100ms expired, scheduling restart.
    Apr 01 23:05:38 susetest systemd[18478]: Stopped Tracker metadata database
store and lookup manager.
    Apr 01 23:05:38 susetest systemd[18478]: tracker-store.service: Start
request repeated too quickly.
    Apr 01 23:05:38 susetest systemd[18478]: Failed to start Tracker metadata
database store and lookup manager.
    Apr 01 23:05:38 susetest systemd[18478]: tracker-store.service: Unit
entered failed state.
    Apr 01 23:05:38 susetest systemd[18478]: tracker-store.service: Failed with
result 'exit-code'.

we should update tracker to version >= 2.1.7 < 2.2.0 (due to 2.2.0 have another
issue https://bugzilla.opensuse.org/show_bug.cgi?id=1130055 ). Please note that
tracker is from SLE15 GA and sqlite3 is from SLE-15:Update.

You are receiving this mail because: