Цитата |
---|
Андрей Николаев написал: Надежда Неверова , а в логах мускуля что? (стандартно в /var/lib/mysql/* лежит) |
Нашла лог по этому пути: /var/log/mysql/error.logвот последние строки2019-01-29T09:56:12.246197Z 0 [Note] Binlog end
2019-01-29T09:56:12.246366Z 0 [Note] Shutting down plugin 'MyISAM'
2019-01-29T09:56:12.247399Z 0 [Note] /usr/sbin/mysqld: Shutdown complete
2019-01-29T09:56:12.691254Z 0 [Warning] Changed limits: max_open_files: 5000 (requested 20540)
2019-01-29T09:56:12.691846Z 0 [Warning] Changed limits: table_open_cache: 2470 (requested 10240)
2019-01-29T09:56:12.884721Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2019-01-29T09:56:12.887056Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.21-21) starting as process 20629 ...
2019-01-29T09:56:12.898120Z 0 [Note] InnoDB: PUNCH HOLE support available
2019-01-29T09:56:12.898185Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-01-29T09:56:12.898194Z 0 [Note] InnoDB: Uses event mutexes
2019-01-29T09:56:12.898201Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2019-01-29T09:56:12.898208Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.7
2019-01-29T09:56:12.898214Z 0 [Note] InnoDB: Using Linux native AIO
2019-01-29T09:56:12.898634Z 0 [Note] InnoDB: Number of pools: 1
2019-01-29T09:56:12.898825Z 0 [Note] InnoDB: Using CPU crc32 instructions
2019-01-29T09:56:12.901505Z 0 [Note] InnoDB: Initializing buffer pool, total size = 2G, instances = 8, chunk size = 128M
2019-01-29T09:56:12.970670Z 0 [Note] InnoDB: Completed initialization of buffer pool
2019-01-29T09:56:12.987082Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2019-01-29T09:56:13.001283Z 0 [Note] InnoDB: Recovering partial pages from the parallel doublewrite buffer at /var/lib/mysql/xb_doublewrite
2019-01-29T09:56:13.023369Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2019-01-29T09:56:13.036056Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 2142290997
2019-01-29T09:56:13.036131Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 2142315008
2019-01-29T09:56:13.037015Z 0 [ERROR] InnoDB: Ignoring the redo log due to missing MLOG_CHECKPOINT between the checkpoint 2142290997 and the end 2142315008.
2019-01-29T09:56:13.037570Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2019-01-29T09:56:18.218481Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2019-01-29T09:56:18.218547Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-01-29T09:56:18.218562Z 0 [ERROR] Failed to initialize builtin plugins.
2019-01-29T09:56:18.218571Z 0 [ERROR] Aborting
2019-01-29T09:56:18.218635Z 0 [Note] Binlog end
2019-01-29T09:56:18.218808Z 0 [Note] Shutting down plugin 'MyISAM'
2019-01-29T09:56:18.220104Z 0 [Note] /usr/sbin/mysqld: Shutdown complete
2019-01-29T09:56:18.652338Z 0 [Warning] Changed limits: max_open_files: 5000 (requested 20540)
2019-01-29T09:56:18.652933Z 0 [Warning] Changed limits: table_open_cache: 2470 (requested 10240)
2019-01-29T09:56:18.877797Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2019-01-29T09:56:18.879765Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.21-21) starting as process 20675 ...
2019-01-29T09:56:18.891745Z 0 [Note] InnoDB: PUNCH HOLE support available
2019-01-29T09:56:18.891823Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-01-29T09:56:18.891838Z 0 [Note] InnoDB: Uses event mutexes
2019-01-29T09:56:18.891847Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2019-01-29T09:56:18.891854Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.7
2019-01-29T09:56:18.891876Z 0 [Note] InnoDB: Using Linux native AIO
2019-01-29T09:56:18.892368Z 0 [Note] InnoDB: Number of pools: 1
2019-01-29T09:56:18.892592Z 0 [Note] InnoDB: Using CPU crc32 instructions
2019-01-29T09:56:18.895955Z 0 [Note] InnoDB: Initializing buffer pool, total size = 2G, instances = 8, chunk size = 128M
2019-01-29T09:56:18.989038Z 0 [Note] InnoDB: Completed initialization of buffer pool
2019-01-29T09:56:19.021051Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2019-01-29T09:56:19.038813Z 0 [Note] InnoDB: Recovering partial pages from the parallel doublewrite buffer at /var/lib/mysql/xb_doublewrite
2019-01-29T09:56:19.088939Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2019-01-29T09:56:19.113804Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 2142290997
2019-01-29T09:56:19.113894Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 2142315008
2019-01-29T09:56:19.115144Z 0 [ERROR] InnoDB: Ignoring the redo log due to missing MLOG_CHECKPOINT between the checkpoint 2142290997 and the end 2142315008.
2019-01-29T09:56:19.115779Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error