yahoo-eng-team team mailing list archive

[Sheel Rana <ranasheel2000@xxxxxxxxx>]

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