Confluence Operations Fail Due to ORA-01536 or ORA-01653

Still need help?

The Atlassian Community is here for you.

Ask the community

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.






























Last modified on Sep 25, 2018

Was this helpful?

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