# SQL Error during import

**URL:** <https://meta.discourse.org/t/sql-error-during-import/27793>\
**Category:** Self-hosting\
**Created:** [April 21, 2015, 9:06am UTC](https://meta.discourse.org/t/sql-error-during-import/27793 "2015-04-21T09:06:16Z")\
**Posts on this page:** 1\
**Showing post:** 1

<div class="post-metadata">

**Author:** ![cocojoe](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/cocojoe/32/108548_2.png) [@cocojoe](https://meta.discourse.org/u/cocojoe)\
**Post date:** [April 21, 2015, 9:06am UTC](https://meta.discourse.org/t/sql-error-during-import/27793/1 "2015-04-21T09:06:16Z")

</div>

Trying to import a discourse backup ~ 3GB from version v1.3.0.beta5 +97 to latest-release +87.

During the import the following sql issue

```plaintext
[2015-04-21 08:34:05] psql:/var/www/discourse/tmp/restores/default/2015-04-21-083104/dump.sql:3781134: ERROR: could not create unique index "post_timings_unique"
[2015-04-21 08:34:05] DETAIL: Key (topic_id, post_number, user_id)=(13868, 7, 6580) is duplicated.
[2015-04-21 08:34:05] EXCEPTION: psql failed
[2015-04-21 08:34:05] /var/www/discourse/lib/backup_restore/restorer.rb:217:in `restore_dump'

```

---

_[View the full topic](https://meta.discourse.org/t/sql-error-during-import/27793)._