App’s settings page gives status 500 directly after installing when using MySQL/MariaDB

Owned by Caroline Trink (Unlicensed)
Last updated: Jun 29, 2022 by Michael Rüegg
1 min read

Problem

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 767 bytes

Solution

Bitbucket Server recommends utf8_bin for MySQL tables.

Therefore, you have to change the character set of your MySQL tables to utf8_bin.


SONAR™, SONARQUBE™ and SONARCLOUD™ are independent and trademarked products and services of SonarSource SA: see sonarsource.com, sonarqube.org, sonarcloud.io.