Error: MySQL Shutdown Unexpectedly

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

Error: MySQL Shutdown Unexpectedly

Postby yarn1 » 15. November 2023 03:30

The error log that came with it is super long :(
Edit: Solved it, reinstalled XAMPP and gave it admin access to run sql and apache

2023-06-06 9:44:00 0 [Note] Starting MariaDB 10.4.28-MariaDB source revision c8f2e9a5c0ac5905f28b050b7df5a9ffd914b7e7 as process 11796
2023-06-06 9:44:00 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2023-06-06 9:44:00 0 [Note] InnoDB: Uses event mutexes
2023-06-06 9:44:00 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-06-06 9:44:00 0 [Note] InnoDB: Number of pools: 1
2023-06-06 9:44:00 0 [Note] InnoDB: Using SSE2 crc32 instructions
2023-06-06 9:44:00 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2023-06-06 9:44:00 0 [Note] InnoDB: Completed initialization of buffer pool
2023-06-06 9:44:00 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=300288
2023-06-06 9:44:00 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2023-06-06 9:44:00 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2023-06-06 9:44:00 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-06-06 9:44:00 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-06-06 9:44:00 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2023-06-06 9:44:00 0 [Note] InnoDB: Waiting for purge to start
2023-06-06 9:44:00 0 [Note] InnoDB: 10.4.28 started; log sequence number 300297; transaction id 170
2023-06-06 9:44:00 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-06-06 9:44:00 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2023-06-06 9:44:00 0 [Note] Server socket created on IP: '::'.
2023-07-04 9:38:57 0 [Note] Starting MariaDB 10.4.28-MariaDB source revision c8f2e9a5c0ac5905f28b050b7df5a9ffd914b7e7 as process 9488
2023-07-04 9:38:57 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2023-07-04 9:38:57 0 [Note] InnoDB: Uses event mutexes
2023-07-04 9:38:57 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-07-04 9:38:57 0 [Note] InnoDB: Number of pools: 1
2023-07-04 9:38:57 0 [Note] InnoDB: Using SSE2 crc32 instructions
2023-07-04 9:38:57 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2023-07-04 9:38:57 0 [Note] InnoDB: Completed initialization of buffer pool
2023-07-04 9:38:57 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=393566
2023-07-04 9:38:57 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2023-07-04 9:38:57 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2023-07-04 9:38:57 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-07-04 9:38:57 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-07-04 9:38:57 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2023-07-04 9:38:57 0 [Note] InnoDB: Waiting for purge to start
2023-07-04 9:38:57 0 [Note] InnoDB: 10.4.28 started; log sequence number 393575; transaction id 364
2023-07-04 9:38:57 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2023-07-04 9:38:57 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-07-04 9:38:57 0 [Note] InnoDB: Buffer pool(s) load completed at 230704 9:38:57
2023-07-04 9:38:57 0 [Note] Server socket created on IP: '::'.
2023-07-04 9:41:12 0 [Note] Starting MariaDB 10.4.28-MariaDB source revision c8f2e9a5c0ac5905f28b050b7df5a9ffd914b7e7 as process 41368
2023-07-04 9:41:12 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2023-07-04 9:41:12 0 [Note] InnoDB: Uses event mutexes
2023-07-04 9:41:12 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-07-04 9:41:12 0 [Note] InnoDB: Number of pools: 1
2023-07-04 9:41:12 0 [Note] InnoDB: Using SSE2 crc32 instructions
2023-07-04 9:41:12 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2023-07-04 9:41:12 0 [Note] InnoDB: Completed initialization of buffer pool
2023-07-04 9:41:12 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=393584
2023-07-04 9:41:12 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2023-07-04 9:41:12 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2023-07-04 9:41:12 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-07-04 9:41:12 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-07-04 9:41:12 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2023-07-04 9:41:12 0 [Note] InnoDB: Waiting for purge to start
2023-07-04 9:41:12 0 [Note] InnoDB: 10.4.28 started; log sequence number 393593; transaction id 364
2023-07-04 9:41:12 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2023-07-04 9:41:12 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-07-04 9:41:12 0 [Note] Server socket created on IP: '::'.
2023-07-18 11:32:56 0 [Note] Starting MariaDB 10.4.28-MariaDB source revision c8f2e9a5c0ac5905f28b050b7df5a9ffd914b7e7 as process 7068
2023-07-18 11:32:56 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2023-07-18 11:32:56 0 [Note] InnoDB: Uses event mutexes
2023-07-18 11:32:56 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-07-18 11:32:56 0 [Note] InnoDB: Number of pools: 1
2023-07-18 11:32:56 0 [Note] InnoDB: Using SSE2 crc32 instructions
2023-07-18 11:32:56 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2023-07-18 11:32:56 0 [Note] InnoDB: Completed initialization of buffer pool
2023-07-18 11:32:56 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=424707
2023-07-18 11:32:56 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2023-07-18 11:32:56 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2023-07-18 11:32:56 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-07-18 11:32:56 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-07-18 11:32:56 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2023-07-18 11:32:56 0 [Note] InnoDB: Waiting for purge to start
2023-07-18 11:32:56 0 [Note] InnoDB: 10.4.28 started; log sequence number 424716; transaction id 489
2023-07-18 11:32:56 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2023-07-18 11:32:56 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-07-18 11:32:56 0 [Note] InnoDB: Buffer pool(s) load completed at 230718 11:32:56
2023-07-18 11:32:56 0 [Note] Server socket created on IP: '::'.
2023-07-18 11:33:02 0 [Note] Starting MariaDB 10.4.28-MariaDB source revision c8f2e9a5c0ac5905f28b050b7df5a9ffd914b7e7 as process 20396
2023-07-18 11:33:02 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2023-07-18 11:33:02 0 [Note] InnoDB: Uses event mutexes
2023-07-18 11:33:02 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-07-18 11:33:02 0 [Note] InnoDB: Number of pools: 1
2023-07-18 11:33:02 0 [Note] InnoDB: Using SSE2 crc32 instructions
2023-07-18 11:33:02 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2023-07-18 11:33:02 0 [Note] InnoDB: Completed initialization of buffer pool
2023-07-18 11:33:02 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=424707
2023-07-18 11:33:02 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2023-07-18 11:33:02 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2023-07-18 11:33:02 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-07-18 11:33:02 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-07-18 11:33:02 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2023-07-18 11:33:02 0 [Note] InnoDB: Waiting for purge to start
2023-07-18 11:33:02 0 [Note] InnoDB: 10.4.28 started; log sequence number 424716; transaction id 489
2023-07-18 11:33:02 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2023-07-18 11:33:02 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-07-18 11:33:02 0 [Note] Server socket created on IP: '::'.
2023-08-01 10:04:11 0 [Note] Starting MariaDB 10.4.28-MariaDB source revision c8f2e9a5c0ac5905f28b050b7df5a9ffd914b7e7 as process 22712
2023-08-01 10:04:11 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2023-08-01 10:04:11 0 [Note] InnoDB: Uses event mutexes
2023-08-01 10:04:11 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-08-01 10:04:11 0 [Note] InnoDB: Number of pools: 1
2023-08-01 10:04:11 0 [Note] InnoDB: Using SSE2 crc32 instructions
2023-08-01 10:04:11 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2023-08-01 10:04:11 0 [Note] InnoDB: Completed initialization of buffer pool
2023-08-01 10:04:11 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=426612
2023-08-01 10:04:11 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2023-08-01 10:04:11 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2023-08-01 10:04:11 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-08-01 10:04:11 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-08-01 10:04:11 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2023-08-01 10:04:11 0 [Note] InnoDB: Waiting for purge to start
2023-08-01 10:04:11 0 [Note] InnoDB: 10.4.28 started; log sequence number 426621; transaction id 542
2023-08-01 10:04:11 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2023-08-01 10:04:11 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-08-01 10:04:11 0 [Note] InnoDB: Buffer pool(s) load completed at 230801 10:04:11
2023-08-01 10:04:11 0 [Note] Server socket created on IP: '::'.
2023-08-15 9:52:58 0 [Note] Starting MariaDB 10.4.28-MariaDB source revision c8f2e9a5c0ac5905f28b050b7df5a9ffd914b7e7 as process 12292
2023-08-15 9:52:58 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2023-08-15 9:52:58 0 [Note] InnoDB: Uses event mutexes
2023-08-15 9:52:58 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-08-15 9:52:58 0 [Note] InnoDB: Number of pools: 1
2023-08-15 9:52:58 0 [Note] InnoDB: Using SSE2 crc32 instructions
2023-08-15 9:52:58 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2023-08-15 9:52:58 0 [Note] InnoDB: Completed initialization of buffer pool
2023-08-15 9:52:58 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=433807
2023-08-15 9:52:58 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2023-08-15 9:52:58 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2023-08-15 9:52:58 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-08-15 9:52:58 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-08-15 9:52:58 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2023-08-15 9:52:58 0 [Note] InnoDB: Waiting for purge to start
2023-08-15 9:52:58 0 [Note] InnoDB: 10.4.28 started; log sequence number 433816; transaction id 611
2023-08-15 9:52:58 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2023-08-15 9:52:58 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-08-15 9:52:58 0 [Note] InnoDB: Buffer pool(s) load completed at 230815 9:52:58
2023-08-15 9:52:58 0 [Note] Server socket created on IP: '::'.
2023-08-15 9:53:00 0 [Note] Starting MariaDB 10.4.28-MariaDB source revision c8f2e9a5c0ac5905f28b050b7df5a9ffd914b7e7 as process 19396
2023-08-15 9:53:00 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2023-08-15 9:53:00 0 [Note] InnoDB: Uses event mutexes
2023-08-15 9:53:00 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-08-15 9:53:00 0 [Note] InnoDB: Number of pools: 1
2023-08-15 9:53:00 0 [Note] InnoDB: Using SSE2 crc32 instructions
2023-08-15 9:53:00 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2023-08-15 9:53:00 0 [Note] InnoDB: Completed initialization of buffer pool
2023-08-15 9:53:00 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=433807
2023-08-15 9:53:00 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2023-08-15 9:53:00 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2023-08-15 9:53:00 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-08-15 9:53:00 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-08-15 9:53:00 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2023-08-15 9:53:00 0 [Note] InnoDB: Waiting for purge to start
2023-08-15 9:53:00 0 [Note] InnoDB: 10.4.28 started; log sequence number 433816; transaction id 611
2023-08-15 9:53:00 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2023-08-15 9:53:00 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-08-15 9:53:00 0 [Note] Server socket created on IP: '::'.
2023-11-12 21:20:58 0 [Note] Starting MariaDB 10.4.28-MariaDB source revision c8f2e9a5c0ac5905f28b050b7df5a9ffd914b7e7 as process 8916
2023-11-12 21:20:58 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2023-11-12 21:20:58 0 [Note] InnoDB: Uses event mutexes
2023-11-12 21:20:58 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-11-12 21:20:58 0 [Note] InnoDB: Number of pools: 1
2023-11-12 21:20:58 0 [Note] InnoDB: Using SSE2 crc32 instructions
2023-11-12 21:20:58 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2023-11-12 21:20:58 0 [Note] InnoDB: Completed initialization of buffer pool
2023-11-12 21:20:58 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=476196
2023-11-12 21:20:58 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2023-11-12 21:20:58 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2023-11-12 21:20:58 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-11-12 21:20:58 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-11-12 21:20:58 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2023-11-12 21:20:58 0 [Note] InnoDB: Waiting for purge to start
2023-11-12 21:20:58 0 [Note] InnoDB: 10.4.28 started; log sequence number 476205; transaction id 783
2023-11-12 21:20:58 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2023-11-12 21:20:58 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-11-12 21:20:58 0 [Note] InnoDB: Buffer pool(s) load completed at 231112 21:20:58
2023-11-12 21:20:59 0 [Note] Server socket created on IP: '::'.
2023-11-12 22:24:30 0 [Note] Starting MariaDB 10.4.28-MariaDB source revision c8f2e9a5c0ac5905f28b050b7df5a9ffd914b7e7 as process 3208
2023-11-12 22:24:30 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2023-11-12 22:24:30 0 [Note] InnoDB: Uses event mutexes
2023-11-12 22:24:30 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-11-12 22:24:30 0 [Note] InnoDB: Number of pools: 1
2023-11-12 22:24:30 0 [Note] InnoDB: Using SSE2 crc32 instructions
2023-11-12 22:24:30 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2023-11-12 22:24:30 0 [Note] InnoDB: Completed initialization of buffer pool
2023-11-12 22:24:30 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=588236
2023-11-12 22:24:30 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2023-11-12 22:24:30 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2023-11-12 22:24:30 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-11-12 22:24:30 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-11-12 22:24:30 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2023-11-12 22:24:30 0 [Note] InnoDB: Waiting for purge to start
2023-11-12 22:24:30 0 [Note] InnoDB: 10.4.28 started; log sequence number 588245; transaction id 1071
2023-11-12 22:24:30 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2023-11-12 22:24:30 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-11-12 22:24:30 0 [Note] InnoDB: Buffer pool(s) load completed at 231112 22:24:30
2023-11-12 22:24:30 0 [Note] Server socket created on IP: '::'.
2023-11-12 22:24:30 0 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.

2023-11-12 22:24:30 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2023-11-12 22:24:30 0 [ERROR] Aborting
2023-11-12 22:24:36 0 [Note] Starting MariaDB 10.4.28-MariaDB source revision c8f2e9a5c0ac5905f28b050b7df5a9ffd914b7e7 as process 14652
2023-11-12 22:24:36 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2023-11-12 22:24:36 0 [Note] InnoDB: Uses event mutexes
2023-11-12 22:24:36 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-11-12 22:24:36 0 [Note] InnoDB: Number of pools: 1
2023-11-12 22:24:36 0 [Note] InnoDB: Using SSE2 crc32 instructions
2023-11-12 22:24:36 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2023-11-12 22:24:36 0 [Note] InnoDB: Completed initialization of buffer pool
2023-11-12 22:24:36 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2023-11-12 22:24:36 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-11-12 22:24:36 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-11-12 22:24:36 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2023-11-12 22:24:36 0 [Note] InnoDB: Waiting for purge to start
2023-11-12 22:24:36 0 [Note] InnoDB: 10.4.28 started; log sequence number 588254; transaction id 1071
2023-11-12 22:24:36 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2023-11-12 22:24:36 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-11-12 22:24:36 0 [Note] Server socket created on IP: '::'.
2023-11-12 22:24:36 0 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.

2023-11-12 22:24:36 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2023-11-12 22:24:36 0 [ERROR] Aborting
2023-11-12 22:25:06 0 [Note] Starting MariaDB 10.4.28-MariaDB source revision c8f2e9a5c0ac5905f28b050b7df5a9ffd914b7e7 as process 23152
2023-11-12 22:25:06 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2023-11-12 22:25:06 0 [Note] InnoDB: Uses event mutexes
2023-11-12 22:25:06 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-11-12 22:25:06 0 [Note] InnoDB: Number of pools: 1
2023-11-12 22:25:06 0 [Note] InnoDB: Using SSE2 crc32 instructions
2023-11-12 22:25:06 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2023-11-12 22:25:06 0 [Note] InnoDB: Completed initialization of buffer pool
2023-11-12 22:25:06 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2023-11-12 22:25:06 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-11-12 22:25:06 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-11-12 22:25:06 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2023-11-12 22:25:06 0 [Note] InnoDB: Waiting for purge to start
2023-11-12 22:25:06 0 [Note] InnoDB: 10.4.28 started; log sequence number 588263; transaction id 1071
2023-11-12 22:25:06 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2023-11-12 22:25:06 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-11-12 22:25:06 0 [Note] InnoDB: Buffer pool(s) load completed at 231112 22:25:06
2023-11-12 22:25:06 0 [Note] Server socket created on IP: '::'.
2023-11-12 22:25:06 0 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.

2023-11-12 22:25:06 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2023-11-12 22:25:06 0 [ERROR] Aborting
2023-11-12 22:26:00 0 [Note] Starting MariaDB 10.4.28-MariaDB source revision c8f2e9a5c0ac5905f28b050b7df5a9ffd914b7e7 as process 7992
2023-11-12 22:26:00 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2023-11-12 22:26:00 0 [Note] InnoDB: Uses event mutexes
2023-11-12 22:26:00 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-11-12 22:26:00 0 [Note] InnoDB: Number of pools: 1
2023-11-12 22:26:00 0 [Note] InnoDB: Using SSE2 crc32 instructions
2023-11-12 22:26:00 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2023-11-12 22:26:00 0 [Note] InnoDB: Completed initialization of buffer pool
2023-11-12 22:26:00 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2023-11-12 22:26:00 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-11-12 22:26:00 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-11-12 22:26:00 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2023-11-12 22:26:00 0 [Note] InnoDB: Waiting for purge to start
2023-11-12 22:26:01 0 [Note] InnoDB: 10.4.28 started; log sequence number 588272; transaction id 1071
2023-11-12 22:26:01 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2023-11-12 22:26:01 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-11-12 22:26:01 0 [Note] Server socket created on IP: '::'.
2023-11-12 22:26:01 0 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.

2023-11-12 22:26:01 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2023-11-12 22:26:01 0 [ERROR] Aborting
2023-11-12 22:27:55 0 [Note] Starting MariaDB 10.4.28-MariaDB source revision c8f2e9a5c0ac5905f28b050b7df5a9ffd914b7e7 as process 17956
2023-11-12 22:27:55 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2023-11-12 22:27:55 0 [Note] InnoDB: Uses event mutexes
2023-11-12 22:27:55 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-11-12 22:27:55 0 [Note] InnoDB: Number of pools: 1
2023-11-12 22:27:55 0 [Note] InnoDB: Using SSE2 crc32 instructions
2023-11-12 22:27:55 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2023-11-12 22:27:55 0 [Note] InnoDB: Completed initialization of buffer pool
2023-11-12 22:27:55 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2023-11-12 22:27:55 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-11-12 22:27:55 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-11-12 22:27:55 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2023-11-12 22:27:55 0 [Note] InnoDB: Waiting for purge to start
2023-11-12 22:27:55 0 [Note] InnoDB: 10.4.28 started; log sequence number 588281; transaction id 1071
2023-11-12 22:27:55 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2023-11-12 22:27:55 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-11-12 22:27:55 0 [Note] InnoDB: Buffer pool(s) load completed at 231112 22:27:55
2023-11-12 22:27:55 0 [Note] Server socket created on IP: '::'.
2023-11-15 9:59:53 0 [Note] Starting MariaDB 10.4.28-MariaDB source revision c8f2e9a5c0ac5905f28b050b7df5a9ffd914b7e7 as process 16952
2023-11-15 9:59:53 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2023-11-15 9:59:53 0 [Note] InnoDB: Uses event mutexes
2023-11-15 9:59:53 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-11-15 9:59:53 0 [Note] InnoDB: Number of pools: 1
2023-11-15 9:59:53 0 [Note] InnoDB: Using SSE2 crc32 instructions
2023-11-15 9:59:53 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2023-11-15 9:59:53 0 [Note] InnoDB: Completed initialization of buffer pool
2023-11-15 9:59:53 0 [ERROR] InnoDB: Page [page id: space=0, page number=198] log sequence number 588547 is in the future! Current system log sequence number 588306.
2023-11-15 9:59:53 0 [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.
2023-11-15 9:59:53 0 [ERROR] InnoDB: Page [page id: space=0, page number=335] log sequence number 588547 is in the future! Current system log sequence number 588306.
2023-11-15 9:59:53 0 [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.
2023-11-15 9:59:53 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2023-11-15 9:59:53 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2023-11-15 9:59:53 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-11-15 9:59:53 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-11-15 9:59:53 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2023-11-15 9:59:53 0 [Note] InnoDB: Waiting for purge to start
2023-11-15 9:59:53 4 [ERROR] InnoDB: Page [page id: space=16, page number=3] log sequence number 588567 is in the future! Current system log sequence number 588306.
2023-11-15 9:59:53 4 [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.
2023-11-15 9:59:54 0 [Note] InnoDB: 10.4.28 started; log sequence number 588281; transaction id 1099
2023-11-15 9:59:54 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2023-11-15 9:59:54 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-11-15 9:59:54 0 [Note] InnoDB: Buffer pool(s) load completed at 231115 9:59:54
2023-11-15 9:59:54 0 [Note] Server socket created on IP: '::'.
2023-11-15 10:04:35 0 [Note] Starting MariaDB 10.4.28-MariaDB source revision c8f2e9a5c0ac5905f28b050b7df5a9ffd914b7e7 as process 2752
2023-11-15 10:04:35 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2023-11-15 10:04:35 0 [Note] InnoDB: Uses event mutexes
2023-11-15 10:04:35 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-11-15 10:04:35 0 [Note] InnoDB: Number of pools: 1
2023-11-15 10:04:35 0 [Note] InnoDB: Using SSE2 crc32 instructions
2023-11-15 10:04:35 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2023-11-15 10:04:35 0 [Note] InnoDB: Completed initialization of buffer pool
2023-11-15 10:04:35 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=588281
2023-11-15 10:04:35 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=335] with future log sequence number 588547
2023-11-15 10:04:35 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=16, page number=3] with future log sequence number 588567
2023-11-15 10:04:35 0 [ERROR] InnoDB: Page [page id: space=0, page number=198] log sequence number 588547 is in the future! Current system log sequence number 588315.
2023-11-15 10:04:35 0 [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.
2023-11-15 10:04:35 0 [ERROR] InnoDB: Page [page id: space=0, page number=335] log sequence number 588547 is in the future! Current system log sequence number 588315.
2023-11-15 10:04:35 0 [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.
2023-11-15 10:04:36 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2023-11-15 10:04:36 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2023-11-15 10:04:36 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-11-15 10:04:36 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-11-15 10:04:36 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2023-11-15 10:04:36 0 [Note] InnoDB: Waiting for purge to start
2023-11-15 10:04:36 2 [ERROR] InnoDB: Page [page id: space=16, page number=3] log sequence number 588567 is in the future! Current system log sequence number 588315.
2023-11-15 10:04:36 2 [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.
2023-11-15 10:04:36 0 [Note] InnoDB: 10.4.28 started; log sequence number 588306; transaction id 1099
2023-11-15 10:04:36 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2023-11-15 10:04:36 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-11-15 10:04:36 0 [Note] Server socket created on IP: '::'.
2023-11-15 10:08:43 0 [Note] Starting MariaDB 10.4.28-MariaDB source revision c8f2e9a5c0ac5905f28b050b7df5a9ffd914b7e7 as process 24828
2023-11-15 10:08:43 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2023-11-15 10:08:43 0 [Note] InnoDB: Uses event mutexes
2023-11-15 10:08:43 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-11-15 10:08:43 0 [Note] InnoDB: Number of pools: 1
2023-11-15 10:08:43 0 [Note] InnoDB: Using SSE2 crc32 instructions
2023-11-15 10:08:43 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2023-11-15 10:08:43 0 [Note] InnoDB: Completed initialization of buffer pool
2023-11-15 10:08:43 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=588315
2023-11-15 10:08:43 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=335] with future log sequence number 588547
2023-11-15 10:08:43 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=16, page number=3] with future log sequence number 588567
2023-11-15 10:08:43 0 [ERROR] InnoDB: Page [page id: space=0, page number=198] log sequence number 588547 is in the future! Current system log sequence number 588333.
2023-11-15 10:08:43 0 [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.
2023-11-15 10:08:43 0 [ERROR] InnoDB: Page [page id: space=0, page number=335] log sequence number 588547 is in the future! Current system log sequence number 588333.
2023-11-15 10:08:43 0 [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.
2023-11-15 10:08:43 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2023-11-15 10:08:43 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2023-11-15 10:08:43 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-11-15 10:08:43 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-11-15 10:08:43 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2023-11-15 10:08:43 0 [Note] InnoDB: Waiting for purge to start
2023-11-15 10:08:43 3 [ERROR] InnoDB: Page [page id: space=16, page number=3] log sequence number 588567 is in the future! Current system log sequence number 588333.
2023-11-15 10:08:43 3 [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.
2023-11-15 10:08:43 0 [Note] InnoDB: 10.4.28 started; log sequence number 588324; transaction id 1099
2023-11-15 10:08:43 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-11-15 10:08:43 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2023-11-15 10:08:43 0 [Note] InnoDB: Buffer pool(s) load completed at 231115 10:08:43
2023-11-15 10:08:43 0 [Note] Server socket created on IP: '::'.
2023-11-15 10:08:53 0 [Note] Starting MariaDB 10.4.28-MariaDB source revision c8f2e9a5c0ac5905f28b050b7df5a9ffd914b7e7 as process 25268
2023-11-15 10:08:53 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2023-11-15 10:08:53 0 [Note] InnoDB: Uses event mutexes
2023-11-15 10:08:53 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-11-15 10:08:53 0 [Note] InnoDB: Number of pools: 1
2023-11-15 10:08:53 0 [Note] InnoDB: Using SSE2 crc32 instructions
2023-11-15 10:08:53 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2023-11-15 10:08:53 0 [Note] InnoDB: Completed initialization of buffer pool
2023-11-15 10:08:53 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=588333
2023-11-15 10:08:53 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=335] with future log sequence number 588547
2023-11-15 10:08:53 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=16, page number=3] with future log sequence number 588567
2023-11-15 10:08:53 0 [ERROR] InnoDB: Page [page id: space=0, page number=198] log sequence number 588547 is in the future! Current system log sequence number 588351.
2023-11-15 10:08:53 0 [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.
2023-11-15 10:08:53 0 [ERROR] InnoDB: Page [page id: space=0, page number=335] log sequence number 588547 is in the future! Current system log sequence number 588351.
2023-11-15 10:08:53 0 [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.
2023-11-15 10:08:53 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2023-11-15 10:08:53 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2023-11-15 10:08:53 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-11-15 10:08:53 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-11-15 10:08:54 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2023-11-15 10:08:54 0 [Note] InnoDB: Waiting for purge to start
2023-11-15 10:08:54 4 [ERROR] InnoDB: Page [page id: space=16, page number=3] log sequence number 588567 is in the future! Current system log sequence number 588351.
2023-11-15 10:08:54 4 [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.
2023-11-15 10:08:54 0 [Note] InnoDB: 10.4.28 started; log sequence number 588342; transaction id 1099
2023-11-15 10:08:54 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2023-11-15 10:08:54 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-11-15 10:08:54 0 [Note] Server socket created on IP: '::'.
2023-11-15 10:09:31 0 [Note] Starting MariaDB 10.4.28-MariaDB source revision c8f2e9a5c0ac5905f28b050b7df5a9ffd914b7e7 as process 24500
2023-11-15 10:09:31 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2023-11-15 10:09:31 0 [Note] InnoDB: Uses event mutexes
2023-11-15 10:09:31 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-11-15 10:09:31 0 [Note] InnoDB: Number of pools: 1
2023-11-15 10:09:31 0 [Note] InnoDB: Using SSE2 crc32 instructions
2023-11-15 10:09:31 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2023-11-15 10:09:31 0 [Note] InnoDB: Completed initialization of buffer pool
2023-11-15 10:09:31 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=588351
2023-11-15 10:09:31 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=335] with future log sequence number 588547
2023-11-15 10:09:31 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=16, page number=3] with future log sequence number 588567
2023-11-15 10:09:31 0 [ERROR] InnoDB: Page [page id: space=0, page number=198] log sequence number 588547 is in the future! Current system log sequence number 588369.
2023-11-15 10:09:31 0 [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.
2023-11-15 10:09:31 0 [ERROR] InnoDB: Page [page id: space=0, page number=335] log sequence number 588547 is in the future! Current system log sequence number 588369.
2023-11-15 10:09:31 0 [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.
2023-11-15 10:09:31 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2023-11-15 10:09:31 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2023-11-15 10:09:31 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-11-15 10:09:31 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-11-15 10:09:31 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2023-11-15 10:09:31 0 [Note] InnoDB: Waiting for purge to start
2023-11-15 10:09:31 2 [ERROR] InnoDB: Page [page id: space=16, page number=3] log sequence number 588567 is in the future! Current system log sequence number 588369.
2023-11-15 10:09:31 2 [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.
2023-11-15 10:09:31 0 [Note] InnoDB: 10.4.28 started; log sequence number 588360; transaction id 1099
2023-11-15 10:09:31 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2023-11-15 10:09:31 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-11-15 10:09:31 0 [Note] Server socket created on IP: '::'.
2023-11-15 10:11:23 0 [Note] Starting MariaDB 10.4.28-MariaDB source revision c8f2e9a5c0ac5905f28b050b7df5a9ffd914b7e7 as process 20228
2023-11-15 10:11:23 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2023-11-15 10:11:23 0 [Note] InnoDB: Uses event mutexes
2023-11-15 10:11:23 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-11-15 10:11:23 0 [Note] InnoDB: Number of pools: 1
2023-11-15 10:11:23 0 [Note] InnoDB: Using SSE2 crc32 instructions
2023-11-15 10:11:23 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2023-11-15 10:11:23 0 [Note] InnoDB: Completed initialization of buffer pool
2023-11-15 10:11:23 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=588369
2023-11-15 10:11:23 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=335] with future log sequence number 588547
2023-11-15 10:11:23 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=16, page number=3] with future log sequence number 588567
2023-11-15 10:11:23 0 [ERROR] InnoDB: Page [page id: space=0, page number=198] log sequence number 588547 is in the future! Current system log sequence number 588387.
2023-11-15 10:11:23 0 [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.
2023-11-15 10:11:23 0 [ERROR] InnoDB: Page [page id: space=0, page number=335] log sequence number 588547 is in the future! Current system log sequence number 588387.
2023-11-15 10:11:23 0 [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.
2023-11-15 10:11:24 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2023-11-15 10:11:24 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2023-11-15 10:11:24 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-11-15 10:11:24 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-11-15 10:11:24 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2023-11-15 10:11:24 0 [Note] InnoDB: Waiting for purge to start
2023-11-15 10:11:24 4 [ERROR] InnoDB: Page [page id: space=16, page number=3] log sequence number 588567 is in the future! Current system log sequence number 588387.
2023-11-15 10:11:24 4 [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.
2023-11-15 10:11:24 0 [Note] InnoDB: 10.4.28 started; log sequence number 588378; transaction id 1099
2023-11-15 10:11:24 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2023-11-15 10:11:24 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-11-15 10:11:24 0 [Note] InnoDB: Buffer pool(s) load completed at 231115 10:11:24
2023-11-15 10:11:24 0 [Note] Server socket created on IP: '::'.
2023-11-15 10:15:31 0 [Note] Starting MariaDB 10.4.28-MariaDB source revision c8f2e9a5c0ac5905f28b050b7df5a9ffd914b7e7 as process 12200
2023-11-15 10:15:31 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2023-11-15 10:15:31 0 [Note] InnoDB: Uses event mutexes
2023-11-15 10:15:31 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-11-15 10:15:31 0 [Note] InnoDB: Number of pools: 1
2023-11-15 10:15:31 0 [Note] InnoDB: Using SSE2 crc32 instructions
2023-11-15 10:15:31 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2023-11-15 10:15:31 0 [Note] InnoDB: Completed initialization of buffer pool
2023-11-15 10:15:31 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=588387
2023-11-15 10:15:31 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=335] with future log sequence number 588547
2023-11-15 10:15:31 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=16, page number=3] with future log sequence number 588567
2023-11-15 10:15:31 0 [ERROR] InnoDB: Page [page id: space=0, page number=198] log sequence number 588547 is in the future! Current system log sequence number 588405.
2023-11-15 10:15:31 0 [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.
2023-11-15 10:15:31 0 [ERROR] InnoDB: Page [page id: space=0, page number=335] log sequence number 588547 is in the future! Current system log sequence number 588405.
2023-11-15 10:15:31 0 [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.
2023-11-15 10:15:32 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2023-11-15 10:15:32 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2023-11-15 10:15:32 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-11-15 10:15:32 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-11-15 10:15:32 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2023-11-15 10:15:32 0 [Note] InnoDB: Waiting for purge to start
2023-11-15 10:15:32 4 [ERROR] InnoDB: Page [page id: space=16, page number=3] log sequence number 588567 is in the future! Current system log sequence number 588405.
2023-11-15 10:15:32 4 [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.
2023-11-15 10:15:32 0 [Note] InnoDB: 10.4.28 started; log sequence number 588396; transaction id 1099
2023-11-15 10:15:32 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2023-11-15 10:15:32 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-11-15 10:15:32 0 [Note] Server socket created on IP: '::'.
2023-11-15 10:19:12 0 [Note] Starting MariaDB 10.4.28-MariaDB source revision c8f2e9a5c0ac5905f28b050b7df5a9ffd914b7e7 as process 13056
2023-11-15 10:19:12 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2023-11-15 10:19:12 0 [Note] InnoDB: Uses event mutexes
2023-11-15 10:19:12 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-11-15 10:19:12 0 [Note] InnoDB: Number of pools: 1
2023-11-15 10:19:12 0 [Note] InnoDB: Using SSE2 crc32 instructions
2023-11-15 10:19:12 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2023-11-15 10:19:12 0 [Note] InnoDB: Completed initialization of buffer pool
2023-11-15 10:19:12 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=588405
2023-11-15 10:19:12 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2023-11-15 10:19:12 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2023-11-15 10:19:12 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-11-15 10:19:12 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-11-15 10:19:12 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2023-11-15 10:19:12 0 [Note] InnoDB: Waiting for purge to start
2023-11-15 10:19:12 3 [ERROR] InnoDB: Page [page id: space=16, page number=3] log sequence number 588567 is in the future! Current system log sequence number 588423.
2023-11-15 10:19:12 3 [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.
2023-11-15 10:19:12 0 [Note] InnoDB: 10.4.28 started; log sequence number 588414; transaction id 170
2023-11-15 10:19:12 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2023-11-15 10:19:12 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-11-15 10:19:12 0 [Note] InnoDB: Buffer pool(s) load completed at 231115 10:19:12
2023-11-15 10:19:12 0 [Note] Server socket created on IP: '::'.
2023-11-15 10:19:26 0 [Note] Starting MariaDB 10.4.28-MariaDB source revision c8f2e9a5c0ac5905f28b050b7df5a9ffd914b7e7 as process 14916
2023-11-15 10:19:26 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2023-11-15 10:19:26 0 [Note] InnoDB: Uses event mutexes
2023-11-15 10:19:26 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-11-15 10:19:26 0 [Note] InnoDB: Number of pools: 1
2023-11-15 10:19:26 0 [Note] InnoDB: Using SSE2 crc32 instructions
2023-11-15 10:19:26 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2023-11-15 10:19:26 0 [Note] InnoDB: Completed initialization of buffer pool
2023-11-15 10:19:26 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=588423
2023-11-15 10:19:26 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2023-11-15 10:19:26 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2023-11-15 10:19:26 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-11-15 10:19:26 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-11-15 10:19:26 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2023-11-15 10:19:26 0 [Note] InnoDB: Waiting for purge to start
2023-11-15 10:19:26 4 [ERROR] InnoDB: Page [page id: space=16, page number=3] log sequence number 588567 is in the future! Current system log sequence number 588441.
2023-11-15 10:19:26 4 [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.
2023-11-15 10:19:26 0 [Note] InnoDB: 10.4.28 started; log sequence number 588432; transaction id 170
2023-11-15 10:19:26 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2023-11-15 10:19:26 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-11-15 10:19:26 0 [Note] Server socket created on IP: '::'.
yarn1
 
Posts: 1
Joined: 15. November 2023 03:25
XAMPP version: v3.3.0
Operating System: Windows 11 Home

Re: Error: MySQL Shutdown Unexpectedly

Postby ginisksam » 16. November 2023 04:04

It is happening to me too. Found out this working solution for me as temporary remedy:

1) Shutdown xampp
2) Copy "D:\xampp\mysql\data" to "D:\xampp\mysql\data-backup
3) Go to "D:\xampp\mysql\backup"
4) Copy these 8 files ( ignore ibdata1 !!) :
aria_log_control, ib_logfile1, ib_buffer_pool, my.ini, ibtmp1, aria_log.00000001, ib_logfile0 & multi-master.info
onto "D:\xampp\mysql\data" & over-right those files
5) Restart xampp with "Run As Administration"
6) Finger-crossed hope it will work for you.
Preventive immediately:
7) Go to phpmyadmin and Export your databases to SQL files for safekeeping

I have to do this now every time I end my coding session for fear the MySQL shutdown comes again and I repeat the above steps once more!

Good Luck
ginisksam
 
Posts: 2
Joined: 16. November 2023 03:47
XAMPP version: 3.3.0
Operating System: Win11


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 182 guests