Support Health Check issues within Confluence using MySQL database

Still need help?

The Atlassian Community is here for you.

Ask the community

Platform Notice: Server and Data Center Only - This article only applies to Atlassian products on the server and data center platforms.

Problem

Confluence is using MySQL database and may be exhibiting the following issue:

  1. Unexpected crashes
  2. 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

Diagnosis

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"

Cause

The healthcheck plugin cannot handle a mysql database name with a hyphen in it.

Resolution

Rename the database so that it does not contain hyphens "-"

 

Last modified on Jun 5, 2017

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.