Hi-
I have installed Openstack Folsom-3 Glance for my testing and found this
error while db sync.
/usr/local/lib/python2.7/dist-packages/paste/deploy/loadwsgi.py:8:
UserWarning: Module glance was already imported from
/opt/stack/glance/glance/__init__.pyc, but
/usr/local/lib/python2.7/dist-packages/glance-2012.2-py2.7.egg is being
added to sys.path
import pkg_resources
Traceback (most recent call last):
File "./bin/glance-manage", line 131, in <module>
main()
File "./bin/glance-manage", line 127, in main
dispatch_cmd(args)
File "./bin/glance-manage", line 103, in dispatch_cmd
cmd_func(args)
File "./bin/glance-manage", line 91, in do_db_sync
glance.db.sqlalchemy.migration.db_sync(version, current_version)
File "/opt/stack/glance/glance/db/sqlalchemy/migration.py", line 124, in
db_sync
upgrade(version=version)
File "/opt/stack/glance/glance/db/sqlalchemy/migration.py", line 67, in
upgrade
return versioning_api.upgrade(sql_connection, repo_path, version)
File "/usr/local/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/local/lib/python2.7/dist-packages/migrate/versioning/util/__init__.py",
line 159, in with_engine
return f(*a, **kw)
File "/usr/local/lib/python2.7/dist-packages/migrate/versioning/api.py",
line 366, in _migrate
schema.runchange(ver, change, changeset.step)
File
"/usr/local/lib/python2.7/dist-packages/migrate/versioning/schema.py", line
91, in runchange
change.run(self.engine, step)
File
"/usr/local/lib/python2.7/dist-packages/migrate/versioning/script/py.py",
line 145, in run
script_func(engine)
File
"/opt/stack/glance/glance/db/sqlalchemy/migrate_repo/versions/001_add_images_table.py",
line 49, in upgrade
create_tables(tables)
File "/opt/stack/glance/glance/db/sqlalchemy/migrate_repo/schema.py",
line 96, in create_tables
table.create()
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/schema.py", line
594, in create
checkfirst=checkfirst)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py",
line 2303, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py",
line 1973, in _run_visitor
**kwargs).traverse_single(element)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/visitors.py",
line 106, in traverse_single
return meth(obj, **kw)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/ddl.py",
line 86, in visit_table
self.connection.execute(schema.CreateTable(table))
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py",
line 1449, in execute
params)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py",
line 1542, in _execute_ddl
compiled
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py",
line 1698, in _execute_context
context)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py",
line 1691, in _execute_context
context)
File
"/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line
331, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (OperationalError) table images already
exists u'\nCREATE TABLE images (\n\tid INTEGER NOT NULL, \n\tname
VARCHAR(255), \n\ttype VARCHAR(30), \n\tsize INTEGER, \n\tstatus
VARCHAR(30) NOT NULL, \n\tis_public BOOLEAN NOT NULL, \n\tlocation TEXT,
\n\tcreated_at DATETIME NOT NULL, \n\tupdated_at DATETIME, \n\tdeleted_at
DATETIME, \n\tdeleted BOOLEAN NOT NULL, \n\tPRIMARY KEY (id), \n\tCHECK
(is_public IN (0, 1)), \n\tCHECK (deleted IN (0, 1))\n)\n\n' ()
Can any one help me on troubleshooting the same.
--
Regards,
----------------------------------------------
Trinath Somanchi,
+91 9866 235 130
_______________________________________________
Mailing list: https://launchpad.net/~openstack
Post to : openstack@lists.launchpad.net
Unsubscribe : https://launchpad.net/~openstack
More help : https://help.launchpad.net/ListHelp
