Univention Bugzilla – Bug 46537
MariaDB limits indexes to 767 bytes / different mysqld charset defaults in UCS 4.3 compared to 4.2
Last modified: 2018-03-14 14:37:58 CET
Prior to UCS 4.3 (with MySQL 5.5) this did not happen: liquibase.exception.DatabaseException: Specified key was too long; max key length is 767 bytes [Failed SQL: ALTER TABLE bis.UserTable ADD CONSTRAINT EMAIL UNIQUE (EMAIL)] This is what I found in "docker logs" in two Apps. digitec-bis bluespice
If this is not feasible, we need a new bug to block the update for setups with this App and remove 4.3 from the list of "SupportedUCSVersions" in the corresponding ini files.
See Bug#46538. But we would need that for UCS 4.2
Debian changed the mariadb default character set to utf8mb4 and collation to utf8mb4_general_ci [1] [2] Some software seems to rely on these defaults and does not set the required charsets when creating their databases, tables and columns. 0c08b0d7 Use mariadb default values for character-set-server and collation-server dd5e0bbc changelog univention-mariadb 1.0.1-4A~4.3.0.201803081102 [1] https://mariadb.com/kb/en/library/differences-in-mariadb-in-debian-and-ubuntu/ [2] https://mariadb.com/kb/en/library/setting-character-sets-and-collations/
Works. Apps can be installed again.
UCS 4.3 has been released: https://docs.software-univention.de/release-notes-4.3-0-en.html https://docs.software-univention.de/release-notes-4.3-0-de.html If this error occurs again, please use "Clone This Bug".