Confluence Operations Fail Due to ORA-01536 or ORA-01653
Platform Notice: Data Center - This article applies to Atlassian products on the Data Center platform.
Note that this knowledge base article was created for the Data Center version of the product. Data Center knowledge base articles 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
A page cannot be saved with Confluence throwing this error message in the UI, for example:
An error occurred while trying to save the requested page.
Operations that require database update may fail with the following exception in the log:
Caused by: java.sql.SQLException: ORA-01536: space quota exceeded for Tablespace 'CONFLUENCE_PROD'
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1008)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1307)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3530)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1350)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
at net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22)
at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:462)
OR
2010-08-19 18:56:19,826 ERROR [http-8843-3] [atlassian.confluence.user.ConfluenceLoginInterceptor] afterLogin
Can not retrieve the user ('zyap') to set the Last-Login-Date for!
org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not insert:
[bucket.user.propertyset.BucketPropertySetItem#bucket.user.propertyset.BucketPropertySetItem@c23f8426];
uncategorized SQLException for SQL []; SQL state [72000]; error code [1653]; ORA-01653: unable to extend table
CONFLUENCE.OS_PROPERTYENTRY by 128 in tablespace CONFLUENCE
; nested exception is java.sql.SQLException: ORA-01653: unable to extend table CONFLUENCE.OS_PROPERTYENTRY by 128 in tablespace CONFLUENCE
Caused by: java.sql.SQLException: ORA-01653: unable to extend table CONFLUENCE.OS_PROPERTYENTRY by 128 in tablespace CONFLUENCE
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
...
Cause
There is a problem with the Oracle tablespace in used. Refer to the exception code for more details.
ORA-01536
The space quota for the segment owner in the tablespace has been exceeded and the operation attempted the creation of a new segment extent in the tablespace. Refer to this page for more information.
ORA-01653
The database failed to allocate an extent of the required number of blocks for a table segment in the tablespace indicated. Refer to this page for more information.
Resolution
Always back up your data before performing any modifications to the database. If possible, test any alter, insert, update, or delete SQL commands on a staging server first.
ORA-01536
Either drop unnecessary objects in the tablespace to reclaim space or have a privileged user increase the quota on this tablespace for the segment owner.
ORA-01653
Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated.