openstack team mailing list archive
-
openstack team
-
Mailing list archive
-
Message #21304
Re: keystone-manage db_sync ERROR
Meant to reply on-list.
-Dolph
On Tue, Feb 26, 2013 at 2:39 PM, Dolph Mathews <dolph.mathews@xxxxxxxxx>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@xxxxxx> 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@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@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~openstack
>> More help : https://help.launchpad.net/ListHelp
>>
>
>
Follow ups
References