Bug #81578
closed
sys_refindex CHANGE ref_string: Index column size too large
Added by Adrian Dymorz about 7 years ago.
Updated almost 6 years ago.
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
- 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.
- 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.
- Related to Feature #84706: Database analyser can't detect index length changes added
- Related to Feature #84706: Database analyser can't detect index length changes added
- Related to deleted (Feature #84706: Database analyser can't detect index length changes)
Also available in: Atom
PDF