yahoo-eng-team team mailing list archive

[Thierry Carrez <thierry.carrez+lp@xxxxxxxxx>]

** Changed in: keystone
       Status: Fix Committed => Fix Released

** Changed in: keystone
    Milestone: None => grizzly-3

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to Keystone.
https://bugs.launchpad.net/bugs/1112535

Title:
  Keystone db_sync fails w/ PostgreSQL (migration 008)

Status in OpenStack Identity (Keystone):
  Fix Released

Bug description:
  Using the latest keystone grizzly code I'm see failures when using
  PostgreSQL after commit 5bc46d8.

   [root@nova1 ~]# keystone-manage db_sync
  Traceback (most recent call last):
    File "/bin/keystone-manage", line 28, in <module>
      cli.main(argv=sys.argv, config_files=config_files)
    File "/usr/lib/python2.7/site-packages/keystone/cli.py", line 144, in main
      CONF.command.cmd_class.main()
    File "/usr/lib/python2.7/site-packages/keystone/cli.py", line 49, in main
      driver.db_sync()
    File "/usr/lib/python2.7/site-packages/keystone/identity/backends/sql.py", line 167, in db_sync
      migration.db_sync()
    File "/usr/lib/python2.7/site-packages/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/site-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/site-packages/migrate/versioning/util/__init__.py", line 159, in with_engine
      return f(*a, **kw)
    File "/usr/lib/python2.7/site-packages/migrate/versioning/api.py", line 366, in _migrate
      schema.runchange(ver, change, changeset.step)
    File "/usr/lib/python2.7/site-packages/migrate/versioning/schema.py", line 91, in runchange
      change.run(self.engine, step)
    File "/usr/lib/python2.7/site-packages/migrate/versioning/script/py.py", line 145, in run
      script_func(engine)
    File "/usr/lib/python2.7/site-packages/keystone/common/sql/migrate_repo/versions/008_create_default_domain.py", line 50, in upgrade
      domain)
    File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 802, in execute
      clause, params or {})
    File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1449, in execute
      params)
    File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1584, in _execute_clauseelement
      compiled_sql, distilled_params
    File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1698, in _execute_context
      context)
    File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1691, in _execute_context
      context)
    File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py", line 331, in do_execute
      cursor.execute(statement, parameters)
  sqlalchemy.exc.ProgrammingError: (ProgrammingError) syntax error at or near "`"
  LINE 1: INSERT INTO `domain` (`extra`, `enabled`, `id`, `name`) VALU...
                      ^
   'INSERT INTO `domain` (`extra`, `enabled`, `id`, `name`) VALUES (%(extra)s, %(enabled)s, %(id)s, %(name)s)' {'id': 'default', 'enabled': True, 'name': 'Default', 'extra': '{"description": "Owns users and tenants (i.e. projects) available on Identity API v2."}'}

To manage notifications about this bug go to:
https://bugs.launchpad.net/keystone/+bug/1112535/+subscriptions