Update ‘--max-kbps’ and ‘--max-burst-kbps’ parameter to 2147483648 or greater than 2147483648 using qos-bandwidth-limit-rule-update command,Neutron server thrown an exception
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
neutron |
Fix Released
|
Low
|
QunyingRan |
Bug Description
In Mitaka,
Update ‘--max-kbps’ and ‘--max-burst-kbps’ parameter to 2147483648 or greater than 2147483648 using qos-bandwidth-
Neutron server thrown an exception "DBDataError: (pymysql.
[root@devstack218 devstack]# neutron qos-bandwidth-
Request Failed: internal server error while processing your request.
Neutron server returns request_ids: ['req-82a00cf8-
[root@devstack218 devstack]# neutron qos-bandwidth-
Request Failed: internal server error while processing your request.
Neutron server returns request_ids: ['req-52fd2986-
[root@devstack218 devstack]#
Similarly, Creating qos-bandwidth-
[root@devstack218 devstack]# neutron qos-bandwidth-
Request Failed: internal server error while processing your request.
Neutron server returns request_ids: ['req-54f916f1-
[root@devstack218 devstack]# neutron qos-bandwidth-
Request Failed: internal server error while processing your request.
Neutron server returns request_ids: ['req-72dbf5c5-
[root@devstack218 devstack]#
The detail info of Neutron-
Changed in neutron: | |
assignee: | nobody → QunyingRan (ran-qunying) |
description: | updated |
description: | updated |
tags: | added: low-hanging-fruit |
tags: | added: qos |
2147483648 is the max for a signed mysql integer. Since 2147483648 kbps is only 2 gigabit, it seems reasonable to make this unsigned and bump that up to 4294967295kbps.
CREATE TABLE `qos_bandwidth_ limit_rules` ( limit_rules_ ibfk_1` FOREIGN KEY (`qos_policy_id`) REFERENCES `qos_policies` (`id`) ON DELETE CASCADE
`id` varchar(36) NOT NULL,
`qos_policy_id` varchar(36) NOT NULL,
`max_kbps` int(11) DEFAULT NULL,
`max_burst_kbps` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `qos_policy_id` (`qos_policy_id`),
CONSTRAINT `qos_bandwidth_
) ENGINE=InnoDB DEFAULT CHARSET=utf8