Open Stack

On 30 March 2017 at 08:08, Saverio Proto <saverio.proto at switch.ch> wrote:

> Hello,
>
> I am testing the neutron l2gw in our staging env.
>
> Because I cant redeploy everything, to retry the installation of the
> l2gw, to clean the database I drop the following tables from the neutron
> database:
>
> drop table physical_ports;
> drop table physical_locators;
> drop table physical_switches;
> drop table logical_switches;
> drop table ucast_macs_remotes;
> drop table ucast_macs_locals;
> drop table vlan_bindings;
> drop table pending_ucast_macs_remotes;
> drop table l2gatewayinterfaces;
> drop table l2gatewaydevices;
> drop table l2gatewayconnections;
> drop table l2gateways;
> drop table l2gw_alembic_version;
>
> I would strongly suggest to have a common prefix like l2gw_ for all the
> tables that belong to the same neutron plugin.
>
> How can I figure out if I missed a table without reading all the code ?
>

There's no written rule to prefix tables with formal labels. IMO it would
largely fail as a rule in practice even if we wrote one down. Have you
considered taking a backup of your DB prior to the migration so that you
can restore from it?

Thanks,
Armando


> Thank you
>
> Saverio
>
>
>
> --
> SWITCH
> Saverio Proto, Peta Solutions
> Werdstrasse 2, P.O. Box, 8021 Zurich, Switzerland
> phone +41 44 268 15 15, direct +41 44 268 1573
> saverio.proto at switch.ch, http://www.switch.ch
>
> http://www.switch.ch/stories
>
> __________________________________________________________________________
> OpenStack Development Mailing List (not for usage questions)
> Unsubscribe: OpenStack-dev-request at lists.openstack.org?subject:unsubscribe
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack-dev/attachments/20170330/88876b77/attachment.html>