Jira error on loading

[John]

Our Jira service desk was freezing up the last couple of days.  We reindex the system and then Java update was applied.  Now we are getting this error. Is this Java.  Server 2012 r2 system. 

[Andy Heinzer · Accepted solution]

Hi John,

Sorry to hear you have encountered this problem.  This is actually a known bug in Jira.  More details in https://jira.atlassian.com/browse/JRASERVER-64325

There are steps documented to work past this problem in the KB JIRA Fails to Start due to Multiple entries with same key

In your case, you will need to run the following SQL query to find these two entries:

select * from clusteredjob where job_id = 'sd.custom.notification.batch.send';

In a functional Jira, there should be only one row returned by this query.   As such you would need to delete the older record from the database and then restart Jira to correct this.  If you're unsure which is older, feel free to post the results of that SQL query and I can help work out the SQL needed to remove that duplicate row.

Regards,

Andy

[John]

Thanks. I followed the steps and it worked.  I found that thread after I submitted this one.  

thanks again