[Openstack] keystone-manage db_sync ERROR

Dolph Mathews dolph.mathews at gmail.com
Tue Feb 26 20:40:57 UTC 2013


Meant to reply on-list.

-Dolph

On Tue, Feb 26, 2013 at 2:39 PM, Dolph Mathews <dolph.mathews at gmail.com>wrote:

> Thanks for the feedback; cc'ing Adam Young. I raised a bug to track the
> issue: https://bugs.launchpad.net/keystone/+bug/1133608
>
>
> -Dolph
>
>
> On Tue, Feb 26, 2013 at 2:24 PM, Miller, Mark M (EB SW Cloud - R&D -
> Corvallis) <mark.m.miller at hp.com> wrote:
>
>> Hello,
>>
>> I have trying to install Keystone Grizzly-3 and cannot get past the
>> following error. The "keystone-manage db_sync" command is generating the
>> following error. I have tried deleting and re-creating the MySQL database
>> (connection = mysql://keystonedbadmin:password@15.253.59.37/keystone)
>> but the error remains. Has anyone else run into this problem and found a
>> solution? I noticed the role ID value 9fe2ff9ee4384b1894a90878d3e92bab in
>> file
>> "/usr/local/lib/python2.7/dist-packages/keystone-2013.1.g3-py2.7.egg/keystone/config.py".
>>
>>
>> Regards,
>>
>> Mark
>>
>>
>>
>> root at build-HP-Compaq-6005-Pro-SFF-PC:~/keystone-2013.1.g3/keystone-2013.1.g3#
>> keystone-manage db_sync
>> Traceback (most recent call last):
>>   File "/usr/local/bin/keystone-manage", line 5, in <module>
>>     pkg_resources.run_script('keystone==2013.1.g3', 'keystone-manage')
>>   File "/usr/lib/python2.7/dist-packages/pkg_resources.py", line 499, in
>> run_script
>>     self.require(requires)[0].run_script(script_name, ns)
>>   File "/usr/lib/python2.7/dist-packages/pkg_resources.py", line 1235, in
>> run_script
>>     execfile(script_filename, namespace, namespace)
>>   File
>> "/usr/local/lib/python2.7/dist-packages/keystone-2013.1.g3-py2.7.egg/EGG-INFO/scripts/keystone-manage",
>> line 28, in <module>
>>     cli.main(argv=sys.argv, config_files=config_files)
>>   File
>> "/usr/local/lib/python2.7/dist-packages/keystone-2013.1.g3-py2.7.egg/keystone/cli.py",
>> line 172, in main
>>     CONF.command.cmd_class.main()
>>   File
>> "/usr/local/lib/python2.7/dist-packages/keystone-2013.1.g3-py2.7.egg/keystone/cli.py",
>> line 53, in main
>>     driver.db_sync()
>>   File
>> "/usr/local/lib/python2.7/dist-packages/keystone-2013.1.g3-py2.7.egg/keystone/identity/backends/sql.py",
>> line 171, in db_sync
>>     migration.db_sync()
>>   File
>> "/usr/local/lib/python2.7/dist-packages/keystone-2013.1.g3-py2.7.egg/keystone/common/sql/migration.py",
>> line 52, in db_sync
>>     return versioning_api.upgrade(CONF.sql.connection, repo_path, version)
>>   File "/usr/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/lib/python2.7/dist-packages/migrate/versioning/util/__init__.py",
>> line 159, in with_engine
>>     return f(*a, **kw)
>>   File "/usr/lib/python2.7/dist-packages/migrate/versioning/api.py", line
>> 366, in _migrate
>>     schema.runchange(ver, change, changeset.step)
>>   File "/usr/lib/python2.7/dist-packages/migrate/versioning/schema.py",
>> line 91, in runchange
>>     change.run(self.engine, step)
>>   File
>> "/usr/lib/python2.7/dist-packages/migrate/versioning/script/py.py", line
>> 145, in run
>>     script_func(engine)
>>   File
>> "/usr/local/lib/python2.7/dist-packages/keystone-2013.1.g3-py2.7.egg/keystone/common/sql/migrate_repo/versions/017_membership_role.py",
>> line 42, in upgrade
>>     'enabled': 'True'}))
>>   File
>> "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.9-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py",
>> line 1449, in execute
>>     params)
>>   File
>> "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.9-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py",
>> line 1584, in _execute_clauseelement
>>     compiled_sql, distilled_params
>>   File
>> "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.9-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py",
>> line 1698, in _execute_context
>>     context)
>>   File
>> "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.9-py2.7-linux-x86_64.egg/sqlalchemy/engine/base.py",
>> line 1691, in _execute_context
>>     context)
>>   File
>> "/usr/local/lib/python2.7/dist-packages/SQLAlchemy-0.7.9-py2.7-linux-x86_64.egg/sqlalchemy/engine/default.py",
>> line 331, in do_execute
>>     cursor.execute(statement, parameters)
>>   File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174,
>> in execute
>>     self.errorhandler(self, exc, value)
>>   File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line
>> 36, in defaulterrorhandler
>>     raise errorclass, errorvalue
>> sqlalchemy.exc.IntegrityError: (IntegrityError) (1062, "Duplicate entry
>> '9fe2ff9ee4384b1894a90878d3e92bab' for key 'PRIMARY'") 'INSERT INTO role
>> (id, name, extra)
>>
>>
>>
>>
>> _______________________________________________
>> 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
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack/attachments/20130226/15d64095/attachment.html>


More information about the Openstack mailing list