Unable to Upgrade or Save Pages Due to Table is Full Error

Still need help?

The Atlassian Community is here for you.

Ask the community

Symptoms

When Confluence initiates the upgrade process, errors occur and the following appears in the atlassian-confluence.log.  These errors may also appear when trying to save a page:

ERROR [main] [hibernate.tool.hbm2ddl.SchemaUpdate] execute The table '#sql-73a5_5' is full
ERROR [main] [hibernate.tool.hbm2ddl.SchemaUpdate] execute could not complete schema update
java.sql.SQLException: The table '#sql-73a5_5' is full
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1072)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3563)
	...

Cause

MySQL can't alter the table since it specifies a certain amount of space for each table and has reached its maximum size. It usually occurs in Innodb storage format, where it's configured in my.cnf or my.ini.

Resolution

  1. Stop MySQL
  2. Backup my.cnf file
  3. Remove the particular line if it's inside the file

    innodb_file_per_table
    
  4. Replace the previous line with the following, if the previous configuration did not exist put the following line under [mysqld]

    innodb_data_file_path = ibdata1:10M:autoextend
    
  5. Restart MySQL

Last modified on Mar 30, 2016

Was this helpful?

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