Issue Summary
This is reproducible on Data Center: Yes
Steps to Reproduce
- Create a database in Microsoft azure, per Connecting Jira applications to Azure SQL
- Install a new deployment of Jira. Go through the startup wizard and enter in connection details to the database
- Test connection is successful, then proceed to the next step to finish.
Expected Results
Database is successfully populated with data.
Actual Results
System produces a 500 error and does not finish updating. We get the following error in the atlassian-jira.log
2024-06-12 10:11:29,136-0400 http-nio-49161-exec-4 ERROR [o.a.c.c.C.[.[localhost].[/j9161].[action]] Servlet.service() for servlet [action] in context with path [/j9161] threw exception [com.querydsl.core.QueryException: Caught SQLServerException for insert into dbo.propertyentry (entity_name, entity_id, property_key, propertytype, id) values (?, ?, ?, ?, ?)] with root cause com.microsoft.sqlserver.jdbc.SQLServerException: Cannot insert duplicate key row in object 'dbo.propertyentry' with unique index 'osproperty_entId_name_propKey'. The duplicate key value is (1, jira.properties).
Workaround
Older versions, such as 9.12.5 work with Azure SQL still.
TBD on fix for others.
- was split into
-
JRASERVER-77891 Import Backup for Server from Cloud fails
-
- Gathering Impact
-
- mentioned in
-
Page Loading...