staging.inyokaproject.org

Akonadi Absturz

Status: Ungelöst | Ubuntu-Version: Kubuntu 15.10 (Wily Werewolf)
Antworten |

mw2000

Anmeldungsdatum:
27. Dezember 2009

Beiträge: 90

Hallo zusammen,

ich habe seit dem letzten Update auf 15.10 deutliche Performance Probleme und sehr oft Abstürze der "Akonadi_Ressource". Ich vermute das hat was mit dem mysql zu tun (siehe Fehlerlog), da auch mysql oft hohe CPU Last fordert. Leider bin ich mysql Leihe...

Errorlog vom mysql Test:

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
2015-12-05 13:13:30 4760 [Note] Plugin 'FEDERATED' is disabled.
2015-12-05 13:13:30 7fc6ceba5740 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2015-12-05 13:13:30 4760 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-12-05 13:13:30 4760 [Note] InnoDB: The InnoDB memory heap is disabled
2015-12-05 13:13:30 4760 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-12-05 13:13:30 4760 [Note] InnoDB: Memory barrier is not used
2015-12-05 13:13:30 4760 [Note] InnoDB: Compressed tables use zlib 1.2.8
2015-12-05 13:13:30 4760 [Note] InnoDB: Using Linux native AIO
2015-12-05 13:13:30 4760 [Note] InnoDB: Not using CPU crc32 instructions
2015-12-05 13:13:30 4760 [Note] InnoDB: Initializing buffer pool, size = 80.0M
2015-12-05 13:13:30 4760 [Note] InnoDB: Completed initialization of buffer pool
2015-12-05 13:13:30 4760 [Note] InnoDB: Highest supported file format is Barracuda.
2015-12-05 13:13:30 4760 [Note] InnoDB: 128 rollback segment(s) are active.
2015-12-05 13:13:30 4760 [Note] InnoDB: Waiting for purge to start
2015-12-05 13:13:30 4760 [Note] InnoDB: 5.6.27 started; log sequence number 8391806777
2015-12-05 13:13:30 4760 [ERROR] Column count of mysql.events_waits_current is wrong. Expected 19, found 16. Created with MySQL 50529, now running 50627. Please use mysql_upgrade to fix this error.
2015-12-05 13:13:30 4760 [ERROR] Column count of mysql.events_waits_history is wrong. Expected 19, found 16. Created with MySQL 50529, now running 50627. Please use mysql_upgrade to fix this error.
2015-12-05 13:13:30 4760 [ERROR] Column count of mysql.events_waits_history_long is wrong. Expected 19, found 16. Created with MySQL 50529, now running 50627. Please use mysql_upgrade to fix this error.
2015-12-05 13:13:30 4760 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_host_by_event_name' has the wrong structure
2015-12-05 13:13:30 4760 [ERROR] Incorrect definition of table performance_schema.events_waits_summary_by_thread_by_event_name: expected column 'THREAD_ID' at position 0 to have type bigint(20), found type int(11).
2015-12-05 13:13:30 4760 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_user_by_event_name' has the wrong structure
2015-12-05 13:13:30 4760 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_account_by_event_name' has the wrong structure
2015-12-05 13:13:30 4760 [ERROR] Column count of mysql.file_summary_by_event_name is wrong. Expected 23, found 5. Created with MySQL 50529, now running 50627. Please use mysql_upgrade to fix this error.
2015-12-05 13:13:30 4760 [ERROR] Column count of mysql.file_summary_by_instance is wrong. Expected 25, found 6. Created with MySQL 50529, now running 50627. Please use mysql_upgrade to fix this error.
2015-12-05 13:13:30 4760 [ERROR] Native table 'performance_schema'.'host_cache' has the wrong structure
2015-12-05 13:13:30 4760 [ERROR] Incorrect definition of table performance_schema.mutex_instances: expected column 'LOCKED_BY_THREAD_ID' at position 2 to have type bigint(20), found type int(11).
2015-12-05 13:13:30 4760 [ERROR] Native table 'performance_schema'.'objects_summary_global_by_type' has the wrong structure
2015-12-05 13:13:30 4760 [ERROR] Incorrect definition of table performance_schema.rwlock_instances: expected column 'WRITE_LOCKED_BY_THREAD_ID' at position 2 to have type bigint(20), found type int(11).
2015-12-05 13:13:30 4760 [ERROR] Native table 'performance_schema'.'setup_actors' has the wrong structure
2015-12-05 13:13:30 4760 [ERROR] Native table 'performance_schema'.'setup_objects' has the wrong structure
2015-12-05 13:13:30 4760 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_index_usage' has the wrong structure
2015-12-05 13:13:30 4760 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_table' has the wrong structure
2015-12-05 13:13:30 4760 [ERROR] Native table 'performance_schema'.'table_lock_waits_summary_by_table' has the wrong structure
2015-12-05 13:13:30 4760 [ERROR] Column count of mysql.threads is wrong. Expected 14, found 3. Created with MySQL 50529, now running 50627. Please use mysql_upgrade to fix this error.
2015-12-05 13:13:30 4760 [ERROR] Native table 'performance_schema'.'events_stages_current' has the wrong structure
2015-12-05 13:13:30 4760 [ERROR] Native table 'performance_schema'.'events_stages_history' has the wrong structure
2015-12-05 13:13:30 4760 [ERROR] Native table 'performance_schema'.'events_stages_history_long' has the wrong structure
2015-12-05 13:13:30 4760 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_thread_by_event_name' has the wrong structure
2015-12-05 13:13:30 4760 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_account_by_event_name' has the wrong structure
2015-12-05 13:13:30 4760 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_user_by_event_name' has the wrong structure
2015-12-05 13:13:30 4760 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_host_by_event_name' has the wrong structure
2015-12-05 13:13:30 4760 [ERROR] Native table 'performance_schema'.'events_stages_summary_global_by_event_name' has the wrong structure
2015-12-05 13:13:30 4760 [ERROR] Native table 'performance_schema'.'events_statements_current' has the wrong structure
2015-12-05 13:13:30 4760 [ERROR] Native table 'performance_schema'.'events_statements_history' has the wrong structure
2015-12-05 13:13:30 4760 [ERROR] Native table 'performance_schema'.'events_statements_history_long' has the wrong structure
2015-12-05 13:13:30 4760 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_thread_by_event_name' has the wrong structure
2015-12-05 13:13:30 4760 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_account_by_event_name' has the wrong structure
2015-12-05 13:13:30 4760 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_user_by_event_name' has the wrong structure
2015-12-05 13:13:30 4760 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_host_by_event_name' has the wrong structure
2015-12-05 13:13:30 4760 [ERROR] Native table 'performance_schema'.'events_statements_summary_global_by_event_name' has the wrong structure
2015-12-05 13:13:30 4760 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_digest' has the wrong structure
2015-12-05 13:13:30 4760 [ERROR] Native table 'performance_schema'.'users' has the wrong structure
2015-12-05 13:13:30 4760 [ERROR] Native table 'performance_schema'.'accounts' has the wrong structure
2015-12-05 13:13:30 4760 [ERROR] Native table 'performance_schema'.'hosts' has the wrong structure
2015-12-05 13:13:30 4760 [ERROR] Native table 'performance_schema'.'socket_instances' has the wrong structure
2015-12-05 13:13:30 4760 [ERROR] Native table 'performance_schema'.'socket_summary_by_instance' has the wrong structure
2015-12-05 13:13:30 4760 [ERROR] Native table 'performance_schema'.'socket_summary_by_event_name' has the wrong structure
2015-12-05 13:13:30 4760 [ERROR] Native table 'performance_schema'.'session_connect_attrs' has the wrong structure
2015-12-05 13:13:30 4760 [ERROR] Native table 'performance_schema'.'session_account_connect_attrs' has the wrong structure
2015-12-05 13:13:30 4760 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.6.27-0ubuntu1'  socket: '/tmp/akonadi-matthias.tQpLsk/mysql.socket'  port: 0  (Ubuntu)
2015-12-05 13:13:30 7fc6bd900700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2015-12-05 13:13:30 7fc6bd900700 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.
2015-12-05 13:13:30 7fc6bd900700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2015-12-05 13:13:30 7fc6bd900700 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.
2015-12-05 13:13:30 7fc6bd900700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2015-12-05 13:13:30 7fc6bd900700 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.
2015-12-05 13:13:31 7fc6bd900700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2015-12-05 13:13:31 7fc6bd900700 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.
2015-12-05 13:13:31 7fc6bd900700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2015-12-05 13:13:31 7fc6bd900700 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.
2015-12-05 13:13:31 7fc6bd900700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2015-12-05 13:13:31 7fc6bd900700 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.
2015-12-05 13:13:31 7fc6bd900700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2015-12-05 13:13:31 7fc6bd900700 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.
2015-12-05 13:13:31 7fc6bd900700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2015-12-05 13:13:31 7fc6bd900700 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.
2015-12-05 13:13:31 7fc6bd900700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2015-12-05 13:13:31 7fc6bd900700 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.
2015-12-05 13:13:31 7fc6bd900700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2015-12-05 13:13:31 7fc6bd900700 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.
2015-12-05 13:13:31 7fc6bd900700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2015-12-05 13:13:31 7fc6bd900700 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.
2015-12-05 13:13:31 7fc6bd900700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2015-12-05 13:13:31 7fc6bd900700 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.
2015-12-05 13:13:31 7fc6bd900700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2015-12-05 13:13:31 7fc6bd900700 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.
2015-12-05 13:13:31 7fc6bd900700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2015-12-05 13:13:31 7fc6bd900700 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.
2015-12-05 13:13:31 7fc6bd900700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2015-12-05 13:13:31 7fc6bd900700 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.
2015-12-05 13:13:31 7fc6bd900700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2015-12-05 13:13:31 7fc6bd900700 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.
2015-12-05 13:13:31 7fc6bd900700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2015-12-05 13:13:31 7fc6bd900700 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.
2015-12-05 13:13:31 7fc6bd900700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2015-12-05 13:13:31 7fc6bd900700 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.
2015-12-05 13:13:31 7fc6bd900700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2015-12-05 13:13:31 7fc6bd900700 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.

Im Netz gibt es dazu ein paar bugfixe, aber damit kam doch als Leihe nicht klar...

Kann mir hier jemand weiterhelfen?

Im Anhang den gesamten Testbericht von Akonadi.

Vielen Dank

MAtthias

Tids Team-Icon

Avatar von Tids

Anmeldungsdatum:
29. Oktober 2008

Beiträge: 3065

Versuch mal auf mariadb zu stellen. Meiner Meinung nach hat es ne bessere Leistung.

pkexec apt-get install mariadb-server mariadb-client

Ansonsten mach mal bitte

pkexec apt-get install kubuntu-desktop akonadi-backend-mysql akonadi-server --reinstall 
akonadictl status
akonadictl fsck
akonadictl vacuum
akonadictl start

in einer konsole

mw2000

(Themenstarter)

Anmeldungsdatum:
27. Dezember 2009

Beiträge: 90

Hallo,

danke für die Antwort, war leider ein paar Tage Offline, daher erst jetzt meine Antwort (sorry). Aber ich hatte danach noch weitere Probleme am Rechner, dieser war schon 7Jahre alt und ich hatte schon ewig nicht mehr neu installiert. Daher habe ich mir kurzentschlossen einen neuen gekauft und völlig neu aufgesetzt. Ich habe mysql natürlich sofort angeschaut und die Fehler sind dort nicht vorhanden.

Ich werde deine Vorschlag an dem alten über Weihnachten noch mal testen und berichten.

GRuß

MAtthias

Antworten |