Public bug reported:
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
** Affects: neutron-fwaas (Ubuntu)
Importance: Undecided
Status: New
** Tags: cinder-volumes
** Attachment added: "cinder-volume-error-whilst-populating-db.PNG"
https://bugs.launchpad.net/bugs/1888222/+attachment/5394306/+files/cinder-volume-error-whilst-populating-db.PNG
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1888222
Title:
Error whilst populating Cinder Volume database
To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/neutron-fwaas/+bug/1888222/+subscriptions
--
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
