[MDEV-11918] CREATE FULLTEXT INDEX with a token longer than 127 bytes crashes server (10.0 version) Created: 2017-01-26 Updated: 2017-01-27 Resolved: 2017-01-27 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Storage Engine - InnoDB |
| Affects Version/s: | 10.0.28, 10.0.29 |
| Fix Version/s: | 10.0.30 |
| Type: | Bug | Priority: | Major |
| Reporter: | Jaime Crespo | Assignee: | Marko Mäkelä |
| Resolution: | Fixed | Votes: | 2 |
| Labels: | None | ||
| Issue Links: |
|
||||||||
| Description |
|
This is crashing wikimedia servers hard. See: https://phabricator.wikimedia.org/T156373 I can probably backport your 10.1 patch, no problem with that, but if I do would you maintain it for future releases? Will there be more MariaDB 10.0 releases? |
| Comments |
| Comment by Jaime Crespo [ 2017-01-26 ] |
|
A Wikimedia community member has beat me to do a pull request before I do: https://github.com/MariaDB/server/pull/300 |
| Comment by Evan Priestley [ 2017-01-26 ] |
|
The proximate cause of this issue is that we (Phabricator) began moving FULLTEXT indexes to the InnoDB table engine on database servers that support InnoDB FULLTEXT in early December. You can find some context in the Phabricator upstream, here: https://secure.phabricator.com/T11741 This engine change happens automatically during the routine upgrade process, which also runs other migrations and schema adjustments. Any install running MariaDB 10.0 with a reasonable amount of data is likely to be impacted by this issue, since we index some exotic data like commit messages which probably contain tokens with lengths greater than 127 bytes in any nontrivial repository. Users don't explicitly choose to perform this engine migration, so impacted users probably will not have an easy path back to safety. We could explicitly blacklist MariaDB 10.0 and prevent it from upgrading to InnoDB FULLTEXT to work around this, but a MariaDB upstream fix would obviously be preferable. |
| Comment by Marko Mäkelä [ 2017-01-27 ] |
|
Thank you for the report. I cherry-picked my |