yahoo-eng-team team mailing list archive

[hanchl <1881685@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

I am trying to upgrade the platform from queens to rocky . To meet
production needs, I cannot upgrade the platform in place. So I need to
copy the queens version data to the rocky version environment before
upgrading. After I import the queens version database to the rocky
version, execute the following command：

"neutron-db-manage \
  --config-file /etc/neutron/neutron.conf \
  --config-file /etc/neutron/plugins/ml2/ml2_conf.ini \
  upgrade head"
Then I got an error:

oslo_db.exception.DBError: (pymysql.err.InternalError) (1005, u'Can\'t
create table `neutron`.`portforwardings` (errno: 150 "Foreign key
constraint is incorrectly formed")') [SQL: u'\nCREATE TABLE
portforwardings (\n\tid VARCHAR(36) NOT NULL, \n\tfloatingip_id
VARCHAR(36) NOT NULL, \n\texternal_port INTEGER NOT NULL,
\n\tinternal_neutron_port_id VARCHAR(36) NOT NULL, \n\tprotocol
VARCHAR(40) NOT NULL, \n\tsocket VARCHAR(36) NOT NULL, \n\tPRIMARY KEY
(id), \n\tFOREIGN KEY(floatingip_id) REFERENCES floatingips (id) ON
DELETE CASCADE, \n\tFOREIGN KEY(internal_neutron_port_id) REFERENCES
ports (id) ON DELETE CASCADE, \n\tCONSTRAINT
uniq_port_forwardings0floatingip_id0external_port UNIQUE (floatingip_id,
external_port), \n\tCONSTRAINT
uniq_port_forwardings0internal_neutron_port_id0socket UNIQUE
(internal_neutron_port_id, socket)\n)ENGINE=InnoDB\n\n'] (Background on
this error at: http://sqlalche.me/e/2j85)

Then I check the two tables: floatingips and ports, found that there was
"DEFAULT CHARSET=utf8"of the two, so I entered the database to manually
create table portforwardings and succeeded.

If there is a bug?

** Affects: neutron
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to neutron.
https://bugs.launchpad.net/bugs/1881685

Title:
  Inconsistent coding while upgrading

Status in neutron:
  New

Bug description:
  I am trying to upgrade the platform from queens to rocky . To meet
  production needs, I cannot upgrade the platform in place. So I need to
  copy the queens version data to the rocky version environment before
  upgrading. After I import the queens version database to the rocky
  version, execute the following command：

  "neutron-db-manage \
    --config-file /etc/neutron/neutron.conf \
    --config-file /etc/neutron/plugins/ml2/ml2_conf.ini \
    upgrade head"
  Then I got an error:

  oslo_db.exception.DBError: (pymysql.err.InternalError) (1005, u'Can\'t
  create table `neutron`.`portforwardings` (errno: 150 "Foreign key
  constraint is incorrectly formed")') [SQL: u'\nCREATE TABLE
  portforwardings (\n\tid VARCHAR(36) NOT NULL, \n\tfloatingip_id
  VARCHAR(36) NOT NULL, \n\texternal_port INTEGER NOT NULL,
  \n\tinternal_neutron_port_id VARCHAR(36) NOT NULL, \n\tprotocol
  VARCHAR(40) NOT NULL, \n\tsocket VARCHAR(36) NOT NULL, \n\tPRIMARY KEY
  (id), \n\tFOREIGN KEY(floatingip_id) REFERENCES floatingips (id) ON
  DELETE CASCADE, \n\tFOREIGN KEY(internal_neutron_port_id) REFERENCES
  ports (id) ON DELETE CASCADE, \n\tCONSTRAINT
  uniq_port_forwardings0floatingip_id0external_port UNIQUE
  (floatingip_id, external_port), \n\tCONSTRAINT
  uniq_port_forwardings0internal_neutron_port_id0socket UNIQUE
  (internal_neutron_port_id, socket)\n)ENGINE=InnoDB\n\n'] (Background
  on this error at: http://sqlalche.me/e/2j85)

  Then I check the two tables: floatingips and ports, found that there
  was "DEFAULT CHARSET=utf8"of the two, so I entered the database to
  manually create table portforwardings and succeeded.

  If there is a bug?

To manage notifications about this bug go to:
https://bugs.launchpad.net/neutron/+bug/1881685/+subscriptions