[Bug 2090992] Re: [SRU] alembic database migrations missing from package

[James Page]

** Description changed:

+ [Impact]
+ DB schema is missing, extension driver is not functional.
+ 
+ [Test Case]
+ sudo apt install mysql-server neutron-server python3-neutron-dynamic-routing
+ sudo mysql -u root << EOF
+ CREATE DATABASE neutron;
+ CREATE USER 'neutron'@'localhost' IDENTIFIED BY 'changeme';
+ CREATE USER 'neutron'@'%'         IDENTIFIED BY 'changeme';
+ GRANT ALL PRIVILEGES ON neutron.* TO 'neutron'@'localhost';
+ GRANT ALL PRIVILEGES ON neutron.* TO 'neutron'@'%';
+ EOF
+ sudo sed -i -e 's!connection = sqlite.*!connection = mysql+pymysql://neutron:changeme@localhost/neutron!g' /etc/neutron/neutron.conf
+ sudo neutron-db-manage upgrade head
+ sudo service neutron-server restart
+ 
+ 
+ [Original Bug Report]
  This package is not shipping alembic database migrations

** Description changed:

  [Impact]
  DB schema is missing, extension driver is not functional.
  
  [Test Case]
  sudo apt install mysql-server neutron-server python3-neutron-dynamic-routing
  sudo mysql -u root << EOF
  CREATE DATABASE neutron;
  CREATE USER 'neutron'@'localhost' IDENTIFIED BY 'changeme';
  CREATE USER 'neutron'@'%'         IDENTIFIED BY 'changeme';
  GRANT ALL PRIVILEGES ON neutron.* TO 'neutron'@'localhost';
  GRANT ALL PRIVILEGES ON neutron.* TO 'neutron'@'%';
  EOF
  sudo sed -i -e 's!connection = sqlite.*!connection = mysql+pymysql://neutron:changeme@localhost/neutron!g' /etc/neutron/neutron.conf
  sudo neutron-db-manage upgrade head
- sudo service neutron-server restart
+ 
+ No DB migrations will be applied for neutron-dynamic-routing:
+ 
  
  
  [Original Bug Report]
  This package is not shipping alembic database migrations

** Description changed:

  [Impact]
  DB schema is missing, extension driver is not functional.
  
  [Test Case]
  sudo apt install mysql-server neutron-server python3-neutron-dynamic-routing
  sudo mysql -u root << EOF
  CREATE DATABASE neutron;
  CREATE USER 'neutron'@'localhost' IDENTIFIED BY 'changeme';
  CREATE USER 'neutron'@'%'         IDENTIFIED BY 'changeme';
  GRANT ALL PRIVILEGES ON neutron.* TO 'neutron'@'localhost';
  GRANT ALL PRIVILEGES ON neutron.* TO 'neutron'@'%';
  EOF
  sudo sed -i -e 's!connection = sqlite.*!connection = mysql+pymysql://neutron:changeme@localhost/neutron!g' /etc/neutron/neutron.conf
  sudo neutron-db-manage upgrade head
  
  No DB migrations will be applied for neutron-dynamic-routing:
  
+   Running upgrade for neutron-dynamic-routing ...
+ INFO  [alembic.runtime.migration] Context impl MySQLImpl.
+ INFO  [alembic.runtime.migration] Will assume non-transactional DDL.
+   OK
  
+ this should look like:
  
  [Original Bug Report]
  This package is not shipping alembic database migrations

** Description changed:

  [Impact]
  DB schema is missing, extension driver is not functional.
  
  [Test Case]
  sudo apt install mysql-server neutron-server python3-neutron-dynamic-routing
  sudo mysql -u root << EOF
  CREATE DATABASE neutron;
  CREATE USER 'neutron'@'localhost' IDENTIFIED BY 'changeme';
  CREATE USER 'neutron'@'%'         IDENTIFIED BY 'changeme';
  GRANT ALL PRIVILEGES ON neutron.* TO 'neutron'@'localhost';
  GRANT ALL PRIVILEGES ON neutron.* TO 'neutron'@'%';
  EOF
  sudo sed -i -e 's!connection = sqlite.*!connection = mysql+pymysql://neutron:changeme@localhost/neutron!g' /etc/neutron/neutron.conf
  sudo neutron-db-manage upgrade head
  
  No DB migrations will be applied for neutron-dynamic-routing:
  
-   Running upgrade for neutron-dynamic-routing ...
+   Running upgrade for neutron-dynamic-routing ...
  INFO  [alembic.runtime.migration] Context impl MySQLImpl.
  INFO  [alembic.runtime.migration] Will assume non-transactional DDL.
-   OK
+   OK
  
  this should look like:
  
+ [What could go wrong]
+ This fix was applied for Oracular onwards; the fix simply ensures that python files that are not true python modules are included in the package.
+ 
  [Original Bug Report]
  This package is not shipping alembic database migrations

-- 
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/2090992

Title:
  [SRU] alembic database migrations missing from package

Status in Ubuntu Cloud Archive:
  Fix Released
Status in Ubuntu Cloud Archive caracal series:
  Triaged
Status in neutron-dynamic-routing package in Ubuntu:
  Fix Released
Status in neutron-dynamic-routing source package in Noble:
  Triaged
Status in neutron-dynamic-routing source package in Oracular:
  Fix Released
Status in neutron-dynamic-routing source package in Plucky:
  Fix Released

Bug description:
  [Impact]
  DB schema is missing, extension driver is not functional.

  [Test Case]
  sudo apt install mysql-server neutron-server python3-neutron-dynamic-routing
  sudo mysql -u root << EOF
  CREATE DATABASE neutron;
  CREATE USER 'neutron'@'localhost' IDENTIFIED BY 'changeme';
  CREATE USER 'neutron'@'%'         IDENTIFIED BY 'changeme';
  GRANT ALL PRIVILEGES ON neutron.* TO 'neutron'@'localhost';
  GRANT ALL PRIVILEGES ON neutron.* TO 'neutron'@'%';
  EOF
  sudo sed -i -e 's!connection = sqlite.*!connection = mysql+pymysql://neutron:changeme@localhost/neutron!g' /etc/neutron/neutron.conf
  sudo neutron-db-manage upgrade head

  No DB migrations will be applied for neutron-dynamic-routing:

    Running upgrade for neutron-dynamic-routing ...
  INFO  [alembic.runtime.migration] Context impl MySQLImpl.
  INFO  [alembic.runtime.migration] Will assume non-transactional DDL.
    OK

  this should look like:

  [What could go wrong]
  This fix was applied for Oracular onwards; the fix simply ensures that python files that are not true python modules are included in the package.

  [Original Bug Report]
  This package is not shipping alembic database migrations

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