Форум Сайтостроение Администрирование серверов

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

S
На сайте с 17.03.2010
Offline
89
Shaltick
1037

Доброй ночи.

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

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.

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

Продажа сайтов и доменов до 120 штук по ссылке (http://www.maultalk.com/go.php?https://docs.google.com/spreadsheets/d/1qkYMebkFzIBTiFsKAnpCfJ1yJB3ikuXCVOnf3Bd16jI/edit#gid=1854191803)
Evas EvaSystems
На сайте с 31.05.2012
Offline
104
Evas EvaSystems
#1

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

Системный администратор Linux. Настройка, сопровождение и оптимизация серверов. Отзывы - searchengines.guru/ru/forum/1017473
S
На сайте с 17.03.2010
Offline
89
Shaltick
#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
104
Evas EvaSystems
#3

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

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

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

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

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

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

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

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