Skip to content

Change network_rate type to unsigned int from unsigned smallint - to allow network rate > 65Gbps #13355

@Pearl1594

Description

@Pearl1594

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

  1. 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

Metadata

Metadata

Assignees

No one assigned

    Type

    No fields configured for Task.

    Projects

    No projects

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions