yahoo-eng-team team mailing list archive

[Matt Kassawara <mkassawara@xxxxxxxxx>]

Public bug reported:

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' ()

** 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/1297607

Title:
  Key length issue with UTF-8 database

Status in OpenStack Neutron (virtual network service):
  New

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