Newton on 16.04 Xenial and mysql's new default utf8mb4 charset
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
openstack-manuals |
Fix Released
|
Undecided
|
Unassigned |
Bug Description
Fresh install of Mitaka on default install of Xenial fails during populating the database steps.
The default character set of mysqld in Debian has been changed to utf8mb4 (from utf8), and "glance-manage db_sync" fails with:
2016-04-26 16:09:13.091 21061 ERROR oslo_db.
The length of the key for 'repository_id' with max 250 chars and 4 bytes per char makes it longer than the 767 allowed by innodb.
http://
Note:this was a multi-region setup, so glance was first component that needed a database sync. Most likely keystone install would also fail if one did install the identity service (during "keystone-manage db_sync") - http://
The settings in /etc/mysql/
Need to also set the following:
/etc/mysql/
/etc/mysql/
/etc/mysql/
/etc/mysql/
Changed in openstack-manuals: | |
assignee: | nobody → Chason (chen-xing) |
I got the same error when trying to populate the keystone-db.
I've created a file /etc/mysql/ mariadb. conf.d/ 60-openstack. cnf to overwrite the defaults containing character- set = utf8
~~~~~~~~~~~
[client]
default-
[mysqld] storage- engine = innodb file_per_ table set-server = utf8
bind-address = 127.0.1.1
default-
innodb_
collation-server = utf8_general_ci
character-
init-connect='SET NAMES utf8'
[mysql] character- set = utf8
default-
~~~~~~~~~~
and still get the error