Допустим, мы установили Bitrix Env 9.0.10 через меню выполняем действие по переходу с MySQL 8.0 на 8.4 на Bitrix Env 9.0.10
MySQL 8.0 по умолчанию, нам нужна 8.4.
Делаем в меню:
1. Manage servers in the pool
-- 6. Update PHP, MySQL, PostgreSQL
----- Upgrade Mysql
В норме всё проходит хорошо.
Но бывает, операция заканчивается ошибкой. База данных не работает, новая база не встала. Если сервер пустой и новый, то заново переустанавливаем операционную систему и пробуем опять.
Если сервер старый - всё очень плохо. Заново повторить действие невозможно. Вываливаются другие ошибки - нет подключения к базе данных.
Смотрим лог последнего действия, если меню Битрикса выдаёт всякие дурацкие ошибки и действия ломаются.
В логе нужно найти, какие действия выполнялись, на каком произошёл сбой.
cd /opt/webdir/
ls -al
cd последняя_задача
cat status
PLAY [bitrix-hosts] ************************************************************
TASK [Gathering Facts] *********************************************************
ok: [srv01.mysite.ru]
TASK [mysql : include_tasks] ***************************************************
included: /etc/ansible/inc_vars.yml for srv01.mysite.ru
TASK [mysql : include variables fr om mysql group] ******************************
ok: [srv01.mysite.ru]
TASK [mysql : include variables from postgresql group] *************************
ok: [srv01.mysite.ru]
TASK [mysql : include variables from web group] ********************************
ok: [srv01.mysite.ru]
TASK [mysql : include variables from temporary config] *************************
ok: [srv01.mysite.ru]
TASK [mysql : additional gathering facts] **************************************
ok: [srv01.mysite.ru]
TASK [mysql : include_tasks] ***************************************************
skipping: [srv01.mysite.ru]
TASK [mysql : include_tasks] ***************************************************
skipping: [srv01.mysite.ru]
TASK [mysql : include_tasks] ***************************************************
skipping: [srv01.mysite.ru]
TASK [mysql : include_tasks] ***************************************************
skipping: [srv01.mysite.ru]
TASK [mysql : include_tasks] ***************************************************
skipping: [srv01.mysite.ru]
TASK [mysql : include_tasks] ***************************************************
skipping: [srv01.mysite.ru]
TASK [mysql : include_tasks] ***************************************************
skipping: [srv01.mysite.ru]
TASK [mysql : include_tasks] ***************************************************
skipping: [srv01.mysite.ru]
TASK [mysql : include_tasks] ***************************************************
skipping: [srv01.mysite.ru]
TASK [mysql : set_fact] ********************************************************
skipping: [srv01.mysite.ru]
TASK [mysql : include_tasks] ***************************************************
skipping: [srv01.mysite.ru]
TASK [mysql : include_tasks] ***************************************************
skipping: [srv01.mysite.ru]
TASK [mysql : include_tasks] ***************************************************
included: /etc/ansible/roles/mysql/tasks/upgrade_mysql_from80_to84.yml for srv01.mysite.ru
TASK [mysql : update system] ***************************************************
ok: [srv01.mysite.ru]
TASK [mysql : touch my.cnf before commit] **************************************
changed: [srv01.mysite.ru]
TASK [mysql : include_tasks] ***************************************************
included: /etc/ansible/roles/mysql/tasks/common-etckeeper.yml for srv01.mysite.ru
TASK [mysql : wait for absent lockfile] ****************************************
skipping: [srv01.mysite.ru]
TASK [mysql : create lockfile] *************************************************
skipping: [srv01.mysite.ru]
TASK [mysql : create time mark] ************************************************
skipping: [srv01.mysite.ru]
TASK [mysql : create touch file] ***********************************************
skipping: [srv01.mysite.ru]
TASK [mysql : check if directores in /etc contains uncommitted changes] ********
skipping: [srv01.mysite.ru]
TASK [mysql : commit changes by etckeeper] *************************************
skipping: [srv01.mysite.ru]
TASK [mysql : delete touch file] ***********************************************
skipping: [srv01.mysite.ru]
TASK [mysql : delete lockfile] *************************************************
skipping: [srv01.mysite.ru]
TASK [mysql : clear packagelist lockfile] **************************************
changed: [srv01.mysite.ru]
TASK [mysql : wait for absent lockfile] ****************************************
ok: [srv01.mysite.ru]
TASK [mysql : create lockfile] *************************************************
changed: [srv01.mysite.ru]
TASK [mysql : count commit date] ***********************************************
changed: [srv01.mysite.ru]
TASK [mysql : commit changes by etckeeper] *************************************
changed: [srv01.mysite.ru]
TASK [mysql : delete lockfile] *************************************************
changed: [srv01.mysite.ru]
TASK [mysql : include_tasks] ***************************************************
included: /etc/ansible/roles/mysql/tasks/sites-gathering_facts-not_mandatory.yml for srv01.mysite.ru
TASK [mysql : set_fact] ********************************************************
ok: [srv01.mysite.ru]
TASK [mysql : gathering facts about installed sites] ***************************
changed: [srv01.mysite.ru]
TASK [mysql : set_fact] ********************************************************
ok: [srv01.mysite.ru]
TASK [mysql : create variable bx_sites_info] ***********************************
ok: [srv01.mysite.ru]
TASK [mysql : include_tasks] ***************************************************
included: /etc/ansible/roles/mysql/tasks/backup_dbs.yml for srv01.mysite.ru
TASK [mysql : backup folders] **************************************************
changed: [srv01.mysite.ru] => (item=/home/bitrix/backup)
changed: [srv01.mysite.ru] => (item=/home/bitrix/backup/mysql)
TASK [mysql : create backup of MySQL databases only] ***************************
changed: [srv01.mysite.ru] => (item={'HTTPSConf': '/etc/nginx/bx/conf/ssl.conf', 'nginx_custom_settings': 'on', 'BackupWeekDay': '', 'BackupCronFile': '', 'SiteCharset': 'utf8mb4', 'NginxHTTPEDir': '/etc/nginx/bx/site_enabled', 'SiteKernelDir': '', 'SphinxConnection': '', 'BackupMonth': '', 'BackupTask': 'disable', 'DocumentRoot': '/home/bitrix/www', 'SiteInstall': 'kernel', 'DBConn': 'Y', 'CronFile': '/etc/crontab', 'CompositeStatus': 'disable', 'CompositeDomains': [], 'dbconn_BX_TEMPORARY_FILES_DIRECTORY': '/home/bitrix/.bx_temp/sitemanager/', 'module_scale': 'not_installed', 'SMTPTLS': 'off', 'ApacheConf': '/etc/httpd/bx/conf/default.conf', 'CompositeMemcachedHost': '', 'CompositeMemcachedPort': '', 'DBPassword': '***************', 'CompositeIncludeUri': [], 'NginxPort': 80, 'CompositeExcludeParams': [], 'HTTPS': 'disable', 'CompositeStorage': '', 'BackupHour': '', 'SphinxIndexName': '', 'error': 0, 'BackupVersion': '', 'DBName': 'sitemanager', 'SiteCsync2': 'default', 'nginx_bx_temp_files': 'on', 'NTLM_use_ntlm': 'N', 'HTTPSCertType': 'general', 'ApacheConfNTLM': '', 'phpMsmtpAccount': 'default', 'SiteName': 'default', 'CronTask': 'enable', 'SiteShort': 'default', 'CompositeNginxID': '02', 'HTTPSCertChain': '', 'ModuleCluster': '', 'config_file': 'dbconn', 'phpUploadDir': '/tmp/php_upload/www', 'CronService': {}, 'module_cluster': 'not_installed', 'ApacheConfScale': '/etc/httpd/bx-scale/conf/default.conf', 'SiteKernelDB': '', 'phpSessionDir': '/tmp/php_sessions/www', 'CompositeError': '', 'EmailAddress': None, 'HTTPSCert': '/etc/nginx/ssl/cert.pem', 'module_transformer': 'not_installed', 'DBHost': 'localhost', 'SMTPHost': None, 'SMTPPort': None, 'DBLogin': 'bitrix0', 'BackupFolder': '', 'proxy_ignore_client_abort': 'off', 'EmailAccount': None, 'CompositeNginx': 'disable', 'HTTPSPriv': '/etc/nginx/ssl/cert.pem', 'ServerName': 'srv01.mysite.ru', 'nginx_custom_settings_directory': '/etc/nginx/bx/site_settings/default', 'message': '', 'NTLM_bitrixvm_auth_support': 'N', 'SMTPUser': None, 'NginxType': 'single', 'BackupMinute': '', 'nginx_bx_temp_config': '/etc/nginx/bx/site_settings/default/bx_temp.conf', 'NginxHTTPDir': '/etc/nginx/bx/site_avaliable', 'NginxHTTPSConfig': 'ssl.s1.conf', 'CompositeNginxMap': '', 'ModuleScale': '', 'SiteStatus': 'not_installed', 'NginxHTTPSFullPath': '/etc/nginx/bx/site_avaliable/ssl.s1.conf', 'module_transformercontroller': 'not_installed', 'DBType': 'mysql', 'NginxHTTPConfig': 's1.conf', 'SMTPPassword': '***************', 'CompositeExcludeUri': [], 'BackupDay': ''})
TASK [mysql : include_tasks] ***************************************************
included: /etc/ansible/roles/mysql/tasks/shutdown_mysqld.yml for srv01.mysite.ru
TASK [mysql : configure mysql shutdown] ****************************************
changed: [srv01.mysite.ru]
TASK [mysql : shutdown mysql on CentOS6] ***************************************
skipping: [srv01.mysite.ru]
TASK [mysql : shutdown mysql on CentOS7] ***************************************
skipping: [srv01.mysite.ru]
TASK [mysql : shutdown mysql] **************************************************
changed: [srv01.mysite.ru]
TASK [mysql : wait mysql shutdown] *********************************************
ok: [srv01.mysite.ru]
TASK [mysql : Check if initd script exists] ************************************
skipping: [srv01.mysite.ru]
TASK [mysql : Failed when initd file is not exists] ****************************
skipping: [srv01.mysite.ru]
TASK [mysql : try stop it another way if the previous command did not succeed] ***
skipping: [srv01.mysite.ru]
TASK [mysql : delete old packages] *********************************************
changed: [srv01.mysite.ru]
TASK [mysql : disable percona 80 repository] ***********************************
changed: [srv01.mysite.ru]
TASK [mysql : enable percona 84 repository] ************************************
fatal: [srv01.mysite.ru]: FAILED! => {"changed": true, "cmd": "percona-release enable ps-84-lts release", "delta": "0:02:58.493069", "end": "2026-11-10 20:01:16.034839", "msg": "non-zero return code", "rc": 2, "start": "2026-11-10 19:58:17.541770", "stderr": "", "stderr_lines": [], "stdout": "Specified repository is not supported for current operating system!", "stdout_lines": ["Specified repository is not supported for current operating system!"]}
NO MORE HOSTS LEFT *************************************************************
PLAY RECAP *********************************************************************
Что произошло?
Ansible выполнял какие-то действия. Подключил файл
included: /etc/ansible/roles/mysql/tasks/upgrade_mysql_from80_to84.yml
Выполнил бекапы удалил пакеты. Выполнил disable percona 80 repository. Но сломался на enable percona 84 repository
Написал ошибку, которой на самом деле не было "Specified repository is not supported for current operating system!". Проще говоря, по какой-то причине в этот момент времени репозиторий был недоступен и мы не смогли его подключить.
Теперь если через меню виртуальной машины повторно попытаться выполнить переход с 8.0 на 8.4 ничего не выйдет. Сломается на выполнении бекапов потому что MySQL удалена.
Решение - открыть файл /etc/ansible/roles/mysql/tasks/upgrade_mysql_from80_to84.yml и закомментировать действия, которые были до enable percona 84 repository и повторить.
Если percona-release enable ps-84-lts release не срабатывает, то можно повторить из консоли percona-release enable ps-84-lts release. Надо разобраться почему он не может подключиться к репозиторию, и дальше можно продолжать через меню
1. Manage servers in the pool
-- 6. Update PHP, MySQL, PostgreSQL
После завершения можно файл /etc/ansible/roles/mysql/tasks/upgrade_mysql_from80_to84.yml отредактировать обратно. Но мы вряд ли уже когда-нибудь будем понижать MySQL на этом сервере.
Пример файла с комменитариями:
/etc/ansible/roles/mysql/tasks/upgrade_mysql_from80_to84.yml
# mysql_package: "percona-server-server",
# mysql_uni_version: 80
# Комментируем начало
#- name: update system
# dnf:
# name: "*"
# state: latest
#
#- name: touch my.cnf before commit
# shell: "echo '#save mysql config before upgrade' >> /etc/my.cnf"
#
#- include_tasks: common-etckeeper.yml
#
#- include_tasks: sites-gathering_facts-not_mandatory.yml
#
#- include_tasks: backup_dbs.yml
# when: "proccess_sites and inventory_hostname == master_server"
#
#- include_tasks: shutdown_mysqld.yml
#
#- name: delete old packages
# shell: "rpm -qa | grep percona-server | xargs rpm -e --nodeps"
# args:
# removes: /bin/mysql
# ignore_errors: true
#- name: disable percona 80 repository
# shell: percona-release disable ps-80 release
# вот отсюда надо продолжать переход с 8.0 на 8.4, потому что в логе написано, что мы дошли до сюда.
- name: enable percona 84 repository
shell: percona-release enable ps-84-lts release
- name: install percona-server
dnf:
name: percona-server-server
state: latest
- name: gathering facts
bx_vat:
- name: performance options
bx_perf:
state: performance
- name: create additional service config
file:
path: /etc/systemd/system/mysqld.service.d
state: directory
- name: copy service config
copy:
src: mysql-limits.conf
dest: /etc/systemd/system/mysqld.service.d/lim it.conf
- name: reload systmd configuration
shell: systemctl daemon-reload
- name: remove my.cnf.rpmsave file
file:
path: /etc/my.cnf.rpmsave
state: absent
- name: restore my.cnf
template:
src: my84.cnf.j2
dest: /etc/my.cnf
mode: 0644
owner: root
group: mysql
- name: restore bvat.cnf
template:
src: bvat/bx_perf-bvat84.cnf.j2
dest: /etc/mysql/conf.d/bvat.cnf
mode: 0644
owner: root
group: mysql
- name: start mysql service
service:
name: mysql
state: started
enabled: yes
- name: update system
dnf:
name: "*"
state: latest