OpenStack Heat

Index on 'tenant' column will be inefficient and 767 bytes per index key on MySQL

Bug #1290274 reported by Clint Byrum on 2014-03-10

This bug report is a duplicate of: Bug #1316646: heat-manage db_sync crashes on migration 033_software_config because of MySQL error 1709. Edit Remove

This bug affects 2 people

Affects		Status	Importance	Assigned to	Milestone
	OpenStack Heat	Triaged	Medium	Rakesh H S

Bug Description

/opt/stack/venvs/heat/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py:324: Warning: Specified key was too long; max key length is 767 bytes
cursor.execute(statement, parameters)

This column, at 256 "chars" will need 3x that in bytes just in case we store UTF-8.

Suggest evaluating whether this needs to be 256 chars, and whether or not it needs to be indexed.

Rakesh H S (rh-s) on 2014-07-07

Changed in heat:
assignee:	nobody → Rakesh H S (rh-s)

Report a bug

This report contains Public information

Everyone can see this information.

Duplicate of bug #1316646 Remove

You are

Subscribing...

Edit bug mail

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.