Comment 1 for bug 1800466

From Don Penney:
There is a failure running neutron-db-sync:

2018-10-29T04:47:29.592 Notice: 2018-10-29 04:47:29 +0000 /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns: oslo_db.exception.DBError: (psycopg2.ProgrammingError) syntax error at or near "SELECT"
2018-10-29T04:47:29.594 Notice: 2018-10-29 04:47:29 +0000 /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns: LINE 1: CREATE TEMPORARY TABLE TEMP_SUBNETS (SELECT s.id FROM subnet...
2018-10-29T04:47:29.596 Notice: 2018-10-29 04:47:29 +0000 /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns: ^
2018-10-29T04:47:29.598 Notice: 2018-10-29 04:47:29 +0000 /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]/returns: [SQL: 'CREATE TEMPORARY TABLE TEMP_SUBNETS (SELECT s.id FROM subnets AS s LEFT OUTER JOIN ipallocations AS ia ON ia.subnet_id = s.id WHERE s.managed = false GROUP BY s.id,ia.ip_address HAVING COUNT(ia.ip_address) = 0);']
2018-10-29T04:47:29.600 Error: 2018-10-29 04:47:29 +0000 /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]: Failed to call refresh: neutron-db-manage upgrade heads returned 1 instead of one of [0]
2018-10-29T04:47:29.602 Error: 2018-10-29 04:47:29 +0000 /Stage[main]/Neutron::Db::Sync/Exec[neutron-db-sync]: neutron-db-manage upgrade heads returned 1 instead of one of [0]