openstack team mailing list archive

[unicell <unicell@xxxxxxxxx>]

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.somanchi@xxxxxxxxx> 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.somanchi@xxxxxxxxx> 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 <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
>>
>>
>
>
> --
> 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
>
>