Hi-<div>here are my steps:</div><div><br></div><div>[1] I have just downloaded the tar.gz file of glance</div><div>[2] untar and run the following commands, python setup.py build , python setup.py install</div><div>[3] create the galnce db in mysql manually.</div>
<div>[4] previously done with keystone work as specified in the ESSESX release, since I dont have folsom-3 specific document to go with,</div><div>[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.</div>
<div>[6] run command ' glance-manage versiont_control 0'</div><div>[7] run command 'glance-manage db_sync'</div><div><br></div><div>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.</div>
<div><br></div><div>Can you please guide me on troubleshooting the issue.</div><div><br></div><div>Thanking you the reply.</div><div><br></div><div>-</div><div>TNS.<br><br><div class="gmail_quote">On Wed, Aug 29, 2012 at 8:12 PM, Brian Waldon <span dir="ltr"><<a href="mailto:bcwaldon@gmail.com" target="_blank">bcwaldon@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Can you share the sequence of commands you used during the install process?<br>
<div><div class="h5"><br>
<br>
On Aug 29, 2012, at 3:18 AM, Trinath Somanchi wrote:<br>
<br>
> Hi-<br>
><br>
> I have installed Openstack Folsom-3 Glance for my testing and found this error while db sync.<br>
><br>
> /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<br>
> import pkg_resources<br>
> Traceback (most recent call last):<br>
> File "./bin/glance-manage", line 131, in <module><br>
> main()<br>
> File "./bin/glance-manage", line 127, in main<br>
> dispatch_cmd(args)<br>
> File "./bin/glance-manage", line 103, in dispatch_cmd<br>
> cmd_func(args)<br>
> File "./bin/glance-manage", line 91, in do_db_sync<br>
> glance.db.sqlalchemy.migration.db_sync(version, current_version)<br>
> File "/opt/stack/glance/glance/db/sqlalchemy/migration.py", line 124, in db_sync<br>
> upgrade(version=version)<br>
> File "/opt/stack/glance/glance/db/sqlalchemy/migration.py", line 67, in upgrade<br>
> return versioning_api.upgrade(sql_connection, repo_path, version)<br>
> File "/usr/local/lib/python2.7/dist-packages/migrate/versioning/api.py", line 186, in upgrade<br>
> return _migrate(url, repository, version, upgrade=True, err=err, **opts)<br>
> File "<string>", line 2, in _migrate<br>
> File "/usr/local/lib/python2.7/dist-packages/migrate/versioning/util/__init__.py", line 159, in with_engine<br>
> return f(*a, **kw)<br>
> File "/usr/local/lib/python2.7/dist-packages/migrate/versioning/api.py", line 366, in _migrate<br>
> schema.runchange(ver, change, changeset.step)<br>
> File "/usr/local/lib/python2.7/dist-packages/migrate/versioning/schema.py", line 91, in runchange<br>
> change.run(self.engine, step)<br>
> File "/usr/local/lib/python2.7/dist-packages/migrate/versioning/script/py.py", line 145, in run<br>
> script_func(engine)<br>
> File "/opt/stack/glance/glance/db/sqlalchemy/migrate_repo/versions/001_add_images_table.py", line 49, in upgrade<br>
> create_tables(tables)<br>
> File "/opt/stack/glance/glance/db/sqlalchemy/migrate_repo/schema.py", line 96, in create_tables<br>
> table.create()<br>
> File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/schema.py", line 594, in create<br>
> checkfirst=checkfirst)<br>
> File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 2303, in _run_visitor<br>
> conn._run_visitor(visitorcallable, element, **kwargs)<br>
> File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1973, in _run_visitor<br>
> **kwargs).traverse_single(element)<br>
> File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/visitors.py", line 106, in traverse_single<br>
> return meth(obj, **kw)<br>
> File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/ddl.py", line 86, in visit_table<br>
> self.connection.execute(schema.CreateTable(table))<br>
> File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1449, in execute<br>
> params)<br>
> File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1542, in _execute_ddl<br>
> compiled<br>
> File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1698, in _execute_context<br>
> context)<br>
> File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1691, in _execute_context<br>
> context)<br>
> File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 331, in do_execute<br>
> cursor.execute(statement, parameters)<br>
> 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' ()<br>
><br>
> Can any one help me on troubleshooting the same.<br>
><br>
><br>
><br>
><br>
> --<br>
> Regards,<br>
> ----------------------------------------------<br>
> Trinath Somanchi,<br>
> +91 9866 235 130<br>
><br>
</div></div>> _______________________________________________<br>
> Mailing list: <a href="https://launchpad.net/~openstack" target="_blank">https://launchpad.net/~openstack</a><br>
> Post to : <a href="mailto:openstack@lists.launchpad.net">openstack@lists.launchpad.net</a><br>
> Unsubscribe : <a href="https://launchpad.net/~openstack" target="_blank">https://launchpad.net/~openstack</a><br>
> More help : <a href="https://help.launchpad.net/ListHelp" target="_blank">https://help.launchpad.net/ListHelp</a><br>
<br>
</blockquote></div><br><br clear="all"><div><br></div>-- <br>Regards,<br>----------------------------------------------<br>Trinath Somanchi,<div>+91 9866 235 130</div><br>
</div>