MySQL Forums
Forum List  »  Newbie

Re: Error: MySQL shutdown unexpectedly
Posted by: Csaba Dudás
Date: January 07, 2021 02:06AM

Similar problem:
2021-01-07 8:58:18 0 [Note] mysqld.exe: Aria engine: starting recovery
recovered pages: 0% 11%
Got error 176 when executing record redo_insert_row_head
2021-01-07 8:58:18 0 [ERROR] mysqld.exe: Aria engine: Redo phase failed
tables to flush: 3 2 1 0
2021-01-07 8:58:18 0 [ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
2021-01-07 8:58:18 0 [ERROR] Plugin 'Aria' init function returned error.
2021-01-07 8:58:18 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
InnoDB: using atomic writes.
2021-01-07 8:58:18 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-01-07 8:58:18 0 [Note] InnoDB: Uses event mutexes
2021-01-07 8:58:18 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-01-07 8:58:18 0 [Note] InnoDB: Number of pools: 1
2021-01-07 8:58:18 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-01-07 8:58:18 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-01-07 8:58:18 0 [Note] InnoDB: Completed initialization of buffer pool
2021-01-07 8:58:18 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=7203749
2021-01-07 8:58:18 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-01-07 8:58:18 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-01-07 8:58:18 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-01-07 8:58:18 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-01-07 8:58:18 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-01-07 8:58:18 0 [Note] InnoDB: Waiting for purge to start
2021-01-07 8:58:18 0 [Note] InnoDB: 10.4.14 started; log sequence number 7203758; transaction id 19188
2021-01-07 8:58:18 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-01-07 8:58:18 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-01-07 8:58:18 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2021-01-07 8:58:18 0 [ERROR] Failed to initialize plugins.
2021-01-07 8:58:18 0 [ERROR] Aborting
Table '.\mysql\db' is crashed, skipping it. Please repair it with aria_chk -r
2021-01-07 8:58:26 0 [Note] mysqld.exe: Aria engine: starting recovery
recovered pages: 0% 11% 28% 44% 55% 75% 88% 100% (0.0 seconds); tables to flush: 2 1 0
(0.0 seconds);
2021-01-07 8:58:26 0 [Note] mysqld.exe: Aria engine: recovery done
InnoDB: using atomic writes.
2021-01-07 8:58:26 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-01-07 8:58:26 0 [Note] InnoDB: Uses event mutexes
2021-01-07 8:58:26 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-01-07 8:58:26 0 [Note] InnoDB: Number of pools: 1
2021-01-07 8:58:26 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-01-07 8:58:26 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-01-07 8:58:26 0 [Note] InnoDB: Completed initialization of buffer pool
2021-01-07 8:58:26 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-01-07 8:58:26 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-01-07 8:58:26 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-01-07 8:58:26 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-01-07 8:58:26 0 [Note] InnoDB: Waiting for purge to start
2021-01-07 8:58:26 0 [Note] InnoDB: 10.4.14 started; log sequence number 7203767; transaction id 19188
2021-01-07 8:58:26 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-01-07 8:58:26 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-01-07 8:58:26 0 [Note] Server socket created on IP: '::'.

Options: ReplyQuote


Subject
Written By
Posted
Re: Error: MySQL shutdown unexpectedly
January 07, 2021 02:06AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.