Migrating Jira Software from MySQL to PostgreSQL not working

Question

I’m trying to migrate an instance of Jira 8.8.0 from using MySQL 5.7.31 to PostgreSQL 9.6.15, and I keep getting errors. The first time I tried this in Production, I got the error described here: https://confluence.atlassian.com/jirakb/xml-backup-import-fails-with-genericentityexception-in-jira-server-440108201.html

I was forced to roll back the changes and kept Production using MySQL. I also dropped the Postgres DB that was going to be used by Production and re-created it.

After trying both of these fixes in Staging, I was able to migrate them in Staging with no issues. However, I tried this again in Production, and I got the error in the attached image. So, I turned off Production Jira, tried the second fix with the jar file, and trying re-importing. This time, I received a 503 error in the middle of the restoration process.

Can someone please explain why this is happening?

Sam_fdmg93 · Answer

Since there's only one Atlassian tool on the database server, it doesn't look like that's the problem. Thanks anyway, Dave!

Dave Theodore [Coyote Creek Consulting] · Answer

When I've seen duplicate objects like this, it's typically when there are multiple instances of Atlassian tools running on one database server.  There are many tables of the same name used in all the tools.  These can cause namespace collisions if the db user can see the other instances.  If you're on a shared database, you should use a dedicated db user for each application and not allow one db user to see the other instances. That's all I got, I'm afraid :)

Sam_fdmg93 · Answer

Thank you for the suggestion, Dave! I was just curious, though, if you've ever come across that error? Searching through the logs, it seems like duplicate entries were consistently being inserted, and I haven't been able to find out why that's what happening.