Hi Paul, so I still can't reproduce the error you have seen.
There are couple of things that might be improved[1][2], but the /var/run/mysqld should be created on start under either sysvinit or systemd. Are you sure that you haven't done any manual changes to /etc/init.d/mysql that would cause dpkg to not replace it with new script? Is there something like /etc/init.d/mysql.dpkg-* present on your NAS system (although I can start mariadb even with the old MySQL 5.5 init.d script). Would you be willing to test it again on your system: a) stop mariadb server b) rm -rf /var/run/mysqld c) start mariadb server Does it fails to create /var/run/mysqld? If not, then (on sysvinit system) output of: sh -x /etc/init.d/mysql start or on systemd init system output of journalctl --unit=mariadb would be appreciated. (Or can I catch you on IRC/Jabber/<other means of online communications>?) Minor nits: 1. systemd unit should use tmpfiles instead of running install -d 2. there's a race condition where /var/run/mysqld is a dangling symlink, but that's should not happen Cheers, -- Ondřej Surý <[email protected]> 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:11, Ondřej Surý wrote: > 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ý <[email protected]> > 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 > > [email protected] > > http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-mysql-maint > > Email had 1 attachment: > > + signature.asc > > 1k (application/pgp-signature) >
