[Bug 1809307] Re: unable to migrate database due missing script

[Corey Bryant]

Verified successfully:

root at b1:~# apt install placement-common
...
root at b1:~# ls /usr/share/placement/
mysql-migrate-db.sh  postgresql-migrate-db.sh
root at b1:~# /usr/share/placement/mysql-migrate-db.sh                                                                                                                                                        
ERROR: Specify an RC file on the command line or create migrate-db.rc in the current directory

Usage: mysql-migrate-db.sh [flags] [rcfile]

Flags:
    --help: this text
    --migrate: actually do data migration
    --mkconfig: write/update config to $rcfile

Pass '-' as $rcfile if all config values are set in
the environment.

Exit codes:
    0: Success
    1: Usage error
    2: Configuration missing or incomplete
    3: Migration already completed
    4: No data to migrate from nova (new deployment)
    5: Unable to connect to one or both databases
root at b1:~# /usr/share/placement/postgresql-migrate-db.sh
Specify an RC file on the command line or create migrate-db.rc in the current directory
root at b1:~# apt policy placement-common
placement-common:
  Installed: 0.0.1~git2018112616.3ccbacfc-0ubuntu2~cloud0
  Candidate: 0.0.1~git2018112616.3ccbacfc-0ubuntu2~cloud0
  Version table:
 *** 0.0.1~git2018112616.3ccbacfc-0ubuntu2~cloud0 500
        500 http://ubuntu-cloud.archive.canonical.com/ubuntu bionic-proposed/stein/main amd64 Packages
        100 /var/lib/dpkg/status

-- 
You received this bug notification because you are a member of Ubuntu
OpenStack, which is subscribed to Ubuntu Cloud Archive.
https://bugs.launchpad.net/bugs/1809307

Title:
  unable to migrate database due missing script

Status in Ubuntu Cloud Archive:
  Fix Committed
Status in placement package in Ubuntu:
  Fix Committed

Bug description:
  Hi,

  I'm working on the upgrades from rocky to stein in kolla. In this release we will need to migrate placement database tables from nova_api to placement database.
  The placement team has written a few scripts to do such data migration.
  Is residing at tools/ directory within the placement source package.

  Could you add such scripts in the package to allow package consumers
  to migrate the tables?

  https://github.com/openstack/placement/tree/master/tools
  https://github.com/openstack/placement/blob/master/tools/mysql-migrate-db.sh

  Regards

To manage notifications about this bug go to:
https://bugs.launchpad.net/cloud-archive/+bug/1809307/+subscriptions