[debian-mysql] Bug#859800: jessie -> stretch upgrade with MySQL 5.5

Mon Apr 10 20:47:15 UTC 2017

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ý <ondrej at 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: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ý <ondrej at 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-maint at 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)
> 