yahoo-eng-team team mailing list archive

[Nuriel Shem-Tov <nuri@xxxxxxxxxx>]

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