Comment 5 for bug 1541698

Revision history for this message
monty solomon (monty+launchpad) wrote :

On a slave I converted a large MyISAM FTS table to InnoDB add added the FTS_DOC_ID column and index. The slave SQL failed trying to insert a row.

InnoDB: Doc ID 128012412 is too big. Its difference with largest used Doc ID 127998061 cannot exceed or equal to 10000
2016-02-04 05:21:42 18349 [ERROR] Slave SQL: Error 'Invalid InnoDB FTS Doc ID' on query. Error_code: 182
2016-02-04 05:21:42 18349 [Warning] Slave: Invalid InnoDB FTS Doc ID Error_code: 182
2016-02-04 05:21:42 18349 [Warning] Slave: Got error 182 from storage engine Error_code: 1030
2016-02-04 05:21:42 18349 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'bin.012487' position 6505648