'
Tasks: TOP => db:migrate => db:load_config => environment
(See full trace by running task with --trace)
```
This seems to be caused by “20120816050526\_add\_unique\_constraint\_to\_user\_actions.rb” and if I take a look in the database-table “schema\_migrations” it seems that this has already been applied. As this migration seems to be added in 2012.
Do you have any ideas why “bundle exec rake db:migrate” is running already applied migrations or what we are doing wrong?
I know the source - version is pretty old but as said we already got successful results.
Kind Regards
---
### Author:  [@klopsknoedel](https://meta.discourse.org/u/klopsknoedel)
#### Post date: [July 2, 2019, 6:11pm UTC](https://meta.discourse.org/t/upgrade-fails-while-migrating/121894/2 "2019-07-02T18:11:03Z")
I’ve misinterpreted this error. So sorry for the confusion. Obviously it has nothing to do with the mentioned migration-file.
Anyway, there seems to be an existing index for an entry in `user_actions`. So I checked that with:
```plaintext
SELECT *
FROM user_actions
WHERE action_type=15
AND user_id=1140990
AND target_topic_id=9346002
AND target_post_id=9431164
AND acting_user_id=419835;
```
This query gives me 0 Results. So there must be an index without a corresponding dataset.
---
### Author:  [@pfaffman](https://meta.discourse.org/u/pfaffman)
#### Post date: [July 2, 2019, 6:20pm UTC](https://meta.discourse.org/t/upgrade-fails-while-migrating/121894/3 "2019-07-02T18:20:47Z")
When I’ve had similar problems I’ve deleted the thing that it was trying to duplicate. That’s likely not very helpful.
Or maybe make sure that you were in read-only when you make the backup?
---
### Author:  [@klopsknoedel](https://meta.discourse.org/u/klopsknoedel)
#### Post date: [July 3, 2019, 4:26pm UTC](https://meta.discourse.org/t/upgrade-fails-while-migrating/121894/4 "2019-07-03T16:26:17Z")
> Or maybe make sure that you were in read-only when you make the backup?
Yes maybe that’s the problem. We’ve created the dump while the database was in use. Worked at the first try. I’ll create another one and try again.
---
### Author:  [@klopsknoedel](https://meta.discourse.org/u/klopsknoedel)
#### Post date: [July 11, 2019, 2:22am UTC](https://meta.discourse.org/t/upgrade-fails-while-migrating/121894/5 "2019-07-11T02:22:57Z")
Hi. It seemed our `user_actions` table got corrupted. I could fix that by running `VACUUM (VERBOSE,ANALYZE,DISABLE_PAGE_SKIPPING) user_actions`. But thanks anyway for your advise!
There where several entries missing from the visibility map which produced duplicated keys.
---
### Author:  [@system](https://meta.discourse.org/u/system)
#### Post date: [December 31, 2022, 1:47am UTC](https://meta.discourse.org/t/upgrade-fails-while-migrating/121894/6 "2022-12-31T01:47:45Z")
---
### Author:  [@Stephen](https://meta.discourse.org/u/Stephen)
#### Post date: [December 31, 2022, 2:24am UTC](https://meta.discourse.org/t/upgrade-fails-while-migrating/121894/7 "2022-12-31T02:24:55Z")