# glance-manage db_sync
/usr/lib/python2.7/dist-packages/glance/registry/db/migrate_repo/versions/001_add_images_table.py:40: SADeprecationWarning: useexisting is deprecated. Use extend_existing.
useexisting=True)
Traceback (most recent call last):
File "/usr/bin/glance-manage", line 128, in <module>
main()
File "/usr/bin/glance-manage", line 124, in main
dispatch_cmd(conf, args)
File "/usr/bin/glance-manage", line 99, in dispatch_cmd
cmd_func(conf, args)
File "/usr/bin/glance-manage", line 87, in do_db_sync
glance.registry.db.migration.db_sync(conf, version=db_version)
File "/usr/lib/python2.7/dist-packages/glance/registry/db/migration.py", line 123, in db_sync
upgrade(conf, version=version)
File "/usr/lib/python2.7/dist-packages/glance/registry/db/migration.py", line 66, in upgrade
return versioning_api.upgrade(sql_connection, repo_path, version)
File "/usr/lib/python2.7/dist-packages/migrate/versioning/api.py", line 186, in upgrade
return _migrate(url, repository, version, upgrade=True, err=err, **opts)
File "<string>", line 2, in _migrate
File "/usr/lib/python2.7/dist-packages/migrate/versioning/util/__init__.py", line 159, in with_engine
return f(*a, **kw)
File "/usr/lib/python2.7/dist-packages/migrate/versioning/api.py", line 366, in _migrate
schema.runchange(ver, change, changeset.step)
File "/usr/lib/python2.7/dist-packages/migrate/versioning/schema.py", line 91, in runchange
change.run(self.engine, step)
File "/usr/lib/python2.7/dist-packages/migrate/versioning/script/py.py", line 145, in run
script_func(engine)
File "/usr/lib/python2.7/dist-packages/glance/registry/db/migrate_repo/versions/001_add_images_table.py", line 49, in upgrade
create_tables(tables)
File "/usr/lib/python2.7/dist-packages/glance/registry/db/migrate_repo/schema.py", line 97, in create_tables
table.create()
File "/usr/lib/python2.7/dist-packages/sqlalchemy/schema.py", line 564, in create
checkfirst=checkfirst)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 2234, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1904, in _run_visitor
**kwargs).traverse_single(element)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/sql/visitors.py", line 86, in traverse_single
return meth(obj, **kw)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/ddl.py", line 86, in visit_table
self.connection.execute(schema.CreateTable(table))
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1405, in execute
params)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1496, in _execute_ddl
compiled
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1646, in _execute_context
context)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1639, in _execute_context
context)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 330, in do_execute
cursor.execute(statement, parameters)
File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174, in execute
self.errorhandler(self, exc, value)
File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorclass, errorvalue
sqlalchemy.exc.OperationalError: (OperationalError) (1050, "Table 'images' already exists") '\nCREATE TABLE images (\n\tid INTEGER NOT NULL AUTO_INCREMENT, \n\tname VARCHAR(255), \n\ttype VARCHAR(30), \n\tsize INTEGER, \n\tstatus VARCHAR(30) NOT NULL, \n\tis_public BOOL NOT NULL, \n\tlocation TEXT, \n\tcreated_at DATETIME NOT NULL, \n\tupdated_at DATETIME, \n\tdeleted_at DATETIME, \n\tdeleted BOOL NOT NULL, \n\tPRIMARY KEY (id), \n\tCHECK (is_public IN (0, 1)), \n\tCHECK (deleted IN (0, 1))\n)ENGINE=InnoDB\n\n' ()
root@node34:~#
HI I try the ubuntu 12.04 alpha 2
root@node34:~# apt-cache policy glance cn.archive. ubuntu. com/ubuntu/ precise/main amd64 Packages dpkg/status
glance:
Installed: 2012.1~e3-0ubuntu1
Candidate: 2012.1~e3-0ubuntu1
Version table:
*** 2012.1~e3-0ubuntu1 0
500 http://
100 /var/lib/
after install glance
# glance-manage db_sync python2. 7/dist- packages/ glance/ registry/ db/migrate_ repo/versions/ 001_add_ images_ table.py: 40: SADeprecationWa rning: useexisting is deprecated. Use extend_existing. glance- manage" , line 128, in <module> glance- manage" , line 124, in main cmd(conf, args) glance- manage" , line 99, in dispatch_cmd glance- manage" , line 87, in do_db_sync registry. db.migration. db_sync( conf, version=db_version) python2. 7/dist- packages/ glance/ registry/ db/migration. py", line 123, in db_sync python2. 7/dist- packages/ glance/ registry/ db/migration. py", line 66, in upgrade api.upgrade( sql_connection, repo_path, version) python2. 7/dist- packages/ migrate/ versioning/ api.py" , line 186, in upgrade python2. 7/dist- packages/ migrate/ versioning/ util/__ init__. py", line 159, in with_engine python2. 7/dist- packages/ migrate/ versioning/ api.py" , line 366, in _migrate runchange( ver, change, changeset.step) python2. 7/dist- packages/ migrate/ versioning/ schema. py", line 91, in runchange run(self. engine, step) python2. 7/dist- packages/ migrate/ versioning/ script/ py.py", line 145, in run func(engine) python2. 7/dist- packages/ glance/ registry/ db/migrate_ repo/versions/ 001_add_ images_ table.py" , line 49, in upgrade tables( tables) python2. 7/dist- packages/ glance/ registry/ db/migrate_ repo/schema. py", line 97, in create_tables python2. 7/dist- packages/ sqlalchemy/ schema. py", line 564, in create checkfirst) python2. 7/dist- packages/ sqlalchemy/ engine/ base.py" , line 2234, in _run_visitor _run_visitor( visitorcallable , element, **kwargs) python2. 7/dist- packages/ sqlalchemy/ engine/ base.py" , line 1904, in _run_visitor .traverse_ single( element) python2. 7/dist- packages/ sqlalchemy/ sql/visitors. py", line 86, in traverse_single python2. 7/dist- packages/ sqlalchemy/ engine/ ddl.py" , line 86, in visit_table connection. execute( schema. CreateTable( table)) python2. 7/dist- packages/ sqlalchemy/ engine/ base.py" , line 1405, in execute python2. 7/dist- packages/ sqlalchemy/ engine/ base.py" , line 1496, in _execute_ddl python2. 7/dist- packages/ sqlalchemy/ engine/ base.py" , line 1646, in _execute_context python2. 7/dist- packages/ sqlalchemy/ engine/ base.py" , line 1639, in _execute_context python2. 7/dist- packages/ sqlalchemy/ engine/ default. py", line 330, in do_execute execute( statement, parameters) python2. 7/dist- packages/ MySQLdb/ cursors. py", line 174, in execute errorhandler( self, exc, value) python2. 7/dist- packages/ MySQLdb/ connections. py", line 36, in defaulterrorhandler exc.Operational Error: (OperationalError) (1050, "Table 'images' already exists") '\nCREATE TABLE images (\n\tid INTEGER NOT NULL AUTO_INCREMENT, \n\tname VARCHAR(255), \n\ttype VARCHAR(30), \n\tsize INTEGER, \n\tstatus VARCHAR(30) NOT NULL, \n\tis_public BOOL NOT NULL, \n\tlocation TEXT, \n\tcreated_at DATETIME NOT NULL, \n\tupdated_at DATETIME, \n\tdeleted_at DATETIME, \n\tdeleted BOOL NOT NULL, \n\tPRIMARY KEY (id), \n\tCHECK (is_public IN (0, 1)), \n\tCHECK (deleted IN (0, 1))\n)ENGINE= InnoDB\ n\n' ()
/usr/lib/
useexisting=True)
Traceback (most recent call last):
File "/usr/bin/
main()
File "/usr/bin/
dispatch_
File "/usr/bin/
cmd_func(conf, args)
File "/usr/bin/
glance.
File "/usr/lib/
upgrade(conf, version=version)
File "/usr/lib/
return versioning_
File "/usr/lib/
return _migrate(url, repository, version, upgrade=True, err=err, **opts)
File "<string>", line 2, in _migrate
File "/usr/lib/
return f(*a, **kw)
File "/usr/lib/
schema.
File "/usr/lib/
change.
File "/usr/lib/
script_
File "/usr/lib/
create_
File "/usr/lib/
table.create()
File "/usr/lib/
checkfirst=
File "/usr/lib/
conn.
File "/usr/lib/
**kwargs)
File "/usr/lib/
return meth(obj, **kw)
File "/usr/lib/
self.
File "/usr/lib/
params)
File "/usr/lib/
compiled
File "/usr/lib/
context)
File "/usr/lib/
context)
File "/usr/lib/
cursor.
File "/usr/lib/
self.
File "/usr/lib/
raise errorclass, errorvalue
sqlalchemy.
root@node34:~#