Publication date: December 20, 2022
Description
In CockroachDB v22.1.6 to v22.1.9, changefeeds using the initial_scan='only'
option can complete with a successful
status even if not all messages have been emitted to the sink. This occurs consistently unless the table is very small.
The same issue may occur if a changefeed with schema_change_policy='stop'
encounters a schema change. The changefeed may not emit any changes that occurred prior to the schema change being emitted.
Statement
This is resolved in CockroachDB by #90241, which ensures all events correctly flush out of all buffers prior to the changefeed exiting.
The fix has been applied to maintenance releases of CockroachDB v22.1.10 and later.
This public issue is tracked by #90146.
Mitigation
Users of CockroachDB v22.1.6 to v22.1.9 are encouraged to upgrade to v22.1.10 or a later version.
Impact
Data expected to be emitted by changefeeds may not be complete.
Please reach out to the support team if more information or assistance is needed.