Re: [openstack-dev] [neutron] Plethora of dbase migration questions...

Hi, Paul! This messages is OK. May be you can put a change on review in WIP status, that I will be able to check what is going on? I never have such problems with migrations in neutron-vpnaas repo. May be the problem is that database is already upgraded, was database cleaned before you run neutron

Re: [openstack-dev] [neutron] Plethora of dbase migration questions...

Well, I can run the upgrade command, but it doesn't seem to be processing my new migration file. I have tried using upgrade with 'head', and with the HEAD file set to the previous version and to the new version. In both cases, I get these info messages twice: "Context impl MySWLImpl." and "Will ass

Re: [openstack-dev] [neutron] Plethora of dbase migration questions...

I found the issue. The upgrade is looking for config to have [database] section and connection definition. If I use /etc/neutron/neutron.conf, then the neutron-db-manage runs. On Tue, Jul 7, 2015 at 3:38 PM Paul Michali wrote: > I have that change in the neutron repo that is being used with by

Re: [openstack-dev] [neutron] Plethora of dbase migration questions...

I have that change in the neutron repo that is being used with by this neutron-vpnaas repo. On Tue, Jul 7, 2015 at 3:12 PM Mike Bayer wrote: > > > On 7/7/15 1:28 PM, Paul Michali wrote: > > HEAD, head, 24f28869838b (my new file) all say the same thing. :( > > > On Tue, Jul 7, 2015 at 12:34 PM S

Re: [openstack-dev] [neutron] Plethora of dbase migration questions...

On 7/7/15 1:28 PM, Paul Michali wrote: HEAD, head, 24f28869838b (my new file) all say the same thing. :( On Tue, Jul 7, 2015 at 12:34 PM Salvatore Orlando > wrote: possibly I was wrong in mixing up git & alembic. It should be "upgrade head" - lowercase.

Re: [openstack-dev] [neutron] Plethora of dbase migration questions...

HEAD, head, 24f28869838b (my new file) all say the same thing. :( On Tue, Jul 7, 2015 at 12:34 PM Salvatore Orlando wrote: > possibly I was wrong in mixing up git & alembic. > It should be "upgrade head" - lowercase. > > If that doesn't work there might some other issue lurking. > > Salvatore >

Re: [openstack-dev] [neutron] Plethora of dbase migration questions...

possibly I was wrong in mixing up git & alembic. It should be "upgrade head" - lowercase. If that doesn't work there might some other issue lurking. Salvatore On 7 July 2015 at 17:44, Paul Michali wrote: > Salvatore, > > I changed head to the version before my new one, and then tried to upgrad

Re: [openstack-dev] [neutron] Plethora of dbase migration questions...

Salvatore, I changed head to the version before my new one, and then tried to upgrade and I see this: neutron-db-manage --config-file /opt/stack/neutron/etc/neutron.conf --service vpnaas upgrade HEAD Traceback (most recent call last): File "/usr/local/bin/neutron-db-manage", line 10, in sy

Re: [openstack-dev] [neutron] Plethora of dbase migration questions...

Yes, I wasn't using the --service option, so I suspect that is why my down_version was wrong. In talking with Akihiro, I added a check to PEP8 and made sure that it fails if head is wrong. It is: https://review.openstack.org/#/c/199082/ (of course that failed py27 - I've got to see if there was so

Re: [openstack-dev] [neutron] Plethora of dbase migration questions...

2015-07-07 21:39 GMT+09:00 Henry Gessau : > On Tue, Jul 07, 2015, Paul Michali > wrote: > > Thanks Salvatore for the responses. See @PCM in-line... > > > > On Tue, Jul 7, 2015 at 6:14 AM Salvatore Orlando > wrote: > >> Some comments inline. >> >> Salvatore >> >>On 6 July 2015 at 20:00, P

Re: [openstack-dev] [neutron] Plethora of dbase migration questions...

On Tue, Jul 07, 2015, Salvatore Orlando wrote: > > > On 7 July 2015 at 14:00, Paul Michali > wrote: > > Thanks Salvatore for the responses. See @PCM in-line... > > > > On Tue, Jul 7, 2015 at 6:14 AM Salvatore Orlando > wrote: > >

Re: [openstack-dev] [neutron] Plethora of dbase migration questions...

On Tue, Jul 07, 2015, Paul Michali wrote: > Thanks Salvatore for the responses. See @PCM in-line... > > > > On Tue, Jul 7, 2015 at 6:14 AM Salvatore Orlando > wrote: > > Some comments inline. > > Salvatore > > On 6 July 2015 at 20:00, Paul Michali

Re: [openstack-dev] [neutron] Plethora of dbase migration questions...

On 7 July 2015 at 14:00, Paul Michali wrote: > Thanks Salvatore for the responses. See @PCM in-line... > > > > On Tue, Jul 7, 2015 at 6:14 AM Salvatore Orlando > wrote: > >> Some comments inline. >> >> Salvatore >> >> On 6 July 2015 at 20:00, Paul Michali wrote: >> >>> Hi, >>> >>> I have some u

Re: [openstack-dev] [neutron] Plethora of dbase migration questions...

And for the query, it involves several table references (Router, Port, IPAllocation). On Tue, Jul 7, 2015 at 8:00 AM Paul Michali wrote: > Thanks Salvatore for the responses. See @PCM in-line... > > > > On Tue, Jul 7, 2015 at 6:14 AM Salvatore Orlando > wrote: > >> Some comments inline. >> >>

Re: [openstack-dev] [neutron] Plethora of dbase migration questions...

Thanks Salvatore for the responses. See @PCM in-line... On Tue, Jul 7, 2015 at 6:14 AM Salvatore Orlando wrote: > Some comments inline. > > Salvatore > > On 6 July 2015 at 20:00, Paul Michali wrote: > >> Hi, >> >> I have some urgent requests about migration that I'm hoping to get some >> info

Re: [openstack-dev] [neutron] Plethora of dbase migration questions...

Some comments inline. Salvatore On 6 July 2015 at 20:00, Paul Michali wrote: > Hi, > > I have some urgent requests about migration that I'm hoping to get some > info on. I'm working on a bug where I need to add two (related) fields to a > table for VPNaaS. Here's the objectives related to migra

[openstack-dev] [neutron] Plethora of dbase migration questions...

Hi, I have some urgent requests about migration that I'm hoping to get some info on. I'm working on a bug where I need to add two (related) fields to a table for VPNaaS. Here's the objectives related to migration... 1) create local_v4_ip and lcoal_v6_ip fields in the vpnservice table 2) for each