MySQL won't start

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

MySQL won't start

Postby tokenbritishguy » 27. November 2019 13:50

Hey,

For some reason My SQL server will not start when I press start on the control panel. It has worked previously. please find attached my log.

[code
InnoDB: using atomic writes.
2019-10-27 11:31:39 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-10-27 11:31:39 0 [Note] InnoDB: Uses event mutexes
2019-10-27 11:31:39 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-10-27 11:31:39 0 [Note] InnoDB: Number of pools: 1
2019-10-27 11:31:39 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-10-27 11:31:39 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-10-27 11:31:39 0 [Note] InnoDB: Completed initialization of buffer pool
2019-10-27 11:31:39 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=300288
2019-10-27 11:31:43 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-10-27 11:31:43 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-10-27 11:31:43 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-10-27 11:31:43 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-10-27 11:31:43 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-10-27 11:31:43 0 [Note] InnoDB: Waiting for purge to start
2019-10-27 11:31:44 0 [Note] InnoDB: 10.4.8 started; log sequence number 300297; transaction id 171
2019-10-27 11:31:44 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2019-10-27 11:31:44 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-10-27 11:31:44 0 [Note] Server socket created on IP: '::'.
2019-10-27 11:31:44 0 [Note] InnoDB: Buffer pool(s) load completed at 191027 11:31:44
2019-10-27 11:31:47 0 [Note] Reading of all Master_info entries succeeded
2019-10-27 11:31:47 0 [Note] Added new Master_info '' to hash table
2019-10-27 11:31:47 0 [Note] mysql\bin\mysqld.exe: ready for connections.
Version: '10.4.8-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
InnoDB: using atomic writes.
2019-10-28 0:42:19 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-10-28 0:42:19 0 [Note] InnoDB: Uses event mutexes
2019-10-28 0:42:19 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-10-28 0:42:19 0 [Note] InnoDB: Number of pools: 1
2019-10-28 0:42:19 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-10-28 0:42:19 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-10-28 0:42:19 0 [Note] InnoDB: Completed initialization of buffer pool
2019-10-28 0:42:20 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=300306
2019-10-28 0:42:24 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-10-28 0:42:24 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-10-28 0:42:24 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-10-28 0:42:24 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-10-28 0:42:24 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-10-28 0:42:24 0 [Note] InnoDB: Waiting for purge to start
2019-10-28 0:42:24 0 [Note] InnoDB: Waiting for purge to start
2019-10-28 0:42:24 0 [Note] InnoDB: 10.4.8 started; log sequence number 300315; transaction id 171
2019-10-28 0:42:24 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2019-10-28 0:42:24 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-10-28 0:42:24 0 [Note] InnoDB: Buffer pool(s) load completed at 191028 0:42:24
2019-10-28 0:42:24 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2019-10-29 15:01:11 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-10-29 15:01:11 0 [Note] InnoDB: Uses event mutexes
2019-10-29 15:01:11 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-10-29 15:01:11 0 [Note] InnoDB: Number of pools: 1
2019-10-29 15:01:11 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-10-29 15:01:11 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-10-29 15:01:11 0 [Note] InnoDB: Completed initialization of buffer pool
2019-10-29 15:01:12 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=300324
2019-10-29 15:01:16 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-10-29 15:01:16 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-10-29 15:01:16 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-10-29 15:01:16 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-10-29 15:01:16 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-10-29 15:01:16 0 [Note] InnoDB: Waiting for purge to start
2019-10-29 15:01:16 0 [Note] InnoDB: Waiting for purge to start
2019-10-29 15:01:16 0 [Note] InnoDB: 10.4.8 started; log sequence number 300333; transaction id 171
2019-10-29 15:01:17 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2019-10-29 15:01:17 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-10-29 15:01:17 0 [Note] InnoDB: Buffer pool(s) load completed at 191029 15:01:17
2019-10-29 15:01:17 0 [Note] Server socket created on IP: '::'.
2019-10-29 15:01:20 0 [Note] Reading of all Master_info entries succeeded
2019-10-29 15:01:20 0 [Note] Added new Master_info '' to hash table
2019-10-29 15:01:20 0 [Note] mysql\bin\mysqld.exe: ready for connections.
Version: '10.4.8-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
InnoDB: using atomic writes.
2019-10-31 19:20:42 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-10-31 19:20:42 0 [Note] InnoDB: Uses event mutexes
2019-10-31 19:20:42 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-10-31 19:20:42 0 [Note] InnoDB: Number of pools: 1
2019-10-31 19:20:42 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-10-31 19:20:42 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-10-31 19:20:42 0 [Note] InnoDB: Completed initialization of buffer pool
2019-10-31 19:20:43 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=300342
2019-10-31 19:20:47 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-10-31 19:20:47 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-10-31 19:20:47 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-10-31 19:20:47 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-10-31 19:20:47 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-10-31 19:20:47 0 [Note] InnoDB: Waiting for purge to start
2019-10-31 19:20:47 0 [Note] InnoDB: 10.4.8 started; log sequence number 300351; transaction id 171
2019-10-31 19:20:47 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2019-10-31 19:20:47 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-10-31 19:20:48 0 [Note] Server socket created on IP: '::'.
2019-10-31 19:20:48 0 [Note] InnoDB: Buffer pool(s) load completed at 191031 19:20:48
InnoDB: using atomic writes.
2019-11-04 13:18:45 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-11-04 13:18:45 0 [Note] InnoDB: Uses event mutexes
2019-11-04 13:18:45 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-11-04 13:18:45 0 [Note] InnoDB: Number of pools: 1
2019-11-04 13:18:45 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-11-04 13:18:45 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-11-04 13:18:45 0 [Note] InnoDB: Completed initialization of buffer pool
2019-11-04 13:18:45 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=300360
2019-11-04 13:18:46 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-11-04 13:18:46 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-11-04 13:18:46 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-11-04 13:18:46 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-11-04 13:18:46 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-11-04 13:18:46 0 [Note] InnoDB: Waiting for purge to start
2019-11-04 13:18:46 0 [Note] InnoDB: 10.4.8 started; log sequence number 300369; transaction id 171
2019-11-04 13:18:46 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2019-11-04 13:18:46 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-11-04 13:18:46 0 [Note] InnoDB: Buffer pool(s) load completed at 191104 13:18:46
2019-11-04 13:18:46 0 [Note] Server socket created on IP: '::'.
2019-11-05 1:34:17 0 [Note] mysqld.exe: Aria engine: starting recovery
recovered pages: 0% 14% 57% 84% 95% 100% (0.2 seconds); tables to flush: 2 1 0
(0.2 seconds);
2019-11-05 1:34:17 0 [Note] mysqld.exe: Aria engine: recovery done
InnoDB: using atomic writes.
2019-11-05 1:34:17 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-11-05 1:34:17 0 [Note] InnoDB: Uses event mutexes
2019-11-05 1:34:17 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-11-05 1:34:17 0 [Note] InnoDB: Number of pools: 1
2019-11-05 1:34:17 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-11-05 1:34:17 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-11-05 1:34:17 0 [Note] InnoDB: Completed initialization of buffer pool
2019-11-05 1:34:17 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=426287
2019-11-05 1:34:19 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-11-05 1:34:19 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-11-05 1:34:19 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-11-05 1:34:19 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-11-05 1:34:19 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-11-05 1:34:19 0 [Note] InnoDB: Waiting for purge to start
2019-11-05 1:34:19 0 [Note] InnoDB: Waiting for purge to start
2019-11-05 1:34:20 0 [Note] InnoDB: Waiting for purge to start
2019-11-05 1:34:20 0 [Note] InnoDB: Waiting for purge to start
2019-11-05 1:34:20 0 [Note] InnoDB: Waiting for purge to start
2019-11-05 1:34:20 0 [Note] InnoDB: 10.4.8 started; log sequence number 426296; transaction id 419
2019-11-05 1:34:20 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2019-11-05 1:34:20 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-11-05 1:34:20 0 [Note] InnoDB: Buffer pool(s) load completed at 191105 1:34:20
2019-11-05 1:34:20 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2019-11-05 18:19:25 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-11-05 18:19:25 0 [Note] InnoDB: Uses event mutexes
2019-11-05 18:19:25 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-11-05 18:19:25 0 [Note] InnoDB: Number of pools: 1
2019-11-05 18:19:25 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-11-05 18:19:25 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-11-05 18:19:25 0 [Note] InnoDB: Completed initialization of buffer pool
2019-11-05 18:19:26 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=471688
2019-11-05 18:19:27 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-11-05 18:19:27 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-11-05 18:19:27 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-11-05 18:19:27 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-11-05 18:19:27 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-11-05 18:19:27 0 [Note] InnoDB: Waiting for purge to start
2019-11-05 18:19:27 0 [Note] InnoDB: 10.4.8 started; log sequence number 471697; transaction id 552
2019-11-05 18:19:27 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2019-11-05 18:19:27 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-11-05 18:19:27 0 [Note] InnoDB: Buffer pool(s) load completed at 191105 18:19:27
2019-11-05 18:19:27 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2019-11-05 21:13:24 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-11-05 21:13:24 0 [Note] InnoDB: Uses event mutexes
2019-11-05 21:13:24 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-11-05 21:13:24 0 [Note] InnoDB: Number of pools: 1
2019-11-05 21:13:24 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-11-05 21:13:24 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-11-05 21:13:24 0 [Note] InnoDB: Completed initialization of buffer pool
2019-11-05 21:13:24 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=472016
2019-11-05 21:13:25 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-11-05 21:13:25 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-11-05 21:13:25 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-11-05 21:13:25 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-11-05 21:13:25 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-11-05 21:13:25 0 [Note] InnoDB: Waiting for purge to start
2019-11-05 21:13:25 0 [Note] InnoDB: 10.4.8 started; log sequence number 472025; transaction id 565
2019-11-05 21:13:25 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2019-11-05 21:13:25 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-11-05 21:13:25 0 [Note] InnoDB: Buffer pool(s) load completed at 191105 21:13:25
2019-11-05 21:13:25 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2019-11-06 17:11:31 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-11-06 17:11:31 0 [Note] InnoDB: Uses event mutexes
2019-11-06 17:11:31 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-11-06 17:11:31 0 [Note] InnoDB: Number of pools: 1
2019-11-06 17:11:31 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-11-06 17:11:31 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-11-06 17:11:31 0 [Note] InnoDB: Completed initialization of buffer pool
2019-11-06 17:11:32 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=473270
2019-11-06 17:11:33 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-11-06 17:11:33 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-11-06 17:11:33 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-11-06 17:11:33 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-11-06 17:11:33 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-11-06 17:11:33 0 [Note] InnoDB: Waiting for purge to start
2019-11-06 17:11:33 0 [Note] InnoDB: 10.4.8 started; log sequence number 473279; transaction id 583
2019-11-06 17:11:33 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2019-11-06 17:11:33 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-11-06 17:11:33 0 [Note] InnoDB: Buffer pool(s) load completed at 191106 17:11:33
2019-11-06 17:11:34 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2019-11-08 14:19:34 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-11-08 14:19:34 0 [Note] InnoDB: Uses event mutexes
2019-11-08 14:19:34 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-11-08 14:19:34 0 [Note] InnoDB: Number of pools: 1
2019-11-08 14:19:34 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-11-08 14:19:35 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-11-08 14:19:35 0 [Note] InnoDB: Completed initialization of buffer pool
2019-11-08 14:19:35 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=473288
2019-11-08 14:19:38 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-11-08 14:19:38 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-11-08 14:19:38 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-11-08 14:19:38 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-11-08 14:19:38 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-11-08 14:19:38 0 [Note] InnoDB: Waiting for purge to start
2019-11-08 14:19:38 0 [Note] InnoDB: 10.4.8 started; log sequence number 473297; transaction id 583
2019-11-08 14:19:38 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2019-11-08 14:19:38 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-11-08 14:19:38 0 [Note] InnoDB: Buffer pool(s) load completed at 191108 14:19:38
2019-11-08 14:19:38 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2019-11-12 13:40:00 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-11-12 13:40:00 0 [Note] InnoDB: Uses event mutexes
2019-11-12 13:40:00 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-11-12 13:40:00 0 [Note] InnoDB: Number of pools: 1
2019-11-12 13:40:00 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-11-12 13:40:00 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-11-12 13:40:00 0 [Note] InnoDB: Completed initialization of buffer pool
2019-11-12 13:40:01 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=473306
2019-11-12 13:40:03 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-11-12 13:40:03 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-11-12 13:40:03 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-11-12 13:40:03 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-11-12 13:40:03 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-11-12 13:40:03 0 [Note] InnoDB: Waiting for purge to start
2019-11-12 13:40:03 0 [Note] InnoDB: 10.4.8 started; log sequence number 473315; transaction id 583
2019-11-12 13:40:03 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2019-11-12 13:40:03 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-11-12 13:40:03 0 [Note] InnoDB: Buffer pool(s) load completed at 191112 13:40:03
2019-11-12 13:40:03 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2019-11-22 19:01:21 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-11-22 19:01:21 0 [Note] InnoDB: Uses event mutexes
2019-11-22 19:01:21 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-11-22 19:01:21 0 [Note] InnoDB: Number of pools: 1
2019-11-22 19:01:21 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-11-22 19:01:21 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-11-22 19:01:21 0 [Note] InnoDB: Completed initialization of buffer pool
2019-11-22 19:01:22 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=500942
2019-11-22 19:01:24 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-11-22 19:01:24 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-11-22 19:01:24 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-11-22 19:01:24 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-11-22 19:01:24 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-11-22 19:01:24 0 [Note] InnoDB: Waiting for purge to start
2019-11-22 19:01:24 0 [Note] InnoDB: Waiting for purge to start
2019-11-22 19:01:24 0 [Note] InnoDB: 10.4.8 started; log sequence number 500951; transaction id 652
2019-11-22 19:01:24 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2019-11-22 19:01:24 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-11-22 19:01:24 0 [Note] InnoDB: Buffer pool(s) load completed at 191122 19:01:24
2019-11-22 19:01:24 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2019-11-25 13:55:45 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-11-25 13:55:45 0 [Note] InnoDB: Uses event mutexes
2019-11-25 13:55:45 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-11-25 13:55:45 0 [Note] InnoDB: Number of pools: 1
2019-11-25 13:55:45 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-11-25 13:55:45 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-11-25 13:55:45 0 [Note] InnoDB: Completed initialization of buffer pool
2019-11-25 13:55:45 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=500960
2019-11-25 13:55:48 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-11-25 13:55:48 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-11-25 13:55:48 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-11-25 13:55:48 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-11-25 13:55:48 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-11-25 13:55:48 0 [Note] InnoDB: Waiting for purge to start
2019-11-25 13:55:48 0 [Note] InnoDB: Waiting for purge to start
2019-11-25 13:55:48 0 [Note] InnoDB: 10.4.8 started; log sequence number 500969; transaction id 652
2019-11-25 13:55:48 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2019-11-25 13:55:48 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-11-25 13:55:48 0 [Note] InnoDB: Buffer pool(s) load completed at 191125 13:55:48
2019-11-25 13:55:48 0 [Note] Server socket created on IP: '::'.


][/code]
tokenbritishguy
 
Posts: 1
Joined: 27. November 2019 13:46
XAMPP version: 3.2.4
Operating System: Windows 10

Re: MySQL won't start

Postby davexsoia » 03. December 2019 20:13

Hello! Same problem as me... Apache works, but after a few seconds I have started MySQL, XAMPP control panel returns me:
Code: Select all
19:01:57  [mysql]   This may be due to a blocked port, missing dependencies,
19:01:57  [mysql]   improper privileges, a crash, or a shutdown by another method.
19:01:57  [mysql]   Press the Logs button to view error logs and check
19:01:57  [mysql]   the Windows Event Viewer for more clues
19:01:57  [mysql]   If you need more help, copy and post this
19:01:57  [mysql]   entire log window on the forums

and on the log mysql_error.log:
Code: Select all
2019-12-02 19:01:51 0 [Note] InnoDB: Uses event mutexes
2019-12-02 19:01:51 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-12-02 19:01:51 0 [Note] InnoDB: Number of pools: 1
2019-12-02 19:01:51 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-12-02 19:01:51 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-12-02 19:01:51 0 [Note] InnoDB: Completed initialization of buffer pool
2019-12-02 19:01:52 0 [Note] InnoDB: Resizing redo log from 2*50331648 to 2*5242880 bytes; LSN=795678
2019-12-02 19:01:52 0 [Note] InnoDB: Starting to delete and rewrite log files.
2019-12-02 19:01:52 0 [Note] InnoDB: Setting log file D:\xampp\mysql\data\ib_logfile101 size to 5242880 bytes
2019-12-02 19:01:52 0 [Note] InnoDB: Setting log file D:\xampp\mysql\data\ib_logfile1 size to 5242880 bytes
2019-12-02 19:01:52 0 [Note] InnoDB: Renaming log file D:\xampp\mysql\data\ib_logfile101 to D:\xampp\mysql\data\ib_logfile0
2019-12-02 19:01:52 0 [Note] InnoDB: New log files created, LSN=795678
2019-12-02 19:01:52 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-12-02 19:01:52 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-12-02 19:01:52 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-12-02 19:01:52 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-12-02 19:01:52 0 [Note] InnoDB: Waiting for purge to start
2019-12-02 19:01:52 0 [Note] InnoDB: 10.4.8 started; log sequence number 795678; transaction id 1046
2019-12-02 19:01:52 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool
2019-12-02 19:01:52 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-12-02 19:01:52 0 [Note] Server socket created on IP: '::'.

IDK what to do, I've also tryed disabling the Avira Firewal, deleting the ibdata1, checking the port scanner(Netstat) and changing the port on 3307, but it gives me the same error.. Thanks for the answers.
davexsoia
 
Posts: 1
Joined: 03. December 2019 20:07
XAMPP version: 3.2.4
Operating System: Windows


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 70 guests