Kubuntu 16.10 KDE 5.7.5 Kontact 5.2.3 mysql Ver 14.14 Distrib 5.7.16
Ich bekomme es einfach nicht hin, diese table wrong structure Fehler zu beheben, löschen bzw. umbenennen von .local/share/akonadi hat zwar einige andere Fehler beseitigt habe auch ein mysql_upgrade durchgeführt danach musste ich die Kalender und Kontakte noch einmal importiern ... Es läuft zwar soweit alles (ab und zu mal wenige Aussetzer) ich würde aber gerne noch diese ganzen mysql Fehler beseitigen ... kann mir jemand weiterhelfen?
2016-12-24T10:10:45.788556Z 0 [Warning] The syntax '--log_warnings/-W' is deprecated and will be removed in a future release. Please use '--log_error_verbosity' instead. 2016-12-24T10:10:45.788637Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2016-12-24T10:10:45.790760Z 0 [Warning] Insecure configuration for --secure-file-priv: Location is accessible to all OS users. Consider choosing a different directory. 2016-12-24T10:10:45.790833Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.16-0ubuntu0.16.10.1) starting as process 21511 ... 2016-12-24T10:10:45.794325Z 0 [Note] InnoDB: PUNCH HOLE support available 2016-12-24T10:10:45.794373Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2016-12-24T10:10:45.794379Z 0 [Note] InnoDB: Uses event mutexes 2016-12-24T10:10:45.794385Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2016-12-24T10:10:45.794390Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2016-12-24T10:10:45.794395Z 0 [Note] InnoDB: Using Linux native AIO 2016-12-24T10:10:45.794850Z 0 [Note] InnoDB: Number of pools: 1 2016-12-24T10:10:45.795066Z 0 [Note] InnoDB: Not using CPU crc32 instructions 2016-12-24T10:10:45.797291Z 0 [Note] InnoDB: Initializing buffer pool, total size = 80M, instances = 1, chunk size = 80M 2016-12-24T10:10:45.805768Z 0 [Note] InnoDB: Completed initialization of buffer pool 2016-12-24T10:10:45.808599Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2016-12-24T10:10:45.837099Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2016-12-24T10:10:45.951081Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2016-12-24T10:10:45.951242Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2016-12-24T10:10:46.023524Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2016-12-24T10:10:46.026285Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2016-12-24T10:10:46.026346Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2016-12-24T10:10:46.028320Z 0 [Note] InnoDB: 5.7.16 started; log sequence number 52605410 2016-12-24T10:10:46.028739Z 0 [Note] InnoDB: Loading buffer pool(s) from /home/globe/.local/share/akonadi/db_data/ib_buffer_pool 2016-12-24T10:10:46.028825Z 0 [Note] Plugin 'FEDERATED' is disabled. 2016-12-24T10:10:46.029956Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened. 2016-12-24T10:10:46.030152Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key 2016-12-24T10:10:46.036032Z 0 [Warning] Failed to open optimizer cost constant tables 2016-12-24T10:10:46.036188Z 0 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them 2016-12-24T10:10:46.036235Z 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist 2016-12-24T10:10:46.036327Z 0 [ERROR] Native table 'performance_schema'.'cond_instances' has the wrong structure 2016-12-24T10:10:46.036346Z 0 [ERROR] Native table 'performance_schema'.'events_waits_current' has the wrong structure 2016-12-24T10:10:46.036363Z 0 [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure 2016-12-24T10:10:46.036381Z 0 [ERROR] Native table 'performance_schema'.'events_waits_history_long' has the wrong structure 2016-12-24T10:10:46.036401Z 0 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_host_by_event_name' has the wrong structure 2016-12-24T10:10:46.036419Z 0 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_instance' has the wrong structure 2016-12-24T10:10:46.036439Z 0 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_thread_by_event_name' has the wrong structure 2016-12-24T10:10:46.036458Z 0 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_user_by_event_name' has the wrong structure 2016-12-24T10:10:46.036492Z 0 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_account_by_event_name' has the wrong structure 2016-12-24T10:10:46.036511Z 0 [ERROR] Native table 'performance_schema'.'events_waits_summary_global_by_event_name' has the wrong structure 2016-12-24T10:10:46.036529Z 0 [ERROR] Native table 'performance_schema'.'file_instances' has the wrong structure 2016-12-24T10:10:46.036547Z 0 [ERROR] Native table 'performance_schema'.'file_summary_by_event_name' has the wrong structure 2016-12-24T10:10:46.036565Z 0 [ERROR] Native table 'performance_schema'.'file_summary_by_instance' has the wrong structure 2016-12-24T10:10:46.036583Z 0 [ERROR] Native table 'performance_schema'.'host_cache' has the wrong structure 2016-12-24T10:10:46.036600Z 0 [ERROR] Native table 'performance_schema'.'mutex_instances' has the wrong structure 2016-12-24T10:10:46.036617Z 0 [ERROR] Native table 'performance_schema'.'objects_summary_global_by_type' has the wrong structure 2016-12-24T10:10:46.036636Z 0 [ERROR] Native table 'performance_schema'.'performance_timers' has the wrong structure 2016-12-24T10:10:46.036654Z 0 [ERROR] Native table 'performance_schema'.'rwlock_instances' has the wrong structure 2016-12-24T10:10:46.036672Z 0 [ERROR] Native table 'performance_schema'.'setup_actors' has the wrong structure 2016-12-24T10:10:46.038044Z 0 [ERROR] Native table 'performance_schema'.'setup_consumers' has the wrong structure 2016-12-24T10:10:46.038107Z 0 [ERROR] Native table 'performance_schema'.'setup_instruments' has the wrong structure 2016-12-24T10:10:46.038125Z 0 [ERROR] Native table 'performance_schema'.'setup_objects' has the wrong structure 2016-12-24T10:10:46.038143Z 0 [ERROR] Native table 'performance_schema'.'setup_timers' has the wrong structure 2016-12-24T10:10:46.038163Z 0 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_index_usage' has the wrong structure 2016-12-24T10:10:46.038180Z 0 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_table' has the wrong structure 2016-12-24T10:10:46.038198Z 0 [ERROR] Native table 'performance_schema'.'table_lock_waits_summary_by_table' has the wrong structure 2016-12-24T10:10:46.038215Z 0 [ERROR] Native table 'performance_schema'.'threads' has the wrong structure 2016-12-24T10:10:46.038232Z 0 [ERROR] Native table 'performance_schema'.'events_stages_current' has the wrong structure 2016-12-24T10:10:46.038250Z 0 [ERROR] Native table 'performance_schema'.'events_stages_history' has the wrong structure 2016-12-24T10:10:46.038268Z 0 [ERROR] Native table 'performance_schema'.'events_stages_history_long' has the wrong structure 2016-12-24T10:10:46.038289Z 0 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_thread_by_event_name' has the wrong structure 2016-12-24T10:10:46.038309Z 0 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_account_by_event_name' has the wrong structure 2016-12-24T10:10:46.038328Z 0 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_user_by_event_name' has the wrong structure 2016-12-24T10:10:46.038346Z 0 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_host_by_event_name' has the wrong structure 2016-12-24T10:10:46.038366Z 0 [ERROR] Native table 'performance_schema'.'events_stages_summary_global_by_event_name' has the wrong structure 2016-12-24T10:10:46.038383Z 0 [ERROR] Native table 'performance_schema'.'events_statements_current' has the wrong structure 2016-12-24T10:10:46.038400Z 0 [ERROR] Native table 'performance_schema'.'events_statements_history' has the wrong structure 2016-12-24T10:10:46.038418Z 0 [ERROR] Native table 'performance_schema'.'events_statements_history_long' has the wrong structure 2016-12-24T10:10:46.038437Z 0 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_thread_by_event_name' has the wrong structure 2016-12-24T10:10:46.038456Z 0 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_account_by_event_name' has the wrong structure 2016-12-24T10:10:46.038490Z 0 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_user_by_event_name' has the wrong structure 2016-12-24T10:10:46.038509Z 0 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_host_by_event_name' has the wrong structure 2016-12-24T10:10:46.038528Z 0 [ERROR] Native table 'performance_schema'.'events_statements_summary_global_by_event_name' has the wrong structure 2016-12-24T10:10:46.038546Z 0 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_digest' has the wrong structure 2016-12-24T10:10:46.038565Z 0 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_program' has the wrong structure 2016-12-24T10:10:46.038582Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_current' has the wrong structure 2016-12-24T10:10:46.038599Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_history' has the wrong structure 2016-12-24T10:10:46.038616Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_history_long' has the wrong structure 2016-12-24T10:10:46.038636Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_summary_by_thread_by_event_name' has the wrong structure 2016-12-24T10:10:46.038655Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_summary_by_account_by_event_name' has the wrong structure 2016-12-24T10:10:46.038674Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_summary_by_user_by_event_name' has the wrong structure 2016-12-24T10:10:46.038693Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_summary_by_host_by_event_name' has the wrong structure 2016-12-24T10:10:46.038712Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_summary_global_by_event_name' has the wrong structure 2016-12-24T10:10:46.038728Z 0 [ERROR] Native table 'performance_schema'.'users' has the wrong structure 2016-12-24T10:10:46.038745Z 0 [ERROR] Native table 'performance_schema'.'accounts' has the wrong structure 2016-12-24T10:10:46.038761Z 0 [ERROR] Native table 'performance_schema'.'hosts' has the wrong structure 2016-12-24T10:10:46.038778Z 0 [ERROR] Native table 'performance_schema'.'socket_instances' has the wrong structure 2016-12-24T10:10:46.038795Z 0 [ERROR] Native table 'performance_schema'.'socket_summary_by_instance' has the wrong structure 2016-12-24T10:10:46.038812Z 0 [ERROR] Native table 'performance_schema'.'socket_summary_by_event_name' has the wrong structure 2016-12-24T10:10:46.038830Z 0 [ERROR] Native table 'performance_schema'.'session_connect_attrs' has the wrong structure 2016-12-24T10:10:46.038848Z 0 [ERROR] Native table 'performance_schema'.'session_account_connect_attrs' has the wrong structure 2016-12-24T10:10:46.038867Z 0 [ERROR] Native table 'performance_schema'.'memory_summary_global_by_event_name' has the wrong structure 2016-12-24T10:10:46.038887Z 0 [ERROR] Native table 'performance_schema'.'memory_summary_by_account_by_event_name' has the wrong structure 2016-12-24T10:10:46.038907Z 0 [ERROR] Native table 'performance_schema'.'memory_summary_by_host_by_event_name' has the wrong structure 2016-12-24T10:10:46.038926Z 0 [ERROR] Native table 'performance_schema'.'memory_summary_by_thread_by_event_name' has the wrong structure 2016-12-24T10:10:46.038945Z 0 [ERROR] Native table 'performance_schema'.'memory_summary_by_user_by_event_name' has the wrong structure 2016-12-24T10:10:46.038961Z 0 [ERROR] Native table 'performance_schema'.'table_handles' has the wrong structure 2016-12-24T10:10:46.038979Z 0 [ERROR] Native table 'performance_schema'.'metadata_locks' has the wrong structure 2016-12-24T10:10:46.039015Z 0 [ERROR] Native table 'performance_schema'.'replication_connection_configuration' has the wrong structure 2016-12-24T10:10:46.039034Z 0 [ERROR] Native table 'performance_schema'.'replication_group_members' has the wrong structure 2016-12-24T10:10:46.039051Z 0 [ERROR] Native table 'performance_schema'.'replication_connection_status' has the wrong structure 2016-12-24T10:10:46.039078Z 0 [ERROR] Native table 'performance_schema'.'replication_applier_configuration' has the wrong structure 2016-12-24T10:10:46.039096Z 0 [ERROR] Native table 'performance_schema'.'replication_applier_status' has the wrong structure 2016-12-24T10:10:46.039114Z 0 [ERROR] Native table 'performance_schema'.'replication_applier_status_by_coordinator' has the wrong structure 2016-12-24T10:10:46.039132Z 0 [ERROR] Native table 'performance_schema'.'replication_applier_status_by_worker' has the wrong structure 2016-12-24T10:10:46.039151Z 0 [ERROR] Native table 'performance_schema'.'replication_group_member_stats' has the wrong structure 2016-12-24T10:10:46.039168Z 0 [ERROR] Native table 'performance_schema'.'prepared_statements_instances' has the wrong structure 2016-12-24T10:10:46.039186Z 0 [ERROR] Native table 'performance_schema'.'user_variables_by_thread' has the wrong structure 2016-12-24T10:10:46.039203Z 0 [ERROR] Native table 'performance_schema'.'status_by_account' has the wrong structure 2016-12-24T10:10:46.039219Z 0 [ERROR] Native table 'performance_schema'.'status_by_host' has the wrong structure 2016-12-24T10:10:46.039236Z 0 [ERROR] Native table 'performance_schema'.'status_by_thread' has the wrong structure 2016-12-24T10:10:46.039253Z 0 [ERROR] Native table 'performance_schema'.'status_by_user' has the wrong structure 2016-12-24T10:10:46.039269Z 0 [ERROR] Native table 'performance_schema'.'global_status' has the wrong structure 2016-12-24T10:10:46.039285Z 0 [ERROR] Native table 'performance_schema'.'session_status' has the wrong structure 2016-12-24T10:10:46.039302Z 0 [ERROR] Native table 'performance_schema'.'variables_by_thread' has the wrong structure 2016-12-24T10:10:46.039319Z 0 [ERROR] Native table 'performance_schema'.'global_variables' has the wrong structure 2016-12-24T10:10:46.039335Z 0 [ERROR] Native table 'performance_schema'.'session_variables' has the wrong structure 2016-12-24T10:10:46.039740Z 0 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.7.16-0ubuntu0.16.10.1' socket: '/tmp/akonadi-globe.HjFKGQ/mysql.socket' port: 0 (Ubuntu) 2016-12-24T10:10:46.083086Z 0 [Note] InnoDB: Buffer pool(s) load completed at 161224 11:10:46