VMBitrix 9 после обновления MYSQL до 8.4 перестали работать задания из pool, завершаются с ошибкой.
Например создание Сайта из меню 8-> create site задание вываливается с такой ошибкой
Код |
---|
TASK [web : generate missing variables] ****************************************
fatal: [vbox.local]: FAILED! => {"changed": false, "module_stderr": "Use of uninitialized value $val in substitution (s///) at /root/.ansible/tmp/ansible-tmp-1758196249.141627-7189-49881519098560/AnsiballZ_bx_generate_site_vars line 223, <$fh> line 1.\nUse of uninitialized value $val in substitution (s///) at /root/.ansible/tmp/ansible-tmp-1758196249.141627-7189-49881519098560/AnsiballZ_bx_generate_site_vars line 224, <$fh> line 1.\nUse of uninitialized value $val in substitution (s///) at /root/.ansible/tmp/ansible-tmp-1758196249.141627-7189-49881519098560/AnsiballZ_bx_generate_site_vars line 223, <$fh> line 1.\nUse of uninitialized value $val in substitution (s///) at /root/.ansible/tmp/ansible-tmp-1758196249.141627-7189-49881519098560/AnsiballZ_bx_generate_site_vars line 224, <$fh> line 1.\nUse of uninitialized value $val in substitution (s///) at /root/.ansible/tmp/ansible-tmp-1758196249.141627-7189-49881519098560/AnsiballZ_bx_generate_site_vars line 223, <$fh> line 1.\nUse of uninitialized value $val in substitution (s///) at /root/.ansible/tmp/ansible-tmp-1758196249.141627-7189-49881519098560/AnsiballZ_bx_generate_site_vars line 224, <$fh> line 1.\nUse of uninitialized value $val in substitution (s///) at /root/.ansible/tmp/ansible-tmp-1758196249.141627-7189-49881519098560/AnsiballZ_bx_generate_site_vars line 223, <$fh> line 1.\nUse of uninitialized value $val in substitution (s///) at /root/.ansible/tmp/ansible-tmp-1758196249.141627-7189-49881519098560/AnsiballZ_bx_generate_site_vars line 224, <$fh> line 1.\nUse of uninitialized value $val in substitution (s///) at /root/.ansible/tmp/ansible-tmp-1758196249.141627-7189-49881519098560/AnsiballZ_bx_generate_site_vars line 223, <$fh> line 1.\nUse of uninitialized value $val in substitution (s///) at /root/.ansible/tmp/ansible-tmp-1758196249.141627-7189-49881519098560/AnsiballZ_bx_generate_site_vars line 224, <$fh> line 1.\ninstall_driver(mysql) failed: Can't load '/usr/lib64/perl5/vendor_perl/auto/DBD/mysql/mysql.so' for module DBD::mysql: libmysqlclient.so.21: cannot open shared object file: No such file or directory at /usr/lib64/perl5/DynaLoader.pm line 193.\n\u0000 at (eval 315) line 3.\nCompilation failed in require at (eval 315) line 3.\nPerhaps a required shared library or dll isn't installed where expected\n at /opt/webdir/lib/bxSiteFiles.pm line 198.\n", "module_stdout": "", "msg": "MODULE FAILURE\nSee stdout/stderr for the exact error", "rc": 2} |
в самом меню появляется такая строка
Код |
---|
install_driver(mysql) failed: Can't load '/usr/lib64/perl5/vendor_perl/auto/DBD/mysql/mysql.so' for module DBD::mysql: libmysqlclient.so.21: cannot open shared object file: No such file or directory at /usr/lib64/perl5/DynaLoader.pm line 193.
at (eval 315) line 3.
Compilation failed in require at (eval 315) line 3.
Perhaps a required shared library or dll isn't installed where expected
at /opt/webdir/lib/bxSiteFiles.pm line 198.
Not found installed sites in the pool |
Код |
---|
[root@vbox ~]#perl -MDBD::mysql -le'print $DBD::mysql::VERSION'
Can't load '/usr/lib64/perl5/vendor_perl/auto/DBD/mysql/mysql.so' for module DBD::mysql: libmysqlclient.so.21: cannot open shared object file: No such file or directory at /usr/lib64/perl5/DynaLoader.pm line 193.
at -e line 0.
Compilation failed in require.
BEGIN failed--compilation aborted. |
Код |
---|
[root@vbox ~]#ldconfig -p | grep libmysqlclient
libmysqlclient.so.24 (libc6,x86-64) => /usr/lib64/mysql/libmysqlclient.so.24 |
Как я понял не найден файл libmysqlclient.so.21, за место него есть libmysqlclient.so.24
Файл dnf.conf
Код |
---|
[main]
gpgcheck=1
installonly_limit=3
clean_requirements_on_remove=True
best=True
skip_if_unavailable=False
exclude=ansible1.9,mysql,mysql-server,mariadb,mariadb-*,Percona-XtraDB-*,Percona-*-55,Percona-*-56,Percona-*-51,Percona-*-50,Percona-Server-server-57-*,perl-DBD-MySQL |
Обновил, прошло без ошибок, сервер ребутнул
Код |
---|
[root@vbox ~]#dnf clean all && dnf update
[root@vbox ~]#rm -f /opt/webdir/tmp/*
[root@vbox ~]#reboot
|
В меню Manage sites in the pool исчезли все сайты (Not found installed sites in the pool)
как исправить?
На самих сайтах это никак не сказывается, работают без ошибок
Виртуальная машина VMBitrix обновлена до версии 9.0.7
php 8.4.12
mysql 8.4.6-6
perl 5.32.1