+ octavia-db-manage upgrade head
2026-04-23 17:27:26.662 7 INFO alembic.runtime.migration [-] Context impl MySQLImpl.
2026-04-23 17:27:26.662 7 INFO alembic.runtime.migration [-] Will assume non-transactional DDL.
2026-04-23 17:27:26.776 7 INFO alembic.runtime.migration [-] Running upgrade  -> 35dee79d5865, initial_create
2026-04-23 17:27:27.476 7 INFO alembic.runtime.migration [-] Running upgrade 35dee79d5865 -> 4c094013699a, update load balancer amphora relationship
2026-04-23 17:27:27.698 7 INFO alembic.runtime.migration [-] Running upgrade 4c094013699a -> 13500e2e978d, update url and name size
2026-04-23 17:27:27.702 7 INFO alembic.runtime.migration [-] Running upgrade 13500e2e978d -> 4faaa983e7a9, update member address column
2026-04-23 17:27:27.763 7 INFO alembic.runtime.migration [-] Running upgrade 4faaa983e7a9 -> 3a1e1cdb7b27, rename amphora host id
2026-04-23 17:27:27.818 7 INFO alembic.runtime.migration [-] Running upgrade 3a1e1cdb7b27 -> 14892634e228, update vip
2026-04-23 17:27:27.933 7 INFO alembic.runtime.migration [-] Running upgrade 14892634e228 -> 256852d5ff7c, add lb_network_ip to amphora
2026-04-23 17:27:27.991 7 INFO alembic.runtime.migration [-] Running upgrade 256852d5ff7c -> 92fe9857279, create healthmanager table
2026-04-23 17:27:28.023 7 INFO alembic.runtime.migration [-] Running upgrade 92fe9857279 -> 3e5b37a0bdb9, Add vrrp_ip and ha_ip to amphora
2026-04-23 17:27:28.131 7 INFO alembic.runtime.migration [-] Running upgrade 3e5b37a0bdb9 -> 48660b6643f0, add new states for amphora
2026-04-23 17:27:28.137 7 INFO alembic.runtime.migration [-] Running upgrade 48660b6643f0 -> 4fe8240425b4, update vip add subnet id
2026-04-23 17:27:28.160 7 INFO alembic.runtime.migration [-] Running upgrade 4fe8240425b4 -> 298eac0640a7, Add vrrp_port_id and ha_port_id to amphora
2026-04-23 17:27:28.303 7 INFO alembic.runtime.migration [-] Running upgrade 298eac0640a7 -> 357d17a6d5ac, update lb and amphora data model for active passive
2026-04-23 17:27:28.656 7 INFO alembic.runtime.migration [-] Running upgrade 357d17a6d5ac -> 2351ea316465, Adding TERMINATED_HTTPS support and TLS ref ID char length increase
2026-04-23 17:27:28.746 7 INFO alembic.runtime.migration [-] Running upgrade 2351ea316465 -> 543f5d8e4e56, Add a column busy in table amphora health
2026-04-23 17:27:28.798 7 INFO alembic.runtime.migration [-] Running upgrade 543f5d8e4e56 -> 3b199c848b96, Create NO_MONITOR operational_status
2026-04-23 17:27:28.817 7 INFO alembic.runtime.migration [-] Running upgrade 3b199c848b96 -> 5a3ee5472c31, add cert expiration info in amphora table
2026-04-23 17:27:28.960 7 INFO alembic.runtime.migration [-] Running upgrade 5a3ee5472c31 -> 1e4c1d83044c, Keepalived configuration datamodel
2026-04-23 17:27:29.310 7 INFO alembic.runtime.migration [-] Running upgrade 1e4c1d83044c -> 6abb04f24c5, Tenant id to project id
2026-04-23 17:27:29.764 7 INFO alembic.runtime.migration [-] Running upgrade 6abb04f24c5 -> 43287cd10fef, Make pool.lb_algorithm larger
2026-04-23 17:27:30.000 7 INFO alembic.runtime.migration [-] Running upgrade 43287cd10fef -> 29ff921a6eb, Shared pools
2026-04-23 17:27:30.327 7 INFO alembic.runtime.migration [-] Running upgrade 29ff921a6eb -> 458c9ee2a011, L7 Policies and Rules
2026-04-23 17:27:30.525 7 INFO alembic.runtime.migration [-] Running upgrade 458c9ee2a011 -> 186509101b9b, add_server_group_id_to_loadbalancer
2026-04-23 17:27:30.600 7 INFO alembic.runtime.migration [-] Running upgrade 186509101b9b -> 8c0851bdf6c3, change_tls_container_id_length_in_sni_table
2026-04-23 17:27:30.647 7 INFO alembic.runtime.migration [-] Running upgrade 8c0851bdf6c3 -> 9bf4d21caaea, adding Amphora ID to listener_statistics table
2026-04-23 17:27:30.940 7 INFO alembic.runtime.migration [-] Running upgrade 9bf4d21caaea -> 4d9cf7d32f2, Insert headers
2026-04-23 17:27:31.023 7 INFO alembic.runtime.migration [-] Running upgrade 4d9cf7d32f2 -> 36b94648fef8, add timestamp
2026-04-23 17:27:31.608 7 INFO alembic.runtime.migration [-] Running upgrade 36b94648fef8 -> 62816c232310, Fix migration for MySQL 5.7
2026-04-23 17:27:31.629 7 INFO alembic.runtime.migration [-] Running upgrade 62816c232310 -> 4a6ec0ab7284, Remove FK constraints on listener_statistics because it will be cross-DB
2026-04-23 17:27:31.723 7 INFO alembic.runtime.migration [-] Running upgrade 4a6ec0ab7284 -> 82b9402e71fd, Update vip address size
2026-04-23 17:27:31.726 7 INFO alembic.runtime.migration [-] Running upgrade 82b9402e71fd -> 9b5473976d6d, Add provisioning_status to objects
2026-04-23 17:27:32.377 7 INFO alembic.runtime.migration [-] Running upgrade 9b5473976d6d -> c11292016060, adding request error number to listener_statistics table
2026-04-23 17:27:32.433 7 INFO alembic.runtime.migration [-] Running upgrade c11292016060 -> 44a2414dd683, adding name column to member and health monitor
2026-04-23 17:27:32.551 7 INFO alembic.runtime.migration [-] Running upgrade 44a2414dd683 -> 3f8ff3be828e, create quotas table
2026-04-23 17:27:32.583 7 INFO alembic.runtime.migration [-] Running upgrade 3f8ff3be828e -> 443fe6676637, Add a column network_id in table vip
2026-04-23 17:27:32.632 7 INFO alembic.runtime.migration [-] Running upgrade 443fe6676637 -> fc5582da7d8a, create_amphora_build_rate_limit_tables
2026-04-23 17:27:32.701 7 INFO alembic.runtime.migration [-] Running upgrade fc5582da7d8a -> fac584114642, Add ID column to Healthmonitor table
2026-04-23 17:27:32.997 7 INFO alembic.runtime.migration [-] Running upgrade fac584114642 -> 034b2dc2f3e0, modernize_l7policy_fields
2026-04-23 17:27:34.491 7 INFO alembic.runtime.migration [-] Running upgrade 034b2dc2f3e0 -> d85ca7258d21, modernize l7rule
2026-04-23 17:27:34.894 7 INFO alembic.runtime.migration [-] Running upgrade d85ca7258d21 -> 52377704420e, add timestamps and operating_status to healthmonitor
2026-04-23 17:27:35.194 7 INFO alembic.runtime.migration [-] Running upgrade 52377704420e -> 5309960964f8, add proxy protocol for pool
2026-04-23 17:27:35.200 7 INFO alembic.runtime.migration [-] Running upgrade 5309960964f8 -> 27e54d00c3cd, add monitor address and port to member
2026-04-23 17:27:35.307 7 INFO alembic.runtime.migration [-] Running upgrade 27e54d00c3cd -> e6672bda93bf, add ping and tls-hello monitor types
2026-04-23 17:27:35.314 7 INFO alembic.runtime.migration [-] Running upgrade e6672bda93bf -> 4aeb9e23ad43, Add DRAINING operating status
2026-04-23 17:27:35.338 7 INFO alembic.runtime.migration [-] Running upgrade 4aeb9e23ad43 -> bf171d0d91c3, add cached_zone to amphora
2026-04-23 17:27:35.451 7 INFO alembic.runtime.migration [-] Running upgrade bf171d0d91c3 -> 0aee2b450512, Add QoS Policy ID column to VIP table
2026-04-23 17:27:35.493 7 INFO alembic.runtime.migration [-] Running upgrade 0aee2b450512 -> 10d38216ad34, add timestamps to amphora
2026-04-23 17:27:35.603 7 INFO alembic.runtime.migration [-] Running upgrade 10d38216ad34 -> 034756a182a2, amphora add image id
2026-04-23 17:27:35.658 7 INFO alembic.runtime.migration [-] Running upgrade 034756a182a2 -> ba35e0fb88e1, add backup field to member
2026-04-23 17:27:35.716 7 INFO alembic.runtime.migration [-] Running upgrade ba35e0fb88e1 -> 0fd2c131923f, add timeout fields to listener
2026-04-23 17:27:36.011 7 INFO alembic.runtime.migration [-] Running upgrade 0fd2c131923f -> 0f242cf02c74, Add provider column
2026-04-23 17:27:36.080 7 INFO alembic.runtime.migration [-] Running upgrade 0f242cf02c74 -> ebbcc72b4e5e, Add Octavia owned VIP column to VIP table
2026-04-23 17:27:36.124 7 INFO alembic.runtime.migration [-] Running upgrade ebbcc72b4e5e -> 76aacf2e176c, Extend some necessary fields for udp support
2026-04-23 17:27:36.230 7 INFO alembic.runtime.migration [-] Running upgrade 76aacf2e176c -> 55874a4ceed6, add l7policy action redirect prefix
2026-04-23 17:27:36.300 7 INFO alembic.runtime.migration [-] Running upgrade 55874a4ceed6 -> 80dba23a159f, tags_support
2026-04-23 17:27:36.344 7 INFO alembic.runtime.migration [-] Running upgrade 80dba23a159f -> 4f65b4f91c39, amphora add flavor id
2026-04-23 17:27:36.410 7 INFO alembic.runtime.migration [-] Running upgrade 4f65b4f91c39 -> b9c703669314, add flavor and flavor_profile table
2026-04-23 17:27:36.475 7 INFO alembic.runtime.migration [-] Running upgrade b9c703669314 -> 211982b05afc, add_flavor_id_to_lb
2026-04-23 17:27:36.550 7 INFO alembic.runtime.migration [-] Running upgrade 211982b05afc -> 11e4bb2bb8ef, Fix_IPv6_VIP
2026-04-23 17:27:36.604 7 INFO alembic.runtime.migration [-] Running upgrade 11e4bb2bb8ef -> 2ad093f6353f, Add listener client_ca_tls_certificate_id column
2026-04-23 17:27:36.675 7 INFO alembic.runtime.migration [-] Running upgrade 2ad093f6353f -> f21ae3f21adc, Add Client Auth options
2026-04-23 17:27:36.885 7 INFO alembic.runtime.migration [-] Running upgrade f21ae3f21adc -> ffad172e98c1, Add certificate revoke revocation list field
2026-04-23 17:27:36.961 7 INFO alembic.runtime.migration [-] Running upgrade ffad172e98c1 -> 1afc932f1ca2, Extend the l7rule type for support client certificate cases
2026-04-23 17:27:36.969 7 INFO alembic.runtime.migration [-] Running upgrade 1afc932f1ca2 -> a1f689aecc1d, Extend pool for support backend re-encryption
2026-04-23 17:27:37.051 7 INFO alembic.runtime.migration [-] Running upgrade a1f689aecc1d -> 74aae261694c, extend pool for backend CA and CRL
2026-04-23 17:27:37.234 7 INFO alembic.runtime.migration [-] Running upgrade 74aae261694c -> a7f187cd221f, Add tls boolean type for backend re-encryption
2026-04-23 17:27:37.330 7 INFO alembic.runtime.migration [-] Running upgrade a7f187cd221f -> 6742ca1b27c2, Add L7policy Redirect http code
2026-04-23 17:27:37.395 7 INFO alembic.runtime.migration [-] Running upgrade 6742ca1b27c2 -> 7432f1d4ea83, add l7policy action redirect prefix
2026-04-23 17:27:37.535 7 INFO alembic.runtime.migration [-] Running upgrade 7432f1d4ea83 -> 6ffc710674ef, Spares pool table
2026-04-23 17:27:37.563 7 INFO alembic.runtime.migration [-] Running upgrade 6ffc710674ef -> 46d914b2a5e5, Seed the spares_pool table
2026-04-23 17:27:37.568 7 INFO alembic.runtime.migration [-] Running upgrade 46d914b2a5e5 -> 392fb85b4419, add primary key to spares_pool
2026-04-23 17:27:37.596 7 INFO 392fb85b4419_add_primary_key_to_spares_pool_py [-] The primary key in spares_pool already exists, continuing.
2026-04-23 17:27:37.600 7 INFO alembic.runtime.migration [-] Running upgrade 392fb85b4419 -> a5762a99609a, add protocol in listener keys
2026-04-23 17:27:37.668 7 INFO alembic.runtime.migration [-] Running upgrade a5762a99609a -> da371b422669, Add CIDRs for listeners
2026-04-23 17:27:37.716 7 INFO alembic.runtime.migration [-] Running upgrade da371b422669 -> dcf88e59aae4, Add LB_ALGORITHM_SOURCE_IP_PORT
2026-04-23 17:27:37.726 7 INFO alembic.runtime.migration [-] Running upgrade dcf88e59aae4 -> e37941b010db, Add lb flavor ID constraint
2026-04-23 17:27:37.832 7 INFO alembic.runtime.migration [-] Running upgrade e37941b010db -> c761c8a71579, add availability_zone table
2026-04-23 17:27:37.902 7 INFO alembic.runtime.migration [-] Running upgrade c761c8a71579 -> 8ac4ed24df3a, add availability_zone to lb
2026-04-23 17:27:38.075 7 INFO alembic.runtime.migration [-] Running upgrade 8ac4ed24df3a -> 7c36b277bfb0, add listener ciphers column
2026-04-23 17:27:38.159 7 INFO alembic.runtime.migration [-] Running upgrade 7c36b277bfb0 -> fbd705961c3a, add pool ciphers column
2026-04-23 17:27:38.251 7 INFO alembic.runtime.migration [-] Running upgrade fbd705961c3a -> e5493ae5f9a7, add listener tls versions column
2026-04-23 17:27:38.330 7 INFO alembic.runtime.migration [-] Running upgrade e5493ae5f9a7 -> d3c8a090f3de, add pool tls versions column
2026-04-23 17:27:38.420 7 INFO alembic.runtime.migration [-] Running upgrade d3c8a090f3de -> 32e5c35b26a8, add l7policy and l7rule quota
2026-04-23 17:27:38.602 7 INFO alembic.runtime.migration [-] Running upgrade 32e5c35b26a8 -> 2ab994dd3ec2, add listener alpn protocols column
2026-04-23 17:27:38.705 7 INFO alembic.runtime.migration [-] Running upgrade 2ab994dd3ec2 -> e6ee84f0abf3, Add PROXY v2 pool protocol
2026-04-23 17:27:38.709 7 INFO alembic.runtime.migration [-] Running upgrade e6ee84f0abf3 -> 8b47b2546312, sctp support
2026-04-23 17:27:38.716 7 INFO alembic.runtime.migration [-] Running upgrade 8b47b2546312 -> be9fdc039b51, add pool alpn protocols column
2026-04-23 17:27:38.806 7 INFO alembic.runtime.migration [-] Running upgrade be9fdc039b51 -> b8bd389cbae7, update default value in l7rule table
2026-04-23 17:27:38.830 7 INFO alembic.runtime.migration [-] Running upgrade b8bd389cbae7 -> 6ac558d7fc21, Add prometheus listener protocol
2026-04-23 17:27:38.835 7 INFO alembic.runtime.migration [-] Running upgrade 6ac558d7fc21 -> 31f7653ded67, allow multiple vips per loadbalancer
2026-04-23 17:27:38.903 7 INFO alembic.runtime.migration [-] Running upgrade 31f7653ded67 -> 0995c26fc506, Add FAILOVER_STOPPED to provisioning_status table
2026-04-23 17:27:38.908 7 INFO alembic.runtime.migration [-] Running upgrade 0995c26fc506 -> 632152d2d32e, Add HTTP Strict Transport Security support
2026-04-23 17:27:39.173 7 INFO alembic.runtime.migration [-] Running upgrade 632152d2d32e -> db2a73e82626, Add vnic_type for VIP
2026-04-23 17:27:39.223 7 INFO alembic.runtime.migration [-] Running upgrade db2a73e82626 -> 3097e55493ae, add sg_id to vip table
2026-04-23 17:27:39.263 7 INFO alembic.runtime.migration [-] Running upgrade 3097e55493ae -> 8db7a6443785, Add member vnic_type
2026-04-23 17:27:39.336 7 INFO alembic.runtime.migration [-] Running upgrade 8db7a6443785 -> fabf4983846b, add_member_port_table
+ octavia-db-manage upgrade_persistence
2026-04-23 17:27:41.023 8 INFO alembic.runtime.migration [-] Context impl MySQLImpl.
2026-04-23 17:27:41.023 8 INFO alembic.runtime.migration [-] Will assume non-transactional DDL.
2026-04-23 17:27:41.065 8 INFO alembic.runtime.migration [-] Running upgrade  -> 1cea328f0f65, initial_logbook_details_tables
2026-04-23 17:27:41.368 8 INFO alembic.runtime.migration [-] Running upgrade 1cea328f0f65 -> 1c783c0c2875, Replace exception and stacktrace with failure column
2026-04-23 17:27:41.561 8 INFO alembic.runtime.migration [-] Running upgrade 1c783c0c2875 -> 84d6e888850, Add task detail type
2026-04-23 17:27:41.619 8 INFO alembic.runtime.migration [-] Running upgrade 84d6e888850 -> 14b227d79a87
2026-04-23 17:27:41.674 8 INFO alembic.runtime.migration [-] Running upgrade 14b227d79a87 -> 589dccdf2b6e, Rename taskdetails to atomdetails
2026-04-23 17:27:41.703 8 INFO alembic.runtime.migration [-] Running upgrade 589dccdf2b6e -> 3162c0f3f8e4, Add 'revert_results' and 'revert_failure' atom detail column.
2026-04-23 17:27:41.833 8 INFO alembic.runtime.migration [-] Running upgrade 3162c0f3f8e4 -> 2ad4984f2864, Switch postgres to json native type.
2026-04-23 17:27:41.837 8 INFO alembic.runtime.migration [-] Running upgrade 2ad4984f2864 -> 0bc3e1a3c135, set_result_meduimtext_type
2026-04-23 17:27:41.900 8 INFO alembic.runtime.migration [-] Running upgrade 0bc3e1a3c135 -> 6df9422fcb43, fix flowdetails meta size
2026-04-23 17:27:41.961 8 INFO alembic.runtime.migration [-] Running upgrade 6df9422fcb43 -> 40fc8c914bd2, fix atomdetails failure size
2026-04-23 17:27:42.083 8 INFO alembic.runtime.migration [-] Running upgrade 40fc8c914bd2 -> 00af93df9d77, Add unique into all indexes