Fix UTF-8 warning during Gerrit sync
Bug #1005923 reported by
Andrew Hutchings
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
OpenStack Core Infrastructure |
Fix Released
|
Medium
|
Andrew Hutchings |
Bug Description
Monty tried to fix this in https:/
To post a comment you must log in.
Python fires that warning when a character higher than 127 is used in an ASCII comparison. We know that only one row was hitting the warning due to only one instance of the warning (and no warnings on any other servers). Running this query found the problem:
SELECT * FROM account_ssh_keys WHERE NOT hex(ssh_public_key) REGEXP '^([0-7] [0-9A-F] )*$';
A user manually entered a key which had Windows style quote marks around the name. This key has now been repaired.