Ceilometer

Migration 23 failing on MySQL

Bug #1288894 reported by Luis A. Garcia
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Ceilometer
Fix Released
Undecided
Luis A. Garcia
Ceilometer 2014.1 "icehouse"

Bug Description

Migration is failing with the following error:

 OperationalError: (OperationalError) (1005, "Can't create table 'ceilometer.#sql-cca_36' (errno: 150)") 'ALTER TABLE trait ADD CONSTRAINT fk_trait_type_id FOREIGN KEY(trait_type_id) REFERENCES trait_type (id)' ()
I, [2014-02-19T19:27:01.238298 #31994] INFO -- default-rhel65: 2014-02-19 13:27:58.430 6727 TRACE ceilometer

This problem is due to the storage engine for the trait_type table.
It needs to be InnoDB but it is not explicitly set so instead it is using the default engine which is MyISAM in MySQL < 5.5.

This is a similar bug to https://bugs.launchpad.net/ceilometer/+bug/1224666

Luis A. Garcia (luisg-8)
Changed in ceilometer:
assignee: nobody → Luis A. Garcia (luisg-8)
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to ceilometer (master)

Fix proposed to branch: master
Review: https://review.openstack.org/78742

Changed in ceilometer:
status: New → In Progress
Julien Danjou (jdanjou)
Changed in ceilometer:
milestone: none → icehouse-rc1
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to ceilometer (master)

Reviewed: https://review.openstack.org/78742
Committed: https://git.openstack.org/cgit/openstack/ceilometer/commit/?id=9b30feda8a89bf5d97837722fc9bb7a729b67f3e
Submitter: Jenkins
Branch: master

commit 9b30feda8a89bf5d97837722fc9bb7a729b67f3e
Author: Luis A. Garcia <email address hidden>
Date: Thu Mar 6 13:00:27 2014 -0700

    Set storage engine for the trait_type table

    Not setting the storage engine for this table can cause problems in
    those MySQL installations whose default storage engine is not InnoDB.

    Change-Id: Ifd0ed0ce7698eb840da87e3f393cd223dcfd36e1
    Closes-Bug: #1288894

Changed in ceilometer:
status: In Progress → Fix Committed
Thierry Carrez (ttx)
Changed in ceilometer:
status: Fix Committed → Fix Released
Thierry Carrez (ttx)
Changed in ceilometer:
milestone: icehouse-rc1 → 2014.1
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.