[Openstack] Openstack Folsom-3 Glance Installation DB error

unicell unicell at gmail.com
Fri Aug 31 11:03:27 UTC 2012


Make sure you used "glance" command from python-glanceclient project,
instead of the command shipped with "glance" project.

More information here
http://bcwaldon.cc/2012/08/20/openstack-folsom-glance-overview

Best Regards,
--
Qiu Yu
http://www.unicell.info


On Fri, Aug 31, 2012 at 3:54 PM, Trinath Somanchi <
trinath.somanchi at gmail.com> wrote:

> Hi Unicell-'
>
> But still I get the same error.
>
> When I issue the glance command, the following warning is issued.
>
> "WARNING! This tool is deprecated in favor of python-glanceclient..."
>
> Can any one help me on how to resolve the issue.
>
> -
> TNS
>
> On Thu, Aug 30, 2012 at 8:47 PM, unicell <unicell at gmail.com> wrote:
>
>> 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 at 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.somanchi at 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 <bcwaldon at 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 at 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 at lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~openstack
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>
>
> --
> Regards,
> ----------------------------------------------
> Trinath Somanchi,
> +91 9866 235 130
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack/attachments/20120831/92a9486a/attachment.html>


More information about the Openstack mailing list