Форум

Собственно суть проблемы, у портала таблица

b_disk_tmp_simple_right

InnoDB

499845680

17.64 ГБ

что это такое?

[QUOTE]Екатерина Шемаева написал:
-- все ли в порядке у Вас в описание хостов (инвентаре) anisible (/etc/ansible/hosts), соответствуют ли имена и IP адреса [/QUOTE]
да все верно


[QUOTE]Екатерина Шемаева написал:
в тексте самого задания:[/QUOTE]
сравнил с машиной где все нормально, текст идентичен

По какой причине может не выполняться задания запущенные из ENV? например вот лог установки memcached

Скрытый текст

PLAY [bitrix-hosts] ************************************************************ TASK [setup] ******************************************************************* ok: [server] TASK [memcached : include variables from mysql group] ************************** ok: [server] TASK [memcached : include variables from web group] **************************** ok: [server] TASK [memcached : include variables from temporary config] ********************* ok: [server] TASK [memcached : include] ***************************************************** TASK [memcached : include] ***************************************************** TASK [memcached : include] ***************************************************** PLAY [bitrix-hosts] ************************************************************ TASK [setup] ******************************************************************* ok: [server] TASK [cleaner : get file list] ************************************************* ok: [server] TASK [cleaner : delete files] ************************************************** changed: [server] => (item={u'uid': 0, u'woth': False, u'mtime': 1541669053.0549407, u'inode': 1318067, u'isgid': False, u'size': 1, u'wgrp': False, u'isuid': False, u'isreg': True, u'gid': 0, u'ischr': False, u'wusr': True, u'xoth': False, u'islnk': False, u'nlink': 1, u'issock': False, u'rgrp': True, u'path': u'/opt/webdir/tmp/pool_unused.cache', u'xusr': False, u'atime': 1541669080.0408907, u'isdir': False, u'ctime': 1541669053.0549407, u'isblk': False, u'xgrp': False, u'dev': 64769, u'roth': True, u'isfifo': False, u'mode': u'0644', u'rusr': True}) changed: [server] => (item={u'uid': 0, u'woth': False, u'mtime': 1541669053.0549407, u'inode': 1318063, u'isgid': False, u'size': 135, u'wgrp': False, u'isuid': False, u'isreg': True, u'gid': 0, u'ischr': False, u'wusr': True, u'xoth': False, u'islnk': False, u'nlink': 1, u'issock': False, u'rgrp': True, u'path': u'/opt/webdir/tmp/pool_servers.cache', u'xusr': False, u'atime': 1541669080.0418909, u'isdir': False, u'ctime': 1541669053.0549407, u'isblk': False, u'xgrp': False, u'dev': 64769, u'roth': True, u'isfifo': False, u'mode': u'0644', u'rusr': True}) ok: [server] => (item={u'uid': 0, u'woth': False, u'mtime': 1541669954.6202652, u'inode': 1320390, u'isgid': False, u'size': 0, u'wgrp': False, u'isuid': False, u'isreg': True, u'gid': 0, u'ischr': False, u'wusr': True, u'xoth': False, u'islnk': False, u'nlink': 1, u'issock': False, u'rgrp': True, u'path': u'/opt/webdir/tmp/bitrix-env_1541669954_1029.pkginfo', u'xusr': False, u'atime': 1541669954.6202652, u'isdir': False, u'ctime': 1541669954.6202652, u'isblk': False, u'xgrp': False, u'dev': 64769, u'roth': True, u'isfifo': False, u'mode': u'0644', u'rusr': True}) PLAY RECAP ********************************************************************* server                      : ok=7    changed=1    unreachable=0    failed=0

В заданиях ENV говорит завершено
memcached_4556763810      | 08/11/2018 12:39          |        finished | play|complete
а по факту
systemctl status memcached
Unit memcached.service could not be found.
вручную устанавливается, но тоже самое и с NodeJS RTC, в заданиях ENV завершено, а по факту ничего не сделано

Скрытый текст

PLAY [bitrix-hosts] ************************************************************ TASK [setup] ******************************************************************* ok: [server] TASK [push-server : include variables from temporary config] ******************* ok: [server] TASK [push-server : additional gathering facts] ******************************** ok: [server] TASK [push-server : include] *************************************************** TASK [push-server : include] *************************************************** TASK [push-server : include] *************************************************** PLAY [bitrix-hosts] ************************************************************ TASK [setup] ******************************************************************* ok: [server] TASK [cleaner : get file list] ************************************************* ok: [server] TASK [cleaner : delete files] ************************************************** changed: [server] => (item={u'uid': 0, u'woth': False, u'mtime': 1541669988.2872026, u'inode': 1318067, u'isgid': False, u'size': 1, u'wgrp': False, u'isuid': False, u'isreg': True, u'gid': 0, u'ischr': False, u'wusr': True, u'xoth': False, u'islnk': False, u'nlink': 1, u'issock': False, u'rgrp': True, u'path': u'/opt/webdir/tmp/pool_unused.cache', u'xusr': False, u'atime': 1541670165.5858722, u'isdir': False, u'ctime': 1541669988.2872026, u'isblk': False, u'xgrp': False, u'dev': 64769, u'roth': True, u'isfifo': False, u'mode': u'0644', u'rusr': True}) changed: [server] => (item={u'uid': 0, u'woth': False, u'mtime': 1541669988.2872026, u'inode': 1318063, u'isgid': False, u'size': 135, u'wgrp': False, u'isuid': False, u'isreg': True, u'gid': 0, u'ischr': False, u'wusr': True, u'xoth': False, u'islnk': False, u'nlink': 1, u'issock': False, u'rgrp': True, u'path': u'/opt/webdir/tmp/pool_servers.cache', u'xusr': False, u'atime': 1541670165.5888722, u'isdir': False, u'ctime': 1541669988.2872026, u'isblk': False, u'xgrp': False, u'dev': 64769, u'roth': True, u'isfifo': False, u'mode': u'0644', u'rusr': True}) changed: [server] => (item={u'uid': 0, u'woth': False, u'mtime': 1541670366.9254959, u'inode': 1310725, u'isgid': False, u'size': 43, u'wgrp': False, u'isuid': False, u'isreg': True, u'gid': 0, u'ischr': False, u'wusr': True, u'xoth': False, u'islnk': False, u'nlink': 1, u'issock': False, u'rgrp': True, u'path': u'/opt/webdir/tmp/push_servers_status.cache', u'xusr': False, u'atime': 1541670371.132488, u'isdir': False, u'ctime': 1541670366.9254959, u'isblk': False, u'xgrp': False, u'dev': 64769, u'roth': True, u'isfifo': False, u'mode': u'0644', u'rusr': True}) PLAY RECAP ********************************************************************* server                      : ok=6    changed=1    unreachable=0    failed=0

выпуск сертификата Let's Encrypt так же не работает
повторный запуск плейбука не дает результата

может ли это быть связано с тем что хостер как то режет ресурсы машины?

[QUOTE]Екатерина Шемаева написал:
почему не рестартовал mysql?[/QUOTE]
похоже нехватало оперативной памяти(512Мб было)
да Ваш способ отработал отлично, повторный запуск обновил до 5.7.23

Скрытый текст

[WARNING]: Consider using yum, dnf or zypper module rather than running rpm **** TASK [setup] ******************************************************************* ok: [local.local] TASK [mysql : include variables fr om mysql group] ****************************** ok: [local.local] TASK [mysql : include variables from web group] ******************************** ok: [local.local] TASK [mysql : include variables from temporary config] ************************* ok: [local.local] TASK [mysql : additional gathering facts] ************************************** ok: [local.local] TASK [mysql : set_fact] ******************************************************** skipping: [local.local] TASK [mysql : gathering facts about installed sites] *************************** skipping: [local.local] TASK [mysql : set_fact] ******************************************************** skipping: [local.local] TASK [mysql : debug] *********************************************************** skipping: [local.local] TASK [mysql : create variable bx_sites_info] *********************************** skipping: [local.local] TASK [mysql : debug] *********************************************************** skipping: [local.local] TASK [mysql : include] ********************************************************* skipping: [local.local] TASK [mysql : include] ********************************************************* skipping: [local.local] TASK [mysql : include] ********************************************************* skipping: [local.local] TASK [mysql : include] ********************************************************* skipping: [local.local] TASK [mysql : include] ********************************************************* skipping: [local.local] TASK [mysql : include] ********************************************************* skipping: [local.local] TASK [mysql : include] ********************************************************* skipping: [local.local] TASK [mysql : include] ********************************************************* skipping: [local.local] TASK [mysql : include] ********************************************************* included: /etc/ansible/roles/mysql/tasks/upgrade_mysql.yml for local.local TASK [mysql : install package] ************************************************* ok: [local.local] TASK [mysql : include] ********************************************************* included: /etc/ansible/roles/mysql/tasks/common-etckeeper.yml for local.local TASK [mysql : create time mark] ************************************************ changed: [local.local] TASK [mysql : create touch file] *********************************************** changed: [local.local] TASK [mysql : check if directores in /etc contains uncommitted changes] ******** changed: [local.local] TASK [mysql : commit changes by etckeeper] ************************************* changed: [local.local] TASK [mysql : delete touch file] *********************************************** changed: [local.local] TASK [mysql : include] ********************************************************* included: /etc/ansible/roles/mysql/tasks/sites-gathering_facts-not_mandatory.yml for local.local TASK [mysql : set_fact] ******************************************************** ok: [local.local] TASK [mysql : gathering facts about installed sites] *************************** changed: [local.local -> None] TASK [mysql : set_fact] ******************************************************** ok: [local.local] TASK [mysql : create variable bx_sites_info] *********************************** ok: [local.local] TASK [mysql : include] ********************************************************* included: /etc/ansible/roles/mysql/tasks/backup_dbs.yml for local.local TASK [mysql : backup folders] ************************************************** changed: [local.local -> None] => (item=/home/bitrix/backup) changed: [local.local -> None] => (item=/home/bitrix/backup/archive) TASK [mysql : create backup] *************************************************** changed: [local.local -> None] => (item={u'CompositeExcludeParams': [], u'CronTask': u'enable', u'NginxPort': 80, u'NginxHTTPSConfig': u'ssl.s1.conf', u'DBType': u'mysql', u'ApacheConfScale': u'/etc/httpd/bx-scale/conf/default.conf', u'ApacheConf': u'/etc/httpd/bx/conf/default.conf', u'DBPassword': u'***************', u'BackupDay': u'', u'module_main_version': u'18.0.9', u'CompositeStatus': u'disable', u'BackupMinute': u'', u'NginxHTTPEDir': u'/etc/nginx/bx/site_enabled', u'CompositeDomains': [], u'SphinxConnection': u'not_found', u'DocumentRoot': u'/home/bitrix/www', u'HTTPSCert': u'/home/bitrix/dehydrated/certs/portal.ru/fullchain.pem', u'message': u'', u'BackupTask': u'disable', u'DBConn': u'Y', u'SiteShort': u'default', u'module_message': u'bxSiteFiles::bx_modules_options: module cluster is not installed on /home/bitrix/www ', u'SiteCsync2': u'default', u'CronFile': u'/etc/crontab', u'module_scale': u'installed', u'SiteName': u'default', u'HTTPSCertChain': u'/home/bitrix/dehydrated/certs/portal.ru/chain.pem', u'proxy_ignore_client_abort': u'off', u'SiteKernelDir': u'', u'CompositeIncludeUri': [], u'CompositeMemcachedPort': u'', u'SiteStatus': u'finished', u'BackupFolder': u'', u'SMTPPort': u'25', u'NTLM_use_ntlm': u'N', u'DBHost': u'localhost', u'SiteInstall': u'kernel', u'NginxHTTPConfig': u's1.conf', u'DBLogin': u'bitrix0', u'BackupMonth': u'', u'phpSessionDir': u'/tmp/php_sessions/www', u'ModuleScale': u'', u'CompositeExcludeUri': [], u'EmailAccount': u'default', u'ServerName': u'local.local', u'error': 0, u'NTLM_module': u'Y', u'SiteCharset': u'utf-8', u'phpUploadDir': u'/tmp/php_upload/www', u'NginxType': u'single', u'HTTPS': u'enable', u'CompositeError': u'', u'HTTPSCertType': u'letsencrypt', u'CompositeMemcachedHost': u'', u'BackupCronFile': u'', u'CompositeNginxID': u'02', u'module_cluster': u'not_installed', u'NginxHTTPSFullPath': u'/etc/nginx/bx/site_avaliable/ssl.s1.conf', u'NTLM_bitrixvm_auth_support': u'N', u'BackupHour': u'', u'SMTPPassword': u'***************', u'SphinxIndexName': u'', u'CompositeNginx': u'disable', u'CompositeStorage': u'', u'SMTPTLS': u'off', u'BackupWeekDay': u'', u'BackupVersion': u'', u'SMTPUser': u'[URL=mailto:info@portal.ru]info@portal.ru[/URL]', u'ModuleCluster': u'', u'EmailAddress': u'info@portal.ru ', u'DBName': u'sitemanager0', u'SMTPHost': u'127.0.0.1', u'HTTPSPriv': u'/home/bitrix/dehydrated/certs/portal.ru/privkey.pem', u'phpMsmtpAccount': u'default', u'CompositeNginxMap': u'', u'SiteKernelDB': u'', u'NginxHTTPDir': u'/etc/nginx/bx/site_avaliable', u'CronService': {}, u'HTTPSConf': u'/etc/nginx/bx/conf/ssl_options.conf'}) TASK [mysql : additional gathering facts] ************************************** ok: [local.local] TASK [mysql : set_fact] ******************************************************** ok: [local.local] TASK [mysql : include] ********************************************************* included: /etc/ansible/roles/mysql/tasks/upgrade_mysql56.yml for local.local TASK [mysql : include] ********************************************************* included: /etc/ansible/roles/mysql/tasks/shutdown_mysqld.yml for local.local TASK [mysql : configure mysql shutdown] **************************************** changed: [local.local] TASK [mysql : shutdown mysql] ************************************************** changed: [local.local] TASK [mysql : wait mysql shutdown] ********************************************* ok: [local.local] TASK [mysql : remove installed mysql] ****************************************** changed: [local.local] TASK [mysql : remove installed mysql] ****************************************** skipping: [local.local] TASK [mysql : clean outdated configs] ****************************************** changed: [local.local] => (item=/etc/systemd/system/mysqld.service) changed: [local.local] => (item=/etc/systemd/system/mysql.service) changed: [local.local] => (item=/etc/systemd/system/mariadb.service.d) TASK [mysql : configure Percona repository] ************************************ changed: [local.local] TASK [mysql : enable Percona repository] *************************************** ok: [local.local] TASK [mysql : install Percona packages] **************************************** changed: [local.local] => (item=[u'Percona-Server-client-56', u'Percona-Server-server-56', u'Percona-Server-shared-56']) TASK [mysql : additional gathering facts] ************************************** ok: [local.local] TASK [mysql : restore my.cnf] ************************************************** changed: [local.local] TASK [mysql : create run directory] ******************************************** ok: [local.local] TASK [mysql : create mysqld service] ******************************************* skipping: [local.local] TASK [mysql : generate mysql private key] ************************************** changed: [local.local] TASK [mysql : generate mysql public key] *************************************** changed: [local.local] TASK [mysql : access rights for mysql keys] ************************************ changed: [local.local] => (item=/var/lib/mysql/private_key.pem) changed: [local.local] => (item=/var/lib/mysql/public_key.pem) TASK [mysql : include] ********************************************************* included: /etc/ansible/roles/mysql/tasks/upgrade_dbs.yml for local.local TASK [mysql : upgrade cnf options] ********************************************* changed: [local.local] TASK [mysql : restarted mysqld] ************************************************ changed: [local.local] TASK [mysql : upgrade DBs] ***************************************************** changed: [local.local] TASK [mysql : remove cnf options] ********************************************** changed: [local.local] TASK [mysql : restarted mysqld] ************************************************ fatal: [local.local]: FAILED! => {"changed": false, "failed": true, "msg": "Unable to restart service mysqld: Job for mysqld.service failed because a timeout was exceeded. See \"systemctl status mysqld.service\" and \"journalctl -xe\" for details.\n"} NO MORE HOSTS LEFT *************************************************************    to retry, use: --lim it @/etc/ansible/mysql.retry PLAY RECAP ********************************************************************* local.local                : ok=44   changed=22   unreachable=0    failed=1

вот весь лог

Было запущено обновление VMBitrix 7.0 до 7.3.3, все прошло успешно, в меню машины(пункт 1) было запущено обновление версии mysql до 5.7, но обновление не прошло до конца, mysql обновился до 5.6.41


fatal: [local]: FAILED! => {"changed": false, "failed": true, "msg": "Unable to restart service mysqld: Job for mysqld.service failed because a timeout was exceeded. See \"systemctl status mysqld.service\" and \"journalctl -xe\" for details.\n"}


я запустил службу вручную и вроде работает, но обновление до 5.7 из меню машины пропало


собственно как запустить обновление еще раз или переустановить mysql что бы дальнейшее обновление через env проходило в обычном режиме?