[mythtv-users] mysqld.log showing errors after f18 > f19/MariaDB upgrade
John Pilkington
J.Pilk at tesco.net
Wed Jan 8 11:50:56 UTC 2014
I moved from f18 to f19 two days ago, and today installed a MariaDB
update. Things [v0.27-109-gcb744f8] seem to be working but mysqld.log
has complaints about table mysql.event and the IP address of the FE/BE
box. Ought I to do anything?
TIA
John P
140108 11:19:47 Percona XtraDB (http://www.percona.com)
5.5.34-MariaDB-31.1 started; log sequence number 208668856
140108 11:19:47 [Note] Plugin 'FEEDBACK' is disabled.
140108 11:19:47 [Note] Server socket created on IP: '0.0.0.0'.
140108 11:19:47 [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
140108 11:19:47 [ERROR] Event Scheduler: An error occurred when
initializing system tables. Disabling the Event Scheduler.
140108 11:19:47 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.34-MariaDB' socket: '/var/lib/mysql/mysql.sock' port:
3306 MariaDB Server
140108 11:24:17 [Warning] IP address '192.168.1.4' could not be
resolved: Name or service not known
More information about the mythtv-users
mailing list