Bug #81578
closed
sys_refindex CHANGE ref_string: Index column size too large
0%
Description
Database analyzer generates the following SQL command
ALTER TABLE sys_refindex CHANGE ref_string `ref_string` VARCHAR(1024) DEFAULT '' NOT NULL Current value: ref_string VARCHAR(200) DEFAULT '' NOT NULL COLLATE utf8_general_ci
which leads to the error message
Database update failed Error: Index column size too large. The maximum column size is 767 bytes.
MariaDB Server version: 10.0.29-MariaDB-0+deb8u1
T3 8.7.1
Updated by Adrian Dymorz over 7 years ago
As a workaround, https://stackoverflow.com/a/30767600/7173655 helped.
ALTER TABLE sys_refindex ROW_FORMAT=DYNAMIC;
Updated by Morton Jonuschat over 7 years ago
- Status changed from New to Needs Feedback
This is probably happening due to a dependency between the index and the alteration of the column. If you check the install tool you should see a change to the index as well (limiting the length of the prefix on ref_string). This change needs to be done before altering the column, then the update should work.
Updated by Riccardo De Contardi about 7 years ago
- Status changed from Needs Feedback to Closed
90 days without feedback -> closing it.
If you think that this is the wrong decision or experience the issue again or have more information about how to reproduce it, please reopen it or open a new issue with a reference to this one. Thank you.
Updated by Henri Nathanson about 6 years ago
- Related to Feature #84706: Database analyser can't detect index length changes added
Updated by Henri Nathanson about 6 years ago
- Related to Feature #84706: Database analyser can't detect index length changes added
Updated by Henri Nathanson about 6 years ago
- Related to deleted (Feature #84706: Database analyser can't detect index length changes)