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

[Ondřej Surý]

I guess this is the same problem with clashing postrm scripts as with
mariadb-10.0 -> mariadb-11.0. I'll investigate and prepare fix for
mysql-5.5 packages in jessie.

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 Sun, Apr 9, 2017, at 19:05, Otto Kekäläinen wrote:
> Thanks Paul for reporting!
> 
> Ondrej, can you take a look at this as you recently updated the
> postinstall scripts and have your Jenkins upgrade tests in place? You
> should be in a good position to debug this.
> 
> 
> 
> 
> 2017-04-07 14:24 GMT+03:00 Paul Gevers <elbrus at debian.org>:
> > Hi Otto (and all the others),
> >
> > I just upgraded my NAS to Stretch which (in hind-sight) was running
> > MySQL 5.5. After the upgrade, the daemon wasn't running, so I thought to
> > install mariadb-server. However, now I get the following message in the
> > /var/log/mysql/error.log:
> >
> > 2017-04-07 12:45:49 3053044544 [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_SUBT\
> > RACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL3\
> > 23','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZE\
> > RO_DATE','INVA
> > 2017-04-07 12:45:49 3053044544 [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_SUB\
> > TRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL\
> > 323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_Z\
> > ERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTI\
> > ON','PAD_CHAR_TO_FULL_LENGTH'), found type
> > set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','NOT_USED','ONLY_FULL_GR\
> > OUP_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-07 12:45:49 3062317056 [ERROR] Aborting
> >
> > The daemon still isn't running (see the final "Aborting").
> >
> > Is this a known issue? Can I fix it? Does this (and/or the MySQL/MariaDB
> > situation) warrant a note in the release notes?
> >
> > I already tried running mysql_upgrade but that fails:
> > paul at fuji ~ $ sudo /usr/bin/mysql_upgrade
> > Version check failed. Got the following error when calling the 'mysql'
> > command line client
> > ERROR 2002 (HY000): Can't connect to local MySQL server through socket
> > '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")
> > FATAL ERROR: Upgrade failed
> >
> > Paul
> >
> >
> >
> >
> > _______________________________________________
> > 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
> 
> 
> 
> -- 
> Otto Kekäläinen
> https://keybase.io/ottok
> Seravo Oy and MariaDB Foundation