I'm getting an error saying my database isn't empty, when it's a brand new Database.

Question

I just deployed an RDS cluster that's Aurora PostgresSQL. When accessing the Jira configuration dashboard I input all of the database information and click next and get this error

"You have specified a database that is not empty, please specify an empty database. If you want to upgrade an existing installation"

How is this possible? I just created this database and haven't done anything to it. I'm also using PostgreSQL version 12.11 and the docs say to use 9.6 or above

Benjamin_tmh9yg · Answer

That's great to hear!

MP32 · Answer

I switched to PostgreSQL version 13.7 and it's working now

Benjamin_tmh9yg · Answer

Hi @MP32 ,

I haven't run into this issue but I have implemented aurora for mysql and portgres.

Are you using AWS Jira QuickStarts, could it be possible that some setting were set from there? Are you able to query from an instance to that server to see if the DB is entirely empty? If there is something, could just drop it manually.

Another community ran into similar, may want to run through to see if you are encountering the same.

https://community.atlassian.com/t5/Jira-questions/Unable-to-Setup-Database-for-Jira-Database-is-not-empty/qaq-p/950292

Thanks,

Ben