Platform notice: Server and Data Center only. This article only applies to Atlassian products on the Server and Data Center platforms.

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

Problem 

• Unable to install certain plugins (Generally plugins which is big in size)

• Plugin installation will take a while load but does not finish and ends up with an error of on the UI.

   An error occurred during installation. Refer to the logs for more information 

• The atlassian-confluence.log shows the error below :

  2015-11-11 11:11:00,385 ERROR [UpmAsynchronousTaskManager:thread-2] [sf.hibernate.util.JDBCExceptionReporter] logExceptions The size of BLOB/TEXT data inserted in one transaction is greater than 10% of redo log size. Increase the redo log size using innodb_log_file_size.
   -- url: /rest/plugins/1.0/ | referer: https://user.com/plugins/servlet/upm | userName: user

Diagnosis

Environment

• Any version of Confluence running on MySQL
• We have seen this specifically with the Gliffy plugin, but this can happen with any other plugin

Cause

The innodb_log_file_size is not set to the size recommended in Database Setup For MySQL, or the plugin is too large for the recommended setting.

Resolution

Increase the Innodb_log_file_size to a bigger value. Generally the rule of thumb is to increase the Innodb_log_file_size to 10 times the size of the plugin. 

1. Shutdown Confluence and shutdown the MySQL database service.

2. Go to my.ini (for windows) or my.cnf  (for Linux) and change the parameters below accordingly. (2GB per the recommendation)

   [mysqld]
   ...
   innodb_log_file_size=2GB
   ...

3. Go to the MySQL installation data folder (normally C:\Program Files\MySQL\MySQL Server 5.6\data) and copy all the ib_logfile0, ib_logfile1,....and so on with the same prefix ib_logfile and paste it somewhere else. (This is to keep a safe copy of the log file)
4. Delete the files.
5. Restart your MySQL database service.

6. Clear your plugins cache by removing the following directories:
    This will remove the plugin cache files only and will not permanently remove any plugins. These directories will be recreated during the next Confluence startup. However, some third-party plugins may store metadata in these directories, so we recommend creating a temporary backup of the directories.

   <confluence-home>/bundled-plugins
   <confluence-home>/plugins-cache
   <confluence-home>/plugins-osgi-cache
   <confluence-home>/plugins-temp
   <confluence-home>/bundled-plugins_language

7. Restart Confluence
8. Reattempt the plugin installation.
9. If it's working fine, you might want to do some trial and error to reduce and tweak the innodb_log_file_size.