Unable to install plugins due to innodb_log_file_size using MySQL

お困りですか?

アトラシアン コミュニティをご利用ください。

コミュニティに質問

プラットフォームについて: サーバーと Data Center のみ。この記事は、サーバーおよび Data Center プラットフォームのアトラシアン製品にのみ適用されます。

問題 

  • 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

診断

環境

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

原因

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.

ソリューション

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. 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. 

最終更新日 2019 年 6 月 20 日

この内容はお役に立ちましたか?

はい
いいえ
この記事についてのフィードバックを送信する
Powered by Confluence and Scroll Viewport.