amh - MYSQL无法启动？

Question

MYSQL无法启动 以下是启动日志

Starting MySQL. ERROR! The server quit without updating PID file (/home/usrdata/mysql-5.7/mysql.pid).2024-06-20T06:09:18.661305Z 0 [Note] InnoDB: Completed initialization of buffer pool2024-06-20T06:09:18.668847Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().2024-06-20T06:09:18.681012Z 0 [Note] InnoDB: Highest supported file format is Barracuda.2024-06-20T06:09:18.684576Z 0 [ERROR] InnoDB: Ignoring the redo log due to missing MLOG_CHECKPOINT between the checkpoint 14776072903 and the end 14776072704.2024-06-20T06:09:18.684597Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error2024-06-20T06:09:18.986010Z 0 [ERROR] Plugin 'InnoDB' init function returned error.2024-06-20T06:09:18.986033Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.2024-06-20T06:09:18.986040Z 0 [ERROR] Failed to initialize builtin plugins.2024-06-20T06:09:18.986043Z 0 [ERROR] Aborting2024-06-20T06:09:18.986059Z 0 [Note] Binlog end2024-06-20T06:09:18.986138Z 0 [Note] Shutting down plugin 'CSV'2024-06-20T06:09:18.987253Z 0 [Note] /usr/local/mysql-5.7/bin/mysqld: Shutdown complete2024-06-20T06:09:37.323735Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).2024-06-20T06:09:37.323826Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.2024-06-20T06:09:37.323863Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled2024-06-20T06:09:37.323909Z 0 [Note] /usr/local/mysql-5.7/bin/mysqld (mysqld 5.7.35-log) starting as process 3272 ...2024-06-20T06:09:37.404648Z 0 [Note] InnoDB: PUNCH HOLE support available2024-06-20T06:09:37.404684Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins2024-06-20T06:09:37.404693Z 0 [Note] InnoDB: Uses event mutexes2024-06-20T06:09:37.404698Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier2024-06-20T06:09:37.404702Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.112024-06-20T06:09:37.408694Z 0 [Note] InnoDB: Number of pools: 12024-06-20T06:09:37.408893Z 0 [Note] InnoDB: Using CPU crc32 instructions2024-06-20T06:09:37.410626Z 0 [Note] InnoDB: Initializing buffer pool, total size = 768M, instances = 1, chunk size = 128M2024-06-20T06:09:37.473512Z 0 [Note] InnoDB: Completed initialization of buffer pool2024-06-20T06:09:37.484577Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().2024-06-20T06:09:37.500257Z 0 [Note] InnoDB: Highest supported file format is Barracuda.2024-06-20T06:09:37.510734Z 0 [ERROR] InnoDB: Ignoring the redo log due to missing MLOG_CHECKPOINT between the checkpoint 14776072903 and the end 14776072704.2024-06-20T06:09:37.510765Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error2024-06-20T06:09:37.811296Z 0 [ERROR] Plugin 'InnoDB' init function returned error.2024-06-20T06:09:37.811321Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.2024-06-20T06:09:37.811327Z 0 [ERROR] Failed to initialize builtin plugins.2024-06-20T06:09:37.811330Z 0 [ERROR] Aborting2024-06-20T06:09:37.811352Z 0 [Note] Binlog end2024-06-20T06:09:37.811440Z 0 [Note] Shutting down plugin 'CSV'2024-06-20T06:09:37.812368Z 0 [Note] /usr/local/mysql-5.7/bin/mysqld: Shutdown complete2024-06-20T06:09:42.858363Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).2024-06-20T06:09:42.858459Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.2024-06-20T06:09:42.858493Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled2024-06-20T06:09:42.858535Z 0 [Note] /usr/local/mysql-5.7/bin/mysqld (mysqld 5.7.35-log) starting as process 7521 ...2024-06-20T06:09:42.940750Z 0 [Note] InnoDB: PUNCH HOLE support available2024-06-20T06:09:42.940808Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins2024-06-20T06:09:42.940813Z 0 [Note] InnoDB: Uses event mutexes2024-06-20T06:09:42.940817Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier2024-06-20T06:09:42.940825Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.112024-06-20T06:09:42.944937Z 0 [Note] InnoDB: Number of pools: 12024-06-20T06:09:42.945122Z 0 [Note] InnoDB: Using CPU crc32 instructions2024-06-20T06:09:42.947139Z 0 [Note] InnoDB: Initializing buffer pool, total size = 768M, instances = 1, chunk size = 128M2024-06-20T06:09:43.008086Z 0 [Note] InnoDB: Completed initialization of buffer pool2024-06-20T06:09:43.020164Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().2024-06-20T06:09:43.033095Z 0 [Note] InnoDB: Highest supported file format is Barracuda.2024-06-20T06:09:43.037369Z 0 [ERROR] InnoDB: Ignoring the redo log due to missing MLOG_CHECKPOINT between the checkpoint 14776072903 and the end 14776072704.2024-06-20T06:09:43.037403Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error2024-06-20T06:09:43.341266Z 0 [ERROR] Plugin 'InnoDB' init function returned error.2024-06-20T06:09:43.341289Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.2024-06-20T06:09:43.341309Z 0 [ERROR] Failed to initialize builtin plugins.2024-06-20T06:09:43.341312Z 0 [ERROR] Aborting2024-06-20T06:09:43.341339Z 0 [Note] Binlog end2024-06-20T06:09:43.341417Z 0 [Note] Shutting down plugin 'CSV'2024-06-20T06:09:43.342748Z 0 [Note] /usr/local/mysql-5.7/bin/mysqld: Shutdown complete2024-06-20T06:10:30.711342Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).2024-06-20T06:10:30.711425Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.2024-06-20T06:10:30.711459Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled2024-06-20T06:10:30.711502Z 0 [Note] /usr/local/mysql-5.7/bin/mysqld (mysqld 5.7.35-log) starting as process 10091 ...2024-06-20T06:10:30.765763Z 0 [Note] InnoDB: PUNCH HOLE support available2024-06-20T06:10:30.765815Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins2024-06-20T06:10:30.765819Z 0 [Note] InnoDB: Uses event mutexes2024-06-20T06:10:30.765823Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier2024-06-20T06:10:30.765826Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.112024-06-20T06:10:30.769195Z 0 [Note] InnoDB: Number of pools: 12024-06-20T06:10:30.769311Z 0 [Note] InnoDB: Using CPU crc32 instructions2024-06-20T06:10:30.770603Z 0 [Note] InnoDB: Initializing buffer pool, total size = 768M, instances = 1, chunk size = 128M2024-06-20T06:10:30.825414Z 0 [Note] InnoDB: Completed initialization of buffer pool2024-06-20T06:10:30.837608Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().2024-06-20T06:10:30.849874Z 0 [Note] InnoDB: Highest supported file format is Barracuda.2024-06-20T06:10:30.853794Z 0 [ERROR] InnoDB: Ignoring the redo log due to missing MLOG_CHECKPOINT between the checkpoint 14776072903 and the end 14776072704.2024-06-20T06:10:30.853823Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error2024-06-20T06:10:31.154961Z 0 [ERROR] Plugin 'InnoDB' init function returned error.2024-06-20T06:10:31.154999Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.2024-06-20T06:10:31.155010Z 0 [ERROR] Failed to initialize builtin plugins.2024-06-20T06:10:31.155016Z 0 [ERROR] Aborting2024-06-20T06:10:31.155042Z 0 [Note] Binlog end2024-06-20T06:10:31.155156Z 0 [Note] Shutting down plugin 'CSV'2024-06-20T06:10:31.156194Z 0 [Note] /usr/local/mysql-5.7/bin/mysqld: Shutdown complete2024-06-20T06:10:53.394732Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).2024-06-20T06:10:53.394815Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.2024-06-20T06:10:53.394850Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled2024-06-20T06:10:53.394893Z 0 [Note] /usr/local/mysql-5.7/bin/mysqld (mysqld 5.7.35-log) starting as process 10758 ...2024-06-20T06:10:53.436766Z 0 [Note] InnoDB: PUNCH HOLE support available2024-06-20T06:10:53.436847Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins2024-06-20T06:10:53.436853Z 0 [Note] InnoDB: Uses event mutexes2024-06-20T06:10:53.436857Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier2024-06-20T06:10:53.436860Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.112024-06-20T06:10:53.439436Z 0 [Note] InnoDB: Number of pools: 12024-06-20T06:10:53.439555Z 0 [Note] InnoDB: Using CPU crc32 instructions2024-06-20T06:10:53.440868Z 0 [Note] InnoDB: Initializing buffer pool, total size = 768M, instances = 1, chunk size = 128M2024-06-20T06:10:53.484785Z 0 [Note] InnoDB: Completed initialization of buffer pool2024-06-20T06:10:53.493102Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().2024-06-20T06:10:53.505320Z 0 [Note] InnoDB: Highest supported file format is Barracuda.2024-06-20T06:10:53.509416Z 0 [ERROR] InnoDB: Ignoring the redo log due to missing MLOG_CHECKPOINT between the checkpoint 14776072903 and the end 14776072704.2024-06-20T06:10:53.509436Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error2024-06-20T06:10:53.810980Z 0 [ERROR] Plugin 'InnoDB' init function returned error.2024-06-20T06:10:53.811023Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.2024-06-20T06:10:53.811034Z 0 [ERROR] Failed to initialize builtin plugins.2024-06-20T06:10:53.811041Z 0 [ERROR] Aborting2024-06-20T06:10:53.811066Z 0 [Note] Binlog end2024-06-20T06:10:53.811185Z 0 [Note] Shutting down plugin 'CSV'2024-06-20T06:10:53.812051Z 0 [Note] /usr/local/mysql-5.7/bin/mysqld: Shutdown complete2024-06-20T06:11:38.852553Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).2024-06-20T06:11:38.852640Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.2024-06-20T06:11:38.852671Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled2024-06-20T06:11:38.852711Z 0 [Note] /usr/local/mysql-5.7/bin/mysqld (mysqld 5.7.35-log) starting as process 11441 ...2024-06-20T06:11:38.894663Z 0 [Note] InnoDB: PUNCH HOLE support available2024-06-20T06:11:38.894727Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins2024-06-20T06:11:38.894731Z 0 [Note] InnoDB: Uses event mutexes2024-06-20T06:11:38.894735Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier2024-06-20T06:11:38.894738Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.112024-06-20T06:11:38.897055Z 0 [Note] InnoDB: Number of pools: 12024-06-20T06:11:38.897170Z 0 [Note] InnoDB: Using CPU crc32 instructions2024-06-20T06:11:38.898501Z 0 [Note] InnoDB: Initializing buffer pool, total size = 768M, instances = 1, chunk size = 128M2024-06-20T06:11:38.942969Z 0 [Note] InnoDB: Completed initialization of buffer pool2024-06-20T06:11:38.950715Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().2024-06-20T06:11:38.962690Z 0 [Note] InnoDB: Highest supported file format is Barracuda.2024-06-20T06:11:38.965967Z 0 [ERROR] InnoDB: Ignoring the redo log due to missing MLOG_CHECKPOINT between the checkpoint 14776072903 and the end 14776072704.2024-06-20T06:11:38.966011Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error2024-06-20T06:11:39.267439Z 0 [ERROR] Plugin 'InnoDB' init function returned error.2024-06-20T06:11:39.267462Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.2024-06-20T06:11:39.267468Z 0 [ERROR] Failed to initialize builtin plugins.2024-06-20T06:11:39.267472Z 0 [ERROR] Aborting2024-06-20T06:11:39.267486Z 0 [Note] Binlog end2024-06-20T06:11:39.267575Z 0 [Note] Shutting down plugin 'CSV'2024-06-20T06:11:39.268624Z 0 [Note] /usr/local/mysql-5.7/bin/mysqld: Shutdown complete2024-06-20T06:12:53.068298Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).2024-06-20T06:12:53.068643Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.2024-06-20T06:12:53.068685Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled2024-06-20T06:12:53.069002Z 0 [Note] /usr/local/mysql-5.7/bin/mysqld (mysqld 5.7.35-log) starting as process 13076 ...2024-06-20T06:12:53.126171Z 0 [Note] InnoDB: PUNCH HOLE support available2024-06-20T06:12:53.126224Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins2024-06-20T06:12:53.126238Z 0 [Note] InnoDB: Uses event mutexes2024-06-20T06:12:53.126242Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier2024-06-20T06:12:53.126246Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.112024-06-20T06:12:53.129735Z 0 [Note] InnoDB: Number of pools: 12024-06-20T06:12:53.131087Z 0 [Note] InnoDB: Using CPU crc32 instructions2024-06-20T06:12:53.132779Z 0 [Note] InnoDB: Initializing buffer pool, total size = 768M, instances = 1, chunk size = 128M2024-06-20T06:12:53.180285Z 0 [Note] InnoDB: Completed initialization of buffer pool2024-06-20T06:12:53.189191Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().2024-06-20T06:12:53.205782Z 0 [Note] InnoDB: Highest supported file format is Barracuda.2024-06-20T06:12:53.219200Z 0 [ERROR] InnoDB: Ignoring the redo log due to missing MLOG_CHECKPOINT between the checkpoint 14776072903 and the end 14776072704.2024-06-20T06:12:53.219225Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error2024-06-20T06:12:53.520138Z 0 [ERROR] Plugin 'InnoDB' init function returned error.2024-06-20T06:12:53.520163Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.2024-06-20T06:12:53.520170Z 0 [ERROR] Failed to initialize builtin plugins.2024-06-20T06:12:53.520174Z 0 [ERROR] Aborting2024-06-20T06:12:53.520189Z 0 [Note] Binlog end2024-06-20T06:12:53.520272Z 0 [Note] Shutting down plugin 'CSV'2024-06-20T06:12:53.521530Z 0 [Note] /usr/local/mysql-5.7/bin/mysqld: Shutdown complete2024-06-20T06:12:57.872923Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).2024-06-20T06:12:57.873003Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.2024-06-20T06:12:57.873033Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled2024-06-20T06:12:57.873073Z 0 [Note] /usr/local/mysql-5.7/bin/mysqld (mysqld 5.7.35-log) starting as process 16418 ...2024-06-20T06:12:57.915066Z 0 [Note] InnoDB: PUNCH HOLE support available2024-06-20T06:12:57.915121Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins2024-06-20T06:12:57.915126Z 0 [Note] InnoDB: Uses event mutexes2024-06-20T06:12:57.915129Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier2024-06-20T06:12:57.915132Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.112024-06-20T06:12:57.917526Z 0 [Note] InnoDB: Number of pools: 12024-06-20T06:12:57.917694Z 0 [Note] InnoDB: Using CPU crc32 instructions2024-06-20T06:12:57.919012Z 0 [Note] InnoDB: Initializing buffer pool, total size = 768M, instances = 1, chunk size = 128M2024-06-20T06:12:57.964359Z 0 [Note] InnoDB: Completed initialization of buffer pool2024-06-20T06:12:57.971818Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().2024-06-20T06:12:57.984295Z 0 [Note] InnoDB: Highest supported file format is Barracuda.2024-06-20T06:12:57.987692Z 0 [ERROR] InnoDB: Ignoring the redo log due to missing MLOG_CHECKPOINT between the checkpoint 14776072903 and the end 14776072704.2024-06-20T06:12:57.987712Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error2024-06-20T06:12:58.289675Z 0 [ERROR] Plugin 'InnoDB' init function returned error.2024-06-20T06:12:58.289721Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.2024-06-20T06:12:58.289733Z 0 [ERROR] Failed to initialize builtin plugins.2024-06-20T06:12:58.289740Z 0 [ERROR] Aborting2024-06-20T06:12:58.289766Z 0 [Note] Binlog end2024-06-20T06:12:58.289891Z 0 [Note] Shutting down plugin 'CSV'2024-06-20T06:12:58.290869Z 0 [Note] /usr/local/mysql-5.7/bin/mysqld: Shutdown complete2024-06-20T06:13:17.151643Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).2024-06-20T06:13:17.151730Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.2024-06-20T06:13:17.151809Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled2024-06-20T06:13:17.151863Z 0 [Note] /usr/local/mysql-5.7/bin/mysqld (mysqld 5.7.35-log) starting as process 3243 ...2024-06-20T06:13:17.233634Z 0 [Note] InnoDB: PUNCH HOLE support available2024-06-20T06:13:17.233682Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins2024-06-20T06:13:17.233687Z 0 [Note] InnoDB: Uses event mutexes2024-06-20T06:13:17.233691Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier2024-06-20T06:13:17.233695Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.112024-06-20T06:13:17.237531Z 0 [Note] InnoDB: Number of pools: 12024-06-20T06:13:17.237703Z 0 [Note] InnoDB: Using CPU crc32 instructions2024-06-20T06:13:17.239397Z 0 [Note] InnoDB: Initializing buffer pool, total size = 768M, instances = 1, chunk size = 128M2024-06-20T06:13:17.298445Z 0 [Note] InnoDB: Completed initialization of buffer pool2024-06-20T06:13:17.309870Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().2024-06-20T06:13:17.325317Z 0 [Note] InnoDB: Highest supported file format is Barracuda.2024-06-20T06:13:17.338143Z 0 [ERROR] InnoDB: Ignoring the redo log due to missing MLOG_CHECKPOINT between the checkpoint 14776072903 and the end 14776072704.2024-06-20T06:13:17.338171Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error2024-06-20T06:13:17.639622Z 0 [ERROR] Plugin 'InnoDB' init function returned error.2024-06-20T06:13:17.639648Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.2024-06-20T06:13:17.639654Z 0 [ERROR] Failed to initialize builtin plugins.2024-06-20T06:13:17.639657Z 0 [ERROR] Aborting2024-06-20T06:13:17.639679Z 0 [Note] Binlog end2024-06-20T06:13:17.639765Z 0 [Note] Shutting down plugin 'CSV'2024-06-20T06:13:17.640731Z 0 [Note] /usr/local/mysql-5.7/bin/mysqld: Shutdown complete2024-06-20T06:13:22.400043Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).2024-06-20T06:13:22.400125Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.2024-06-20T06:13:22.400154Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled2024-06-20T06:13:22.400189Z 0 [Note] /usr/local/mysql-5.7/bin/mysqld (mysqld 5.7.35-log) starting as process 7520 ...2024-06-20T06:13:22.472508Z 0 [Note] InnoDB: PUNCH HOLE support available2024-06-20T06:13:22.472556Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins2024-06-20T06:13:22.472564Z 0 [Note] InnoDB: Uses event mutexes2024-06-20T06:13:22.472568Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier2024-06-20T06:13:22.472572Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.112024-06-20T06:13:22.476097Z 0 [Note] InnoDB: Number of pools: 12024-06-20T06:13:22.476257Z 0 [Note] InnoDB: Using CPU crc32 instructions2024-06-20T06:13:22.477794Z 0 [Note] InnoDB: Initializing buffer pool, total size = 768M, instances = 1, chunk size = 128M2024-06-20T06:13:22.530518Z 0 [Note] InnoDB: Completed initialization of buffer pool2024-06-20T06:13:22.541397Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().2024-06-20T06:13:22.553896Z 0 [Note] InnoDB: Highest supported file format is Barracuda.2024-06-20T06:13:22.557764Z 0 [ERROR] InnoDB: Ignoring the redo log due to missing MLOG_CHECKPOINT between the checkpoint 14776072903 and the end 14776072704.2024-06-20T06:13:22.557784Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error2024-06-20T06:13:22.858889Z 0 [ERROR] Plugin 'InnoDB' init function returned error.2024-06-20T06:13:22.858915Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.2024-06-20T06:13:22.858932Z 0 [ERROR] Failed to initialize builtin plugins.2024-06-20T06:13:22.858935Z 0 [ERROR] Aborting2024-06-20T06:13:22.858948Z 0 [Note] Binlog end2024-06-20T06:13:22.859015Z 0 [Note] Shutting down plugin 'CSV'2024-06-20T06:13:22.859927Z 0 [Note] /usr/local/mysql-5.7/bin/mysqld: Shutdown complete2024-06-20T06:14:26.876830Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).2024-06-20T06:14:26.876907Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.2024-06-20T06:14:26.876938Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled2024-06-20T06:14:26.876976Z 0 [Note] /usr/local/mysql-5.7/bin/mysqld (mysqld 5.7.35-log) starting as process 9754 ...2024-06-20T06:14:26.930759Z 0 [Note] InnoDB: PUNCH HOLE support available2024-06-20T06:14:26.930818Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins2024-06-20T06:14:26.930823Z 0 [Note] InnoDB: Uses event mutexes2024-06-20T06:14:26.930827Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier2024-06-20T06:14:26.930830Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.112024-06-20T06:14:26.934482Z 0 [Note] InnoDB: Number of pools: 12024-06-20T06:14:26.934597Z 0 [Note] InnoDB: Using CPU crc32 instructions2024-06-20T06:14:26.936223Z 0 [Note] InnoDB: Initializing buffer pool, total size = 768M, instances = 1, chunk size = 128M2024-06-20T06:14:27.010381Z 0 [Note] InnoDB: Completed initialization of buffer pool2024-06-20T06:14:27.022263Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().2024-06-20T06:14:27.034463Z 0 [Note] InnoDB: Highest supported file format is Barracuda.2024-06-20T06:14:27.038616Z 0 [ERROR] InnoDB: Ignoring the redo log due to missing MLOG_CHECKPOINT between the checkpoint 14776072903 and the end 14776072704.2024-06-20T06:14:27.038639Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error2024-06-20T06:14:27.339546Z 0 [ERROR] Plugin 'InnoDB' init function returned error.2024-06-20T06:14:27.339580Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.2024-06-20T06:14:27.339586Z 0 [ERROR] Failed to initialize builtin plugins.2024-06-20T06:14:27.339590Z 0 [ERROR] Aborting2024-06-20T06:14:27.339605Z 0 [Note] Binlog end2024-06-20T06:14:27.339681Z 0 [Note] Shutting down plugin 'CSV'2024-06-20T06:14:27.340670Z 0 [Note] /usr/local/mysql-5.7/bin/mysqld: Shutdown complete2024-06-20T06:14:45.809049Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).2024-06-20T06:14:45.809126Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.2024-06-20T06:14:45.809156Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled2024-06-20T06:14:45.809195Z 0 [Note] /usr/local/mysql-5.7/bin/mysqld (mysqld 5.7.35-log) starting as process 10407 ...2024-06-20T06:14:45.853357Z 0 [Note] InnoDB: PUNCH HOLE support available2024-06-20T06:14:45.853412Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins2024-06-20T06:14:45.853416Z 0 [Note] InnoDB: Uses event mutexes2024-06-20T06:14:45.853420Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier2024-06-20T06:14:45.853424Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.112024-06-20T06:14:45.855848Z 0 [Note] InnoDB: Number of pools: 12024-06-20T06:14:45.855966Z 0 [Note] InnoDB: Using CPU crc32 instructions2024-06-20T06:14:45.857326Z 0 [Note] InnoDB: Initializing buffer pool, total size = 768M, instances = 1, chunk size = 128M2024-06-20T06:14:45.902802Z 0 [Note] InnoDB: Completed initialization of buffer pool2024-06-20T06:14:45.909878Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().2024-06-20T06:14:45.921762Z 0 [Note] InnoDB: Highest supported file format is Barracuda.2024-06-20T06:14:45.925166Z 0 [ERROR] InnoDB: Ignoring the redo log due to missing MLOG_CHECKPOINT between the checkpoint 14776072903 and the end 14776072704.2024-06-20T06:14:45.925186Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error2024-06-20T06:14:46.226547Z 0 [ERROR] Plugin 'InnoDB' init function returned error.2024-06-20T06:14:46.226599Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.2024-06-20T06:14:46.226609Z 0 [ERROR] Failed to initialize builtin plugins.2024-06-20T06:14:46.226616Z 0 [ERROR] Aborting2024-06-20T06:14:46.226643Z 0 [Note] Bi

删除过pid和lock 检查过根目录有剩余空间

Answer 1

[ERROR] InnoDB: Ignoring the redo log due to missing MLOG_CHECKPOINT between the checkpoint 14776072903 and the end 14776072704.[ERROR] InnoDB: Plugin initialization aborted with error Generic error[ERROR] Plugin 'InnoDB' init function returned error.[ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.[ERROR] Failed to initialize builtin plugins.[ERROR] Aborting

这个问题是因为InnoDB重做日志（redo log）损坏引起。具体来说，重做日志中缺少检查点记录，导致InnoDB无法正常启动。

可以参考以下步骤：

1. 删除InnoDB重做日志 这种方法会导致最近的未提交事务丢失
2. 检查InnoDB表空间文件是否有损坏的
3. 检查是否拥有权限

Answer 2

 [ERROR] InnoDB: Ignoring the redo log due to missing

服务器是不正常关机，还是什么操作，mysql直接挂掉了吗日志异常，
可以修改my.cnf配置，/usr/local/mysql-版本/my.cnf
增加innodb_force_recovery恢复参数，再启动amh mysql start看。

操作前，建议做一次当前mysql的 /home/usrdata/mysql-版本/ 数据目录文件的备份。