)]}'
{"id":"openstack%2Foctavia~980436","triplet_id":"openstack%2Foctavia~master~I0000000000000000000000000000000000000001","project":"openstack/octavia","branch":"master","hashtags":[],"change_id":"I0000000000000000000000000000000000000001","subject":"Fix column types not resized by previous migrations","status":"ABANDONED","created":"2026-03-13 13:53:42.000000000","updated":"2026-03-13 13:54:28.000000000","total_comment_count":0,"unresolved_comment_count":0,"has_review_started":true,"meta_rev_id":"fa41c749f16b6bf616a03cc08f64b71e92f06aa5","_number":980436,"virtual_id_number":980436,"owner":{"_account_id":19702,"name":"Damien RANNOU","email":"damien.rannou@corp.ovh.com","username":"DamienRANNOU","status":"OVHcloud"},"actions":{},"labels":{"Verified":{"values":{"-2":"Fails","-1":"Doesn\u0027t seem to work"," 0":"No score","+1":"Works for me","+2":"Verified"},"description":"","default_value":0,"optional":true},"Code-Review":{"values":{"-2":"Do not merge","-1":"This patch needs further work before it can be merged"," 0":"No score","+1":"Looks good to me, but someone else must approve","+2":"Looks good to me (core reviewer)"},"description":"","default_value":0,"optional":true},"Workflow":{"values":{"-1":"Work in progress"," 0":"Ready for reviews","+1":"Approved"},"description":"","default_value":0,"optional":true},"Backport-Candidate":{"values":{"-2":"Do Not Backport","-1":"Not A Backport Candidate"," 0":"Backport Review Needed","+1":"Proposed Backport","+2":"Should Backport"},"description":"","default_value":0,"optional":true}},"removable_reviewers":[],"reviewers":{},"pending_reviewers":{},"reviewer_updates":[],"messages":[{"id":"1bf06f3379fd0cfc870cbba586f33e36f390ac25","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":19702,"name":"Damien RANNOU","email":"damien.rannou@corp.ovh.com","username":"DamienRANNOU","status":"OVHcloud"},"date":"2026-03-13 13:53:42.000000000","message":"Uploaded patch set 1.","accounts_in_message":[],"_revision_number":1},{"id":"fa41c749f16b6bf616a03cc08f64b71e92f06aa5","tag":"autogenerated:gerrit:abandon","author":{"_account_id":19702,"name":"Damien RANNOU","email":"damien.rannou@corp.ovh.com","username":"DamienRANNOU","status":"OVHcloud"},"date":"2026-03-13 13:54:28.000000000","message":"Abandoned\n\nerror","accounts_in_message":[],"_revision_number":1}],"current_revision_number":1,"current_revision":"726b077c92775fdb3f4541e7c0c21e44128062af","revisions":{"726b077c92775fdb3f4541e7c0c21e44128062af":{"kind":"REWORK","_number":1,"created":"2026-03-13 13:53:42.000000000","uploader":{"_account_id":19702,"name":"Damien RANNOU","email":"damien.rannou@corp.ovh.com","username":"DamienRANNOU","status":"OVHcloud"},"ref":"refs/changes/36/980436/1","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/octavia","ref":"refs/changes/36/980436/1","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/octavia refs/changes/36/980436/1 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/octavia refs/changes/36/980436/1 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/octavia refs/changes/36/980436/1 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/octavia refs/changes/36/980436/1"}}},"commit":{"parents":[{"commit":"79cf1f787fa9c03adba8575dc94324b97963f84e","subject":"Update master for stable/2026.1","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/octavia/commit/79cf1f787fa9c03adba8575dc94324b97963f84e"}]}],"author":{"name":"Damien Rannou","email":"damien.rannou@corp.ovh.com","date":"2026-03-13 13:09:45.000000000","tz":60},"committer":{"name":"Damien Rannou","email":"damien.rannou@corp.ovh.com","date":"2026-03-13 13:23:09.000000000","tz":60},"subject":"Fix column types not resized by previous migrations","message":"Fix column types not resized by previous migrations\n\nTwo previous migrations used existing_type\u003d instead of type_\u003d in\nop.alter_column() calls. With Alembic, existing_type\u003d only declares\nthe current column type for introspection — it does not alter the\ncolumn. The type_\u003d parameter is required to actually issue an\nALTER COLUMN TYPE statement.\n\n- Migration 2351ea316465 intended to enlarge\n  listener.tls_certificate_id from String(36) to String(255),\n  but the column stayed at its original size. Barbican secret_ref\n  URLs exceed 36 characters, causing StringDataRightTruncation\n  when creating TERMINATED_HTTPS listeners.\n\n- Migration 43287cd10fef intended to enlarge algorithm.name from\n  String(30) to String(255) and pool.lb_algorithm from String(16)\n  to String(255), but both columns stayed at their original sizes.\n  LEAST_CONNECTIONS (17 chars) exceeds varchar(16), causing\n  StringDataRightTruncation on pool creation or update.\n\nThis adds a corrective migration that applies the type changes\nusing type_\u003d so they take effect on all database backends.\n\nChange-Id: I0000000000000000000000000000000000000001\nSigned-off-by: Damien Rannou \u003cdamien.rannou@corp.ovh.com\u003e\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/octavia/commit/726b077c92775fdb3f4541e7c0c21e44128062af"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/octavia/commit/726b077c92775fdb3f4541e7c0c21e44128062af"}]},"branch":"refs/heads/master"}},"requirements":[],"submit_records":[],"submit_requirements":[{"name":"Verified","description":"Verified in gate by CI","status":"UNSATISFIED","is_legacy":false,"submittability_expression_result":{"expression":"label:Verified\u003dMAX AND -label:Verified\u003dMIN","fulfilled":false,"status":"FAIL","passing_atoms":[],"failing_atoms":["label:Verified\u003dMAX","label:Verified\u003dMIN"],"atom_explanations":{}}},{"name":"Backport-Candidate","description":"Backport candidate status","status":"NOT_APPLICABLE","is_legacy":false,"applicability_expression_result":{"fulfilled":false,"status":"FAIL"},"submittability_expression_result":{"expression":"is:true","fulfilled":true,"status":"NOT_EVALUATED","passing_atoms":[],"failing_atoms":[],"atom_explanations":{}}},{"name":"Code-Review","description":"Code reviewed by core reviewer","status":"UNSATISFIED","is_legacy":false,"submittability_expression_result":{"expression":"label:Code-Review\u003dMAX AND -label:Code-Review\u003dMIN","fulfilled":false,"status":"FAIL","passing_atoms":[],"failing_atoms":["label:Code-Review\u003dMAX","label:Code-Review\u003dMIN"],"atom_explanations":{}}},{"name":"Workflow","description":"Approved for gate by core reviewer","status":"UNSATISFIED","is_legacy":false,"submittability_expression_result":{"expression":"label:Workflow\u003dMAX AND -label:Workflow\u003dMIN","fulfilled":false,"status":"FAIL","passing_atoms":[],"failing_atoms":["label:Workflow\u003dMAX","label:Workflow\u003dMIN"],"atom_explanations":{}}}]}