[qos][postgresql] neutron qos-bandwidth-limit-rule-create failed

[Dongcan Ye]

Neutron version is Liberty and db backend is PostgreSQL.

Using following command to create qos ratelimit:
$ neutron qos-policy-create bw-limiter
$ neutron qos-bandwidth-limit-rule-create bw-limiter --max-kbps 3000 \
  --max-burst-kbps 300

ERROR log in neutron server:
http://paste.openstack.org/show/508633/

[Assaf Muller (amuller)]

Assigned to Miguel for root cause analysis.

[Miguel Angel Ajo (mangelajo)]

This reminds me of something similar we saw with an specific mysql / sqlalchemy version, it's probably time to look at this more in depth.

[Miguel Angel Ajo (mangelajo)]

I think this is related to :

   https://bugs.launchpad.net/neutron/+bug/1585816

Probably the incarnation of the same bug with different backends.

[Ihar Hrachyshka (ihar-hrachyshka)]

We may want to consider switching to _get_collection in Liberty and Mitaka as in https://review.openstack.org/#/c/300055/

[Miguel Angel Ajo (mangelajo)]

I'm removing myself as assignee until I can get back into it. (probably past mid july)

[Miguel Angel Ajo (mangelajo)]

note from Ihar, verify if https://review.openstack.org/#/c/300055/ fixed it, and in such case consider backport to mitaka and libert

[Slawek Kaplonski (slaweq)]

On latest neutron from master it looks that problem is solved.
I tried:

    admin@devstack-2:/opt/stack/neutron$ neutron qos-policy-create bw-limiter
    Created a new policy:
    +-------------+--------------------------------------+
    | Field | Value |
    +-------------+--------------------------------------+
    | description | |
    | id | 92a80865-3ac2-4c56-a800-e3fbbf429d8d |
    | name | bw-limiter |
    | rules | |
    | shared | False |
    | tenant_id | e7dbd63b709d4c6285d530a15bed2a8f |
    +-------------+--------------------------------------+
    admin@devstack-2:/opt/stack/neutron$ neutron qos-bandwidth-limit-rule-create bw-limiter --max-kbps 3000 --max-burst-kbps 300
    Created a new bandwidth_limit_rule:
    +----------------+--------------------------------------+
    | Field | Value |
    +----------------+--------------------------------------+
    | id | 859bb9a8-987c-4433-977d-f4fa262481b3 |
    | max_burst_kbps | 300 |
    | max_kbps | 3000 |
    +----------------+--------------------------------------+

and result in pgsql db:

    psql (9.3.12)
    SSL connection (cipher: DHE-RSA-AES256-GCM-SHA384, bits: 256)
    Type "help" for help.

    neutron=# select * from qos_bandwidth_limit_rules;
                  id | qos_policy_id | max_kbps | max_burst_kbps
    --------------------------------------+--------------------------------------+----------+----------------
     859bb9a8-987c-4433-977d-f4fa262481b3 | 92a80865-3ac2-4c56-a800-e3fbbf429d8d | 3000 | 300
    (1 row)

I also checked on neutron with head set to commit: 5532fb71925a2473545b0f290367234b09fc7d7f (one before https://review.openstack.org/#/c/300055/ and I had error as reported by Dongcan Ye.
So this bug is fixed now.

[Ihar Hrachyshka (ihar-hrachyshka)]

Not critical for Mitaka.