We are happy to announce that Vesta is back under active development as of 25 February 2024. We are working on v1 candidate and expect to engage more with the community over the coming months. We are committed to open source, and we encourage contributors to help us build the future of Vesta.
Не стартует Mysql
Не стартует Mysql
Всем доброго времени.
У меня сегодня крашнулась несколько таблиц одной из БД (InnoDB)
Перезапустил mysql перестал работать.
В логе вот это
Помогите пож. восстановить работу.
У меня сегодня крашнулась несколько таблиц одной из БД (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.
-
- Support team
- Posts: 1111
- Joined: Tue Jul 30, 2013 10:18 pm
- Contact:
- Os: CentOS 6x
- Web: nginx + php-fpm
Re: Не стартует 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.
-
- Support team
- Posts: 1111
- Joined: Tue Jul 30, 2013 10:18 pm
- Contact:
- Os: CentOS 6x
- Web: nginx + php-fpm
Re: Не стартует Mysql
Ну и вдогонку: https://habr.com/post/84283/