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

[Otto Kekäläinen]

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