[Akonadi] [Bug 348491] Multiple MySQL table structure errors

[Martin Steigerwald via KDE Bugzilla]

https://bugs.kde.org/show_bug.cgi?id=348491

Martin Steigerwald <Martin at Lichtvoll.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |Martin at Lichtvoll.de

--- Comment #1 from Martin Steigerwald <Martin at Lichtvoll.de> ---
Hello Peter, thank you for your report. I have no idea what it can be, but I
ask some questions:

1) Is this really a new user, i.e. means ~/.config/akonadi and
~/.local/share/akonadi and ~/.kde/share/config/akonadi* do not exist?

2) Are you sure that only one mysqld is running? I have seen it several times
that after an akonadictl stop mysqld was not stopped properly at least not
within a minute. When doing an akonadictl start while old mysqld is running, it
unfortunately starts another. I ask due to:

150531 10:54:57 [ERROR] mysqld: Deadlock found when trying to get lock; try
restarting transaction

But there is another message about another mysqld running missing from the log.

3) Are you positive that your filesystem is 100% clean? Review syslog/messages
log and/or dmesg for any errors of the filesystem and any errors of the
underlying backend storage. Please do an fsck -N (no modify, read only mode) on
the unmounted filesystem as well, just to make sure it is intact. Please also
state what filesystem type / device the Akonadi stuff is located on.

4) When you start akonadi on a terminal with akonadictl start do you see any
additional messages or errors? You may also review ~/.xsession-errors for any
additional errors.

5) Any errors in ~/local/share/akonadi/akonadiserver.error and/or
akonadi_control.error?

6) Last also: Did you do a MySQL upgrade between creating the user and starting
Akonadi for the first time (thus creating the database) and your import of old
mails? If so, it may be needed to run mysql_upgrade on the database. I ask due
to:

150531 10:29:56 [ERROR] Native table
'performance_schema'.'events_statements_current' has the wrong structure


Also what exact patch release of Akonadi 1.13 is it? Does it contain any of the
performance related improvements from Akonadi 1.13 git branch? I have used them
for a long time, but the Debian developer who packaged 1.13 had issues with it.
Also please state what version of KDEPIM you use on top on Akonadi.

You may also want to try with Akonadi 15.08 or even later, but you need Qt 5
based KDEPIM for that as well, so also Plasma 5 instead of KDE SC 4.14/4.11
stuff. I have KDEPIM/Akonadi running from git master together with MariaDB 10
and mysql.err is clean.

-- 
You are receiving this mail because:
You are the assignee for the bug.