Fix UTF-8 warning during Gerrit sync

Bug #1005923 reported by Andrew Hutchings
6
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://review.openstack.org/7824 but was reverted in https://review.openstack.org/7835 since it made things worse. Those reviews show the errors.

Revision history for this message
Andrew Hutchings (linuxjedi) wrote :

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.

Changed in openstack-ci:
status: New → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.