Comment 9 for bug 1856296

Reviewed: https://review.opendev.org/698957
Committed: https://git.openstack.org/cgit/openstack/kolla-ansible/commit/?id=4b21e938079589653437c6f857e4d400acd326e6
Submitter: Zuul
Branch: stable/train

commit 4b21e938079589653437c6f857e4d400acd326e6
Author: Radosław Piliszek <email address hidden>
Date: Fri Dec 13 17:38:03 2019 +0100

    Fix upgrades from older (<=10.1) MariaDB releases

    Due to old row format pre-upgrade some current migrations
    may fail to apply.
    In Train this affects only Ubuntu.
    This patch runs a script to change all row formats to DYNAMIC
    which is the default in recent MariaDB releases.

    This patch incorporates the following change to pass CI:

    CI: Set zuul's ansible_python_interpreter to python2

    Train, Stein & Rocky only

    Zuul seems to have started setting ansible_python_interpreter to python3
    on Ubuntu, which breaks our installation of kolla-ansible on Train and
    earlier stable branches.

    This change sets ansible_python_interpreter explicitly to python2. We
    use host-vars rather than vars because zuul sets a host-var for
    ansible_python_interpreter=auto, which overrides vars.

    I9ba0d16972b31a64617461461fafaf2b436e2bdf by Mark Goddard

    Change-Id: I3b39ec8d733b52a13cbc22b6f426b000584bab9d
    Closes-bug: #1856296