MySQL : unexpected shutdown

Problems with the Windows version of XAMPP, questions, comments, and anything related.

MySQL : unexpected shutdown

Postby MaaikeJ » 28. November 2021 13:18

Hi, everyone! :D
Think I need your help, guys.
I don't know why MySQL suddenly shot down... :(

Here is the copy of the logs doc:

2021-11-24 9:17:43 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-11-24 9:17:43 0 [Note] InnoDB: Uses event mutexes
2021-11-24 9:17:43 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-11-24 9:17:43 0 [Note] InnoDB: Number of pools: 1
2021-11-24 9:17:43 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-11-24 9:17:43 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-11-24 9:17:43 0 [Note] InnoDB: Completed initialization of buffer pool
2021-11-24 9:17:43 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=300288
2021-11-24 9:17:44 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-11-24 9:17:44 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-11-24 9:17:44 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-11-24 9:17:44 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-11-24 9:17:44 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-11-24 9:17:44 0 [Note] InnoDB: Waiting for purge to start
2021-11-24 9:17:44 0 [Note] InnoDB: 10.4.21 started; log sequence number 300297; transaction id 170
2021-11-24 9:17:44 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-11-24 9:17:44 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-11-24 9:17:44 0 [Note] Server socket created on IP: '::'.
2021-11-27 10:52:54 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-11-27 10:52:54 0 [Note] InnoDB: Uses event mutexes
2021-11-27 10:52:54 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-11-27 10:52:54 0 [Note] InnoDB: Number of pools: 1
2021-11-27 10:52:54 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-11-27 10:52:54 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-11-27 10:52:54 0 [Note] InnoDB: Completed initialization of buffer pool
2021-11-27 10:52:54 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=8102729
2021-11-27 10:52:54 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-11-27 10:52:54 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-11-27 10:52:54 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-11-27 10:52:54 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-11-27 10:52:54 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-11-27 10:52:54 0 [Note] InnoDB: Waiting for purge to start
2021-11-27 10:52:54 0 [Note] InnoDB: 10.4.21 started; log sequence number 8102738; transaction id 5782
2021-11-27 10:52:54 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-11-27 10:52:54 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-11-27 10:52:54 0 [Note] Server socket created on IP: '::'.
2021-11-28 8:11:30 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-11-28 8:11:30 0 [Note] InnoDB: Uses event mutexes
2021-11-28 8:11:30 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-11-28 8:11:30 0 [Note] InnoDB: Number of pools: 1
2021-11-28 8:11:30 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-11-28 8:11:30 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-11-28 8:11:30 0 [Note] InnoDB: Completed initialization of buffer pool
2021-11-28 8:11:30 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=14731986
2021-11-28 8:11:30 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-11-28 8:11:30 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-11-28 8:11:30 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-11-28 8:11:30 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-11-28 8:11:30 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-11-28 8:11:31 0 [Note] InnoDB: Waiting for purge to start
2021-11-28 8:11:31 0 [Note] InnoDB: 10.4.21 started; log sequence number 14731995; transaction id 9669
2021-11-28 8:11:31 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-11-28 8:11:31 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-11-28 8:11:31 0 [Note] Server socket created on IP: '::'.
Cannot find checkpoint record at LSN (1,0x5556)
2021-11-28 12:40:36 0 [ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
2021-11-28 12:40:36 0 [ERROR] Plugin 'Aria' init function returned error.
2021-11-28 12:40:36 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2021-11-28 12:40:36 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-11-28 12:40:36 0 [Note] InnoDB: Uses event mutexes
2021-11-28 12:40:36 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-11-28 12:40:36 0 [Note] InnoDB: Number of pools: 1
2021-11-28 12:40:36 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-11-28 12:40:36 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-11-28 12:40:36 0 [Note] InnoDB: Completed initialization of buffer pool
2021-11-28 12:40:36 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=19346023
2021-11-28 12:40:36 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-11-28 12:40:36 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-11-28 12:40:36 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-11-28 12:40:36 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-11-28 12:40:36 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-11-28 12:40:36 0 [Note] InnoDB: Waiting for purge to start
2021-11-28 12:40:36 0 [Note] InnoDB: 10.4.21 started; log sequence number 19346032; transaction id 12802
2021-11-28 12:40:36 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-11-28 12:40:36 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-11-28 12:40:36 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2021-11-28 12:40:36 0 [ERROR] Failed to initialize plugins.
2021-11-28 12:40:36 0 [ERROR] Aborting
Cannot find checkpoint record at LSN (1,0x5556)
2021-11-28 13:05:55 0 [ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
2021-11-28 13:05:55 0 [ERROR] Plugin 'Aria' init function returned error.
2021-11-28 13:05:55 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2021-11-28 13:05:55 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-11-28 13:05:55 0 [Note] InnoDB: Uses event mutexes
2021-11-28 13:05:55 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-11-28 13:05:55 0 [Note] InnoDB: Number of pools: 1
2021-11-28 13:05:55 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-11-28 13:05:55 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-11-28 13:05:55 0 [Note] InnoDB: Completed initialization of buffer pool
2021-11-28 13:05:55 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-11-28 13:05:55 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-11-28 13:05:55 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-11-28 13:05:55 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-11-28 13:05:55 0 [Note] InnoDB: Waiting for purge to start
2021-11-28 13:05:55 0 [Note] InnoDB: 10.4.21 started; log sequence number 19346041; transaction id 12802
2021-11-28 13:05:55 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-11-28 13:05:55 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-11-28 13:05:55 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2021-11-28 13:05:55 0 [ERROR] Failed to initialize plugins.
2021-11-28 13:05:55 0 [ERROR] Aborting


If anyone could help, I'd be grateful :oops:
MaaikeJ
 
Posts: 2
Joined: 28. November 2021 13:10
Location: France
XAMPP version: v3.3.0
Operating System: Windows 11 x64

Re: MySQL : unexpected shutdown

Postby MaaikeJ » 30. November 2021 09:35

Hi !
Yesterday, I found the problem and its solution. It worked fine all day long.

But, now, I've got another problem....
Could anyone help? Please?

2021-11-30 9:37:35 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-11-30 9:37:35 0 [Note] InnoDB: Uses event mutexes
2021-11-30 9:37:35 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-11-30 9:37:35 0 [Note] InnoDB: Number of pools: 1
2021-11-30 9:37:35 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-11-30 9:37:35 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-11-30 9:37:35 0 [Note] InnoDB: Completed initialization of buffer pool
2021-11-30 9:37:35 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=300288
2021-11-30 9:37:36 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-11-30 9:37:36 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-11-30 9:37:36 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-11-30 9:37:36 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-11-30 9:37:36 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-11-30 9:37:36 0 [Note] InnoDB: Waiting for purge to start
2021-11-30 9:37:36 0 [Note] InnoDB: 10.4.21 started; log sequence number 300297; transaction id 170
2021-11-30 9:37:36 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-11-30 9:37:36 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-11-30 9:37:36 0 [Note] InnoDB: Buffer pool(s) load completed at 211130 9:37:36
2021-11-30 9:37:36 0 [Note] Server socket created on IP: '::'.
MaaikeJ
 
Posts: 2
Joined: 28. November 2021 13:10
Location: France
XAMPP version: v3.3.0
Operating System: Windows 11 x64


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 121 guests