Your Amazon Aurora MySQL cluster looks healthy. Reads and writes
succeed and every metric is green. Then a routine CREATE
INDEX fails with error 63955, and from then on no index
that includes a virtual column can be created on the cluster
until you rebuild its databases.
Error Code: 63955.
Index cannot be created because virtual index ID limit (4294967295) was reached.-
What it means: the cluster has used up the
internal IDs Aurora MySQL uses when it evaluates indexes that
contain a virtual column. This error does not affect existing
data or ordinary indexes, but new indexes on
VIRTUALgenerated columns, functional indexes, and multi-valued indexes fail. -
What helps short term: converting the
generated column in the failing index from
VIRTUALtoSTORED, so that the index no longer contains a …