MySQL startet nicht mehr

[peitman]

Hallo zusammen,
ich benutze XAMPP als Entwicklungsumgebung zur Programmierung von Websites.

Von jetzt auf gleich erhielt ich im Browser eine Fehlermeldung, dass die MySQL-Datenbank nicht mehr erreichbar ist!
Ich habe dann das Control Panel geschlossen, neu geöffnet, Apache gestartet - i.O., MySQL gestartet - Fehlermeldung.

0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
0 [ERROR] Failed to initialize plugins.
0 [ERROR] Aborting

Im Forum hier gesucht und auf den nachfolgenden Post gestossen: https://community.apachefriends.org/f/viewtopic.php?f=16&t=80349&p=271641&hilit=Failed+to+initialize+plugins#p271641

Wie hier beschrieben vorgegangen, Apache gestartet - i.O., MySQL gestartet - Fehlermeldung.
Die LogFile schreibt nachfolgendes:

Cannot find checkpoint record at LSN (1,0x5976)
2021-08-06 11:56:29 0 [ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
2021-08-06 11:56:29 0 [ERROR] Plugin 'Aria' init function returned error.
2021-08-06 11:56:29 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
InnoDB: using atomic writes.
2021-08-06 11:56:29 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-08-06 11:56:29 0 [Note] InnoDB: Uses event mutexes
2021-08-06 11:56:29 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-08-06 11:56:29 0 [Note] InnoDB: Number of pools: 1
2021-08-06 11:56:29 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-08-06 11:56:29 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-08-06 11:56:29 0 [Note] InnoDB: Completed initialization of buffer pool
2021-08-06 11:56:29 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-08-06 11:56:29 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-08-06 11:56:29 0 [Note] InnoDB: Setting file 'G:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-08-06 11:56:29 0 [Note] InnoDB: File 'G:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-08-06 11:56:29 0 [Note] InnoDB: 10.4.14 started; log sequence number 423499851; transaction id 169724
2021-08-06 11:56:29 0 [Note] InnoDB: Loading buffer pool(s) from G:\xampp\mysql\data\ib_buffer_pool
2021-08-06 11:56:29 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-08-06 11:56:29 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2021-08-06 11:56:29 0 [ERROR] Failed to initialize plugins.
2021-08-06 11:56:29 0 [ERROR] Aborting

Wäre super wenn jemand helfen könnte.

Danke

[Altrea]

Hi,

Deine mysql Datenbank muss repariert werden. Das kannst du folgendermaßen tun:

Klicke den Shell Button im XAMPP control Panel um die XAMPP Shell zu öffnen
tippe folgenden Befehl ein, um MariaDB ohne Benutzertabellen zu starten

Code: Select all

mysqld --console --skip-grant-tables --skip-external-locking

Lasse dieses Fenster geöffnet (wichtig!) und öffne eine weitere XAMPP Shell über den Shell Button
Tippe hier folgenden Befehl ein

Code: Select all

mysqlcheck -r --databases mysql --use-frm

Danach kannst du beide XAMPP Shell Fenster wieder schließen und versuchen MariaDB über den normalen Weg zu starten.

[peitman]

Erst einmal Danke Altrea

das hatte ich schon versucht, hat aber nicht funktioniert!
Habe das jetzt noch einmal durchgeführt, ebenfalls ohne Erfolg.

Nachfolgend die Meldung aus der LogFile:

Cannot find checkpoint record at LSN (1,0x5976)
2021-08-06 12:54:29 0 [ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
2021-08-06 12:54:29 0 [ERROR] Plugin 'Aria' init function returned error.
2021-08-06 12:54:29 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
InnoDB: using atomic writes.
2021-08-06 12:54:29 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-08-06 12:54:29 0 [Note] InnoDB: Uses event mutexes
2021-08-06 12:54:29 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-08-06 12:54:29 0 [Note] InnoDB: Number of pools: 1
2021-08-06 12:54:29 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-08-06 12:54:29 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-08-06 12:54:29 0 [Note] InnoDB: Completed initialization of buffer pool
2021-08-06 12:54:30 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-08-06 12:54:30 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-08-06 12:54:30 0 [Note] InnoDB: Setting file 'G:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-08-06 12:54:30 0 [Note] InnoDB: File 'G:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-08-06 12:54:30 0 [Note] InnoDB: 10.4.14 started; log sequence number 423499887; transaction id 169724
2021-08-06 12:54:30 0 [Note] InnoDB: Loading buffer pool(s) from G:\xampp\mysql\data\ib_buffer_pool
2021-08-06 12:54:30 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-08-06 12:54:30 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2021-08-06 12:54:30 0 [ERROR] Failed to initialize plugins.
2021-08-06 12:54:30 0 [ERROR] Aborting