title: What does the MySQL 5.6 error "InnoDB presently supports one FULLTEXT index creation at a time. Try LOCK=SHARED" mean?
body: <p>In MySQL 5.6.22 (specifically running on Amazon RDS) I once had a fulltext index on a table. I have since dropped that index in favor of using sphinxsearch. There are no more fulltext indexes on any of the tables on the database.</p>
  
  <p>When I try to now perform an online DDL such as adding a tinyint column to a table with LOCK=NONE I get this error:</p>
  
  <blockquote>
    <p>InnoDB presently supports one FULLTEXT index creation at a time. Try LOCK=SHARED.</p>
  </blockquote>
  
  <p>But, there are no fulltext indexes anywhere. I've even tried creating a read-replica in Amazon in hopes that the rebuilding of the database would fix that and I get the same error there.</p>
  
  <p>Am I missing something obvious?</p>
  
  <p>SHOW CREATE TABLE:</p>
  
  <pre><code>CREATE TABLE `pages` (
    `ID` char(64) CHARACTER SET latin1 NOT NULL,
    `auto_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `siteID` bigint(20) unsigned NOT NULL,
    `recordingID` char(64) DEFAULT NULL,
    `dateCreated` datetime DEFAULT NULL,
    `ip` char(46) CHARACTER SET latin1 DEFAULT NULL,
    `referrer` text CHARACTER SET latin1,
    `referrer_client` char(50) DEFAULT NULL,
    `referrer_from` char(255) DEFAULT NULL,
    `referrer_type` char(50) DEFAULT NULL,
    `referrer_network` char(50) DEFAULT NULL,
    `referrer_link` char(255) DEFAULT NULL,
    `campaign_source` char(50) DEFAULT NULL,
    `campaign_medium` char(32) DEFAULT NULL,
    `campaign_campaign` char(75) DEFAULT NULL,
    `url` char(255) CHARACTER SET latin1 DEFAULT NULL,
    `keywords` char(100) CHARACTER SET latin1 DEFAULT NULL,
    `source` char(128) CHARACTER SET latin1 DEFAULT NULL,
    `os` char(30) CHARACTER SET latin1 DEFAULT NULL,
    `browser` char(30) CHARACTER SET latin1 DEFAULT NULL,
    `user_agent` char(255) CHARACTER SET latin1 DEFAULT NULL,
    `agentFamily` char(50) DEFAULT NULL,
    `is_phone` tinyint(1) DEFAULT '0',
    `is_tablet` tinyint(1) DEFAULT '0',
    `is_desktop` tinyint(1) DEFAULT '0',
    `tags` char(255) CHARACTER SET latin1 DEFAULT NULL,
    `device` char(65) DEFAULT NULL,
    `last_event_time` datetime DEFAULT NULL,
    `view_width` int(11) DEFAULT NULL,
    `view_height` int(11) DEFAULT NULL,
    `browser_width` int(11) DEFAULT NULL,
    `browser_height` int(11) DEFAULT NULL,
    `optimizely_experiments` char(255) CHARACTER SET latin1 DEFAULT NULL,
    `optimizely_variations` char(255) CHARACTER SET latin1 DEFAULT NULL,
    `is_paid` tinyint(1) DEFAULT '0',
    `typed` tinyint(1) DEFAULT '0',
    `organization` char(255) CHARACTER SET latin1 DEFAULT NULL,
    `country` char(75) CHARACTER SET latin1 DEFAULT NULL,
    `city` char(128) CHARACTER SET latin1 DEFAULT NULL,
    `region` char(10) DEFAULT NULL,
    `regionName` char(64) DEFAULT NULL,
    `country_code2` char(2) CHARACTER SET latin1 DEFAULT NULL,
    `postal` char(32) CHARACTER SET latin1 DEFAULT NULL,
    `latitude` char(30) DEFAULT NULL,
    `longitude` char(30) DEFAULT NULL,
    `custom_data` text CHARACTER SET latin1,
    `notes` text CHARACTER SET latin1,
    `title` char(255) DEFAULT NULL,
    `has_dom_tree` tinyint(1) DEFAULT '0',
    `time` int(11) DEFAULT NULL,
    PRIMARY KEY (`auto_id`),
    UNIQUE KEY `pageid` (`ID`),
    KEY `siteID` (`siteID`),
    KEY `dateCreated` (`dateCreated`),
    KEY `recordingID` (`recordingID`),
    KEY `siteID_url` (`siteID`,`url`)
  ) ENGINE=InnoDB AUTO_INCREMENT=90042803 DEFAULT CHARSET=utf8
  </code></pre>
  
  <p>Simple Alter</p>
  
  <pre><code>ALTER TABLE `pages`   
    ADD COLUMN `is_ppc` TINYINT(1) , LOCK=NONE
  </code></pre>
  
  <p>Error</p>
  
  <pre><code>Error Code: 1846
  LOCK=NONE is not supported. Reason: InnoDB presently supports one FULLTEXT index creation at a time. Try LOCK=SHARED.
  </code></pre>