Лег MySQL на сервере ребут не помогат.

S
На сайте с 17.03.2010
Offline
89
841

Доброй ночи.

После перезагрузки сервера:

Ubuntu 16.04 + ISPmanager 5

не стартует MySQL

При заходе в Базы данных в ИСПманагере выдает ошибку

"Не удалось подключиться к базе данных '' Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)"

Перезапуск службы и сервера проблему не решает!

Вот такой лог:

Starting MySQL Community Server...

mysql.service: Main process exited, code=exited, status=1/FAILURE
(root) CMD (/usr/local/mgr5/sbin/cron-ispmgr sbin/mgrctl -m ispmgr problems.autosolve >/dev/null 2>&1)
(root) CMD (/usr/local/mgr5/sbin/cron-core sbin/mgrctl -m core sysinfostat >/dev/null 2>&1)
(root) CMD (/usr/local/mgr5/sbin/cron-core sbin/mgrctl -m core problems.autosolve >/dev/null 2>&1)
(root) CMD (/usr/local/mgr5/sbin/cron-ispmgr sbin/mgrctl -m ispmgr periodic >/dev/null 2>&1)
Failed to start MySQL Community Server.
mysql.service: Unit entered failed state.
mysql.service: Failed with result 'exit-code'.
mysql.service: Service hold-off time over, scheduling restart.
Stopped MySQL Community Server.

Есть варианты в какую сторону "бежать" - решать вопрос?

Evas EvaSystems
На сайте с 31.05.2012
Offline
83
#1

Что в логе ошибок самого mysql?

Системный администратор Linux. Настройка, сопровождение и оптимизация серверов. Отзывы - searchengines.guru/ru/forum/1017473
S
На сайте с 17.03.2010
Offline
89
#2

2019-02-15T22:03:10.169308Z 0 [Note] Shutting down plugin 'ngram'

2019-02-15T22:03:10.169340Z 0 [Note] Shutting down plugin 'partition'
2019-02-15T22:03:10.169357Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2019-02-15T22:03:10.169374Z 0 [Note] Shutting down plugin 'ARCHIVE'
2019-02-15T22:03:10.169391Z 0 [Note] Shutting down plugin 'MEMORY'
2019-02-15T22:03:10.169419Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2019-02-15T22:03:10.169438Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2019-02-15T22:03:10.169454Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2019-02-15T22:03:10.169470Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2019-02-15T22:03:10.169486Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2019-02-15T22:03:10.169501Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2019-02-15T22:03:10.169516Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2019-02-15T22:03:10.169532Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2019-02-15T22:03:10.169634Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2019-02-15T22:03:10.169684Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2019-02-15T22:03:10.169703Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2019-02-15T22:03:10.169719Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2019-02-15T22:03:10.169734Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2019-02-15T22:03:10.169750Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2019-02-15T22:03:10.169765Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2019-02-15T22:03:10.169781Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2019-02-15T22:03:10.169797Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2019-02-15T22:03:10.169812Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2019-02-15T22:03:10.169827Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2019-02-15T22:03:10.169842Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2019-02-15T22:03:10.169858Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2019-02-15T22:03:10.169871Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2019-02-15T22:03:10.169881Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2019-02-15T22:03:10.169891Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2019-02-15T22:03:10.169901Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2019-02-15T22:03:10.169911Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2019-02-15T22:03:10.169921Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2019-02-15T22:03:10.169936Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2019-02-15T22:03:10.169952Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2019-02-15T22:03:10.169967Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2019-02-15T22:03:10.169982Z 0 [Note] Shutting down plugin 'InnoDB'
2019-02-15T22:03:10.170507Z 0 [Note] InnoDB: FTS optimize thread exiting.
2019-02-15T22:03:10.170826Z 0 [Note] InnoDB: Starting shutdown...
2019-02-15T22:03:10.273226Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2019-02-15T22:03:10.280604Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 190216 1:03:10
2019-02-15T22:03:11.815765Z 0 [Note] InnoDB: Shutdown completed; log sequence number 84704633459
2019-02-15T22:03:11.820084Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-02-15T22:03:11.820140Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2019-02-15T22:03:11.820171Z 0 [Note] Shutting down plugin 'MyISAM'
2019-02-15T22:03:11.820256Z 0 [Note] Shutting down plugin 'CSV'
2019-02-15T22:03:11.820281Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2019-02-15T22:03:11.820435Z 0 [Note] Shutting down plugin '*****_password'
2019-02-15T22:03:11.820454Z 0 [Note] Shutting down plugin 'mysql_native_password'
2019-02-15T22:03:11.820698Z 0 [Note] Shutting down plugin 'binlog'
2019-02-15T22:03:11.821367Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

а вот вывод команды проверки статуса

root@vd:~# systemctl status mysql.service                                                                                                                      

* mysql.service - MySQL Community Server
Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
Drop-In: /etc/systemd/system/mysql.service.d
`-nofile.conf
Active: activating (start-post) (Result: exit-code) since Sat 2019-02-16 01:05:11 MSK; 9s ago
Process: 25292 ExecStart=/usr/sbin/mysqld (code=exited, status=1/FAILURE)
Process: 25282 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS)
Main PID: 25292 (code=exited, status=1/FAILURE); : 25293 (mysql-systemd-s)
CGroup: /system.slice/mysql.service
`-control
|-25293 /bin/bash /usr/share/mysql/mysql-systemd-start post
`-25379 sleep 1

Feb 16 01:05:11 vd systemd[1]: Starting MySQL Community Server...
Feb 16 01:05:15 vd systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE
Evas EvaSystems
На сайте с 31.05.2012
Offline
83
#3

Это полный лог? Больше там ничего нет? Вначале до того как пошел Shutting down плагинов

S
На сайте с 17.03.2010
Offline
89
#4
Evas:
Это полный лог? Больше там ничего нет? Вначале до того как пошел Shutting down плагинов

Фух решили! СПС огромное ;-)

Проблема в этом:

2019-02-15T22:02:09.399348Z 0 [ERROR] unknown variable 'table_cache=128'

Evas EvaSystems
На сайте с 31.05.2012
Offline
83
#5
Shaltick:
Фух решили! СПС огромное ;-)
Проблема в этом:
2019-02-15T22:02:09.399348Z 0 [ERROR] unknown variable 'table_cache=128'

На здоровье :)

Авторизуйтесь или зарегистрируйтесь, чтобы оставить комментарий