Beiträge von Clarke

Clarke · 9. Januar 2024

Danke für die Hilfe. Ich habe ein Backup meiner Daten wieder zurückgespielt. Jetzt geht es wieder. Wenn der Fehler noch mal auftritt, gehe ich nach eurer Anleitung vor.

Grüsse

Clarke01

Clarke · 8. Januar 2024

Der mysql-server läuft wieder. Ich kann die Datenbank über phpmyadmin sehen, aber nicht aufrufen. dann erscheint folgende Fehlermeldung.

Clarke · 8. Januar 2024

Ich habe Xampp auf meinem Computer installiert.

nach kurzer Zeit bekomme ich folgende Fehlermeldung in Xampp und MySQL lässt sich nicht mehr starten:

Code

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

Die Logdatei von der php.ini :

Code

2024-01-08  8:47:19 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 10224
2024-01-08  8:47:19 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-01-08  8:47:19 0 [Note] InnoDB: Uses event mutexes
2024-01-08  8:47:19 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-01-08  8:47:19 0 [Note] InnoDB: Number of pools: 1
2024-01-08  8:47:19 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-01-08  8:47:19 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-01-08  8:47:19 0 [Note] InnoDB: Completed initialization of buffer pool
2024-01-08  8:47:19 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=5893928
2024-01-08  8:47:19 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-01-08  8:47:19 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2024-01-08  8:47:19 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-01-08  8:47:19 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-01-08  8:47:19 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-01-08  8:47:19 0 [Note] InnoDB: Waiting for purge to start
2024-01-08  8:47:19 0 [Note] InnoDB: 10.4.32 started; log sequence number 5893937; transaction id 4685
2024-01-08  8:47:19 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2024-01-08  8:47:19 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-01-08  8:47:19 0 [Note] InnoDB: Buffer pool(s) load completed at 240108  8:47:19
2024-01-08  8:47:19 0 [Note] Server socket created on IP: '::'.
2024-01-08  8:51:10 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 17112
2024-01-08  8:51:10 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
2024-01-08  8:51:10 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
2024-01-08  8:51:10 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2024-01-08  8:51:10 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-01-08  8:51:10 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2024-01-08  8:51:10 0 [ERROR] Aborting
2024-01-08  8:51:26 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 16260
2024-01-08  8:51:26 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
2024-01-08  8:51:26 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
2024-01-08  8:51:26 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2024-01-08  8:51:26 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-01-08  8:51:26 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2024-01-08  8:51:26 0 [ERROR] Aborting
2024-01-08 10:27:47 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 12868
2024-01-08 10:27:47 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
2024-01-08 10:27:47 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
2024-01-08 10:27:47 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2024-01-08 10:27:47 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-01-08 10:27:47 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2024-01-08 10:27:47 0 [ERROR] Aborting
2024-01-08 15:36:06 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 13020
Cannot find checkpoint record at LSN (1,0x5d6b)
2024-01-08 15:36:06 0 [ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
2024-01-08 15:36:06 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2024-01-08 15:36:06 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-01-08 15:36:06 0 [Note] InnoDB: Uses event mutexes
2024-01-08 15:36:06 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-01-08 15:36:06 0 [Note] InnoDB: Number of pools: 1
2024-01-08 15:36:06 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-01-08 15:36:06 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-01-08 15:36:06 0 [Note] InnoDB: Completed initialization of buffer pool
2024-01-08 15:36:06 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=7078012
2024-01-08 15:36:07 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-01-08 15:36:07 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2024-01-08 15:36:07 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-01-08 15:36:07 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-01-08 15:36:07 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-01-08 15:36:07 0 [Note] InnoDB: Waiting for purge to start
2024-01-08 15:36:07 0 [Note] InnoDB: 10.4.32 started; log sequence number 7078021; transaction id 6119
2024-01-08 15:36:07 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-01-08 15:36:07 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2024-01-08 15:36:07 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2024-01-08 15:36:07 0 [ERROR] Failed to initialize plugins.
2024-01-08 15:36:07 0 [ERROR] Aborting
2024-01-08 15:36:30 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 4504
Cannot find checkpoint record at LSN (1,0x5d6b)
2024-01-08 15:36:30 0 [ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
2024-01-08 15:36:30 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2024-01-08 15:36:30 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-01-08 15:36:30 0 [Note] InnoDB: Uses event mutexes
2024-01-08 15:36:30 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-01-08 15:36:30 0 [Note] InnoDB: Number of pools: 1
2024-01-08 15:36:30 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-01-08 15:36:30 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-01-08 15:36:30 0 [Note] InnoDB: Completed initialization of buffer pool
2024-01-08 15:36:30 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-01-08 15:36:30 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-01-08 15:36:30 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-01-08 15:36:30 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-01-08 15:36:30 0 [Note] InnoDB: Waiting for purge to start
2024-01-08 15:36:30 0 [Note] InnoDB: 10.4.32 started; log sequence number 7078030; transaction id 6119
2024-01-08 15:36:30 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2024-01-08 15:36:30 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-01-08 15:36:30 0 [Note] InnoDB: Buffer pool(s) load completed at 240108 15:36:30
2024-01-08 15:36:30 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2024-01-08 15:36:30 0 [ERROR] Failed to initialize plugins.
2024-01-08 15:36:30 0 [ERROR] Aborting

Alles anzeigen