yahoo-eng-team team mailing list archive

[Steve Martinelli <1545736@xxxxxxxxxxxxxxxxxx>]

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