This is my first post on this forum and I would like to say Hello to everybody ...
I have a strange problem with my XAMPP / MySQL :
Yesterday evening, all works well ... (I'm working on an "local" version of my actual site ...)
After working, I stop MySQL, stop Apache, quit XAMPP and stop my PC.
This morning I try to restart everything and .... HORROR it doesn't works anymore.
I certainly "touch" something by mistake, but I don't now what ...
Here are my logs :
a) XAMPP Control Panel :
11:39:15 [main] Initializing Control Panel
11:39:15 [main] Windows Version: Enterprise 64-bit
11:39:15 [main] XAMPP Version: 8.2.12
11:39:15 [main] Control Panel Version: 3.3.0 [ Compiled: Apr 6th 2021 ]
11:39:15 [main] Running with Administrator rights - good!
11:39:15 [main] XAMPP Installation Directory: "c:\xampp\"
11:39:15 [main] Checking for prerequisites
11:39:15 [main] All prerequisites found
11:39:15 [main] Initializing Modules
11:39:15 [main] Starting Check-Timer
11:39:15 [main] Control Panel Ready
11:39:19 [Apache] Attempting to start Apache app...
11:39:19 [Apache] Status change detected: running
11:41:19 [mysql] Attempting to start MySQL app...
11:41:19 [mysql] Status change detected: running
11:41:21 [mysql] Status change detected: stopped
11:41:21 [mysql] Error: MySQL shutdown unexpectedly.
11:41:21 [mysql] This may be due to a blocked port, missing dependencies,
11:41:21 [mysql] improper privileges, a crash, or a shutdown by another method.
11:41:21 [mysql] Press the Logs button to view error logs and check
11:41:21 [mysql] the Windows Event Viewer for more clues
11:41:21 [mysql] If you need more help, copy and post this
11:41:21 [mysql] entire log window on the forums
b) mysql_error.log :
2024-04-25 11:41:19 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 8468
2024-04-25 11:41:19 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-04-25 11:41:19 0 [Note] InnoDB: Uses event mutexes
2024-04-25 11:41:19 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-04-25 11:41:19 0 [Note] InnoDB: Number of pools: 1
2024-04-25 11:41:19 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-04-25 11:41:19 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-04-25 11:41:19 0 [Note] InnoDB: Completed initialization of buffer pool
2024-04-25 11:41:19 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-04-25 11:41:19 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2024-04-25 11:41:19 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-04-25 11:41:19 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-04-25 11:41:19 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-04-25 11:41:19 0 [Note] InnoDB: Waiting for purge to start
2024-04-25 11:41:20 0 [Note] InnoDB: 10.4.32 started; log sequence number 51095083; transaction id 20884
2024-04-25 11:41:20 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2024-04-25 11:41:20 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-04-25 11:41:20 0 [Note] Server socket created on IP: '::'.
c) Windows Event viewer : (Sorry, key's name are in French !!)
Nom du journal :Application
Source : MariaDB
Date : 25.04.24 11:41:21
ID de l’événement :100
Catégorie de la tâche :Aucun
Niveau : Erreur
Mots clés : Classique
Utilisateur : N/A
Ordinateur : Port-AK
Description :
mysqld.exe: Error on close of 'C:\xampp\mysql\data\aria_log_control' (Errcode: 9 "Bad file descriptor")
XML de l’événement :
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="MariaDB" />
<EventID Qualifiers="49152">100</EventID>
<Version>0</Version>
<Level>2</Level>
<Task>0</Task>
<Opcode>0</Opcode>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2024-04-25T09:41:21.2514619Z" />
<EventRecordID>205677</EventRecordID>
<Correlation />
<Execution ProcessID="8468" ThreadID="0" />
<Channel>Application</Channel>
<Computer>Port-AK</Computer>
<Security />
</System>
<EventData>
<Data>mysqld.exe: Error on close of 'C:\xampp\mysql\data\aria_log_control' (Errcode: 9 "Bad file descriptor")
</Data>
</EventData>
</Event>
Nom du journal :Application
Source : MariaDB
Date : 25.04.24 11:41:21
ID de l’événement :100
Catégorie de la tâche :Aucun
Niveau : Erreur
Mots clés : Classique
Utilisateur : N/A
Ordinateur : Port-AK
Description :
mysqld.exe: Error writing file 'C:\xampp\mysql\data\aria_log_control' (Errcode: 9 "Bad file descriptor")
XML de l’événement :
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="MariaDB" />
<EventID Qualifiers="49152">100</EventID>
<Version>0</Version>
<Level>2</Level>
<Task>0</Task>
<Opcode>0</Opcode>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2024-04-25T09:41:21.2499263Z" />
<EventRecordID>205676</EventRecordID>
<Correlation />
<Execution ProcessID="8468" ThreadID="0" />
<Channel>Application</Channel>
<Computer>Port-AK</Computer>
<Security />
</System>
<EventData>
<Data>mysqld.exe: Error writing file 'C:\xampp\mysql\data\aria_log_control' (Errcode: 9 "Bad file descriptor")
</Data>
</EventData>
</Event>
Nom du journal :Application
Source : MariaDB
Date : 25.04.24 11:41:21
ID de l’événement :100
Catégorie de la tâche :Aucun
Niveau : Erreur
Mots clés : Classique
Utilisateur : N/A
Ordinateur : Port-AK
Description :
mysqld.exe: Aria engine: checkpoint failed
XML de l’événement :
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="MariaDB" />
<EventID Qualifiers="49152">100</EventID>
<Version>0</Version>
<Level>2</Level>
<Task>0</Task>
<Opcode>0</Opcode>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2024-04-25T09:41:21.2495780Z" />
<EventRecordID>205675</EventRecordID>
<Correlation />
<Execution ProcessID="8468" ThreadID="0" />
<Channel>Application</Channel>
<Computer>Port-AK</Computer>
<Security />
</System>
<EventData>
<Data>mysqld.exe: Aria engine: checkpoint failed
</Data>
</EventData>
</Event>
Nom du journal :Application
Source : MariaDB
Date : 25.04.24 11:41:21
ID de l’événement :100
Catégorie de la tâche :Aucun
Niveau : Erreur
Mots clés : Classique
Utilisateur : N/A
Ordinateur : Port-AK
Description :
mysqld.exe: Error writing file 'C:\xampp\mysql\data\aria_log_control' (Errcode: 9 "Bad file descriptor")
XML de l’événement :
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="MariaDB" />
<EventID Qualifiers="49152">100</EventID>
<Version>0</Version>
<Level>2</Level>
<Task>0</Task>
<Opcode>0</Opcode>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2024-04-25T09:41:21.2492878Z" />
<EventRecordID>205674</EventRecordID>
<Correlation />
<Execution ProcessID="8468" ThreadID="0" />
<Channel>Application</Channel>
<Computer>Port-AK</Computer>
<Security />
</System>
<EventData>
<Data>mysqld.exe: Error writing file 'C:\xampp\mysql\data\aria_log_control' (Errcode: 9 "Bad file descriptor")
</Data>
</EventData>
</Event>
Nom du journal :Application
Source : MariaDB
Date : 25.04.24 11:41:20
ID de l’événement :100
Catégorie de la tâche :Aucun
Niveau : Erreur
Mots clés : Classique
Utilisateur : N/A
Ordinateur : Port-AK
Description :
Aborting
XML de l’événement :
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="MariaDB" />
<EventID Qualifiers="49152">100</EventID>
<Version>0</Version>
<Level>2</Level>
<Task>0</Task>
<Opcode>0</Opcode>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2024-04-25T09:41:20.0313857Z" />
<EventRecordID>205673</EventRecordID>
<Correlation />
<Execution ProcessID="8468" ThreadID="0" />
<Channel>Application</Channel>
<Computer>Port-AK</Computer>
<Security />
</System>
<EventData>
<Data>Aborting
</Data>
</EventData>
</Event>
Nom du journal :Application
Source : MariaDB
Date : 25.04.24 11:41:20
ID de l’événement :100
Catégorie de la tâche :Aucun
Niveau : Erreur
Mots clés : Classique
Utilisateur : N/A
Ordinateur : Port-AK
Description :
Fatal error: Can't open and lock privilege tables: Incorrect file format 'db'
XML de l’événement :
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="MariaDB" />
<EventID Qualifiers="49152">100</EventID>
<Version>0</Version>
<Level>2</Level>
<Task>0</Task>
<Opcode>0</Opcode>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2024-04-25T09:41:20.0311328Z" />
<EventRecordID>205672</EventRecordID>
<Correlation />
<Execution ProcessID="8468" ThreadID="0" />
<Channel>Application</Channel>
<Computer>Port-AK</Computer>
<Security />
</System>
<EventData>
<Data>Fatal error: Can't open and lock privilege tables: Incorrect file format 'db'
</Data>
</EventData>
</Event>
Nom du journal :Application
Source : MariaDB
Date : 25.04.24 11:41:20
ID de l’événement :100
Catégorie de la tâche :Aucun
Niveau : Information
Mots clés : Classique
Utilisateur : N/A
Ordinateur : Port-AK
Description :
InnoDB: Buffer pool(s) load completed at 240425 11:41:20
XML de l’événement :
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="MariaDB" />
<EventID Qualifiers="49152">100</EventID>
<Version>0</Version>
<Level>4</Level>
<Task>0</Task>
<Opcode>0</Opcode>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2024-04-25T09:41:20.0273767Z" />
<EventRecordID>205671</EventRecordID>
<Correlation />
<Execution ProcessID="8468" ThreadID="0" />
<Channel>Application</Channel>
<Computer>Port-AK</Computer>
<Security />
</System>
<EventData>
<Data>InnoDB: Buffer pool(s) load completed at 240425 11:41:20
</Data>
</EventData>
</Event>
Can you please help me to solve my problem ?
Best regards.
Andreas Knabe