yahoo-eng-team team mailing list archive

[hubert chen <chf@xxxxxxxxxxxxxxx>]

** Project changed: nova => neutron

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to neutron.
https://bugs.launchpad.net/bugs/1844595

Title:
  openstackNova(Rocky)--chinese incorrect codes for db character error

Status in neutron:
  Incomplete

Bug description:
  Description
  ===========
  When search security-group, a message "Incorrect string value" is sent.

  Environment
  ===========
  [root@controller1 ~]# lsb_release -a
  LSB Version:	:core-4.1-mips64el:core-4.1-noarch:cxx-4.1-mips64el:cxx-4.1-noarch:desktop-4.1-mips64el:desktop-4.1-noarch:languages-4.1-mips64el:languages-4.1-noarch:printing-4.1-mips64el:printing-4.1-noarch
  Distributor ID:	Loongnix
  Description:	Loongnix release 1.0 (20190331)
  Release:	1.0
  Codename:	20190331

  
  Steps to reproduce & Expected result
  ======================
  execute a cli：
  [root@controller1 ~]# openstack security group list
  HttpException: 500: Server Error for url: http://controller1:9696/v2.0/security-groups, {"NeutronError": {"message": "\u8bf7\u6c42\u5931\u8d25\uff1a\u5728\u5904\u7406\u8bf7\u6c42\u65f6\uff0c\u53d1\u751f\u5185\u90e8\u670d\u52a1\u5668\u9519\u8bef\u3002", "type": "HTTPInternalServerError", "detail": ""}}
  2019-09-17 15:29:49.660 1845 ERROR neutron.api.v2.resource DBDataError: (pymysql.err.InternalError) (1366, u"Incorrect string value: '\\xE7\\xBC\\xBA\\xE7\\x9C\\x81...' for column 'description' at row 1") [SQL: u'INSERT INTO standa      rdattributes (resource_type, description, created_at, updated_at) VALUES (%(resource_type)s, %(description)s, %(created_at)s, %(updated_at)s)'] [parameters: {'created_at': datetime.datetime(2019, 9, 17, 7, 29, 49), 'description': u      '\u7f3a\u7701\u5b89\u5168\u7ec4', 'resource_type': 'securitygroups', 'updated_at': datetime.datetime(2019, 9, 17, 7, 29, 49)}] (Background on this error at: http://sqlalche.me/e/2j85)

  Logs & Configs
  ==============
  MariaDB [(none)]> show variables like 'character%';
  +--------------------------+------------------------------+
  | Variable_name            | Value                        |
  +--------------------------+------------------------------+
  | character_set_client     | utf8                         |
  | character_set_connection | utf8                         |
  | character_set_database   | latin1                       |
  | character_set_filesystem | binary                       |
  | character_set_results    | utf8                         |
  | character_set_server     | latin1                       |
  | character_set_system     | utf8                         |
  | character_sets_dir       | /usr/share/mariadb/charsets/ |
  +--------------------------+------------------------------+

To manage notifications about this bug go to:
https://bugs.launchpad.net/neutron/+bug/1844595/+subscriptions