[Bug 2090992] [NEW] [SRU] alembic database migrations missing from package

[James Page]

Public bug reported:

[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:


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

** Affects: cloud-archive
     Importance: Undecided
         Status: Fix Released

** Affects: cloud-archive/caracal
     Importance: High
         Status: Triaged

** Affects: neutron-dynamic-routing (Ubuntu)
     Importance: Undecided
         Status: Fix Released

** Affects: neutron-dynamic-routing (Ubuntu Noble)
     Importance: High
         Status: Triaged

** Affects: neutron-dynamic-routing (Ubuntu Oracular)
     Importance: Undecided
         Status: Fix Released

** Affects: neutron-dynamic-routing (Ubuntu Plucky)
     Importance: Undecided
         Status: Fix Released

** Also affects: neutron-dynamic-routing (Ubuntu Noble)
   Importance: Undecided
       Status: New

** Also affects: neutron-dynamic-routing (Ubuntu Oracular)
   Importance: Undecided
       Status: New

** Also affects: neutron-dynamic-routing (Ubuntu Plucky)
   Importance: Undecided
       Status: New

** Changed in: neutron-dynamic-routing (Ubuntu Oracular)
       Status: New => Fix Released

** Changed in: neutron-dynamic-routing (Ubuntu Plucky)
       Status: New => Fix Released

** Also affects: cloud-archive
   Importance: Undecided
       Status: New

** Also affects: cloud-archive/caracal
   Importance: Undecided
       Status: New

** Changed in: cloud-archive
       Status: New => Fix Released

** Changed in: cloud-archive/caracal
       Status: New => Triaged

** Changed in: cloud-archive/caracal
   Importance: Undecided => High

** Changed in: neutron-dynamic-routing (Ubuntu Noble)
       Status: New => Triaged

** Changed in: neutron-dynamic-routing (Ubuntu Noble)
   Importance: Undecided => High

-- 
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:


  
  [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