[EN] [solved] akonadi failed to start

[orinoco]

Hello,

the programs Kmail, Korganizer and KAdressBook no longer start because Akonadi is not working correctly. I get the following output when I start Kmail in the console:

Code: [Select]

orinoco@womble:~$ kmail
Qt: Session management error: None of the authentication protocols specified are supported
Qt: Session management error: None of the authentication protocols specified are supported
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/sbin/mysqld"
org.kde.pim.akonadiserver: arguments: ("--defaults-file=/home/orinoco/.local/share/akonadi/mysql.conf", "--datadir=/home/orinoco/.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: ""
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...
Connection to speech-dispatcher failed
Connection to speech-dispatcher failed
Connection to speech-dispatcher failed
Connection to speech-dispatcher failed
Connection to speech-dispatcher failed
Connection to speech-dispatcher failed
Connection to speech-dispatcher failed
Connection to speech-dispatcher failed
Connection to speech-dispatcher failed
Comparators already registered for type MetaEnumVariable
org.kde.pim.akonadicore: Job error:  "" for collection: QVector()
org.kde.pim.akonadicore: Job error:  "" for collection: QVector()
org.kde.pim.messagelist: Failed to load tags  ""
org.kde.pim.mailcommon: failed to retrieve tags  ""
We have an error during reading password  "Entry not found"
The output is similar for Korganizer and KAdressBook. How do I get my e-mail, calendar entries and contact data back?

[orinoco]

Hello,

I have found the following messages in the file /home/user/.local/share/akonadi/db_data/mysql.err:

Code: [Select]

2024-07-17 10:17:56 0 [Note] Starting MariaDB 11.4.2-MariaDB-4 source revision 3fca5ed772fb75e3e57c507edef2985f8eba5b12 as process 619726
2024-07-17 10:17:56 0 [Warning] option 'innodb-log-buffer-size': unsigned value 1048576 adjusted to 2097152
2024-07-17 10:17:56 0 [Note] InnoDB: Compressed tables use zlib 1.3.1
2024-07-17 10:17:56 0 [Note] InnoDB: Number of transaction pools: 1
2024-07-17 10:17:56 0 [Note] InnoDB: Using generic crc32 instructions
2024-07-17 10:17:56 0 [Note] InnoDB: Using liburing
2024-07-17 10:17:56 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
2024-07-17 10:17:56 0 [Note] InnoDB: Initialized memory pressure event listener
2024-07-17 10:17:56 0 [Note] InnoDB: Completed initialization of buffer pool
2024-07-17 10:17:56 0 [Note] InnoDB: Buffered log writes (block size=512 bytes)
2024-07-17 10:17:56 0 [ERROR] InnoDB: Inconsistent tablespace ID in file .//undo001
2024-07-17 10:17:56 0 [ERROR] InnoDB: Unable to read first page of file .//undo001
2024-07-17 10:17:56 0 [ERROR] InnoDB: Plugin initialization aborted with error Data structure corruption
2024-07-17 10:17:56 0 [Note] InnoDB: Starting shutdown...
2024-07-17 10:17:56 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2024-07-17 10:17:56 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-07-17 10:17:56 0 [Note] Plugin 'wsrep-provider' is disabled.
2024-07-17 10:17:56 0 [ERROR] Unknown/unsupported storage engine: innodb
2024-07-17 10:17:56 0 [ERROR] Aborting
Can I rebuild the database? What does this mean for my old emails?

[orinoco]

Hello,

about 140 views and no response. I must be an unfortunate individual.

I have now archived the folder ~/.local/share/local-mail/ with tar, transferred the resulting file to a computer with a fresh installation and unpacked it there again. Kmail took a while, but then the e-mails reappeared in the overview.

[vilde]

Hello,

about 140 views and no response. I must be an unfortunate individual.

I have now archived the folder ~/.local/share/local-mail/ with tar, transferred the resulting file to a computer with a fresh installation and unpacked it there again. Kmail took a while, but then the e-mails reappeared in the overview.

Maybe this is not an upgrade warning? All problems may not be upgrade warnings. I stick my head out and say there is to much crap in "upgrade warnings". And maybe I'm wrong?

[eriefisher]

Since you managed to export and them import your data to another machine I would say the database is fine. Also, since you seem to be alone with this issue it's unlikely an upgrade issue. Is it possible the a package was removed during an upgrade preventing everything from working together, Akondi, Kmail etc.? There are a lot of KDE/Plasma users here, I'm not one of them, and no one else is reporting the issue. Possibly reinstall the packages or removing the config files for a fresh start may help. Sounds like something got corrupted.

[Pip]

My mysql.err shows all sorts of things -

[ERROR] Incorrect definition of table mysql.column_stats: expected column 'hist_type' at position 9 to have type enum('SINGLE_PREC_HB','DOUBLE_PREC_HB','JSON_HB'), found type enum('SINGLE_PREC_HB','DOUBLE_PREC_HB').
 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'histogram' at position 10 to have type longblob, found type varbinary(255).

but Kontact is still working. I've been upgrading with --Solver 3.0 (thanks... Drat, no reference in here).

[orinoco]

Since you managed to export and them import your data to another machine I would say the database is fine.

I'm sorry, I didn't describe it that way. I packed the mail directory on the computer with the Akonadi/Mysql problem and unpacked it on another computer. Then I started KMail and waited to see what happened.

Exporting from KMail was no longer possible because the program, like all the others in the Kontact collection that are based on Akonadi, could no longer be started. Posting #2 shows, that the database is corrupt.

If nothing has been changed on the computer apart from an upgrade and no other computer crashes with file system errors have occurred beforehand, you might suspect that it is due to an upgrade. Hence the posting with the intention to warn. When no feedback was received, I assumed that it was a local problem and shared my solution to help others with this kind of problem in the future.

Sorry for any misunderstandings and ambiguities.