Dear Maintainer, with the help on the KDE / kontact IRC Channel the problem is finally kind of solved, so ticket can be closed.
The problem seemed to be the Akonadi database which got corrupted during the dist-upgrade (guess I shouldn't do dist-upgrades anymore, everytime I do it something gets corrupted...). My solution was to set back the complete Akonadi database and it's configs with this description: <https://wiki.ubuntuusers.de/Akonadi/#Akonadi-zuruecksetzen> That was not an ideal solution as this way requires alot of (re)setting of the Akonadi Resources and search/move the place of my calendar/ToDo file (std.ics) which was in ~/.kde/share/apps/korganizer/ but now is saved in ~/.local/share/apps/korganizer/. But in the end this is faster than searching how to repair a database, so it's okay. Thanks - Maria Maria: > Package: akonadi-server > Version: 4:16.04.3-5 > Severity: important > > Dear Maintainer, > > after the upgrade / dist-upgrade Akonadi stopped working rendering Kontact > utterly useless. > > Kontact: > "Akonadi PIM Service is not operational > akonadi-konsole: > "Failed to connect to database: Can't connect to local MySQL server through > socket '/tmp/akonadi-USER.7psq92/mysql.socket' (2 'file or folder not found') > QMYSQL: Unable to connect" > > While the folder in tmp is existing, the file mysql.socket is not. > I tried reinstalling all installed packages relating to Akonadi, MariaDB and > MySQL and dpkg-reconfigure them, without any change. > I tried to create /tmp/akonadi-USER.7psq92/mysql.socket as a link to > /var/run/mysqld/mysqld.sock but Akonadi was still not able to connect so I > deleted the link again. > > Thanks for your help! > Maria > > > > Akonadi Server Self-Test Report > =============================== > > Test 1: SUCCESS > -------- > > Database driver found. > Details: The QtSQL driver 'QMYSQL' is required by your current Akonadi server > configuration and was found on your system. > > File content of '/home/poetic-terrorist/.config/akonadi/akonadiserverrc': > [Debug] > Tracer=dbus > > [%General] > Driver=QMYSQL > > [QMYSQL] > Host= > Name=akonadi > Options="UNIX_SOCKET=/tmp/akonadi-poetic-terrorist.7psq92/mysql.socket" > ServerPath=/usr/sbin/mysqld > StartServer=true > > > Test 2: SUCCESS > -------- > > Akonadi is not running as root > Details: Akonadi is not running as a root/administrator user, which is the > recommended setup for a secure system. > > Test 3: SUCCESS > -------- > > MySQL server found. > Details: You have currently configured Akonadi to use the MySQL server > '/usr/sbin/mysqld'. > Make sure you have the MySQL server installed, set the correct path and ensure > you have the necessary read and execution rights on the server executable. The > server executable is typically called 'mysqld'; its location varies depending > on the distribution. > > Test 4: SUCCESS > -------- > > MySQL server is executable. > Details: MySQL server found: /usr/sbin/mysqld Ver 10.1.24-MariaDB-6 for > debian-linux-gnu on x86_64 (Debian 9.0) > > > Test 5: ERROR > -------- > > MySQL server log contains errors. > Details: The MySQL server error log file '<a href="/home/poetic- > terrorist/.local/share/akonadi/db_data/mysql.err">/home/poetic- > terrorist/.local/share/akonadi/db_data/mysql.err</a>' contains errors. > > File content of '/home/poetic- > terrorist/.local/share/akonadi/db_data/mysql.err': > 2017-08-24 12:41:00 139717515728000 [Note] InnoDB: > innodb_empty_free_list_algorithm has been changed to legacy because of small > buffer pool size. In order to use backoff, increase buffer pool at least up to > 20MB. > > 2017-08-24 12:41:00 139717515728000 [Note] InnoDB: Using mutexes to ref count > buffer pool pages > 2017-08-24 12:41:00 139717515728000 [Note] InnoDB: The InnoDB memory heap is > disabled > 2017-08-24 12:41:00 139717515728000 [Note] InnoDB: Mutexes and rw_locks use > GCC > atomic builtins > 2017-08-24 12:41:00 139717515728000 [Note] InnoDB: GCC builtin > __atomic_thread_fence() is used for memory barrier > 2017-08-24 12:41:00 139717515728000 [Note] InnoDB: Compressed tables use zlib > 1.2.8 > 2017-08-24 12:41:00 139717515728000 [Note] InnoDB: Using Linux native AIO > 2017-08-24 12:41:00 139717515728000 [Note] InnoDB: Using SSE crc32 > instructions > 2017-08-24 12:41:00 139717515728000 [Note] InnoDB: Initializing buffer pool, > size = 80.0M > 2017-08-24 12:41:00 139717515728000 [Note] InnoDB: Completed initialization of > buffer pool > 2017-08-24 12:41:00 139717515728000 [Note] InnoDB: Highest supported file > format is Barracuda. > 2017-08-24 12:41:00 139717515728000 [Note] InnoDB: Starting crash recovery > from > checkpoint LSN=33915400979 > 2017-08-24 12:41:00 139717515728000 [Note] InnoDB: Restoring possible half- > written data pages from the doublewrite buffer... > InnoDB: Set innodb_force_recovery to ignore this error. > 2017-08-24 12:41:00 139717515728000 [ERROR] Plugin 'InnoDB' init function > returned error. > 2017-08-24 12:41:00 139717515728000 [ERROR] Plugin 'InnoDB' registration as a > STORAGE ENGINE failed. > 2017-08-24 12:41:00 139717515728000 [Note] Plugin 'FEEDBACK' is disabled. > 2017-08-24 12:41:00 139717515728000 [ERROR] Unknown/unsupported storage > engine: > innodb > 2017-08-24 12:41:00 139717515728000 [ERROR] Aborting > > Error in my_thread_global_end(): 1 threads didn't exit > > > Test 6: SUCCESS > -------- > > MySQL server default configuration found. > Details: The default configuration for the MySQL server was found and is > readable at <a href="/etc/xdg/akonadi/mysql- > global.conf">/etc/xdg/akonadi/mysql-global.conf</a>. > > File content of '/etc/xdg/akonadi/mysql-global.conf': > # > # Global Akonadi MySQL server settings, > # These settings can be adjusted using $HOME/.config/akonadi/mysql-local.conf > # > # Based on advice by Kris Köhntopp <k...@mysql.com> > # > [mysqld] > > # strict query parsing/interpretation > # TODO: make Akonadi work with those settings enabled > # > sql_mode=strict_trans_tables,strict_all_tables,strict_error_for_division_by_zero,no_auto_create_user,no_auto_value_on_zero,no_engine_substitution,no_zero_date,no_zero_in_date,only_full_group_by,pipes_as_concat > # sql_mode=strict_trans_tables > > # DEBUGGING: > # log all queries, useful for debugging but generates an enormous amount of > data > # log=mysql.full > # log queries slower than n seconds, log file name relative to datadir (for > debugging only) > # log_slow_queries=mysql.slow > # long_query_time=1 > # log queries not using indices, debug only, disable for production use > # log_queries_not_using_indexes=1 > # > # mesure database size and adjust innodb_buffer_pool_size > # SELECT sum(data_length) as bla, sum(index_length) as blub FROM > information_schema.tables WHERE table_schema not in ("mysql", > "information_schema"); > > # NOTES: > # Keep Innob_log_waits and keep Innodb_buffer_pool_wait_free small (see show > global status like "inno%", show global variables) > > #expire_logs_days=3 > > #sync_bin_log=0 > > # Use UTF-8 encoding for tables > character_set_server=utf8 > collation_server=utf8_general_ci > > # use InnoDB for transactions and better crash recovery > default_storage_engine=innodb > > # memory pool InnoDB uses to store data dictionary information and other > internal data structures (default:8M) > # Deprecated in MySQL >= 5.6.3, removed in 5.7 (works in MariaDB) > # innodb_additional_mem_pool_size=8M > > # memory buffer InnoDB uses to cache data and indexes of its tables > (default:128M) > # Larger values means less I/O > innodb_buffer_pool_size=80M > > # Create a .ibd file for each table (default:0) > innodb_file_per_table=1 > > # Write out the log buffer to the log file at each commit (default:1) > innodb_flush_log_at_trx_commit=2 > > # Buffer size used to write to the log files on disk (default:1M for builtin, > 8M for plugin) > # larger values means less I/O > innodb_log_buffer_size=1M > > # Size of each log file in a log group (default:5M) larger means less I/O but > more time for recovery. > innodb_log_file_size=64M > > # # error log file name, relative to datadir (default:hostname.err) > log_error=mysql.err > > # print warnings and connection errors (default:1) > log_warnings=2 > > # Convert table named to lowercase > lower_case_table_names=1 > > # Maximum size of one packet or any generated/intermediate string. > (default:1M) > max_allowed_packet=32M > > # Maximum simultaneous connections allowed (default:100) > max_connections=256 > > # The two options below make no sense with prepared statements and/or > transactions > # (make sense when having the same query multiple times) > > # Memory allocated for caching query results (default:0 (disabled)) > query_cache_size=0 > > # Do not cache results (default:1) > query_cache_type=0 > > # Do not use the privileges mechanisms > skip_grant_tables > > # Do not listen for TCP/IP connections at all > skip_networking > > # The number of open tables for all threads. (default:64) > table_open_cache=200 > > # How many threads the server should cache for reuse (default:0) > thread_cache_size=3 > > # wait 365d before dropping the DB connection (default:8h) > wait_timeout=31536000 > > # We use InnoDB, so don't let MyISAM eat up memory > key_buffer_size=16K > > # KUBUNTU: > # Unset the export dir check as only the full mysql-server package creates it > secure_file_priv= > > [client] > default-character-set=utf8 > > > Test 7: SKIP > -------- > > MySQL server custom configuration not available. > Details: The custom configuration for the MySQL server was not found but is > optional. > > Test 8: SUCCESS > -------- > > MySQL server configuration is usable. > Details: The MySQL server configuration was found at <a href="/home/poetic- > terrorist/.local/share/akonadi/mysql.conf">/home/poetic- > terrorist/.local/share/akonadi/mysql.conf</a> and is readable. > > File content of '/home/poetic-terrorist/.local/share/akonadi/mysql.conf': > # > # Global Akonadi MySQL server settings, > # These settings can be adjusted using $HOME/.config/akonadi/mysql-local.conf > # > # Based on advice by Kris Köhntopp <k...@mysql.com> > # > [mysqld] > > # strict query parsing/interpretation > # TODO: make Akonadi work with those settings enabled > # > sql_mode=strict_trans_tables,strict_all_tables,strict_error_for_division_by_zero,no_auto_create_user,no_auto_value_on_zero,no_engine_substitution,no_zero_date,no_zero_in_date,only_full_group_by,pipes_as_concat > # sql_mode=strict_trans_tables > > # DEBUGGING: > # log all queries, useful for debugging but generates an enormous amount of > data > # log=mysql.full > # log queries slower than n seconds, log file name relative to datadir (for > debugging only) > # log_slow_queries=mysql.slow > # long_query_time=1 > # log queries not using indices, debug only, disable for production use > # log_queries_not_using_indexes=1 > # > # mesure database size and adjust innodb_buffer_pool_size > # SELECT sum(data_length) as bla, sum(index_length) as blub FROM > information_schema.tables WHERE table_schema not in ("mysql", > "information_schema"); > > # NOTES: > # Keep Innob_log_waits and keep Innodb_buffer_pool_wait_free small (see show > global status like "inno%", show global variables) > > #expire_logs_days=3 > > #sync_bin_log=0 > > # Use UTF-8 encoding for tables > character_set_server=utf8 > collation_server=utf8_general_ci > > # use InnoDB for transactions and better crash recovery > default_storage_engine=innodb > > # memory pool InnoDB uses to store data dictionary information and other > internal data structures (default:8M) > # Deprecated in MySQL >= 5.6.3, removed in 5.7 (works in MariaDB) > # innodb_additional_mem_pool_size=8M > > # memory buffer InnoDB uses to cache data and indexes of its tables > (default:128M) > # Larger values means less I/O > innodb_buffer_pool_size=80M > > # Create a .ibd file for each table (default:0) > innodb_file_per_table=1 > > # Write out the log buffer to the log file at each commit (default:1) > innodb_flush_log_at_trx_commit=2 > > # Buffer size used to write to the log files on disk (default:1M for builtin, > 8M for plugin) > # larger values means less I/O > innodb_log_buffer_size=1M > > # Size of each log file in a log group (default:5M) larger means less I/O but > more time for recovery. > innodb_log_file_size=64M > > # # error log file name, relative to datadir (default:hostname.err) > log_error=mysql.err > > # print warnings and connection errors (default:1) > log_warnings=2 > > # Convert table named to lowercase > lower_case_table_names=1 > > # Maximum size of one packet or any generated/intermediate string. > (default:1M) > max_allowed_packet=32M > > # Maximum simultaneous connections allowed (default:100) > max_connections=256 > > # The two options below make no sense with prepared statements and/or > transactions > # (make sense when having the same query multiple times) > > # Memory allocated for caching query results (default:0 (disabled)) > query_cache_size=0 > > # Do not cache results (default:1) > query_cache_type=0 > > # Do not use the privileges mechanisms > skip_grant_tables > > # Do not listen for TCP/IP connections at all > skip_networking > > # The number of open tables for all threads. (default:64) > table_open_cache=200 > > # How many threads the server should cache for reuse (default:0) > thread_cache_size=3 > > # wait 365d before dropping the DB connection (default:8h) > wait_timeout=31536000 > > # We use InnoDB, so don't let MyISAM eat up memory > key_buffer_size=16K > > # KUBUNTU: > # Unset the export dir check as only the full mysql-server package creates it > secure_file_priv= > > [client] > default-character-set=utf8 > > > Test 9: SUCCESS > -------- > > akonadictl found and usable > Details: The program '/usr/bin/akonadictl' to control the Akonadi server was > found and could be executed successfully. > Result: > Akonadi 5.2.2 > > > Test 10: ERROR > -------- > > Akonadi control process not registered at D-Bus. > Details: The Akonadi control process is not registered at D-Bus which > typically > means it was not started or encountered a fatal error during startup. > > Test 11: ERROR > -------- > > Akonadi server process not registered at D-Bus. > Details: The Akonadi server process is not registered at D-Bus which typically > means it was not started or encountered a fatal error during startup. > > Test 12: SKIP > -------- > > Protocol version check not possible. > Details: Without a connection to the server it is not possible to check if the > protocol version meets the requirements. > > Test 13: ERROR > -------- > > No resource agents found. > Details: No resource agents have been found, Akonadi is not usable without at > least one. This usually means that no resource agents are installed or that > there is a setup problem. The following paths have been searched: > '/usr/share/akonadi/agents'. The XDG_DATA_DIRS environment variable is set to > '/usr/share:/usr/share:/usr/local/share'; make sure this includes all paths > where Akonadi agents are installed. > > Directory listing of '/usr/share/akonadi/agents': > akonadibalooindexingagent.desktop > akonadiindexingagent.desktop > akonotesresource.desktop > archivemailagent.desktop > birthdaysresource.desktop > contactsresource.desktop > davgroupwareresource.desktop > followupreminder.desktop > googlecalendarresource.desktop > googlecontactsresource.desktop > icaldirresource.desktop > icalresource.desktop > imapresource.desktop > invitationsagent.desktop > kalarmdirresource.desktop > kalarmresource.desktop > kolabresource.desktop > maildirresource.desktop > maildispatcheragent.desktop > mailfilteragent.desktop > mboxresource.desktop > migrationagent.desktop > mixedmaildirresource.desktop > newmailnotifieragent.desktop > notesagent.desktop > notesresource.desktop > openxchangeresource.desktop > pop3resource.desktop > sendlateragent.desktop > vcarddirresource.desktop > vcardresource.desktop > > Environment variable XDG_DATA_DIRS is set to > '/usr/share:/usr/share:/usr/local/share' > > Test 14: ERROR > -------- > > Current Akonadi server error log found. > Details: The Akonadi server reported errors during its current startup. The > log > can be found in <a href="/home/poetic- > terrorist/.local/share/akonadi/akonadiserver.error">/home/poetic- > terrorist/.local/share/akonadi/akonadiserver.error</a>. > > File content of '/home/poetic- > terrorist/.local/share/akonadi/akonadiserver.error': > Database process exited unexpectedly during initial connection! > executable: "/usr/sbin/mysqld" > arguments: ("--defaults-file=/home/poetic- > terrorist/.local/share/akonadi/mysql.conf", "--datadir=/home/poetic- > terrorist/.local/share/akonadi/db_data/", "--socket=/tmp/akonadi-poetic- > terrorist.7psq92/mysql.socket") > stdout: "" > stderr: "2017-08-24 12:41:00 139717515728000 [Note] /usr/sbin/mysqld (mysqld > 10.1.24-MariaDB-6) starting as process 3851 ...\n" > exit code: 1 > process error: "Process operation timed out" > Failed to remove Unix socket > Failed to remove runtime connection config file > > > Test 15: ERROR > -------- > > Previous Akonadi server error log found. > Details: The Akonadi server reported errors during its previous startup. The > log can be found in <a href="/home/poetic- > terrorist/.local/share/akonadi/akonadiserver.error.old">/home/poetic- > terrorist/.local/share/akonadi/akonadiserver.error.old</a>. > > File content of '/home/poetic- > terrorist/.local/share/akonadi/akonadiserver.error.old': > Database process exited unexpectedly during initial connection! > executable: "/usr/sbin/mysqld" > arguments: ("--defaults-file=/home/poetic- > terrorist/.local/share/akonadi/mysql.conf", "--datadir=/home/poetic- > terrorist/.local/share/akonadi/db_data/", "--socket=/tmp/akonadi-poetic- > terrorist.7psq92/mysql.socket") > stdout: "" > stderr: "2017-08-24 12:39:06 139891864433792 [Note] /usr/sbin/mysqld (mysqld > 10.1.24-MariaDB-6) starting as process 3803 ...\n" > exit code: 1 > process error: "Process operation timed out" > Failed to remove Unix socket > Failed to remove runtime connection config file > > > Test 16: SUCCESS > -------- > > No current Akonadi control error log found. > Details: The Akonadi control process did not report any errors during its > current startup. > > Test 17: SUCCESS > -------- > > No previous Akonadi control error log found. > Details: The Akonadi control process did not report any errors during its > previous startup. > > > > > -- System Information: > Debian Release: buster/sid > APT prefers unstable-debug > APT policy: (500, 'unstable-debug'), (500, 'testing-debug'), (500, > 'testing'), (100, 'unstable') > Architecture: amd64 (x86_64) > > Kernel: Linux 4.12.0-1-amd64 (SMP w/4 CPU cores) > Locale: LANG=de_DE.UTF-8, LC_CTYPE=de_DE.UTF-8 (charmap=UTF-8), LANGUAGE=de > (charmap=UTF-8) > Shell: /bin/sh linked to /bin/dash > Init: systemd (via /run/systemd/system) > > Versions of packages akonadi-server depends on: > ii akonadi-backend-mysql 4:16.04.3-5 > ii libc6 2.24-14 > ii libgcc1 1:7.2.0-1 > ii libkf5akonadiprivate5 4:16.04.3-5 > ii libkf5akonadiwidgets5 4:16.04.3-5 > ii libkf5configcore5 5.28.0-2 > ii libkf5coreaddons5 5.28.0-2 > ii libkf5i18n5 5.28.0-2 > ii libqt5core5a 5.7.1+dfsg-4 > ii libqt5dbus5 5.7.1+dfsg-4 > ii libqt5gui5 5.7.1+dfsg-4 > ii libqt5network5 5.7.1+dfsg-4 > ii libqt5sql5 5.7.1+dfsg-4 > ii libqt5widgets5 5.7.1+dfsg-4 > ii libqt5xml5 5.7.1+dfsg-4 > ii libstdc++6 7.2.0-1 > > akonadi-server recommends no packages. > > Versions of packages akonadi-server suggests: > ii akonadi-backend-mysql 4:16.04.3-5 > pn akonadi-backend-postgresql <none> > pn akonadi-backend-sqlite <none> > > -- no debconf information >
