mysql is not qorking in xampp

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

mysql is not qorking in xampp

Postby amitt_06_ » 07. January 2024 05:25

My xampp mysql is not working

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

here are my logs

2024-01-04 20:06:18 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 17904
2024-01-04 20:06:18 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-01-04 20:06:18 0 [Note] InnoDB: Uses event mutexes
2024-01-04 20:06:18 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-01-04 20:06:18 0 [Note] InnoDB: Number of pools: 1
2024-01-04 20:06:18 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-01-04 20:06:18 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-01-04 20:06:18 0 [Note] InnoDB: Completed initialization of buffer pool
2024-01-04 20:06:18 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=300288
2024-01-04 20:06:18 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-01-04 20:06:18 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2024-01-04 20:06:18 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-01-04 20:06:18 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-01-04 20:06:18 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-01-04 20:06:18 0 [Note] InnoDB: Waiting for purge to start
2024-01-04 20:06:18 0 [Note] InnoDB: 10.4.32 started; log sequence number 300297; transaction id 170
2024-01-04 20:06:18 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2024-01-04 20:06:18 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-01-04 20:06:18 0 [Note] InnoDB: Buffer pool(s) load completed at 240104 20:06:18
2024-01-04 20:06:18 0 [Note] Server socket created on IP: '::'.
2024-01-04 20:09:04 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 15564
2024-01-04 20:09:04 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
2024-01-04 20:09:04 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
2024-01-04 20:09:04 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2024-01-04 20:09:04 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-01-04 20:09:04 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2024-01-04 20:09:04 0 [ERROR] Aborting
2024-01-04 20:14:37 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 21928
2024-01-04 20:14:37 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
2024-01-04 20:14:37 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
2024-01-04 20:14:37 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2024-01-04 20:14:37 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-01-04 20:14:37 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2024-01-04 20:14:37 0 [ERROR] Aborting
2024-01-04 20:39:57 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 11964
2024-01-04 20:39:57 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
2024-01-04 20:39:57 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
2024-01-04 20:39:57 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2024-01-04 20:39:57 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-01-04 20:39:57 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2024-01-04 20:39:57 0 [ERROR] Aborting
2024-01-04 20:50:52 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 17080
2024-01-04 20:50:52 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
2024-01-04 20:50:52 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
2024-01-04 20:50:52 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2024-01-04 20:50:52 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-01-04 20:50:52 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2024-01-04 20:50:52 0 [ERROR] Aborting
2024-01-04 20:55:18 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 13936
2024-01-04 20:55:18 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
2024-01-04 20:55:18 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
2024-01-04 20:55:18 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2024-01-04 20:55:18 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-01-04 20:55:18 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2024-01-04 20:55:18 0 [ERROR] Aborting
2024-01-04 21:07:28 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 8996
2024-01-04 21:07:28 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-01-04 21:07:28 0 [Note] InnoDB: Uses event mutexes
2024-01-04 21:07:28 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-01-04 21:07:28 0 [Note] InnoDB: Number of pools: 1
2024-01-04 21:07:28 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-01-04 21:07:28 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-01-04 21:07:28 0 [Note] InnoDB: Completed initialization of buffer pool
2024-01-04 21:07:28 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=300306
2024-01-04 21:07:28 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-01-04 21:07:28 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2024-01-04 21:07:28 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-01-04 21:07:28 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-01-04 21:07:28 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-01-04 21:07:28 0 [Note] InnoDB: Waiting for purge to start
2024-01-04 21:07:28 0 [Note] InnoDB: 10.4.32 started; log sequence number 300315; transaction id 170
2024-01-04 21:07:28 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2024-01-04 21:07:28 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-01-04 21:07:28 0 [Note] InnoDB: Buffer pool(s) load completed at 240104 21:07:28
2024-01-04 21:07:28 0 [Note] Server socket created on IP: '::'.
2024-01-05 9:54:11 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 16192
2024-01-05 9:54:11 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-01-05 9:54:11 0 [Note] InnoDB: Uses event mutexes
2024-01-05 9:54:11 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-01-05 9:54:11 0 [Note] InnoDB: Number of pools: 1
2024-01-05 9:54:11 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-01-05 9:54:11 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-01-05 9:54:11 0 [Note] InnoDB: Completed initialization of buffer pool
2024-01-05 9:54:11 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=2018995
2024-01-05 9:54:11 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-01-05 9:54:11 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2024-01-05 9:54:11 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-01-05 9:54:11 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-01-05 9:54:11 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-01-05 9:54:11 0 [Note] InnoDB: Waiting for purge to start
2024-01-05 9:54:11 0 [Note] InnoDB: 10.4.32 started; log sequence number 2019004; transaction id 840
2024-01-05 9:54:11 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2024-01-05 9:54:11 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-01-05 9:54:11 0 [Note] InnoDB: Buffer pool(s) load completed at 240105 9:54:11
2024-01-05 9:54:11 0 [Note] Server socket created on IP: '::'.
2024-01-07 9:40:22 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 4016
Cannot find checkpoint record at LSN (1,0x55da)
2024-01-07 9:40:22 0 [ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
2024-01-07 9:40:22 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2024-01-07 9:40:22 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-01-07 9:40:22 0 [Note] InnoDB: Uses event mutexes
2024-01-07 9:40:22 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-01-07 9:40:22 0 [Note] InnoDB: Number of pools: 1
2024-01-07 9:40:22 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-01-07 9:40:22 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-01-07 9:40:22 0 [Note] InnoDB: Completed initialization of buffer pool
2024-01-07 9:40:22 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=6723771
2024-01-07 9:40:23 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-01-07 9:40:23 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2024-01-07 9:40:23 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-01-07 9:40:23 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-01-07 9:40:23 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-01-07 9:40:23 0 [Note] InnoDB: Waiting for purge to start
2024-01-07 9:40:23 0 [Note] InnoDB: 10.4.32 started; log sequence number 6723780; transaction id 4964
2024-01-07 9:40:23 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2024-01-07 9:40:23 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-01-07 9:40:23 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2024-01-07 9:40:23 0 [ERROR] Failed to initialize plugins.
2024-01-07 9:40:23 0 [ERROR] Aborting
2024-01-07 9:40:33 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 20088
Cannot find checkpoint record at LSN (1,0x55da)
2024-01-07 9:40:33 0 [ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
2024-01-07 9:40:33 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2024-01-07 9:40:33 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-01-07 9:40:33 0 [Note] InnoDB: Uses event mutexes
2024-01-07 9:40:33 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-01-07 9:40:33 0 [Note] InnoDB: Number of pools: 1
2024-01-07 9:40:33 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-01-07 9:40:33 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-01-07 9:40:33 0 [Note] InnoDB: Completed initialization of buffer pool
2024-01-07 9:40:33 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-01-07 9:40:33 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-01-07 9:40:33 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-01-07 9:40:33 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-01-07 9:40:33 0 [Note] InnoDB: Waiting for purge to start
2024-01-07 9:40:33 0 [Note] InnoDB: 10.4.32 started; log sequence number 6723789; transaction id 4964
2024-01-07 9:40:33 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2024-01-07 9:40:33 0 [Note] InnoDB: Buffer pool(s) load completed at 240107 9:40:33
2024-01-07 9:40:33 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-01-07 9:40:33 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2024-01-07 9:40:33 0 [ERROR] Failed to initialize plugins.
2024-01-07 9:40:33 0 [ERROR] Aborting
amitt_06_
 
Posts: 1
Joined: 07. January 2024 05:17
XAMPP version: v3.3.0
Operating System: windows

Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 169 guests