On jeudi, 21 avril 2016 16.10:19 h CEST Dennis Gallien wrote:
Hello,
I sure would appreciate any suggestions with this problem.
I (finally!) upgraded my 13.1 workstation to 13.2, including all updates.
Before the update, I would occasionally get the folder lock up problem caused by the akonadi server (once or twice every couple days) that requires the server to be restarted (or log out/log in). IIRC this was a known issue. I hoped it was fixed with the 13.2 release. (I checked the kde akonadi wiki but no help there.)
Following my 13.2 upgrade, the problem has become much, much worse. Repeatedly when I click on a message in a folder (read or unread), the folder locks and I get the green Kmail wait screen. At least in the past the condition would sometimes correct itself after a while and free the folder; not any longer, I am now forced to restart the server every time.
When I do the server restart, I always get about 50 error messages in the mysql error log. These look like the errors I got in the past each time I would restart, but I can't be sure (I didn't keep the old logs).
Fwiw, the log errors look like this:
160421 15:08:48 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist 160421 15:08:48 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them 160421 15:08:48 [ERROR] Native table 'performance_schema'.'cond_instances' has the wrong structure 160421 15:08:48 [ERROR] Native table 'performance_schema'.'events_waits_current' has the wrong structure 160421 15:08:48 [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure 160421 15:08:48 [ERROR] Native table 'performance_schema'.'events_waits_history_long' has the wrong structure 160421 15:08:48 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_host_by_event_name' has the wrong structure . . . followed by another ~45 of the same "Native table 'performance . schema'.'<name> has the wrong structure" errors, and then this at the end: . . 160421 15:08:48 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist 160421 15:08:48 [Note] Reading of all Master_info entries succeded 160421 15:08:48 [Note] Added new Master_info '' to hash table 160421 15:08:48 [Note] /usr/sbin/mysqld: ready for connections. Version: '10.0.22-MariaDB' socket: '/tmp/akonadi-mingus.3qlDQM/mysql.socket' port: 0 openSUSE package 2016-04-21 15:08:48 7fa061eb1700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
Any suggested solution or workaround? I would hate to have to switch to another client after using Kmail for >dozen years, but this constant akonadi problem has become intolerable.
Thanks in advance.
Dennis
I don't think it could help a lot but. akonadictl vacuum akonadictl fsck can't damage more. The errors you have look like and older mysql/mariad db structure which have escape upgrade procedure ( rpm install running only those on system wide server ) Sorry I'm using a central postgresql instance, so I'm not aware of all the details for mysql/mariadb but I would check the package of those and check the postin action to replay exactly the same to your local akonadi server. kmail exporter can perhaps help you to dump the actual data, then create a fresh one and reimport (but don't trust this tool as a silver bullet, it lack certainly maturity) And nobody like to loose some setup. Hope this give you some direction where to check -- Bruno Friedmann Ioda-Net Sàrl www.ioda-net.ch Bareos Partner openSUSE Member, fsfe fellowship GPG KEY : D5C9B751C4653227 irc: tigerfoot -- To unsubscribe, e-mail: opensuse-kde+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse-kde+owner@opensuse.org