Project

General

Profile

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

Added by Emmanuel GARETTE 10 months ago. Updated 9 months ago.

Status:
Fermé
Priority:
Normal
Assigned To:
Start date:
12/02/2020
Due date:
% Done:

100%

Remaining (hours):
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

=> https://dev-eole.ac-dijon.fr/jenkins/job/2.8.0/job/test-upgradeauto-thot-272-2.8.0-amd64/6/parsed_console/

Associated revisions

Revision d611b6c5 (diff)
Added by Emmanuel GARETTE 10 months ago

Les 'modes' configurés en 2.7 n'existe plus en 2.8 (ref #31353)

Revision c1483618 (diff)
Added by Emmanuel GARETTE 10 months ago

Les 'modes' configurés en 2.7 n'existe plus en 2.8 (ref #31353)

History

#2 Updated by Emmanuel GARETTE 10 months ago

  • Status changed from Nouveau to En cours

#3 Updated by Emmanuel GARETTE 10 months ago

  • Assigned To set to Emmanuel GARETTE

#4 Updated by Emmanuel GARETTE 10 months ago

  • % Done changed from 0 to 100

#5 Updated by Emmanuel GARETTE 10 months ago

  • Status changed from En cours to Résolu

#6 Updated by Joël Cuissinat 9 months ago

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 Updated by Joël Cuissinat 9 months ago

  • Status changed from Résolu to Fermé
  • Remaining (hours) set to 0.0

Also available in: Atom PDF