** 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 -- Mailing list: https://launchpad.net/~yahoo-eng-team Post to : yahoo-eng-team@lists.launchpad.net Unsubscribe : https://launchpad.net/~yahoo-eng-team More help : https://help.launchpad.net/ListHelp