# Getting error on deleting workflows while using astraDB serverless with temporal

**URL:** <https://community.temporal.io/t/getting-error-on-deleting-workflows-while-using-astradb-serverless-with-temporal/5356>\
**Category:** Community Support\
**Tags:** cassandra\
**Created:** [July 17, 2022, 10:32am UTC](https://community.temporal.io/t/getting-error-on-deleting-workflows-while-using-astradb-serverless-with-temporal/5356 "2022-07-17T10:32:57Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Dhruva\_Upamanyu](https://sea2.discourse-cdn.com/flex016/user_avatar/community.temporal.io/dhruva_upamanyu/32/313_2.png) [@Dhruva\_Upamanyu](https://community.temporal.io/u/Dhruva_Upamanyu)\
**Post date:** [July 17, 2022, 10:32am UTC](https://community.temporal.io/t/getting-error-on-deleting-workflows-while-using-astradb-serverless-with-temporal/5356/1 "2022-07-17T10:32:57Z")

</div>

Hi im noticing that completed workflows are not getting deleted even after retention period is over  
with the following error  
“Fail to process task”,“shard-id”:178,“address”:“10.71.19.10:7234”,“component”:“visibility-queue-processor”,“shard-id”:178,“queue-task-id”:25165913,“queue-task-visibility-timestamp”

operation DeleteWorkflowExecution encountered Provided value ONE is not allowed for Write Consistency Level (disallowed values are: [ANY, ONE, LOCAL\_ONE])"

As i understand temporal uses the value provided in the config file  
visibility:  
driver: “cassandra”  
cassandra:  
disableInitialHostLookup: true  
hosts: “host”  
port: 29042  
keyspace: temporal\_visibility  
user: “user”  
existingSecret: “password”  
replicationFactor: 3  
consistency:  
default:  
consistency: “local\_quorum”  
serialConsistency: “local\_serial”

So why is the delete operation ignoring this consistency level and using ONE as the value?  
Note: i am using astraDB as my database provider, i understand that they do not support consistency ONE on writes but is this query expected?

I can see as per this code

> <https://github.com/temporalio/temporal/blob/master/common/persistence/visibility/store/standard/cassandra/visibility_store.go>

```nohighlight
	cfg config.Cassandra,
	r resolver.ServiceResolver,
	logger log.Logger,
) (*visibilityStore, error) {
	session, err := gocql.NewSession(cfg, r, logger)
	if err != nil {
		logger.Fatal("unable to initialize cassandra session", tag.Error(err))
	}

	return &visibilityStore{
		session: session,
		lowConslevel: gocql.One,
	}, nil
}

Thanks
```

---

<div class="post-metadata">

**Author:** ![tihomir](https://sea2.discourse-cdn.com/flex016/user_avatar/community.temporal.io/tihomir/32/6580_2.png) [@tihomir](https://community.temporal.io/u/tihomir)\
**Post date:** [July 20, 2022, 3:22am UTC](https://community.temporal.io/t/getting-error-on-deleting-workflows-while-using-astradb-serverless-with-temporal/5356/3 "2022-07-20T03:22:31Z")

</div>

Thanks for sharing this. Asked server team to provide input and will get back to you asap.

---

<div class="post-metadata">

**Author:** ![Dhruva\_Upamanyu](https://sea2.discourse-cdn.com/flex016/user_avatar/community.temporal.io/dhruva_upamanyu/32/313_2.png) [@Dhruva\_Upamanyu](https://community.temporal.io/u/Dhruva_Upamanyu)\
**Post date:** [July 20, 2022, 5:57am UTC](https://community.temporal.io/t/getting-error-on-deleting-workflows-while-using-astradb-serverless-with-temporal/5356/4 "2022-07-20T05:57:03Z")

</div>

Thanks for the ack! Awaiting response

---

<div class="post-metadata">

**Author:** ![animesh](https://sea2.discourse-cdn.com/flex016/user_avatar/community.temporal.io/animesh/32/1356_2.png) [@animesh](https://community.temporal.io/u/animesh)\
**Post date:** [July 22, 2022, 6:52am UTC](https://community.temporal.io/t/getting-error-on-deleting-workflows-while-using-astradb-serverless-with-temporal/5356/5 "2022-07-22T06:52:58Z")

</div>

plus one on this. We just started testing temporal on astra, and running into this issue.

---

<div class="post-metadata">

**Author:** ![Yimin\_Chen](https://sea2.discourse-cdn.com/flex016/user_avatar/community.temporal.io/yimin_chen/32/963_2.png) [@Yimin\_Chen](https://community.temporal.io/u/Yimin_Chen)\
**Post date:** [July 22, 2022, 10:21pm UTC](https://community.temporal.io/t/getting-error-on-deleting-workflows-while-using-astradb-serverless-with-temporal/5356/6 "2022-07-22T22:21:43Z")

</div>

Thanks for reporting this. It does seem like a bug that we use consistency One for delete.

---

<div class="post-metadata">

**Author:** ![Jauneet\_Singh](https://sea2.discourse-cdn.com/flex016/user_avatar/community.temporal.io/jauneet_singh/32/2384_2.png) [@Jauneet\_Singh](https://community.temporal.io/u/Jauneet_Singh)\
**Post date:** [July 26, 2022, 4:44pm UTC](https://community.temporal.io/t/getting-error-on-deleting-workflows-while-using-astradb-serverless-with-temporal/5356/7 "2022-07-26T16:44:14Z")

</div>

Hi

@Yimin_Chen Need your support to close this as this feature blocks a lot of testing.

---

<div class="post-metadata">

**Author:** ![Yimin\_Chen](https://sea2.discourse-cdn.com/flex016/user_avatar/community.temporal.io/yimin_chen/32/963_2.png) [@Yimin\_Chen](https://community.temporal.io/u/Yimin_Chen)\
**Post date:** [July 27, 2022, 3:57am UTC](https://community.temporal.io/t/getting-error-on-deleting-workflows-while-using-astradb-serverless-with-temporal/5356/8 "2022-07-27T03:57:38Z")

</div>

Fix is landed to master.

---

<div class="post-metadata">

**Author:** ![tihomir](https://sea2.discourse-cdn.com/flex016/user_avatar/community.temporal.io/tihomir/32/6580_2.png) [@tihomir](https://community.temporal.io/u/tihomir)\
**Post date:** [July 31, 2022, 9:22pm UTC](https://community.temporal.io/t/getting-error-on-deleting-workflows-while-using-astradb-serverless-with-temporal/5356/9 "2022-07-31T21:22:56Z")

</div>

Just to add for tracking - commit [here](https://github.com/temporalio/temporal/commit/0dfc7f945b641d29ec1a7130d92b1418f343c4fc).