← Back to team overview

yahoo-eng-team team mailing list archive

[Bug 1754376] Re: keystone db_sync error "Index column size too large. The maximum column size is 767 bytes."

 

Hi Colleen. Thanks for the information. I will mark this as invalid.

** Changed in: keystone
       Status: Incomplete => Invalid

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to OpenStack Identity (keystone).
https://bugs.launchpad.net/bugs/1754376

Title:
  keystone db_sync error "Index column size too large. The maximum
  column size is 767 bytes."

Status in OpenStack Identity (keystone):
  Invalid

Bug description:
  When I populate the keystone database with the following command:

  su -s /bin/sh -c "keystone-manage db_sync" keystone

  I got this error:

  DBError: (pymysql.err.InternalError) (1709, u'Index column size too large. The maximum column size is 767 bytes.') [SQL: u'\nCREATE TABLE migrate_version (\n\trepository_id VARCHAR(250) NOT NULL, \n\trepository_path TEXT, \n\tversion INTEGER, \n\tPRIMARY KEY (repository_id)\n)\n\n'] (Background on this error at: http://sqlalche.me/e/2j85)
  2018-03-09 00:31:18.480 19707 ERROR keystone

  Full errors: http://paste.openstack.org/show/695366/

  - OS: Uubntu desktop 16.04 LTS
  - Keystone ppa: https://launchpad.net/~ubuntu-cloud-archive/+archive/ubuntu/queens-staging
  - Mariadb: 10.0.33-MariaDB-0ubuntu0.16.04.1
  - Install keystone standlalone (not with other services)

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


References