yahoo-eng-team team mailing list archive

[Mark McClain <1297607@xxxxxxxxxxxxxxxxxx>]

** Changed in: neutron
       Status: New => Won't Fix

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

Title:
  Key length issue with UTF-8 database

Status in OpenStack Neutron (virtual network service):
  Won't Fix

Bug description:
  On Icehouse-3, the neutron-server daemon generates the following error
  on startup when configured to use a UTF-8 database:

  2014-03-25 21:23:17.942 26195 INFO neutron.db.api [-] Database
  registration exception: (OperationalError) (1071, 'Specified key was
  too long; max key length is 1000 bytes') '\nCREATE TABLE agents
  (\n\tid VARCHAR(36) NOT NULL, \n\tagent_type VARCHAR(255) NOT NULL,
  \n\t`binary` VARCHAR(255) NOT NULL, \n\ttopic VARCHAR(255) NOT NULL,
  \n\thost VARCHAR(255) NOT NULL, \n\tadmin_state_up BOOL NOT NULL,
  \n\tcreated_at DATETIME NOT NULL, \n\tstarted_at DATETIME NOT NULL,
  \n\theartbeat_timestamp DATETIME NOT NULL, \n\tdescription
  VARCHAR(255), \n\tconfigurations VARCHAR(4095) NOT NULL, \n\tPRIMARY
  KEY (id), \n\tCONSTRAINT uniq_agents0agent_type0host UNIQUE
  (agent_type, host), \n\tCHECK (admin_state_up IN (0, 1))\n)\n\n' ()

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