Taps Server Error: PGError: ERROR: duplicate key value violates unique constraint

Question

I could not find a similar question on stackoverflow, so i apologize if its a duplicate. If its already been answered, kindly point me to that.

I am moving my app from engineyard to heroku and i am trying to push the db using their db:push command. It works great until it reaches one table where it complains of violating a unique constraint.

I have double checked the table and there is no duplicate in that table. My local Db is MySQL. I have asked this question on the heroku support group but have not received any response yet.

Really need to get this solved so i can get my app up and running.

Any help is highly appreciated. If i am unclear and you need more information, please let me know.

Thanks!

Answer 1

+1 - having the same issue and I'm out of ideas.

What's more, if I rerun db:push, it will fail at different points. The first time, 398,000 out of 1.3 million records made it, then 49,000, then 98,000 (approximately).