Tâche #31353
Scénario #30986: Implémenter l'Upgrade Auto 2.7.2 → 2.8.0
Problème d'upgrade de mysql sur Thot
Début:
02/12/2020
Echéance:
% réalisé:
100%
Restant à faire (heures):
0.0
Description
Warning: The unit file, source configuration file or drop-ins of mysql.service changed on disk. Run 'systemctl daemon-reload' to reload units. + set -e + case "$1" in + '[' -e /etc/mysql/FROZEN -o -h /etc/mysql/FROZEN ']' + mysql_datadir=/usr/share/mysql + mysql_statedir=/var/lib/mysql + mysql_rundir=/var/run/mysqld + mysql_logdir=/var/log/mysql + mysql_cfgdir=/etc/mysql + mysql_upgradedir=/var/lib/mysql-upgrade + mysql_filesdir=/var/lib/mysql-files + mysql_keyringdir=/var/lib/mysql-keyring + aa-status --enabled + apparmor_parser -r -T -W /etc/apparmor.d/usr.sbin.mysqld + /usr/share/mysql-common/configure-symlinks install mysql /etc/mysql/mysql.cnf + for d in $mysql_statedir $mysql_filesdir $mysql_keyringdir $mysql_logdir + '[' '!' -d /var/lib/mysql -a '!' -L /var/lib/mysql ']' + chown -R mysql:mysql /var/lib/mysql + chmod 0700 /var/lib/mysql + for d in $mysql_statedir $mysql_filesdir $mysql_keyringdir $mysql_logdir + '[' '!' -d /var/lib/mysql-files -a '!' -L /var/lib/mysql-files ']' + chown -R mysql:mysql /var/lib/mysql-files + chmod 0700 /var/lib/mysql-files + for d in $mysql_statedir $mysql_filesdir $mysql_keyringdir $mysql_logdir + '[' '!' -d /var/lib/mysql-keyring -a '!' -L /var/lib/mysql-keyring ']' + chown -R mysql:mysql /var/lib/mysql-keyring + chmod 0700 /var/lib/mysql-keyring + for d in $mysql_statedir $mysql_filesdir $mysql_keyringdir $mysql_logdir + '[' '!' -d /var/log/mysql -a '!' -L /var/log/mysql ']' + chown -R mysql:mysql /var/log/mysql + chmod 0700 /var/log/mysql + set +e + chown -R 0:0 /usr/share/mysql + touch /var/log/mysql/error.log + chown -R mysql:adm /var/log/mysql + chmod 0750 /var/log/mysql + chmod 0640 /var/log/mysql/error.log + set -e + db_set mysql-server/postrm_remove_database false + _db_cmd 'SET mysql-server/postrm_remove_database' false + _db_internal_IFS=' ' + IFS=' ' + printf '%s\n' 'SET mysql-server/postrm_remove_database false' + IFS=' ' + read -r _db_internal_line debconf (developer): <-- SET mysql-server/postrm_remove_database false debconf (developer): --> 10 mysql-server/postrm_remove_database doesn't exist + IFS=' ' + RET='10 mysql-server/postrm_remove_database doesn'\''t exist' + case ${_db_internal_line%%[ ]*} in + return 10 + true + dpkg --compare-versions '' le 8.0.16-0ubuntu3~ + echo 'Renaming removed key_buffer and myisam-recover options (if present)' Renaming removed key_buffer and myisam-recover options (if present) + fix_old_config_options + sed -e 's/[[:space:]]*query\_cache*/# Deprecated query cache option disabled by maintainer script\n#query\_cache/' /etc/mysql/mysql.conf.d/mysqld.cnf --in-place=.bak + cmp -s /etc/mysql/mysql.conf.d/mysqld.cnf /etc/mysql/mysql.conf.d/mysqld.cnf.bak + test_mysqld_startup + result=0 ++ mysqld --verbose --help --innodb-read-only + output='2020-12-07T16:21:47.755611Z 0 [ERROR] [MY-000077] [Server] /usr/sbin/mysqld: Error while setting value '\''ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'\'' to '\''sql_mode'\''. 2020-12-07T16:21:47.759197Z 0 [ERROR] [MY-010119] [Server] Aborting' + result=1 + '[' '!' 1 = 0 ']' + echo 'ERROR: Unable to start MySQL server:' ERROR: Unable to start MySQL server: + echo '2020-12-07T16:21:47.755611Z 0 [ERROR] [MY-000077] [Server] /usr/sbin/mysqld: Error while setting value '\''ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'\'' to '\''sql_mode'\''. 2020-12-07T16:21:47.759197Z 0 [ERROR] [MY-010119] [Server] Aborting' 2020-12-07T16:21:47.755611Z 0 [ERROR] [MY-000077] [Server] /usr/sbin/mysqld: Error while setting value 'ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' to 'sql_mode'. 2020-12-07T16:21:47.759197Z 0 [ERROR] [MY-010119] [Server] Aborting + echo 'Please take a look at https://wiki.debian.org/Teams/MySQL/FAQ for tips on fixing common upgrade issues.' Please take a look at https://wiki.debian.org/Teams/MySQL/FAQ for tips on fixing common upgrade issues. + echo 'Once the problem is resolved, run apt-get --fix-broken install to retry.' Once the problem is resolved, run apt-get --fix-broken install to retry. + return 1
Révisions associées
Les 'modes' configurés en 2.7 n'existe plus en 2.8 (ref #31353)
Les 'modes' configurés en 2.7 n'existe plus en 2.8 (ref #31353)
Historique
#1 Mis à jour par Emmanuel GARETTE il y a plus de 3 ans
#2 Mis à jour par Emmanuel GARETTE il y a plus de 3 ans
- Statut changé de Nouveau à En cours
#3 Mis à jour par Emmanuel GARETTE il y a plus de 3 ans
- Assigné à mis à Emmanuel GARETTE
#4 Mis à jour par Emmanuel GARETTE il y a plus de 3 ans
- % réalisé changé de 0 à 100
#5 Mis à jour par Emmanuel GARETTE il y a plus de 3 ans
- Statut changé de En cours à Résolu
#6 Mis à jour par Joël Cuissinat il y a plus de 3 ans
Vu :
11:39:13 run-parts: executing /tmp/Upgrade-Auto/pre_upgrade/10-mysql
L'Upgrade est OK (exécution n°13) : https://dev-eole.ac-dijon.fr/jenkins/job/2.8.0/job/test-upgradeauto-thot-272-2.8.0-amd64/
#7 Mis à jour par Joël Cuissinat il y a plus de 3 ans
- Statut changé de Résolu à Fermé
- Restant à faire (heures) mis à 0.0