Keystone db_sync fails w/ PostgreSQL (migration 008)

[Dan Prince]

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."}'}

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: master
Review: https://review.openstack.org/20999

[Davanum Srinivas (DIMS) (dims-v)]

Stops the postgres gate job dead in its tracks:
https://jenkins.openstack.org/job/gate-tempest-devstack-vm-postgres-full/161/console

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/20999
Committed: http://github.com/openstack/keystone/commit/4722c84fb90c51fb5810ad7b46c48230ecee1a6c
Submitter: Jenkins
Branch: master

commit 4722c84fb90c51fb5810ad7b46c48230ecee1a6c
Author: Dan Prince <email address hidden>
Date: Fri Feb 1 09:20:12 2013 -0500

    Updates migration 008 to work on PostgreSQL.

    This fixes a regression in 5bc46d8 which caused migration 008 to
    fail when using PostgreSQL.

    Fixes LP Bug #1112535.

    Change-Id: I94f69c2dece3a5753eed3cc3cf7b63ba60208c5c