Добрый день господа! Помогите разобраться:
У нас vmbitrix последней сборки.
С утра после перезагрузки портал не может запустить Mysql:
| Код |
|---|
[Bitrix\Main\DB\ConnectionException] Mysql connect error [localhost]: (2002) No such file or directory (400)
/home/bitrix/www/bitrix/modules/main/lib/db/mysqliconnection.php:65
#0: Bitrix\Main\DB\MysqliConnection->connectInternal()
/home/bitrix/www/bitrix/modules/main/lib/db/mysqliconnection.php:122
#1: Bitrix\Main\DB\MysqliConnection->queryInternal(string, array, NULL)
/home/bitrix/www/bitrix/modules/main/lib/db/connection.php:330
#2: Bitrix\Main\DB\Connection->query(string)
/home/bitrix/www/bitrix/modules/main/lib/config/option.php:226
#3: Bitrix\Main\Config\Option::load(string, NULL)
/home/bitrix/www/bitrix/modules/main/lib/config/option.php:53
#4: Bitrix\Main\Config\Option::get(string, string, string)
/home/bitrix/www/bitrix/modules/main/lib/httprequest.php:382
#5: Bitrix\Main\HttpRequest->prepareCookie(array)
/home/bitrix/www/bitrix/modules/main/lib/httprequest.php:69
#6: Bitrix\Main\HttpRequest->__construct(object, array, array, array, array)
/home/bitrix/www/bitrix/modules/main/lib/httpapplication.php:46
#7: Bitrix\Main\HttpApplication->initializeContext(array)
/home/bitrix/www/bitrix/modules/main/lib/application.php:122
#8: Bitrix\Main\Application->initializeExtendedKernel(array)
/home/bitrix/www/bitrix/modules/main/include.php:23
#9: require_once(string)
/home/bitrix/www/bitrix/modules/main/include/prolog_before.php:14
#10: require_once(string)
/home/bitrix/www/index.php:8 |
Прошли по ранее уже известным нам граблям и:1) Проверили свободное - место, там 2 терабайта, занято 1%.
2) Удалили временные файлы сокетов, рестартнули Mysqld но не помогает.
При рестарте выводит вот это:
Job for mysqld.service failed because the control process exited with error code. See "systemctl status mysqld.service" and "journalctl -xe" for details.Привожу тексты разных команд.
Во-первых:
systemctl status mysqld.service
| Код |
|---|
Б≈▐ mysqld.service - MySQL Server
Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
Active: activating (start) since Tue 2019-01-29 13:35:19 +05; 3s ago
Docs: man:mysqld(
http://dev.mysql.com/doc/refman/en/using-systemd.html
Process: 15469 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
Control: 15486 (mysqld)
CGroup: /system.slice/mysqld.service
Б■°Б■─15486 /usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid
Б■■Б■─15489 /usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid
Jan 29 13:35:19 portal.AAA.ru systemd[1]: mysqld.service holdoff time over, scheduling restart.
Jan 29 13:35:19 portal.AAA.ru systemd[1]: Starting MySQL Server... |
и далее ничего.
кусок ответа по команде
journalctl -xe| Код |
|---|
Jan 29 13:51:03 portal.AAA.ru systemd[1]: Failed to start MySQL Server.
-- Subject: Unit mysqld.service has failed
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mysqld.service has failed.
--
-- The result is failed.
Jan 29 13:51:03 portal.AAA.ru systemd[1]: Unit mysqld.service entered failed state.
Jan 29 13:51:03 portal.AAA.ru systemd[1]: mysqld.service failed.
Jan 29 13:51:03 portal.AAA.ru systemd[1]: mysqld.service holdoff time over, scheduling restart.
Jan 29 13:51:03 portal.AAA.ru systemd[1]: Starting MySQL Server...
-- Subject: Unit mysqld.service has begun start-up
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mysqld.service has begun starting up.
Jan 29 13:51:05 portal.AAA.ru sshd[23368]: Failed password for invalid user liang from 186.67.23.122 port 50365 ssh2
Jan 29 13:51:05 portal.AAA.ru sshd[23368]: Received disconnect from 186.67.23.122 port 50365:11: Bye Bye [preauth]
Jan 29 13:51:05 portal.AAA.ru sshd[23368]: Disconnected from 186.67.23.122 port 50365 [preauth] |
Свободное место
df -h
| Код |
|---|
Filesystem Size Used Avail Use% Mounted on
/dev/sda3 2.0T 19G 1.9T 1% /
devtmpfs 2.8G 0 2.8G 0% /dev
tmpfs 2.8G 0 2.8G 0% /dev/shm
tmpfs 2.8G 17M 2.8G 1% /run
tmpfs 2.8G 0 2.8G 0% /sys/fs/cgroup
/dev/sda1 190M 126M 51M 72% /boot
tmpfs 567M 0 567M 0% /run/user/0 |
ps -AlF | grep mysql после попытки рестарта
| Код |
|---|
4 S mysql 27199 1 0 80 0 - 20527 pipe_w 4980 0 13:58 ? 00:00:00 /usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid
1 S mysql 27203 1 12 80 0 - 729144 hrtime 352948 0 13:58 ? 00:00:00 /usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid
0 S root 27232 4629 0 80 0 - 28176 pipe_w 972 0 13:58 pts/0 00:00:00 grep --color=auto mysql |
Остановка и запуск сервиса не помогает. В чем еще может быть проблема?