my xampp v 3.3.0 my sql server showing this errors in red

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

my xampp v 3.3.0 my sql server showing this errors in red

Postby mak1 » 30. March 2022 14:24

my xampp v 3.3.0 my sql server showing this errors in red
Error: MySQL shutdown unexpectedly.. kindly guide me to solve.


Error: MySQL shutdown unexpectedly.
6:03:20 PM [mysql] This may be due to a blocked port, missing dependencies,
6:03:20 PM [mysql] improper privileges, a crash, or a shutdown by another method.
6:03:20 PM [mysql] Press the Logs button to view error logs and check
6:03:20 PM [mysql] the Windows Event Viewer for more clues
6:03:20 PM [mysql] If you need more help, copy and post this
6:03:20 PM [mysql] entire log window on the forums




2022-02-15 2:49:17 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-02-15 2:49:17 0 [Note] InnoDB: Uses event mutexes
2022-02-15 2:49:17 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-02-15 2:49:18 0 [Note] InnoDB: Number of pools: 1
2022-02-15 2:49:18 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-02-15 2:49:18 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2022-02-15 2:49:18 0 [Note] InnoDB: Completed initialization of buffer pool
2022-02-15 2:49:18 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=300288
2022-02-15 2:49:18 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-02-15 2:49:18 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2022-02-15 2:49:18 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-02-15 2:49:18 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-02-15 2:49:18 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2022-02-15 2:49:18 0 [Note] InnoDB: Waiting for purge to start
2022-02-15 2:49:18 0 [Note] InnoDB: 10.4.22 started; log sequence number 300297; transaction id 170
2022-02-15 2:49:18 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2022-02-15 2:49:18 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-02-15 2:49:18 0 [Note] Server socket created on IP: '::'.
2022-02-15 3:10:01 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-02-15 3:10:01 0 [Note] InnoDB: Uses event mutexes
2022-02-15 3:10:01 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-02-15 3:10:01 0 [Note] InnoDB: Number of pools: 1
2022-02-15 3:10:01 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-02-15 3:10:01 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2022-02-15 3:10:01 0 [Note] InnoDB: Completed initialization of buffer pool
2022-02-15 3:10:01 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=300306
2022-02-15 3:10:01 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-02-15 3:10:01 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2022-02-15 3:10:01 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-02-15 3:10:01 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-02-15 3:10:01 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2022-02-15 3:10:01 0 [Note] InnoDB: Waiting for purge to start
2022-02-15 3:10:01 0 [Note] InnoDB: 10.4.22 started; log sequence number 300315; transaction id 170
2022-02-15 3:10:01 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2022-02-15 3:10:01 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-02-15 3:10:01 0 [Note] Server socket created on IP: '::'.
2022-02-15 16:39:01 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-02-15 16:39:01 0 [Note] InnoDB: Uses event mutexes
2022-02-15 16:39:01 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-02-15 16:39:01 0 [Note] InnoDB: Number of pools: 1
2022-02-15 16:39:01 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-02-15 16:39:01 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2022-02-15 16:39:01 0 [Note] InnoDB: Completed initialization of buffer pool
2022-02-15 16:39:01 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=1040798
2022-02-15 16:39:02 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-02-15 16:39:02 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2022-02-15 16:39:02 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-02-15 16:39:02 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-02-15 16:39:02 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2022-02-15 16:39:02 0 [Note] InnoDB: Waiting for purge to start
2022-02-15 16:39:02 0 [Note] InnoDB: 10.4.22 started; log sequence number 1040807; transaction id 728
2022-02-15 16:39:02 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-02-15 16:39:02 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2022-02-15 16:39:02 0 [Note] Server socket created on IP: '::'.
2022-02-15 16:55:47 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-02-15 16:55:47 0 [Note] InnoDB: Uses event mutexes
2022-02-15 16:55:47 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-02-15 16:55:47 0 [Note] InnoDB: Number of pools: 1
2022-02-15 16:55:47 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-02-15 16:55:47 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2022-02-15 16:55:47 0 [Note] InnoDB: Completed initialization of buffer pool
2022-02-15 16:55:47 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=1040816
2022-02-15 16:55:48 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-02-15 16:55:48 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2022-02-15 16:55:48 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-02-15 16:55:48 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-02-15 16:55:48 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2022-02-15 16:55:48 0 [Note] InnoDB: Waiting for purge to start
2022-02-15 16:55:48 0 [Note] InnoDB: 10.4.22 started; log sequence number 1040825; transaction id 728
2022-02-15 16:55:48 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2022-02-15 16:55:48 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-02-15 16:55:48 0 [Note] Server socket created on IP: '::'.
2022-02-15 16:58:55 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-02-15 16:58:55 0 [Note] InnoDB: Uses event mutexes
2022-02-15 16:58:55 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-02-15 16:58:55 0 [Note] InnoDB: Number of pools: 1
2022-02-15 16:58:55 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-02-15 16:58:55 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2022-02-15 16:58:55 0 [Note] InnoDB: Completed initialization of buffer pool
2022-02-15 16:58:55 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=1040834
2022-02-15 16:58:55 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-02-15 16:58:55 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2022-02-15 16:58:55 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-02-15 16:58:55 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-02-15 16:58:55 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2022-02-15 16:58:55 0 [Note] InnoDB: Waiting for purge to start
2022-02-15 16:58:56 0 [Note] InnoDB: 10.4.22 started; log sequence number 1040843; transaction id 728
2022-02-15 16:58:56 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2022-02-15 16:58:56 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-02-15 16:58:56 0 [Note] Server socket created on IP: '::'.
2022-02-15 17:00:02 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-02-15 17:00:02 0 [Note] InnoDB: Uses event mutexes
2022-02-15 17:00:02 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-02-15 17:00:02 0 [Note] InnoDB: Number of pools: 1
2022-02-15 17:00:02 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-02-15 17:00:02 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2022-02-15 17:00:02 0 [Note] InnoDB: Completed initialization of buffer pool
2022-02-15 17:00:02 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=1040852
2022-02-15 17:00:02 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-02-15 17:00:02 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2022-02-15 17:00:02 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-02-15 17:00:02 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-02-15 17:00:02 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2022-02-15 17:00:02 0 [Note] InnoDB: Waiting for purge to start
2022-02-15 17:00:02 0 [Note] InnoDB: 10.4.22 started; log sequence number 1040861; transaction id 728
2022-02-15 17:00:02 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2022-02-15 17:00:02 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-02-15 17:00:02 0 [Note] Server socket created on IP: '::'.
2022-02-15 17:11:24 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-02-15 17:11:24 0 [Note] InnoDB: Uses event mutexes
2022-02-15 17:11:24 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-02-15 17:11:24 0 [Note] InnoDB: Number of pools: 1
2022-02-15 17:11:24 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-02-15 17:11:24 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2022-02-15 17:11:24 0 [Note] InnoDB: Completed initialization of buffer pool
2022-02-15 17:11:24 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=1040870
2022-02-15 17:11:25 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-02-15 17:11:25 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2022-02-15 17:11:25 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-02-15 17:11:25 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-02-15 17:11:25 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2022-02-15 17:11:25 0 [Note] InnoDB: Waiting for purge to start
2022-02-15 17:11:25 0 [Note] InnoDB: 10.4.22 started; log sequence number 1040879; transaction id 728
2022-02-15 17:11:25 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2022-02-15 17:11:25 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-02-15 17:11:25 0 [Note] Server socket created on IP: '::'.
2022-02-16 17:31:07 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-02-16 17:31:07 0 [Note] InnoDB: Uses event mutexes
2022-02-16 17:31:07 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-02-16 17:31:07 0 [Note] InnoDB: Number of pools: 1
2022-02-16 17:31:07 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-02-16 17:31:07 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2022-02-16 17:31:07 0 [Note] InnoDB: Completed initialization of buffer pool
2022-02-16 17:31:07 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=8922876
2022-02-16 17:31:09 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-02-16 17:31:09 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2022-02-16 17:31:09 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-02-16 17:31:09 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-02-16 17:31:09 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2022-02-16 17:31:09 0 [Note] InnoDB: Waiting for purge to start
2022-02-16 17:31:09 0 [Note] InnoDB: 10.4.22 started; log sequence number 8922885; transaction id 3771
2022-02-16 17:31:09 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2022-02-16 17:31:09 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-02-16 17:31:09 0 [Note] Server socket created on IP: '::'.
2022-02-17 1:02:56 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-02-17 1:02:56 0 [Note] InnoDB: Uses event mutexes
2022-02-17 1:02:56 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-02-17 1:02:56 0 [Note] InnoDB: Number of pools: 1
2022-02-17 1:02:56 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-02-17 1:02:56 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2022-02-17 1:02:56 0 [Note] InnoDB: Completed initialization of buffer pool
2022-02-17 1:02:56 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=9638262
2022-02-17 1:02:57 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-02-17 1:02:57 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2022-02-17 1:02:57 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-02-17 1:02:57 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-02-17 1:02:57 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2022-02-17 1:02:57 0 [Note] InnoDB: Waiting for purge to start
2022-02-17 1:02:57 0 [Note] InnoDB: 10.4.22 started; log sequence number 9638271; transaction id 4448
2022-02-17 1:02:57 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2022-02-17 1:02:57 0 [Note] Plugin 'FEEDBACK' is disabled.
MySQL. Please close it to get rid of this error.
2022-03-29 20:05:06 0 [ERROR] InnoDB: Operating system error number 32 in a file operation.
2022-03-29 20:05:06 0 [ERROR] InnoDB: The error means that another program is using InnoDB's files. This might be a backup or antivirus software or another instance of MySQL. Please close it to get rid of this error.
2022-03-29 20:05:16 0 [ERROR] InnoDB: Operating system error number 32 in a file operation.
2022-03-29 20:05:16 0 [ERROR] InnoDB: The error means that another program is using InnoDB's files. This might be a backup or antivirus software or another instance of MySQL. Please close it to get rid of this error.
mak1
 
Posts: 1
Joined: 30. March 2022 14:00
XAMPP version: 3.3.0
Operating System: windows 10

Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 170 guests