[Eisfair] [E1] MySQL 2.5.0 - Crash nach Systemupdate auf MariaDB

[Benjamin Heide]

Am 21.10.2015 um 00:13 schrieb Holger Bruenjes:
> Hallo Benjamin
> 
> Am 2015-10-20 um 23:55 schrieb Benjamin Heide:
> ..
>> 151020 23:52:02 [ERROR] Unknown/unsupported storage engine: InnoDB
> 
> entferne mal die ib_logfile*  aus dem Verszeichnis /var/lib/mysql
> 
> dann noch mal starten
> 
>da passierte das selbe wie vorher.
Unknown/unsupported storage engine: InnoDB

server # /usr/bin/mysqld_safe --ledir=/usr/bin
151021 00:18:10 mysqld_safe Logging to '/var/lib/mysql/mysqld.log'.
151021 00:18:10 mysqld_safe Starting mysqld daemon with databases from
/var/lib/mysql
151021 00:18:10 mysqld_safe mysqld from pid file /run/mysql.pid ended


nun habe ich die mal umbenannt und noch mal gestartet.

server # /usr/bin/mysqld_safe --ledir=/usr/bin
151021 00:19:05 mysqld_safe Logging to '/var/lib/mysql/mysqld.log'.
151021 00:19:05 mysqld_safe Starting mysqld daemon with databases from
/var/lib/mysql

da hängt er jetzt.

151021  0:18:10 [Note] /usr/bin/mysqld: Shutdown complete

151021 00:18:10 mysqld_safe mysqld from pid file /run/mysql.pid ended
151021 00:19:05 mysqld_safe Starting mysqld daemon with databases from
/var/lib/mysql
151021  0:19:05 [Note] /usr/bin/mysqld (mysqld 5.5.45-MariaDB) starting
as process 17398 ...
151021  0:19:05 InnoDB: The InnoDB memory heap is disabled
151021  0:19:05 InnoDB: Mutexes and rw_locks use GCC atomic builtins
151021  0:19:05 InnoDB: Compressed tables use zlib 1.2.8
151021  0:19:05 InnoDB: Using Linux native AIO
151021  0:19:05 InnoDB: Initializing buffer pool, size = 128.0M
151021  0:19:05 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
151021  0:19:05  InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
151021  0:19:05  InnoDB: Log file ./ib_logfile0 did not exist: new to be
created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
151021  0:19:06  InnoDB: Log file ./ib_logfile1 did not exist: new to be
created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: 127 rollback segment(s) active.
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
151021  0:19:07  InnoDB: Waiting for the background threads to start
151021  0:19:08 Percona XtraDB (http://www.percona.com)
5.5.44-MariaDB-37.3 started; log sequence number 0
151021  0:19:08 [Note] Server socket created on IP: '0.0.0.0'.
151021  0:19:08 [ERROR] Missing system table mysql.proxies_priv; please
run mysql_upgrade to create it
151021  0:19:09 [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_TABLES','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','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_A
151021  0:19:09 [ERROR] Event Scheduler: An error occurred when
initializing system tables. Disabling the Event Scheduler.
151021  0:19:09 [Note] /usr/bin/mysqld: ready for connections.
Version: '5.5.45-MariaDB'  socket: '/run/mysql/mysql.sock'  port: 3306
eisfair-1 build