[Yahoo-eng-team] [Bug 1526710] Re: NotSupportedError: MySQL cannot rename indexes

2016-01-20 Thread Federico Ressi 
** Changed in: glance
   Status: Incomplete => Invalid

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

Title:
  NotSupportedError: MySQL cannot rename indexes

Status in Glance:
  Invalid

Bug description:
  When stacking with branch stable/liberty of devstack, on a control host I had 
below error.
  I am using a clean Ubuntu 14.04 LTS just updated.

  
  2015-12-16 07:50:32.262 | 2015-12-16 07:50:32.262 INFO migrate.versioning.api 
[-] 0 -> 1... 
  2015-12-16 07:50:32.272 | 2015-12-16 07:50:32.272 INFO 
glance.db.sqlalchemy.migrate_repo.schema [-] creating table images
  2015-12-16 07:50:32.293 | 2015-12-16 07:50:32.293 INFO migrate.versioning.api 
[-] done
  2015-12-16 07:50:32.293 | 2015-12-16 07:50:32.293 INFO migrate.versioning.api 
[-] 1 -> 2... 
  2015-12-16 07:50:32.303 | 2015-12-16 07:50:32.303 INFO 
glance.db.sqlalchemy.migrate_repo.schema [-] creating table image_properties
  2015-12-16 07:50:32.350 | 2015-12-16 07:50:32.350 INFO migrate.versioning.api 
[-] done
  2015-12-16 07:50:32.351 | 2015-12-16 07:50:32.351 INFO migrate.versioning.api 
[-] 2 -> 3... 
  2015-12-16 07:50:32.374 | 2015-12-16 07:50:32.374 INFO migrate.versioning.api 
[-] done
  2015-12-16 07:50:32.376 | 2015-12-16 07:50:32.374 INFO migrate.versioning.api 
[-] 3 -> 4... 
  2015-12-16 07:50:32.387 | 2015-12-16 07:50:32.387 INFO migrate.versioning.api 
[-] done
  2015-12-16 07:50:32.387 | 2015-12-16 07:50:32.387 INFO migrate.versioning.api 
[-] 4 -> 5... 
  2015-12-16 07:50:32.399 | 2015-12-16 07:50:32.398 INFO migrate.versioning.api 
[-] done
  2015-12-16 07:50:32.399 | 2015-12-16 07:50:32.399 INFO migrate.versioning.api 
[-] 5 -> 6... 
  2015-12-16 07:50:32.404 | 2015-12-16 07:50:32.404 CRITICAL glance [-] 
NotSupportedError: MySQL cannot rename indexes
  2015-12-16 07:50:32.406 | 
  2015-12-16 07:50:32.406 | 2015-12-16 07:50:32.404 TRACE glance Traceback 
(most recent call last):
  2015-12-16 07:50:32.406 | 2015-12-16 07:50:32.404 TRACE glance   File 
"/usr/local/bin/glance-manage", line 10, in 
  2015-12-16 07:50:32.406 | 2015-12-16 07:50:32.404 TRACE glance 
sys.exit(main())
  2015-12-16 07:50:32.407 | 2015-12-16 07:50:32.404 TRACE glance   File 
"/opt/stack/glance/glance/cmd/manage.py", line 314, in main
  2015-12-16 07:50:32.407 | 2015-12-16 07:50:32.404 TRACE glance return 
CONF.command.action_fn()
  2015-12-16 07:50:32.407 | 2015-12-16 07:50:32.404 TRACE glance   File 
"/opt/stack/glance/glance/cmd/manage.py", line 170, in sync
  2015-12-16 07:50:32.407 | 2015-12-16 07:50:32.404 TRACE glance 
CONF.command.current_version)
  2015-12-16 07:50:32.408 | 2015-12-16 07:50:32.404 TRACE glance   File 
"/opt/stack/glance/glance/cmd/manage.py", line 115, in sync
  2015-12-16 07:50:32.408 | 2015-12-16 07:50:32.404 TRACE glance version)
  2015-12-16 07:50:32.408 | 2015-12-16 07:50:32.404 TRACE glance   File 
"/usr/local/lib/python2.7/dist-packages/oslo_db/sqlalchemy/migration.py", line 
79, in db_sync
  2015-12-16 07:50:32.408 | 2015-12-16 07:50:32.404 TRACE glance migration 
= versioning_api.upgrade(engine, repository, version)
  2015-12-16 07:50:32.408 | 2015-12-16 07:50:32.404 TRACE glance   File 
"/usr/local/lib/python2.7/dist-packages/migrate/versioning/api.py", line 186, 
in upgrade
  2015-12-16 07:50:32.409 | 2015-12-16 07:50:32.404 TRACE glance return 
_migrate(url, repository, version, upgrade=True, err=err, **opts)
  2015-12-16 07:50:32.409 | 2015-12-16 07:50:32.404 TRACE glance   File 
"", line 2, in _migrate
  2015-12-16 07:50:32.409 | 2015-12-16 07:50:32.404 TRACE glance   File 
"/usr/local/lib/python2.7/dist-packages/migrate/versioning/util/__init__.py", 
line 160, in with_engine
  2015-12-16 07:50:32.410 | 2015-12-16 07:50:32.404 TRACE glance return 
f(*a, **kw)
  2015-12-16 07:50:32.410 | 2015-12-16 07:50:32.404 TRACE glance   File 
"/usr/local/lib/python2.7/dist-packages/migrate/versioning/api.py", line 366, 
in _migrate
  2015-12-16 07:50:32.410 | 2015-12-16 07:50:32.404 TRACE glance 
schema.runchange(ver, change, changeset.step)
  2015-12-16 07:50:32.410 | 2015-12-16 07:50:32.404 TRACE glance   File 
"/usr/local/lib/python2.7/dist-packages/migrate/versioning/schema.py", line 93, 
in runchange
  2015-12-16 07:50:32.411 | 2015-12-16 07:50:32.404 TRACE glance 
change.run(self.engine, step)
  2015-12-16 07:50:32.411 | 2015-12-16 07:50:32.404 TRACE glance   File 
"/usr/local/lib/python2.7/dist-packages/migrate/versioning/script/py.py", line 
148, in run
  2015-12-16 07:50:32.411 | 2015-12-16 07:50:32.404 TRACE glance 
script_func(engine)
  2015-12-16 07:50:32.412 | 2015-12-16 07:50:32.404 TRACE glance   File 
"/opt/stack/glance/glance/db/sqlalchemy/migrate_repo/versions/006_key_to_name.py",
 line 96, in upgrade
  2015-12-16 07:50:32.412 | 2015-12-16 07:50:32.404 TRACE glance 
index.rename('ix_image_properties_image_id_name')
  2015-12-16 07:50:32.413 |

[Yahoo-eng-team] [Bug 1526710] Re: NotSupportedError: MySQL cannot rename indexes

2015-12-16 Thread Federico Ressi 
** No longer affects: devstack

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

Title:
  NotSupportedError: MySQL cannot rename indexes

Status in Glance:
  New

Bug description:
  When stacking with branch stable/liberty of devstack, on a control host I had 
below error.
  I am using a clean Ubuntu 14.04 LTS just updated.

  
  2015-12-16 07:50:32.262 | 2015-12-16 07:50:32.262 INFO migrate.versioning.api 
[-] 0 -> 1... 
  2015-12-16 07:50:32.272 | 2015-12-16 07:50:32.272 INFO 
glance.db.sqlalchemy.migrate_repo.schema [-] creating table images
  2015-12-16 07:50:32.293 | 2015-12-16 07:50:32.293 INFO migrate.versioning.api 
[-] done
  2015-12-16 07:50:32.293 | 2015-12-16 07:50:32.293 INFO migrate.versioning.api 
[-] 1 -> 2... 
  2015-12-16 07:50:32.303 | 2015-12-16 07:50:32.303 INFO 
glance.db.sqlalchemy.migrate_repo.schema [-] creating table image_properties
  2015-12-16 07:50:32.350 | 2015-12-16 07:50:32.350 INFO migrate.versioning.api 
[-] done
  2015-12-16 07:50:32.351 | 2015-12-16 07:50:32.351 INFO migrate.versioning.api 
[-] 2 -> 3... 
  2015-12-16 07:50:32.374 | 2015-12-16 07:50:32.374 INFO migrate.versioning.api 
[-] done
  2015-12-16 07:50:32.376 | 2015-12-16 07:50:32.374 INFO migrate.versioning.api 
[-] 3 -> 4... 
  2015-12-16 07:50:32.387 | 2015-12-16 07:50:32.387 INFO migrate.versioning.api 
[-] done
  2015-12-16 07:50:32.387 | 2015-12-16 07:50:32.387 INFO migrate.versioning.api 
[-] 4 -> 5... 
  2015-12-16 07:50:32.399 | 2015-12-16 07:50:32.398 INFO migrate.versioning.api 
[-] done
  2015-12-16 07:50:32.399 | 2015-12-16 07:50:32.399 INFO migrate.versioning.api 
[-] 5 -> 6... 
  2015-12-16 07:50:32.404 | 2015-12-16 07:50:32.404 CRITICAL glance [-] 
NotSupportedError: MySQL cannot rename indexes
  2015-12-16 07:50:32.406 | 
  2015-12-16 07:50:32.406 | 2015-12-16 07:50:32.404 TRACE glance Traceback 
(most recent call last):
  2015-12-16 07:50:32.406 | 2015-12-16 07:50:32.404 TRACE glance   File 
"/usr/local/bin/glance-manage", line 10, in 
  2015-12-16 07:50:32.406 | 2015-12-16 07:50:32.404 TRACE glance 
sys.exit(main())
  2015-12-16 07:50:32.407 | 2015-12-16 07:50:32.404 TRACE glance   File 
"/opt/stack/glance/glance/cmd/manage.py", line 314, in main
  2015-12-16 07:50:32.407 | 2015-12-16 07:50:32.404 TRACE glance return 
CONF.command.action_fn()
  2015-12-16 07:50:32.407 | 2015-12-16 07:50:32.404 TRACE glance   File 
"/opt/stack/glance/glance/cmd/manage.py", line 170, in sync
  2015-12-16 07:50:32.407 | 2015-12-16 07:50:32.404 TRACE glance 
CONF.command.current_version)
  2015-12-16 07:50:32.408 | 2015-12-16 07:50:32.404 TRACE glance   File 
"/opt/stack/glance/glance/cmd/manage.py", line 115, in sync
  2015-12-16 07:50:32.408 | 2015-12-16 07:50:32.404 TRACE glance version)
  2015-12-16 07:50:32.408 | 2015-12-16 07:50:32.404 TRACE glance   File 
"/usr/local/lib/python2.7/dist-packages/oslo_db/sqlalchemy/migration.py", line 
79, in db_sync
  2015-12-16 07:50:32.408 | 2015-12-16 07:50:32.404 TRACE glance migration 
= versioning_api.upgrade(engine, repository, version)
  2015-12-16 07:50:32.408 | 2015-12-16 07:50:32.404 TRACE glance   File 
"/usr/local/lib/python2.7/dist-packages/migrate/versioning/api.py", line 186, 
in upgrade
  2015-12-16 07:50:32.409 | 2015-12-16 07:50:32.404 TRACE glance return 
_migrate(url, repository, version, upgrade=True, err=err, **opts)
  2015-12-16 07:50:32.409 | 2015-12-16 07:50:32.404 TRACE glance   File 
"", line 2, in _migrate
  2015-12-16 07:50:32.409 | 2015-12-16 07:50:32.404 TRACE glance   File 
"/usr/local/lib/python2.7/dist-packages/migrate/versioning/util/__init__.py", 
line 160, in with_engine
  2015-12-16 07:50:32.410 | 2015-12-16 07:50:32.404 TRACE glance return 
f(*a, **kw)
  2015-12-16 07:50:32.410 | 2015-12-16 07:50:32.404 TRACE glance   File 
"/usr/local/lib/python2.7/dist-packages/migrate/versioning/api.py", line 366, 
in _migrate
  2015-12-16 07:50:32.410 | 2015-12-16 07:50:32.404 TRACE glance 
schema.runchange(ver, change, changeset.step)
  2015-12-16 07:50:32.410 | 2015-12-16 07:50:32.404 TRACE glance   File 
"/usr/local/lib/python2.7/dist-packages/migrate/versioning/schema.py", line 93, 
in runchange
  2015-12-16 07:50:32.411 | 2015-12-16 07:50:32.404 TRACE glance 
change.run(self.engine, step)
  2015-12-16 07:50:32.411 | 2015-12-16 07:50:32.404 TRACE glance   File 
"/usr/local/lib/python2.7/dist-packages/migrate/versioning/script/py.py", line 
148, in run
  2015-12-16 07:50:32.411 | 2015-12-16 07:50:32.404 TRACE glance 
script_func(engine)
  2015-12-16 07:50:32.412 | 2015-12-16 07:50:32.404 TRACE glance   File 
"/opt/stack/glance/glance/db/sqlalchemy/migrate_repo/versions/006_key_to_name.py",
 line 96, in upgrade
  2015-12-16 07:50:32.412 | 2015-12-16 07:50:32.404 TRACE glance 
index.rename('ix_image_properties_image_id_name')
  2015-12-16 07:50:32.413 | 2015-12-16 07:50:32.404 TRACE