SQL wont start up

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

SQL wont start up

Postby Nimkii » 25. April 2020 15:15

Code: Select all
InnoDB: using atomic writes.
2020-04-23 22:58:32 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-04-23 22:58:32 0 [Note] InnoDB: Uses event mutexes
2020-04-23 22:58:32 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-04-23 22:58:32 0 [Note] InnoDB: Number of pools: 1
2020-04-23 22:58:32 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-04-23 22:58:32 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-04-23 22:58:32 0 [Note] InnoDB: Completed initialization of buffer pool
2020-04-23 22:58:32 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=300288
2020-04-23 22:58:33 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-04-23 22:58:33 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-04-23 22:58:33 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-04-23 22:58:33 0 [Note] InnoDB: Setting file 'C:\xamppNEW\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-04-23 22:58:33 0 [Note] InnoDB: File 'C:\xamppNEW\mysql\data\ibtmp1' size is now 12 MB.
2020-04-23 22:58:33 0 [Note] InnoDB: Waiting for purge to start
2020-04-23 22:58:33 0 [Note] InnoDB: 10.4.11 started; log sequence number 300297; transaction id 171
2020-04-23 22:58:33 0 [Note] InnoDB: Loading buffer pool(s) from C:\xamppNEW\mysql\data\ib_buffer_pool
2020-04-23 22:58:33 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-04-23 22:58:33 0 [Note] Server socket created on IP: '::'.
2020-04-24 10:58:22 0 [Note] mysqld.exe: Aria engine: starting recovery
recovered pages: 0% 13% 56% 82% 95% 100% (0.1 seconds); tables to flush: 2 1 0
 (0.2 seconds);
2020-04-24 10:58:22 0 [Note] mysqld.exe: Aria engine: recovery done
InnoDB: using atomic writes.
2020-04-24 10:58:22 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-04-24 10:58:22 0 [Note] InnoDB: Uses event mutexes
2020-04-24 10:58:22 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-04-24 10:58:22 0 [Note] InnoDB: Number of pools: 1
2020-04-24 10:58:22 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-04-24 10:58:22 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-04-24 10:58:22 0 [Note] InnoDB: Completed initialization of buffer pool
2020-04-24 10:58:22 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=312475
2020-04-24 10:58:25 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-04-24 10:58:25 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-04-24 10:58:25 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-04-24 10:58:25 0 [Note] InnoDB: Setting file 'C:\xamppNEW\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-04-24 10:58:25 0 [Note] InnoDB: File 'C:\xamppNEW\mysql\data\ibtmp1' size is now 12 MB.
2020-04-24 10:58:25 0 [Note] InnoDB: 10.4.11 started; log sequence number 312484; transaction id 226
2020-04-24 10:58:25 0 [Note] InnoDB: Loading buffer pool(s) from C:\xamppNEW\mysql\data\ib_buffer_pool
2020-04-24 10:58:25 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-04-24 10:58:25 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2020-04-24 15:07:35 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-04-24 15:07:35 0 [Note] InnoDB: Uses event mutexes
2020-04-24 15:07:35 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-04-24 15:07:35 0 [Note] InnoDB: Number of pools: 1
2020-04-24 15:07:35 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-04-24 15:07:35 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-04-24 15:07:35 0 [Note] InnoDB: Completed initialization of buffer pool
2020-04-24 15:07:36 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=312493
2020-04-24 15:07:37 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-04-24 15:07:37 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-04-24 15:07:37 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-04-24 15:07:37 0 [Note] InnoDB: Setting file 'C:\xamppNEW\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-04-24 15:07:37 0 [Note] InnoDB: File 'C:\xamppNEW\mysql\data\ibtmp1' size is now 12 MB.
2020-04-24 15:07:37 0 [Note] InnoDB: Waiting for purge to start
2020-04-24 15:07:37 0 [Note] InnoDB: 10.4.11 started; log sequence number 312502; transaction id 226
2020-04-24 15:07:37 0 [Note] InnoDB: Loading buffer pool(s) from C:\xamppNEW\mysql\data\ib_buffer_pool
2020-04-24 15:07:37 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-04-24 15:07:37 0 [Note] InnoDB: Buffer pool(s) load completed at 200424 15:07:37
2020-04-24 15:07:37 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2020-04-24 22:54:41 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-04-24 22:54:41 0 [Note] InnoDB: Uses event mutexes
2020-04-24 22:54:41 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-04-24 22:54:41 0 [Note] InnoDB: Number of pools: 1
2020-04-24 22:54:41 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-04-24 22:54:41 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-04-24 22:54:41 0 [Note] InnoDB: Completed initialization of buffer pool
2020-04-24 22:54:41 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=312812
2020-04-24 22:54:42 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-04-24 22:54:42 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-04-24 22:54:42 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-04-24 22:54:42 0 [Note] InnoDB: Setting file 'C:\xamppNEW\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-04-24 22:54:42 0 [Note] InnoDB: File 'C:\xamppNEW\mysql\data\ibtmp1' size is now 12 MB.
2020-04-24 22:54:42 0 [Note] InnoDB: 10.4.11 started; log sequence number 312821; transaction id 250
2020-04-24 22:54:42 0 [Note] InnoDB: Loading buffer pool(s) from C:\xamppNEW\mysql\data\ib_buffer_pool
2020-04-24 22:54:42 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-04-24 22:54:42 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2020-04-25  8:14:40 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-04-25  8:14:40 0 [Note] InnoDB: Uses event mutexes
2020-04-25  8:14:40 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-04-25  8:14:40 0 [Note] InnoDB: Number of pools: 1
2020-04-25  8:14:40 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-04-25  8:14:40 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-04-25  8:14:40 0 [Note] InnoDB: Completed initialization of buffer pool
2020-04-25  8:14:40 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=313480
2020-04-25  8:14:41 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-04-25  8:14:41 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-04-25  8:14:41 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-04-25  8:14:41 0 [Note] InnoDB: Setting file 'C:\xamppNEW\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-04-25  8:14:41 0 [Note] InnoDB: File 'C:\xamppNEW\mysql\data\ibtmp1' size is now 12 MB.
2020-04-25  8:14:41 0 [Note] InnoDB: Waiting for purge to start
2020-04-25  8:14:41 0 [Note] InnoDB: 10.4.11 started; log sequence number 313489; transaction id 276
2020-04-25  8:14:41 0 [Note] InnoDB: Loading buffer pool(s) from C:\xamppNEW\mysql\data\ib_buffer_pool
2020-04-25  8:14:41 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-04-25  8:14:41 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2020-04-25 10:01:46 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-04-25 10:01:46 0 [Note] InnoDB: Uses event mutexes
2020-04-25 10:01:46 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-04-25 10:01:46 0 [Note] InnoDB: Number of pools: 1
2020-04-25 10:01:46 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-04-25 10:01:46 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-04-25 10:01:46 0 [Note] InnoDB: Completed initialization of buffer pool
2020-04-25 10:01:46 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=314607
2020-04-25 10:01:46 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-04-25 10:01:46 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-04-25 10:01:46 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-04-25 10:01:46 0 [Note] InnoDB: Setting file 'C:\xamppNEW\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-04-25 10:01:46 0 [Note] InnoDB: File 'C:\xamppNEW\mysql\data\ibtmp1' size is now 12 MB.
2020-04-25 10:01:46 0 [Note] InnoDB: Waiting for purge to start
2020-04-25 10:01:46 0 [Note] InnoDB: 10.4.11 started; log sequence number 314616; transaction id 302
2020-04-25 10:01:46 0 [Note] InnoDB: Loading buffer pool(s) from C:\xamppNEW\mysql\data\ib_buffer_pool
2020-04-25 10:01:46 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-04-25 10:01:47 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2020-04-25 10:02:32 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-04-25 10:02:32 0 [Note] InnoDB: Uses event mutexes
2020-04-25 10:02:32 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-04-25 10:02:32 0 [Note] InnoDB: Number of pools: 1
2020-04-25 10:02:32 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-04-25 10:02:32 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-04-25 10:02:32 0 [Note] InnoDB: Completed initialization of buffer pool
2020-04-25 10:02:32 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=314625
2020-04-25 10:02:32 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-04-25 10:02:32 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-04-25 10:02:32 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-04-25 10:02:32 0 [Note] InnoDB: Setting file 'C:\xamppNEW\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-04-25 10:02:32 0 [Note] InnoDB: File 'C:\xamppNEW\mysql\data\ibtmp1' size is now 12 MB.
2020-04-25 10:02:32 0 [Note] InnoDB: Waiting for purge to start
2020-04-25 10:02:33 0 [Note] InnoDB: 10.4.11 started; log sequence number 314634; transaction id 302
2020-04-25 10:02:33 0 [Note] InnoDB: Loading buffer pool(s) from C:\xamppNEW\mysql\data\ib_buffer_pool
2020-04-25 10:02:33 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-04-25 10:02:33 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2020-04-25 10:03:12 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-04-25 10:03:12 0 [Note] InnoDB: Uses event mutexes
2020-04-25 10:03:12 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-04-25 10:03:12 0 [Note] InnoDB: Number of pools: 1
2020-04-25 10:03:12 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-04-25 10:03:12 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-04-25 10:03:12 0 [Note] InnoDB: Completed initialization of buffer pool
2020-04-25 10:03:12 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=314955
2020-04-25 10:03:13 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-04-25 10:03:13 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-04-25 10:03:13 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-04-25 10:03:13 0 [Note] InnoDB: Setting file 'C:\xamppNEW\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-04-25 10:03:13 0 [Note] InnoDB: File 'C:\xamppNEW\mysql\data\ibtmp1' size is now 12 MB.
2020-04-25 10:03:13 0 [Note] InnoDB: Waiting for purge to start
2020-04-25 10:03:13 0 [Note] InnoDB: 10.4.11 started; log sequence number 314964; transaction id 312
2020-04-25 10:03:13 0 [Note] InnoDB: Loading buffer pool(s) from C:\xamppNEW\mysql\data\ib_buffer_pool
2020-04-25 10:03:13 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-04-25 10:03:13 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2020-04-25 10:03:28 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-04-25 10:03:28 0 [Note] InnoDB: Uses event mutexes
2020-04-25 10:03:28 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-04-25 10:03:28 0 [Note] InnoDB: Number of pools: 1
2020-04-25 10:03:28 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-04-25 10:03:28 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-04-25 10:03:28 0 [Note] InnoDB: Completed initialization of buffer pool
2020-04-25 10:03:29 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-04-25 10:03:29 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-04-25 10:03:29 0 [Note] InnoDB: Setting file 'C:\xamppNEW\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-04-25 10:03:29 0 [Note] InnoDB: File 'C:\xamppNEW\mysql\data\ibtmp1' size is now 12 MB.
2020-04-25 10:03:29 0 [Note] InnoDB: Waiting for purge to start
2020-04-25 10:03:29 0 [Note] InnoDB: 10.4.11 started; log sequence number 314982; transaction id 312
2020-04-25 10:03:29 0 [Note] InnoDB: Loading buffer pool(s) from C:\xamppNEW\mysql\data\ib_buffer_pool
2020-04-25 10:03:29 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-04-25 10:03:29 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2020-04-25 10:03:49 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-04-25 10:03:49 0 [Note] InnoDB: Uses event mutexes
2020-04-25 10:03:49 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-04-25 10:03:49 0 [Note] InnoDB: Number of pools: 1
2020-04-25 10:03:49 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-04-25 10:03:49 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-04-25 10:03:49 0 [Note] InnoDB: Completed initialization of buffer pool
2020-04-25 10:03:50 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-04-25 10:03:50 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-04-25 10:03:50 0 [Note] InnoDB: Setting file 'C:\xamppNEW\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-04-25 10:03:50 0 [Note] InnoDB: File 'C:\xamppNEW\mysql\data\ibtmp1' size is now 12 MB.
2020-04-25 10:03:50 0 [Note] InnoDB: Waiting for purge to start
2020-04-25 10:03:50 0 [Note] InnoDB: 10.4.11 started; log sequence number 314991; transaction id 312
2020-04-25 10:03:50 0 [Note] InnoDB: Loading buffer pool(s) from C:\xamppNEW\mysql\data\ib_buffer_pool
2020-04-25 10:03:50 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-04-25 10:03:50 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2020-04-25 10:08:03 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-04-25 10:08:03 0 [Note] InnoDB: Uses event mutexes
2020-04-25 10:08:03 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-04-25 10:08:03 0 [Note] InnoDB: Number of pools: 1
2020-04-25 10:08:03 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-04-25 10:08:03 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-04-25 10:08:03 0 [Note] InnoDB: Completed initialization of buffer pool
2020-04-25 10:08:03 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-04-25 10:08:03 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-04-25 10:08:03 0 [Note] InnoDB: Setting file 'C:\xamppNEW\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-04-25 10:08:03 0 [Note] InnoDB: File 'C:\xamppNEW\mysql\data\ibtmp1' size is now 12 MB.
2020-04-25 10:08:03 0 [Note] InnoDB: Waiting for purge to start
2020-04-25 10:08:04 0 [Note] InnoDB: 10.4.11 started; log sequence number 315000; transaction id 312
2020-04-25 10:08:04 0 [Note] InnoDB: Loading buffer pool(s) from C:\xamppNEW\mysql\data\ib_buffer_pool
2020-04-25 10:08:04 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-04-25 10:08:04 0 [Note] Server socket created on IP: '::'.


Have reason to believe its something to do with file priveledge. As it was crashing when you would close control panel.. When "not" in administrator.. Then was working in administrator turned on. Now SQL wont fire up at all
Nimkii
 
Posts: 1
Joined: 25. April 2020 15:08
XAMPP version: 7.4.5
Operating System: Windows 10

Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 170 guests