Random Errors with XAMPP MariaDB/MySQL

Alles, was MariaDB und MySQL betrifft, kann hier besprochen werden.

Random Errors with XAMPP MariaDB/MySQL

Postby lavanyadeepak » 13. March 2023 06:00

My XAMPP seems to be having weird issues. From the Control Panel Apache starts but Mysql/MariaDB has issues. Sometimes it starts and sometimes a couple of times have repeatedly click the start button

Here is the logger display in the panel.

10:25:58 [main] Initializing Control Panel
10:25:58 [main] Windows Version: Enterprise 64-bit
10:25:58 [main] XAMPP Version: 8.2.0
10:25:58 [main] Control Panel Version: 3.3.0 [ Compiled: Apr 6th 2021 ]
10:25:58 [main] Running with Administrator rights - good!
10:25:58 [main] XAMPP Installation Directory: "c:\xampp\"
10:25:58 [main] Checking for prerequisites
10:25:59 [main] All prerequisites found
10:25:59 [main] Initializing Modules
10:25:59 [main] Starting Check-Timer
10:25:59 [main] Control Panel Ready
10:26:03 [Apache] Attempting to start Apache app...
10:26:04 [Apache] Status change detected: running
10:26:05 [mysql] Attempting to start MySQL app...
10:26:06 [mysql] Status change detected: running
10:26:07 [mysql] Status change detected: stopped
10:26:07 [mysql] Error: MySQL shutdown unexpectedly.
10:26:07 [mysql] This may be due to a blocked port, missing dependencies,
10:26:07 [mysql] improper privileges, a crash, or a shutdown by another method.
10:26:07 [mysql] Press the Logs button to view error logs and check
10:26:07 [mysql] the Windows Event Viewer for more clues
10:26:07 [mysql] If you need more help, copy and post this
10:26:07 [mysql] entire log window on the forums
10:26:09 [mysql] Attempting to start MySQL app...
10:26:09 [mysql] Status change detected: running

MySQL log is here:

2023-01-29 18:17:46 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2023-01-29 18:17:46 0 [Note] InnoDB: Uses event mutexes
2023-01-29 18:17:46 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-01-29 18:17:46 0 [Note] InnoDB: Number of pools: 1
2023-01-29 18:17:46 0 [Note] InnoDB: Using SSE2 crc32 instructions
2023-01-29 18:17:46 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2023-01-29 18:17:46 0 [Note] InnoDB: Completed initialization of buffer pool
2023-01-29 18:17:46 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=300288
2023-01-29 18:17:46 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2023-01-29 18:17:46 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2023-01-29 18:17:46 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-01-29 18:17:46 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-01-29 18:17:46 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2023-01-29 18:17:46 0 [Note] InnoDB: Waiting for purge to start
2023-01-29 18:17:47 0 [Note] InnoDB: 10.4.27 started; log sequence number 300297; transaction id 170
2023-01-29 18:17:47 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2023-01-29 18:17:47 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-01-29 18:17:47 0 [Note] Server socket created on IP: '::'.
2023-01-29 18:23:32 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2023-01-29 18:23:32 0 [Note] InnoDB: Uses event mutexes
2023-01-29 18:23:32 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-01-29 18:23:32 0 [Note] InnoDB: Number of pools: 1
2023-01-29 18:23:32 0 [Note] InnoDB: Using SSE2 crc32 instructions
2023-01-29 18:23:32 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2023-01-29 18:23:32 0 [Note] InnoDB: Completed initialization of buffer pool
2023-01-29 18:23:32 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=300638
2023-01-29 18:23:32 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2023-01-29 18:23:32 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2023-01-29 18:23:32 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-01-29 18:23:32 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-01-29 18:23:32 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2023-01-29 18:23:32 0 [Note] InnoDB: Waiting for purge to start
2023-01-29 18:23:33 0 [Note] InnoDB: 10.4.27 started; log sequence number 300647; transaction id 193
2023-01-29 18:23:33 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2023-01-29 18:23:33 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-01-29 18:23:33 0 [Note] Server socket created on IP: '::'.
2023-02-09 12:49:05 0 [Note] mysqld.exe: Aria engine: starting recovery
recovered pages: 0% 14% 24% 34% 45% 56% 68% 80% 100% (0.0 seconds); tables to flush: 17 16 15 14 13 12 11 10 9 8 7 6 5 4 3 2 1 0
(0.1 seconds);
2023-02-09 12:49:05 0 [Note] mysqld.exe: Aria engine: recovery done
2023-02-09 12:49:05 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2023-02-09 12:49:05 0 [Note] InnoDB: Uses event mutexes
2023-02-09 12:49:05 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-02-09 12:49:05 0 [Note] InnoDB: Number of pools: 1
2023-02-09 12:49:05 0 [Note] InnoDB: Using SSE2 crc32 instructions
2023-02-09 12:49:05 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2023-02-09 12:49:05 0 [Note] InnoDB: Completed initialization of buffer pool
2023-02-09 12:49:05 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=795457
2023-02-09 12:49:05 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2023-02-09 12:49:05 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2023-02-09 12:49:05 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-02-09 12:49:05 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-02-09 12:49:05 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2023-02-09 12:49:05 0 [Note] InnoDB: Waiting for purge to start
2023-02-09 12:49:05 0 [Note] InnoDB: 10.4.27 started; log sequence number 795466; transaction id 1143
2023-02-09 12:49:05 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2023-02-09 12:49:05 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-02-09 12:49:05 0 [Note] Zerofilling moved table: '.\mysql\plugin'
2023-02-09 12:49:05 0 [Note] Zerofilling moved table: '.\mysql\servers'
2023-02-09 12:49:05 0 [Note] Server socket created on IP: '::'.
2023-02-23 12:15:59 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2023-02-23 12:15:59 0 [Note] InnoDB: Uses event mutexes
2023-02-23 12:15:59 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-02-23 12:15:59 0 [Note] InnoDB: Number of pools: 1
2023-02-23 12:15:59 0 [Note] InnoDB: Using SSE2 crc32 instructions
2023-02-23 12:15:59 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2023-02-23 12:15:59 0 [Note] InnoDB: Completed initialization of buffer pool
2023-02-23 12:15:59 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=11722730
2023-02-23 12:15:59 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2023-02-23 12:15:59 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2023-02-23 12:15:59 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-02-23 12:15:59 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-02-23 12:15:59 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2023-02-23 12:15:59 0 [Note] InnoDB: Waiting for purge to start
2023-02-23 12:15:59 0 [Note] InnoDB: 10.4.27 started; log sequence number 11722739; transaction id 5594
2023-02-23 12:15:59 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2023-02-23 12:15:59 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-02-23 12:15:59 0 [Note] Server socket created on IP: '::'.
2023-02-23 12:16:03 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2023-02-23 12:16:03 0 [Note] InnoDB: Uses event mutexes
2023-02-23 12:16:03 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-02-23 12:16:03 0 [Note] InnoDB: Number of pools: 1
2023-02-23 12:16:03 0 [Note] InnoDB: Using SSE2 crc32 instructions
2023-02-23 12:16:03 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2023-02-23 12:16:03 0 [Note] InnoDB: Completed initialization of buffer pool
2023-02-23 12:16:03 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=11722730
2023-02-23 12:16:04 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2023-02-23 12:16:04 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2023-02-23 12:16:04 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-02-23 12:16:04 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-02-23 12:16:04 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2023-02-23 12:16:04 0 [Note] InnoDB: Waiting for purge to start
2023-02-23 12:16:04 0 [Note] InnoDB: 10.4.27 started; log sequence number 11722739; transaction id 5594
2023-02-23 12:16:04 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2023-02-23 12:16:04 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-02-23 12:16:04 0 [Note] Server socket created on IP: '::'.
2023-02-28 14:42:48 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2023-02-28 14:42:48 0 [Note] InnoDB: Uses event mutexes
2023-02-28 14:42:48 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-02-28 14:42:48 0 [Note] InnoDB: Number of pools: 1
2023-02-28 14:42:48 0 [Note] InnoDB: Using SSE2 crc32 instructions
2023-02-28 14:42:48 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2023-02-28 14:42:48 0 [Note] InnoDB: Completed initialization of buffer pool
2023-02-28 14:42:48 0 [Note] InnoDB: The log sequence number 139827 in the system tablespace does not match the log sequence number 11722764 in the ib_logfiles!
2023-02-28 14:42:48 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2023-02-28 14:42:48 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2023-02-28 14:42:48 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-02-28 14:42:48 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-02-28 14:42:48 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2023-02-28 14:42:48 0 [Note] InnoDB: Waiting for purge to start
2023-02-28 14:42:48 0 [Note] InnoDB: 10.4.27 started; log sequence number 11722764; transaction id 5594
2023-02-28 14:42:48 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2023-02-28 14:42:48 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-02-28 14:42:48 0 [Note] Server socket created on IP: '::'.
2023-03-13 10:26:06 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2023-03-13 10:26:06 0 [Note] InnoDB: Uses event mutexes
2023-03-13 10:26:06 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-03-13 10:26:06 0 [Note] InnoDB: Number of pools: 1
2023-03-13 10:26:06 0 [Note] InnoDB: Using SSE2 crc32 instructions
2023-03-13 10:26:06 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2023-03-13 10:26:06 0 [Note] InnoDB: Completed initialization of buffer pool
2023-03-13 10:26:06 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=11810534
2023-03-13 10:26:06 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2023-03-13 10:26:06 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2023-03-13 10:26:06 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-03-13 10:26:06 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-03-13 10:26:06 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2023-03-13 10:26:06 0 [Note] InnoDB: Waiting for purge to start
2023-03-13 10:26:07 0 [Note] InnoDB: 10.4.27 started; log sequence number 11810543; transaction id 5790
2023-03-13 10:26:07 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2023-03-13 10:26:07 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-03-13 10:26:07 0 [Note] Server socket created on IP: '::'.
2023-03-13 10:26:09 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2023-03-13 10:26:09 0 [Note] InnoDB: Uses event mutexes
2023-03-13 10:26:09 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-03-13 10:26:09 0 [Note] InnoDB: Number of pools: 1
2023-03-13 10:26:09 0 [Note] InnoDB: Using SSE2 crc32 instructions
2023-03-13 10:26:09 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2023-03-13 10:26:09 0 [Note] InnoDB: Completed initialization of buffer pool
2023-03-13 10:26:09 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=11810534
2023-03-13 10:26:09 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2023-03-13 10:26:09 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2023-03-13 10:26:09 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-03-13 10:26:09 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-03-13 10:26:09 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2023-03-13 10:26:09 0 [Note] InnoDB: Waiting for purge to start
2023-03-13 10:26:09 0 [Note] InnoDB: 10.4.27 started; log sequence number 11810543; transaction id 5790
2023-03-13 10:26:09 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2023-03-13 10:26:09 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-03-13 10:26:09 0 [Note] Server socket created on IP: '::'.
lavanyadeepak
 
Posts: 13
Joined: 04. November 2019 15:26
XAMPP version: 7.1.33
Operating System: Windows 10

Re: Random Errors with XAMPP MariaDB/MySQL

Postby gulshan212 » 29. March 2023 11:52

Hello this is Gulshan Negi
Well, this problem is looking big but I this can be resolve by doing some simple steps which includes checking of conflicting programs, look for error messages, restart XAMPP, check the log files, and consider reinstalling XAMPP if nothing else works.
I hope it will work.
Thanks
User avatar
gulshan212
 
Posts: 21
Joined: 12. January 2023 12:14
Location: Haldwani, Uttarakhand
XAMPP version: 8.0.25
Operating System: Windows 10


Return to MariaDB - MySQL

Who is online

Users browsing this forum: No registered users and 6 guests