Paul, thanks, my E_TOO_MANY_EMAILS hit me again. Seems like the error can be safely ignored, and the real issue is the missing rundir.
So, couple more questions: 1. what init system does your NAS have after upgrade? 2. did you reboot the system between removing mysql-server-5.5 and mariadb-server-10.0 (purging /var/run on tmpfs)? Cheers, -- Ondřej Surý <ond...@sury.org> Knot DNS (https://www.knot-dns.cz/) – a high-performance DNS server Knot Resolver (https://www.knot-resolver.cz/) – secure, privacy-aware, fast DNS(SEC) resolver Vše pro chleba (https://vseprochleba.cz) – Mouky ze mlýna a potřeby pro pečení chleba všeho druhu On Mon, Apr 10, 2017, at 22:05, Paul Gevers wrote: > Oh, and I assume you take > https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=859800 into account. > That has an update with respect to my first e-mail. > > Paul > > On 04/10/17 22:00, Ondřej Surý wrote: > > I spoke too soon. I see the aforementioned errors in the log file: > > > > 2017-04-10 19:48:36 140304128580992 [Note] InnoDB: Using mutexes to ref > > count buffer pool pages > > 2017-04-10 19:48:36 140304128580992 [Note] InnoDB: The InnoDB memory > > heap is disabled > > 2017-04-10 19:48:36 140304128580992 [Note] InnoDB: Mutexes and rw_locks > > use GCC atomic builtins > > 2017-04-10 19:48:36 140304128580992 [Note] InnoDB: GCC builtin > > __atomic_thread_fence() is used for memory barrier > > 2017-04-10 19:48:36 140304128580992 [Note] InnoDB: Compressed tables use > > zlib 1.2.8 > > 2017-04-10 19:48:36 140304128580992 [Note] InnoDB: Using Linux native > > AIO > > 2017-04-10 19:48:36 140304128580992 [Note] InnoDB: Using SSE crc32 > > instructions > > 2017-04-10 19:48:36 140304128580992 [Note] InnoDB: Initializing buffer > > pool, size = 128.0M > > 2017-04-10 19:48:36 140304128580992 [Note] InnoDB: Completed > > initialization of buffer pool > > 2017-04-10 19:48:36 140304128580992 [Note] InnoDB: Highest supported > > file format is Barracuda. > > 2017-04-10 19:48:36 140304128580992 [Note] InnoDB: Creating tablespace > > and datafile system tables. > > 2017-04-10 19:48:36 140304128580992 [Note] InnoDB: Tablespace and > > datafile system tables created. > > 2017-04-10 19:48:36 140304128580992 [Warning] InnoDB: Resizing redo log > > from 2*320 to 2*3072 pages, LSN=1600094 > > 2017-04-10 19:48:36 140304128580992 [Warning] InnoDB: Starting to delete > > and rewrite log files. > > 2017-04-10 19:48:36 140304128580992 [Note] InnoDB: Setting log file > > ./ib_logfile101 size to 48 MB > > 2017-04-10 19:48:36 140304128580992 [Note] InnoDB: Setting log file > > ./ib_logfile1 size to 48 MB > > 2017-04-10 19:48:36 140304128580992 [Note] InnoDB: Renaming log file > > ./ib_logfile101 to ./ib_logfile0 > > 2017-04-10 19:48:36 140304128580992 [Warning] InnoDB: New log files > > created, LSN=1600524 > > 2017-04-10 19:48:36 140304128580992 [Note] InnoDB: 128 rollback > > segment(s) are active. > > 2017-04-10 19:48:36 140304128580992 [Note] InnoDB: Waiting for purge to > > start > > 2017-04-10 19:48:36 140304128580992 [Note] InnoDB: Percona XtraDB > > (http://www.percona.com) 5.6.35-80.0 started; log sequence number > > 1595685 > > 2017-04-10 19:48:36 140303495309056 [Note] InnoDB: Dumping buffer > > pool(s) not yet started > > 2017-04-10 19:48:36 140304075331328 [ERROR] Incorrect definition of > > table mysql.proc: 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','INVA > > 2017-04-10 19:48:36 140304075331328 [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 > > ERROR: 1136 Column count doesn't match value count at row 1 > > 2017-04-10 19:48:36 140304128580992 [ERROR] Aborting > > > > 2017-04-10 19:48:39 140567571205504 [Note] InnoDB: Using mutexes to ref > > count buffer pool pages > > 2017-04-10 19:48:39 140567571205504 [Note] InnoDB: The InnoDB memory > > heap is disabled > > 2017-04-10 19:48:39 140567571205504 [Note] InnoDB: Mutexes and rw_locks > > use GCC atomic builtins > > 2017-04-10 19:48:39 140567571205504 [Note] InnoDB: GCC builtin > > __atomic_thread_fence() is used for memory barrier > > 2017-04-10 19:48:39 140567571205504 [Note] InnoDB: Compressed tables use > > zlib 1.2.8 > > 2017-04-10 19:48:39 140567571205504 [Note] InnoDB: Using Linux native > > AIO > > 2017-04-10 19:48:39 140567571205504 [Note] InnoDB: Using SSE crc32 > > instructions > > 2017-04-10 19:48:39 140567571205504 [Note] InnoDB: Initializing buffer > > pool, size = 128.0M > > 2017-04-10 19:48:39 140567571205504 [Note] InnoDB: Completed > > initialization of buffer pool > > 2017-04-10 19:48:39 140567571205504 [Note] InnoDB: Highest supported > > file format is Barracuda. > > 2017-04-10 19:48:39 140567571205504 [Note] InnoDB: 128 rollback > > segment(s) are active. > > 2017-04-10 19:48:39 140567571205504 [Note] InnoDB: Waiting for purge to > > start > > 2017-04-10 19:48:39 140567571205504 [Note] InnoDB: Percona XtraDB > > (http://www.percona.com) 5.6.35-80.0 started; log sequence number > > 1616614 > > 2017-04-10 19:48:39 140566939551488 [Note] InnoDB: Dumping buffer > > pool(s) not yet started > > 2017-04-10 19:48:39 140567571205504 [Note] Plugin 'FEEDBACK' is > > disabled. > > > > But my mysqld process starts after that, unlike yours. > > > > Cheers, > > > > _______________________________________________ > pkg-mysql-maint mailing list > pkg-mysql-ma...@lists.alioth.debian.org > http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-mysql-maint > Email had 1 attachment: > + signature.asc > 1k (application/pgp-signature)
