mysql start up issues & phpMyAdmin corrupted innoDB tables

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

mysql start up issues & phpMyAdmin corrupted innoDB tables

Postby rgaDawg » 13. January 2023 21:38

Win11, Pro on Dell 4820 WorkStation, XAMPP v8.1.12 & v8.2.0.

This problem for me has gone through XAMPP v8.1.12 & XAMPP v8.20 and would be nice to get some fix to it.
It seems that my previous version of XAMPP 8.1.6 did not have these problems.

Either mysql -- shuts down unexpectedly, or even when starting phpmyadmin has problems with its innoDB tables.

I have isolated an issue with the > C:\xampp\mysql\data\phpmyadmin\*.* tables that cause mysql start up problems (at least on my XAMPP installations). If I restore the virgin > C:\xampp\mysql\data\phpmyadmin\*.* [/b ]tables (dated 10-21-2022 for XAMPP v8.2.0), then no start up issues with mysql. Without restoring those files, even when I get a start up with mysql, phyMyAdmin shows errors with those tables and phpMyAdmin cannot correct via Operations > Create. Of course you will lose all personalized settings for phpMyAdmin. Oh, well.

phpMyAdmin error message
The phpMyAdmin storage is not completely configured ..

Segment of mysql error.log
InnoDB: Failing assertion: slot
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to https://jira.mariadb.org/
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
[b]InnoDB: corruption in the InnoDB tablespace.
Please refer to
InnoDB: https://mariadb.com/kb/en/library/innodb-recovery-modes/
InnoDB: about forcing recovery.
rgaDawg
 
Posts: 5
Joined: 03. December 2022 23:08
XAMPP version: 8.1.12
Operating System: Win11 Pro, Dell 5820 WorkSt

Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 93 guests