Will synchronous materialized views roll back after a write failure?

When synchronous_view_updates is set to True, it will synchronously write the base table and GSI. If writing a certain GSI fails during this period, will the other successfully written base and index tables be rolled back? It is not reflected in the introduction of document synchronous-materialized-views.
I think it will. But I haven’t found the corresponding code in this PR either? Does anyone understand the working principle? Thank you.

No, no previous writes will be rolled back. This is only possible with transactions, which we don’t support.

1 Like