Problems starting Jira in the development environment (Contraint violated)

[ignacio.flores]

I am currently building a copy of our production environment jira data center 7.10.

When starting jira, in the catalina.out file, I see records that make me noise, such as creation of index functions among others. Coincidentally, when trying to create issues I get ORA 00001 errors related to unique constraint violation.

Has anyone else had this issue ? Could it be a database configuration problem?

[Nic Brough -Adaptavist-]

Yes, this tends to mean that your database is either incorrectly configured, or corrupt.

Jira is trying to insert new data that already exists in the database, so it is unable to do it.

The most likely cause of this is someone editing the database directly, instead of doing it in Jira, but other things can do this, including crashes.  In this case, it's worth mentioning that you can also get there if you take a simple dump of a large database while Jira is running, although it is very unlikely.  (You need to be taking snapshot dumps so the data is consistent)

How did you create this development database?   Is it a copy of the production database?