Streams: Updates to stream replication (Preview)¶
Attention
This behavior change is in the 2024_07 bundle.
For the current status of the bundle, refer to Bundle History.
Stream replication is being updated to prevent incorrect query results. Some streams that previously worked might now be blocked because the system can’t determine which changes are safe, so both safe and unsafe changes are blocked to ensure data accuracy.
- Before the change:
During database or failover group replication, a stream could return incorrect results if its underlying views change after failover but before consumption.
- After the change:
During database or failover group replication, streams mark themselves as unreadable instead of returning incorrect data. Users see an error with recovery guidance, preventing accidental use of incorrect results.
To recover an unreadable stream, restore the view to its original definition, consume any pending changes from the stream, then apply your intended changes to the view.
Ref: 2112