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