Bug 402680 - akonadiserver do not start
Summary: akonadiserver do not start
Status: RESOLVED FIXED
Alias: None
Product: Akonadi
Classification: Frameworks and Libraries
Component: server (show other bugs)
Version: unspecified
Platform: Neon Linux
: NOR normal
Target Milestone: ---
Assignee: kdepim bugs
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-12-29 16:01 UTC by Alexandr Zamaraev (aka Tonal)
Modified: 2023-04-28 15:23 UTC (History)
4 users (show)

See Also:
Latest Commit:
Version Fixed In: 23.04.0


Attachments
Akonadi Server Self-Test Report (87.01 KB, text/plain)
2018-12-29 16:01 UTC, Alexandr Zamaraev (aka Tonal)
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Alexandr Zamaraev (aka Tonal) 2018-12-29 16:01:36 UTC
Created attachment 117168 [details]
Akonadi Server Self-Test Report

SUMMARY
akonadiserver do not start - mysql error

STEPS TO REPRODUCE
$ akonadictl start
Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
tonal@hius2:/etc/mysql/mysql.conf.d$ akonadi.collectionattributetable                   OK
akonadi.collectionmimetyperelation                 OK
akonadi.collectionpimitemrelation                  OK
akonadi.collectiontable                            OK
akonadi.flagtable                                  OK
akonadi.mimetypetable                              OK
akonadi.parttable                                  OK
akonadi.parttypetable                              OK
akonadi.pimitemflagrelation                        OK
akonadi.pimitemtable                               OK
akonadi.pimitemtagrelation                         OK
akonadi.relationtable                              OK
akonadi.relationtypetable                          OK
akonadi.resourcetable                              OK
akonadi.schemaversiontable                         OK
akonadi.tagattributetable                          OK
akonadi.tagremoteidresourcerelationtable           OK
akonadi.tagtable                                   OK
akonadi.tagtypetable                               OK
org.kde.pim.akonadiserver: ""
org.kde.pim.akonadiserver: Unable to initialize database.
mysqladmin: The query to get the server's pid file failed, error: 'Table 'performance_schema.session_variables' doesn't exist'. Continuing.
org.kde.pim.akonadicontrol: Application 'akonadiserver' exited normally...

SOFTWARE/OS VERSIONS
KDE neon 5.14  4.15.0-43-generic amd64 
KDE Plasma Version: 5.14.4 
KDE Frameworks Version: 5.53.0 
Qt Version: 5.11.2 
MySQL version: 5.7.24-0ubuntu0.18.04.1 (Ubuntu)
Comment 1 Alexandr Zamaraev (aka Tonal) 2018-12-29 16:14:01 UTC
see also https://bugs.kde.org/show_bug.cgi?id=374636
Comment 2 Alexandr Zamaraev (aka Tonal) 2020-03-27 17:40:19 UTC
see also https://bugs.kde.org/show_bug.cgi?id=411093
Comment 3 Er 2020-04-09 21:41:18 UTC
Have the same problem.
When install clean system akonadi works good and kate work.
When I install mysqlserver akonadi crashed same as at links below:
https://bugs.kde.org/show_bug.cgi?id=374636
https://bugs.kde.org/show_bug.cgi?id=411093

Deleting mysqlserver does not solve problem.

Operating System: Kubuntu 20.04
KDE Plasma Version: 5.18.4
KDE Frameworks Version: 5.68.0
Qt Version: 5.12.5
Kernel Version: 5.4.0-21-generic
OS Type: 64-bit
Processors: 8 × Intel® Core™ i7-7700HQ CPU @ 2.80GHz
Memory: 15,5 ГиБ
Comment 5 Alexandr Zamaraev (aka Tonal) 2023-04-26 04:35:26 UTC
$ akonadictl --version
akonadictl 5.23.0 (23.04.0)

$ akonadictl start
org.kde.pim.akonadictl: Starting Akonadi Server...
org.kde.pim.akonadictl:    done.
Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
org.kde.pim.akonadiserver: Starting up the Akonadi Server...
org.kde.pim.akonadiserver: Running DB initializer
tonal@hius2:~/lang/projects/promsoft/epool$ org.kde.pim.akonadiserver: DB initializer done
Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
org.kde.pim.akonadiserver: Unable to connect to dbus service:  "An AppArmor policy prevents this sender from sending this message to this recipient; type=\"method_call\", sender=\":1.145\" (uid=1000 pid=413638 comm=\"/usr/bin/akonadiserver \" label=\"/usr/bin/akonadiserver (enforce)\") interface=\"org.freedesktop.DBus\" member=\"RequestName\" error name=\"(unset)\" requested_reply=\"0\" destination=\"org.freedesktop.DBus\" (bus)"
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadiserver' exited normally...

Operating System: KDE neon 5.27
KDE Plasma Version: 5.27.4
KDE Frameworks Version: 5.105.0
Qt Version: 5.15.9
Kernel Version: 5.19.0-41-generic (64-bit)
Graphics Platform: X11
Processors: 4 × Intel® Core™ i5-6200U CPU @ 2.30GHz
Memory: 31.2 ГиБ of RAM
Graphics Processor: NVIDIA GeForce 940MX/PCIe/SSE2
Manufacturer: Acer
Product Name: TravelMate P259-MG
System Version: V1.51
Comment 6 Carl Schwan 2023-04-26 17:44:33 UTC
Ok the new issue is caused by appammor which block akonadi :(

The debian/neon packaging should normally includes appamor rules to prevent that.
Comment 7 Christophe Marin 2023-04-28 08:36:46 UTC
(In reply to Carl Schwan from comment #6)
> Ok the new issue is caused by appammor which block akonadi :(
> 
> The debian/neon packaging should normally includes appamor rules to prevent
> that.

the rules are in the apparmor/mysqld_akonadi file
Comment 8 Alexandr Zamaraev (aka Tonal) 2023-04-28 09:09:59 UTC
(In reply to Christophe Marin from comment #7)
> the rules are in the apparmor/mysqld_akonadi file
I found 3 files:
```
/etc/apparmor.d$ ls *akonadi*
mariadbd_akonadi  mysqld_akonadi  usr.bin.akonadiserver
```
Comment 9 Alexandr Zamaraev (aka Tonal) 2023-04-28 09:14:15 UTC
see also https://bugs.kde.org/show_bug.cgi?id=411093
Comment 10 Bug Janitor Service 2023-04-28 14:42:33 UTC
A possibly relevant merge request was started @ https://invent.kde.org/pim/akonadi/-/merge_requests/137
Comment 11 Christophe Marin 2023-04-28 15:22:08 UTC
Git commit 620ea58f76e00aed52c1acee9c8d11b6f3279953 by Christophe Marin.
Committed on 28/04/2023 at 14:36.
Pushed by krop into branch 'master'.

Allow running mysql_upgrade when starting Akonadi

Amends d6a1c057327332487adc9ad39252f9481ae28288

M  +2    -1    apparmor/mariadbd_akonadi
M  +1    -0    apparmor/mysqld_akonadi
M  +2    -0    apparmor/usr.bin.akonadiserver

https://invent.kde.org/pim/akonadi/commit/620ea58f76e00aed52c1acee9c8d11b6f3279953
Comment 12 Christophe Marin 2023-04-28 15:23:13 UTC
Git commit 5d6bf9ab17c89bb42ba6dc579ea564d105c6efcb by Christophe Marin.
Committed on 28/04/2023 at 15:22.
Pushed by krop into branch 'release/23.04'.

Allow running mysql_upgrade when starting Akonadi

Amends d6a1c057327332487adc9ad39252f9481ae28288

(cherry picked from commit 620ea58f76e00aed52c1acee9c8d11b6f3279953)

M  +2    -1    apparmor/mariadbd_akonadi
M  +1    -0    apparmor/mysqld_akonadi
M  +2    -0    apparmor/usr.bin.akonadiserver

https://invent.kde.org/pim/akonadi/commit/5d6bf9ab17c89bb42ba6dc579ea564d105c6efcb