ORA-01691: unable to extend lob segment JIRA.SYS_LOB0000074456C00007$$ by 1024 inJ IRA applications tablespaces

Still need help?

The Atlassian Community is here for you.

Ask the community

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:

(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:

Last modified on Mar 30, 2016

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.