# Snapshot restore is failing

**URL:** https://community.cratedb.com/t/snapshot-restore-is-failing/894
**Category:** CrateDB
**Created:** [November 17, 2021, 10:24pm UTC](https://community.cratedb.com/t/snapshot-restore-is-failing/894 "2021-11-17T22:24:24Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![ahowey](https://avatars.discourse-cdn.com/v4/letter/a/8e7dd6/32.png) [@ahowey](https://community.cratedb.com/u/ahowey)
#### Post date: [November 17, 2021, 10:24pm UTC](https://community.cratedb.com/t/snapshot-restore-is-failing/894/1 "2021-11-17T22:24:24Z")

</div>

We have a setup where we create a snapshot of our crate database in our Production environment in one AWS region, copy that snapshot to an S3 bucket, and then restore that snapshot to a different crate cluster in a different AWS region which is our DR environment. This had been working properly until 11/08/2021, when it started failing with the following error

`SQLActionException[SnapshotRestoreException: [my_repository:us_crate_20211108043003/gclfu8ahQ7qE8hdrxsL5EA] cannot restore index [app..partitioned.tp_activity_v2.04732dhj6cs34d1g60o30c1g] because an open index with same name already exists in the cluster.`

There are currently no “user” tables in the DR crate cluster as confirmed by the following:

```auto
cr> SELECT CONCAT(table_schema, '.', table_name) FROM INFORMATION_SCHEMA.TABLES where table_schema IN ('doc', 'app');
+---------------------------------------+
| concat(table_schema, '.', table_name) |
+---------------------------------------+
+---------------------------------------+

```

How do I close or delete the blocking index?