Unable to Upgrade or Save Pages Due to Table is Full Error
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
- Stop MySQL
- Backup
my.cnf
file Remove the particular line if it's inside the file
innodb_file_per_table
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
- Restart MySQL