← Back to team overview

openstack team mailing list archive

Re: Openstack Folsom-3 Glance Installation DB error

 

Hi-
here are my steps:

[1] I have just downloaded the tar.gz file of glance
[2] untar and run the following commands, python setup.py build , python
setup.py install
[3] create the galnce db in mysql manually.
[4] previously done with keystone work as specified in the ESSESX release,
since I dont have folsom-3 specific document to go with,
[5] updated glance-registry.conf, glance-api-paste.ini,
glance-registry-api.ini (some difference in file name, as I did not
remember them) with SQL information.
[6] run command ' glance-manage versiont_control 0'
[7] run command 'glance-manage db_sync'

This is the complete set of order of steps I have used, and at the end of
the 7th step, I got the below error.

Can you please guide me on troubleshooting the issue.

Thanking you the reply.

-
TNS.

On Wed, Aug 29, 2012 at 8:12 PM, Brian Waldon <bcwaldon@xxxxxxxxx> wrote:

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


-- 
Regards,
----------------------------------------------
Trinath Somanchi,
+91 9866 235 130

Follow ups

References