This forum has been archived. All content is frozen. Please use KDE Discuss instead.

Arch linux - Kalendar issue - mysql

Tags: None
(comma "," separated)
User avatar
pushback
Registered Member
Posts
6
Karma
0

Arch linux - Kalendar issue - mysql

Wed Jun 01, 2022 3:14 pm
Hello, i have an issue with kalendar on Arch Linux using kde plasma:
the program does not want to start, it crashes right after i click on the icon.

If i try to launch it via a terminal, i have those errors:
Code: Select all

$ kalendar
QML debugging is enabled. Only use this in a safe environment.
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/guillaume/.local/share/akonadi/mysql.conf", "--datadir=/home/guillaume/.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: "2022-06-01 17:01:11 0 [Note] /usr/bin/mysqld (server 10.8.3-MariaDB) starting as process 5556 ...\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...
org.kde.pim.akonadicore: Could not start/stop Akonadi!
Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
org.kde.pim.akonadiserver: Starting up the Akonadi Server...
22 -- exe=/usr/bin/kalendar
13 -- platform=xcb
11 -- display=:0
17 -- appname=kalendar
17 -- apppath=/usr/bin
10 -- signal=11
9 -- pid=5542
19 -- appversion=22.04.1
21 -- programname=Kalendar
31 -- bugaddress=submit@bugs.kde.org
12 -- startupid=0
KCrash: crashing... crashRecursionCounter = 2
KCrash: Application Name = kalendar path = /usr/bin pid = 5542
KCrash: Arguments: /usr/bin/kalendar
KCrash: Attempting to start /usr/lib/drkonqi

[1]+  Stopped                 kalendar


then those lines pop:

Code: Select all

$ 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/guillaume/.local/share/akonadi/mysql.conf", "--datadir=/home/guillaume/.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: "2022-06-01 17:01:16 0 [Note] /usr/bin/mysqld (server 10.8.3-MariaDB) starting as process 5578 ...\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...


some more info related to mysql:
Code: Select all
$ systemctl status mariadb
● mariadb.service - MariaDB 10.8.3 database server
     Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
     Active: active (running) since Wed 2022-06-01 16:05:51 CEST; 57min ago
       Docs: man:mariadbd(8)
             https://mariadb.com/kb/en/library/systemd/
    Process: 2674 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
    Process: 2675 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $>
    Process: 2712 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
   Main PID: 2702 (mariadbd)
     Status: "Taking your SQL requests now..."
      Tasks: 8 (limit: 14205)
     Memory: 257.1M
        CPU: 601ms
     CGroup: /system.slice/mariadb.service
             └─2702 /usr/bin/mariadbd

juin 01 16:05:50 asus mariadbd[2702]: 2022-06-01 16:05:50 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
juin 01 16:05:50 asus mariadbd[2702]: 2022-06-01 16:05:50 0 [Note] InnoDB: Buffer pool(s) load completed at 220601 16:05:50
juin 01 16:05:50 asus mariadbd[2702]: 2022-06-01 16:05:50 0 [Note] Server socket created on IP: '0.0.0.0'.
juin 01 16:05:50 asus mariadbd[2702]: 2022-06-01 16:05:50 0 [Note] Server socket created on IP: '::'.
juin 01 16:05:51 asus mariadbd[2702]: 2022-06-01 16:05:51 0 [Note] /usr/bin/mariadbd: ready for connections.
juin 01 16:05:51 asus mariadbd[2702]: Version: '10.8.3-MariaDB'  socket: '/run/mysqld/mysqld.sock'  port: 3306  Arch Linux
juin 01 16:05:51 asus systemd[1]: Started MariaDB 10.8.3 database server.
juin 01 16:06:04 asus mariadbd[2702]: 2022-06-01 16:06:04 3 [Warning] Access denied for user 'root'@'localhost'
juin 01 16:16:54 asus mariadbd[2702]: 2022-06-01 16:16:54 7 [Warning] Access denied for user 'root'@'localhost'
juin 01 16:17:09 asus mariadbd[2702]: 2022-06-01 16:17:09 8 [Warning] Access denied for user 'root'@'localhost'



Thanks for your help!
koffeinfriedhof
Registered Member
Posts
608
Karma
4
OS
HI!

Try to delete (move) the local database and let it recreate.
Code: Select all
mv ~/.local/share/akonadi{,.OLD}


Do you use the mariaDB for something else? Normally ist must not be started via systemd-unit as akonadi uses a local instance.
User avatar
pushback
Registered Member
Posts
6
Karma
0
Thank you koffeinfriedhof for your quick reply. Effectively, I don't use mariaDB. So i disabled and stopped it and move akonadi folder as you mentioned. Akonadi was recreated but Kalendar failed again:

Code: Select all
QML debugging is enabled. Only use this in a safe environment.
Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
org.kde.pim.akonadiserver: Starting up the Akonadi Server...
Installing MariaDB/MySQL system tables in '/home/guillaume/.local/share/akonadi/db_data/' ...
OK

To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system


Two all-privilege accounts were created.
One is root@localhost, it has no password, but you need to
be system 'root' user to connect. Use, for example, sudo mysql
The second is guillaume@localhost, it has no password either, but
you need to be the system 'guillaume' user to connect.
After connecting you can set the password, if you would need to be
able to connect as any of these users with a password and without sudo

See the MariaDB Knowledgebase at https://mariadb.com/kb

You can start the MariaDB daemon with:
cd '/usr' ; /usr/bin/mysqld_safe --datadir='/home/guillaume/.local/share/akonadi/db_data/'

You can test the MariaDB daemon with mysql-test-run.pl
cd '/usr/mysql-test' ; perl mysql-test-run.pl

Please report any problems at https://mariadb.org/jira

The latest information about MariaDB is available at https://mariadb.org/.

Consider joining MariaDB's strong and vibrant community:
https://mariadb.org/get-involved/

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/guillaume/.local/share/akonadi/mysql.conf", "--datadir=/home/guillaume/.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: "2022-06-01 18:44:48 0 [Note] /usr/bin/mysqld (server 10.8.3-MariaDB) starting as process 1922 ...\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...
org.kde.pim.akonadicore: Could not start/stop Akonadi!
Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
org.kde.pim.akonadiserver: Starting up the Akonadi Server...
22 -- exe=/usr/bin/kalendar
13 -- platform=xcb
11 -- display=:0
17 -- appname=kalendar
17 -- apppath=/usr/bin
10 -- signal=11
9 -- pid=1852
19 -- appversion=22.04.1
21 -- programname=Kalendar
31 -- bugaddress=submit@bugs.kde.org
12 -- startupid=0
KCrash: crashing... crashRecursionCounter = 2
KCrash: Application Name = kalendar path = /usr/bin pid = 1852
KCrash: Arguments: /usr/bin/kalendar
KCrash: Attempting to start /usr/lib/drkonqi

[1]+  Stopped                 kalendar

Code: Select all
$ 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/guillaume/.local/share/akonadi/mysql.conf", "--datadir=/home/guillaume/.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: "2022-06-01 18:44:54 0 [Note] /usr/bin/mysqld (server 10.8.3-MariaDB) starting as process 1944 ...\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...
QSocketNotifier: Invalid socket 8 and type 'Read', disabling...
QSocketNotifier: Invalid socket 16 and type 'Read', disabling...
Unable to start Dr. Konqi
Re-raising signal for core dump handling.

koffeinfriedhof
Registered Member
Posts
608
Karma
4
OS
Okay. Try to remove mariadb including configs and stuff, but watch the packages that follow! After deinstallation we install it with new, clean configs. Close all Kontact/KMail/… windows or logout and use a tty.
Code: Select all
# as user
kill -9 $(pgrep akonadi)  # kill all akonadi processes
rm -r ~/.local/share/akonadi
# optional move the config files
mkdir ~/akonadiconfig && mv ~/.config/akonadi* ~/akonadiconfig/

# as root
pacman -Rscn mariadb
pacman -Syu kmail korganizer  # perhaps others, depends on remove

reboot # or relogin


After cleaning up it cannot be a config issue (well, should not ;)). If it still crashes create a new fresh user, enable full debugging for him/her with `kdebugdialog5` / `kdebugsettings ` and try setting up this user, following the output (See Akonadi/Debug_IMAP for an example).

Please be carefully and do not simply copy/paste. This code is untested and should be understood as a guide.


Bookmarks



Who is online

Registered users: Bing [Bot], Google [Bot], kesang, Yahoo [Bot]