[Yahoo-eng-team] [Bug 1320855] Re: sql: migration from 37 to 38 version fails

2014-06-11 Thread Thierry Carrez 
** Changed in: keystone
   Status: Fix Committed = Fix Released

** Changed in: keystone
Milestone: None = juno-1

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

Title:
  sql: migration from 37 to 38 version fails

Status in OpenStack Identity (Keystone):
  Fix Released
Status in Keystone icehouse series:
  Fix Released

Bug description:
  Migration from Havana to Icehouse fails due to db_sync error, when
  migrating 37 to 38 sql schema:

  CRITICAL keystone [-] OperationalError: (OperationalError) (1005,
  Can't create table 'keystone.assignment' (errno: 150)) \nCREATE
  TABLE assignment (\n\ttype
  ENUM('UserProject','GroupProject','UserDomain','GroupDomain') NOT
  NULL, \n\tactor_id VARCHAR(64) NOT NULL, \n\ttarget_id VARCHAR(64) NOT
  NULL, \n\trole_id VARCHAR(64) NOT NULL, \n\tinherited BOOL NOT NULL,
  \n\tPRIMARY KEY (type, actor_id, target_id, role_id), \n\tFOREIGN
  KEY(role_id) REFERENCES role (id), \n\tCHECK (inherited IN (0,
  1))\n)\n\n ()#0122014-05-19 09:57:51.445 40373 TRACE keystone
  Traceback (most recent call last):#0122014-05-19 09:57:51.445 40373
  TRACE keystone   File /usr/bin/keystone-manage, line 51, in
  module#0122014-05-19 09:57:51.445 40373 TRACE keystone
  cli.main(argv=sys.argv, config_files=config_files)#0122014-05-19
  09:57:51.445 40373 TRACE keystone   File /usr/lib/python2.7/dist-
  packages/keystone/cli.py, line 191, in main#0122014-05-19
  09:57:51.445 40373 TRACE keystone
  CONF.command.cmd_class.main()#0122014-05-19 09:57:51.445 40373 TRACE
  keystone   File /usr/lib/python2.7/dist-packages/keystone/cli.py,
  line 67, in main#0122014-05-19 09:57:51.445 40373 TRACE keystone
  migration_helpers.sync_database_to_version(extension,
  version)#0122014-05-19 09:57:51.445 40373 TRACE keystone   File
  /usr/lib/python2.7/dist-
  packages/keystone/common/sql/migration_helpers.py, line 139, in
  sync_database_to_version#0122014-05-19 09:57:51.445 40373 TRACE
  keystone migration.db_sync(sql.get_engine(), abs_path,
  version=version)#0122014-05-19 09:57:51.445 40373 TRACE keystone
  File /usr/lib/python2.7/dist-
  packages/keystone/openstack/common/db/sqlalchemy/migration.py, line
  197, in db_sync#0122014-05-19 09:57:51.445 40373 TRACE keystone
  return versioning_api.upgrade(engine, repository,
  version)#0122014-05-19 09:57:51.445 40373 TRACE keystone   File
  /usr/lib/python2.7/dist-packages/migrate/versioning/api.py, line
  186, in upgrade#0122014-05-19 09:57:51.445 40373 TRACE keystone

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

-- 
Mailing list: https://launchpad.net/~yahoo-eng-team
Post to : yahoo-eng-team@lists.launchpad.net
Unsubscribe : https://launchpad.net/~yahoo-eng-team
More help   : https://help.launchpad.net/ListHelp

[Yahoo-eng-team] [Bug 1320855] Re: sql: migration from 37 to 38 version fails

2014-06-05 Thread Alan Pevec 
** Changed in: keystone/icehouse
   Status: Fix Committed = Fix Released

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

Title:
  sql: migration from 37 to 38 version fails

Status in OpenStack Identity (Keystone):
  Fix Committed
Status in Keystone icehouse series:
  Fix Released

Bug description:
  Migration from Havana to Icehouse fails due to db_sync error, when
  migrating 37 to 38 sql schema:

  CRITICAL keystone [-] OperationalError: (OperationalError) (1005,
  Can't create table 'keystone.assignment' (errno: 150)) \nCREATE
  TABLE assignment (\n\ttype
  ENUM('UserProject','GroupProject','UserDomain','GroupDomain') NOT
  NULL, \n\tactor_id VARCHAR(64) NOT NULL, \n\ttarget_id VARCHAR(64) NOT
  NULL, \n\trole_id VARCHAR(64) NOT NULL, \n\tinherited BOOL NOT NULL,
  \n\tPRIMARY KEY (type, actor_id, target_id, role_id), \n\tFOREIGN
  KEY(role_id) REFERENCES role (id), \n\tCHECK (inherited IN (0,
  1))\n)\n\n ()#0122014-05-19 09:57:51.445 40373 TRACE keystone
  Traceback (most recent call last):#0122014-05-19 09:57:51.445 40373
  TRACE keystone   File /usr/bin/keystone-manage, line 51, in
  module#0122014-05-19 09:57:51.445 40373 TRACE keystone
  cli.main(argv=sys.argv, config_files=config_files)#0122014-05-19
  09:57:51.445 40373 TRACE keystone   File /usr/lib/python2.7/dist-
  packages/keystone/cli.py, line 191, in main#0122014-05-19
  09:57:51.445 40373 TRACE keystone
  CONF.command.cmd_class.main()#0122014-05-19 09:57:51.445 40373 TRACE
  keystone   File /usr/lib/python2.7/dist-packages/keystone/cli.py,
  line 67, in main#0122014-05-19 09:57:51.445 40373 TRACE keystone
  migration_helpers.sync_database_to_version(extension,
  version)#0122014-05-19 09:57:51.445 40373 TRACE keystone   File
  /usr/lib/python2.7/dist-
  packages/keystone/common/sql/migration_helpers.py, line 139, in
  sync_database_to_version#0122014-05-19 09:57:51.445 40373 TRACE
  keystone migration.db_sync(sql.get_engine(), abs_path,
  version=version)#0122014-05-19 09:57:51.445 40373 TRACE keystone
  File /usr/lib/python2.7/dist-
  packages/keystone/openstack/common/db/sqlalchemy/migration.py, line
  197, in db_sync#0122014-05-19 09:57:51.445 40373 TRACE keystone
  return versioning_api.upgrade(engine, repository,
  version)#0122014-05-19 09:57:51.445 40373 TRACE keystone   File
  /usr/lib/python2.7/dist-packages/migrate/versioning/api.py, line
  186, in upgrade#0122014-05-19 09:57:51.445 40373 TRACE keystone

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

-- 
Mailing list: https://launchpad.net/~yahoo-eng-team
Post to : yahoo-eng-team@lists.launchpad.net
Unsubscribe : https://launchpad.net/~yahoo-eng-team
More help   : https://help.launchpad.net/ListHelp

[Yahoo-eng-team] [Bug 1320855] Re: sql: migration from 37 to 38 version fails

2014-06-02 Thread Dolph Mathews 
** Also affects: keystone/icehouse
   Importance: Undecided
   Status: New

** Changed in: keystone/icehouse
   Importance: Undecided = Medium

** Changed in: keystone/icehouse
 Assignee: (unassigned) = Emilien Macchi (emilienm)

** Changed in: keystone/icehouse
   Status: New = In Progress

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

Title:
  sql: migration from 37 to 38 version fails

Status in OpenStack Identity (Keystone):
  Fix Committed
Status in Keystone icehouse series:
  In Progress

Bug description:
  Migration from Havana to Icehouse fails due to db_sync error, when
  migrating 37 to 38 sql schema:

  CRITICAL keystone [-] OperationalError: (OperationalError) (1005,
  Can't create table 'keystone.assignment' (errno: 150)) \nCREATE
  TABLE assignment (\n\ttype
  ENUM('UserProject','GroupProject','UserDomain','GroupDomain') NOT
  NULL, \n\tactor_id VARCHAR(64) NOT NULL, \n\ttarget_id VARCHAR(64) NOT
  NULL, \n\trole_id VARCHAR(64) NOT NULL, \n\tinherited BOOL NOT NULL,
  \n\tPRIMARY KEY (type, actor_id, target_id, role_id), \n\tFOREIGN
  KEY(role_id) REFERENCES role (id), \n\tCHECK (inherited IN (0,
  1))\n)\n\n ()#0122014-05-19 09:57:51.445 40373 TRACE keystone
  Traceback (most recent call last):#0122014-05-19 09:57:51.445 40373
  TRACE keystone   File /usr/bin/keystone-manage, line 51, in
  module#0122014-05-19 09:57:51.445 40373 TRACE keystone
  cli.main(argv=sys.argv, config_files=config_files)#0122014-05-19
  09:57:51.445 40373 TRACE keystone   File /usr/lib/python2.7/dist-
  packages/keystone/cli.py, line 191, in main#0122014-05-19
  09:57:51.445 40373 TRACE keystone
  CONF.command.cmd_class.main()#0122014-05-19 09:57:51.445 40373 TRACE
  keystone   File /usr/lib/python2.7/dist-packages/keystone/cli.py,
  line 67, in main#0122014-05-19 09:57:51.445 40373 TRACE keystone
  migration_helpers.sync_database_to_version(extension,
  version)#0122014-05-19 09:57:51.445 40373 TRACE keystone   File
  /usr/lib/python2.7/dist-
  packages/keystone/common/sql/migration_helpers.py, line 139, in
  sync_database_to_version#0122014-05-19 09:57:51.445 40373 TRACE
  keystone migration.db_sync(sql.get_engine(), abs_path,
  version=version)#0122014-05-19 09:57:51.445 40373 TRACE keystone
  File /usr/lib/python2.7/dist-
  packages/keystone/openstack/common/db/sqlalchemy/migration.py, line
  197, in db_sync#0122014-05-19 09:57:51.445 40373 TRACE keystone
  return versioning_api.upgrade(engine, repository,
  version)#0122014-05-19 09:57:51.445 40373 TRACE keystone   File
  /usr/lib/python2.7/dist-packages/migrate/versioning/api.py, line
  186, in upgrade#0122014-05-19 09:57:51.445 40373 TRACE keystone

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

-- 
Mailing list: https://launchpad.net/~yahoo-eng-team
Post to : yahoo-eng-team@lists.launchpad.net
Unsubscribe : https://launchpad.net/~yahoo-eng-team
More help   : https://help.launchpad.net/ListHelp