MariaDB refuse to start

Problems with the Windows version of XAMPP, questions, comments, and anything related.

MariaDB refuse to start

Postby rofi » 18. November 2019 19:43

From XAMPP Control Panel I start Apache without errors.
When I click on Start for MySQL I always get the message:

19:28:02 [mysql] Error: MySQL shutdown unexpectedly.
19:28:02 [mysql] This may be due to a blocked port, missing dependencies,
19:28:02 [mysql] improper privileges, a crash, or a shutdown by another method.
19:28:02 [mysql] Press the Logs button to view error logs and check
19:28:02 [mysql] the Windows Event Viewer for more clues
19:28:02 [mysql] If you need more help, copy and post this
19:28:02 [mysql] entire log window on the forums


mysql_error.log says:

InnoDB: using atomic writes.
2019-11-17 16:07:06 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-11-17 16:07:06 0 [Note] InnoDB: Uses event mutexes
2019-11-17 16:07:06 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-11-17 16:07:06 0 [Note] InnoDB: Number of pools: 1
2019-11-17 16:07:06 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-11-17 16:07:06 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-11-17 16:07:06 0 [Note] InnoDB: Completed initialization of buffer pool
2019-11-17 16:07:06 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=300288
2019-11-17 16:07:06 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-11-17 16:07:06 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-11-17 16:07:06 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-11-17 16:07:06 0 [Note] InnoDB: Setting file 'C:\xampp_php72\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-11-17 16:07:06 0 [Note] InnoDB: File 'C:\xampp_php72\mysql\data\ibtmp1' size is now 12 MB.
2019-11-17 16:07:06 0 [Note] InnoDB: Waiting for purge to start
2019-11-17 16:07:06 0 [Note] InnoDB: 10.4.8 started; log sequence number 300297; transaction id 171
2019-11-17 16:07:06 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp_php72\mysql\data\ib_buffer_pool
2019-11-17 16:07:06 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-11-17 16:07:06 0 [Note] Server socket created on IP: '::'.


The Windows Event Viewer shows for MariaDB:

The description for Event ID 100 from source MariaDB cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.
If the event originated on another computer, the display information had to be saved with the event.
The following information was included with the event:
Aborting

I tried already to delete all files starting with ib from my mysql\data, but to no avail.
Any ideas what is going on? And how to make it work?
rofi
 
Posts: 2
Joined: 18. November 2019 19:27
XAMPP version: 3.2.4
Operating System: Windows 10

Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 39 guests