Не запускается MySQL (но не из-за места)
Добрый день господа! Помогите разобраться:
У нас vmbitrix последней сборки.
С утра после перезагрузки портал не может запустить Mysql:
Прошли по ранее уже известным нам граблям и:
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
| Цитата |
|---|
| Андрей Николаев написал: а в логах мускуля что? (стандартно в /var/lib/mysql/* лежит) |
Логов с расширением .err не удалось найти. А эти не удалось прочитать
| Цитата |
|---|
| Андрей Николаев написал: Надежда Неверова , а в логах мускуля что? (стандартно в /var/lib/mysql/* лежит) |
Нашла лог по этому пути: /var/log/mysql/error.log
вот последние строки
2019-01-29T09:56:12.246197Z 0 [Note] Binlog end
2019-01-29T09:56:12.246366Z 0 [Note] Shutting down plugin ‘MyISAM’
2019-01-29T09:56:12.247399Z 0 [Note] /usr/sbin/mysqld: Shutdown complete
2019-01-29T09:56:12.691254Z 0 [Warning] Changed limits: max_open_files: 5000 (requested 20540)
2019-01-29T09:56:12.691846Z 0 [Warning] Changed limits: table_open_cache: 2470 (requested 10240)
2019-01-29T09:56:12.884721Z 0 [Warning] ‘NO_AUTO_CREATE_USER’ sql mode was not set.
2019-01-29T09:56:12.887056Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.21-21) starting as process 20629 .
2019-01-29T09:56:12.898120Z 0 [Note] InnoDB: PUNCH HOLE support available
2019-01-29T09:56:12.898185Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-01-29T09:56:12.898194Z 0 [Note] InnoDB: Uses event mutexes
2019-01-29T09:56:12.898201Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2019-01-29T09:56:12.898208Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.7
2019-01-29T09:56:12.898214Z 0 [Note] InnoDB: Using Linux native AIO
2019-01-29T09:56:12.898634Z 0 [Note] InnoDB: Number of pools: 1
2019-01-29T09:56:12.898825Z 0 [Note] InnoDB: Using CPU crc32 instructions
2019-01-29T09:56:12.901505Z 0 [Note] InnoDB: Initializing buffer pool, total size = 2G, instances = 8, chunk size = 128M
2019-01-29T09:56:12.970670Z 0 [Note] InnoDB: Completed initialization of buffer pool
2019-01-29T09:56:12.987082Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2019-01-29T09:56:13.001283Z 0 [Note] InnoDB: Recovering partial pages from the parallel doublewrite buffer at /var/lib/mysql/xb_doublewrite
2019-01-29T09:56:13.023369Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2019-01-29T09:56:13.036056Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 2142290997
2019-01-29T09:56:13.036131Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 2142315008
2019-01-29T09:56:13.037015Z 0 [ERROR] InnoDB: Ignoring the redo log due to missing MLOG_CHECKPOINT between the checkpoint 2142290997 and the end 2142315008.
2019-01-29T09:56:13.037570Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2019-01-29T09:56:18.218481Z 0 [ERROR] Plugin ‘InnoDB’ init function returned error.
2019-01-29T09:56:18.218547Z 0 [ERROR] Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed.
2019-01-29T09:56:18.218562Z 0 [ERROR] Failed to initialize builtin plugins.
2019-01-29T09:56:18.218571Z 0 [ERROR] Aborting
2019-01-29T09:56:18.218635Z 0 [Note] Binlog end
2019-01-29T09:56:18.218808Z 0 [Note] Shutting down plugin ‘MyISAM’
2019-01-29T09:56:18.220104Z 0 [Note] /usr/sbin/mysqld: Shutdown complete
2019-01-29T09:56:18.652338Z 0 [Warning] Changed limits: max_open_files: 5000 (requested 20540)
2019-01-29T09:56:18.652933Z 0 [Warning] Changed limits: table_open_cache: 2470 (requested 10240)
2019-01-29T09:56:18.877797Z 0 [Warning] ‘NO_AUTO_CREATE_USER’ sql mode was not set.
2019-01-29T09:56:18.879765Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.21-21) starting as process 20675 .
2019-01-29T09:56:18.891745Z 0 [Note] InnoDB: PUNCH HOLE support available
2019-01-29T09:56:18.891823Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-01-29T09:56:18.891838Z 0 [Note] InnoDB: Uses event mutexes
2019-01-29T09:56:18.891847Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2019-01-29T09:56:18.891854Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.7
2019-01-29T09:56:18.891876Z 0 [Note] InnoDB: Using Linux native AIO
2019-01-29T09:56:18.892368Z 0 [Note] InnoDB: Number of pools: 1
2019-01-29T09:56:18.892592Z 0 [Note] InnoDB: Using CPU crc32 instructions
2019-01-29T09:56:18.895955Z 0 [Note] InnoDB: Initializing buffer pool, total size = 2G, instances = 8, chunk size = 128M
2019-01-29T09:56:18.989038Z 0 [Note] InnoDB: Completed initialization of buffer pool
2019-01-29T09:56:19.021051Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2019-01-29T09:56:19.038813Z 0 [Note] InnoDB: Recovering partial pages from the parallel doublewrite buffer at /var/lib/mysql/xb_doublewrite
2019-01-29T09:56:19.088939Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2019-01-29T09:56:19.113804Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 2142290997
2019-01-29T09:56:19.113894Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 2142315008
2019-01-29T09:56:19.115144Z 0 [ERROR] InnoDB: Ignoring the redo log due to missing MLOG_CHECKPOINT between the checkpoint 2142290997 and the end 2142315008.
2019-01-29T09:56:19.115779Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
Источник
Упал mysql. Нужна помощь
Имеем BitrixVM 7.3.0
На виртуалке закончилось свободное место. В результате сайт стал выдавать такое:
[Bitrix\Main\DB\ConnectionException] Mysql connect error [localhost]: (2002) Connection refused (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:370
#5: Bitrix\Main\HttpRequest->prepareCookie(array)
/home/bitrix/www/bitrix/modules/main/lib/httprequest.php:68
#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/bitrix/modules/main/include/prolog.php:10
#11: require_once(string)
/home/bitrix/www/bitrix/header.php:1
#12: require(string)
/home/bitrix/www/crm/deal/index.php:2
#13: include_once(string)
/home/bitrix/www/bitrix/modules/main/include/urlrewrite.php:159
#14: include_once(string)
/home/bitrix/www/bitrix/urlrewrite.php:2
В консоль доступ есть. Диск расширили, места достаточно.
Но Mysql не стартует.
systemctl status mysql говорит:
● mysqld.service — MySQL Server
Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
Active: activating (start) since Wed 2018-07-25 11:28:59 MSK; 2s ago
Docs: man:mysqld(8)
http://dev.mysql.com/doc/refman/en/using-systemd.html
Process: 18166 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
Control: 18184 (mysqld)
CGroup: /system.slice/mysqld.service
├─18184 /usr/sbin/mysqld —daemonize —pid-file=/var/run/mysqld/mysqld.pid
└─18187 /usr/sbin/mysqld —daemonize —pid-file=/var/run/mysqld/mysqld.pid
Jul 25 11:28:59 bitrix systemd[1]: Starting MySQL Server.
journalctl -xe говорит:
— Unit mysqld.service has failed.
—
Jul 25 11:26:08 bitrix systemd[1]: mysqld.service failed.
Jul 25 11:26:08 bitrix systemd[1]: mysqld.service holdoff time over, scheduling restart.
Jul 25 11:26:08 bitrix 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.
Jul 25 11:26:12 bitrix mysqld[15962]: Unable to determine if daemon is running: Success
Jul 25 11:26:12 bitrix systemd[1]: mysqld.service: control process exited, code=exited status=1
Jul 25 11:26:12 bitrix 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
Подскажите, куда дальше копать?
юрий белов, попробуйте остановить nginx, httpd и запустить: mysql, httpd, nginx.
Либо у Вас памяти нехватает на запуск, либо
