[Expired for neutron because there has been no activity for 60 days.]
** Changed in: neutron
Status: Incomplete => Expired
--
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):
Expired
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
