Support Health Check issues within Confluence using MySQL database
プラットフォームについて: Server および Data Center のみ。この記事は、Server および Data Center プラットフォームのアトラシアン製品にのみ適用されます。
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.
*Fisheye および Crucible は除く
問題
Confluence is using MySQL database and may be exhibiting the following issue:
- Unexpected crashes
- Error messages in the Health Check menu:
The following error message appears in the atlassian-confluence.log
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-abc.supporthealthchecks' at line 1診断
Diagnostic Steps
Check if Confluence database has an illegal character hyphen "-" in it.
From the example above, Confluence has been connected to a database with the name "confluence-abc"
原因
The healthcheck plugin cannot handle a mysql database name with a hyphen in it.
ソリューション
Rename the database so that it does not contain hyphens "-"