[openstack-dev] [Openstack] Openstack Folsom-3 Glance Installation DB error

Brian Waldon bcwaldon at gmail.com
Wed Aug 29 14:42:19 UTC 2012


Can you share the sequence of commands you used during the install process?


On Aug 29, 2012, at 3:18 AM, Trinath Somanchi wrote:

> 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 at lists.launchpad.net
> Unsubscribe : https://launchpad.net/~openstack
> More help   : https://help.launchpad.net/ListHelp




More information about the OpenStack-dev mailing list