[Eisfair] [E1] MySQL 2.5.0 - cannot start!

Fabian Törner toerner at gmx.net
So Okt 4 13:13:09 CEST 2015


Am 04.10.2015 um 12:54 schrieb Fabian Törner:
> Hallo Holger,

> Was brauchst Du noch für Informationen?

evtl. noch ein paar Ausgaben aus dem Log-File:

151004 13:08:51 mysqld_safe Starting mysqld daemon with databases from 
/var/lib/mysql
151004 13:08:51 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be 
removed in a future release.
151004 13:08:51 [Note] /usr/bin/mysqld (mysqld 5.5.45-MariaDB) starting 
as process 17896 ...
151004 13:08:52 InnoDB: The InnoDB memory heap is disabled
151004 13:08:52 InnoDB: Mutexes and rw_locks use GCC atomic builtins
151004 13:08:52 InnoDB: Compressed tables use zlib 1.2.8
151004 13:08:52 InnoDB: Using Linux native AIO
151004 13:08:52 InnoDB: Initializing buffer pool, size = 128.0M
151004 13:08:52 InnoDB: Completed initialization of buffer pool
151004 13:08:52 InnoDB: highest supported file format is Barracuda.
151004 13:08:52  InnoDB: Waiting for the background threads to start
151004 13:08:53 Percona XtraDB (http://www.percona.com) 
5.5.44-MariaDB-37.3 started; log sequence number 194369558
151004 13:08:53 [ERROR] Missing system table mysql.proxies_priv; please 
run mysql_upgrade to create it
151004 13:08:53 [ERROR] Native table 
'performance_schema'.'events_waits_current' has the wrong structure
151004 13:08:53 [ERROR] Native table 
'performance_schema'.'events_waits_history' has the wrong structure
151004 13:08:53 [ERROR] Native table 
'performance_schema'.'events_waits_history_long' has the wrong structure
151004 13:08:53 [ERROR] Native table 
'performance_schema'.'setup_consumers' has the wrong structure
151004 13:08:53 [ERROR] Native table 
'performance_schema'.'setup_instruments' has the wrong structure
151004 13:08:53 [ERROR] Native table 'performance_schema'.'setup_timers' 
has the wrong structure
151004 13:08:53 [ERROR] Native table 
'performance_schema'.'performance_timers' has the wrong structure
151004 13:08:53 [ERROR] Native table 'performance_schema'.'threads' has 
the wrong structure
151004 13:08:53 [ERROR] Native table 
'performance_schema'.'events_waits_summary_by_thread_by_event_name' has 
the wrong structure
151004 13:08:53 [ERROR] Native table 
'performance_schema'.'events_waits_summary_by_instance' has the wrong 
structure
151004 13:08:53 [ERROR] Native table 
'performance_schema'.'events_waits_summary_global_by_event_name' has the 
wrong structure
151004 13:08:53 [ERROR] Native table 
'performance_schema'.'file_summary_by_event_name' has the wrong structure
151004 13:08:53 [ERROR] Native table 
'performance_schema'.'file_summary_by_instance' has the wrong structure
151004 13:08:53 [ERROR] Native table 
'performance_schema'.'mutex_instances' has the wrong structure
151004 13:08:53 [ERROR] Native table 
'performance_schema'.'rwlock_instances' has the wrong structure
151004 13:08:53 [ERROR] Native table 
'performance_schema'.'cond_instances' has the wrong structure
151004 13:08:53 [ERROR] Native table 
'performance_schema'.'file_instances' has the wrong structure
151004 13:08:53 [ERROR] Incorrect definition of table mysql.event: 
expected column 'sql_mode' at position 14 to have type 
set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','IGNORE_BAD_TABLE_OPTIONS','ONLY_FULL_GROUP_BY',
'NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABL
ES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH'), 
found type set('REAL_AS_
FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','NOT_USED','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL3
23','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_A
151004 13:08:53 [ERROR] Event Scheduler: An error occurred when 
initializing system tables. Disabling the Event Scheduler.
151004 13:08:53 [Note] /usr/bin/mysqld: ready for connections.
Version: '5.5.45-MariaDB'  socket: '/run/mysql/mysql.sock'  port: 0 
eisfair-1 build


HTH & viele Grüße
Fabian



Mehr Informationen über die Mailingliste Eisfair