MySQL bricht beim Start ab.

Irgendwelche Probleme mit XAMPP für Windows? Dann ist hier genau der richtige Ort um nachzufragen.

MySQL bricht beim Start ab.

Postby KaiBlack » 31. August 2022 10:40

Hallo,
anbei die Fehlermeldung und der Log.

Fehler: MySQL wurde unerwartet beendet
Ursache könnte ein geblockter Port, fehlende Abhängigkeiten,
fehlende Berechtigungen, ein Absturz oder ein Abbruch einer anderen Methode sein.
Drücke den Logs Button um error logs zu sehen und prüfe
im Windows Event Viewer für weitere Hinweise
Wenn du weitere Hilfe benötigst, kopiere den kompletten Inhalt des Log Fensters
und füge ihn als Ergänzung in einem neuen Forum Eintrag hinzu.

2022-08-30 18:53:09 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-08-30 18:53:09 0 [Note] InnoDB: Uses event mutexes
2022-08-30 18:53:09 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-08-30 18:53:09 0 [Note] InnoDB: Number of pools: 1
2022-08-30 18:53:09 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-08-30 18:53:09 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2022-08-30 18:53:09 0 [Note] InnoDB: Completed initialization of buffer pool
2022-08-30 18:53:09 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=300288
2022-08-30 18:53:10 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-08-30 18:53:10 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2022-08-30 18:53:10 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-08-30 18:53:10 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-08-30 18:53:10 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2022-08-30 18:53:10 0 [Note] InnoDB: Waiting for purge to start
2022-08-30 18:53:10 0 [Note] InnoDB: 10.4.24 started; log sequence number 300297; transaction id 170
2022-08-30 18:53:10 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2022-08-30 18:53:10 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-08-30 18:53:10 0 [Note] Server socket created on IP: '::'.
2022-08-30 18:53:10 0 [Note] InnoDB: Buffer pool(s) load completed at 220830 18:53:10
2022-08-31 11:15:38 0 [Note] mysqld.exe: Aria engine: starting recovery
recovered pages: 0% 12% 50% 74% 85% 100% (0.0 seconds); tables to flush: 1 0
(0.0 seconds);
2022-08-31 11:15:38 0 [Note] mysqld.exe: Aria engine: recovery done
2022-08-31 11:15:38 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-08-31 11:15:38 0 [Note] InnoDB: Uses event mutexes
2022-08-31 11:15:38 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-08-31 11:15:38 0 [Note] InnoDB: Number of pools: 1
2022-08-31 11:15:38 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-08-31 11:15:38 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2022-08-31 11:15:38 0 [Note] InnoDB: Completed initialization of buffer pool
2022-08-31 11:15:38 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=12726248
2022-08-31 11:15:38 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-08-31 11:15:38 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2022-08-31 11:15:38 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-08-31 11:15:38 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-08-31 11:15:38 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2022-08-31 11:15:38 0 [Note] InnoDB: 10.4.24 started; log sequence number 12726257; transaction id 10282
2022-08-31 11:15:38 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2022-08-31 11:15:38 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-08-31 11:15:38 0 [Note] Server socket created on IP: '::'.
2022-08-31 11:15:38 0 [Note] InnoDB: Buffer pool(s) load completed at 220831 11:15:38
2022-08-31 11:15:44 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-08-31 11:15:44 0 [Note] InnoDB: Uses event mutexes
2022-08-31 11:15:44 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-08-31 11:15:44 0 [Note] InnoDB: Number of pools: 1
2022-08-31 11:15:44 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-08-31 11:15:44 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2022-08-31 11:15:44 0 [Note] InnoDB: Completed initialization of buffer pool
2022-08-31 11:15:44 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-08-31 11:15:44 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-08-31 11:15:44 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-08-31 11:15:44 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2022-08-31 11:15:44 0 [Note] InnoDB: 10.4.24 started; log sequence number 12726266; transaction id 10282
2022-08-31 11:15:44 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2022-08-31 11:15:44 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-08-31 11:15:44 0 [Note] Server socket created on IP: '::'.
2022-08-31 11:19:34 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-08-31 11:19:34 0 [Note] InnoDB: Uses event mutexes
2022-08-31 11:19:34 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-08-31 11:19:34 0 [Note] InnoDB: Number of pools: 1
2022-08-31 11:19:34 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-08-31 11:19:34 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2022-08-31 11:19:34 0 [Note] InnoDB: Completed initialization of buffer pool
2022-08-31 11:19:34 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-08-31 11:19:34 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-08-31 11:19:34 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-08-31 11:19:34 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2022-08-31 11:19:34 0 [Note] InnoDB: 10.4.24 started; log sequence number 12726291; transaction id 10282
2022-08-31 11:19:34 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2022-08-31 11:19:34 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-08-31 11:19:34 0 [Note] Server socket created on IP: '::'.
2022-08-31 11:19:55 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-08-31 11:19:55 0 [Note] InnoDB: Uses event mutexes
2022-08-31 11:19:55 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-08-31 11:19:55 0 [Note] InnoDB: Number of pools: 1
2022-08-31 11:19:55 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-08-31 11:19:55 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2022-08-31 11:19:55 0 [Note] InnoDB: Completed initialization of buffer pool
2022-08-31 11:19:55 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-08-31 11:19:55 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-08-31 11:19:55 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-08-31 11:19:55 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2022-08-31 11:19:55 0 [Note] InnoDB: 10.4.24 started; log sequence number 12726300; transaction id 10282
2022-08-31 11:19:55 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2022-08-31 11:19:55 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-08-31 11:19:55 0 [Note] Server socket created on IP: '::'.
2022-08-31 11:22:31 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-08-31 11:22:31 0 [Note] InnoDB: Uses event mutexes
2022-08-31 11:22:31 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-08-31 11:22:31 0 [Note] InnoDB: Number of pools: 1
2022-08-31 11:22:31 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-08-31 11:22:31 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2022-08-31 11:22:31 0 [Note] InnoDB: Completed initialization of buffer pool
2022-08-31 11:22:31 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-08-31 11:22:31 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-08-31 11:22:31 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-08-31 11:22:31 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2022-08-31 11:22:31 0 [Note] InnoDB: Waiting for purge to start
2022-08-31 11:22:31 0 [Note] InnoDB: 10.4.24 started; log sequence number 12726309; transaction id 10282
2022-08-31 11:22:31 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2022-08-31 11:22:31 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-08-31 11:22:31 0 [Note] Server socket created on IP: '::'.
2022-08-31 11:35:44 0 [ERROR] mysqld.exe: File 'C:\xampp\mysql\data\aria_log.00000001' not found (Errcode: 2 "No such file or directory")
2022-08-31 11:35:44 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-08-31 11:35:44 0 [Note] InnoDB: Uses event mutexes
2022-08-31 11:35:44 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-08-31 11:35:44 0 [Note] InnoDB: Number of pools: 1
2022-08-31 11:35:44 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-08-31 11:35:44 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2022-08-31 11:35:44 0 [Note] InnoDB: Completed initialization of buffer pool
2022-08-31 11:35:44 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-08-31 11:35:44 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-08-31 11:35:44 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-08-31 11:35:44 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2022-08-31 11:35:44 0 [Note] InnoDB: 10.4.24 started; log sequence number 12726318; transaction id 10282
2022-08-31 11:35:44 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2022-08-31 11:35:44 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-08-31 11:35:44 0 [Note] Server socket created on IP: '::'.
KaiBlack
 
Posts: 2
Joined: 31. August 2022 10:24
XAMPP version: 3.3.0
Operating System: Windows

Re: MySQL bricht beim Start ab.

Postby Nobbie » 31. August 2022 12:54

Dass auf diese Frage ggf. keine (oder immer nur eine Standardantwort) erfolgt, ist definitiv schon lange nicht mehr anders zu erwarten. Ohne(!) Übertreibung wurde diese Frage sicherlich an die 1000 Mal oder öfter gestellt, immer und immer und immer wieder. Schaut man mal alleine nur die 1. Seite dieses einen Subforums an, findet man diese Menge Beiträge mit demselben Thema:

viewtopic.php?f=4&t=82235
viewtopic.php?f=4&t=82208
viewtopic.php?f=4&t=82203
viewtopic.php?f=4&t=82162
viewtopic.php?f=4&t=82179
viewtopic.php?f=4&t=81812
viewtopic.php?f=4&t=81984
viewtopic.php?f=4&t=82103
viewtopic.php?f=4&t=82094
viewtopic.php?f=4&t=81981
viewtopic.php?f=4&t=81965
viewtopic.php?f=4&t=81957
viewtopic.php?f=4&t=81939
viewtopic.php?f=4&t=81897
viewtopic.php?f=4&t=81921
viewtopic.php?f=4&t=81841
viewtopic.php?f=4&t=81772
viewtopic.php?f=4&t=81742
Nobbie
 
Posts: 13176
Joined: 09. March 2008 13:04

Re: MySQL bricht beim Start ab.

Postby KaiBlack » 31. August 2022 14:26

Sehr geehrter Forum-Nutzer,

natürlich habe ich mich auch erkundigt. Es haben allerdings einige Lösungsvorschläge nicht funktioniert, weshalb ich mich dazu entschieden habe, einen eigenen Forum-Eintrag zu verfassen.
Natürlich muss ich dabei berücksichtigen, dass es viele ähnliche Probleme gibt, allerdings wollte ich lediglich einen Lösungsvorschlag.

Ich danke Ihnen für Ihre Hilfe bei meinem Problem, und dass Sie nun endlich zufrieden gestellt sind.
KaiBlack
 
Posts: 2
Joined: 31. August 2022 10:24
XAMPP version: 3.3.0
Operating System: Windows


Return to XAMPP für Windows

Who is online

Users browsing this forum: No registered users and 102 guests