Не стартует Mysql

[Fack]

Всем доброго времени.
У меня сегодня крашнулась несколько таблиц одной из БД (InnoDB)
Перезапустил mysql перестал работать.

В логе вот это

Code: Select all

2018-11-29T11:59:58.861947Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-11-29T11:59:58.861987Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2018-11-29T11:59:58.862820Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.24-0ubuntu0.16.04.1) starting as process 18717 ...
2018-11-29T11:59:58.877583Z 0 [Note] InnoDB: PUNCH HOLE support available
2018-11-29T11:59:58.877619Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-11-29T11:59:58.877624Z 0 [Note] InnoDB: Uses event mutexes
2018-11-29T11:59:58.877628Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2018-11-29T11:59:58.877632Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
2018-11-29T11:59:58.877636Z 0 [Note] InnoDB: Using Linux native AIO
2018-11-29T11:59:58.877847Z 0 [Note] InnoDB: Number of pools: 1
2018-11-29T11:59:58.877912Z 0 [Note] InnoDB: Using CPU crc32 instructions
2018-11-29T11:59:58.878852Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2018-11-29T11:59:58.884036Z 0 [Note] InnoDB: Completed initialization of buffer pool
2018-11-29T11:59:58.885224Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2018-11-29T11:59:58.896850Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2018-11-29T11:59:58.897890Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 13284971070
2018-11-29T11:59:58.897914Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 13284985271
2018-11-29T11:59:58.898055Z 0 [ERROR] InnoDB: Checksum mismatch in datafile: ./admin_shnyagi/dle_billing_history.ibd, Space ID:3581, Flags: 33. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html $
2018-11-29T11:59:58.898085Z 0 [Note] InnoDB: Page size:1024. Pages to analyze:64
2018-11-29T11:59:58.898212Z 0 [Note] InnoDB: Page size: 1024. Possible space_id count:0
2018-11-29T11:59:58.898220Z 0 [Note] InnoDB: Page size:2048. Pages to analyze:64
2018-11-29T11:59:58.898402Z 0 [Note] InnoDB: Page size: 2048. Possible space_id count:0
2018-11-29T11:59:58.898409Z 0 [Note] InnoDB: Page size:4096. Pages to analyze:64
2018-11-29T11:59:58.898725Z 0 [Note] InnoDB: Page size: 4096. Possible space_id count:0
2018-11-29T11:59:58.898733Z 0 [Note] InnoDB: Page size:8192. Pages to analyze:64
2018-11-29T11:59:58.899317Z 0 [Note] InnoDB: Page size: 8192. Possible space_id count:0
2018-11-29T11:59:58.899326Z 0 [Note] InnoDB: Page size:16384. Pages to analyze:64
2018-11-29T11:59:58.899371Z 0 [Note] InnoDB: VALID: space:3581 page_no:1 page_size:16384
2018-11-29T11:59:58.899400Z 0 [Note] InnoDB: VALID: space:3581 page_no:2 page_size:16384
2018-11-29T11:59:58.899427Z 0 [Note] InnoDB: VALID: space:3581 page_no:3 page_size:16384
2018-11-29T11:59:58.899454Z 0 [Note] InnoDB: VALID: space:3581 page_no:4 page_size:16384
2018-11-29T11:59:58.899481Z 0 [Note] InnoDB: VALID: space:3581 page_no:5 page_size:16384
2018-11-29T11:59:58.899508Z 0 [Note] InnoDB: VALID: space:3581 page_no:6 page_size:16384
2018-11-29T11:59:58.899535Z 0 [Note] InnoDB: VALID: space:3581 page_no:7 page_size:16384
2018-11-29T11:59:58.899562Z 0 [Note] InnoDB: VALID: space:3581 page_no:8 page_size:16384
2018-11-29T11:59:58.899589Z 0 [Note] InnoDB: VALID: space:3581 page_no:9 page_size:16384
2018-11-29T11:59:58.899615Z 0 [Note] InnoDB: VALID: space:3581 page_no:10 page_size:16384
2018-11-29T11:59:58.899642Z 0 [Note] InnoDB: VALID: space:3581 page_no:11 page_size:16384
2018-11-29T11:59:58.899669Z 0 [Note] InnoDB: VALID: space:3581 page_no:12 page_size:16384
2018-11-29T11:59:58.899696Z 0 [Note] InnoDB: VALID: space:3581 page_no:13 page_size:16384
2018-11-29T11:59:58.899723Z 0 [Note] InnoDB: VALID: space:3581 page_no:14 page_size:16384
2018-11-29T11:59:58.899749Z 0 [Note] InnoDB: VALID: space:3581 page_no:15 page_size:16384
2018-11-29T11:59:58.899776Z 0 [Note] InnoDB: VALID: space:3581 page_no:16 page_size:16384
2018-11-29T11:59:58.899813Z 0 [Note] InnoDB: VALID: space:3581 page_no:17 page_size:16384
2018-11-29T11:59:58.899840Z 0 [Note] InnoDB: VALID: space:3581 page_no:18 page_size:16384
2018-11-29T11:59:58.899867Z 0 [Note] InnoDB: VALID: space:3581 page_no:19 page_size:16384
2018-11-29T11:59:58.899894Z 0 [Note] InnoDB: VALID: space:3581 page_no:20 page_size:16384
2018-11-29T11:59:58.899921Z 0 [Note] InnoDB: VALID: space:3581 page_no:21 page_size:16384
2018-11-29T11:59:58.899948Z 0 [Note] InnoDB: VALID: space:3581 page_no:22 page_size:16384
2018-11-29T11:59:58.899975Z 0 [Note] InnoDB: VALID: space:3581 page_no:23 page_size:16384
2018-11-29T11:59:58.900002Z 0 [Note] InnoDB: VALID: space:3581 page_no:24 page_size:16384
2018-11-29T11:59:58.900029Z 0 [Note] InnoDB: VALID: space:3581 page_no:25 page_size:16384
2018-11-29T11:59:58.900056Z 0 [Note] InnoDB: VALID: space:3581 page_no:26 page_size:16384
2018-11-29T11:59:58.900082Z 0 [Note] InnoDB: VALID: space:3581 page_no:27 page_size:16384
2018-11-29T11:59:58.900109Z 0 [Note] InnoDB: VALID: space:3581 page_no:28 page_size:16384
2018-11-29T11:59:58.900136Z 0 [Note] InnoDB: VALID: space:3581 page_no:29 page_size:16384
2018-11-29T11:59:58.900163Z 0 [Note] InnoDB: VALID: space:3581 page_no:30 page_size:16384
2018-11-29T11:59:58.900190Z 0 [Note] InnoDB: VALID: space:3581 page_no:31 page_size:16384
2018-11-29T11:59:58.900218Z 0 [Note] InnoDB: VALID: space:3581 page_no:32 page_size:16384
2018-11-29T11:59:58.900247Z 0 [Note] InnoDB: VALID: space:3581 page_no:33 page_size:16384
2018-11-29T11:59:58.900275Z 0 [Note] InnoDB: VALID: space:3581 page_no:34 page_size:16384
2018-11-29T11:59:58.900303Z 0 [Note] InnoDB: VALID: space:3581 page_no:35 page_size:16384
2018-11-29T11:59:58.900331Z 0 [Note] InnoDB: VALID: space:3581 page_no:36 page_size:16384
2018-11-29T11:59:58.901348Z 0 [Note] InnoDB: Page size: 16384. Possible space_id count:1
2018-11-29T11:59:58.901358Z 0 [Note] InnoDB: space_id:3581, Number of pages matched: 36/36 (16384)
2018-11-29T11:59:58.901364Z 0 [Note] InnoDB: Chosen space:3581
2018-11-29T11:59:58.901384Z 0 [ERROR] InnoDB: Corrupted page [page id: space=3581, page number=0] of datafile './admin_shnyagi/dle_billing_history.ibd' could not be found in the doublewrite buffer.
2018-11-29T11:59:58.901723Z 0 [ERROR] InnoDB: Checksum mismatch in datafile: ./admin_shnyagi/dle_billing_prcodes.ibd, Space ID:3583, Flags: 33. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html $
2018-11-29T11:59:58.901749Z 0 [Note] InnoDB: Page size:1024. Pages to analyze:64
2018-11-29T11:59:58.901869Z 0 [Note] InnoDB: Page size: 1024. Possible space_id count:0
2018-11-29T11:59:58.901875Z 0 [Note] InnoDB: Page size:2048. Pages to analyze:48
2018-11-29T11:59:58.902009Z 0 [Note] InnoDB: Page size: 2048. Possible space_id count:0
2018-11-29T11:59:58.902016Z 0 [Note] InnoDB: Page size:4096. Pages to analyze:24
2018-11-29T11:59:58.902128Z 0 [Note] InnoDB: Page size: 4096. Possible space_id count:0
2018-11-29T11:59:58.902135Z 0 [Note] InnoDB: Page size:8192. Pages to analyze:12
2018-11-29T11:59:58.902244Z 0 [Note] InnoDB: Page size: 8192. Possible space_id count:0
2018-11-29T11:59:58.902250Z 0 [Note] InnoDB: Page size:16384. Pages to analyze:6
2018-11-29T11:59:58.902295Z 0 [Note] InnoDB: VALID: space:3583 page_no:1 page_size:16384
2018-11-29T11:59:58.902323Z 0 [Note] InnoDB: VALID: space:3583 page_no:2 page_size:16384
2018-11-29T11:59:58.902350Z 0 [Note] InnoDB: VALID: space:3583 page_no:3 page_size:16384
2018-11-29T11:59:58.902427Z 0 [Note] InnoDB: Page size: 16384. Possible space_id count:1
2018-11-29T11:59:58.902434Z 0 [Note] InnoDB: space_id:3583, Number of pages matched: 3/3 (16384)
2018-11-29T11:59:58.902439Z 0 [Note] InnoDB: Chosen space:3583
2018-11-29T11:59:58.902448Z 0 [ERROR] InnoDB: Corrupted page [page id: space=3583, page number=0] of datafile './admin_shnyagi/dle_billing_prcodes.ibd' could not be found in the doublewrite buffer.
2018-11-29T11:59:58.902656Z 0 [Note] InnoDB: Database was not shutdown normally!
2018-11-29T11:59:58.902671Z 0 [Note] InnoDB: Starting crash recovery.
2018-11-29T11:59:58.903181Z 0 [ERROR] InnoDB: Tablespace 3581 was not found at ./admin_shnyagi/dle_billing_history.ibd.
2018-11-29T11:59:58.903189Z 0 [ERROR] InnoDB: Set innodb_force_recovery=1 to ignore this and to permanently lose all changes to the tablespace.
2018-11-29T11:59:58.903384Z 0 [ERROR] InnoDB: Cannot continue operation.

Помогите пож. восстановить работу.

[grayfolk]

Всем доброго времени.
У меня сегодня крашнулась несколько таблиц одной из БД (InnoDB)
Перезапустил mysql перестал работать.

Помогите пож. восстановить работу.

Либо используйте рекомендацию

Code: Select all

2018-11-29T11:59:58.903189Z 0 [ERROR] InnoDB: Set innodb_force_recovery=1 to ignore this and to permanently lose all changes to the tablespace.

с потерей данных, либо, самое простое - восстановите из бэкапа.

[grayfolk]

Ну и вдогонку: https://habr.com/post/84283/