Update default system encoding setting for Mysql images

[service:drupalci/mysql-9-database] 2024-08-16T14:08:52.774462329Z rebuilding /var/lib/mysql/ibdata1 [service:drupalci/mysql-9-database] 2024-08-16T14:08:52.789233576Z 2024-08-16T14:08:52.785324Z 0 [System] [MY-015017] [Server] MySQL Server Initialization - start. [service:drupalci/mysql-9-database] 2024-08-16T14:08:52.789246537Z 2024-08-16T14:08:52.786505Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 9.0.1) initializing of server in progress as process 8 [service:drupalci/mysql-9-database] 2024-08-16T14:08:52.789252836Z 2024-08-16T14:08:52.786536Z 0 [ERROR] [MY-010338] [Server] Can't find error-message file '/usr/share/mysql-8.4/english/errmsg.sys'. Check error-message file location and 'lc-messages-dir' configuration directive. [service:drupalci/mysql-9-database] 2024-08-16T14:08:52.789256306Z 2024-08-16T14:08:52.787559Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. [service:drupalci/mysql-9-database] 2024-08-16T14:08:52.789262756Z 2024-08-16T14:08:52.787564Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8mb3_general_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead. [service:drupalci/mysql-9-database] 2024-08-16T14:08:52.798698404Z 2024-08-16T14:08:52.798633Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. [service:drupalci/mysql-9-database] 2024-08-16T14:08:52.902264999Z 2024-08-16T14:08:52.902180Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. [service:drupalci/mysql-9-database] 2024-08-16T14:08:54.092341406Z 2024-08-16T14:08:54.092177Z 6 [Warning] [MY-010453] [Server] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option. [service:drupalci/mysql-9-database] 2024-08-16T14:08:54.996434581Z 2024-08-16T14:08:54.996300Z 0 [System] [MY-015018] [Server] MySQL Server Initialization - end. [service:drupalci/mysql-9-database] 2024-08-16T14:08:55.008515253Z mysqladmin: connect to server at 'localhost' failed [service:drupalci/mysql-9-database] 2024-08-16T14:08:55.008524253Z error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' [service:drupalci/mysql-9-database] 2024-08-16T14:08:55.008526573Z Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists! [service:drupalci/mysql-9-database] 2024-08-16T14:08:55.231233414Z 2024-08-16T14:08:55.018320Z 0 [System] [MY-015015] [Server] MySQL Server - start. [service:drupalci/mysql-9-database] 2024-08-16T14:08:55.231245965Z 2024-08-16T14:08:55.227983Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 9.0.1) starting as process 74 [service:drupalci/mysql-9-database] 2024-08-16T14:08:55.231249535Z 2024-08-16T14:08:55.228015Z 0 [ERROR] [MY-010338] [Server] Can't find error-message file '/usr/share/mysql-8.4/english/errmsg.sys'. Check error-message file location and 'lc-messages-dir' configuration directive. [service:drupalci/mysql-9-database] 2024-08-16T14:08:55.231252245Z 2024-08-16T14:08:55.229069Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. [service:drupalci/mysql-9-database] 2024-08-16T14:08:55.231254565Z 2024-08-16T14:08:55.229075Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8mb3_general_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead. [service:drupalci/mysql-9-database] 2024-08-16T14:08:55.241553787Z 2024-08-16T14:08:55.241450Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. [service:drupalci/mysql-9-database] 2024-08-16T14:08:55.343145329Z 2024-08-16T14:08:55.343035Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. [service:drupalci/mysql-9-database] 2024-08-16T14:08:55.517587512Z 2024-08-16T14:08:55.517460Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed. [service:drupalci/mysql-9-database] 2024-08-16T14:08:55.517599642Z 2024-08-16T14:08:55.517495Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel. [service:drupalci/mysql-9-database] 2024-08-16T14:08:55.522706697Z 2024-08-16T14:08:55.522626Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory. [service:drupalci/mysql-9-database] 2024-08-16T14:08:55.534749719Z 2024-08-16T14:08:55.534646Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock [service:drupalci/mysql-9-database] 2024-08-16T14:08:55.534817821Z 2024-08-16T14:08:55.534756Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '9.0.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server - GPL. [service:drupalci/mysql-9-database] 2024-08-16T14:08:56.016196654Z mysqld is alive [service:drupalci/mysql-9-database] 2024-08-16T14:08:56.034220846Z User [service:drupalci/mysql-9-database] 2024-08-16T14:08:56.034233297Z drupaltestbot [service:drupalci/mysql-9-database] 2024-08-16T14:08:56.034235727Z mysql.infoschema [service:drupalci/mysql-9-database] 2024-08-16T14:08:56.034237917Z mysql.session [service:drupalci/mysql-9-database] 2024-08-16T14:08:56.034240087Z mysql.sys [service:drupalci/mysql-9-database] 2024-08-16T14:08:56.034242187Z root [service:drupalci/mysql-9-database] 2024-08-16T14:08:56.036355202Z Grants added

Comments & Activities

Issue created by @andypost
Comment 5 months ago →
🇫🇷France andypost
Status changed to Needs review 5 months ago12:10pm 19 August 2024
Comment 5 months ago →
🇫🇷France andypost
The MR https://git.drupalcode.org/project/drupalci_environments/-/merge_request...
Comment about 2 months ago →
🇳🇱Netherlands bbrala Netherlands
How scary is this for possible indexes? Not sure what field types we use but the character limit will go down as the bytes per caharacter go up. Jas this been considered?
Comment about 2 months ago →
🇫🇷France andypost
I bet it will effect on tmpfs usage, moreover ATM mysql:8 image sometimes fail to start
Comment about 2 months ago →
🇳🇱Netherlands bbrala Netherlands
An index on a (var)char > 176 will fail since it will run out of the max 100 bytes. Mostly referring to that.
Comment about 1 month ago →
🇫🇷France andypost
Probably core needs own issue to discus default encoding additionally to ✨ Make ROW_FORMAT configurable Needs work

InnoDB tables have a max index length of 767 bytes (in MySQL 5.6 and older) or 3072 bytes (MySQL 5.7+ with innodb_large_prefix enabled).

UTF-8 MB4 encoding uses up to 4 bytes per character, meaning strings longer than 191 characters can exceed the max index size.

Update default system encoding setting for Mysql images

Problem/Motivation

Steps to reproduce

Proposed resolution

Remaining tasks

User interface changes

API changes

Data model changes

Comments & Activities