Reviewed: https://review.opendev.org/715011 Committed: https://git.openstack.org/cgit/openstack/neutron/commit/?id=79e8230e39c5ba30ace3afe3d9f1cc15463ea9ad Submitter: Zuul Branch: master
commit 79e8230e39c5ba30ace3afe3d9f1cc15463ea9ad Author: Rodolfo Alonso Hernandez <ralon...@redhat.com> Date: Wed Mar 25 17:35:15 2020 +0000 Filter subnet by segment ID or None In "_query_filter_by_fixed_ips_segment", the subnet query should be filtered by segment ID if exists, or None otherwise. The "segment_id" field (from the "subnet" DB register) is a string. As reported in the related bug, PostgreSQL does not accept to compare this field with a boolean value ("false"). This patch avoids the previous situation where the DB WHERE statement was trying to compare a string and a boolean: operator does not exist: character varying = boolean LINE 5: WHERE anon_1.subnets_segment_id = false No operator matches the given name and argument type(s). You might \ need to add explicit type casts. Change-Id: I1ff29eb45c6663885c2b8a126a3669e75b920c98 Closes-Bug: #1869034 ** Changed in: neutron Status: In Progress => Fix Released -- You received this bug notification because you are a member of Yahoo! Engineering Team, which is subscribed to neutron. https://bugs.launchpad.net/bugs/1869034 Title: Postgresql periodic job failing every day Status in neutron: Fix Released Bug description: Periodic job "neutron-tempest-postgres-full" is failing every day since 18.03.2020. Always same tests are red: tempest.api.network.test_networks.NetworksIpV6TestAttrs.test_create_delete_slaac_subnet_with_ports tempest.api.network.test_networks.NetworksIpV6TestAttrs.test_create_delete_stateless_subnet_with_ports Errors like https://storage.bhs.cloud.ovh.net/v1/AUTH_dcaab5e32b234d56b626f72581e3644c/zuul_opendev_logs_95c/periodic/opendev.org/openstack/neutron/master /neutron-tempest-postgres-full/95cb0e8/testr_results.html It may be that https://review.opendev.org/#/c/709444/ is culprit of that issue but we need to verify that. To manage notifications about this bug go to: https://bugs.launchpad.net/neutron/+bug/1869034/+subscriptions -- Mailing list: https://launchpad.net/~yahoo-eng-team Post to : yahoo-eng-team@lists.launchpad.net Unsubscribe : https://launchpad.net/~yahoo-eng-team More help : https://help.launchpad.net/ListHelp