JIRA has loss of functionality and ORA-00600 error is in the logs
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Symptoms
It can affect different functionalities in JIRA a message similar as the following appears in the atlassian-jira.log:
1
2
3
4
5
6
][name,test][creator,null] (SQL Exception while executing the following:UPDATE jiraworkflows SET workflowname=?, creatorname=?, DESCRIPTOR=?, ISLOCKED=? WHERE ID=? (ORA-00600: internal error code, arguments: [25027], [7], [0], [], [], [], [], [], [], [], [], []
))
at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.store(DefaultOfBizDelegator.java:357)
at com.atlassian.jira.workflow.OfBizWorkflowDescriptorStore.saveWorkflow(OfBizWorkflowDescriptorStore.java:95)
at com.atlassian.jira.workflow.CachingWorkflowDescriptorStore.saveWorkflow(CachingWorkflowDescriptorStore.java:129)
at com.atlassian.jira.workflow.JiraWorkflowFactory.saveWorkflow(JiraWorkflowFactory.java:61)
Cause
This is the generic internal error number for Oracle program exceptions. It indicates that a process has encountered a low-level, unexpected condition (source). Causes of this message include:
Timeouts
File corruption
Failed data checks in memory
Hardware, memory, or I/O errors
Incorrectly restored files
Resolution
Contact Oracle support to further investigate the cause of this issue. Additionally, we have reports that moving the data to a different table space can potentially solve this issue. Example:
1
alter table JIRA.JIRADRAFTWORKFLOWS move lob (DESCRIPTOR) store as (tablespace JIRA_DATA);
Was this helpful?