<div dir="ltr">We think that the problem was 390 in nova_prod_cell0.migrate_version. Instead it should be 362.<div><br></div><div>No idea how this happened ...</div><div><br></div><div>We have manually changed that value to 362 and the db_sync worked </div><div> </div><div><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Tue, Jul 16, 2019 at 1:16 PM Massimo Sgaravatto <<a href="mailto:massimo.sgaravatto@gmail.com">massimo.sgaravatto@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div>My understanding (e.g. from #comment 1 of this bug: <a href="https://bugs.launchpad.net/grenade/+bug/1761775" target="_blank">https://bugs.launchpad.net/grenade/+bug/1761775</a>) is that --local-cell updates only the database specified as connection in [database], i.e. not also the cell0 database</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Tue, Jul 16, 2019 at 1:12 PM Eugen Block <<a href="mailto:eblock@nde.ag" target="_blank">eblock@nde.ag</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">AFAIK cell0 is the local cell, isn't it? I'm not sure, maybe someone <br>
else can shed some light on this.<br>
<br>
<br>
Zitat von Massimo Sgaravatto <<a href="mailto:massimo.sgaravatto@gmail.com" target="_blank">massimo.sgaravatto@gmail.com</a>>:<br>
<br>
> Mmm.<br>
> Doesn't "--local_cell" mean that cell0 is not updated ?<br>
> I was already using cell0 in Ocata ...<br>
><br>
> Cheers, Massimo<br>
><br>
> On Tue, Jul 16, 2019 at 12:52 PM Eugen Block <<a href="mailto:eblock@nde.ag" target="_blank">eblock@nde.ag</a>> wrote:<br>
><br>
>> Hi,<br>
>><br>
>> I think you need to run<br>
>><br>
>> nova-manage db sync --local_cell<br>
>><br>
>> in Ocata. I can't quite remember the reason, but you should try it.<br>
>> I had the same problems and this command worked out for me.<br>
>><br>
>> Regards,<br>
>> Eugen<br>
>><br>
>><br>
>><br>
>> Zitat von Massimo Sgaravatto <<a href="mailto:massimo.sgaravatto@gmail.com" target="_blank">massimo.sgaravatto@gmail.com</a>>:<br>
>><br>
>> > Resending with the right tags in the subject line ...<br>
>> ><br>
>> ><br>
>> > Hi<br>
>> ><br>
>> > We are trying to update our Ocata cloud to Pike (this is the first step:<br>
>> > we will go through Ocata --> Pike --> Queens --> Rocky) but we have a<br>
>> > problem with nova-manage db sync:<br>
>> ><br>
>> ><br>
>> > [root@cld-ctrl-01 ~]# su -s /bin/sh -c "nova-manage db sync" nova<br>
>> > ERROR: Could not access cell0.<br>
>> > Has the nova_api database been created?<br>
>> > Has the nova_cell0 database been created?<br>
>> > Has "nova-manage api_db sync" been run?<br>
>> > Has "nova-manage cell_v2 map_cell0" been run?<br>
>> > Is [api_database]/connection set in nova.conf?<br>
>> > Is the cell0 database connection URL correct?<br>
>> > Error: "Database schema file with version 390 doesn't exist."<br>
>> ><br>
>> > We have these settings in nova.conf:<br>
>> ><br>
>> > [database]<br>
>> > connection = mysql+pymysql://<a href="http://nova_prod:xyz@192.168.60.10:6306/nova_prod" rel="noreferrer" target="_blank">nova_prod:xyz@192.168.60.10:6306/nova_prod</a><br>
>> > [api_database]<br>
>> > connection = mysql+pymysql://<br>
>> > <a href="http://nova_api_prod:xyz@192.168.60.10:6306/nova_api_prod" rel="noreferrer" target="_blank">nova_api_prod:xyz@192.168.60.10:6306/nova_api_prod</a><br>
>> ><br>
>> > I can't see problems accessing the databases. i.e. these commands work:<br>
>> ><br>
>> > mysql -u nova_api_prod -pxyz -h 192.168.60.10 -P 6306 nova_api_prod<br>
>> ><br>
>> > mysql -u nova_prod -pxyz -h 192.168.60.10 -P 6306 nova_prod<br>
>> ><br>
>> > mysql -u nova_prod -pxyz -h 192.168.60.10 -P 6306 nova_prod_cell0<br>
>> ><br>
>> > If I try to rerun nova-manage cell_v2 map_cell0:<br>
>> ><br>
>> > [root@cld-ctrl-01 ~]# nova-manage cell_v2 map_cell0<br>
>> > Cell0 is already setup<br>
>> ><br>
>> ><br>
>> > [root@cld-ctrl-01 ~]# su -s /bin/sh -c "nova-manage api_db version" nova<br>
>> > 45<br>
>> ><br>
>> > [root@cld-ctrl-01 ~]# su -s /bin/sh -c "nova-manage db version" nova<br>
>> > 362<br>
>> ><br>
>> > [root@cld-ctrl-01 ~]# nova-manage cell_v2 list_cells<br>
>> ><br>
>> +-------+--------------------------------------+--------------------------------------------------+-------------------------------------------------------------------+<br>
>> > | Name | UUID |<br>
>> Transport<br>
>> > URL | Database Connection<br>
>> > |<br>
>> ><br>
>> +-------+--------------------------------------+--------------------------------------------------+-------------------------------------------------------------------+<br>
>> > | cell0 | 00000000-0000-0000-0000-000000000000 |<br>
>> > none:/// | mysql+pymysql://nova_prod:****@<br>
>> > <a href="http://192.168.60.10:6306/nova_prod_cell0" rel="noreferrer" target="_blank">192.168.60.10:6306/nova_prod_cell0</a> |<br>
>> > | cell1 | 5e42faa0-710b-4967-bb42-fcf53602c96e |<br>
>> > rabbit://openstack_prod:****@<a href="http://192.168.60.183:5672" rel="noreferrer" target="_blank">192.168.60.183:5672</a> |<br>
>> > mysql+pymysql://nova_prod:****@<a href="http://192.168.60.10:6306/nova_prod" rel="noreferrer" target="_blank">192.168.60.10:6306/nova_prod</a> |<br>
>> ><br>
>> +-------+--------------------------------------+--------------------------------------------------+-------------------------------------------------------------------+<br>
>> ><br>
>> > Following some doc we also tried to specify the --database_connection /<br>
>> > --database-connection argument, but this seems not working<br>
>> ><br>
>> ><br>
>> > Setting nova in debug mode, this is the last entry in the nova-manage log<br>
>> > file:<br>
>> ><br>
>> > 2019-07-16 12:11:42.774 22013 DEBUG migrate.versioning.repository<br>
>> > [req-8ca52407-dbe1-4a62-ad6c-16631c2a9a06 - - - - -] Config:<br>
>> > OrderedDict([('db_settings', OrderedDict([('__name__', 'db_settings'),<br>
>> > ('repository_id', 'nova'), ('version_table', 'migrate_version'),<br>
>> > ('required_dbs', '[]')]))]) __init__<br>
>> > /usr/lib/python2.7/site-packages/migrate/versioning/repository.py:83<br>
>> ><br>
>> > Any hints ?<br>
>> ><br>
>> > Thanks, Massimo<br>
>> > <br>
>> > <br>
>> > OpenStack Discuss<br>
>><br>
>><br>
>><br>
>><br>
>><br>
<br>
<br>
<br>
</blockquote></div>
</blockquote></div>