Xampp und MySQL

Clarke

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

Elwood

Trage das mal bei Shell ein:

Code

mysqld --console --skip-grant-tables --skip-external-lockin

Wäre jetzt meine erste Vermutung.

EDIT:

Natürlich dann mit Eingabebestätigung:

hechtnetz

So ins Blaue hinein:

Mit netstat - Befehl oder TCPView (ein kostenloses Dienstprogramm von Sysinternals) mal prüfen, welche Ports bei Dir belegt sind.

Erinnere mich, dass gaaanz früher mal Skype den MySQL-Port gekapert hatte. Ist heute aber nicht mehr so.

jsc_01

Zitat von hechtnetz

Erinnere mich, dass gaaanz früher mal Skype den MySQL-Port gekapert hatte. Ist heute aber nicht mehr so.

Kenne ich auch noch so, aber nicht gekapert sondern: Wer zuerst kommt...

hechtnetz

Zitat von jsc_01

Kenne ich auch noch so, aber nicht gekapert sondern: Wer zuerst kommt...

OT:

Einigen wir uns freundschaftlich auf: „zuerst gekommen und festgebissen.“

firstlady

Dieses Problem ist recht häufig und ich habe noch keine Ursache gefunden. Es tritt bei mir auf wenn das system unerwartet beendet wurde und dann neu gestartet wird.

Mit dieser Anleitung kann man das reparieren: https://appuals.com/error-mysql-shutdown-unexpectedly/

Clarke

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

Elwood

Im Screenshot sieht man, dass du Joomla versuchst aufzurufen.

Die DB rufst du ja über die Schaltfläche 'Admin' auf:

Clarke

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

Wolly2024

Der "500" Fehler tritt auf wenn Du nur deine Datenbanken in den data Ordner kopiert hast. Du musst auch die Datei ibdata1 mit kopieren. Hat wohl was mit den Tabellenformaten zu tun. also innoDB statt MyIsam. So ist es zumindest bei meiner Xampp Installation.