XAMPP won't start MySQL after upgrading to 7.0.22-1

Problems with the Mac OS X version of XAMPP, questions, comments, and anything related.

XAMPP won't start MySQL after upgrading to 7.0.22-1

Postby msaz87 » 14. September 2017 01:13

I'm running a Mac (Sierra 10.12.6) with XAMPP and upgraded from 5-something to 7.0.22-1. Ever since then, I've had trouble running MySQL. I've done a full uninstall and then reinstall, and it will work, but once I've restarted my computer, it stops working again.

2017-09-12 9:16:16 140736413361088 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace mysql/gtid_slave_pos uses space ID: 3 at filepath: ./mysql/gtid_slave_pos.ibd. Cannot open tablespace mysql/slave_relay_log_info which uses space ID: 3 at filepath: ./mysql/slave_relay_log_info.ibd


Here's my full log on pastebin: https://pastebin.com/R4UxcscW

If I edit my.cnf and add innodb_force_recovery = 1, start MySQL, stop it, remove what I added, then start it again, it works. But, it doesn't seem to last forever as when I tried again in the morning I got the same problem again.

Any ideas?
msaz87
 
Posts: 1
Joined: 14. September 2017 01:06
XAMPP version: 7.0.22-1
Operating System: macOS Sierra 10.12.6

Return to XAMPP for macOS

Who is online

Users browsing this forum: No registered users and 57 guests