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