Repository navigation
Change network_rate type to unsigned int from unsigned smallint - to allow network rate > 65Gbps #13355
Description
problem
Currently because of the network rate type defined in the DB, the max network rate that can be set on a network offering is 65Gbps. Changing the type to unsigned int will remove that limitation
versions
All versions
The steps to reproduce the bug
- Create a network offering with a network rate set to 100000 (100Gbps) - it fails with:
2026-06-05 12:45:32,022 ERROR [c.c.o.d.NetworkOfferingDaoImpl] (qtp2038105753-22:[ctx-6dc6a8d0, ctx-675c2030]) (logid:8dbb168d) DB Exception on: HikariProxyPreparedStatement@165179441 wrapping com.mysql.cj.jdbc.ServerPreparedStatement[284]: INSERT INTO network_offerings (network_offerings.name, network_offerings.unique_name, network_offerings.display_text, network_offerings.nw_rate, network_offerings.mc_rate, network_offerings.traffic_type, network_offerings.specify_vlan, network_offerings.system_only, network_offerings.service_offering_id, network_offerings.tags, network_offerings.default, network_offerings.availability, network_offerings.state, network_offerings.created, network_offerings.guest_type, network_offerings.dedicated_lb_service, network_offerings.shared_source_nat_service, network_offerings.specify_ip_ranges, network_offerings.sort_key, network_offerings.uuid, network_offerings.redundant_router_service, network_offerings.conserve_mode, network_offerings.elastic_ip_service, network_offerings.eip_associate_public_ip, network_offerings.elastic_lb_service, network_offerings.inline, network_offerings.is_persistent, network_offerings.for_vpc, network_offerings.for_tungsten, network_offerings.for_nsx, network_offerings.network_mode, network_offerings.egress_default_policy, network_offerings.concurrent_connections, network_offerings.keep_alive_enabled, network_offerings.supports_streched_l2, network_offerings.supports_public_access, network_offerings.supports_vm_autoscaling, network_offerings.internal_lb, network_offerings.public_lb, network_offerings.service_package_id, network_offerings.routing_mode, network_offerings.specify_as_number) VALUES (x'7465737431', x'7465737431', x'7465737431', 100000, 10, 'Guest', 1, 0, 5, NULL, 0, 'Optional', 'Enabled', '2026-06-05 12:45:32', 'Isolated', 0, 0, 0, 0, x'39636261663263312d393265372d343030662d613131312d646334323638366636376434', 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 1, NULL, 0, 0, 0, 0, 0, 0, NULL, NULL, 0) com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Out of range value for column 'nw_rate' at row 1
What to do about it?
No response
Activity