ContextQMD
Back to Yugabyte Db

TA-20648

docs/content/stable/releases/techadvisories/ta-20648.md

2026.1.0.0-b291.1 KB
Original Source
ProductAffected VersionsRelated IssuesFixed In
{{<product "ysql">}}{{<release "2.20.x, 2.19.x">}}{{<issue 20648>}}{{<release "2.20.1.3, 2.20.2+, 2.21.0">}}

Description

The impacted releases contain an issue where an index update can be wrongly applied, leading to index corruption in the following rare cases:

  • Update to a table with non-unique indexes and self-referential triggers where both the index updates, and the trigger application affect the same rows.
  • Multi-row update to a table with a non-unique partial index.

Mitigation

If you're using a {{<release "2.20">}} series release prior to {{<release "2.20.1.3">}}, it is recommended that you upgrade to YugabyteDB {{<release "2.20.1.3">}} or later. The fix ensures new writes to get executed correctly. But it will not repair existing inconsistent data. To fix inconsistent indexes, the indexes need to be recreated. It is advisable to create a new index, and then drop the older one.