LINUX.ORG.RU

Не запускается MySql

 


0

1

Всем привет.

Сегодня по непонятным причинам упал MySQL и не хочет запускаться.

#journalctl -xe

Oct 30 09:58:50 bx sshd[8601]: reverse mapping checking getaddrinfo for drone.xulepth.fr [46.105.124.52] fa
Oct 30 09:58:50 bx sshd[8601]: pam_unix(sshd:auth): authentication failure; logname= uid=0 euid=0 tty=ssh r
Oct 30 09:58:50 bx sshd[8601]: pam_succeed_if(sshd:auth): requirement "uid >= 1000" not met by user "root"
Oct 30 09:58:51 bx mysqld[8573]: Unable to determine if daemon is running: Success
Oct 30 09:58:51 bx systemd[1]: mysqld.service: control process exited, code=exited status=1
Oct 30 09:58:51 bx 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.
Oct 30 09:58:51 bx systemd[1]: Unit mysqld.service entered failed state.
Oct 30 09:58:51 bx systemd[1]: mysqld.service failed.
Oct 30 09:58:51 bx systemd[1]: mysqld.service holdoff time over, scheduling restart.
Oct 30 09:58:51 bx systemd[1]: Stopped MySQL Server.

подскажите пжл, куда копать ((

ну так лог mysql глянь что пишет

Anoxemian ★★★★★
()

подскажите пжл, куда копать ((

Посмотри логи, например. Если ничего там не поймешь - покажи нам.

Zhbert ★★★★★
()
Ответ на: комментарий от Zhbert

При попытке перезапуска mysqld в error-лог летит следующее: ``` 3Z 0 [Note] InnoDB: Page size:1024. Pages to analyze:64 2019-10-30T15:19:31.956467Z 0 [Note] InnoDB: Page size: 1024. Possible space_id count:0 2019-10-30T15:19:31.956474Z 0 [Note] InnoDB: Page size:2048. Pages to analyze:56 2019-10-30T15:19:31.956586Z 0 [Note] InnoDB: Page size: 2048. Possible space_id count:0 2019-10-30T15:19:31.956596Z 0 [Note] InnoDB: Page size:4096. Pages to analyze:28 2019-10-30T15:19:31.956718Z 0 [Note] InnoDB: Page size: 4096. Possible space_id count:0 2019-10-30T15:19:31.956726Z 0 [Note] InnoDB: Page size:8192. Pages to analyze:14 2019-10-30T15:19:31.956804Z 0 [Note] InnoDB: Page size: 8192. Possible space_id count:0 2019-10-30T15:19:31.956808Z 0 [Note] InnoDB: Page size:16384. Pages to analyze:7 2019-10-30T15:19:31.956833Z 0 [Note] InnoDB: VALID: space:1485 page_no:0 page_size:16384 2019-10-30T15:19:31.956922Z 0 [Note] InnoDB: VALID: space:20650 page_no:4 page_size:16384 2019-10-30T15:19:31.956971Z 0 [Note] InnoDB: Page size: 16384. Possible space_id count:2 2019-10-30T15:19:31.956975Z 0 [Note] InnoDB: space_id:1485, Number of pages matched: 1/2 (16384) 2019-10-30T15:19:31.956980Z 0 [Note] InnoDB: space_id:20650, Number of pages matched: 1/2 (16384) 2019-10-30T15:19:31.956984Z 0 [Note] InnoDB: space_id:1485, Number of pages matched: 1/2 (16384) 2019-10-30T15:19:31.956988Z 0 [Note] InnoDB: Chosen space:1485 2019-10-30T15:19:31.956999Z 0 [ERROR] InnoDB: Corrupted page [page id: space=1485, page number=0] of datafile './body_db/b_iblock_14_index_val.ibd' could not be found in the doublewrite buffer. 2019-10-30T15:19:31.964201Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 145920281328 2019-10-30T15:19:31.965830Z 0 [Note] InnoDB: Database was not shutdown normally! 2019-10-30T15:19:31.965840Z 0 [Note] InnoDB: Starting crash recovery. 2019-10-30T15:19:31.967281Z 0 [ERROR] InnoDB: Tablespace 20650 was not found at ./body_db/b_iblock_14_index_val.ibd. 2019-10-30T15:19:31.967305Z 0 [ERROR] InnoDB: Set innodb_force_recovery=1 to ignore this and to permanently lose all changes to the tablespace. 2019-10-30T15:19:31.973899Z 0 [ERROR] InnoDB: Cannot continue operation. 2019-10-30T15:19:38.389073Z 0 [Warning] Changed limits: max_open_files: 5000 (requested 16246) 2019-10-30T15:19:38.389363Z 0 [Warning] Changed limits: table_open_cache: 2473 (requested 8096) 2019-10-30T15:19:38.573732Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set. 2019-10-30T15:19:38.575082Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.25-28) starting as process 10488 ... 2019-10-30T15:19:38.582358Z 0 [Note] InnoDB: PUNCH HOLE support available 2019-10-30T15:19:38.582401Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-10-30T15:19:38.582409Z 0 [Note] InnoDB: Uses event mutexes 2019-10-30T15:19:38.582415Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2019-10-30T15:19:38.582444Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.7 2019-10-30T15:19:38.582454Z 0 [Note] InnoDB: Using Linux native AIO 2019-10-30T15:19:38.582780Z 0 [Note] InnoDB: Number of pools: 1 2019-10-30T15:19:38.582934Z 0 [Note] InnoDB: Using CPU crc32 instructions 2019-10-30T15:19:38.587980Z 0 [Note] InnoDB: Initializing buffer pool, total size = 1G, instances = 8, chunk size = 128M 2019-10-30T15:19:38.628198Z 0 [Note] InnoDB: Completed initialization of buffer pool 2019-10-30T15:19:38.639889Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2019-10-30T15:19:38.672528Z 0 [Note] InnoDB: Recovering partial pages from the parallel doublewrite buffer at /var/lib/mysql/xb_doublewrite 2019-10-30T15:19:38.772245Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2019-10-30T15:19:38.778755Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 145920040289 2019-10-30T15:19:38.779298Z 0 [ERROR] InnoDB: Space ID in fsp header is 858908, but in the page header it is 1485. 2019-10-30T15:19:38.779323Z 0 [ERROR] InnoDB: Header page contains inconsistent data in datafile: ./body_db/b_iblock_14_index_val.ibd, Space ID:18446744073709551615, Flags: 3342336. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue. 2019-10-30T15:19:38.779361Z 0 [Note] InnoDB: Page size:1024. Pages to analyze:64 2019-10-30T15:19:38.779543Z 0 [Note] InnoDB: Page size: 1024. Possible space_id count:0 2019-10-30T15:19:38.779556Z 0 [Note] InnoDB: Page size:2048. Pages to analyze:56 2019-10-30T15:19:38.779739Z 0 [Note] InnoDB: Page size: 2048. Possible space_id count:0 2019-10-30T15:19:38.779747Z 0 [Note] InnoDB: Page size:4096. Pages to analyze:28 2019-10-30T15:19:38.779892Z 0 [Note] InnoDB: Page size: 4096. Possible space_id count:0 2019-10-30T15:19:38.779899Z 0 [Note] InnoDB: Page size:8192. Pages to analyze:14 2019-10-30T15:19:38.780031Z 0 [Note] InnoDB: Page size: 8192. Possible space_id count:0 2019-10-30T15:19:38.780039Z 0 [Note] InnoDB: Page size:16384. Pages to analyze:7 2019-10-30T15:19:38.780071Z 0 [Note] InnoDB: VALID: space:1485 page_no:0 page_size:16384 2019-10-30T15:19:38.780248Z 0 [Note] InnoDB: VALID: space:20650 page_no:4 page_size:16384 2019-10-30T15:19:38.780342Z 0 [Note] InnoDB: Page size: 16384. Possible space_id count:2 2019-10-30T15:19:38.780351Z 0 [Note] InnoDB: space_id:1485, Number of pages matched: 1/2 (16384) 2019-10-30T15:19:38.780366Z 0 [Note] InnoDB: space_id:20650, Number of pages matched: 1/2 (16384) 2019-10-30T15:19:38.780374Z 0 [Note] InnoDB: space_id:1485, Number of pages matched: 1/2 (16384) 2019-10-30T15:19:38.780381Z 0 [Note] InnoDB: Chosen space:1485 2019-10-30T15:19:38.780413Z 0 [ERROR] InnoDB: Corrupted page [page id: space=1485, page number=0] of datafile './body_db/b_iblock_14_index_val.ibd' could not be found in the doublewrite buffer. 2019-10-30T15:19:38.780925Z 0 [ERROR] InnoDB: Space ID in fsp header is 858908, but in the page header it is 1485. 2019-10-30T15:19:38.780941Z 0 [ERROR] InnoDB: Header page contains inconsistent data in datafile: ./body_db/b_iblock_14_index_val.ibd, Space ID:18446744073709551615, Flags: 3342336. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue. 2019-10-30T15:19:38.78097 ```

stranger-ru
() автор топика
Ответ на: комментарий от stranger-ru

Оформи, пожалуйста, в формате LORCODE (ссылка есть чуть ниже формы ввода текста сообщения), тогда твой лог будет более читабельным.

Zhbert ★★★★★
()
Ответ на: комментарий от Zhbert

Вот выдержка из конца лога (+убрал часть Note):

2019-10-30T16:18:45.384883Z 0 [Note] InnoDB: space_id:1485, Number of pages matched: 1/2 (16384)
2019-10-30T16:18:45.384890Z 0 [Note] InnoDB: Chosen space:1485
2019-10-30T16:18:45.384925Z 0 [ERROR] InnoDB: Corrupted page [page id: space=1485, page number=0] of datafile './body_db/b_iblock_14_index_val.ibd' could not be found in the doublewrite buffer.
2019-10-30T16:18:45.385511Z 0 [ERROR] InnoDB: Space ID in fsp header is 858908, but in the page header it is 1485.
2019-10-30T16:18:45.385542Z 0 [ERROR] InnoDB: Header page contains inconsistent data in datafile: ./body_db/b_iblock_14_index_val.ibd, Space ID:18446744073709551615, Flags: 3342336. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2019-10-30T16:18:45.385570Z 0 [Note] InnoDB: Page size:1024. Pages to analyze:64
2019-10-30T16:18:45.386535Z 0 [Note] InnoDB: Chosen space:1485
2019-10-30T16:18:45.386552Z 0 [ERROR] InnoDB: Corrupted page [page id: space=1485, page number=0] of datafile './body_db/b_iblock_14_index_val.ibd' could not be found in the doublewrite buffer.
2019-10-30T16:18:45.398934Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 145920281328
2019-10-30T16:18:45.401738Z 0 [Note] InnoDB: Database was not shutdown normally!
2019-10-30T16:18:45.401753Z 0 [Note] InnoDB: Starting crash recovery.
2019-10-30T16:18:45.403312Z 0 [ERROR] InnoDB: Tablespace 20650 was not found at ./body_db/b_iblock_14_index_val.ibd.
2019-10-30T16:18:45.403331Z 0 [ERROR] InnoDB: Set innodb_force_recovery=1 to ignore this and to permanently lose all changes to the tablespace.
2019-10-30T16:18:45.410522Z 0 [ERROR] InnoDB: Cannot continue operation.
2019-10-30T16:18:51.888605Z 0 [Warning] Changed limits: max_open_files: 5000 (requested 16246)
2019-10-30T16:18:51.888886Z 0 [Warning] Changed limits: table_open_cache: 2473 (requested 8096)
2019-10-30T16:18:52.075134Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2019-10-30T16:18:52.077386Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.25-28) starting as process 10321 ...
2019-10-30T16:18:52.085566Z 0 [Note] InnoDB: PUNCH HOLE support available
2019-10-30T16:18:52.085612Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-10-30T16:18:52.085619Z 0 [Note] InnoDB: Uses event mutexes
2019-10-30T16:18:52.085625Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2019-10-30T16:18:52.085638Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.7
2019-10-30T16:18:52.296106Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 145920040289
2019-10-30T16:18:52.296689Z 0 [ERROR] InnoDB: Space ID in fsp header is 858908, but in the page header it is 1485.
2019-10-30T16:18:52.296715Z 0 [ERROR] InnoDB: Header page contains inconsistent data in datafile: ./body_db/b_iblock_14_index_val.ibd, Space ID:18446744073709551615, Flags: 3342336. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2019-10-30T16:18:52.297740Z 0 [Note] InnoDB: space_id:1485, Number of pages matched: 1/2 (16384)
2019-10-30T16:18:52.297746Z 0 [Note] InnoDB: Chosen space:1485
2019-10-30T16:18:52.297784Z 0 [ERROR] InnoDB: Corrupted page [page id: space=1485, page number=0] of datafile './body_db/b_iblock_14_index_val.ibd' could not be found in the doublewrite buffer.
2019-10-30T16:18:52.298330Z 0 [ERROR] InnoDB: Space ID in fsp header is 858908, but in the page header it is 1485.
2019-10-30T16:18:52.298347Z 0 [ERROR] InnoDB: Header page contains inconsistent data in datafile: ./body_db/b_iblock_14_index_val.ibd, Space ID:18446744073709551615, Flags: 3342336. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2019-10-30T16:18:52.298375Z 0 [Note] InnoDB: Page size:1024. Pages to analyze:64
2019-10-30T16:18:52.298535Z 0 [Note] InnoDB: Page size: 1024. Possible space_id count:0
2019-10-30T16:18:52.298552Z 0 [Note] InnoDB: Page size:2048. Pages to analyze:56
2019-10-30T16:18:52.298721Z 0 [Note] InnoDB: Page size: 2048. Possible space_id count:0
2019-10-30T16:18:52.309544Z 0 [Note] InnoDB: Starting crash recovery.
2019-10-30T16:18:52.311023Z 0 [ERROR] InnoDB: Tablespace 20650 was not found at ./body_db/b_iblock_14_index_val.ibd.
2019-10-30T16:18:52.311040Z 0 [ERROR] InnoDB: Set innodb_force_recovery=1 to ignore this and to permanently lose all changes to the tablespace.
2019-10-30T16:18:52.317795Z 0 [ERROR] InnoDB: Cannot continue operation.
stranger-ru
() автор топика
Ответ на: комментарий от anonymous

причину уже нашел ранее, из-за ночного бекапа системы закончилось физическое место на диске и в это же время видимо были обращения к серверу MySql, после чего он упал.

Спасибо за подсказку насчет конца лога, чего-то сразу и не посмотрел в конец.

stranger-ru
() автор топика
Вы не можете добавлять комментарии в эту тему. Тема перемещена в архив.