Functional tests job in the ovn-octavia-provider is broken

[Slawek Kaplonski]

Probably because https://review.opendev.org/c/openstack/neutron/+/814009
Failure example: https://zuul.opendev.org/t/openstack/build/642360f0bd8b46699316e0063d9becd0

+ lib/databases/postgresql:configure_database_postgresql:92 : sudo -u root sudo -u postgres -i psql -c 'CREATE ROLE root WITH SUPERUSER LOGIN PASSWORD '\''openstack_citest'\'''
CREATE ROLE
++ /home/zuul/src/opendev.org/openstack/neutron/tools/configure_for_func_testing.sh:_install_databases:176 : mktemp -d
+ /home/zuul/src/opendev.org/openstack/neutron/tools/configure_for_func_testing.sh:_install_databases:176 : tmp_dir=/tmp/tmp.5EA0JIeLQG
+ /home/zuul/src/opendev.org/openstack/neutron/tools/configure_for_func_testing.sh:_install_databases:177 : trap 'rm -rf /tmp/tmp.5EA0JIeLQG' EXIT
+ /home/zuul/src/opendev.org/openstack/neutron/tools/configure_for_func_testing.sh:_install_databases:179 : cat
+ /home/zuul/src/opendev.org/openstack/neutron/tools/configure_for_func_testing.sh:_install_databases:185 : /usr/bin/mysql -u root -popenstack_citest
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1396 (HY000) at line 2: Operation CREATE USER failed for 'root'@'localhost'

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: master
Review: https://review.opendev.org/c/openstack/ovn-octavia-provider/+/819377

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.opendev.org/c/openstack/ovn-octavia-provider/+/819377
Committed: https://opendev.org/openstack/ovn-octavia-provider/commit/1ee61f955fa13ebffdb70b027b8768915e74fa57
Submitter: "Zuul (22348)"
Branch: master

commit 1ee61f955fa13ebffdb70b027b8768915e74fa57
Author: Slawek Kaplonski <email address hidden>
Date: Thu Nov 25 21:52:39 2021 +0100

    Fix functional tests job

    This patch fixes functional tests job by doing 2 things:

    * Configure correct db user in the functional tests job
      This was changed in the Neutron in commit [1] and should
      be updated also in the configure_functional_tests role in
      this repo.
    * Remove run-devstack role from run_functional_job playbook
      There is no need to run that role in the functional
      job and not running it can save few minutes in each job's run.
      The same change was done in Neutron in patch [2].

    [1] https://review.opendev.org/c/openstack/neutron/+/814009
    [2] https://review.opendev.org/c/openstack/neutron/+/816354

    Depends-On: https://review.opendev.org/c/openstack/devstack/+/819402

    Closes-bug: #1952357
    Change-Id: I0f3f93cdb361575591cd1278da74075d83611cae

[OpenStack Infra (hudson-openstack)]

This issue was fixed in the openstack/ovn-octavia-provider 2.0.0.0rc1 release candidate.