ORA-01691: unable to extend lob segment JIRA.SYS_LOB0000074456C00007$$ by 1024 inJ IRA applications tablespaces
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
When trying to copy and paste a long text in the Description section, you will hit into this problem.
The following appears in the atlassian-jira.log:
1
2
3
4
5
6
7
8
9
10
11
(SQL Exception while executing the following:INSERT INTO jiraaction (ID, issueid, AUTHOR, actiontype, actionlevel, rolelevel, actionbody, CREATED, UPDATEAUTHOR, UPDATED, actionnum) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ORA-01691: unable to extend lob segment JIRA.SYS_LOB0000074456C00007$$ by 1024 in tablespace JIRA
))
at org.ofbiz.core.entity.GenericDAO.singleInsert(GenericDAO.java:149)
at org.ofbiz.core.entity.GenericDAO.insert(GenericDAO.java:114)
at org.ofbiz.core.entity.GenericHelperDAO.create(GenericHelperDAO.java:63)
at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:480)
at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:460)
at org.ofbiz.core.entity.GenericValue.create(GenericValue.java:77)
at com.atlassian.core.ofbiz.util.EntityUtils.createValue(EntityUtils.java:64)
at com.atlassian.jira.issue.comments.DefaultCommentManager.create(DefaultCommentManager.java:198)
... 119 more
Cause
The tablespace being full or there not being enough available space.
Resolution
Go through the following links below to fix this problem by table space / memory size:
Was this helpful?