Apache Friends Support Forum

I am running a new server on Mac High Sierra (not Xampp), but the old Xampp installation is still installed, just not running at the same time. I've already migrated most of my sites over to the new server with everything there running fine. I have one site for which I need the old database. Migrating databases in the past I have done using pma without trouble many times, however this time I am unable since I can't launch pma anymore. This may be because I've upgraded PHP on my system so it may be incompatible now. Clearing browser cache and cookies, and the server sessions in temp didn't fix it, so I'm suspecting php version issues.

Code: Select all

Error during session start; please check your PHP and/or webserver log file and configure your PHP installation properly. Also ensure that cookies are enabled in your browser.

session_start(): open(SESSION_FILE, O_RDWR) failed: Permission denied (13)

Yes, there is that ugly error again, however before offering all the standard solutions for this, please take the following information into account:

All I need is the mysql data from one site. The easiest way I can do it is using pma but if I have to get it some other way such as using mysql code I'm willing to try but my preference would be to fix pma if it's possible. Since I am going to be destroying the xampp server once I get this final data, I changed the entire Xampp folder and its contents to full read/write permissions for all just to make 100% certain it's not a permissions issue. That didn't work (obviously, or I wouldn't be here).

Any help would be greatly appreciated. Thanks in advance.

EDIT: It appears the Xampp installaton I was running came with PHP5. I've upgraded to PHP7. Is there a way to possibly downgrade back to 5 just long enough to get pma running again just long enough to get the data? Not sure but I'm going to try that first. Hope I don't bust my system but I doubt it. Will be back to report how it goes...

Also, I'm not seeing anything in error logs for Apache. However, the MySQL log is indicating this:

Version: '10.1.38-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:49 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:50 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:50 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:50 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:50 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'min_value' at position 3 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:50 8228 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'max_value' at position 4 to have type varbinary(255), found type varchar(255).
2019-10-18 17:23:50 366c InnoDB: FTS Optimize Removing table bitnami_espocrm/email
2019-10-18 18:53:52 70 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2019-10-18 18:53:52 112 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2019-10-18 18:53:52 112 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2019-10-18 18:53:52 112 [Note] InnoDB: The InnoDB memory heap is disabled
2019-10-18 18:53:52 112 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-10-18 18:53:52 112 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2019-10-18 18:53:52 112 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-10-18 18:53:52 112 [Note] InnoDB: Using generic crc32 instructions
2019-10-18 18:53:52 112 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2019-10-18 18:53:52 112 [Note] InnoDB: Completed initialization of buffer pool
2019-10-18 18:53:52 112 [Note] InnoDB: Highest supported file format is Barracuda.
2019-10-18 18:53:52 112 [Note] InnoDB: The log sequence number 1835037 in ibdata file do not match the log sequence number 230922998 in the ib_logfiles!
2019-10-18 18:53:53 112 [Note] InnoDB: Restoring possible half-written data pages from the doublewrite buffer...
2019-10-18 18:53:53 112 [Note] InnoDB: 128 rollback segment(s) are active.
2019-10-18 18:53:53 112 [Note] InnoDB: Waiting for purge to start
2019-10-18 18:53:53 112 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.42-84.2 started; log sequence number 230922998
2019-10-18 18:53:53 1348 [Note] InnoDB: Dumping buffer pool(s) not yet started
2019-10-18 18:53:53 112 [Note] Plugin 'FEEDBACK' is disabled.
2019-10-18 18:53:53 112 [Note] Server socket created on IP: '::'.
2019-10-18 18:53:53 112 [ERROR] mysqld.exe: Table '.\mysql\user' is marked as crashed and should be repaired
2019-10-18 18:53:53 112 [Warning] Checking table: '.\mysql\user'
2019-10-18 18:53:53 112 [ERROR] mysql.user: 1 client is using or hasn't closed the table properly
2019-10-18 18:53:53 112 [ERROR] mysqld.exe: Table '.\mysql\db' is marked as crashed and should be repaired
2019-10-18 18:53:53 112 [Warning] Checking table: '.\mysql\db'
2019-10-18 18:53:53 112 [ERROR] mysql.db: 1 client is using or hasn't closed the table properly
2019-10-18 18:53:53 112 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '10.1.38-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
2019-10-18 19:12:49 2d18 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2019-10-18 19:12:49 11544 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2019-10-18 19:12:49 11544 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2019-10-18 19:12:49 11544 [Note] InnoDB: The InnoDB memory heap is disabled
2019-10-18 19:12:49 11544 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-10-18 19:12:49 11544 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2019-10-18 19:12:49 11544 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-10-18 19:12:49 11544 [Note] InnoDB: Using generic crc32 instructions
2019-10-18 19:12:49 11544 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2019-10-18 19:12:49 11544 [Note] InnoDB: Completed initialization of buffer pool
2019-10-18 19:12:49 11544 [Note] InnoDB: Highest supported file format is Barracuda.
2019-10-18 19:12:49 11544 [Note] InnoDB: The log sequence number 1835037 in ibdata file do not match the log sequence number 230923008 in the ib_logfiles!
2019-10-18 19:12:50 11544 [Note] InnoDB: Restoring possible half-written data pages from the doublewrite buffer...
2019-10-18 19:12:50 11544 [Note] InnoDB: 128 rollback segment(s) are active.
2019-10-18 19:12:50 11544 [Note] InnoDB: Waiting for purge to start
2019-10-18 19:12:50 11544 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.42-84.2 started; log sequence number 230923008
2019-10-18 19:12:50 13536 [Note] InnoDB: Dumping buffer pool(s) not yet started
2019-10-18 19:12:50 11544 [Note] Plugin 'FEEDBACK' is disabled.
2019-10-18 19:12:50 11544 [Note] Server socket created on IP: '::'.
2019-10-18 19:12:50 11544 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '10.1.38-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
2019-10-18 19:33:04 ab4 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2019-10-18 19:33:04 2740 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2019-10-18 19:33:04 2740 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2019-10-18 19:33:04 2740 [Note] InnoDB: The InnoDB memory heap is disabled
2019-10-18 19:33:04 2740 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-10-18 19:33:04 2740 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2019-10-18 19:33:04 2740 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-10-18 19:33:04 2740 [Note] InnoDB: Using generic crc32 instructions
2019-10-18 19:33:04 2740 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2019-10-18 19:33:04 2740 [Note] InnoDB: Completed initialization of buffer pool
2019-10-18 19:33:04 2740 [Note] InnoDB: Highest supported file format is Barracuda.
2019-10-18 19:33:04 2740 [Note] InnoDB: The log sequence number 1835037 in ibdata file do not match the log sequence number 230923018 in the ib_logfiles!
2019-10-18 19:33:05 2740 [Note] InnoDB: Restoring possible half-written data pages from the doublewrite buffer...
2019-10-18 19:33:05 2740 [Note] InnoDB: 128 rollback segment(s) are active.
2019-10-18 19:33:05 2740 [Note] InnoDB: Waiting for purge to start
2019-10-18 19:33:05 2740 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.42-84.2 started; log sequence number 230923018
2019-10-18 19:33:05 12856 [Note] InnoDB: Dumping buffer pool(s) not yet started
2019-10-18 19:33:05 2740 [Note] Plugin 'FEEDBACK' is disabled.
2019-10-18 19:33:05 2740 [Note] Server socket created on IP: '::'.
2019-10-18 19:33:05 2740 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '10.1.38-MariaDB' socket: '' port: 3306 mariadb.org binary distribution

Poof! the Apache in my xampp decide to stop, and without much help in feedback. Here's the info it provided:
7:12:49 PM [main] Initializing Control Panel
7:12:49 PM [main] Windows Version: Enterprise 64-bit
7:12:49 PM [main] XAMPP Version: 7.3.2
7:12:49 PM [main] Control Panel Version: 3.2.2 [ Compiled: Nov 12th 2015 ]
7:12:49 PM [main] Running with Administrator rights - good!
7:12:49 PM [main] XAMPP Installation Directory: "c:\xampp"
7:12:49 PM [main] Checking for prerequisites
7:12:49 PM [main] All prerequisites found
7:12:49 PM [main] Initializing Modules
7:12:49 PM [main] Enabling autostart for module "Apache"
7:12:49 PM [main] Enabling autostart for module "MySQL"
7:12:49 PM [main] Starting Check-Timer
7:12:49 PM [main] Control Panel Ready
7:12:49 PM [Apache] Autostart active: starting...
7:12:49 PM [Apache] Attempting to start Apache app...
7:12:49 PM [mysql] Autostart active: starting...
7:12:49 PM [mysql] Attempting to start MySQL app...
7:12:50 PM [Apache] Status change detected: running
7:12:50 PM [mysql] Status change detected: running
7:12:50 PM [Apache] Status change detected: stopped
7:12:50 PM [Apache] Error: Apache shutdown unexpectedly.
7:12:50 PM [Apache] This may be due to a blocked port, missing dependencies,
7:12:50 PM [Apache] improper privileges, a crash, or a shutdown by another method.
7:12:50 PM [Apache] Press the Logs button to view error logs and check
7:12:50 PM [Apache] the Windows Event Viewer for more clues
7:12:50 PM [Apache] If you need more help, copy and post this
7:12:50 PM [Apache] entire log window on the forums
7:13:03 PM [mysql] Attempting to stop MySQL app...
7:13:03 PM [mysql] Status change detected: stopped
7:13:19 PM [main] Executing "c:\xampp\apache"
7:17:55 PM [Apache] Attempting to start Apache app...
7:17:55 PM [Apache] Status change detected: running
7:17:56 PM [Apache] Status change detected: stopped
7:17:56 PM [Apache] Error: Apache shutdown unexpectedly.
7:17:56 PM [Apache] This may be due to a blocked port, missing dependencies,
7:17:56 PM [Apache] improper privileges, a crash, or a shutdown by another method.
7:17:56 PM [Apache] Press the Logs button to view error logs and check
7:17:56 PM [Apache] the Windows Event Viewer for more clues
7:17:56 PM [Apache] If you need more help, copy and post this
7:17:56 PM [Apache] entire log window on the forums

I had just (finally) installed ESPOCRM on a Win10Pro system, as a localhost install. That install required making some changes to the PHP settings. Specifially:
max_execution_time, set to 180
max_input_time, set to 180
memory_limit, set to 256M
post_max_size, set to 20M
upload_max_size, set to 20M

After the install returned a success page, I attempted to log in and received an "auth error" message and it didn't open. Thinking I had to re-initialize xampp and stopped Apache and MySQL and attempted to restart them; that's when Apache wouldn't start. The MySQL setup was straight forward and simple. I'd like to tell you want version it is, but without Apache starting the MySQL has taken a break. The forums for the CRM app seem to be leaning to the "auth error" message originating due to an authentication issue in the outbound mail section; and also offering:

Do you use FastCGI? https://github.com/espocrm/documenta...ly-for-fastcgi
https://github.com/espocrm/documenta...nstallation.md
which one step you see the last?

Being a rookie at Apache, with a Windows habit, I'm not sure their advice is in the right direction.

I did save the original php.ini file, but haven't tried copying it back. Thought I trying for advice here first.
Can anyone help???

InnoDB: using atomic writes.
2019-10-18 2:28:44 0 [Note] InnoDB: The first innodb_system data file 'ibdata1' did not exist. A new tablespace will be created!
2019-10-18 2:28:44 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-10-18 2:28:44 0 [Note] InnoDB: Uses event mutexes
2019-10-18 2:28:44 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-10-18 2:28:44 0 [Note] InnoDB: Number of pools: 1
2019-10-18 2:28:44 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-10-18 2:28:44 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-10-18 2:28:44 0 [Note] InnoDB: Completed initialization of buffer pool
2019-10-18 2:28:44 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibdata1' size to 10 MB. Physically writing the file full; Please wait ...
2019-10-18 2:28:44 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibdata1' size is now 10 MB.
2019-10-18 2:28:44 0 [Note] InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile101 size to 5242880 bytes
2019-10-18 2:28:44 0 [Note] InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile1 size to 5242880 bytes
2019-10-18 2:28:44 0 [Note] InnoDB: Renaming log file C:\xampp\mysql\data\ib_logfile101 to C:\xampp\mysql\data\ib_logfile0
2019-10-18 2:28:44 0 [Note] InnoDB: New log files created, LSN=17992
2019-10-18 2:28:44 0 [Note] InnoDB: Doublewrite buffer not found: creating new
2019-10-18 2:28:44 0 [Note] InnoDB: Doublewrite buffer created
2019-10-18 2:28:44 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-10-18 2:28:44 0 [Note] InnoDB: Creating foreign key constraint system tables.
2019-10-18 2:28:44 0 [Note] InnoDB: Creating tablespace and datafile system tables.
2019-10-18 2:28:44 0 [Note] InnoDB: Creating sys_virtual system tables.
2019-10-18 2:28:44 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-10-18 2:28:44 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-10-18 2:28:44 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-10-18 2:28:44 0 [Note] InnoDB: Waiting for purge to start
2019-10-18 2:28:44 0 [Note] InnoDB: 10.4.6 started; log sequence number 0; transaction id 7
2019-10-18 2:28:44 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-10-18 2:28:44 0 [Note] Server socket created on IP: '::'.
[size=150][/size]

I have experienced a similar problem on XAMPP 7.3.5 when Windows 10 1903 did an cumulative update kb4524100 & Kb2517389.
I suspect it rebooted without stopping background processes.
This does not occur when rebooting from the start menu.
I didn't try the repair, I restored a backup.

InnoDB: using atomic writes.
2019-10-12 1:19:50 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-10-12 1:19:50 0 [Note] InnoDB: Uses event mutexes
2019-10-12 1:19:50 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-10-12 1:19:50 0 [Note] InnoDB: Number of pools: 1
2019-10-12 1:19:50 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-10-12 1:19:50 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-10-12 1:19:50 0 [Note] InnoDB: Completed initialization of buffer pool
2019-10-12 1:19:50 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-10-12 1:19:50 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-10-12 1:19:50 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-10-12 1:19:50 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-10-12 1:19:50 0 [Note] InnoDB: Waiting for purge to start
2019-10-12 1:19:51 0 [Note] InnoDB: 10.4.8 started; log sequence number 294606; transaction id 138
2019-10-12 1:19:51 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2019-10-12 1:19:51 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-10-12 1:19:51 0 [Note] Server socket created on IP: '::'.
2019-10-12 1:19:51 0 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.


2019-10-12 1:19:51 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2019-10-12 1:19:51 0 [ERROR] Aborting
InnoDB: using atomic writes.
2019-10-12 1:21:30 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-10-12 1:21:30 0 [Note] InnoDB: Uses event mutexes
2019-10-12 1:21:30 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-10-12 1:21:30 0 [Note] InnoDB: Number of pools: 1
2019-10-12 1:21:30 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-10-12 1:21:30 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-10-12 1:21:30 0 [Note] InnoDB: Completed initialization of buffer pool
2019-10-12 1:21:30 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-10-12 1:21:30 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-10-12 1:21:30 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-10-12 1:21:30 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-10-12 1:21:30 0 [Note] InnoDB: Waiting for purge to start
2019-10-12 1:21:30 0 [Note] InnoDB: 10.4.8 started; log sequence number 294615; transaction id 138
2019-10-12 1:21:30 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2019-10-12 1:21:30 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-10-12 1:21:30 0 [Note] Server socket created on IP: '::'.
2019-10-12 1:21:30 0 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.


2019-10-12 1:21:30 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2019-10-12 1:21:30 0 [ERROR] Aborting
InnoDB: using atomic writes.
2019-10-12 1:26:48 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-10-12 1:26:48 0 [Note] InnoDB: Uses event mutexes
2019-10-12 1:26:48 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-10-12 1:26:48 0 [Note] InnoDB: Number of pools: 1
2019-10-12 1:26:48 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-10-12 1:26:48 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-10-12 1:26:48 0 [Note] InnoDB: Completed initialization of buffer pool
2019-10-12 1:26:48 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-10-12 1:26:48 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-10-12 1:26:48 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-10-12 1:26:48 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-10-12 1:26:48 0 [Note] InnoDB: Waiting for purge to start
2019-10-12 1:26:48 0 [Note] InnoDB: 10.4.8 started; log sequence number 294624; transaction id 138
2019-10-12 1:26:48 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2019-10-12 1:26:48 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-10-12 1:26:48 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2019-10-12 1:42:55 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-10-12 1:42:55 0 [Note] InnoDB: Uses event mutexes
2019-10-12 1:42:55 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-10-12 1:42:55 0 [Note] InnoDB: Number of pools: 1
2019-10-12 1:42:55 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-10-12 1:42:55 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-10-12 1:42:55 0 [Note] InnoDB: Completed initialization of buffer pool
2019-10-12 1:42:55 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=294624
2019-10-12 1:42:55 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-10-12 1:42:55 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-10-12 1:42:55 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-10-12 1:42:55 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-10-12 1:42:55 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-10-12 1:42:55 0 [Note] InnoDB: Waiting for purge to start
2019-10-12 1:42:55 0 [Note] InnoDB: 10.4.8 started; log sequence number 294633; transaction id 138
2019-10-12 1:42:55 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2019-10-12 1:42:55 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-10-12 1:42:55 0 [Note] Server socket created on IP: '::'.

When I try to start all services in the XAMPP Mac client, MySQL starts but not ProFTPD and Apache. I get these error messages in the log:

Code: Select all

ERROR: Failed to start "proftpd": cannot start service: debian proftpd[551]: Fatal: unable to read configuration file '/opt/lampp/etc/proftpd.conf': No such file or directory

ERROR: Failed to start "apache": cannot start service: httpd: Could not open configuration file /opt/lampp/etc/httpd.conf: No such file or directory

If I check in the /etc/ folder, the files proftpd.conf and httpd.conf as well as other files that might be there are missing and all the subfolders have empty files.

In my /htdocs/ folder, all my folders there for WordPress installations seems to be missing files in their root folder (such as .htaccess, wp-config.php, different essential WP install files). The same goes for the /wp-admin/, /wp-includes/ and /wp-content/-folders where most of the files seems to be missing, even uploaded images. I can't find these files in the trash because I have unfortunately emptied my trash before I noticed this issue.

I tried to copy the remaining files from one of the subfolders in /htdocs/, but then I get a message about not enough permission:

Code: Select all

Items can’t be copied to [my destination folder] because you don’t have permission to read them.

I don't remember doing anything special that might have caused this. I use FileZilla for transfering files and VPN services from time to time.

Things I have tried:
- Restart and shut down computer
- Restart XAMPP Services, mount volume, start network in different orders
- Show/hide hidden files in lampp folder
- Starting XAMPP services with and without VPN running
- Starting services with localhost port set to 81

The most important thing for me now is to access one of my databases, that's what's keeping me from doing a full re-install of XAMPP.
If I look up the folder now in /lampp/var/mysql/, it's 0 bytes and I don't have permission to open it.

Is there a way for me to get back permissions and recover my database?

Hi,

I am using xampp, version v3.2.4 on windows 10. I am having a lot of troubles using xampp these days. As it crashes again and again. Then i have to reinstall it again to make it work, as none of other solutions were helpful. I have happened almost 10-15 times now. I shut down my pc and when i start it next day, it doesn't work. Dont know what goes wrong there. Please let me know the solution to this, as i am very frustrated with doing install/ uninstall the xampp and then creating dbs again.

Below is the error that i get in xampp window

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


If you need full log from mysql_error.log, here it is

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

Recently used Xampp to set up a Windows 10 machine and would now like to have Apache and MySQL run as a Windows service automatically on boot up. A tutorial had me run shell:start and drop shortcuts to Apache and MySQL into the directory that shell:start took me to (I assume this is familiar to you all, else I'll spell it out).

The Apache shortcut is httpd.exe (don't recall where I got that) and I made a shotcut of mysql.exe, thinking that appropriate. Result...

On boot up (1) Apache: an empty black MS-DOS level command screen comes up and stays up for httpd.exe. Apache is running (per Xampp control) but if I close the screen, Apache dies, (2) MySQL, the black screen comes up but quickly disappears and MySQL is not running in Xampp Control.

I'm hoping simply to see both running in Xampp control with no residual black screens. Anyone see what I've done wrong?

Steve

Hallo zusammen,

Bei meiner XAMPP - Installation startet MySQL nicht, Apache funktioniert aber ohne Probleme.

Das ist der Inhalt der MySQL-Log-Datei:

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

Mein Betriebssystem ist Windows 10 Pro v1903, und ich benutze XAMPP v3.2.4.

Danke schon mal im Voraus!

Hi guys

Just installed and setup xampp, all working fine, I then downloaded and setup Orangehms and now I can't start Apache or MySQL.

I've not changed any setting myself, and I've restarted the pc. All was working fine until this?

Any help

Some time ago I installed a new version of Xampp, then today I decided I needed to get started on it again. I initially found the wrong control-xampp.exe file and it displayed lots of errors when attempting to start Apache and MySQL. So restarted my computer and found the right file to run. So that looked better - tells me it is XAMPP Control Panel v3.2.4 (compile Mar 7th 2019). My browser will open localhost and phpMyAdmin shows all my databases. But if I try to open a site, instead of getting a webpage, I get the install script. And it won't install over an existing database anyway.
When I tried to set up a new site from scratch using Wordpress it produced some php errors, but appeared to run the install up to step 2. When I tried to get into the back end, I got more errors:

Code: Select all

Warning: Illegal string offset 'remember' in D:\xamppnew\htdocs\mysterytest\wp-includes\user.php on line 39

Warning: Cannot assign an empty string to a string offset in D:\xamppnew\htdocs\mysterytest\wp-includes\user.php on line 39

Warning: Illegal string offset 'user_login' in D:\xamppnew\htdocs\mysterytest\wp-includes\user.php on line 54

Fatal error: Uncaught Error: Cannot create references to/from string offsets in D:\xamppnew\htdocs\mysterytest\wp-includes\user.php:54 Stack trace: #0 D:\xamppnew\htdocs\mysterytest\wp-login.php(770): wp_signon('', '') #1 {main} thrown in D:\xamppnew\htdocs\mysterytest\wp-includes\user.php on line 54

What have I done wrong? Should I try re-installing XAMPP? How can I recover all my old testing sites?

I have installed the Bitnami XAMPP

XAMPP for Linux 64bit 5.6.40-1
having
- PHP to 5.6.40
- MariaDB to 10.1.37
- OpenSSL 1.0.2q
installed on Debian GNU Linux 9
I tried to start my xampp for linux

Code: Select all

tanzeem@debian-tzm:~$ sudo /opt/lampp/lampp restart
[sudo] password for tanzeem:
Restarting XAMPP for Linux 5.6.40-1...
XAMPP: Stopping Apache...ok.
XAMPP: Stopping MySQL...not running.
XAMPP: Stopping ProFTPD...ok.
XAMPP: Starting Apache...ok.
XAMPP: Starting MySQL...ok.
XAMPP: Starting ProFTPD...ok.

Immediately the mysql server stops automatically with the following message

Code: Select all

 /opt/lampp/bin/mysql.server: 264: kill: No such process

I have the following entries int /etc/mysql even after I uninstalled my default mysql server
debian.cnf koha-common.cnf mariadb.conf.d/
debian-start mariadb.cnf

Part of Content of file `/opt/lampp/var/mysql/<hostname>.err` for the date after reinstalling xampp and when tried to start xampp in linux is attached:

Code: Select all

2019-10-01 13:22:46 6702 mysqld_safe Starting mysqld daemon with databases from /opt/lampp/var/mysql
2019-10-01 13:22:47 140061563180864 [Note] Using unique option prefix 'key_buffer' is error-prone and can break in the future. Please use the full name 'key_buffer_size' instead.
2019-10-01 13:22:47 140061563180864 [Note] /opt/lampp/sbin/mysqld (mysqld 10.1.38-MariaDB) starting as process 6850 ...
2019-10-01 13:22:47 140061563180864 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2019-10-01 13:22:47 140061563180864 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2019-10-01 13:22:47 140061563180864 [Note] InnoDB: The InnoDB memory heap is disabled
2019-10-01 13:22:47 140061563180864 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-10-01 13:22:47 140061563180864 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier
2019-10-01 13:22:47 140061563180864 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-10-01 13:22:47 140061563180864 [Note] InnoDB: Using generic crc32 instructions
2019-10-01 13:22:47 140061563180864 [ERROR] mysqld: Can't create/write to file '/tmp/user/0/ibu62mPf' (Errcode: 13 "Permission denied")
2019-10-01 13:22:47 7f629fb85740  InnoDB: Error: unable to create temporary file; errno: 13
2019-10-01 13:22:47 140061563180864 [ERROR] Plugin 'InnoDB' init function returned error.
2019-10-01 13:22:47 140061563180864 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-10-01 13:22:48 140061563180864 [Note] Plugin 'FEEDBACK' is disabled.
2019-10-01 13:22:48 140061563180864 [ERROR] Unknown/unsupported storage engine: InnoDB
2019-10-01 13:22:48 140061563180864 [ERROR] Aborting

2019-10-01 13:22:48 6702 mysqld_safe mysqld from pid file /opt/lampp/var/mysql/debian-tzm.pid ended
2019-10-01 13:24:16 7244 mysqld_safe Starting mysqld daemon with databases from /opt/lampp/var/mysql
2019-10-01 13:24:16 140082405451584 [Note] Using unique option prefix 'key_buffer' is error-prone and can break in the future. Please use the full name 'key_buffer_size' instead.
2019-10-01 13:24:16 140082405451584 [Note] /opt/lampp/sbin/mysqld (mysqld 10.1.38-MariaDB) starting as process 7389 ...
2019-10-01 13:24:16 140082405451584 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2019-10-01 13:24:16 140082405451584 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2019-10-01 13:24:16 140082405451584 [Note] InnoDB: The InnoDB memory heap is disabled
2019-10-01 13:24:16 140082405451584 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-10-01 13:24:16 140082405451584 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier
2019-10-01 13:24:16 140082405451584 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-10-01 13:24:16 140082405451584 [Note] InnoDB: Using generic crc32 instructions
2019-10-01 13:24:16 140082405451584 [ERROR] mysqld: Can't create/write to file '/tmp/user/0/ibPSJwOL' (Errcode: 13 "Permission denied")
2019-10-01 13:24:16 7f677a042740  InnoDB: Error: unable to create temporary file; errno: 13
2019-10-01 13:24:16 140082405451584 [ERROR] Plugin 'InnoDB' init function returned error.
2019-10-01 13:24:16 140082405451584 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-10-01 13:24:16 140082405451584 [Note] Plugin 'FEEDBACK' is disabled.
2019-10-01 13:24:16 140082405451584 [ERROR] Unknown/unsupported storage engine: InnoDB
2019-10-01 13:24:16 140082405451584 [ERROR] Aborting

2019-10-01 13:24:16 7244 mysqld_safe mysqld from pid file /opt/lampp/var/mysql/debian-tzm.pid ended
2019-10-01 13:25:47 7799 mysqld_safe Starting mysqld daemon with databases from /opt/lampp/var/mysql
2019-10-01 13:25:47 140061192259392 [Note] Using unique option prefix 'key_buffer' is error-prone and can break in the future. Please use the full name 'key_buffer_size' instead.
2019-10-01 13:25:47 140061192259392 [Note] /opt/lampp/sbin/mysqld (mysqld 10.1.38-MariaDB) starting as process 7946 ...
2019-10-01 13:25:47 140061192259392 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2019-10-01 13:25:48 140061192259392 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2019-10-01 13:25:48 140061192259392 [Note] InnoDB: The InnoDB memory heap is disabled
2019-10-01 13:25:48 140061192259392 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-10-01 13:25:48 140061192259392 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier
2019-10-01 13:25:48 140061192259392 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-10-01 13:25:48 140061192259392 [Note] InnoDB: Using generic crc32 instructions
2019-10-01 13:25:48 140061192259392 [ERROR] mysqld: Can't create/write to file '/tmp/user/0/ibtoby2q' (Errcode: 13 "Permission denied")
2019-10-01 13:25:48 7f62899c8740  InnoDB: Error: unable to create temporary file; errno: 13
2019-10-01 13:25:48 140061192259392 [ERROR] Plugin 'InnoDB' init function returned error.
2019-10-01 13:25:48 140061192259392 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-10-01 13:25:48 140061192259392 [Note] Plugin 'FEEDBACK' is disabled.
2019-10-01 13:25:48 140061192259392 [ERROR] Unknown/unsupported storage engine: InnoDB
2019-10-01 13:25:48 140061192259392 [ERROR] Aborting

2019-10-01 13:25:48 7799 mysqld_safe mysqld from pid file /opt/lampp/var/mysql/debian-tzm.pid ended
2019-10-01 14:50:43 2896 mysqld_safe Starting mysqld daemon with databases from /opt/lampp/var/mysql
2019-10-01 14:50:44 139657902384960 [Note] Using unique option prefix 'key_buffer' is error-prone and can break in the future. Please use the full name 'key_buffer_size' instead.
2019-10-01 14:50:44 139657902384960 [Note] /opt/lampp/sbin/mysqld (mysqld 10.1.38-MariaDB) starting as process 3041 ...
2019-10-01 14:50:44 139657902384960 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2019-10-01 14:50:44 139657902384960 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2019-10-01 14:50:44 139657902384960 [Note] InnoDB: The InnoDB memory heap is disabled
2019-10-01 14:50:44 139657902384960 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-10-01 14:50:44 139657902384960 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier
2019-10-01 14:50:44 139657902384960 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-10-01 14:50:44 139657902384960 [Note] InnoDB: Using generic crc32 instructions
2019-10-01 14:50:44 139657902384960 [ERROR] mysqld: Can't create/write to file '/tmp/user/0/ibVmFshy' (Errcode: 13 "Permission denied")
2019-10-01 14:50:44 7f04a3a96740  InnoDB: Error: unable to create temporary file; errno: 13
2019-10-01 14:50:44 139657902384960 [ERROR] Plugin 'InnoDB' init function returned error.
2019-10-01 14:50:44 139657902384960 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-10-01 14:50:44 139657902384960 [Note] Plugin 'FEEDBACK' is disabled.
2019-10-01 14:50:44 139657902384960 [ERROR] Unknown/unsupported storage engine: InnoDB
2019-10-01 14:50:44 139657902384960 [ERROR] Aborting

2019-10-01 14:50:44 2896 mysqld_safe mysqld from pid file /opt/lampp/var/mysql/debian-tzm.pid ended
2019-10-01 15:22:43 3503 mysqld_safe Starting mysqld daemon with databases from /opt/lampp/var/mysql
2019-10-01 15:22:44 140687290926912 [Note] Using unique option prefix 'key_buffer' is error-prone and can break in the future. Please use the full name 'key_buffer_size' instead.
2019-10-01 15:22:44 140687290926912 [Note] /opt/lampp/sbin/mysqld (mysqld 10.1.38-MariaDB) starting as process 3648 ...
2019-10-01 15:22:44 140687290926912 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2019-10-01 15:22:44 140687290926912 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2019-10-01 15:22:44 140687290926912 [Note] InnoDB: The InnoDB memory heap is disabled
2019-10-01 15:22:44 140687290926912 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-10-01 15:22:44 140687290926912 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier
2019-10-01 15:22:44 140687290926912 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-10-01 15:22:44 140687290926912 [Note] InnoDB: Using generic crc32 instructions
2019-10-01 15:22:44 140687290926912 [ERROR] mysqld: Can't create/write to file '/tmp/user/0/ibLoJISK' (Errcode: 13 "Permission denied")
2019-10-01 15:22:44 7ff450000740  InnoDB: Error: unable to create temporary file; errno: 13
2019-10-01 15:22:44 140687290926912 [ERROR] Plugin 'InnoDB' init function returned error.
2019-10-01 15:22:44 140687290926912 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-10-01 15:22:44 140687290926912 [Note] Plugin 'FEEDBACK' is disabled.
2019-10-01 15:22:44 140687290926912 [ERROR] Unknown/unsupported storage engine: InnoDB
2019-10-01 15:22:44 140687290926912 [ERROR] Aborting

2019-10-01 15:22:44 3503 mysqld_safe mysqld from pid file /opt/lampp/var/mysql/debian-tzm.pid ended

I am unable to start the MySQL database from XAMPP control panel. I need to shutdown the server on 15/09/2019 due to some power issue, and turning it ON on today; i.e. on 25/09/2019. some of the snapshots of the mysql_error.log are as follows:
2019-09-15 10:33:32 d3c InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2019-09-15 10:33:32 3388 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2019-09-15 10:33:32 3388 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2019-09-15 10:33:32 3388 [Note] InnoDB: The InnoDB memory heap is disabled
2019-09-15 10:33:32 3388 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-09-15 10:33:32 3388 [Note] InnoDB: _mm_lfence() and _mm_sfence() are u2s019e-d0 9f-o1r5 m1e0m:o3r3y: 3b2a rer0icer
InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and wit2h 0t1h9e- 0I9n-n1o5D B1'0s: 3i3n:t3e2r n3a3l8 8m e[mNoortye ]a lIlnnoocDaBt:o rC.o
mpr2e01s9s-e0d9 -t1a5b l1e0s: 3u3s:e3 2z l3i5b9 61 .[2N.o3t
e] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2019-09-15 10:33:32 3388 [Note] InnoDB: Using generic crc32 instructions
2019-09-15 10:33:32 3388 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2019-09-15 10:33:32 3388 [Note] InnoDB: Completed initialization of buffer pool
2019-09-15 10:33:32 3596 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2019-09-15 10:33:32 3596 [Note] InnoDB: The InnoDB memory heap is disabled
2019-09-15 10:33:32 3596 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-09-15 10:33:32 3596 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2019-09-15 10:33:32 3596 [Note] InnoDB: Compressed tables use zlib 1.2.3
2019-09-15 10:33:32 3596 [Note] InnoDB: Using generic crc32 instructions
2019-09-15 10:33:32 3596 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2019-09-15 10:33:32 3596 [Note] InnoDB: Completed initialization of buffer pool
2019-09-15 10:33:32 ea4 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2019-09-15 10:33:32 3748 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2019-09-15 10:33:32 d3c InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
2019-09-15 10:33:32 3748 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2019-09-15 10:33:32 3748 [Note] InnoDB: The InnoDB memory heap is disabled
2019-09-15 10:33:32 3748 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-09-15 10:33:32 3748 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2019-09-15 10:33:32 3748 [Note] InnoDB: Compressed tables use zlib 1.2.3
2019-09-15 10:33:32 3748 [Note] InnoDB: Using generic crc32 instructi2o0n1s9
-09-15 10:33:32 3596 [Note] InnoDB: Highest supported file format is Barracuda.
2019-09-15 10:33:32 3748 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2019-09-15 10:33:32 3748 [Note] InnoDB: Completed initialization of buffer pool
2019-09-15 10:33:32 684 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2019-09-15 10:33:32 1668 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2019-09-15 10:33:32 3748 [ERROR] InnoDB: D:\xampp\mysql\data\ibdata1 can't be opened in read-write mode
2019-09-15 10:33:32 3748 [ERROR] InnoDB: The system tablespace must be writable!
2019-09-15 10:33:32 3748 [ERROR] Plugin 'InnoDB' init function returned error.
2019-09-15 10:33:32 3748 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-09-15 10:33:32 3596 [Note] InnoDB: The log sequence number 1835037 in ibdata file do not match the log sequence number 89329480 in the ib_logfiles!
2019-09-15 10:33:32 3748 [Note] Plugin 'FEEDBACK' is disabled.
2019-09-15 10:33:32 3748 [ERROR] Unknown/unsupported storage engine: InnoDB
2019-09-15 10:33:32 3748 [ERROR] Aborting

2019-09-15 10:33:32 1668 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2019-09-15 10:33:32 1668 [Note] InnoDB: The InnoDB memory heap is disabled
2019-09-15 10:33:32 1668 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-09-15 10:33:32 1668 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2019-09-15 10:33:32 1668 [Note] InnoDB: Compressed tables use zlib 1.2.3
2019-09-15 10:33:32 1668 [Note] InnoDB: Using generic crc32 instructions
2019-09-15 10:33:32 1668 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2019-09-15 10:33:32 1668 [Note] InnoDB: Completed initialization of buffer pool
2019-09-15 10:33:32 ff0 InnoDB: Warning: Using innodb_additional_mem_p2o0o1l9_-si0z9e- 1i5s 1D0E:P3R3E:C3A2T E1D6.6 8T h[iEsR RoOpRt]i oInn nmoaDyB :b eD :r\exmaomvpepd\ miyns qflu\tduartea \riebldeaatsae1s ,c atno'gte tbhee ro pweintehd tihne roepatdi-ownr iitnen omdobd_eu
se_sys_malloc and with the InnoDB's internal memory allocator.
2019-09-15 10:33:32 4080 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use ba2ck0o1f9f-,0 9i-n1c5r e1a0s:e3 3b:u3f2f e1r6 6p8o o[lE RaRtO Rl]e aIsntn ouDpB :t oT h2e0 MsBy.s
t
em tablespace must be writable!
2019-09-15 10:33:32 1668 [ERROR] Plugin 'InnoDB' init function returned error.
2019-09-15 10:33:32 1668 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-09-15 10:33:32 1668 [Note] Plugin 'FEEDBACK' is disabled.
2019-09-15 10:33:32 1668 [ERROR] Unknown/unsupported storage engine: InnoDB
2019-09-15 10:33:32 1668 [ERROR] Aborting

2019-09-15 10:33:32 4080 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2019-09-15 10:33:32 4080 [Note] InnoDB: The InnoDB memory heap is disabled
2019-09-15 10:33:32 4080 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-09-15 10:33:32 4080 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2019-09-15 10:33:32 4080 [Note] InnoDB: Compressed tables use zlib 1.2.3
2019-09-15 10:33:32 4080 [Note] InnoDB: Using generic crc32 instructions
2019-09-15 10:33:32 4080 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2019-09-15 10:33:32 4080 [Note] InnoDB: Completed initialization of buffer pool
2019-09-15 10:33:32 2e8 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2019-09-15 10:33:32 744 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to2 02109M-B0.9
-
15 10:33:32 4080 [ERROR] InnoDB: D:\xampp\mysql\data\ibdata1 can't be opened in read-write mode
2019-09-15 10:33:32 4080 [ERROR] InnoDB: The system tablespace must be writable!
2019-09-15 10:33:32 4080 [ERROR] Plugin 'InnoDB' init function returned error.
2019-09-15 10:33:32 4080 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-09-15 10:33:32 744 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2019-09-15 10:33:32 744 [Note] InnoDB: The InnoDB memory heap is disabled
2019-09-15 10:33:32 744 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-09-15 10:33:32 744 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2019-09-15 10:33:32 744 [Note] InnoDB: Compressed tables use zlib 1.2.3
2019-09-15 10:33:32 744 [Note] InnoDB: Using generic crc32 instructions
2019-09-15 10:33:32 744 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2019-09-15 10:33:32 744 [Note] InnoDB: Completed initialization of buffer pool
2019-09-15 10:33:32 744 [ERROR] InnoDB: D:\xampp\mysql\data\ibdata1 can't be opened in read-writCeanno tm ofdien
d checkpoint record at LSN (1,0x208b)

2019-09-15 10:33:32 4080 [ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
2019-09-15 10:33:32 744 [ERROR] InnoDB: The system tablespace must be writab2l0e1!9
-09-15 10:33:32 4080 [ERROR] Plugin 'Aria' init function returned error.
2019-09-15 10:33:32 744 [ERROR] Plugin 'InnoDB' init function returned error.
2019-09-15 10:33:32 4080 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2019-09-15 10:33:32 744 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-09-15 10:33:32 4080 [Note] Plugin 'FEEDBACK' is disabled.
2019-09-15 10:33:32 674 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2019-09-15 10:33:32 1652 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2019-09-15 10:33:32 4080 [ERROR] Unknown/unsupported storage engine: InnoDB
2019-09-15 10:33:32 4080 [ERROR] Aborting

Cannot find checkpoint record at LSN (1,0x208b)

2019-09-15 10:33:32 744 [ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
2019-09-15 10:33:32 744 [ERROR] Plugin 'Aria' init function returned error.
2019-09-15 10:33:32 744 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2019-09-15 10:33:32 744 [Note] Plugin 'FEEDBACK' is disabled.
2019-09-15 10:33:32 744 [ERROR] Unknown/unsupported storage engine: InnoDB
2019-09-15 10:33:32 744 [ERROR] Aborting

2019-09-15 10:33:32 1652 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2019-09-15 10:33:32 1652 [Note] InnoDB: The InnoDB memory heap is disabled
2019-09-15 10:33:32 1652 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-09-15 10:33:32 f94 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the 2I0n1n9o-D0B9'-s1 5i n1t0e:rn3a3l: 3m2e m1o6r5y2 a[llNooctaet]o rI.n
noDB2:0 1_9m-m0_9l-f1e5n c1e0(:)3 3a:n3d2 _3m9m8_8s f[eNnoctee]( )I nanroDeB : iunsneodd bf_oerm pmteym_ofrrye eb_alrirsite_ra
lgorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2019-09-15 10:33:32 1652 [Note] InnoDB: Compressed tables use zlib 1.2.3
2019-09-15 10:33:32 1652 [Note] InnoDB: Using generic crc32 instructions
2019-09-15 10:33:32 1652 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2019-09-15 10:33:32 1652 [Note] InnoDB: Completed initialization of buffer pool
2019-09-15 10:33:32 1652 [ERROR] InnoDB: D:\xampp\mysql\data\ibdata1 can't be opened in read-write mode
2019-09-15 10:33:32 3988 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2019-09-15 10:33:32 1652 [ERROR] InnoDB: The system tablespace must be writ2a0b1l9-e0!9
-15 10:33:32 3988 [Note] InnoDB: The InnoDB memory heap is disabled
2019-09-15 10:33:32 1652 [ERROR] Plugin 'InnoDB' init function returned error.
2019-09-15 10:33:32 1652 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-09-15 10:33:32 3988 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-09-15 10:33:32 3988 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2019-09-15 10:33:32 3988 [Note] InnoDB: Compressed tables use zlib 1.2.3
2019-09-15 10:33:32 3988 [Note] InnoDB: Using generic crc32 instructions
2019-09-15 10:33:32 3988 [Note] InnoDB: Initializing buffer pool, size = 16.0M
Cannot find checkpoint record at LSN (1,0x208b)

2019-09-15 10:33:32 1652 [ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
2019-09-15 10:33:32 1652 [ERROR] Plugin 'Aria' init function returned error.
2019-09-15 10:33:32 1652 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2019-09-15 10:33:32 1652 [Note] Plugin 'FEEDBACK' is disabled.
2019-09-15 10:33:32 3988 [Note] InnoDB: Completed initialization of buffer pool
2019-09-15 10:33:32 1652 [ERROR] Unknown/unsupported storage engine: InnoDB
2019-09-15 10:33:32 1652 [ERROR] Aborting

2019-09-15 10:33:32 cb4 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2019-09-15 10:33:32 3252 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2019-09-15 10:33:32 3988 [ERROR] InnoDB: D:\xampp\mysql\data\ibdata1 can't be opened in read-write mode
2019-09-15 10:33:32 3988 [ERROR] InnoDB: The system tablespace must be writable!
2019-09-15 10:33:32 3988 [ERROR] Plugin 'InnoDB' init function returned error.
2019-09-15 10:33:32 3988 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
Cannot find checkpoint record at LSN (1,0x208b)

2019-09-15 10:33:32 3988 [ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
2019-09-15 10:33:32 3988 [ERROR] Plugin 'Aria' init function returned error.
2019-09-15 10:33:32 3988 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2019-09-15 10:33:32 3988 [Note] Plugin 'FEEDBACK' is disabled.
2019-09-15 10:33:32 3988 [ERROR] Unknown/unsupported storage engine: InnoDB
2019-09-15 10:33:32 3988 [ERROR] Aborting

2019-09-15 10:33:32 3252 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2019-09-15 10:33:32 3252 [Note] InnoDB: The InnoDB memory heap is disabled
2019-09-15 10:33:32 3252 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-09-15 10:33:32 3252 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2019-09-15 10:33:32 3252 [Note] InnoDB: Compressed tables use zlib 1.2.3
2019-09-15 10:33:32 3252 [Note] InnoDB: Using generic crc32 instructions
2019-09-15 10:33:32 3252 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2019-09-15 10:33:32 3252 [Note] InnoDB: Completed initialization of buffer pool
2019-09-15 10:33:32 3252 [ERROR] InnoDB: D:\xampp\mysql\data\ibdata1 can't be opened in read-write mode
2019-09-15 10:33:32 3252 [ERROR] InnoDB: The system tablespace must be writable!
2019-09-15 10:33:32 3252 [ERROR] Plugin 'InnoDB' init function returned error.
2019-09-15 10:33:32 3252 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-09-15 10:33:32 f58 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2019-09-15 10:33:32 3928 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

Cannot find checkpoint record at LSN (1,0x208b)

2019-09-15 10:33:32 3252 [ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
2019-09-15 10:33:32 3252 [ERROR] Plugin 'Aria' init function returned error.
2019-09-15 10:33:32 3252 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2019-09-15 10:33:32 3252 [Note] Plugin 'FEEDBACK' is disabled.
2019-09-15 10:33:32 3252 [ERROR] Unknown/unsupported storage engine: InnoDB
2019-09-15 10:33:32 3252 [ERROR] Aborting

I am running Wordpress on a local enviorment and suddenly MySQL crashed, and after that it crashed every time i tried accessing localhost. I added "innodb_flush_method=normal" to my.ini as I saw that may solve it but no luck. I can access http://localhost/phpmyadmin/. This is MySQL crash log with default config.

Code: Select all

InnoDB: using atomic writes.
2019-09-18 21:38:52 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-09-18 21:38:52 0 [Note] InnoDB: Uses event mutexes
2019-09-18 21:38:52 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-09-18 21:38:52 0 [Note] InnoDB: Number of pools: 1
2019-09-18 21:38:52 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-09-18 21:38:52 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-09-18 21:38:52 0 [Note] InnoDB: Completed initialization of buffer pool
2019-09-18 21:38:52 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-09-18 21:38:52 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-09-18 21:38:52 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-09-18 21:38:52 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-09-18 21:38:52 0 [Note] InnoDB: Waiting for purge to start
2019-09-18 21:38:52 0 [Note] InnoDB: 10.4.6 started; log sequence number 294606; transaction id 138
2019-09-18 21:38:52 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-09-18 21:38:52 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool
2019-09-18 21:38:52 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2019-09-18 22:41:42 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-09-18 22:41:42 0 [Note] InnoDB: Uses event mutexes
2019-09-18 22:41:42 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-09-18 22:41:42 0 [Note] InnoDB: Number of pools: 1
2019-09-18 22:41:42 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-09-18 22:41:42 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-09-18 22:41:42 0 [Note] InnoDB: Completed initialization of buffer pool
2019-09-18 22:41:42 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=2936196
2019-09-18 22:41:42 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-09-18 22:41:42 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-09-18 22:41:42 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-09-18 22:41:42 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-09-18 22:41:42 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-09-18 22:41:42 0 [Note] InnoDB: Waiting for purge to start
2019-09-18 22:41:42 0 [Note] InnoDB: 10.4.6 started; log sequence number 2936205; transaction id 2472
2019-09-18 22:41:42 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool
2019-09-18 22:41:42 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-09-18 22:41:42 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2019-09-22 15:50:48 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-09-22 15:50:48 0 [Note] InnoDB: Uses event mutexes
2019-09-22 15:50:48 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-09-22 15:50:48 0 [Note] InnoDB: Number of pools: 1
2019-09-22 15:50:48 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-09-22 15:50:48 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-09-22 15:50:48 0 [Note] InnoDB: Completed initialization of buffer pool
2019-09-22 15:50:48 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=62890796
2019-09-22 15:50:48 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-09-22 15:50:48 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-09-22 15:50:48 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-09-22 15:50:48 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-09-22 15:50:48 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-09-22 15:50:48 0 [Note] InnoDB: Waiting for purge to start
2019-09-22 15:50:48 0 [Note] InnoDB: 10.4.6 started; log sequence number 62890805; transaction id 67156
2019-09-22 15:50:48 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool
2019-09-22 15:50:48 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-09-22 15:50:48 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2019-09-23 21:15:15 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-09-23 21:15:15 0 [Note] InnoDB: Uses event mutexes
2019-09-23 21:15:15 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-09-23 21:15:15 0 [Note] InnoDB: Number of pools: 1
2019-09-23 21:15:15 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-09-23 21:15:15 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-09-23 21:15:15 0 [Note] InnoDB: Completed initialization of buffer pool
2019-09-23 21:15:15 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=131145675
2019-09-23 21:15:16 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-09-23 21:15:16 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-09-23 21:15:16 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-09-23 21:15:16 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-09-23 21:15:16 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-09-23 21:15:16 0 [Note] InnoDB: Waiting for purge to start
2019-09-23 21:15:16 0 [Note] InnoDB: 10.4.6 started; log sequence number 131145684; transaction id 182907
2019-09-23 21:15:16 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool
2019-09-23 21:15:16 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-09-23 21:15:16 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2019-09-23 21:17:01 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-09-23 21:17:01 0 [Note] InnoDB: Uses event mutexes
2019-09-23 21:17:01 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-09-23 21:17:01 0 [Note] InnoDB: Number of pools: 1
2019-09-23 21:17:01 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-09-23 21:17:01 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-09-23 21:17:01 0 [Note] InnoDB: Completed initialization of buffer pool
2019-09-23 21:17:01 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=131145693
2019-09-23 21:17:01 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-09-23 21:17:01 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-09-23 21:17:01 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-09-23 21:17:01 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-09-23 21:17:01 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-09-23 21:17:01 0 [Note] InnoDB: Waiting for purge to start
2019-09-23 21:17:02 0 [Note] InnoDB: 10.4.6 started; log sequence number 131145702; transaction id 182907
2019-09-23 21:17:02 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool
2019-09-23 21:17:02 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-09-23 21:17:02 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2019-09-23 21:17:43 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-09-23 21:17:43 0 [Note] InnoDB: Uses event mutexes
2019-09-23 21:17:43 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-09-23 21:17:43 0 [Note] InnoDB: Number of pools: 1
2019-09-23 21:17:43 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-09-23 21:17:43 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-09-23 21:17:43 0 [Note] InnoDB: Completed initialization of buffer pool
2019-09-23 21:17:43 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=131145711
2019-09-23 21:17:44 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-09-23 21:17:44 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-09-23 21:17:44 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-09-23 21:17:44 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-09-23 21:17:44 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-09-23 21:17:44 0 [Note] InnoDB: Waiting for purge to start
2019-09-23 21:17:44 0 [Note] InnoDB: 10.4.6 started; log sequence number 131145720; transaction id 182907
2019-09-23 21:17:44 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool
2019-09-23 21:17:44 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-09-23 21:17:44 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2019-09-23 21:20:38 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-09-23 21:20:38 0 [Note] InnoDB: Uses event mutexes
2019-09-23 21:20:38 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-09-23 21:20:38 0 [Note] InnoDB: Number of pools: 1
2019-09-23 21:20:38 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-09-23 21:20:38 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-09-23 21:20:38 0 [Note] InnoDB: Completed initialization of buffer pool
2019-09-23 21:20:38 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=131145745
2019-09-23 21:20:39 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-09-23 21:20:39 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-09-23 21:20:39 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-09-23 21:20:39 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-09-23 21:20:39 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-09-23 21:20:39 0 [Note] InnoDB: Waiting for purge to start
2019-09-23 21:20:39 0 [Note] InnoDB: 10.4.6 started; log sequence number 131145754; transaction id 182907
2019-09-23 21:20:39 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool
2019-09-23 21:20:39 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-09-23 21:20:39 0 [Note] Server socket created on IP: '::'.
2019-09-23 21:20:39 0 [Note] InnoDB: Buffer pool(s) load completed at 190923 21:20:39
2019-09-23 21:20:39 0 [Note] Reading of all Master_info entries succeeded
2019-09-23 21:20:39 0 [Note] Added new Master_info '' to hash table
2019-09-23 21:20:39 0 [Note] mysql\bin\mysqld.exe: ready for connections.
Version: '10.4.6-MariaDB'  socket: ''  port: 3306  mariadb.org binary distribution
2019-09-23 21:22:03 0x3048  InnoDB: Assertion failure in file D:\winx64-packages\build\src\storage\innobase\btr\btr0cur.cc line 7988
InnoDB: Failing assertion: space_id == page_get_space_id(page)
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
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: https://mariadb.com/kb/en/library/innodb-recovery-modes/
InnoDB: about forcing recovery.
190923 21:22:03 [ERROR] mysqld got exception 0x80000003 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.

To report this bug, see https://mariadb.com/kb/en/reporting-bugs

We will try our best to scrape up some info that will hopefully help
diagnose the problem, but since we have already crashed,
something is definitely wrong and this may fail.

Server version: 10.4.6-MariaDB
key_buffer_size=16777216
read_buffer_size=262144
max_used_connections=2
max_threads=65537
thread_count=8
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 20285 K  bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x1f76c5bf538
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
mysqld.exe!my_parameter_handler()
ucrtbase.dll!raise()
ucrtbase.dll!abort()
mysqld.exe!parse_user()
mysqld.exe!pthread_dummy()
mysqld.exe!pthread_dummy()
mysqld.exe!pthread_dummy()
mysqld.exe!pthread_dummy()
mysqld.exe!pthread_dummy()
mysqld.exe!pthread_dummy()
mysqld.exe!parse_user()
mysqld.exe!?ha_rnd_next@handler@@QEAAHPEAE@Z()
mysqld.exe!?rr_sequential@@YAHPEAUREAD_RECORD@@@Z()
mysqld.exe!?sub_select@@YA?AW4enum_nested_loop_state@@PEAVJOIN@@PEAUst_join_table@@_N@Z()
mysqld.exe!?disjoin@?$List@VItem@@@@QEAAXPEAV1@@Z()
mysqld.exe!?exec_inner@JOIN@@QEAAXXZ()
mysqld.exe!?exec@JOIN@@QEAAXXZ()
mysqld.exe!?mysql_select@@YA_NPEAVTHD@@PEAUTABLE_LIST@@IAEAV?$List@VItem@@@@PEAVItem@@IPEAUst_order@@434_KPEAVselect_result@@PEAVst_select_lex_unit@@PEAVst_select_lex@@@Z()
mysqld.exe!?handle_select@@YA_NPEAVTHD@@PEAULEX@@PEAVselect_result@@K@Z()
mysqld.exe!?execute_init_command@@YAXPEAVTHD@@PEAUst_mysql_lex_string@@PEAUst_mysql_rwlock@@@Z()
mysqld.exe!?mysql_execute_command@@YAHPEAVTHD@@@Z()
mysqld.exe!?mysql_parse@@YAXPEAVTHD@@PEADIPEAVParser_state@@_N3@Z()
mysqld.exe!?dispatch_command@@YA_NW4enum_server_command@@PEAVTHD@@PEADI_N3@Z()
mysqld.exe!?do_command@@YA_NPEAVTHD@@@Z()
mysqld.exe!?pool_of_threads_scheduler@@YAXPEAUscheduler_functions@@PEAKPEAI@Z()
mysqld.exe!?tp_callback@@YAXPEAUTP_connection@@@Z()
ntdll.dll!TpReleaseWait()
ntdll.dll!RtlInitializeResource()
KERNEL32.DLL!BaseThreadInitThunk()
ntdll.dll!RtlUserThreadStart()

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (0x1f76c5c6800): SELECT `option_id`, `option_name`, `option_value`, `autoload` FROM `wordpress`.`wp_options`
Connection ID (thread ID): 29
Status: NOT_KILLED

Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=on,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on,condition_pushdown_for_subquery=on,rowid_filter=on,condition_pushdown_from_having=on

The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
Writing a core file at D:\xampp\mysql\data\
InnoDB: using atomic writes.
2019-09-23 21:22:57 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-09-23 21:22:57 0 [Note] InnoDB: Uses event mutexes
2019-09-23 21:22:57 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-09-23 21:22:57 0 [Note] InnoDB: Number of pools: 1
2019-09-23 21:22:57 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-09-23 21:22:57 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-09-23 21:22:57 0 [Note] InnoDB: Completed initialization of buffer pool
2019-09-23 21:22:57 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=131146121
2019-09-23 21:22:57 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-09-23 21:22:57 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-09-23 21:22:57 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-09-23 21:22:57 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-09-23 21:22:57 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-09-23 21:22:57 0 [Note] InnoDB: Waiting for purge to start
2019-09-23 21:22:57 0 [Note] InnoDB: 10.4.6 started; log sequence number 131146130; transaction id 182915
2019-09-23 21:22:57 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool
2019-09-23 21:22:57 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-09-23 21:22:57 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2019-09-23 21:25:50 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-09-23 21:25:50 0 [Note] InnoDB: Uses event mutexes
2019-09-23 21:25:50 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-09-23 21:25:50 0 [Note] InnoDB: Number of pools: 1
2019-09-23 21:25:50 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-09-23 21:25:50 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-09-23 21:25:50 0 [Note] InnoDB: Completed initialization of buffer pool
2019-09-23 21:25:50 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=131147417
2019-09-23 21:25:50 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-09-23 21:25:50 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-09-23 21:25:50 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-09-23 21:25:50 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-09-23 21:25:50 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-09-23 21:25:50 0 [Note] InnoDB: Waiting for purge to start
2019-09-23 21:25:50 0 [Note] InnoDB: 10.4.6 started; log sequence number 131147426; transaction id 182981
2019-09-23 21:25:50 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool
2019-09-23 21:25:50 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-09-23 21:25:50 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2019-09-23 21:26:24 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-09-23 21:26:24 0 [Note] InnoDB: Uses event mutexes
2019-09-23 21:26:24 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-09-23 21:26:24 0 [Note] InnoDB: Number of pools: 1
2019-09-23 21:26:24 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-09-23 21:26:24 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-09-23 21:26:24 0 [Note] InnoDB: Completed initialization of buffer pool
2019-09-23 21:26:24 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=131147435
2019-09-23 21:26:24 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-09-23 21:26:24 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-09-23 21:26:24 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-09-23 21:26:24 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-09-23 21:26:24 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-09-23 21:26:24 0 [Note] InnoDB: Waiting for purge to start
2019-09-23 21:26:24 0 [Note] InnoDB: 10.4.6 started; log sequence number 131147444; transaction id 182981
2019-09-23 21:26:24 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool
2019-09-23 21:26:24 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-09-23 21:26:24 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2019-09-23 21:28:54 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-09-23 21:28:54 0 [Note] InnoDB: Uses event mutexes
2019-09-23 21:28:54 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-09-23 21:28:54 0 [Note] InnoDB: Number of pools: 1
2019-09-23 21:28:54 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-09-23 21:28:54 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-09-23 21:28:54 0 [Note] InnoDB: Completed initialization of buffer pool
2019-09-23 21:28:54 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=131147453
2019-09-23 21:28:55 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-09-23 21:28:55 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-09-23 21:28:55 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-09-23 21:28:55 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-09-23 21:28:55 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-09-23 21:28:55 0 [Note] InnoDB: Waiting for purge to start
2019-09-23 21:28:55 0 [Note] InnoDB: 10.4.6 started; log sequence number 131147462; transaction id 182981
2019-09-23 21:28:55 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool
2019-09-23 21:28:55 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-09-23 21:28:55 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2019-09-23 21:29:06 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-09-23 21:29:06 0 [Note] InnoDB: Uses event mutexes
2019-09-23 21:29:06 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-09-23 21:29:06 0 [Note] InnoDB: Number of pools: 1
2019-09-23 21:29:06 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-09-23 21:29:06 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-09-23 21:29:06 0 [Note] InnoDB: Completed initialization of buffer pool
2019-09-23 21:29:06 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=131147471
2019-09-23 21:29:06 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-09-23 21:29:06 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-09-23 21:29:06 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-09-23 21:29:06 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-09-23 21:29:06 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-09-23 21:29:06 0 [Note] InnoDB: Waiting for purge to start
2019-09-23 21:29:06 0 [Note] InnoDB: 10.4.6 started; log sequence number 131147480; transaction id 182981
2019-09-23 21:29:06 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool
2019-09-23 21:29:06 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-09-23 21:29:06 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2019-09-23 21:29:12 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-09-23 21:29:12 0 [Note] InnoDB: Uses event mutexes
2019-09-23 21:29:12 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-09-23 21:29:12 0 [Note] InnoDB: Number of pools: 1
2019-09-23 21:29:12 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-09-23 21:29:12 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-09-23 21:29:12 0 [Note] InnoDB: Completed initialization of buffer pool
2019-09-23 21:29:12 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=131147489
2019-09-23 21:29:12 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-09-23 21:29:12 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-09-23 21:29:12 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-09-23 21:29:12 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-09-23 21:29:12 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-09-23 21:29:12 0 [Note] InnoDB: Waiting for purge to start
2019-09-23 21:29:12 0 [Note] InnoDB: 10.4.6 started; log sequence number 131147498; transaction id 182981
2019-09-23 21:29:12 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool
2019-09-23 21:29:12 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-09-23 21:29:12 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2019-09-23 21:29:22 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-09-23 21:29:22 0 [Note] InnoDB: Uses event mutexes
2019-09-23 21:29:22 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-09-23 21:29:22 0 [Note] InnoDB: Number of pools: 1
2019-09-23 21:29:22 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-09-23 21:29:22 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-09-23 21:29:22 0 [Note] InnoDB: Completed initialization of buffer pool
2019-09-23 21:29:22 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=131147507
2019-09-23 21:29:22 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-09-23 21:29:22 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-09-23 21:29:22 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-09-23 21:29:22 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-09-23 21:29:22 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-09-23 21:29:22 0 [Note] InnoDB: Waiting for purge to start
2019-09-23 21:29:22 0 [Note] InnoDB: 10.4.6 started; log sequence number 131147516; transaction id 182981
2019-09-23 21:29:22 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool
2019-09-23 21:29:22 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-09-23 21:29:22 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2019-09-23 21:30:16 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-09-23 21:30:16 0 [Note] InnoDB: Uses event mutexes
2019-09-23 21:30:16 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-09-23 21:30:16 0 [Note] InnoDB: Number of pools: 1
2019-09-23 21:30:16 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-09-23 21:30:16 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-09-23 21:30:16 0 [Note] InnoDB: Completed initialization of buffer pool
2019-09-23 21:30:16 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=131147525
2019-09-23 21:30:16 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-09-23 21:30:16 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-09-23 21:30:16 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-09-23 21:30:16 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-09-23 21:30:16 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-09-23 21:30:16 0 [Note] InnoDB: Waiting for purge to start
2019-09-23 21:30:16 0 [Note] InnoDB: 10.4.6 started; log sequence number 131147534; transaction id 182981
2019-09-23 21:30:16 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool
2019-09-23 21:30:16 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-09-23 21:30:16 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2019-09-23 21:32:40 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-09-23 21:32:40 0 [Note] InnoDB: Uses event mutexes
2019-09-23 21:32:40 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-09-23 21:32:40 0 [Note] InnoDB: Number of pools: 1
2019-09-23 21:32:40 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-09-23 21:32:40 0 [Note] InnoDB: Initializing buffer pool, total size = 34M, instances = 1, chunk size = 34M
2019-09-23 21:32:40 0 [Note] InnoDB: Completed initialization of buffer pool
2019-09-23 21:32:40 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=131147543
2019-09-23 21:32:40 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-09-23 21:32:40 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-09-23 21:32:40 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-09-23 21:32:40 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-09-23 21:32:40 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-09-23 21:32:40 0 [Note] InnoDB: Waiting for purge to start
2019-09-23 21:32:40 0 [Note] InnoDB: 10.4.6 started; log sequence number 131147552; transaction id 182981
2019-09-23 21:32:40 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool
2019-09-23 21:32:40 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-09-23 21:32:40 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2019-09-23 21:32:49 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-09-23 21:32:49 0 [Note] InnoDB: Uses event mutexes
2019-09-23 21:32:49 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-09-23 21:32:49 0 [Note] InnoDB: Number of pools: 1
2019-09-23 21:32:49 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-09-23 21:32:49 0 [Note] InnoDB: Initializing buffer pool, total size = 120M, instances = 1, chunk size = 120M
2019-09-23 21:32:49 0 [Note] InnoDB: Completed initialization of buffer pool
2019-09-23 21:32:49 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=131147561
2019-09-23 21:32:50 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-09-23 21:32:50 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-09-23 21:32:50 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-09-23 21:32:50 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-09-23 21:32:50 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-09-23 21:32:50 0 [Note] InnoDB: Waiting for purge to start
2019-09-23 21:32:50 0 [Note] InnoDB: 10.4.6 started; log sequence number 131147570; transaction id 182981
2019-09-23 21:32:50 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool
2019-09-23 21:32:50 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-09-23 21:32:50 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2019-09-23 21:33:02 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-09-23 21:33:02 0 [Note] InnoDB: Uses event mutexes
2019-09-23 21:33:02 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-09-23 21:33:02 0 [Note] InnoDB: Number of pools: 1
2019-09-23 21:33:02 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-09-23 21:33:02 0 [Note] InnoDB: Initializing buffer pool, total size = 12M, instances = 1, chunk size = 12M
2019-09-23 21:33:02 0 [Note] InnoDB: Completed initialization of buffer pool
2019-09-23 21:33:02 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=131147579
2019-09-23 21:33:02 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-09-23 21:33:02 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-09-23 21:33:02 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-09-23 21:33:02 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-09-23 21:33:02 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-09-23 21:33:02 0 [Note] InnoDB: Waiting for purge to start
2019-09-23 21:33:02 0 [Note] InnoDB: 10.4.6 started; log sequence number 131147588; transaction id 182981
2019-09-23 21:33:02 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool
2019-09-23 21:33:02 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-09-23 21:33:02 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2019-09-23 21:33:56 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-09-23 21:33:56 0 [Note] InnoDB: Uses event mutexes
2019-09-23 21:33:56 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-09-23 21:33:56 0 [Note] InnoDB: Number of pools: 1
2019-09-23 21:33:56 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-09-23 21:33:56 0 [Note] InnoDB: Initializing buffer pool, total size = 12M, instances = 1, chunk size = 12M
2019-09-23 21:33:56 0 [Note] InnoDB: Completed initialization of buffer pool
2019-09-23 21:33:56 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=131147597
2019-09-23 21:33:56 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-09-23 21:33:56 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-09-23 21:33:56 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-09-23 21:33:56 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-09-23 21:33:56 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-09-23 21:33:56 0 [Note] InnoDB: 10.4.6 started; log sequence number 131147606; transaction id 182981
2019-09-23 21:33:56 0 [Note] InnoDB: !!! innodb_force_recovery is set to 2 !!!
2019-09-23 21:33:56 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool
2019-09-23 21:33:56 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-09-23 21:33:56 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2019-09-23 21:34:52 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-09-23 21:34:52 0 [Note] InnoDB: Uses event mutexes
2019-09-23 21:34:52 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-09-23 21:34:52 0 [Note] InnoDB: Number of pools: 1
2019-09-23 21:34:52 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-09-23 21:34:52 0 [Note] InnoDB: Initializing buffer pool, total size = 12M, instances = 1, chunk size = 12M
2019-09-23 21:34:52 0 [Note] InnoDB: Completed initialization of buffer pool
2019-09-23 21:34:52 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=131147597
2019-09-23 21:34:52 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-09-23 21:34:52 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-09-23 21:34:52 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-09-23 21:34:52 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-09-23 21:34:52 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-09-23 21:34:52 0 [Note] InnoDB: Waiting for purge to start
2019-09-23 21:34:53 0 [Note] InnoDB: 10.4.6 started; log sequence number 131147615; transaction id 182981
2019-09-23 21:34:53 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool
2019-09-23 21:34:53 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-09-23 21:34:53 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2019-09-23 21:35:11 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-09-23 21:35:11 0 [Note] InnoDB: Uses event mutexes
2019-09-23 21:35:11 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-09-23 21:35:11 0 [Note] InnoDB: Number of pools: 1
2019-09-23 21:35:11 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-09-23 21:35:11 0 [Note] InnoDB: Initializing buffer pool, total size = 12M, instances = 1, chunk size = 12M
2019-09-23 21:35:11 0 [Note] InnoDB: Completed initialization of buffer pool
2019-09-23 21:35:11 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=131147624
2019-09-23 21:35:11 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-09-23 21:35:11 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-09-23 21:35:11 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-09-23 21:35:11 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-09-23 21:35:11 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-09-23 21:35:11 0 [Note] InnoDB: Waiting for purge to start
2019-09-23 21:35:11 0 [Note] InnoDB: 10.4.6 started; log sequence number 131147633; transaction id 182981
2019-09-23 21:35:11 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool
2019-09-23 21:35:11 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-09-23 21:35:11 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2019-09-23 21:35:20 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-09-23 21:35:20 0 [Note] InnoDB: Uses event mutexes
2019-09-23 21:35:20 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-09-23 21:35:20 0 [Note] InnoDB: Number of pools: 1
2019-09-23 21:35:20 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-09-23 21:35:20 0 [Note] InnoDB: Initializing buffer pool, total size = 12M, instances = 1, chunk size = 12M
2019-09-23 21:35:20 0 [Note] InnoDB: Completed initialization of buffer pool
2019-09-23 21:35:20 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=131147642
2019-09-23 21:35:20 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-09-23 21:35:20 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-09-23 21:35:20 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-09-23 21:35:20 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-09-23 21:35:20 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-09-23 21:35:20 0 [Note] InnoDB: Waiting for purge to start
2019-09-23 21:35:21 0 [Note] InnoDB: 10.4.6 started; log sequence number 131147651; transaction id 182981
2019-09-23 21:35:21 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool
2019-09-23 21:35:21 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-09-23 21:35:21 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2019-09-23 21:36:03 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-09-23 21:36:03 0 [Note] InnoDB: Uses event mutexes
2019-09-23 21:36:03 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-09-23 21:36:03 0 [Note] InnoDB: Number of pools: 1
2019-09-23 21:36:03 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-09-23 21:36:03 0 [Note] InnoDB: Initializing buffer pool, total size = 12M, instances = 1, chunk size = 12M
2019-09-23 21:36:03 0 [Note] InnoDB: Completed initialization of buffer pool
2019-09-23 21:36:03 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=131147986
2019-09-23 21:36:03 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-09-23 21:36:03 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-09-23 21:36:03 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-09-23 21:36:03 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-09-23 21:36:03 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-09-23 21:36:03 0 [Note] InnoDB: Waiting for purge to start
2019-09-23 21:36:03 0 [Note] InnoDB: 10.4.6 started; log sequence number 131147995; transaction id 182989
2019-09-23 21:36:03 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool
2019-09-23 21:36:03 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-09-23 21:36:03 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2019-09-23 21:42:39 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-09-23 21:42:39 0 [Note] InnoDB: Uses event mutexes
2019-09-23 21:42:39 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-09-23 21:42:39 0 [Note] InnoDB: Number of pools: 1
2019-09-23 21:42:39 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-09-23 21:42:39 0 [Note] InnoDB: Initializing buffer pool, total size = 12M, instances = 1, chunk size = 12M
2019-09-23 21:42:39 0 [Note] InnoDB: Completed initialization of buffer pool
2019-09-23 21:42:39 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=131148004
2019-09-23 21:42:39 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-09-23 21:42:39 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-09-23 21:42:39 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-09-23 21:42:39 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-09-23 21:42:39 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-09-23 21:42:39 0 [Note] InnoDB: Waiting for purge to start
2019-09-23 21:42:39 0 [Note] InnoDB: 10.4.6 started; log sequence number 131148013; transaction id 182989
2019-09-23 21:42:39 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool
2019-09-23 21:42:39 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-09-23 21:42:39 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2019-09-23 21:43:13 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-09-23 21:43:13 0 [Note] InnoDB: Uses event mutexes
2019-09-23 21:43:13 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-09-23 21:43:13 0 [Note] InnoDB: Number of pools: 1
2019-09-23 21:43:13 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-09-23 21:43:13 0 [Note] InnoDB: Initializing buffer pool, total size = 12M, instances = 1, chunk size = 12M
2019-09-23 21:43:13 0 [Note] InnoDB: Completed initialization of buffer pool
2019-09-23 21:43:13 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=131148022
2019-09-23 21:43:13 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-09-23 21:43:13 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-09-23 21:43:13 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-09-23 21:43:13 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-09-23 21:43:13 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-09-23 21:43:13 0 [Note] InnoDB: Waiting for purge to start
2019-09-23 21:43:13 0 [Note] InnoDB: 10.4.6 started; log sequence number 131148031; transaction id 182989
2019-09-23 21:43:13 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool
2019-09-23 21:43:13 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-09-23 21:43:13 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2019-09-23 21:43:33 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-09-23 21:43:33 0 [Note] InnoDB: Uses event mutexes
2019-09-23 21:43:33 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-09-23 21:43:33 0 [Note] InnoDB: Number of pools: 1
2019-09-23 21:43:33 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-09-23 21:43:33 0 [Note] InnoDB: Initializing buffer pool, total size = 12M, instances = 1, chunk size = 12M
2019-09-23 21:43:33 0 [Note] InnoDB: Completed initialization of buffer pool
2019-09-23 21:43:33 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=131148040
2019-09-23 21:43:33 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-09-23 21:43:33 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-09-23 21:43:33 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-09-23 21:43:33 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-09-23 21:43:33 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-09-23 21:43:33 0 [Note] InnoDB: Waiting for purge to start
2019-09-23 21:43:33 0 [Note] InnoDB: 10.4.6 started; log sequence number 131148049; transaction id 182989
2019-09-23 21:43:33 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool
2019-09-23 21:43:33 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-09-23 21:43:33 0 [Note] Server socket created on IP: '::'.