Bug 16083

Summary:	baloo indexing and search not working (missing dependency)
Product:	Mageia	Reporter:	PC LX <mageia>
Component:	RPM Packages	Assignee:	QA Team <qa-bugs>
Status:	RESOLVED FIXED	QA Contact:
Severity:	major
Priority:	Normal	CC:	davidwhodgins, lmenut, mageia, ottoleipala1, sysadmin-bugs, yochenhsieh
Version:	5	Keywords:	validated_update
Target Milestone:	---
Hardware:	All
OS:	Linux
Whiteboard:	advisory MGA5-32-OK
Source RPM:	baloo-4.14.3-1.mga5.src.rpm	CVE:
Status comment:

Description PC LX 2015-06-05 14:10:22 CEST

Description of problem:

baloo is not indexing files. Problem is caused by a failure to load the QSQLITE driver. QSQLITE driver is not included in the available drivers (see available drivers a few lines down). Available drivers include QSQLITE3 (notice the 3).

$ baloosearch test
QSqlDatabase: QSQLITE driver not loaded
QSqlDatabase: available drivers: QMYSQL3 QMYSQL QSQLITE3
$ balooctl restart
QSqlDatabase: QSQLITE driver not loaded
QSqlDatabase: available drivers: QMYSQL3 QMYSQL QSQLITE3
QSqlQuery::prepare: database not open
QSqlQuery::prepare: database not open
baloo_file(2541): "Driver not loaded Driver not loaded" 
baloo_file(2541): Cannot create fileMapping for "/home/artur"
... and many more like the last two for various directories.
$ ls -l /usr/lib64/qt5/plugins/sqldrivers/
total 388
-rwxr-xr-x 1 root root  59648 Abr 23 22:37 libqsqlite.so*
-rwxr-xr-x 1 root root  76544 Abr 23 22:37 libqsqlmysql.so*
-rwxr-xr-x 1 root root 105344 Abr 23 22:37 libqsqlodbc.so*
-rwxr-xr-x 1 root root  88976 Abr 23 22:37 libqsqlpsql.so*
-rwxr-xr-x 1 root root  59496 Abr 23 22:37 libqsqltds.so*



Version-Release number of selected component (if applicable):

$ rpm -qa | egrep 'baloo|qtbase5-database' | sort
baloo-4.14.3-1.mga5
lib64baloocore4-4.14.3-1.mga5
lib64baloofiles4-4.14.3-1.mga5
lib64baloopim4-4.14.3-1.mga5
lib64balooqueryparser4-4.14.3-1.mga5
lib64baloowidgets4-4.14.3-1.mga5
lib64balooxapian4-4.14.3-1.mga5
qtbase5-database-plugin-mysql-5.4.0-7.mga5
qtbase5-database-plugin-odbc-5.4.0-7.mga5
qtbase5-database-plugin-pgsql-5.4.0-7.mga5
qtbase5-database-plugin-sqlite-5.4.0-7.mga5
qtbase5-database-plugin-tds-5.4.0-7.mga5


How reproducible:

Always.


Steps to Reproduce:
1. Open terminal.
2. Run command "baloosearch test".
3. Run command "balooctl restart".
4. See error messages.


Reproducible: 

Steps to Reproduce:

Comment 1 PC LX 2015-06-05 15:27:31 CEST

After looking at the strace output of "ballosearch test" I noticed that it is using Qt4 (and not Qt5).

Listing the installed Qt4 database drivers revealed that only the MySQL driver was installed.

$ rpm -qa | grep qt4-database
qt4-database-plugin-mysql-4.8.6-9.mga5


I installed the qt4-database-plugin-sqlite package and after that running "baloosearch test" no longer shows any errors.

$ rpm -qa | grep qt4-database
qt4-database-plugin-sqlite-4.8.6-9.mga5
qt4-database-plugin-mysql-4.8.6-9.mga5
$ ls -la /usr/lib64/qt4/plugins/sqldrivers/
total 132
-rwxr-xr-x 1 root root 54792 Abr 23 22:56 libqsqlite.so*
-rwxr-xr-x 1 root root 76024 Abr 23 22:56 libqsqlmysql.so*


Running "balooctl restart; balooctl enable" also shows no errors and both "balooctl status" and iotop reveal that the indexing is underway.

After a while, both baloosearch and dolphin's search shows the expected results.

So, it seems that the problem is caused by a missing Qt4 SQLITE driver and this can probably be fixed by adding a package dependency for qt4-database-plugin-sqlite package in some (maybe baloo?) package.

Comment 2 Samuel Verschelde 2015-06-05 15:44:14 CEST

Thanks for investigating. Assigning to maintainer.

CC: (none) => lmenut
Assignee: bugsquad => mageia
Summary: baloo indexing and search not working (showing error QSqlDatabase: QSQLITE driver not loaded) => baloo indexing and search not working (missing dependency)
Whiteboard: (none) => MGA5TOO

Comment 3 You-Cheng Hsieh 2015-06-23 03:33:48 CEST

This problem will cause dolphin unable to seach files. Should it be noted in errata?

CC: (none) => yochenhsieh

Comment 4 Luc Menut 2015-06-30 23:15:56 CEST

Suggested advisory:
Updated baloo packages fix a missing dependency

Baloo requires the Qt4 QSQLITE driver to work properly, but this dependency was missing in packages.
This update add the missing dependency on qt4-database-plugin-sqlite.

Reference:
https://bugs.mageia.org/show_bug.cgi?id=16083

src.rpm:
baloo-4.14.3-1.1.mga5.src.rpm

packages i586:
baloo-4.14.3-1.1.mga5.i586.rpm
libbaloocore4-4.14.3-1.1.mga5.i586.rpm
libbaloo-devel-4.14.3-1.1.mga5.i586.rpm
libbaloofiles4-4.14.3-1.1.mga5.i586.rpm
libbaloopim4-4.14.3-1.1.mga5.i586.rpm
libbalooqueryparser4-4.14.3-1.1.mga5.i586.rpm
libbalooxapian4-4.14.3-1.1.mga5.i586.rpm

packages x86_64:
baloo-4.14.3-1.1.mga5.x86_64.rpm
lib64baloocore4-4.14.3-1.1.mga5.x86_64.rpm
lib64baloo-devel-4.14.3-1.1.mga5.x86_64.rpm
lib64baloofiles4-4.14.3-1.1.mga5.x86_64.rpm
lib64baloopim4-4.14.3-1.1.mga5.x86_64.rpm
lib64balooqueryparser4-4.14.3-1.1.mga5.x86_64.rpm
lib64balooxapian4-4.14.3-1.1.mga5.x86_64.rpm

CC: (none) => mageia
Hardware: x86_64 => All
Assignee: mageia => qa-bugs

Comment 5 Samuel Verschelde 2015-07-01 13:04:20 CEST

Thanks Luc. I suppose this is fixed in cauldron? Setting version to 5, please adjust to cauldron if not fixed there already.

Version: Cauldron => 5
Whiteboard: MGA5TOO => (none)

Comment 6 Otto Leipälä 2015-07-02 06:52:31 CEST

Not all installs are affected this bug only systems have no digikam installed as it requires qt4-database-plugin-sqlite.

CC: (none) => ozkyster

Comment 7 Dave Hodgins 2015-07-05 03:10:43 CEST

Advisory committed to svn.

CC: (none) => davidwhodgins
Whiteboard: (none) => advisory

Comment 8 You-Cheng Hsieh 2015-07-08 17:04:50 CEST

Testing completed Mageia 5 i586 for baloo-4.14.3-1.1.mga5.src.rpm:
- qt4-database-plugin-sqlite required to be installed when baloo is updated.
- baloo indexer running without errors after re-login.

Whiteboard: advisory => advisory MGA5-32-OK

Dave Hodgins 2015-07-23 03:56:58 CEST

Keywords: (none) => validated_update
CC: (none) => sysadmin-bugs

Comment 9 Mageia Robot 2015-07-23 11:40:03 CEST

An update for this issue has been pushed to Mageia Updates repository.

http://advisories.mageia.org/MGAA-2015-0064.html

Status: NEW => RESOLVED
Resolution: (none) => FIXED