Bug ID 1200432
Summary akonadiserver: Database process exited unexpectedly during initial connection!
Classification openSUSE
Product openSUSE Distribution
Version Leap 15.4
Hardware Other
OS Other
Status NEW
Severity Normal
Priority P5 - None
Component KDE Applications
Assignee opensuse-kde-bugs@opensuse.org
Reporter ndordea@gmail.com
QA Contact qa-bugs@suse.de
Found By ---
Blocker ---

Created attachment 859533 [details]
full jornalctl -a

leap 15.3 kmail/kontact worked fine 
against my leap 15.3 was executed  zypper up .... went fine
shutdown 

restart with the DVD-leap-15.4 ...
it run without fine ....

reboot/start HD  

After DVD upgrade to leap 15.4, kmail does not start .  
akonadictl status 
Akonadi Control: stopped
Akonadi Server: stopped
Akonadi Server Search Support: available (Remote Search, Akonadi Search Plugin)
Available Agent Types: akonadi_akonotes_resource, akonadi_archivemail_agent,
akonadi_birthdays_resource, akonadi_contacts_resource,
akonadi_davgroupware_resource, akonadi_ews_resource, akonadi_ewsmta_resource,
akonadi_followupreminder_agent, akonadi_google_resource, akonadi_ical_resource,
akonadi_icaldir_resource, akonadi_imap_resource, akonadi_indexing_agent,
akonadi_kalarm_dir_resource, akonadi_kalarm_resource, akonadi_knut_resource,
akonadi_kolab_resource, akonadi_maildir_resource, akonadi_maildispatcher_agent,
akonadi_mailfilter_agent, akonadi_mailmerge_agent, akonadi_mbox_resource,
akonadi_migration_agent, akonadi_mixedmaildir_resource,
akonadi_newmailnotifier_agent, akonadi_notes_agent, akonadi_notes_resource,
akonadi_openxchange_resource, akonadi_pop3_resource, akonadi_sendlater_agent,
akonadi_tomboynotes_resource, akonadi_unifiedmailbox_agent,
akonadi_vcard_resource, akonadi_vcarddir_resource 


akonadictl start 
org.kde.pim.akonadictl: Starting Akonadi Server...
org.kde.pim.akonadictl:    done.
Connecting to deprecated signal
QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
rocco@suse4Rocco<[--> ~ ]> 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/sbin/mysqld"
org.kde.pim.akonadiserver: arguments:
("--defaults-file=/home/rocco/.local/share/akonadi/mysql.conf",
"--datadir=/home/rocco/.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-10 11:28:56 0 [Note]
/usr/sbin/mysqld (server 10.6.7-MariaDB) starting as process 24183 ...\n"
org.kde.pim.akonadiserver: exit code: 6
org.kde.pim.akonadiserver: process error: "Process crashed"
org.kde.pim.akonadiserver: Shutting down AkonadiServer...
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadiserver' exited
normally...

Even if akonadi complains of database, akonadi database can be used via 
mysql -h localhost -u root -p

Enter password: 
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 21
Server version: 10.6.7-MariaDB MariaDB package

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> show databases ;
+--------------------+
| Database           |
+--------------------+
| akonadi            |
| amarok             |
| amarokdb           |
| cookbook           |
| information_schema |
| mysql              |
| performance_schema |
| sys                |
| test               |
+--------------------+
9 rows in set (0.000 sec)

MariaDB [(none)]> use akonadi ;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
MariaDB [akonadi]> show tables;
+----------------------------------+
| Tables_in_akonadi                |
+----------------------------------+
| collectionattributetable         |
| collectionmimetyperelation       |
| collectionpimitemrelation        |
| collectiontable                  |
| flagtable                        |
| mimetypetable                    |
| parttable                        |
| parttypetable                    |
| pimitemflagrelation              |
| pimitemtable                     |
| pimitemtagrelation               |
| relationtable                    |
| relationtypetable                |
| resourcetable                    |
| schemaversiontable               |
| tagattributetable                |
| tagremoteidresourcerelationtable |
| tagtable                         |
| tagtypetable                     |
+----------------------------------+
19 rows in set (0.000 sec)

MariaDB [akonadi]> select count(*) from collectiontable;
+----------+
| count(*) |
+----------+
|      190 |
+----------+
1 row in set (0.001 sec)

MariaDB [akonadi] quit
Bye

It seems that akonadi is the culprit .  
Is it any solution to use kmail without akonadi ?

Attached are some files collected : journalctl, some mysql/akonadi info 

Please help me to regain the access to my emails .

Thanks 
ND


You are receiving this mail because: