Description:-
Sc10 / sc10-kvm / Sc010-ovn-provider failing with "(pymysql.err.ProgrammingError) (1146, \"Table 'octavia.quotas' doesn't exist\"
https://logserver.rdoproject.org/openstack-periodic-integration-main/opendev.org/openstack/tripleo-ci/master/periodic-tripleo-ci-centos-8-scenario010-ovn-provider-standalone-master/0a2a19e/logs/undercloud/var/log/tempest/tempest_run.log.txt.gz
~~~
Details: b'{"faultcode": "Server", "faultstring": "(pymysql.err.ProgrammingError) (1146, \\"Table \'octavia.quotas\' doesn\'t exist\\")\\n[SQL: SELECT quotas.project_id AS quotas_project_id, quotas.health_monitor AS quotas_health_monitor, quotas.listener AS quotas_listener, quotas.load_balancer AS quotas_load_balancer, quotas.`member` AS quotas_member, quotas.pool AS quotas_pool, quotas.l7policy AS quotas_l7policy, quotas.l7rule AS quotas_l7rule, quotas.in_use_health_monitor AS quotas_in_use_health_monitor, quotas.in_use_listener AS quotas_in_use_listener, quotas.in_use_load_balancer AS quotas_in_use_load_balancer, quotas.in_use_member AS quotas_in_use_member, quotas.in_use_pool AS quotas_in_use_pool, quotas.in_use_l7policy AS quotas_in_use_l7policy, quotas.in_use_l7rule AS quotas_in_use_l7rule \\nFROM quotas \\nWHERE quotas.project_id = %(project_id_1)s \\n LIMIT %(param_1)s]\\n[parameters: {\'project_id_1\': \'4f50a37c9d2c4b7eac4bf9b469535ce5\', \'param_1\': 1}]\\n(Background on this error at: http://sqlalche.me/e/13/f405)", "debuginfo": null}'
~~~
https://logserver.rdoproject.org/openstack-periodic-integration-main/opendev.org/openstack/tripleo-ci/master/periodic-tripleo-ci-centos-8-scenario010-standalone-master/2baa3e1/logs/undercloud/var/log/tempest/stestr_results.html.gz
https://logserver.rdoproject.org/openstack-periodic-integration-main/opendev.org/openstack/tripleo-ci/master/periodic-tripleo-ci-centos-8-scenario010-standalone-master/2baa3e1/logs/undercloud/var/log/tempest/stestr_results.html.gz
Last good run on 07th June:-
https://review.rdoproject.org/zuul/builds?job_name=periodic-tripleo-ci-centos-8-scenario010-standalone-master
I think this was caused by a typo in a recent patch that broke the db_sync for octavia.
See patch https:/ /review. opendev. org/c/openstack /tripleo- heat-templates/ +/795590