This should be fixed centrally with oslo.db. There is also no movement
on this patch in a long time, and I'm not convinced it's a realistic
problem (we handle UTF8 characters well enough in the database, just not
4byte ones).
** Changed in: keystone
Status: Confirmed => Won't Fix
--
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to OpenStack Identity (keystone).
https://bugs.launchpad.net/bugs/1545736
Title:
keystone role create failed when 4 byte unicode character is provided
in name field
Status in OpenStack Identity (keystone):
Won't Fix
Bug description:
mysql database does not support 4 byte unicode due to its utf8
character set.
If any operation is executed with 4byte unicode name, it reports 500 error
without any proper error message to user.
This will be confusing for user as no information is present about why this
issue occurred.
Please refer below for details:
# keystone role-create --name sheel_🌋
An unexpected error prevented the server from fulfilling your request:
(pymysql.err.InternalError) (1366, u"Incorrect string value:
'\\xF0\\x9F\\x8C\\x8B' for column 'name' at row 1") [SQL: u'INSERT INTO role
(id, name, extra) VALUES (%s, %s, %s)'] [parameters:
('fc291c14e5e54e5a9ae6b8e159e002c9', u'sheel_\U0001f30b', '{}')] (Disable debug
mode to suppress these details.) (HTTP 500) (Request-ID:
req-a713a94e-5704-4eb9-92c4-86c4c91354f0)
To manage notifications about this bug go to:
https://bugs.launchpad.net/keystone/+bug/1545736/+subscriptions
--
Mailing list: https://launchpad.net/~yahoo-eng-team
Post to : [email protected]
Unsubscribe : https://launchpad.net/~yahoo-eng-team
More help : https://help.launchpad.net/ListHelp
