KMail and KOrganiser issue after last update

quakestring · 7 September 2021 15:08

Very same output after reinstall all the package you said.

    ~  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: database server stopped unexpectedly        ✔ 
org.kde.pim.akonadiserver: Database process exited unexpectedly during initial connection!
org.kde.pim.akonadiserver: executable: "/usr/bin/mysqld"
org.kde.pim.akonadiserver: arguments: ("--defaults-file=/home/mozammel/.local/share/akonadi/mysql.conf", "--datadir=/home/mozammel/.local/share/akonadi/db_data/", "--socket=/run/user/1000/akonadi/mysql.socket", "--pid-file=/run/user/1000/akonadi/mysql.pid")
org.kde.pim.akonadiserver: stdout: ""
org.kde.pim.akonadiserver: stderr: "2021-09-07 20:37:25 0 [Note] /usr/bin/mysqld (server 10.6.4-MariaDB) starting as process 3134 ...\n"
org.kde.pim.akonadiserver: exit code: 1
org.kde.pim.akonadiserver: process error: "Unknown error"
org.kde.pim.akonadiserver: Shutting down AkonadiServer...
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadiserver' exited normally...

anon58039152 · 7 September 2021 15:19

sudo aa-complain /usr/bin/akonadiserver

quakestring · 7 September 2021 15:48

if I remember correctly, some months back when I had similar issue, I found this commend and it worked

sudo aa-complain /usr/bin/akonadiserver

but now it didn’t work. same result as before

    ~  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: database server stopped unexpectedly        ✔ 
org.kde.pim.akonadiserver: Database process exited unexpectedly during initial connection!
org.kde.pim.akonadiserver: executable: "/usr/bin/mysqld"
org.kde.pim.akonadiserver: arguments: ("--defaults-file=/home/mozammel/.local/share/akonadi/mysql.conf", "--datadir=/home/mozammel/.local/share/akonadi/db_data/", "--socket=/run/user/1000/akonadi/mysql.socket", "--pid-file=/run/user/1000/akonadi/mysql.pid")
org.kde.pim.akonadiserver: stdout: ""
org.kde.pim.akonadiserver: stderr: "2021-09-07 21:17:08 0 [Note] /usr/bin/mysqld (server 10.6.4-MariaDB) starting as process 3312 ...\n"
org.kde.pim.akonadiserver: exit code: 1
org.kde.pim.akonadiserver: process error: "Unknown error"
org.kde.pim.akonadiserver: Shutting down AkonadiServer...
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadiserver' exited normally...

anon58039152 · 7 September 2021 15:49

try:

sudo aa-enforce /usr/bin/akonadiserver

quakestring · 7 September 2021 16:03

very same result. still not working.

 sudo aa-status                                                     INT ✘ 
[sudo] password for mozammel: 
apparmor module is loaded.
9 profiles are loaded.
9 profiles are in enforce mode.
   /usr/bin/akonadiserver
   dovecot-script-login
   lsb_release
   mariadbd_akonadi
   mysqld_akonadi
   nvidia_modprobe
   nvidia_modprobe//kmod
   php-fpm
   postgresql_akonadi
0 profiles are in complain mode.
0 profiles are in kill mode.
0 profiles are in unconfined mode.
0 processes have profiles defined.
0 processes are in enforce mode.
0 processes are in complain mode.
0 processes are unconfined but have a profile defined.
0 processes are in mixed mode.
0 processes are in kill mode.

anon58039152 · 7 September 2021 16:15

but mysqld is running well ?

quakestring · 7 September 2021 16:16

yes, mysql is running fine, also mariadb running fine.
I think akonadi uses mariadb.

anon58039152 · 7 September 2021 16:17

mariadb and mysqld are the same thing …

quakestring · 7 September 2021 16:17

yes. right.

quakestring · 7 September 2021 16:17

 sudo systemctl status mariadb                                                                                  ✔ 
● mariadb.service - MariaDB 10.6.4 database server
     Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset: disabled)
     Active: active (running) since Tue 2021-09-07 21:13:38 IST; 35min ago
       Docs: man:mariadbd(8)
             https://mariadb.com/kb/en/library/systemd/
   Main PID: 508 (mariadbd)
     Status: "Taking your SQL requests now..."
      Tasks: 8 (limit: 9413)
     Memory: 81.0M
        CPU: 547ms
     CGroup: /system.slice/mariadb.service
             └─508 /usr/bin/mariadbd

Sep 07 21:13:38 mozammel-tm1703 mariadbd[508]: 2021-09-07 21:13:38 0 [Note] InnoDB: 10.6.4 started; log sequence number 45166>
Sep 07 21:13:38 mozammel-tm1703 mariadbd[508]: 2021-09-07 21:13:38 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysq>
Sep 07 21:13:38 mozammel-tm1703 mariadbd[508]: 2021-09-07 21:13:38 0 [Note] InnoDB: Buffer pool(s) load completed at 210907 2>
Sep 07 21:13:38 mozammel-tm1703 mariadbd[508]: 2021-09-07 21:13:38 0 [Note] Server socket created on IP: '0.0.0.0'.
Sep 07 21:13:38 mozammel-tm1703 mariadbd[508]: 2021-09-07 21:13:38 0 [Note] Server socket created on IP: '::'.
Sep 07 21:13:38 mozammel-tm1703 mariadbd[508]: 2021-09-07 21:13:38 0 [ERROR] Incorrect definition of table mysql.event: expec>
Sep 07 21:13:38 mozammel-tm1703 mariadbd[508]: 2021-09-07 21:13:38 0 [ERROR] mariadbd: Event Scheduler: An error occurred whe>
Sep 07 21:13:38 mozammel-tm1703 mariadbd[508]: 2021-09-07 21:13:38 0 [Note] /usr/bin/mariadbd: ready for connections.
Sep 07 21:13:38 mozammel-tm1703 mariadbd[508]: Version: '10.6.4-MariaDB'  socket: '/run/mysqld/mysqld.sock'  port: 3306  Arch>
Sep 07 21:13:38 mozammel-tm1703 systemd[1]: Started MariaDB 10.6.4 database server.

there is 2 error I don’t understand those error.

anon58039152 · 7 September 2021 16:19

could you restart akonadi service once ?

quakestring · 7 September 2021 16:20

$akonadictl restart                                                                                             ✔ 
Akonadi is not running.
$akonadictl start                                                                                             4 ✘ 
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: database server stopped unexpectedly                                                ✔ 
org.kde.pim.akonadiserver: Database process exited unexpectedly during initial connection!
org.kde.pim.akonadiserver: executable: "/usr/bin/mysqld"
org.kde.pim.akonadiserver: arguments: ("--defaults-file=/home/mozammel/.local/share/akonadi/mysql.conf", "--datadir=/home/mozammel/.local/share/akonadi/db_data/", "--socket=/run/user/1000/akonadi/mysql.socket", "--pid-file=/run/user/1000/akonadi/mysql.pid")
org.kde.pim.akonadiserver: stdout: ""
org.kde.pim.akonadiserver: stderr: "2021-09-07 21:51:23 0 [Note] /usr/bin/mysqld (server 10.6.4-MariaDB) starting as process 11705 ...\n"
org.kde.pim.akonadiserver: exit code: 1
org.kde.pim.akonadiserver: process error: "Unknown error"
org.kde.pim.akonadiserver: Shutting down AkonadiServer...
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadiserver' exited normally...

anon58039152 · 7 September 2021 16:25

oh thats is bad, could we try

sudo mariadb-upgrade

what does it say? … if positive then restart computer…

quakestring · 7 September 2021 16:49

sudo mariadb-upgrade                                                                                       INT ✘ 
[sudo] password for mozammel: 
Sorry, try again.
[sudo] password for mozammel: 
Phase 1/7: Checking and upgrading mysql database
Processing databases
mysql
mysql.column_stats                                 OK
mysql.columns_priv                                 OK
mysql.db                                           OK
mysql.event                                        OK
mysql.func                                         OK
mysql.global_priv                                  OK
mysql.gtid_slave_pos                               OK
mysql.help_category                                OK
mysql.help_keyword                                 OK
mysql.help_relation                                OK
mysql.help_topic                                   OK
mysql.index_stats                                  OK
mysql.innodb_index_stats                           OK
mysql.innodb_table_stats                           OK
mysql.plugin                                       OK
mysql.proc                                         OK
mysql.procs_priv                                   OK
mysql.proxies_priv                                 OK
mysql.roles_mapping                                OK
mysql.servers                                      OK
mysql.table_stats                                  OK
mysql.tables_priv                                  OK
mysql.time_zone                                    OK
mysql.time_zone_leap_second                        OK
mysql.time_zone_name                               OK
mysql.time_zone_transition                         OK
mysql.time_zone_transition_type                    OK
mysql.transaction_registry                         OK
Phase 2/7: Installing used storage engines... Skipped
Phase 3/7: Fixing views
mysql.user                                         OK
Phase 4/7: Running 'mysql_fix_privilege_tables'
Phase 5/7: Fixing table and database names
Phase 6/7: Checking and upgrading tables
Processing databases
information_schema
performance_schema
sys
sys.sys_config                                     OK
Phase 7/7: Running 'FLUSH PRIVILEGES'
OK

but still issue not fixed

 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: database server stopped unexpectedly        ✔ 
org.kde.pim.akonadiserver: Database process exited unexpectedly during initial connection!
org.kde.pim.akonadiserver: executable: "/usr/bin/mysqld"
org.kde.pim.akonadiserver: arguments: ("--defaults-file=/home/mozammel/.local/share/akonadi/mysql.conf", "--datadir=/home/mozammel/.local/share/akonadi/db_data/", "--socket=/run/user/1000/akonadi/mysql.socket", "--pid-file=/run/user/1000/akonadi/mysql.pid")
org.kde.pim.akonadiserver: stdout: ""
org.kde.pim.akonadiserver: stderr: "2021-09-07 22:18:44 0 [Note] /usr/bin/mysqld (server 10.6.4-MariaDB) starting as process 1902 ...\n"
org.kde.pim.akonadiserver: exit code: 1
org.kde.pim.akonadiserver: process error: "Unknown error"
org.kde.pim.akonadiserver: Shutting down AkonadiServer...
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadiserver' exited normally...

anon58039152 · 7 September 2021 16:59

did you restart the pc ?

quakestring · 7 September 2021 17:05

Yes I did restart.

anon58039152 · 7 September 2021 17:11

could also try: delete

/home/<your home name>/.local/share/akonadi/mysql.conf

quakestring · 7 September 2021 17:24

wow… it worked. thank you so much.

anon58039152 · 7 September 2021 17:29

youhoooo , glad it worked

system · 10 September 2021 07:29

This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.