** Changed in: nova Importance: Medium => High ** Also affects: nova/newton Importance: Undecided Status: New
** Also affects: nova/ocata Importance: Undecided Status: New -- You received this bug notification because you are a member of Yahoo! Engineering Team, which is subscribed to OpenStack Compute (nova). https://bugs.launchpad.net/bugs/1696001 Title: nova-manage cell_v2 map_cell0 can create invalid connection URL Status in OpenStack Compute (nova): Confirmed Status in OpenStack Compute (nova) newton series: New Status in OpenStack Compute (nova) ocata series: New Bug description: Description =========== nova-manage cell_v2 map_cell0 will automatically generate a database connection url from the existing connection configuration setting. However, if the connection has query parameters like a charset defined, it will generate an invalid URL. Steps to reproduce ================== Set the following in the nova.conf: [database] connection = mysql+pymysql://nova:passw...@db.example.com/nova?charset=utf8 Run: nova-manage cell_v2 map_cell0 Excepted result =============== Cell0 is mapped to mysql+pymysql://nova:passw...@db.example.com/nova_cell0?charset=utf8 Actual Result ============= Cell0 is mapped to mysql+pymysql://nova:passw...@db.example.com/nova?charset=utf8nova_cell0 Subsequent API calls may fail because of this with exceptions like: 2017-06-05 20:54:20.343 2197 ERROR nova.api.openstack.extensions File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 660, in __init__ 2017-06-05 20:54:20.343 2197 ERROR nova.api.openstack.extensions self.encoding = charset_by_name(self.charset).encoding 2017-06-05 20:54:20.343 2197 ERROR nova.api.openstack.extensions AttributeError: 'NoneType' object has no attribute 'encoding' because utf8nova_cell0 is not a valid encoding. Environment: OpenStack Ocata, # dpkg -l | grep nova-common ii nova-common 2:15.0.5-1~u16.04+mcp5 all OpenStack Compute - common files To manage notifications about this bug go to: https://bugs.launchpad.net/nova/+bug/1696001/+subscriptions -- Mailing list: https://launchpad.net/~yahoo-eng-team Post to : yahoo-eng-team@lists.launchpad.net Unsubscribe : https://launchpad.net/~yahoo-eng-team More help : https://help.launchpad.net/ListHelp