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

[Benjamin Heide]

Hi Holger
> 
> 
> /var/install/bin/mariadb-tools-update-db
> 
> 
server # /var/install/bin/mariadb-tools-update-db
 * Starting MariaDB/MySQL database server ..

                                               [  OK  ]

Check database ...

und da hängt er fest.



151021  0:56:56  InnoDB: Starting shutdown...
151021  0:56:57  InnoDB: Shutdown completed; log sequence number 1597945
151021  0:56:57 [Note] /usr/bin/mysqld: Shutdown complete

151021 00:56:57 mysqld_safe mysqld from pid file /run/mysql.pid ended
151021 00:57:07 mysqld_safe Starting mysqld daemon with databases from
/var/lib/mysql
151021  0:57:07 [Note] /usr/bin/mysqld (mysqld 5.5.45-MariaDB) starting
as process 8509 ...
151021  0:57:07 InnoDB: The InnoDB memory heap is disabled
151021  0:57:07 InnoDB: Mutexes and rw_locks use GCC atomic builtins
151021  0:57:07 InnoDB: Compressed tables use zlib 1.2.8
151021  0:57:07 InnoDB: Using Linux native AIO
151021  0:57:07 InnoDB: Initializing buffer pool, size = 128.0M
151021  0:57:07 InnoDB: Completed initialization of buffer pool
151021  0:57:07 InnoDB: highest supported file format is Barracuda.
151021  0:57:07  InnoDB: Waiting for the background threads to start
151021  0:57:08 Percona XtraDB (http://www.percona.com)
5.5.44-MariaDB-37.3 started; log sequence number 1597945
151021  0:57:08 [Note] Server socket created on IP: '0.0.0.0'.
151021  0:57:08 [ERROR] Missing system table mysql.proxies_priv; please
run mysql_upgrade to create it
151021  0:57:08 [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:57:08 [ERROR] Event Scheduler: An error occurred when
initializing system tables. Disabling the Event Scheduler.
151021  0:57:08 [Note] /usr/bin/mysqld: ready for connections.
Version: '5.5.45-MariaDB'  socket: '/run/mysql/mysql.sock'  port: 3306
eisfair-1 build


so nun Bettzeit..

bis später

mega THX & cu Benjamin