Description of problem:

While deploying a heat stack with 100 instances customer is having the following DB errors:

2020-05-05 20:46:18.078 34 DEBUG neutron_lib.callbacks.manager [req-04adbcdf-73c3-4b37-a6b2-6a7b8ab53404 b8c34ca587fa41b2856d27dc50ce7517 163da8abd54245e4b1f9ecafc31bc20c - default default] Notify callbacks ['neutron.notifiers.nova.Notifier._send_nova_notification-1721'] for port, before_response _notify_loop /usr/lib/python2.7/site-packages/neutron_lib/callbacks/manager.py:167
2020-05-05 20:46:18.292 34 ERROR oslo_db.sqlalchemy.exc_filters [req-04adbcdf-73c3-4b37-a6b2-6a7b8ab53404 b8c34ca587fa41b2856d27dc50ce7517 163da8abd54245e4b1f9ecafc31bc20c - default default] DBAPIError exception wrapped from (pymysql.err.InternalError) (1305, u'SAVEPOINT sa_savepoint_10 does not exist') [SQL: u'ROLLBACK TO SAVEPOINT sa_savepoint_10'] (Background on this error at: http://sqlalche.me/e/2j85): InternalError: (1305, u'SAVEPOINT sa_savepoint_10 does not exist')
2020-05-05 20:46:18.301 34 ERROR oslo_db.sqlalchemy.exc_filters [req-04adbcdf-73c3-4b37-a6b2-6a7b8ab53404 b8c34ca587fa41b2856d27dc50ce7517 163da8abd54245e4b1f9ecafc31bc20c - default default] DBAPIError exception wrapped from (pymysql.err.InternalError) (1305, u'SAVEPOINT sa_savepoint_9 does not exist') [SQL: u'ROLLBACK TO SAVEPOINT sa_savepoint_9'] (Background on this error at: http://sqlalche.me/e/2j85): InternalError: (1305, u'SAVEPOINT sa_savepoint_9 does not exist')
2020-05-05 20:46:18.314 34 ERROR oslo_db.sqlalchemy.exc_filters [req-04adbcdf-73c3-4b37-a6b2-6a7b8ab53404 b8c34ca587fa41b2856d27dc50ce7517 163da8abd54245e4b1f9ecafc31bc20c - default default] DBAPIError exception wrapped from (pymysql.err.InternalError) (1305, u'SAVEPOINT sa_savepoint_8 does not exist') [SQL: u'ROLLBACK TO SAVEPOINT sa_savepoint_8'] (Background on this error at: http://sqlalche.me/e/2j85): InternalError: (1305, u'SAVEPOINT sa_savepoint_8 does not exist')
2020-05-05 20:46:18.318 34 ERROR oslo_middleware.catch_errors [req-04adbcdf-73c3-4b37-a6b2-6a7b8ab53404 b8c34ca587fa41b2856d27dc50ce7517 163da8abd54245e4b1f9ecafc31bc20c - default default] An error occurred during processing the request: POST /v2.0/ports HTTP/1.0
2020-05-05 20:46:18.332 34 INFO neutron.wsgi [req-04adbcdf-73c3-4b37-a6b2-6a7b8ab53404 b8c34ca587fa41b2856d27dc50ce7517 163da8abd54245e4b1f9ecafc31bc20c - default default] 10.X.X.16 "POST /v2.0/ports HTTP/1.1" status: 500  len: 380 time: 3.6189361


and port fails to create:

| smrXXXX_definition_vm_XXXXX_port |                                      | OS::Neutron::Port        | CREATE_FAILED   | 2020-05-05T19:46:11Z | XXXX_smrXXXXX_39d27718-4c43-4e4f-9880-XXXX-smrs-h5zqxqfsngif-1-lfpjaujnipia |


Around the same date time there are alot ofd these error:

2020-05-05 20:46:05.312 31 ERROR nova.scheduler.utils [req-a6b8ca7a-f0b8-4560-9a50-e672b5942ad2 90ef9d21a06340a698461f082077875d 54e93c4ae4474fc3aef5e7cf94a0b667 - default default] [instance: 98f74faa-59ae-43c0-adb2-42c010b20a4d] Error from last host: XXX-compute-std-0.localdomain (node XXXX-compute-std-0.localdomain): [u'Traceback (most recent call last):\n', u'  File "/usr/lib/python2.7/site-packages/nova/compute/manager.py", line 1858, in _do_build_and_run_instance\n    filter_properties, request_spec)\n', u'  File "/usr/lib/python2.7/site-packages/nova/compute/manager.py", line 2142, in _build_and_run_instance\n    instance_uuid=instance.uuid, reason=six.text_type(e))\n', u'RescheduledException: Build of instance 98f74faa-59ae-43c0-adb2-42c010b20a4d was re-scheduled: Build of instance 98f74faa-59ae-43c0-adb2-42c010b20a4d was re-scheduled: Anti-affinity instance group policy was violated.\n']




Version-Release number of selected component (if applicable):
OSP13 z8

How reproducible:
always

Steps to Reproduce:
1. Deploy a heat aplication using recently installed Z8
2.
3.

Actual results:
Mentioned errors

Expected results:
Deploy successful