Skip to content

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

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

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Type

    Projects

    No projects

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions