[Bug 1062277] Re: 092_add_instance_system_metadata migration fails when upgrading
** Tags removed: folsom-backport-potential -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to nova in Ubuntu. https://bugs.launchpad.net/bugs/1062277 Title: 092_add_instance_system_metadata migration fails when upgrading To manage notifications about this bug go to: https://bugs.launchpad.net/nova/+bug/1062277/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 1062277] Re: 092_add_instance_system_metadata migration fails when upgrading
in a conclusion. this is caused by human operation. not a code bug. ** Changed in: nova Status: In Progress = Invalid ** Changed in: nova (Ubuntu) Status: Confirmed = Invalid -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to nova in Ubuntu. https://bugs.launchpad.net/bugs/1062277 Title: 092_add_instance_system_metadata migration fails when upgrading To manage notifications about this bug go to: https://bugs.launchpad.net/nova/+bug/1062277/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 1062277] Re: 092_add_instance_system_metadata migration fails when upgrading
I'm curious as to why this is happening. When running the initial Essex/Folsom migrations we explicitly set the default DB schema to use the UTF8 charset. What do you see from the output of this query: SELECT default_character_set_name FROM information_schema.SCHEMATA S WHERE schema_name = nova; -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to nova in Ubuntu. https://bugs.launchpad.net/bugs/1062277 Title: 092_add_instance_system_metadata migration fails when upgrading To manage notifications about this bug go to: https://bugs.launchpad.net/nova/+bug/1062277/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 1062277] Re: 092_add_instance_system_metadata migration fails when upgrading
@Dan The default_character_set_name is set to 'latin1'. This system has been upgraded through various lifecycles of Openstack which may explain it (a more recent installation that I looked at is set to 'utf8'). I would argue that setting the character set explicitly on table creation is the correct and prevents these sorts of issues. -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to nova in Ubuntu. https://bugs.launchpad.net/bugs/1062277 Title: 092_add_instance_system_metadata migration fails when upgrading To manage notifications about this bug go to: https://bugs.launchpad.net/nova/+bug/1062277/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 1062277] Re: 092_add_instance_system_metadata migration fails when upgrading
OK I've figured it out. We had a DB issue in Essex to do with the projects table. I had to do a mysqldump and then reimport. This would've then had the DB at Essex but with character set for the database set to the default in mysql which is latin1. Thus missing the 077 migration which sets the database character set to utf-8. I agree with Andrew on this one, setting it explicitly on DB creation should prevent something like this. -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to nova in Ubuntu. https://bugs.launchpad.net/bugs/1062277 Title: 092_add_instance_system_metadata migration fails when upgrading To manage notifications about this bug go to: https://bugs.launchpad.net/nova/+bug/1062277/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 1062277] Re: 092_add_instance_system_metadata migration fails when upgrading
Fix proposed to branch: master Review: https://review.openstack.org/14617 ** Changed in: nova Status: Confirmed = In Progress ** Changed in: nova Assignee: (unassigned) = Sam Morrison (sorrison) -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to nova in Ubuntu. https://bugs.launchpad.net/bugs/1062277 Title: 092_add_instance_system_metadata migration fails when upgrading To manage notifications about this bug go to: https://bugs.launchpad.net/nova/+bug/1062277/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 1062277] Re: 092_add_instance_system_metadata migration fails when upgrading
** Tags added: folsom-backport-potential ** Changed in: nova Status: New = Confirmed ** Changed in: nova Importance: Undecided = Critical -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to nova in Ubuntu. https://bugs.launchpad.net/bugs/1062277 Title: 092_add_instance_system_metadata migration fails when upgrading To manage notifications about this bug go to: https://bugs.launchpad.net/nova/+bug/1062277/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 1062277] Re: 092_add_instance_system_metadata migration fails when upgrading
** Changed in: nova (Ubuntu) Importance: Undecided = Critical ** Changed in: nova (Ubuntu) Status: New = Confirmed -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to nova in Ubuntu. https://bugs.launchpad.net/bugs/1062277 Title: 092_add_instance_system_metadata migration fails when upgrading To manage notifications about this bug go to: https://bugs.launchpad.net/nova/+bug/1062277/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 1062277] Re: 092_add_instance_system_metadata migration fails when upgrading
** Patch added: 092_add_instance_system_metadata.patch https://bugs.launchpad.net/bugs/1062277/+attachment/3375835/+files/092_add_instance_system_metadata.patch -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to nova in Ubuntu. https://bugs.launchpad.net/bugs/1062277 Title: 092_add_instance_system_metadata migration fails when upgrading To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/nova/+bug/1062277/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 1062277] Re: 092_add_instance_system_metadata migration fails when upgrading
** Also affects: nova Importance: Undecided Status: New ** Tags added: openstack-ubuntu-upgrade -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to nova in Ubuntu. https://bugs.launchpad.net/bugs/1062277 Title: 092_add_instance_system_metadata migration fails when upgrading To manage notifications about this bug go to: https://bugs.launchpad.net/nova/+bug/1062277/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 1062277] Re: 092_add_instance_system_metadata migration fails when upgrading
The attachment 092_add_instance_system_metadata.patch of this bug report has been identified as being a patch. The ubuntu-reviewers team has been subscribed to the bug report so that they can review the patch. In the event that this is in fact not a patch you can resolve this situation by removing the tag 'patch' from the bug report and editing the attachment so that it is not flagged as a patch. Additionally, if you are member of the ubuntu-reviewers team please also unsubscribe the team from this bug report. [This is an automated message performed by a Launchpad user owned by Brian Murray. Please contact him regarding any issues with the action taken in this bug report.] ** Tags added: patch -- You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to nova in Ubuntu. https://bugs.launchpad.net/bugs/1062277 Title: 092_add_instance_system_metadata migration fails when upgrading To manage notifications about this bug go to: https://bugs.launchpad.net/nova/+bug/1062277/+subscriptions -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs