Failed to access the database: Database error occurred

When a connection failure occurs, the driver that the Klocwork tools use to communicate with the primary database returns an error code and SQL state value, which is required to reconnect.

In Klocwork 2025.1, the MySQL database driver was replaced with the MariaDB driver. Because the error code and SQL state values returned by these two drivers are different, starting in release 2025.1, certain connection failures may issue a value that is mapped to the wrong error, or that has not been accounted for yet.

To resolve potential connection failures with minimal downtime, project administrators can account for additional connection failure values.

The error signature will appear in projects_root\config\klocwork.log and will match the following regex pattern:

.*ERROR .* An exception occurred while executing .* Failed to access the database: Database error occurred: \(conn=[\d]+\) Connection is closed in SQL statement .*

1. In Validate, turn on debug-level logging by going to https://<your-server-name>/review/insight-review.html#logconf. The Logging Configuration page will appear.
2. At the end of the Logging Configuration file, add one of the following lines:
   • If you are troubleshooting this error for the first time:
     log4j.logger.com.klocwork.database.config.MySQLDatabaseConfiguration=DEBUG
   • If you previously troubleshooted this error and the problem persists:
     log4j.logger.com.klocwork.database.config.MySQLDatabaseConfiguration=TRACE
     
3. Click Apply.
4. Wait for the error to be reproduced.
5. Remove the DEBUG or TRACE line that you previously added to the Logging Configuration file. Deselect the Log SQL queries and Profile SQL checkboxes, then click Apply.
6. The projects_root\config\klocwork.log file will contain a message that matches the following pattern:
   Will not refresh connection for error code: "<CODE>" and sql state: "<STATE>".
7. In the Validate package config folder, create a file named maria_reconnect_codes.json. Add the value found in projects_root\config\klocwork.log to config\maria_reconnect_codes.json, using the following structure:

   [
   {"errorCode": "<CODE>", "sqlState": "<STATE>"},
   ]

   For example:

   [
   {"errorCode": "<CODE>", "sqlState": "<STATE>"},
   ]

8. Restart the Validate servers.