Hi Trinath, For the first db_sync issue you mentioned, it seems to be caused by Folsom version of glance-manage db_sync, which is caused "glance-manage db_sync" followed by "glance version_control 0". And I can duplicate it at my side.
Brian is working on another issue ( https://bugs.launchpad.net/glance/+bug/1042925 ), the proposed solution might be helpful for this issue, I think. For now, as a workaround, you can simply run "glance-manage db_sync", and no need for "glance-manage version_control 0". "glance-manage db_sync" command alone is enough to create the database model. For the second issue you mentioned, "glance index" is deprecated in Folsom. You can now refer to "glance image-list" and "glance --help" for more information. Best Regards, -- Qiu Yu http://www.unicell.info On Thu, Aug 30, 2012 at 5:42 PM, Trinath Somanchi < trinath.soman...@gmail.com> wrote: > Hi- > > This issue is resolved, reset the mysql passcode for glance. > > But struck with another issue, 'glance index' command. > > I have issued 'glance index' command to check the accuracy of my glance > installations. > > But I got the following error > > /opt/stack/glance/glance/openstack/common/version.py:22: 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 > WARNING! This tool is deprecated in favor of python-glanceclient (see > http://github.com/openstack/python-glanceclient). > Failed to show index. Got error: > [Errno 111] Connection refused > > > Can any one help me on solving this issue. > > - > TNS > > > > > On Wed, Aug 29, 2012 at 10:25 PM, Trinath Somanchi < > trinath.soman...@gmail.com> wrote: > >> 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 >> >> > > > -- > 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 > >
_______________________________________________ Mailing list: https://launchpad.net/~openstack Post to : openstack@lists.launchpad.net Unsubscribe : https://launchpad.net/~openstack More help : https://help.launchpad.net/ListHelp
