Public bug reported: This has been observed under the following conditions:
- Currently using IceHouse - Not using neutron-db-manage, but rather relying on neutron-server process to create tables upon startup - MySQL is set to default engine MyISAM Neutron attempts to create its tables in the empty designated database. This process breaks (MySQL error). The reason being that the 'agents' table is defaulting to "MyISAM" -- neutron is missing a directive to set the engine to InnoDB. Subsequently, InnoDB tables trying to be created while referring to this table - fail. A proposed solution _avoiding_ having to set InnoDB as the default engine in my.cnf: At /usr/lib/python2.6/site-packages/neutron/db/agents_db.py at line 48, adding the line: {'mysql_engine': 'InnoDB'} This is for the __table_args__ definition, which should then look like this: __table_args__ = ( sa.UniqueConstraint('agent_type', 'host', name='uniq_agents0agent_type0host'), {'mysql_engine': 'InnoDB'} ) ** 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/1329235 Title: "agents" table not created as InnoDB when MySQL's engine is set to MyISAM, breaks subsequent table creation Status in OpenStack Neutron (virtual network service): New Bug description: This has been observed under the following conditions: - Currently using IceHouse - Not using neutron-db-manage, but rather relying on neutron-server process to create tables upon startup - MySQL is set to default engine MyISAM Neutron attempts to create its tables in the empty designated database. This process breaks (MySQL error). The reason being that the 'agents' table is defaulting to "MyISAM" -- neutron is missing a directive to set the engine to InnoDB. Subsequently, InnoDB tables trying to be created while referring to this table - fail. A proposed solution _avoiding_ having to set InnoDB as the default engine in my.cnf: At /usr/lib/python2.6/site-packages/neutron/db/agents_db.py at line 48, adding the line: {'mysql_engine': 'InnoDB'} This is for the __table_args__ definition, which should then look like this: __table_args__ = ( sa.UniqueConstraint('agent_type', 'host', name='uniq_agents0agent_type0host'), {'mysql_engine': 'InnoDB'} ) To manage notifications about this bug go to: https://bugs.launchpad.net/neutron/+bug/1329235/+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