# Error restoring backup "key is duplicated"

**URL:** <https://meta.discourse.org/t/error-restoring-backup-key-is-duplicated/68999>\
**Category:** Self-hosting\
**Created:** [August 29, 2017, 3:40pm UTC](https://meta.discourse.org/t/error-restoring-backup-key-is-duplicated/68999 "2017-08-29T15:40:45Z")\
**Posts on this page:** 1\
**Showing post:** 1

<div class="post-metadata">

**Author:** ![appcomq](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/appcomq/32/84767_2.png) [@appcomq](https://meta.discourse.org/u/appcomq)\
**Post date:** [August 29, 2017, 3:40pm UTC](https://meta.discourse.org/t/error-restoring-backup-key-is-duplicated/68999/1 "2017-08-29T15:40:45Z")

</div>

😂😂 I…

version is v1.9.0.beta7 +341

```
[2017-08-29 15:27:03] ERROR: could not create unique index "index_topic_users_on_topic_id_and_user_id"
[2017-08-29 15:27:03] DETAIL: Key (topic_id, user_id)=(59700, 11226) is duplicated.
[2017-08-29 15:27:03] ERROR: current transaction is aborted, commands ignored until end of transaction block
[2017-08-29 15:27:03] ERROR: current transaction is aborted, commands ignored until end of transaction block
[2017-08-29 15:27:03] ERROR: current transaction is aborted, commands ignored until end of transaction block
[2017-08-29 15:27:03] ERROR: current transaction is aborted, commands ignored until end of transaction block
....

[2017-08-29 15:27:03] EXCEPTION: psql failed
[2017-08-29 15:27:03] /var/www/discourse/lib/backup_restore/restorer.rb:279:in `restore_dump'
/var/www/discourse/lib/backup_restore/restorer.rb:42:in `run'
/var/www/discourse/lib/backup_restore/backup_restore.rb:163:in `block in start!'
/var/www/discourse/lib/backup_restore/backup_restore.rb:160:in `fork'

...

```

---

_[View the full topic](https://meta.discourse.org/t/error-restoring-backup-key-is-duplicated/68999)._