Re: Mysql avec Sid
On 11/25/2014 07:30 PM, Sylvain L. Sauvage wrote:
> Pas verbeux.
> T’as rien d’autre dans syslog ou /var/log/mysql{.log,/} ?
>
/var/log/mysql/error.log
141125 18:49:55 mysqld_safe mysqld from pid file
/var/run/mysqld/mysqld.pid ended
141125 19:52:13 [ERROR] Incorrect definition of table mysql.proc:
expected column 'definer' at position 11 to have type char(77), found
type char(141).
141125 19:52:13 [ERROR] Incorrect definition of table mysql.event:
expected column 'definer' at position 3 to have type char(77), found
type char(141).
141125 19:52:13 [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','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_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','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_A
ERROR: 1136 Column count doesn't match value count at row 1
141125 19:52:13 [ERROR] Aborting
141125 19:52:13 [Note] /usr/sbin/mysqld: Shutdown complete
141125 19:52:13 [Warning] Using unique option prefix myisam-recover
instead of myisam-recover-options is deprecated and will be removed in a
future release. Please use the full name instead.
141125 19:52:13 [Note] Plugin 'FEDERATED' is disabled.
141125 19:52:13 InnoDB: The InnoDB memory heap is disabled
141125 19:52:13 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141125 19:52:13 InnoDB: Compressed tables use zlib 1.2.8
141125 19:52:13 InnoDB: Using Linux native AIO
141125 19:52:13 InnoDB: Initializing buffer pool, size = 128.0M
141125 19:52:13 InnoDB: Completed initialization of buffer pool
InnoDB: Error: log file ./ib_logfile0 is of different size 0 50331648 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
141125 19:52:13 [ERROR] Plugin 'InnoDB' init function returned error.
141125 19:52:13 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE
failed.
141125 19:52:13 [ERROR] Unknown/unsupported storage engine: InnoDB
141125 19:52:13 [ERROR] Aborting
141125 19:52:13 [Note] /usr/sbin/mysqld: Shutdown complete
141125 19:52:14 [Warning] Using unique option prefix myisam-recover
instead of myisam-recover-options is deprecated and will be removed in a
future release. Please use the full name instead.
141125 19:52:14 [Note] Plugin 'FEDERATED' is disabled.
141125 19:52:14 InnoDB: The InnoDB memory heap is disabled
141125 19:52:14 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141125 19:52:14 InnoDB: Compressed tables use zlib 1.2.8
141125 19:52:14 InnoDB: Using Linux native AIO
141125 19:52:14 InnoDB: Initializing buffer pool, size = 128.0M
141125 19:52:14 InnoDB: Completed initialization of buffer pool
InnoDB: Error: log file ./ib_logfile0 is of different size 0 50331648 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
141125 19:52:14 [ERROR] Plugin 'InnoDB' init function returned error.
141125 19:52:14 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE
failed.
141125 19:52:14 [ERROR] Unknown/unsupported storage engine: InnoDB
141125 19:52:14 [ERROR] Aborting
141125 19:52:14 [Note] /usr/sbin/mysqld: Shutdown complete
141125 19:52:14 [Warning] Using unique option prefix myisam-recover
instead of myisam-recover-options is deprecated and will be removed in a
future release. Please use the full name instead.
141125 19:52:14 [Note] Plugin 'FEDERATED' is disabled.
141125 19:52:14 InnoDB: The InnoDB memory heap is disabled
141125 19:52:14 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141125 19:52:14 InnoDB: Compressed tables use zlib 1.2.8
141125 19:52:14 InnoDB: Using Linux native AIO
141125 19:52:14 InnoDB: Initializing buffer pool, size = 128.0M
141125 19:52:14 InnoDB: Completed initialization of buffer pool
InnoDB: Error: log file ./ib_logfile0 is of different size 0 50331648 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
141125 19:52:14 [ERROR] Plugin 'InnoDB' init function returned error.
141125 19:52:14 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE
failed.
141125 19:52:14 [ERROR] Unknown/unsupported storage engine: InnoDB
141125 19:52:14 [ERROR] Aborting
141125 19:52:14 [Note] /usr/sbin/mysqld: Shutdown complete
141125 19:52:15 [Warning] Using unique option prefix myisam-recover
instead of myisam-recover-options is deprecated and will be removed in a
future release. Please use the full name instead.
141125 19:52:15 [Note] Plugin 'FEDERATED' is disabled.
141125 19:52:15 InnoDB: The InnoDB memory heap is disabled
141125 19:52:15 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141125 19:52:15 InnoDB: Compressed tables use zlib 1.2.8
141125 19:52:15 InnoDB: Using Linux native AIO
141125 19:52:15 InnoDB: Initializing buffer pool, size = 128.0M
141125 19:52:15 InnoDB: Completed initialization of buffer pool
InnoDB: Error: log file ./ib_logfile0 is of different size 0 50331648 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
141125 19:52:15 [ERROR] Plugin 'InnoDB' init function returned error.
141125 19:52:15 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE
failed.
141125 19:52:15 [ERROR] Unknown/unsupported storage engine: InnoDB
141125 19:52:15 [ERROR] Aborting
141125 19:52:15 [Note] /usr/sbin/mysqld: Shutdown complete
141125 19:52:15 [Warning] Using unique option prefix myisam-recover
instead of myisam-recover-options is deprecated and will be removed in a
future release. Please use the full name instead.
141125 19:52:15 [Note] Plugin 'FEDERATED' is disabled.
141125 19:52:15 InnoDB: The InnoDB memory heap is disabled
141125 19:52:15 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141125 19:52:15 InnoDB: Compressed tables use zlib 1.2.8
141125 19:52:15 InnoDB: Using Linux native AIO
141125 19:52:15 InnoDB: Initializing buffer pool, size = 128.0M
141125 19:52:15 InnoDB: Completed initialization of buffer pool
InnoDB: Error: log file ./ib_logfile0 is of different size 0 50331648 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
141125 19:52:15 [ERROR] Plugin 'InnoDB' init function returned error.
141125 19:52:15 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE
failed.
141125 19:52:15 [ERROR] Unknown/unsupported storage engine: InnoDB
141125 19:52:15 [ERROR] Aborting
141125 19:52:15 [Note] /usr/sbin/mysqld: Shutdown complete
141125 19:52:19 mysqld_safe Starting mysqld daemon with databases from
/var/lib/mysql
141125 19:52:19 [Warning] Using unique option prefix key_buffer instead
of key_buffer_size is deprecated and will be removed in a future
release. Please use the full name instead.
141125 19:52:19 [Warning] Using unique option prefix myisam-recover
instead of myisam-recover-options is deprecated and will be removed in a
future release. Please use the full name instead.
141125 19:52:19 [Note] Plugin 'FEDERATED' is disabled.
141125 19:52:19 InnoDB: The InnoDB memory heap is disabled
141125 19:52:19 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141125 19:52:19 InnoDB: Compressed tables use zlib 1.2.8
141125 19:52:19 InnoDB: Using Linux native AIO
141125 19:52:19 InnoDB: Initializing buffer pool, size = 128.0M
141125 19:52:19 InnoDB: Completed initialization of buffer pool
InnoDB: Error: log file ./ib_logfile0 is of different size 0 50331648 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
141125 19:52:19 [ERROR] Plugin 'InnoDB' init function returned error.
141125 19:52:19 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE
failed.
141125 19:52:19 [ERROR] Unknown/unsupported storage engine: InnoDB
141125 19:52:19 [ERROR] Aborting
141125 19:52:19 [Note] /usr/sbin/mysqld: Shutdown complete
141125 19:52:19 mysqld_safe mysqld from pid file
/var/run/mysqld/mysqld.pid ended
--
Maderios
Reply to: