MySQL MariaDB not starting any more

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

MySQL MariaDB not starting any more

Postby Klaus_Schaefer » 10. December 2023 15:35

Hi folks,
since today I'm receiving an error when trying to start MariaDB/MySQL. I searched in the forum and found similar errors reported several times, but the answers didn't give me a real understanding of what I can do:
15:12:19 [mysql] Versuche MySQL zu starten...
15:12:20 [mysql] Statusänderung erkannt: gestartet
15:12:21 [mysql] Statusänderung erkannt: gestoppt
15:12:21 [mysql] Fehler: MySQL wurde unerwartet beendet
15:12:21 [mysql] Ursache könnte ein geblockter Port, fehlende Abhängigkeiten,
15:12:21 [mysql] fehlende Berechtigungen, ein Absturz oder ein Abbruch einer anderen Methode sein.
15:12:21 [mysql] Drücke den Logs Button um error logs zu sehen und prüfe
15:12:21 [mysql] im Windows Event Viewer für weitere Hinweise
15:12:21 [mysql] Wenn du weitere Hilfe benötigst, kopiere den kompletten Inhalt des Log Fensters
15:12:21 [mysql] und füge ihn als Ergänzung in einem neuen Forum Eintrag hinzu.

The standard port is not blocked and I have no idea how to deal with this error. Windows event id shows error 100. The MySQL log entries are follows:
2023-12-10 15:12:20 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 22704
2023-12-10 15:12:20 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2023-12-10 15:12:20 0 [Note] InnoDB: Uses event mutexes
2023-12-10 15:12:20 0 [Note] InnoDB: Compressed tables use zlib 1.3
2023-12-10 15:12:20 0 [Note] InnoDB: Number of pools: 1
2023-12-10 15:12:20 0 [Note] InnoDB: Using SSE2 crc32 instructions
2023-12-10 15:12:20 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2023-12-10 15:12:20 0 [Note] InnoDB: Completed initialization of buffer pool
2023-12-10 15:12:20 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2023-12-10 15:12:20 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-12-10 15:12:20 0 [Note] InnoDB: Setting file 'J:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-12-10 15:12:20 0 [Note] InnoDB: File 'J:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2023-12-10 15:12:20 0 [Note] InnoDB: Waiting for purge to start
2023-12-10 15:12:20 0 [Note] InnoDB: 10.4.32 started; log sequence number 152646591; transaction id 55968
2023-12-10 15:12:20 0 [Note] InnoDB: Loading buffer pool(s) from J:\xampp\mysql\data\ib_buffer_pool
2023-12-10 15:12:20 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-12-10 15:12:20 0 [Note] InnoDB: Buffer pool(s) load completed at 231210 15:12:20
2023-12-10 15:12:20 0 [Note] Server socket created on IP: '::'.

Actually I don't see any error message in there, I had the same entries when MYSQL startet successful. What can I do? Do I have to reinstall XAMPP? Will I loose all my work of creating a WordPress webpage? I'm a little bit frustrated :cry: and hope you can help me!

Thnx and best regards
Klaus
Klaus_Schaefer
 
Posts: 3
Joined: 10. December 2023 15:20
XAMPP version: 8.2.12
Operating System: Windows Version: Home 64-bit

Re: MySQL MariaDB not starting any more

Postby Klaus_Schaefer » 10. December 2023 18:18

Nach einigem Suchen hier im Forum habe ich die Lösung für das Problem gefunden. Scheint eine Art "Bug" in der MySQL/MariaDB Implementierung zu sein, da das Problem ja viele User hier in verschiedenen Foren-Bereichen gemeldet haben:
https://community.apachefriends.org/f/viewtopic.php?f=4&t=83177&p=280859#p280859

Gruß
Klaus
Klaus_Schaefer
 
Posts: 3
Joined: 10. December 2023 15:20
XAMPP version: 8.2.12
Operating System: Windows Version: Home 64-bit


Return to MariaDB - MySQL

Who is online

Users browsing this forum: No registered users and 34 guests