yahoo-eng-team team mailing list archive

[Trinh Nguyen <dangtrinhnt@xxxxxxxxx>]

Public bug reported:

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

** Affects: keystone
     Importance: Undecided
         Status: New

** Description changed:

  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
+ - 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

-- 
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):
  New

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

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