Cinder

  1. Bug #1368213
  2. Comment #6

Comment 6 for bug 1368213

Revision history for this message
Xing Yang (xing-yang) wrote :

Reproduced this on a fresh devstack install.

Error from Rushi's output while running "cinder-manage db sync 24" from 25:
OperationalError: (OperationalError) (1025, "Error on rename of './cinder/#sql-2423_62' to './cinder/snapshots' (errno: 150)") '\nALTER TABLE snapshots DROP COLUMN cgsnapshot_id' ()
2014-09-11 18:05:55.095 TRACE cinder

The reason that drop column failed was because of the foreign key constraint. MySQL cannot drop column until the foreign key constraint is removed. So the solution is to remove the foreign key first, and then drop the column.