yahoo-eng-team team mailing list archive

[LIU Yulong <yulong@xxxxxxxxxxxxx>]

Public bug reported:

During the DB upgrading of neutron, the following error raised:

CREATE TABLE ovn_hash_ring (
	node_uuid VARCHAR(36) NOT NULL, 
	group_name VARCHAR(256) NOT NULL, 
	hostname VARCHAR(256) NOT NULL, 
	created_at DATETIME NOT NULL, 
	updated_at DATETIME NOT NULL, 
	PRIMARY KEY (node_uuid, group_name)
)ENGINE=InnoDB


ERROR: 1071
Specified key was too long; max key length is 767 bytes

Execution Time : 00:00:00:000
Transfer Time  : 00:00:00:000
Total Time     : 00:00:00:000


[1] neutron/db/migration/alembic_migrations/versions/ussuri/expand/f4b9654dd40c_ovn_backend.py

** Affects: neutron
     Importance: Undecided
         Status: New

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

Title:
  "CREATE TABLE ovn_hash_ring" Specified key was too long; max key
  length is 767 bytes

Status in neutron:
  New

Bug description:
  During the DB upgrading of neutron, the following error raised:

  CREATE TABLE ovn_hash_ring (
  	node_uuid VARCHAR(36) NOT NULL, 
  	group_name VARCHAR(256) NOT NULL, 
  	hostname VARCHAR(256) NOT NULL, 
  	created_at DATETIME NOT NULL, 
  	updated_at DATETIME NOT NULL, 
  	PRIMARY KEY (node_uuid, group_name)
  )ENGINE=InnoDB

  
  ERROR: 1071
  Specified key was too long; max key length is 767 bytes

  Execution Time : 00:00:00:000
  Transfer Time  : 00:00:00:000
  Total Time     : 00:00:00:000

  
  [1] neutron/db/migration/alembic_migrations/versions/ussuri/expand/f4b9654dd40c_ovn_backend.py

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