)]}'
{"/PATCHSET_LEVEL":[{"author":{"_account_id":28619,"name":"Dmitriy Rabotyagov","email":"noonedeadpunk@gmail.com","username":"noonedeadpunk"},"change_message_id":"e70a75d89b60a2ec7610ff2e4157b686da229af6","unresolved":false,"context_lines":[],"source_content_type":"","patch_set":5,"id":"57f91171_53ad7ed8","updated":"2025-09-10 07:51:32.000000000","message":"I need also to check for the `old_mode`: https://mariadb.com/docs/server/server-management/variables-and-modes/server-system-variables#old_mode\n\nAs realised it\u0027s default could have changed. While it\u0027s not described for the variable itself, it was mentioned on https://mariadb.com/docs/server/reference/data-types/string-data-types/character-sets/unicode","commit_id":"19fa2275acb5a3a50852ee221fca380ee4b945cf"},{"author":{"_account_id":28619,"name":"Dmitriy Rabotyagov","email":"noonedeadpunk@gmail.com","username":"noonedeadpunk"},"change_message_id":"6a2ec54b790fc48d5074fd2b3a5b0f31f4b539d2","unresolved":false,"context_lines":[],"source_content_type":"","patch_set":5,"id":"59f41d5f_a3f2ed36","updated":"2025-09-10 10:21:54.000000000","message":"okay, got confirmation that default value of `old_mode` was not changed yet","commit_id":"19fa2275acb5a3a50852ee221fca380ee4b945cf"}],"defaults/main.yml":[{"author":{"_account_id":11604,"name":"sean mooney","email":"smooney@redhat.com","username":"sean-k-mooney"},"change_message_id":"1f61c624ea9c2b39ef6bcaec4eb6a3b6d2de1101","unresolved":true,"context_lines":[{"line_number":129,"context_line":""},{"line_number":130,"context_line":"## charset options"},{"line_number":131,"context_line":"galera_default_charset: utf8mb3"},{"line_number":132,"context_line":"galera_default_collation: general_ci"},{"line_number":133,"context_line":"# NOTE: Default collation set will be updated with defined above defaults"},{"line_number":134,"context_line":"galera_default_collation_set:"},{"line_number":135,"context_line":"  utf8mb3: utf8mb3_uca1400_ai_ci"}],"source_content_type":"text/x-yaml","patch_set":5,"id":"14e08a22_0c44ad20","line":132,"range":{"start_line":132,"start_character":26,"end_line":132,"end_character":36},"updated":"2025-09-08 11:14:24.000000000","message":"galera_default_charset: utf8mb4\ngalera_default_collation: utf8mb4_bin\n\nin general openstack apis are intened to be case senseivte and we have also moved to the 4 bytye encodeign fo utf8 a while ago.\n\nbasiclly i think this change happend sometime around the adoption fo 22.04 or 24.04 for many so going back to the utf8mb3 would seam like a regression.\n\nthis may be an ok value in some case for upgrade but for new deployment those dont seam like the value we shoudl have.","commit_id":"19fa2275acb5a3a50852ee221fca380ee4b945cf"},{"author":{"_account_id":28619,"name":"Dmitriy Rabotyagov","email":"noonedeadpunk@gmail.com","username":"noonedeadpunk"},"change_message_id":"17d13e2874b68a273a2663d2cc475ae20abf902c","unresolved":false,"context_lines":[{"line_number":129,"context_line":""},{"line_number":130,"context_line":"## charset options"},{"line_number":131,"context_line":"galera_default_charset: utf8mb3"},{"line_number":132,"context_line":"galera_default_collation: general_ci"},{"line_number":133,"context_line":"# NOTE: Default collation set will be updated with defined above defaults"},{"line_number":134,"context_line":"galera_default_collation_set:"},{"line_number":135,"context_line":"  utf8mb3: utf8mb3_uca1400_ai_ci"}],"source_content_type":"text/x-yaml","patch_set":5,"id":"412a5ddd_267a7394","line":132,"range":{"start_line":132,"start_character":26,"end_line":132,"end_character":36},"in_reply_to":"14e08a22_0c44ad20","updated":"2025-09-10 07:35:46.000000000","message":"So let\u0027s look at nova migrations:\nhttps://opendev.org/openstack/nova/src/commit/2952c109489f9cbe082f9a9e79d4ac5b15dba290/nova/db/api/migrations/versions/d67eeaabee36_initial_version.py#L59\n\n`utf8` for MariaDB versions 10.6 until 11.8 this was an alias to `utf8mb3`:\nhttps://mariadb.com/docs/server/reference/data-types/string-data-types/character-sets/unicode\n\nIf you check current defaults in https://review.opendev.org/c/openstack/openstack-ansible-galera_server/+/959075/5/templates/my.cnf.j2 - this patch just aims to make them configurable.\n\nSo I\u0027m pretty much just keeping defaults here. It does not mean it\u0027s end of the story, but wanna address these changes incrementally. So it\u0027s not a regression - it\u0027s keeping the existing behavior while allowing to be more flexible.\n\nOnce we have them as variables - we can add an upgrade script to override defaults for deployments that are upgrading and update defaults for new deployments.\n\nHowever, the question would still be what to do with old ones. As what I do not want to bring in now is inconsistency in charsets/collations until there\u0027s some common view on this issue from community prespective.","commit_id":"19fa2275acb5a3a50852ee221fca380ee4b945cf"}]}