Unable to create a Confluence XML site backup when using MySQL

お困りですか?

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

コミュニティに質問

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

問題

You are not able to create an XML site backup, specifically when using MySQL as your database with Confluence. 

The following appears in the atlassian-confluence.log

atlassian-confluence.log
Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.
WARN [http-nio-8090-exec-58] [v2.c3p0.impl.NewPooledConnection] log [c3p0] Another error has occurred [ com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed. ] which will not be reported to listeners!

原因

MySQL closes the database connection that Confluence is using while creating the XML backup, which is a long-running process.

回避策

Increase the interactive_timeout and wait_timeout in MySQL.

interactive_timeout: The number of seconds the server waits for activity on an interactive connection before closing it. 

wait_timeout: The number of seconds the server waits for activity on a non-interactive connection before closing it.

  • Find out your current timeout values by running the following in MySQL with a privileged account:

    SHOW VARIABLES LIKE '%timeout%';
  • Edit the my.cnf file and increase the interactive_timeout and wait_timeout to be higher than the current value. You can do this by adding the respective variable and value under the [mysqld] section.

     

    Default Values
    [mysqld]
    wait_timeout = 28800
    interactive_timeout = 28800
  • Restart MySQL to apply the changes

     

 

最終更新日 2016 年 9 月 14 日

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

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