OpenStack DB Error : (pymysql.err.InternalError) (1071,1071 – Specified key was too long; max key length is 767 bytes

Openstack Liberty

DB Error : (pymysql.err.InternalError) (1071,1071 – Specified key was too long; max key length is 767 bytes

 

1) Replace all instances of ‘utf8mb4’ with ‘utf8’ in /etc/mysql/mariadb.conf.d/*2) Add the below to /etc/mysql/conf.d/mysqld_openstack.cnf:

cat /etc/mysql/conf.d/mysqld_openstack.cnf:
[client]
default-character-set = utf8
[mysqld]
bind-address = <<IP>>
default-storage-engine =###
innodb_file_per_table
collation-server = utf8_general_ci
init-connect = ‘SET NAMES utf8’
character-set-server = utf8
[mysql]
default-character-set = utf8

3) Drop the keystone database
4) Restart mysql service
5) Run ‘keystone-manage db_sync’

 Modify the files in /etc/mysql/mariadb.conf.d/ was also necessary to fix.

Posted in Cloud.

Leave a Reply

Your email address will not be published. Required fields are marked *