akonadi-server should not depend explicitly on akonadi-backend-mysql

Bug #1803357 reported by Raul Dias
This bug affects 2 people
Affects Status Importance Assigned to Milestone
akonadi (Ubuntu)

Bug Description

There are 3 different backends for akonadi-server:

all of them should provide a metapackage (e.g. akonadi-backend) and akonadi-server should depend on the metapackage.

ProblemType: Bug
DistroRelease: Ubuntu 18.10
Package: akonadi-server 4:18.04.3-0ubuntu2
Uname: Linux 4.18.18-041818-generic x86_64
NonfreeKernelModules: nvidia_modeset nvidia
ApportVersion: 2.20.10-0ubuntu13
Architecture: amd64
CurrentDesktop: KDE
Date: Wed Nov 14 12:00:39 2018
InstallationDate: Installed on 2014-05-12 (1647 days ago)
InstallationMedia: Error: [Errno 13] Permission denied: '/var/log/installer/media-info'
SourcePackage: akonadi
UpgradeStatus: Upgraded to cosmic on 2018-10-22 (23 days ago)

Revision history for this message
Raul Dias (rsd) wrote :
Revision history for this message
Launchpad Janitor (janitor) wrote :

Status changed to 'Confirmed' because the bug affects multiple users.

Changed in akonadi (Ubuntu):
status: New → Confirmed
Revision history for this message
somekool (somekool) wrote :

Yes please !
we need this
please remove the hard dependency on mysql backend

could switching backend offer to migrate the configuration, and clean/purge the previous storage?

the only doc I found for sqlite is https://www.legendiary.at/2012/03/13/change-akonadi-backend-to-sqlite3/

Revision history for this message
somekool (somekool) wrote :

still valid as of 19.10

Revision history for this message
somekool (somekool) wrote :

please note, akonadi is not officially supported as a backend

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

ref: https://techbase.kde.org/KDE_PIM/Akonadi

I suggest we move it to experimental

Revision history for this message
somekool (somekool) wrote :

Note, with MySQL
I often get this migration error

> org.kde.pim.akonadiserver: "\nSql error: Duplicate column name 'version' QMYSQL: Unable to execute query\nQuery: ALTER TABLE SchemaVersionTable ADD COLUMN version INTEGER NOT NULL DEFAULT 0"
org.kde.pim.akonadiserver: Unable to initialize database.

I delete or move away the db_data to "Start over"

Revision history for this message
somekool (somekool) wrote :

would be nice to have this solved before 20.04 LTS

Thank you

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.