XAMPP出現Error: MySQL shutdown unexpectedly.
XAMPP顯示以下訊息:
[mysql] Attempting to start MySQL app...
[mysql] Status change detected: running
[mysql] Status change detected: stopped
[mysql] Error: MySQL shutdown unexpectedly.
[mysql] This may be due to a blocked port, missing dependencies,
[mysql] improper privileges, a crash, or a shutdown by another method.
[mysql] Press the Logs button to view error logs and check
[mysql] the Windows Event Viewer for more clues
[mysql] If you need more help, copy and post this
[mysql] entire log window on the forums
Error log 如下:
########################################
Cannot find checkpoint record at LSN (1,0x5771)
[ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
[ERROR] Plugin 'Aria' init function returned error.
[ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
InnoDB: using atomic writes.
[Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
[Note] InnoDB: Uses event mutexes
[Note] InnoDB: Compressed tables use zlib 1.2.11
[Note] InnoDB: Number of pools: 1
[Note] InnoDB: Using SSE2 crc32 instructions
[Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
[Note] InnoDB: Completed initialization of buffer pool
[ERROR] InnoDB: Page [page id: space=0, page number=7] log sequence number 741449411 is in the future! Current system log sequence number 25318555.
[ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
[ERROR] InnoDB: Page [page id: space=0, page number=3] log sequence number 735154551 is in the future! Current system log sequence number 25318555.
[ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
[ERROR] InnoDB: Page [page id: space=0, page number=11] log sequence number 740940259 is in the future! Current system log sequence number 25318555.
[ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
[ERROR] InnoDB: Page [page id: space=0, page number=405] log sequence number 444723260 is in the future! Current system log sequence number 25318555.
[ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
[ERROR] InnoDB: Page [page id: space=0, page number=1] log sequence number 741358918 is in the future! Current system log sequence number 25318555.
[ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
[ERROR] InnoDB: Page [page id: space=0, page number=8] log sequence number 741140799 is in the future! Current system log sequence number 25318555.
[ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
[ERROR] InnoDB: Page [page id: space=0, page number=573] log sequence number 741451302 is in the future! Current system log sequence number 25318555.
[ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
[ERROR] InnoDB: Page [page id: space=0, page number=10] log sequence number 741055332 is in the future! Current system log sequence number 25318555.
[ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
[ERROR] InnoDB: Page [page id: space=0, page number=437] log sequence number 345971326 is in the future! Current system log sequence number 25318555.
[ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
[ERROR] InnoDB: Page [page id: space=0, page number=12] log sequence number 725827202 is in the future! Current system log sequence number 25318555.
[ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
[ERROR] InnoDB: Page [page id: space=0, page number=417] log sequence number 446626187 is in the future! Current system log sequence number 25318555.
[ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
[ERROR] InnoDB: Page [page id: space=0, page number=307] log sequence number 741123439 is in the future! Current system log sequence number 25318555.
[ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
[ERROR] InnoDB: Page [page id: space=0, page number=302] log sequence number 446482510 is in the future! Current system log sequence number 25318555.
[ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
[ERROR] InnoDB: Page [page id: space=0, page number=303] log sequence number 446479076 is in the future! Current system log sequence number 25318555.
[ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
[ERROR] InnoDB: Page [page id: space=0, page number=304] log sequence number 446479229 is in the future! Current system log sequence number 25318555.
[ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
[ERROR] InnoDB: Page [page id: space=0, page number=308] log sequence number 504294926 is in the future! Current system log sequence number 25318555.
[ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
[ERROR] InnoDB: Page [page id: space=0, page number=561] log sequence number 741451132 is in the future! Current system log sequence number 25318555.
[ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
[ERROR] InnoDB: Page [page id: space=0, page number=574] log sequence number 741140799 is in the future! Current system log sequence number 25318555.
[ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
[ERROR] InnoDB: Page [page id: space=0, page number=560] log sequence number 504294926 is in the future! Current system log sequence number 25318555.
[ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
[ERROR] InnoDB: Page [page id: space=0, page number=557] log sequence number 741140799 is in the future! Current system log sequence number 25318555.
[ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
[ERROR] InnoDB: Page [page id: space=0, page number=406] log sequence number 627936453 is in the future! Current system log sequence number 25318555.
[ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
[ERROR] InnoDB: Page [page id: space=0, page number=423] log sequence number 740940259 is in the future! Current system log sequence number 25318555.
[ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
[ERROR] InnoDB: Page [page id: space=0, page number=514] log sequence number 741123398 is in the future! Current system log sequence number 25318555.
[ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
[ERROR] InnoDB: Page [page id: space=0, page number=518] log sequence number 741451181 is in the future! Current system log sequence number 25318555.
[ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
[Note] InnoDB: 128 out of 128 rollback segments are active.
[ERROR] InnoDB: Page [page id: space=0, page number=305] log sequence number 446482552 is in the future! Current system log sequence number 25318555.
[ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
[Note] InnoDB: Creating shared tablespace for temporary tables
[Note] InnoDB: Setting file 'C:\tools\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
[Note] InnoDB: File 'C:\tools\xampp\mysql\data\ibtmp1' size is now 12 MB.
[Note] InnoDB: Waiting for purge to start
[ERROR] InnoDB: Page [page id: space=0, page number=9] log sequence number 741448859 is in the future! Current system log sequence number 25318555.
[ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
[ERROR] InnoDB: Page [page id: space=0, page number=370] log sequence number 741130809 is in the future! Current system log sequence number 25318555.
[ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
[ERROR] InnoDB: Page [page id: space=0, page number=380] log sequence number 741060078 is in the future! Current system log sequence number 25318555.
[ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
[ERROR] InnoDB: Page [page id: space=0, page number=428] log sequence number 741451202 is in the future! Current system log sequence number 25318555.
[ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
[ERROR] InnoDB: Page [page id: space=646, page number=0] log sequence number 725647802 is in the future! Current system log sequence number 25318555.
[ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
[ERROR] InnoDB: Page [page id: space=0, page number=425] log sequence number 741123404 is in the future! Current system log sequence number 25318555.
[ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
[ERROR] InnoDB: Page [page id: space=646, page number=1] log sequence number 725647487 is in the future! Current system log sequence number 25318555.
[ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
[Note] InnoDB: 10.4.17 started; log sequence number 25318546; transaction id 781354
[Note] InnoDB: Loading buffer pool(s) from C:\tools\xampp\mysql\data\ib_buffer_pool
[Note] Plugin 'FEEDBACK' is disabled.
[ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
[Note] InnoDB: Buffer pool(s) load completed at 221107 4:26:13
[ERROR] Failed to initialize plugins.
[ERROR] Aborting
########################################
#方法1:
把file aria_log_control 和 aria_log.xxx delete.
#方法2:
先backup mysql內的data folder;
Copy file ibdata1 from backup folder to data folder.
