<div dir="ltr">Meant to reply on-list.<div class="gmail_extra"><div><div><br></div>-Dolph</div><br><div class="gmail_quote">On Tue, Feb 26, 2013 at 2:39 PM, Dolph Mathews <span dir="ltr"><<a href="mailto:dolph.mathews@gmail.com" target="_blank">dolph.mathews@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Thanks for the feedback; cc'ing Adam Young. I raised a bug to track the issue: <a href="https://bugs.launchpad.net/keystone/+bug/1133608" target="_blank">https://bugs.launchpad.net/keystone/+bug/1133608</a></div>
<div class="gmail_extra"><span class="HOEnZb"><font color="#888888">
<br clear="all"><div><div><br></div>-Dolph</div></font></span><div><div class="h5">
<br><br><div class="gmail_quote">On Tue, Feb 26, 2013 at 2:24 PM, Miller, Mark M (EB SW Cloud - R&D - Corvallis) <span dir="ltr"><<a href="mailto:mark.m.miller@hp.com" target="_blank">mark.m.miller@hp.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hello,<br>
<br>
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://<a href="http://keystonedbadmin:password@15.253.59.37/keystone" target="_blank">keystonedbadmin:password@15.253.59.37/keystone</a>) 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".<br>
<br>
<br>
Regards,<br>
<br>
Mark<br>
<br>
<br>
<br>
root@build-HP-Compaq-6005-Pro-SFF-PC:~/keystone-2013.1.g3/keystone-2013.1.g3# keystone-manage db_sync<br>
Traceback (most recent call last):<br>
File "/usr/local/bin/keystone-manage", line 5, in <module><br>
pkg_resources.run_script('keystone==2013.1.g3', 'keystone-manage')<br>
File "/usr/lib/python2.7/dist-packages/pkg_resources.py", line 499, in run_script<br>
self.require(requires)[0].run_script(script_name, ns)<br>
File "/usr/lib/python2.7/dist-packages/pkg_resources.py", line 1235, in run_script<br>
execfile(script_filename, namespace, namespace)<br>
File "/usr/local/lib/python2.7/dist-packages/keystone-2013.1.g3-py2.7.egg/EGG-INFO/scripts/keystone-manage", line 28, in <module><br>
cli.main(argv=sys.argv, config_files=config_files)<br>
File "/usr/local/lib/python2.7/dist-packages/keystone-2013.1.g3-py2.7.egg/keystone/cli.py", line 172, in main<br>
CONF.command.cmd_class.main()<br>
File "/usr/local/lib/python2.7/dist-packages/keystone-2013.1.g3-py2.7.egg/keystone/cli.py", line 53, in main<br>
driver.db_sync()<br>
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<br>
migration.db_sync()<br>
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<br>
return versioning_api.upgrade(CONF.sql.connection, repo_path, version)<br>
File "/usr/lib/python2.7/dist-packages/migrate/versioning/api.py", line 186, in upgrade<br>
return _migrate(url, repository, version, upgrade=True, err=err, **opts)<br>
File "<string>", line 2, in _migrate<br>
File "/usr/lib/python2.7/dist-packages/migrate/versioning/util/__init__.py", line 159, in with_engine<br>
return f(*a, **kw)<br>
File "/usr/lib/python2.7/dist-packages/migrate/versioning/api.py", line 366, in _migrate<br>
schema.runchange(ver, change, changeset.step)<br>
File "/usr/lib/python2.7/dist-packages/migrate/versioning/schema.py", line 91, in runchange<br>
change.run(self.engine, step)<br>
File "/usr/lib/python2.7/dist-packages/migrate/versioning/script/py.py", line 145, in run<br>
script_func(engine)<br>
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<br>
'enabled': 'True'}))<br>
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<br>
params)<br>
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<br>
compiled_sql, distilled_params<br>
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<br>
context)<br>
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<br>
context)<br>
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<br>
cursor.execute(statement, parameters)<br>
File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174, in execute<br>
self.errorhandler(self, exc, value)<br>
File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler<br>
raise errorclass, errorvalue<br>
sqlalchemy.exc.IntegrityError: (IntegrityError) (1062, "Duplicate entry '9fe2ff9ee4384b1894a90878d3e92bab' for key 'PRIMARY'") 'INSERT INTO role (id, name, extra)<br>
<br>
<br>
<br>
<br>
_______________________________________________<br>
Mailing list: <a href="https://launchpad.net/~openstack" target="_blank">https://launchpad.net/~openstack</a><br>
Post to : <a href="mailto:openstack@lists.launchpad.net" target="_blank">openstack@lists.launchpad.net</a><br>
Unsubscribe : <a href="https://launchpad.net/~openstack" target="_blank">https://launchpad.net/~openstack</a><br>
More help : <a href="https://help.launchpad.net/ListHelp" target="_blank">https://help.launchpad.net/ListHelp</a><br>
</blockquote></div><br></div></div></div>
</blockquote></div><br></div></div>