Peter Wagemans Posted February 27, 2019 Posted February 27, 2019 The upgrade was a bit problematic on my server. First I had to upgrade to php7.1 on my Ubuntu 16 LTS server, which is not part of the main distribution (I wonder why). After I tackled that, and PHP7.1 was running, I started the upgrade, and got stuck here: InnoDB presently supports one FULLTEXT index creation at a time ALTER TABLE `core_search_index` ADD KEY `index_stream`... No way to cancel out of the upgrade, just "retry" and "continue", whci made no difference as the error simply re-appeared. Luckily, I found a workaround here: https://stackoverflow.com/questions/28666643/what-does-the-mysql-5-6-error-innodb-presently-supports-one-fulltext-index-crea Quote I changed the table engine from InnoDB to MyISAM i.e. ALTER TABLE `core_search_index` ENGINE='MyISAM'; .. After that, I pushed the retry button and the upgrade continued. Pfff. I'm currently waiting for the reindexing to complete, and I guess I'll change the engine back to InnoDB afterwards. It seems to be a bug in MySQL. I use v5.7.25-0ubuntu0.16.04.2 Just sharing this, for those who get in trouble like I did. This was a scary experience, even with backups.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.