Bug 27286

Summary:	mga8beta1 - kmail2 - deprecated org.kde.pim.akonadiserver (32bit)
Product:	Mageia	Reporter:	Joe Da Silva <digital>
Component:	RPM Packages	Assignee:	Mageia Bug Squad <bugsquad>
Status:	RESOLVED INVALID	QA Contact:
Severity:	normal
Priority:	Normal	CC:	geiger.david68210, lewyssmith, ouaurelien
Version:	Cauldron	Keywords:	NEEDINFO
Target Milestone:	---
Hardware:	All
OS:	Linux
Whiteboard:
Source RPM:	akonadi-20.08.1-1.mga8.src.rpm	CVE:
Status comment:

Description Joe Da Silva 2020-09-18 09:19:49 CEST

Description of problem:
While fixing kmail2 bug #27273, a new bug was created. This occurred while attempting to run akonadi on user#2 using sqlite3 instead of the default mysql for user#1

error message seen....

[boinc@genesis ~]$ akonadictl restart
org.kde.pim.akonadictl: Starting Akonadi Server...
org.kde.pim.akonadictl: done.
Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
[boinc@genesis ~]$ org.kde.pim.akonadiserver: Starting up the Akonadi Server...
Cannot mix incompatible Qt library (5.15.0) with this library (5.15.1)
org.kde.pim.akonadicontrol: ProcessControl: Application "/usr/bin/akonadiserver" stopped unexpectedly ( "Process crashed" )
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadiserver' crashed! 1 restarts left.
org.kde.pim.akonadiserver: Starting up the Akonadi Server...
Cannot mix incompatible Qt library (5.15.0) with this library (5.15.1)
org.kde.pim.akonadicontrol: ProcessControl: Application "/usr/bin/akonadiserver" stopped unexpectedly ( "Process crashed" )
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadiserver' crashed! 0 restarts left.
org.kde.pim.akonadiserver: Starting up the Akonadi Server...
Cannot mix incompatible Qt library (5.15.0) with this library (5.15.1)
org.kde.pim.akonadicontrol: ProcessControl: Application "/usr/bin/akonadiserver" stopped unexpectedly ( "Process crashed" )
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadiserver' crashed too often. Giving up!

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

How reproducible:
attempt to use sqlite3 for akonadi
instructions given in bug #27273 "Reduce Akonadi memory usage to 40MB"

Steps to Reproduce:
1. start a new user
2. before beginning kmail, you need to edit .config/akonadi/akonadiserverrc so that the line shows Driver=QSQLITE3
3. open a command line
4. start kmail

When I tested - I was not able to run plasma, and started xcfe instead, but lacking any akonadi files in .config and .local/share I started kmail to initialize those directories with akonadi files usually installed with plasma
stoped akonadi, then did as seen above, and restarted akonadi again.

Comment 1 David GEIGER 2020-09-18 13:04:45 CEST

New kde application 20.08.1 will be available today and also compiled against new Qt 5.15.1!

CC: (none) => geiger.david68210

Comment 2 Aurelien Oudelet 2020-09-18 18:28:49 CEST

Plasma Applications updated to 20.08.1 and rebuilt against QT 5.15.1 / KF5 74.
Does this still apply?

Keywords: (none) => NEEDINFO

Comment 3 Lewis Smith 2020-09-21 21:20:27 CEST

Thanks DavidG for the timely intervention, and Aurelien's confirmation.

@Joe Da Silva : please do say whether the latest updates (including
akonadi-20.08.1-1.mga8) fix the problem.
When raising a bug, or trying an update, please always give the version of the package(s) involved if possible:
 $ rpm -q <package>

Source RPM: (none) => akonadi-20.08.1-1.mga8.src.rpm
CC: (none) => lewyssmith

Comment 4 Aurelien Oudelet 2020-09-23 01:32:58 CEST

For library version mismatch it should be resolved by latest updates in Core repository.

(In reply to Joe Da Silva from comment #0)
> 2. before beginning kmail, you need to  edit .config/akonadi/akonadiserverrc
> so that the line shows Driver=QSQLITE3

Accordig to this KDE techbase article:
https://techbase.kde.org/KDE_PIM/Akonadi

Which DBMS does Akonadi use?
Akonadi currently supports MySQL and PostgreSQL. Basically, every database that is supported by QtSQL can be used, requiring minimal changes in the code at most. However, not all of them provide the features needed by Akonadi (see next two questions).

Why not use sqlite?
We tried. Really. It just can't handle the concurrent access very well.

Why not use MySQL/Embedded?
We tried that as well, there are two reasons for not using it: No support for the InnoDB engine (which we need for transaction support) and poor availability (only OpenSUSE provided usable packages, needed a patched QSQL driver).

Do I need a running MySQL server?
No. Akonadi starts its own local MySQL server (unless configured otherwise, see next question). All you need is having the 'mysqld' binary installed at runtime (usually found in the mysql-server package of your distribution).

So for a SQLite support for Akonadi from Mageia is a NO answer, sorry to say it. If SQLite is still available from KDE GUI , it is a bug from upstream. If it is activated from a modified by hands conf file, it is an undesirable action.

Closing this INVALID.
Feel free to complain upstream (KDE Bugzilla) to really have SQLite support in Akonadi.

Status: NEW => RESOLVED
Resolution: (none) => INVALID
CC: (none) => ouaurelien