# Will synchronous materialized views roll back after a write failure?

**URL:** https://forum.scylladb.com/t/will-synchronous-materialized-views-roll-back-after-a-write-failure/812
**Category:** ScyllaDB
**Tags:** materialized-views
**Created:** [August 29, 2023, 6:36am UTC](https://forum.scylladb.com/t/will-synchronous-materialized-views-roll-back-after-a-write-failure/812 "2023-08-29T06:36:59Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![bo\_li](https://sea2.discourse-cdn.com/flex016/user_avatar/forum.scylladb.com/bo_li/32/438_2.png) [@bo\_li](https://forum.scylladb.com/u/bo_li)
#### Post date: [August 29, 2023, 6:36am UTC](https://forum.scylladb.com/t/will-synchronous-materialized-views-roll-back-after-a-write-failure/812/1 "2023-08-29T06:36:59Z")

</div>

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](https://opensource.docs.scylladb.com/stable/cql/cql-extensions.html#synchronous-materialized-views).  
I think it will. But I haven’t found the corresponding code in this [PR](https://github.com/scylladb/scylladb/pull/10777/commits) either? Does anyone understand the working principle? Thank you.

---

<div class="post-metadata">

### Author: ![Botond\_Denes](https://sea2.discourse-cdn.com/flex016/user_avatar/forum.scylladb.com/botond_denes/32/163_2.png) [@Botond\_Denes](https://forum.scylladb.com/u/Botond_Denes)
#### Post date: [August 31, 2023, 1:41pm UTC](https://forum.scylladb.com/t/will-synchronous-materialized-views-roll-back-after-a-write-failure/812/2 "2023-08-31T13:41:34Z")

</div>

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