Public bug reported:
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)
** Affects: keystone
Importance: Undecided
Assignee: Sheel Rana (ranasheel2000)
Status: New
** Changed in: keystone
Assignee: (unassigned) => Sheel Rana (ranasheel2000)
--
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):
New
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
