+ octavia-db-manage upgrade head 2026-04-23 00:59:58.340 7 INFO alembic.runtime.migration [-] Context impl MySQLImpl. 2026-04-23 00:59:58.340 7 INFO alembic.runtime.migration [-] Will assume non-transactional DDL. 2026-04-23 00:59:58.449 7 INFO alembic.runtime.migration [-] Running upgrade -> 35dee79d5865, initial_create 2026-04-23 00:59:59.092 7 INFO alembic.runtime.migration [-] Running upgrade 35dee79d5865 -> 4c094013699a, update load balancer amphora relationship 2026-04-23 00:59:59.335 7 INFO alembic.runtime.migration [-] Running upgrade 4c094013699a -> 13500e2e978d, update url and name size 2026-04-23 00:59:59.340 7 INFO alembic.runtime.migration [-] Running upgrade 13500e2e978d -> 4faaa983e7a9, update member address column 2026-04-23 00:59:59.395 7 INFO alembic.runtime.migration [-] Running upgrade 4faaa983e7a9 -> 3a1e1cdb7b27, rename amphora host id 2026-04-23 00:59:59.448 7 INFO alembic.runtime.migration [-] Running upgrade 3a1e1cdb7b27 -> 14892634e228, update vip 2026-04-23 00:59:59.572 7 INFO alembic.runtime.migration [-] Running upgrade 14892634e228 -> 256852d5ff7c, add lb_network_ip to amphora 2026-04-23 00:59:59.622 7 INFO alembic.runtime.migration [-] Running upgrade 256852d5ff7c -> 92fe9857279, create healthmanager table 2026-04-23 00:59:59.655 7 INFO alembic.runtime.migration [-] Running upgrade 92fe9857279 -> 3e5b37a0bdb9, Add vrrp_ip and ha_ip to amphora 2026-04-23 00:59:59.767 7 INFO alembic.runtime.migration [-] Running upgrade 3e5b37a0bdb9 -> 48660b6643f0, add new states for amphora 2026-04-23 00:59:59.772 7 INFO alembic.runtime.migration [-] Running upgrade 48660b6643f0 -> 4fe8240425b4, update vip add subnet id 2026-04-23 00:59:59.795 7 INFO alembic.runtime.migration [-] Running upgrade 4fe8240425b4 -> 298eac0640a7, Add vrrp_port_id and ha_port_id to amphora 2026-04-23 00:59:59.899 7 INFO alembic.runtime.migration [-] Running upgrade 298eac0640a7 -> 357d17a6d5ac, update lb and amphora data model for active passive 2026-04-23 01:00:00.246 7 INFO alembic.runtime.migration [-] Running upgrade 357d17a6d5ac -> 2351ea316465, Adding TERMINATED_HTTPS support and TLS ref ID char length increase 2026-04-23 01:00:00.334 7 INFO alembic.runtime.migration [-] Running upgrade 2351ea316465 -> 543f5d8e4e56, Add a column busy in table amphora health 2026-04-23 01:00:00.380 7 INFO alembic.runtime.migration [-] Running upgrade 543f5d8e4e56 -> 3b199c848b96, Create NO_MONITOR operational_status 2026-04-23 01:00:00.400 7 INFO alembic.runtime.migration [-] Running upgrade 3b199c848b96 -> 5a3ee5472c31, add cert expiration info in amphora table 2026-04-23 01:00:00.526 7 INFO alembic.runtime.migration [-] Running upgrade 5a3ee5472c31 -> 1e4c1d83044c, Keepalived configuration datamodel 2026-04-23 01:00:00.868 7 INFO alembic.runtime.migration [-] Running upgrade 1e4c1d83044c -> 6abb04f24c5, Tenant id to project id 2026-04-23 01:00:01.236 7 INFO alembic.runtime.migration [-] Running upgrade 6abb04f24c5 -> 43287cd10fef, Make pool.lb_algorithm larger 2026-04-23 01:00:01.508 7 INFO alembic.runtime.migration [-] Running upgrade 43287cd10fef -> 29ff921a6eb, Shared pools 2026-04-23 01:00:01.835 7 INFO alembic.runtime.migration [-] Running upgrade 29ff921a6eb -> 458c9ee2a011, L7 Policies and Rules 2026-04-23 01:00:02.034 7 INFO alembic.runtime.migration [-] Running upgrade 458c9ee2a011 -> 186509101b9b, add_server_group_id_to_loadbalancer 2026-04-23 01:00:02.118 7 INFO alembic.runtime.migration [-] Running upgrade 186509101b9b -> 8c0851bdf6c3, change_tls_container_id_length_in_sni_table 2026-04-23 01:00:02.172 7 INFO alembic.runtime.migration [-] Running upgrade 8c0851bdf6c3 -> 9bf4d21caaea, adding Amphora ID to listener_statistics table 2026-04-23 01:00:02.427 7 INFO alembic.runtime.migration [-] Running upgrade 9bf4d21caaea -> 4d9cf7d32f2, Insert headers 2026-04-23 01:00:02.506 7 INFO alembic.runtime.migration [-] Running upgrade 4d9cf7d32f2 -> 36b94648fef8, add timestamp 2026-04-23 01:00:03.046 7 INFO alembic.runtime.migration [-] Running upgrade 36b94648fef8 -> 62816c232310, Fix migration for MySQL 5.7 2026-04-23 01:00:03.065 7 INFO alembic.runtime.migration [-] Running upgrade 62816c232310 -> 4a6ec0ab7284, Remove FK constraints on listener_statistics because it will be cross-DB 2026-04-23 01:00:03.107 7 INFO alembic.runtime.migration [-] Running upgrade 4a6ec0ab7284 -> 82b9402e71fd, Update vip address size 2026-04-23 01:00:03.110 7 INFO alembic.runtime.migration [-] Running upgrade 82b9402e71fd -> 9b5473976d6d, Add provisioning_status to objects 2026-04-23 01:00:04.337 7 INFO alembic.runtime.migration [-] Running upgrade 9b5473976d6d -> c11292016060, adding request error number to listener_statistics table 2026-04-23 01:00:04.388 7 INFO alembic.runtime.migration [-] Running upgrade c11292016060 -> 44a2414dd683, adding name column to member and health monitor 2026-04-23 01:00:04.528 7 INFO alembic.runtime.migration [-] Running upgrade 44a2414dd683 -> 3f8ff3be828e, create quotas table 2026-04-23 01:00:04.564 7 INFO alembic.runtime.migration [-] Running upgrade 3f8ff3be828e -> 443fe6676637, Add a column network_id in table vip 2026-04-23 01:00:04.630 7 INFO alembic.runtime.migration [-] Running upgrade 443fe6676637 -> fc5582da7d8a, create_amphora_build_rate_limit_tables 2026-04-23 01:00:04.704 7 INFO alembic.runtime.migration [-] Running upgrade fc5582da7d8a -> fac584114642, Add ID column to Healthmonitor table 2026-04-23 01:00:05.014 7 INFO alembic.runtime.migration [-] Running upgrade fac584114642 -> 034b2dc2f3e0, modernize_l7policy_fields 2026-04-23 01:00:06.353 7 INFO alembic.runtime.migration [-] Running upgrade 034b2dc2f3e0 -> d85ca7258d21, modernize l7rule 2026-04-23 01:00:06.703 7 INFO alembic.runtime.migration [-] Running upgrade d85ca7258d21 -> 52377704420e, add timestamps and operating_status to healthmonitor 2026-04-23 01:00:06.966 7 INFO alembic.runtime.migration [-] Running upgrade 52377704420e -> 5309960964f8, add proxy protocol for pool 2026-04-23 01:00:06.976 7 INFO alembic.runtime.migration [-] Running upgrade 5309960964f8 -> 27e54d00c3cd, add monitor address and port to member 2026-04-23 01:00:07.095 7 INFO alembic.runtime.migration [-] Running upgrade 27e54d00c3cd -> e6672bda93bf, add ping and tls-hello monitor types 2026-04-23 01:00:07.101 7 INFO alembic.runtime.migration [-] Running upgrade e6672bda93bf -> 4aeb9e23ad43, Add DRAINING operating status 2026-04-23 01:00:07.110 7 INFO alembic.runtime.migration [-] Running upgrade 4aeb9e23ad43 -> bf171d0d91c3, add cached_zone to amphora 2026-04-23 01:00:07.177 7 INFO alembic.runtime.migration [-] Running upgrade bf171d0d91c3 -> 0aee2b450512, Add QoS Policy ID column to VIP table 2026-04-23 01:00:07.226 7 INFO alembic.runtime.migration [-] Running upgrade 0aee2b450512 -> 10d38216ad34, add timestamps to amphora 2026-04-23 01:00:07.339 7 INFO alembic.runtime.migration [-] Running upgrade 10d38216ad34 -> 034756a182a2, amphora add image id 2026-04-23 01:00:07.393 7 INFO alembic.runtime.migration [-] Running upgrade 034756a182a2 -> ba35e0fb88e1, add backup field to member 2026-04-23 01:00:07.461 7 INFO alembic.runtime.migration [-] Running upgrade ba35e0fb88e1 -> 0fd2c131923f, add timeout fields to listener 2026-04-23 01:00:07.748 7 INFO alembic.runtime.migration [-] Running upgrade 0fd2c131923f -> 0f242cf02c74, Add provider column 2026-04-23 01:00:07.831 7 INFO alembic.runtime.migration [-] Running upgrade 0f242cf02c74 -> ebbcc72b4e5e, Add Octavia owned VIP column to VIP table 2026-04-23 01:00:07.911 7 INFO alembic.runtime.migration [-] Running upgrade ebbcc72b4e5e -> 76aacf2e176c, Extend some necessary fields for udp support 2026-04-23 01:00:08.107 7 INFO alembic.runtime.migration [-] Running upgrade 76aacf2e176c -> 55874a4ceed6, add l7policy action redirect prefix 2026-04-23 01:00:08.228 7 INFO alembic.runtime.migration [-] Running upgrade 55874a4ceed6 -> 80dba23a159f, tags_support 2026-04-23 01:00:08.317 7 INFO alembic.runtime.migration [-] Running upgrade 80dba23a159f -> 4f65b4f91c39, amphora add flavor id 2026-04-23 01:00:08.413 7 INFO alembic.runtime.migration [-] Running upgrade 4f65b4f91c39 -> b9c703669314, add flavor and flavor_profile table 2026-04-23 01:00:08.490 7 INFO alembic.runtime.migration [-] Running upgrade b9c703669314 -> 211982b05afc, add_flavor_id_to_lb 2026-04-23 01:00:08.554 7 INFO alembic.runtime.migration [-] Running upgrade 211982b05afc -> 11e4bb2bb8ef, Fix_IPv6_VIP 2026-04-23 01:00:08.598 7 INFO alembic.runtime.migration [-] Running upgrade 11e4bb2bb8ef -> 2ad093f6353f, Add listener client_ca_tls_certificate_id column 2026-04-23 01:00:08.691 7 INFO alembic.runtime.migration [-] Running upgrade 2ad093f6353f -> f21ae3f21adc, Add Client Auth options 2026-04-23 01:00:08.875 7 INFO alembic.runtime.migration [-] Running upgrade f21ae3f21adc -> ffad172e98c1, Add certificate revoke revocation list field 2026-04-23 01:00:08.963 7 INFO alembic.runtime.migration [-] Running upgrade ffad172e98c1 -> 1afc932f1ca2, Extend the l7rule type for support client certificate cases 2026-04-23 01:00:08.968 7 INFO alembic.runtime.migration [-] Running upgrade 1afc932f1ca2 -> a1f689aecc1d, Extend pool for support backend re-encryption 2026-04-23 01:00:09.061 7 INFO alembic.runtime.migration [-] Running upgrade a1f689aecc1d -> 74aae261694c, extend pool for backend CA and CRL 2026-04-23 01:00:09.247 7 INFO alembic.runtime.migration [-] Running upgrade 74aae261694c -> a7f187cd221f, Add tls boolean type for backend re-encryption 2026-04-23 01:00:09.334 7 INFO alembic.runtime.migration [-] Running upgrade a7f187cd221f -> 6742ca1b27c2, Add L7policy Redirect http code 2026-04-23 01:00:09.407 7 INFO alembic.runtime.migration [-] Running upgrade 6742ca1b27c2 -> 7432f1d4ea83, add l7policy action redirect prefix 2026-04-23 01:00:09.535 7 INFO alembic.runtime.migration [-] Running upgrade 7432f1d4ea83 -> 6ffc710674ef, Spares pool table 2026-04-23 01:00:09.563 7 INFO alembic.runtime.migration [-] Running upgrade 6ffc710674ef -> 46d914b2a5e5, Seed the spares_pool table 2026-04-23 01:00:09.568 7 INFO alembic.runtime.migration [-] Running upgrade 46d914b2a5e5 -> 392fb85b4419, add primary key to spares_pool 2026-04-23 01:00:09.582 7 INFO 392fb85b4419_add_primary_key_to_spares_pool_py [-] The primary key in spares_pool already exists, continuing. 2026-04-23 01:00:09.586 7 INFO alembic.runtime.migration [-] Running upgrade 392fb85b4419 -> a5762a99609a, add protocol in listener keys 2026-04-23 01:00:09.624 7 INFO alembic.runtime.migration [-] Running upgrade a5762a99609a -> da371b422669, Add CIDRs for listeners 2026-04-23 01:00:09.660 7 INFO alembic.runtime.migration [-] Running upgrade da371b422669 -> dcf88e59aae4, Add LB_ALGORITHM_SOURCE_IP_PORT 2026-04-23 01:00:09.675 7 INFO alembic.runtime.migration [-] Running upgrade dcf88e59aae4 -> e37941b010db, Add lb flavor ID constraint 2026-04-23 01:00:09.784 7 INFO alembic.runtime.migration [-] Running upgrade e37941b010db -> c761c8a71579, add availability_zone table 2026-04-23 01:00:09.872 7 INFO alembic.runtime.migration [-] Running upgrade c761c8a71579 -> 8ac4ed24df3a, add availability_zone to lb 2026-04-23 01:00:10.049 7 INFO alembic.runtime.migration [-] Running upgrade 8ac4ed24df3a -> 7c36b277bfb0, add listener ciphers column 2026-04-23 01:00:10.138 7 INFO alembic.runtime.migration [-] Running upgrade 7c36b277bfb0 -> fbd705961c3a, add pool ciphers column 2026-04-23 01:00:10.259 7 INFO alembic.runtime.migration [-] Running upgrade fbd705961c3a -> e5493ae5f9a7, add listener tls versions column 2026-04-23 01:00:10.364 7 INFO alembic.runtime.migration [-] Running upgrade e5493ae5f9a7 -> d3c8a090f3de, add pool tls versions column 2026-04-23 01:00:10.456 7 INFO alembic.runtime.migration [-] Running upgrade d3c8a090f3de -> 32e5c35b26a8, add l7policy and l7rule quota 2026-04-23 01:00:10.678 7 INFO alembic.runtime.migration [-] Running upgrade 32e5c35b26a8 -> 2ab994dd3ec2, add listener alpn protocols column 2026-04-23 01:00:10.753 7 INFO alembic.runtime.migration [-] Running upgrade 2ab994dd3ec2 -> e6ee84f0abf3, Add PROXY v2 pool protocol 2026-04-23 01:00:10.756 7 INFO alembic.runtime.migration [-] Running upgrade e6ee84f0abf3 -> 8b47b2546312, sctp support 2026-04-23 01:00:10.760 7 INFO alembic.runtime.migration [-] Running upgrade 8b47b2546312 -> be9fdc039b51, add pool alpn protocols column 2026-04-23 01:00:10.840 7 INFO alembic.runtime.migration [-] Running upgrade be9fdc039b51 -> b8bd389cbae7, update default value in l7rule table 2026-04-23 01:00:10.866 7 INFO alembic.runtime.migration [-] Running upgrade b8bd389cbae7 -> 6ac558d7fc21, Add prometheus listener protocol 2026-04-23 01:00:10.872 7 INFO alembic.runtime.migration [-] Running upgrade 6ac558d7fc21 -> 31f7653ded67, allow multiple vips per loadbalancer 2026-04-23 01:00:10.933 7 INFO alembic.runtime.migration [-] Running upgrade 31f7653ded67 -> 0995c26fc506, Add FAILOVER_STOPPED to provisioning_status table 2026-04-23 01:00:10.938 7 INFO alembic.runtime.migration [-] Running upgrade 0995c26fc506 -> 632152d2d32e, Add HTTP Strict Transport Security support 2026-04-23 01:00:11.163 7 INFO alembic.runtime.migration [-] Running upgrade 632152d2d32e -> db2a73e82626, Add vnic_type for VIP 2026-04-23 01:00:11.209 7 INFO alembic.runtime.migration [-] Running upgrade db2a73e82626 -> 3097e55493ae, add sg_id to vip table 2026-04-23 01:00:11.244 7 INFO alembic.runtime.migration [-] Running upgrade 3097e55493ae -> 8db7a6443785, Add member vnic_type 2026-04-23 01:00:11.306 7 INFO alembic.runtime.migration [-] Running upgrade 8db7a6443785 -> fabf4983846b, add_member_port_table + octavia-db-manage upgrade_persistence 2026-04-23 01:00:12.763 8 INFO alembic.runtime.migration [-] Context impl MySQLImpl. 2026-04-23 01:00:12.763 8 INFO alembic.runtime.migration [-] Will assume non-transactional DDL. 2026-04-23 01:00:12.812 8 INFO alembic.runtime.migration [-] Running upgrade -> 1cea328f0f65, initial_logbook_details_tables 2026-04-23 01:00:13.068 8 INFO alembic.runtime.migration [-] Running upgrade 1cea328f0f65 -> 1c783c0c2875, Replace exception and stacktrace with failure column 2026-04-23 01:00:13.259 8 INFO alembic.runtime.migration [-] Running upgrade 1c783c0c2875 -> 84d6e888850, Add task detail type 2026-04-23 01:00:13.309 8 INFO alembic.runtime.migration [-] Running upgrade 84d6e888850 -> 14b227d79a87 2026-04-23 01:00:13.375 8 INFO alembic.runtime.migration [-] Running upgrade 14b227d79a87 -> 589dccdf2b6e, Rename taskdetails to atomdetails 2026-04-23 01:00:13.400 8 INFO alembic.runtime.migration [-] Running upgrade 589dccdf2b6e -> 3162c0f3f8e4, Add 'revert_results' and 'revert_failure' atom detail column. 2026-04-23 01:00:13.525 8 INFO alembic.runtime.migration [-] Running upgrade 3162c0f3f8e4 -> 2ad4984f2864, Switch postgres to json native type. 2026-04-23 01:00:13.529 8 INFO alembic.runtime.migration [-] Running upgrade 2ad4984f2864 -> 0bc3e1a3c135, set_result_meduimtext_type 2026-04-23 01:00:13.589 8 INFO alembic.runtime.migration [-] Running upgrade 0bc3e1a3c135 -> 6df9422fcb43, fix flowdetails meta size 2026-04-23 01:00:13.653 8 INFO alembic.runtime.migration [-] Running upgrade 6df9422fcb43 -> 40fc8c914bd2, fix atomdetails failure size 2026-04-23 01:00:13.773 8 INFO alembic.runtime.migration [-] Running upgrade 40fc8c914bd2 -> 00af93df9d77, Add unique into all indexes