[Bug 1888222] [NEW] Error whilst populating Cinder Volume database
Sagar Gurung
1888222 at bugs.launchpad.net
Mon Jul 20 11:51:13 UTC 2020
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
OpenStack, which is subscribed to neutron-fwaas in Ubuntu.
https://bugs.launchpad.net/bugs/1888222
Title:
Error whilst populating Cinder Volume database
Status in neutron-fwaas package in Ubuntu:
New
Bug description:
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
To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/neutron-fwaas/+bug/1888222/+subscriptions
More information about the Ubuntu-openstack-bugs
mailing list