Error whilst populating Cinder Volume database

[Sagar Gurung]

After all the configurations, when I tried to populate Cinder-Volume database, below error generated although it completed its migrations till end. I double checked the character set as well and it is set to utf8. Never used to get this error before as I used same steps to set up openstack before. Now, there seems to be. Is it a bug or any idea why this is an issue? Please help. Thank you.

ERROR below:

2020-07-20 11:19:05.946 49256 INFO migrate.versioning.api [-] done
2020-07-20 11:19:05.947 49256 INFO migrate.versioning.api [-] 124 -> 125...
2020-07-20 11:19:05.954 49256 INFO migrate.versioning.api [-] done
2020-07-20 11:19:05.954 49256 INFO migrate.versioning.api [-] 125 -> 126...
2020-07-20 11:19:05.961 49256 INFO migrate.versioning.api [-] done
2020-07-20 11:19:05.961 49256 INFO migrate.versioning.api [-] 126 -> 127...
2020-07-20 11:19:05.965 49256 ERROR oslo_db.sqlalchemy.exc_filters [-] DBAPIError exception wrapped from (pymysql.err.InternalError) (1071, 'Specified key was too long; max key length is 767 bytes') [SQL: '\nALTER TABLE quota_usages CHANGE COLUMN resource resource VARCHAR(300)'] (Background on this error at : http://sqlalche.me/e/2j85): pymysql.err.InternalError: (1071, 'Specified key was too long; max key length is 767 bytes')
2020-07-20 11:19:05.965 49256 ERROR oslo_db.sqlalchemy.exc_filters Traceback (most recent call last):
2020-07-20 11:19:05.965 49256 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1193, in _execu te_context
2020-07-20 11:19:05.965 49256 ERROR oslo_db.sqlalchemy.exc_filters context)
2020-07-20 11:19:05.965 49256 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 509, in do_e xecute
2020-07-20 11:19:05.965 49256 ERROR oslo_db.sqlalchemy.exc_filters cursor.execute(statement, parameters)
2020-07-20 11:19:05.965 49256 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/pymysql/cursors.py", line 165, in execute
2020-07-20 11:19:05.965 49256 ERROR oslo_db.sqlalchemy.exc_filters result = self._query(query)
2020-07-20 11:19:05.965 49256 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/pymysql/cursors.py", line 321, in _query
2020-07-20 11:19:05.965 49256 ERROR oslo_db.sqlalchemy.exc_filters conn.query(q)
2020-07-20 11:19:05.965 49256 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 860, in query
2020-07-20 11:19:05.965 49256 ERROR oslo_db.sqlalchemy.exc_filters self._affected_rows = self._read_query_result(unbuffered=unbuffered)
2020-07-20 11:19:05.965 49256 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 1061, in _read_que ry_result
2020-07-20 11:19:05.965 49256 ERROR oslo_db.sqlalchemy.exc_filters result.read()
2020-07-20 11:19:05.965 49256 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 1349, in read
2020-07-20 11:19:05.965 49256 ERROR oslo_db.sqlalchemy.exc_filters first_packet = self.connection._read_packet()
2020-07-20 11:19:05.965 49256 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 1018, in _read_pac ket
2020-07-20 11:19:05.965 49256 ERROR oslo_db.sqlalchemy.exc_filters packet.check_error()
2020-07-20 11:19:05.965 49256 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 384, in check_erro r
2020-07-20 11:19:05.965 49256 ERROR oslo_db.sqlalchemy.exc_filters err.raise_mysql_exception(self._data)
2020-07-20 11:19:05.965 49256 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/pymysql/err.py", line 107, in raise_mysql_except ion
2020-07-20 11:19:05.965 49256 ERROR oslo_db.sqlalchemy.exc_filters raise errorclass(errno, errval)
2020-07-20 11:19:05.965 49256 ERROR oslo_db.sqlalchemy.exc_filters pymysql.err.InternalError: (1071, 'Specified key was too long; max key length is 767 by tes')
2020-07-20 11:19:05.965 49256 ERROR oslo_db.sqlalchemy.exc_filters
2020-07-20 11:19:05.970 49256 INFO migrate.versioning.api [-] done
2020-07-20 11:19:05.970 49256 INFO migrate.versioning.api [-] 127 -> 128...
2020-07-20 11:19:06.261 49256 INFO migrate.versioning.api [-] done

My 99-openstack.cnf configurations below:

[mysqld]
bind-address = 10.5.60.22
default-storage-engine = innodb
innodb_file_per_table = on
max_connections = 4096
collation-server = utf8_general_ci
character-set-server = utf8