Bug 46537 - MariaDB limits indexes to 767 bytes / different mysqld charset defaults in UCS 4.3 compared to 4.2
MariaDB limits indexes to 767 bytes / different mysqld charset defaults in UC...
Status: CLOSED FIXED
Product: UCS
Classification: Unclassified
Component: MySQL
UCS 4.3
Other Linux
: P5 normal (vote)
: UCS 4.3
Assigned To: Erik Damrose
Dirk Wiesenthal
: interim-4
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2018-03-08 09:03 CET by Dirk Wiesenthal
Modified: 2018-03-14 14:37 CET (History)
2 users (show)

See Also:
What kind of report is it?: Development Internal
What type of bug is this?: ---
Who will be affected by this bug?: ---
How will those affected feel about the bug?: ---
User Pain:
Enterprise Customer affected?:
School Customer affected?:
ISV affected?:
Waiting Support:
Flags outvoted (downgraded) after PO Review:
Ticket number:
Bug group (optional):
Max CVSS v3 score:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Dirk Wiesenthal univentionstaff 2018-03-08 09:03:46 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
Comment 1 Dirk Wiesenthal univentionstaff 2018-03-08 09:05:25 CET
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.
Comment 2 Dirk Wiesenthal univentionstaff 2018-03-08 09:11:44 CET
See Bug#46538. But we would need that for UCS 4.2
Comment 3 Erik Damrose univentionstaff 2018-03-08 11:11:27 CET
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/
Comment 4 Dirk Wiesenthal univentionstaff 2018-03-08 17:33:06 CET
Works. Apps can be installed again.
Comment 5 Stefan Gohmann univentionstaff 2018-03-14 14:37:58 CET
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".