)]}'
{"/PATCHSET_LEVEL":[{"author":{"_account_id":13861,"name":"yatin","email":"ykarel@redhat.com","username":"yatinkarel"},"change_message_id":"bdcfb1224a9dbb51def3126d4a3ab1b3121b880b","unresolved":false,"context_lines":[],"source_content_type":"","patch_set":1,"id":"38a694d1_4658dd7f","updated":"2025-06-30 13:53:23.000000000","message":"check experimental","commit_id":"e5606b776eb3ee591ffda7504b7059be71adc23b"},{"author":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"change_message_id":"b678e19014c3574f40b2dd3cde72146639fc99b5","unresolved":false,"context_lines":[],"source_content_type":"","patch_set":1,"id":"378bfe90_66012cc5","updated":"2025-06-30 18:46:28.000000000","message":"recheck instance disappeared","commit_id":"e5606b776eb3ee591ffda7504b7059be71adc23b"}],"neutron/db/migration/alembic_migrations/versions/2025.2/expand/d553edeb540f_tag_case_sensitive.py":[{"author":{"_account_id":11604,"name":"sean mooney","email":"smooney@redhat.com","username":"sean-k-mooney"},"change_message_id":"7ed48023830abc75be4cdbdd4a6adae8fde1d441","unresolved":true,"context_lines":[{"line_number":35,"context_line":""},{"line_number":36,"context_line":"def upgrade():"},{"line_number":37,"context_line":"    try:"},{"line_number":38,"context_line":"        op.execute(\u0027ALTER TABLE tags CONVERT TO CHARACTER SET utf8mb4 \u0027"},{"line_number":39,"context_line":"                   \u0027COLLATE utf8mb4_bin\u0027)"},{"line_number":40,"context_line":"        op.execute(\u0027ALTER TABLE tags CHARACTER SET utf8mb4 \u0027"},{"line_number":41,"context_line":"                   \u0027COLLATE utf8mb4_bin\u0027)"},{"line_number":42,"context_line":"    except exc.OperationalError as _exc:"},{"line_number":43,"context_line":"        if \u0027Unknown collation\u0027 in str(_exc):"},{"line_number":44,"context_line":"            LOG.error(\u0027Collation \"utf8mb4_bin\" does not exist; the Neutron \u0027"}],"source_content_type":"text/x-python","patch_set":1,"id":"de97b2b2_99e8469d","line":41,"range":{"start_line":38,"start_character":8,"end_line":41,"end_character":41},"updated":"2025-06-30 17:40:16.000000000","message":"note for others\n\nthe first alter table actull convert the existing data rencoding it if needed\nthe scond one updates the default for new data to ensure we contiue to use the correc tencodings.\n\nif we only used the second command, it would not convert the existing data\n\nTechnically, the second alter table is implemented by the first in MySQL but i think this is more correct across different backends.\n\nnote that tese are mariadb/mysql specific statements.\n\nsqlite does nto implemnet charater sets adn coalation the same way and postgress uses diffent values.\n\nin nova we avoid using raw sql for protablity\n\nand the only time we have doen alter tables we have gated them like this\n\nhttps://github.com/openstack/nova/blob/master/nova/db/main/migrations/versions/16f1fbcab42b_resolve_shadow_table_diffs.py#L59-L64\n\ngivne neutorn is nologner supprotign postgress this is proably ok but im guesing the try except it requried for sqlite3 ?","commit_id":"e5606b776eb3ee591ffda7504b7059be71adc23b"},{"author":{"_account_id":16688,"name":"Rodolfo Alonso","email":"ralonsoh@redhat.com","username":"rodolfo-alonso-hernandez"},"change_message_id":"8f3dbd4880c9dbd45f6713e08a6f813bf37e3f40","unresolved":false,"context_lines":[{"line_number":35,"context_line":""},{"line_number":36,"context_line":"def upgrade():"},{"line_number":37,"context_line":"    try:"},{"line_number":38,"context_line":"        op.execute(\u0027ALTER TABLE tags CONVERT TO CHARACTER SET utf8mb4 \u0027"},{"line_number":39,"context_line":"                   \u0027COLLATE utf8mb4_bin\u0027)"},{"line_number":40,"context_line":"        op.execute(\u0027ALTER TABLE tags CHARACTER SET utf8mb4 \u0027"},{"line_number":41,"context_line":"                   \u0027COLLATE utf8mb4_bin\u0027)"},{"line_number":42,"context_line":"    except exc.OperationalError as _exc:"},{"line_number":43,"context_line":"        if \u0027Unknown collation\u0027 in str(_exc):"},{"line_number":44,"context_line":"            LOG.error(\u0027Collation \"utf8mb4_bin\" does not exist; the Neutron \u0027"}],"source_content_type":"text/x-python","patch_set":1,"id":"c2005ae2_34eb7653","line":41,"range":{"start_line":38,"start_character":8,"end_line":41,"end_character":41},"in_reply_to":"de97b2b2_99e8469d","updated":"2025-07-01 08:59:30.000000000","message":"As you mentioned, we don\u0027t support postgre. The sqlalchemy mantainer told me to use raw commands. I know this is not portable but is accepted by the supported backends.","commit_id":"e5606b776eb3ee591ffda7504b7059be71adc23b"}],"releasenotes/notes/tag-case-sensitive-f94700cd349a65a2.yaml":[{"author":{"_account_id":1131,"name":"Brian Haley","email":"haleyb.dev@gmail.com","username":"brian-haley"},"change_message_id":"3fc9c98c31a0894fc2f08ab39b5a0791ecebd78e","unresolved":true,"context_lines":[{"line_number":3,"context_line":"  - |"},{"line_number":4,"context_line":"    The resource tags are now case sensitive, following the `OpenStack"},{"line_number":5,"context_line":"    guidelines \u003chttps://specs.openstack.org/openstack/api-wg/guidelines/tags.html\u003e`_"},{"line_number":6,"context_line":"    for tags. \"tag\" table is now using case sensitive collate/charset"},{"line_number":7,"context_line":"    ``utf8mb4_bin``/``utf8mb4``, that are present in all MariaDB releases and"},{"line_number":8,"context_line":"    since MySQL 5.5.3 (2010)."}],"source_content_type":"text/x-yaml","patch_set":1,"id":"24a86f45_3e1e121f","line":6,"range":{"start_line":6,"start_character":14,"end_line":6,"end_character":19},"updated":"2025-06-30 14:23:28.000000000","message":"nit: s/The \"tag\" ...\n\nIf it needs a respin.","commit_id":"e5606b776eb3ee591ffda7504b7059be71adc23b"}]}