Es passiert oft, dass KMail E-Mails nicht anzeigt, sondern nur das was man im angehängten Screenshot sieht. Meistens hilft ein „akonadictl restart“, aber das nervt schon. Wie kann man das Problem dauerhaft lösen?
KMail zeigt oft nur „Retrieving Folder Contents Please wait …“ an
Anmeldungsdatum: Beiträge: Zähle... Wohnort: Bergisches Land |
|
||
(Themenstarter)
Anmeldungsdatum: Beiträge: Zähle... Wohnort: Bergisches Land |
Jetzt hilft auch ein Akonadi-Neustart nicht mehr. Dabei werden einige Fehler angezeigt: supertux@Gabi:~$ akonadictl restart supertux@Gabi:~$ Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString) supertux@Gabi:~$ akonadi.collectionattributetable OK akonadi.collectionmimetyperelation OK akonadi.collectionpimitemrelation OK akonadi.collectiontable OK akonadi.flagtable OK akonadi.mimetypetable OK akonadi.parttable OK akonadi.parttypetable OK akonadi.pimitemflagrelation OK akonadi.pimitemtable OK akonadi.pimitemtagrelation OK akonadi.relationtable OK akonadi.relationtypetable OK akonadi.resourcetable OK akonadi.schemaversiontable OK akonadi.tagattributetable OK akonadi.tagremoteidresourcerelationtable OK akonadi.tagtable OK akonadi.tagtypetable OK Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString) org.kde.pim.akonadicontrol: "AgentManager::agentInstanceSynchronize" Agent instance "akonadi_pop3_resource_16" has no resource interface! org.kde.pim.akonadicontrol: "AgentManager::agentInstanceSynchronize" Agent instance "akonadi_pop3_resource_17" has no resource interface! org.kde.pim.akonadicontrol: "AgentManager::agentInstanceSynchronize" Agent instance "akonadi_pop3_resource_18" has no resource interface! org.kde.pim.akonadicontrol: "AgentManager::agentInstanceSynchronize" Agent instance "akonadi_pop3_resource_4" has no resource interface! org.kde.pim.akonadicontrol: "AgentManager::agentInstanceSynchronize" Agent instance "akonadi_pop3_resource_5" has no resource interface! org.kde.pim.akonadicontrol: "AgentManager::agentInstanceSynchronize" Agent instance "akonadi_pop3_resource_9" has no resource interface! org.kde.pim.akonadiplugin_indexer: unknown term "birthday" org.kde.pim.akonadiplugin_indexer: unknown term "birthday" org.kde.pim.akonadiplugin_indexer: no terms added org.kde.pim.akonadiserver: "Cannot connect to agent instance with identifier 'akonadi_maildir_resource_1', error message: ''" org.kde.pim.akonadiserver: "Cannot connect to agent instance with identifier 'akonadi_maildir_resource_1', error message: ''" org.kde.pim.akonadicontrol: "AgentManager::agentInstanceSynchronizeCollection" Agent instance "akonadi_maildir_resource_1" has no resource interface! org.kde.pim.akonadiserver: "Cannot connect to agent instance with identifier 'akonadi_maildir_resource_1', error message: ''" org.kde.pim.akonadiplugin_indexer: unknown term "birthday" org.kde.pim.akonadiplugin_indexer: unknown term "birthday" org.kde.pim.akonadiplugin_indexer: no terms added org.kde.pim.akonadiplugin_indexer: unknown term "birthday" org.kde.pim.akonadiplugin_indexer: unknown term "birthday" org.kde.pim.akonadiplugin_indexer: no terms added "No file selected." org.kde.pim.akonadiplugin_indexer: unknown term "birthday" org.kde.pim.akonadiplugin_indexer: unknown term "birthday" org.kde.pim.akonadiplugin_indexer: no terms added "No file selected." "No file selected." "No file selected." org.kde.pim.akonadi_indexer_agent: "DatabaseLockError" "DatabaseLockError: Unable to get write lock on /home/supertux/.local/share/baloo/emailContacts/: already locked" org.kde.pim.akonadicontrol: Agent instance "akonadi_baloo_indexer" has no interface! org.kde.pim.akonadicontrol: Agent instance "akonadi_baloo_indexer" has no interface! org.kde.pim.akonadicontrol: ProcessControl: Application "/usr/bin/akonadi_baloo_indexer" stopped unexpectedly ( "Process crashed" ) org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_baloo_indexer' crashed! 1 restarts left. QProcess: Destroyed while process ("/usr/bin/akonadi_baloo_indexer") is still running. org.kde.pim.akonadicontrol: ProcessControl: Application "/usr/bin/akonadi_baloo_indexer" stopped unexpectedly ( "Process crashed" ) org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_baloo_indexer' crashed! 0 restarts left. org.kde.pim.akonadicontrol: Agent instance with identifier "akonadi_baloo_indexer" does not exist org.kde.pim.akonadiplugin_indexer: unknown term "birthday" org.kde.pim.akonadiplugin_indexer: unknown term "birthday" org.kde.pim.akonadiplugin_indexer: no terms added org.kde.pim.akonadiplugin_indexer: unknown term "birthday" org.kde.pim.akonadiplugin_indexer: unknown term "birthday" org.kde.pim.akonadiplugin_indexer: no terms added org.kde.pim.akonadiplugin_indexer: unknown term "birthday" org.kde.pim.akonadiplugin_indexer: unknown term "birthday" org.kde.pim.akonadiplugin_indexer: no terms added org.kde.akonadi.ETM: GEN true false false org.kde.akonadi.ETM: collection: QVector() org.kde.akonadi.ETM: akonadi_baloo_indexer(7494): "DatabaseLockError" "DatabaseLockError: Unable to get write lock on /home/supertux/.local/share/baloo/email/: already locked" org.kde.akonadi.ETM: Subtree: 48 QSet(75, 68, 104, 69, 70, 71, 64, 177, 178, 100, 65, 101, 102, 67, 103, 175, 52, 88, 53, 54, 48, 49, 120, 85, 50, 51, 82, 153, 119, 77, 113, 114, 72) org.kde.akonadi.ETM: Fetch job took 308 msec org.kde.akonadi.ETM: was collection fetch job: collections: 33 org.kde.akonadi.ETM: first fetched collection: "Local Folders" akonadi_baloo_indexer(7494): "DatabaseLockError" "DatabaseLockError: Unable to get write lock on /home/supertux/.local/share/baloo/emailContacts/: already locked" org.kde.akonadi.ETM: GEN true false false org.kde.akonadi.ETM: collection: QVector() org.kde.akonadi.ETM: org.kde.akonadi.ETM: collection: QVector() org.kde.akonadi.ETM: Fetch job took 477 msec org.kde.akonadi.ETM: was collection fetch job: collections: 22 org.kde.akonadi.ETM: first fetched collection: "Search" org.kde.akonadi.ETM: Fetch job took 11 msec org.kde.akonadi.ETM: was collection fetch job: collections: 0 org.kde.akonadi.ETM: Subtree: 48 QSet(69, 68, 67, 65, 64, 54, 53, 52, 51, 50, 49, 48, 120, 119, 88, 114, 113, 85, 153, 82, 178, 177, 104, 77, 175, 103, 102, 75, 101, 100, 72, 71, 70) org.kde.akonadi.ETM: Fetch job took 346 msec org.kde.akonadi.ETM: was collection fetch job: collections: 33 org.kde.akonadi.ETM: first fetched collection: "Local Folders" org.kde.akonadi.ETM: collection: QVector() org.kde.akonadi.ETM: Fetch job took 353 msec org.kde.akonadi.ETM: was collection fetch job: collections: 22 org.kde.akonadi.ETM: first fetched collection: "Search" org.kde.akonadi.ETM: Fetch job took 2 msec org.kde.akonadi.ETM: was collection fetch job: collections: 0 org.kde.pim.akonadiplugin_indexer: unknown term "birthday" org.kde.pim.akonadiplugin_indexer: unknown term "birthday" org.kde.pim.akonadiplugin_indexer: no terms added org.kde.pim.akonadiplugin_indexer: unknown term "birthday" org.kde.pim.akonadiplugin_indexer: unknown term "birthday" org.kde.pim.akonadiplugin_indexer: no terms added org.kde.pim.akonadiplugin_indexer: unknown term "birthday" org.kde.pim.akonadiplugin_indexer: unknown term "birthday" org.kde.pim.akonadiplugin_indexer: no terms added org.kde.pim.akonadiplugin_indexer: unknown term "birthday" org.kde.pim.akonadiplugin_indexer: unknown term "birthday" org.kde.pim.akonadiplugin_indexer: no terms added akonadi_baloo_indexer(7494): Could not obtain lock for Xapian Database. This is bad akonadi_baloo_indexer(7494): "DatabaseLockError" "DatabaseLockError: Unable to get write lock on /home/supertux/.local/share/baloo/notes/: already locked" akonadi_baloo_indexer(7494): "DatabaseLockError" "DatabaseLockError: Unable to get write lock on /home/supertux/.local/share/baloo/calendars/: already locked" akonadi_baloo_indexer(7494)/libakonadi: Unable to register service "org.freedesktop.Akonadi.Agent.akonadi_baloo_indexer" at dbus: "" KCrash: Application 'akonadi_baloo_indexer' crashing... KCrash: Attempting to start /usr/lib/kde4/libexec/drkonqi from kdeinit KCrash: Connect sock_file=/home/supertux/.kde/socket-Gabi/kdeinit4__0 org.kde.pim.akonadicore: Got a stale notification for an item which was already removed. 432414 "" org.kde.pim.akonadicore: Got a stale notification for an item which was already removed. 432414 "" org.kde.pim.akonadicore: Got a stale notification for an item which was already removed. 432414 "" org.kde.pim.akonadicore: Got a stale notification for an item which was already removed. 432414 "" org.kde.pim.akonadicore: Got a stale notification for an item which was already removed. 432414 "" org.kde.pim.akonadicore: Got a stale notification for an item which was already removed. 432414 "" false Unable to start Dr. Konqi Not forwarding the crash to Apport. |
||
Anmeldungsdatum: Beiträge: 1967 |
Moin, hast Du aber viele E-Mail Provider 16 mal? Wieviel E-Mail-Account hast Du den 20? Deine akonadi Datenbank ist geschrottet, im Bereich E-Mail sowie auch Termine, ne da muß @HmpfCBR ran er kennst sich da noch besser aus wie meiner einer. Kannst ja schoin mal ein akonadictl fsck und ein akonadictl vacuum laufen lassen, siehe akonadictl --help. peace |
||
(Themenstarter)
Anmeldungsdatum: Beiträge: 544 Wohnort: Bergisches Land |
Ich habe sechs E-Mail-Konten konfiguriert. Stimmt, der Calender funktioniert auch nicht richtig. Er zeigt zwar Termine an, aber ich kann nichts bearbeiten. Bei akonadictl fsck steht ganz oft „Item "12291" has no RID“ mit jeweils anderer Nummer. akonadictl vacuum zeigte nur „optimizing table SchemaVersionTable...“ und ähnlich an. |
||
Anmeldungsdatum: Beiträge: 1967 |
Dann haste aber viel gespielt oder so, es werden 16 pop-resource angezeigt. Vielleicht die Datenbank neu aufbauen was Dir HmpfCBR besser erklären kann. Schau mal hier https://wiki.ubuntuusers.de/Akonadi/ unter "Akonadi zurücksetzen" |
||
(Themenstarter)
Anmeldungsdatum: Beiträge: 544 Wohnort: Bergisches Land |
Ich habe jetzt mal die Datenbank von Akonadi nach https://wiki.ubuntuusers.de/Akonadi/#Akonadi-zuruecksetzen zurückgesetzt, die Ausgabe vom Start von Akonadi sieht aber nicht ok aus: supertux@Gabi:~$ akonadictl start Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString) supertux@Gabi:~$ akonadi.collectionattributetable OK akonadi.collectionmimetyperelation OK akonadi.collectionpimitemrelation OK akonadi.collectiontable OK akonadi.flagtable OK akonadi.mimetypetable OK akonadi.parttable OK akonadi.parttypetable OK akonadi.pimitemflagrelation OK akonadi.pimitemtable OK akonadi.pimitemtagrelation OK akonadi.relationtable OK akonadi.relationtypetable OK akonadi.resourcetable OK akonadi.schemaversiontable OK akonadi.tagattributetable OK akonadi.tagremoteidresourcerelationtable OK akonadi.tagtable OK akonadi.tagtypetable OK Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString) org.kde.pim.akonadiserver: "Cannot connect to agent instance with identifier 'akonadi_maildir_resource_0', error message: ''" org.kde.pim.akonadicontrol: Agent instance "akonadi_baloo_indexer" has no interface! org.kde.pim.akonadicontrol: Agent instance "akonadi_baloo_indexer" has no interface! org.kde.pim.akonadicontrol: ProcessControl: Application "/usr/bin/akonadi_baloo_indexer" stopped unexpectedly ( "Process crashed" ) org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_baloo_indexer' crashed! 1 restarts left. QProcess: Destroyed while process ("/usr/bin/akonadi_baloo_indexer") is still running. org.kde.pim.akonadicontrol: ProcessControl: Application "/usr/bin/akonadi_baloo_indexer" stopped unexpectedly ( "Process crashed" ) org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_baloo_indexer' crashed! 0 restarts left. org.kde.akonadi.ETM: GEN true false false org.kde.akonadi.ETM: collection: QVector() org.kde.akonadi.ETM: org.kde.akonadi.ETM: GEN true false false org.kde.akonadi.ETM: collection: QVector() org.kde.akonadi.ETM: org.kde.akonadi.ETM: Subtree: 10 QSet(11, 10, 12) org.kde.akonadi.ETM: Fetch job took 142 msec org.kde.akonadi.ETM: was collection fetch job: collections: 3 org.kde.akonadi.ETM: first fetched collection: "Local Folders" org.kde.akonadi.ETM: collection: QVector() org.kde.akonadi.ETM: Fetch job took 146 msec org.kde.akonadi.ETM: was collection fetch job: collections: 2 org.kde.akonadi.ETM: first fetched collection: "Search" org.kde.akonadi.ETM: Fetch job took 4 msec org.kde.akonadi.ETM: was collection fetch job: collections: 0 org.kde.akonadi.ETM: Subtree: 10 QSet(12, 11, 10) org.kde.akonadi.ETM: Fetch job took 106 msec org.kde.akonadi.ETM: was collection fetch job: collections: 3 org.kde.akonadi.ETM: first fetched collection: "Local Folders" org.kde.akonadi.ETM: collection: QVector() org.kde.akonadi.ETM: Fetch job took 116 msec org.kde.akonadi.ETM: was collection fetch job: collections: 2 org.kde.akonadi.ETM: first fetched collection: "Search" org.kde.akonadi.ETM: Fetch job took 2 msec org.kde.akonadi.ETM: was collection fetch job: collections: 0 akonadi_baloo_indexer(4917): "DatabaseLockError" "DatabaseLockError: Unable to get write lock on /home/supertux/.local/share/baloo/email/: already locked" akonadi_baloo_indexer(4917): "DatabaseLockError" "DatabaseLockError: Unable to get write lock on /home/supertux/.local/share/baloo/emailContacts/: already locked" akonadi_baloo_indexer(4917): Could not obtain lock for Xapian Database. This is bad akonadi_baloo_indexer(4917): "DatabaseLockError" "DatabaseLockError: Unable to get write lock on /home/supertux/.local/share/baloo/notes/: already locked" akonadi_baloo_indexer(4917): "DatabaseLockError" "DatabaseLockError: Unable to get write lock on /home/supertux/.local/share/baloo/calendars/: already locked" akonadi_baloo_indexer(4917)/libakonadi: Unable to register service "org.freedesktop.Akonadi.Agent.akonadi_baloo_indexer" at dbus: "" KCrash: Application 'akonadi_baloo_indexer' crashing... KCrash: Attempting to start /usr/lib/kde4/libexec/drkonqi from kdeinit KCrash: Connect sock_file=/home/supertux/.kde/socket-Gabi/kdeinit4__0 Unable to start Dr. Konqi Not forwarding the crash to Apport. supertux@Gabi:~$ |
||
Anmeldungsdatum: Beiträge: 12067 |
▶ Rechte im Homeverzeichnis korrigieren und sudo lesen! |
||
(Themenstarter)
Anmeldungsdatum: Beiträge: 544 Wohnort: Bergisches Land |
Soweit ich das sehe, habe ich Schreibzugriff: supertux@Gabi:~/.local/share/baloo$ ls -l total 455728 drwx------ 2 supertux supertux 4096 Nov 25 17:51 calendars drwx------ 2 supertux supertux 4096 Nov 25 17:51 contacts drwx------ 2 supertux supertux 4096 Nov 25 16:11 email drwx------ 2 supertux supertux 4096 Nov 25 16:11 emailContacts -rw------- 1 supertux supertux 466616320 Apr 29 2017 index -rw------- 1 supertux supertux 8192 Nov 25 16:53 index-lock drwx------ 2 supertux supertux 4096 Nov 25 16:11 notes Warum muss ich die Rechte korrigieren? |
||
Anmeldungsdatum: Beiträge: 12067 |
War eine Vermutung. In deinen Logdateien steht "already locked", also schon gesperrt. Wenn akonadi, welches mit Benutzerrechten ausgeführt wird, diesen Lock nicht mehr löschen kann, liegt das in den meisten Fällen an fehlenden Rechten. Tauchen die Fehler danach noch auf, kann man einige Prüfungen machen, wie
Erweiterte Tests kann man mit akonaditest einrichten und starten. |
||
(Themenstarter)
Anmeldungsdatum: Beiträge: 544 Wohnort: Bergisches Land |
Hier sind die Konsolenausgaben: supertux@Gabi:~$ akonadictl status Akonadi Control: running Akonadi Server: running Akonadi Server Search Support: available (Remote Search) Available Agent Types: akonadi_akonotes_resource, akonadi_archivemail_agent, akonadi_baloo_indexer, akonadi_birthdays_resource, akonadi_contacts_resource, akonadi_davgroupware_resource, akonadi_followupreminder_agent, akonadi_googlecalendar_resource, akonadi_googlecontacts_resource, akonadi_ical_resource, akonadi_icaldir_resource, akonadi_imap_resource, akonadi_indexing_agent, akonadi_invitations_agent, akonadi_kalarm_dir_resource, akonadi_kalarm_resource, akonadi_kolab_resource, akonadi_maildir_resource, akonadi_maildispatcher_agent, akonadi_mailfilter_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_vcard_resource, akonadi_vcarddir_resource supertux@Gabi:~$ akonadictl fsck Looking for resources in the DB not matching a configured resource... Looking for collections not belonging to a valid resource... Checking collection tree consistency... Looking for items not belonging to a valid collection... Looking for item parts not belonging to a valid item... Looking for item flags not belonging to a valid item... Looking for overlapping external parts... Verifying external parts... Found 25 external files. Found 25 external parts. Found no unreferenced external files. Checking size treshold changes... Found 0 parts to be moved to external files Found 0 parts to be moved to database Looking for dirty objects... Collection "Search" (id: 1) has no RID. Found 1 collections without RID. Found 0 items without RID. Found 0 dirty items. Looking for rid-duplicates not matching the content mime-type of the parent collection Checking Birthdays & Anniversaries Checking Local Folders Checking Notes Checking Personal Contacts Checking Search Checking akonadi_ical_resource_0 Checking drafts Checking inbox Checking outbox Checking sent-mail Checking templates Checking trash Migrating parts to new cache hierarchy... Consistency check done. 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/supertux/.config/akonadi/akonadiserverrc': [Debug] Tracer=null [%General] Driver=QMYSQL [QMYSQL] Host= Name=akonadi Options="UNIX_SOCKET=/tmp/akonadi-supertux.S6mt5A/mysql.socket" ServerPath=/usr/sbin/mysqld-akonadi 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-akonadi'. 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 5.6.30-0ubuntu0.15.10.1 for debian-linux-gnu on x86_64 ((Ubuntu)) Test 5: ERROR -------- MySQL server log contains errors. Details: The MySQL server error log file '<a href="/home/supertux/.local/share/akonadi/db_data/mysql.err">/home/supertux/.local/share/akonadi/db_data/mysql.err</a>' contains errors. File content of '/home/supertux/.local/share/akonadi/db_data/mysql.err': 2017-11-25 16:11:34 8214 [Note] Plugin 'FEDERATED' is disabled. 2017-11-25 16:11:34 8214 [Note] InnoDB: Using atomics to ref count buffer pool pages 2017-11-25 16:11:34 8214 [Note] InnoDB: The InnoDB memory heap is disabled 2017-11-25 16:11:34 8214 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2017-11-25 16:11:34 8214 [Note] InnoDB: Memory barrier is not used 2017-11-25 16:11:34 8214 [Note] InnoDB: Compressed tables use zlib 1.2.8 2017-11-25 16:11:34 8214 [Note] InnoDB: Using Linux native AIO 2017-11-25 16:11:34 8214 [Note] InnoDB: Not using CPU crc32 instructions 2017-11-25 16:11:34 8214 [Note] InnoDB: Initializing buffer pool, size = 80.0M 2017-11-25 16:11:34 8214 [Note] InnoDB: Completed initialization of buffer pool 2017-11-25 16:11:34 8214 [Note] InnoDB: Highest supported file format is Barracuda. 2017-11-25 16:11:34 8214 [Note] InnoDB: 128 rollback segment(s) are active. 2017-11-25 16:11:34 8214 [Note] InnoDB: Waiting for purge to start 2017-11-25 16:11:34 8214 [Note] InnoDB: 5.6.30 started; log sequence number 1828075 2017-11-25 16:11:34 8214 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them 2017-11-25 16:11:34 8214 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist 2017-11-25 16:11:34 8214 [ERROR] Native table 'performance_schema'.'cond_instances' has the wrong structure 2017-11-25 16:11:34 8214 [ERROR] Native table 'performance_schema'.'events_waits_current' has the wrong structure 2017-11-25 16:11:34 8214 [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure 2017-11-25 16:11:34 8214 [ERROR] Native table 'performance_schema'.'events_waits_history_long' has the wrong structure 2017-11-25 16:11:34 8214 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_host_by_event_name' has the wrong structure 2017-11-25 16:11:34 8214 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_instance' has the wrong structure 2017-11-25 16:11:34 8214 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_thread_by_event_name' has the wrong structure 2017-11-25 16:11:34 8214 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_user_by_event_name' has the wrong structure 2017-11-25 16:11:34 8214 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_account_by_event_name' has the wrong structure 2017-11-25 16:11:34 8214 [ERROR] Native table 'performance_schema'.'events_waits_summary_global_by_event_name' has the wrong structure 2017-11-25 16:11:34 8214 [ERROR] Native table 'performance_schema'.'file_instances' has the wrong structure 2017-11-25 16:11:34 8214 [ERROR] Native table 'performance_schema'.'file_summary_by_event_name' has the wrong structure 2017-11-25 16:11:34 8214 [ERROR] Native table 'performance_schema'.'file_summary_by_instance' has the wrong structure 2017-11-25 16:11:34 8214 [ERROR] Native table 'performance_schema'.'host_cache' has the wrong structure 2017-11-25 16:11:34 8214 [ERROR] Native table 'performance_schema'.'mutex_instances' has the wrong structure 2017-11-25 16:11:34 8214 [ERROR] Native table 'performance_schema'.'objects_summary_global_by_type' has the wrong structure 2017-11-25 16:11:34 8214 [ERROR] Native table 'performance_schema'.'performance_timers' has the wrong structure 2017-11-25 16:11:34 8214 [ERROR] Native table 'performance_schema'.'rwlock_instances' has the wrong structure 2017-11-25 16:11:34 8214 [ERROR] Native table 'performance_schema'.'setup_actors' has the wrong structure 2017-11-25 16:11:34 8214 [ERROR] Native table 'performance_schema'.'setup_consumers' has the wrong structure 2017-11-25 16:11:34 8214 [ERROR] Native table 'performance_schema'.'setup_instruments' has the wrong structure 2017-11-25 16:11:34 8214 [ERROR] Native table 'performance_schema'.'setup_objects' has the wrong structure 2017-11-25 16:11:34 8214 [ERROR] Native table 'performance_schema'.'setup_timers' has the wrong structure 2017-11-25 16:11:34 8214 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_index_usage' has the wrong structure 2017-11-25 16:11:34 8214 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_table' has the wrong structure 2017-11-25 16:11:34 8214 [ERROR] Native table 'performance_schema'.'table_lock_waits_summary_by_table' has the wrong structure 2017-11-25 16:11:34 8214 [ERROR] Native table 'performance_schema'.'threads' has the wrong structure 2017-11-25 16:11:34 8214 [ERROR] Native table 'performance_schema'.'events_stages_current' has the wrong structure 2017-11-25 16:11:34 8214 [ERROR] Native table 'performance_schema'.'events_stages_history' has the wrong structure 2017-11-25 16:11:34 8214 [ERROR] Native table 'performance_schema'.'events_stages_history_long' has the wrong structure 2017-11-25 16:11:34 8214 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_thread_by_event_name' has the wrong structure 2017-11-25 16:11:34 8214 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_account_by_event_name' has the wrong structure 2017-11-25 16:11:34 8214 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_user_by_event_name' has the wrong structure 2017-11-25 16:11:34 8214 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_host_by_event_name' has the wrong structure 2017-11-25 16:11:34 8214 [ERROR] Native table 'performance_schema'.'events_stages_summary_global_by_event_name' has the wrong structure 2017-11-25 16:11:34 8214 [ERROR] Native table 'performance_schema'.'events_statements_current' has the wrong structure 2017-11-25 16:11:34 8214 [ERROR] Native table 'performance_schema'.'events_statements_history' has the wrong structure 2017-11-25 16:11:34 8214 [ERROR] Native table 'performance_schema'.'events_statements_history_long' has the wrong structure 2017-11-25 16:11:34 8214 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_thread_by_event_name' has the wrong structure 2017-11-25 16:11:34 8214 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_account_by_event_name' has the wrong structure 2017-11-25 16:11:34 8214 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_user_by_event_name' has the wrong structure 2017-11-25 16:11:34 8214 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_host_by_event_name' has the wrong structure 2017-11-25 16:11:34 8214 [ERROR] Native table 'performance_schema'.'events_statements_summary_global_by_event_name' has the wrong structure 2017-11-25 16:11:34 8214 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_digest' has the wrong structure 2017-11-25 16:11:34 8214 [ERROR] Native table 'performance_schema'.'users' has the wrong structure 2017-11-25 16:11:34 8214 [ERROR] Native table 'performance_schema'.'accounts' has the wrong structure 2017-11-25 16:11:34 8214 [ERROR] Native table 'performance_schema'.'hosts' has the wrong structure 2017-11-25 16:11:34 8214 [ERROR] Native table 'performance_schema'.'socket_instances' has the wrong structure 2017-11-25 16:11:34 8214 [ERROR] Native table 'performance_schema'.'socket_summary_by_instance' has the wrong structure 2017-11-25 16:11:34 8214 [ERROR] Native table 'performance_schema'.'socket_summary_by_event_name' has the wrong structure 2017-11-25 16:11:34 8214 [ERROR] Native table 'performance_schema'.'session_connect_attrs' has the wrong structure 2017-11-25 16:11:34 8214 [ERROR] Native table 'performance_schema'.'session_account_connect_attrs' has the wrong structure 2017-11-25 16:11:34 8214 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.30-0ubuntu0.15.10.1' socket: '/tmp/akonadi-supertux.S6mt5A/mysql.socket' port: 0 (Ubuntu) 2017-11-25 16:11:34 7fcc198df700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2017-11-25 16:11:34 7fcc198df700 InnoDB: Error: Fetch of persistent statistics requested for table "akonadi"."collectionattributetable" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2017-11-25 16:11:34 7fcc198df700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2017-11-25 16:11:34 7fcc198df700 InnoDB: Error: Fetch of persistent statistics requested for table "akonadi"."collectionmimetyperelation" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2017-11-25 16:11:34 7fcc198df700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2017-11-25 16:11:34 7fcc198df700 InnoDB: Error: Fetch of persistent statistics requested for table "akonadi"."collectionpimitemrelation" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2017-11-25 16:11:34 7fcc198df700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2017-11-25 16:11:34 7fcc198df700 InnoDB: Error: Fetch of persistent statistics requested for table "akonadi"."collectiontable" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2017-11-25 16:11:34 7fcc198df700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2017-11-25 16:11:34 7fcc198df700 InnoDB: Error: Fetch of persistent statistics requested for table "akonadi"."flagtable" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2017-11-25 16:11:34 7fcc198df700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2017-11-25 16:11:34 7fcc198df700 InnoDB: Error: Fetch of persistent statistics requested for table "akonadi"."mimetypetable" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2017-11-25 16:11:34 7fcc198df700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2017-11-25 16:11:34 7fcc198df700 InnoDB: Error: Fetch of persistent statistics requested for table "akonadi"."parttable" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2017-11-25 16:11:34 7fcc198df700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2017-11-25 16:11:34 7fcc198df700 InnoDB: Error: Fetch of persistent statistics requested for table "akonadi"."parttypetable" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2017-11-25 16:11:34 7fcc198df700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2017-11-25 16:11:34 7fcc198df700 InnoDB: Error: Fetch of persistent statistics requested for table "akonadi"."pimitemflagrelation" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2017-11-25 16:11:34 7fcc198df700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2017-11-25 16:11:34 7fcc198df700 InnoDB: Error: Fetch of persistent statistics requested for table "akonadi"."pimitemtable" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2017-11-25 16:11:34 7fcc198df700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2017-11-25 16:11:34 7fcc198df700 InnoDB: Error: Fetch of persistent statistics requested for table "akonadi"."pimitemtagrelation" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2017-11-25 16:11:34 7fcc198df700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2017-11-25 16:11:34 7fcc198df700 InnoDB: Error: Fetch of persistent statistics requested for table "akonadi"."relationtable" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2017-11-25 16:11:34 7fcc198df700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2017-11-25 16:11:34 7fcc198df700 InnoDB: Error: Fetch of persistent statistics requested for table "akonadi"."relationtypetable" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2017-11-25 16:11:34 7fcc198df700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2017-11-25 16:11:34 7fcc198df700 InnoDB: Error: Fetch of persistent statistics requested for table "akonadi"."resourcetable" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2017-11-25 16:11:34 7fcc198df700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2017-11-25 16:11:34 7fcc198df700 InnoDB: Error: Fetch of persistent statistics requested for table "akonadi"."schemaversiontable" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2017-11-25 16:11:34 7fcc198df700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2017-11-25 16:11:34 7fcc198df700 InnoDB: Error: Fetch of persistent statistics requested for table "akonadi"."tagattributetable" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2017-11-25 16:11:34 7fcc198df700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2017-11-25 16:11:34 7fcc198df700 InnoDB: Error: Fetch of persistent statistics requested for table "akonadi"."tagremoteidresourcerelationtable" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2017-11-25 16:11:34 7fcc198df700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2017-11-25 16:11:34 7fcc198df700 InnoDB: Error: Fetch of persistent statistics requested for table "akonadi"."tagtable" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2017-11-25 16:11:34 7fcc198df700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2017-11-25 16:11:34 7fcc198df700 InnoDB: Error: Fetch of persistent statistics requested for table "akonadi"."tagtypetable" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2017-11-25 17:50:48 7fcc15bbd700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2017-11-25 17:50:48 7fcc15bbd700 InnoDB: Recalculation of persistent statistics requested for table "akonadi"."collectionattributetable" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead. 2017-11-25 17:50:48 7fcc15bbd700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2017-11-25 17:50:48 7fcc15bbd700 InnoDB: Recalculation of persistent statistics requested for table "akonadi"."resourcetable" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead. 2017-11-25 17:50:48 7fcc15bbd700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2017-11-25 17:50:48 7fcc15bbd700 InnoDB: Recalculation of persistent statistics requested for table "akonadi"."collectiontable" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead. 2017-11-25 17:50:48 7fcc15bbd700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2017-11-25 17:50:48 7fcc15bbd700 InnoDB: Recalculation of persistent statistics requested for table "akonadi"."collectionmimetyperelation" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead. 2017-11-25 17:50:49 7fcc15bbd700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2017-11-25 17:50:49 7fcc15bbd700 InnoDB: Recalculation of persistent statistics requested for table "akonadi"."pimitemtable" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead. 2017-11-25 17:51:01 7fcc15bbd700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2017-11-25 17:51:01 7fcc15bbd700 InnoDB: Recalculation of persistent statistics requested for table "akonadi"."collectiontable" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead. 2017-11-25 17:51:11 7fcc15bbd700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2017-11-25 17:51:11 7fcc15bbd700 InnoDB: Recalculation of persistent statistics requested for table "akonadi"."parttypetable" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead. 2017-11-25 17:51:21 7fcc15bbd700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2017-11-25 17:51:21 7fcc15bbd700 InnoDB: Recalculation of persistent statistics requested for table "akonadi"."collectionattributetable" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead. 2017-11-25 17:51:31 7fcc15bbd700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2017-11-25 17:51:31 7fcc15bbd700 InnoDB: Recalculation of persistent statistics requested for table "akonadi"."parttable" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead. 2017-11-25 17:51:41 7fcc15bbd700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2017-11-25 17:51:41 7fcc15bbd700 InnoDB: Recalculation of persistent statistics requested for table "akonadi"."tagtable" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead. 2017-11-25 17:51:51 7fcc15bbd700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2017-11-25 17:51:51 7fcc15bbd700 InnoDB: Recalculation of persistent statistics requested for table "akonadi"."collectionmimetyperelation" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead. 2017-11-25 17:52:01 7fcc15bbd700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2017-11-25 17:52:01 7fcc15bbd700 InnoDB: Recalculation of persistent statistics requested for table "akonadi"."pimitemtable" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead. 2017-11-25 17:52:11 7fcc15bbd700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found. 2017-11-25 17:52:11 7fcc15bbd700 InnoDB: Recalculation of persistent statistics requested for table "akonadi"."resourcetable" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead. 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 <kris@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= # KUBUNTU: # workaround for 5.7 being more strict with column types # (reverts to 5.6 behavior) sql_mode=NO_ENGINE_SUBSTITUTION [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/supertux/.local/share/akonadi/mysql.conf">/home/supertux/.local/share/akonadi/mysql.conf</a> and is readable. File content of '/home/supertux/.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 <kris@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= # KUBUNTU: # workaround for 5.7 being more strict with column types # (reverts to 5.6 behavior) sql_mode=NO_ENGINE_SUBSTITUTION [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: akonadictl 5.4.3 Test 10: SUCCESS -------- Akonadi control process registered at D-Bus. Details: The Akonadi control process is registered at D-Bus which typically indicates it is operational. Test 11: SUCCESS -------- Akonadi server process registered at D-Bus. Details: The Akonadi server process is registered at D-Bus which typically indicates it is operational. 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: SUCCESS -------- Resource agents found. Details: At least one resource agent has been found. 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 tomboynotesresource.desktop vcarddirresource.desktop vcardresource.desktop Environment variable XDG_DATA_DIRS is set to '/usr/share//usr/share/xsessions/plasma:/usr/local/share:/usr/share:/var/lib/snapd/desktop:/var/lib/snapd/desktop' Test 14: SUCCESS -------- No current Akonadi server error log found. Details: The Akonadi server did not report any errors during its current startup. 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/supertux/.local/share/akonadi/akonadiserver.error.old">/home/supertux/.local/share/akonadi/akonadiserver.error.old</a>. File content of '/home/supertux/.local/share/akonadi/akonadiserver.error.old': Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString) 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: ERROR -------- Previous Akonadi control error log found. Details: The Akonadi control process reported errors during its previous startup. The log can be found in <a href="/home/supertux/.local/share/akonadi/akonadi_control.error.old">/home/supertux/.local/share/akonadi/akonadi_control.error.old</a>. File content of '/home/supertux/.local/share/akonadi/akonadi_control.error.old': Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)Agent instance "akonadi_baloo_indexer" has no interface!Agent instance "akonadi_baloo_indexer" has no interface!ProcessControl: Application "/usr/bin/akonadi_baloo_indexer" stopped unexpectedly ( "Process crashed" )Application '/usr/bin/akonadi_baloo_indexer' crashed! 1 restarts left.QProcess: Destroyed while process ("/usr/bin/akonadi_baloo_indexer") is still running.ProcessControl: Application "/usr/bin/akonadi_baloo_indexer" stopped unexpectedly ( "Process crashed" )Application '/usr/bin/akonadi_baloo_indexer' crashed! 0 restarts left. supertux@Gabi:~$ akonadictl restart org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_ical_resource' exited normally... org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_maildir_resource' exited normally... org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_sendlater_agent' exited normally... org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_mailfilter_agent' exited normally... org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_contacts_resource' exited normally... org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_birthdays_resource' exited normally... org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_followupreminder_agent' exited normally... org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_maildispatcher_agent' exited normally... org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_newmailnotifier_agent' exited normally... org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_indexing_agent' exited normally... org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_archivemail_agent' exited normally... org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_akonotes_resource' exited normally... org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_migration_agent' exited normally... org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_notes_agent' exited normally... akonadi_baloo_indexer(8334)/libakonadi Akonadi::SessionPrivate::socketError: Socket error occurred: "QLocalSocket: Remote closed" chainup() org.kde.pim.akonadicontrol: Application 'akonadiserver' exited normally... supertux@Gabi:~$ Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString) akonadi.collectionattributetable OK akonadi.collectionmimetyperelation OK akonadi.collectionpimitemrelation OK akonadi.collectiontable OK akonadi.flagtable OK akonadi.mimetypetable OK akonadi.parttable OK akonadi.parttypetable OK akonadi.pimitemflagrelation OK akonadi.pimitemtable OK akonadi.pimitemtagrelation OK akonadi.relationtable OK akonadi.relationtypetable OK akonadi.resourcetable OK akonadi.schemaversiontable OK akonadi.tagattributetable OK akonadi.tagremoteidresourcerelationtable OK akonadi.tagtable OK akonadi.tagtypetable OK Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString) org.kde.pim.akonadicontrol: Agent instance "akonadi_baloo_indexer" has no interface! org.kde.pim.akonadicontrol: Agent instance "akonadi_baloo_indexer" has no interface! org.kde.pim.akonadicontrol: ProcessControl: Application "/usr/bin/akonadi_baloo_indexer" stopped unexpectedly ( "Process crashed" ) org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_baloo_indexer' crashed! 1 restarts left. QProcess: Destroyed while process ("/usr/bin/akonadi_baloo_indexer") is still running. org.kde.pim.akonadicontrol: ProcessControl: Application "/usr/bin/akonadi_baloo_indexer" stopped unexpectedly ( "Process crashed" ) org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_baloo_indexer' crashed! 0 restarts left. org.kde.pim.akonadicontrol: Agent instance with identifier "akonadi_baloo_indexer" does not exist org.kde.pim.akonadicontrol: Agent instance with identifier "akonadi_baloo_indexer" does not exist org.kde.akonadi.ETM: GEN true false false org.kde.akonadi.ETM: collection: QVector() org.kde.akonadi.ETM: akonadi_baloo_indexer(14256): "DatabaseLockError" "DatabaseLockError: Unable to get write lock on /home/supertux/.local/share/baloo/email/: already locked" akonadi_baloo_indexer(14256): "DatabaseLockError" "DatabaseLockError: Unable to get write lock on /home/supertux/.local/share/baloo/emailContacts/: already locked" org.kde.akonadi.ETM: Subtree: 10 QSet(10, 11, 12, 14, 15, 16, 17) org.kde.akonadi.ETM: Fetch job took 42 msec org.kde.akonadi.ETM: was collection fetch job: collections: 7 org.kde.akonadi.ETM: first fetched collection: "Local Folders" org.kde.akonadi.ETM: collection: QVector() org.kde.akonadi.ETM: Fetch job took 45 msec org.kde.akonadi.ETM: was collection fetch job: collections: 6 org.kde.akonadi.ETM: first fetched collection: "Search" org.kde.akonadi.ETM: Fetch job took 1 msec org.kde.akonadi.ETM: was collection fetch job: collections: 0 org.kde.akonadi.ETM: GEN true false false org.kde.akonadi.ETM: collection: QVector() org.kde.akonadi.ETM: org.kde.akonadi.ETM: Subtree: 10 QSet(10, 11, 12, 14, 16, 15, 17) org.kde.akonadi.ETM: Fetch job took 87 msec org.kde.akonadi.ETM: was collection fetch job: collections: 7 org.kde.akonadi.ETM: first fetched collection: "Local Folders" org.kde.akonadi.ETM: collection: QVector() org.kde.akonadi.ETM: Fetch job took 90 msec org.kde.akonadi.ETM: was collection fetch job: collections: 6 org.kde.akonadi.ETM: first fetched collection: "Search" org.kde.akonadi.ETM: Fetch job took 2 msec org.kde.akonadi.ETM: was collection fetch job: collections: 0 akonadi_baloo_indexer(14256): Could not obtain lock for Xapian Database. This is bad akonadi_baloo_indexer(14256): "DatabaseLockError" "DatabaseLockError: Unable to get write lock on /home/supertux/.local/share/baloo/notes/: already locked" akonadi_baloo_indexer(14256): "DatabaseLockError" "DatabaseLockError: Unable to get write lock on /home/supertux/.local/share/baloo/calendars/: already locked" akonadi_baloo_indexer(14256)/libakonadi: Unable to register service "org.freedesktop.Akonadi.Agent.akonadi_baloo_indexer" at dbus: "" KCrash: Application 'akonadi_baloo_indexer' crashing... KCrash: Attempting to start /usr/lib/kde4/libexec/drkonqi from kdeinit KCrash: Connect sock_file=/home/supertux/.kde/socket-Gabi/kdeinit4__0 Unable to start Dr. Konqi Not forwarding the crash to Apport. |
||
Anmeldungsdatum: Beiträge: 12067 |
Sieht aus, als wäre deine mysql-Datenbank fehlerhaft. Hast du irgendwas™ mit MySQL gemacht? Ist dein System auf dem neuesten Stand? Gab es Probleme bei Updates/Upgrades? Vorschlag: Backup der Datenbank, dann mittels
|
||
(Themenstarter)
Anmeldungsdatum: Beiträge: 544 Wohnort: Bergisches Land |
Mein System ist auf dem neusten Stand. Ich hatte schon mal Probleme mit Akonadi. Mit MySQL habe ich an meinem System nichts gemacht. Ich erhalte dann diese Ausgabe: supertux@Gabi:~$ ps aux | grep mysql supertux 1820 0.1 1.5 1368676 126220 ? Sl 11:56 0:00 /usr/sbin/mysqld --defaults-file=/home/supertux/.local/share/akonadi/mysql.conf --datadir=/home/supertux/.local/share/akonadi/db_data/ --socket=/tmp/akonadi-supertux.S6mt5A/mysql.socket supertux 2659 0.0 0.0 15784 972 pts/4 S+ 12:04 0:00 grep --color=auto mysql supertux@Gabi:~$ mysql_upgrade --defaults-file=/home/$USER/.local/share/akonadi/mysql.conf --datadir=/home/$USER/.local/share/akonadi/db_data/ --socket=/tmp/akonadi-$USER.S6mt5A/mysql.socket mysql_upgrade: the '--datadir' option is always ignored Looking for 'mysql' as: mysql Looking for 'mysqlcheck' as: mysqlcheck Error: Failed while fetching Server version! Could be due to unauthorized access. FATAL ERROR: Upgrade failed supertux@Gabi:~$ |
||
Anmeldungsdatum: Beiträge: 12067 |
Zeige bitte die Ausgaben von
|
||
(Themenstarter)
Anmeldungsdatum: Beiträge: 544 Wohnort: Bergisches Land |
supertux@Gabi:~$ ls -lha /var/run/mysqld && find ~ ! -user $USER -ls ls: cannot access '/var/run/mysqld': No such file or directory supertux@Gabi:~$ |
||
Anmeldungsdatum: Beiträge: 12067 |
Danach noch mal upgrade versuchen. |