Comment 0 for bug 1630732

Revision history for this message
Matthew Thode (prometheanfire) wrote :

I have a deleted service (nova-network) that is preventing online_data_migrations from running.

    # nova-manage db online_data_migrations
    Running batches of 50 until complete
    2016-10-05 14:11:00.578 2197 ERROR nova.db.sqlalchemy.api [req-60487805-6488-428e-b364-8eb6a1b620aa - - - - -] Data migrations for PciDevice are not safe, likely because not all services that access the DB directly are updated to the latest version

    # select * from services;
             created_at | updated_at | deleted_at | id | host | binary | topic | report_count | disabled | deleted | disabled_reason | last_seen_up | forced_down | version
----------------------------+----------------------------+----------------------------+-- --+-----------------------------+--------------------+-------------+--------------+----------+---------+-----------------+----------------------------+-------------+---------
     2016-03-28 21:54:50.624939 | 2016-10-05 05:04:27.88604 | | 8 | 127.0.0.1 | nova-osapi_compute | | 0 | f | 0 | | | f | 15
     2014-04-01 02:25:19.568992 | 2016-10-05 19:10:36.775756 | | 1 | master.openstack.mthode.org | nova-scheduler | scheduler | 6508816 | f | 0 | | 2016-10-05 19:10:36.775144 | f | 15
     2014-09-22 22:48:42.410217 | 2016-10-05 19:10:38.957666 | | 5 | master.openstack.mthode.org | nova-cert | cert | 5880779 | f | 0 | | 2016-10-05 19:10:38.957042 | f | 15
     2014-04-01 03:24:01.305666 | 2014-04-08 16:17:50.835133 | 2015-08-03 06:30:12.744504 | 4 | master.openstack.mthode.org | nova-network | network | 65072 | f | 4 | | | f | 0
     2016-03-28 21:54:51.04119 | 2016-10-05 05:06:33.459861 | | 9 | 127.0.0.1 | nova-metadata | | 0 | f | 0 | | | f | 15
     2014-04-01 02:54:42.114856 | 2016-10-05 19:10:43.925853 | | 3 | master.openstack.mthode.org | nova-conductor | conductor | 6515405 | f | 0 | | 2016-10-05 19:10:43.924894 | f | 15
     2014-04-01 02:54:22.058152 | 2016-10-05 19:10:35.282541 | | 2 | master.openstack.mthode.org | nova-consoleauth | consoleauth | 6513588 | f | 0 | | 2016-10-05 19:10:35.281509 | f | 15
 2014-09-23 02:52:56.806792 | 2016-10-05 19:10:44.616719 | | 6 | node03.openstack.mthode.org | nova-compute | compute | 5329359 | f | 0 | | 2016-10-05 19:10:15.192567 | f | 15
     2015-08-03 06:26:13.39909 | 2016-10-05 19:10:41.220255 | | 7 | node02.openstack.mthode.org | nova-compute | compute | 2815464 | f | 0 | | 2016-10-05 19:10:41.219626 | f | 15