[debian-mysql] jessie -> stretch upgrade with MySQL 5.5

[Paul Gevers]

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,
> 

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 488 bytes
Desc: OpenPGP digital signature
URL: <http://lists.alioth.debian.org/pipermail/pkg-mysql-maint/attachments/20170410/1893ad88/attachment.sig>