[Bug 1061166] Re: ec2 instance IDs are broken after folsom upgrade
** Changed in: nova Milestone: grizzly-1 = 2013.1 -- 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/1061166 Title: ec2 instance IDs are broken after folsom upgrade To manage notifications about this bug go to: https://bugs.launchpad.net/nova/+bug/1061166/+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 1061166] Re: ec2 instance IDs are broken after folsom upgrade
** Tags removed: in-stable-folsom -- 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/1061166 Title: ec2 instance IDs are broken after folsom upgrade To manage notifications about this bug go to: https://bugs.launchpad.net/nova/+bug/1061166/+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 1061166] Re: ec2 instance IDs are broken after folsom upgrade
** Changed in: nova/folsom Status: Fix Committed = Fix Released -- 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/1061166 Title: ec2 instance IDs are broken after folsom upgrade To manage notifications about this bug go to: https://bugs.launchpad.net/nova/+bug/1061166/+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 1061166] Re: ec2 instance IDs are broken after folsom upgrade
** Changed in: nova Status: Fix Committed = Fix Released ** Changed in: nova Milestone: None = grizzly-1 -- 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/1061166 Title: ec2 instance IDs are broken after folsom upgrade To manage notifications about this bug go to: https://bugs.launchpad.net/nova/+bug/1061166/+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 1061166] Re: ec2 instance IDs are broken after folsom upgrade
** Changed in: nova/folsom Milestone: None = 2012.2.1 -- 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/1061166 Title: ec2 instance IDs are broken after folsom upgrade To manage notifications about this bug go to: https://bugs.launchpad.net/nova/+bug/1061166/+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 1061166] Re: ec2 instance IDs are broken after folsom upgrade
** Branch linked: lp:~openstack-ubuntu-testing/nova/raring-grizzly -- 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/1061166 Title: ec2 instance IDs are broken after folsom upgrade To manage notifications about this bug go to: https://bugs.launchpad.net/nova/+bug/1061166/+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 1061166] Re: ec2 instance IDs are broken after folsom upgrade
** Changed in: nova/folsom Assignee: (unassigned) = Adam Gandelman (gandelman-a) -- 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/1061166 Title: ec2 instance IDs are broken after folsom upgrade To manage notifications about this bug go to: https://bugs.launchpad.net/nova/+bug/1061166/+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 1061166] Re: ec2 instance IDs are broken after folsom upgrade
** Branch linked: lp:~openstack-ubuntu-testing/nova/precise-folsom- proposed -- 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/1061166 Title: ec2 instance IDs are broken after folsom upgrade To manage notifications about this bug go to: https://bugs.launchpad.net/nova/+bug/1061166/+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 1061166] Re: ec2 instance IDs are broken after folsom upgrade
** Also affects: nova/folsom Importance: Undecided Status: New ** Changed in: nova/folsom Status: New = Fix Committed ** Changed in: nova/folsom 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/1061166 Title: ec2 instance IDs are broken after folsom upgrade To manage notifications about this bug go to: https://bugs.launchpad.net/nova/+bug/1061166/+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 1061166] Re: ec2 instance IDs are broken after folsom upgrade
To answer my previous question for posterity, yes after removing duplicates and resetting the auto incremnt as described above and mismatch between the ids in instances and instance_id_mappings must be recitified: UPDATE instance_id_mappings,instances SET instance_id_mappings.id=instances.id WHERE instances.uuid=instance_id_mappings.uuid and instance_id_mappings.idinstances.id; seems to me instance_id_mappings only contains duplicated information which can only lead ot suffering like this, guess I should go read the code and revision history if I want to see how this came to be. -- 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/1061166 Title: ec2 instance IDs are broken after folsom upgrade To manage notifications about this bug go to: https://bugs.launchpad.net/nova/+bug/1061166/+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 1061166] Re: ec2 instance IDs are broken after folsom upgrade
This doesn't seem to be working for me, perhaps I implemented it incorrectly, or need to take further remedial action? (using ubuntu 12.04 coud archive version of nova-api as a base) copied the patched verion of nova/db/sqlalchemy/api.py to /usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/api.py and /usr/local/nova/nova/db/sqlalchemy/api.py then pycompiled /usr/lib/python2.7/dist- packages/nova/db/sqlalchemy/api.py (as there was an existing file of that name), I've restated the api service and even rebooted the system and still get the InstanceNotFound errors when attempting tho delete (euca-terminate-instances) or assign floating ips (euca-associate- address) -- 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/1061166 Title: ec2 instance IDs are broken after folsom upgrade To manage notifications about this bug go to: https://bugs.launchpad.net/nova/+bug/1061166/+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 1061166] Re: ec2 instance IDs are broken after folsom upgrade
Jon- Unfortunately if you've hit this bug, your instance_id_mappings table is already polluted with duplicate entries and the mapping between EC2 IDs and UUIDs is skewed.Someone may know a better work around, but in the meantime I'd take a look at the instance_id_mappings table and clean it of duplicate entries, ensuring the original rows remain (those copied during the original migration) if you wish to get back the original EC2 IDs. -- 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/1061166 Title: ec2 instance IDs are broken after folsom upgrade To manage notifications about this bug go to: https://bugs.launchpad.net/nova/+bug/1061166/+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 1061166] Re: ec2 instance IDs are broken after folsom upgrade
I see that for instances that were running during the upgrade, but I'm getting this error with new instances that do not have duplicate entries: euca-describe-instances i-4fb6 RESERVATION r-ttje080y 98333a1a28e746fa8c629c83a818ad57open INSTANCEi-4fb6 ami-0027flood-x26 flood-x26 running 0 m1.tiny 2012-10-09T14:42:16.000Znova euca-terminate-instances i-4fb6 InstanceNotFound: Instance i-4fb6 could not be found. nova show shows this as having UUID 3f5d9fbf-eb02-4531-bacd-90df69f1233a and converting the ec2 id to decimal gives me ID 20406 mysql select * from instance_id_mappings where uuid='3f5d9fbf-eb02-4531-bacd-90df69f1233a' or id=20406 ; +-+++-+---+--+ | created_at | updated_at | deleted_at | deleted | id| uuid | +-+++-+---+--+ | 2012-10-09 14:42:16 | NULL | NULL | 0 | 20406 | 3f5d9fbf-eb02-4531-bacd-90df69f1233a | +-+++-+---+--+ 1 row in set (0.00 sec) mysql select created_at,updated_at,deleted_at,id,uuid,hostname from instances where uuid='3f5d9fbf-eb02-4531-bacd-90df69f1233a' or id=20406 ; +-+-++---+--+---+ | created_at | updated_at | deleted_at | id| uuid | hostname | +-+-++---+--+---+ | 2012-10-09 14:42:16 | 2012-10-09 14:42:47 | NULL | 20297 | 3f5d9fbf-eb02-4531-bacd-90df69f1233a | flood-x26 | +-+-++---+--+---+ 1 row in set (0.00 sec) do I need to ensure instance_id_mappings.id == instances.id? thats' a little ugly, but possible to fix up on my end. -- 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/1061166 Title: ec2 instance IDs are broken after folsom upgrade To manage notifications about this bug go to: https://bugs.launchpad.net/nova/+bug/1061166/+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 1061166] Re: ec2 instance IDs are broken after folsom upgrade
This bug was fixed in the package nova - 2012.2-0ubuntu4 --- nova (2012.2-0ubuntu4) quantal; urgency=low * debian/patches/ubuntu/ubuntu-fix-ec2-instance-id-mappings.patch: Backport from trunk, Set read_deleted='yes' for instance_id_mappings. (LP: #1061166) -- Chuck Short zul...@ubuntu.com Tue, 09 Oct 2012 11:51:15 -0500 ** Changed in: nova (Ubuntu) Status: Confirmed = Fix Released -- 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/1061166 Title: ec2 instance IDs are broken after folsom upgrade To manage notifications about this bug go to: https://bugs.launchpad.net/nova/+bug/1061166/+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 1061166] Re: ec2 instance IDs are broken after folsom upgrade
** Branch linked: lp:ubuntu/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/1061166 Title: ec2 instance IDs are broken after folsom upgrade To manage notifications about this bug go to: https://bugs.launchpad.net/nova/+bug/1061166/+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 1061166] Re: ec2 instance IDs are broken after folsom upgrade
Reviewed: https://review.openstack.org/14240 Committed: http://github.com/openstack/nova/commit/b7e509af5d8bc3f9e26dea5cf5121c0f62348dc0 Submitter: Jenkins Branch:stable/folsom commit b7e509af5d8bc3f9e26dea5cf5121c0f62348dc0 Author: Adam Gandelman adam.gandel...@canonical.com Date: Thu Oct 4 14:10:32 2012 -0700 Set read_deleted='yes' for instance_id_mappings. Since the migration that creates the instance_id_mappings does not populated the 'deleted' column, queries to this table should not limit results to 'deleted=0'. Limiting to non-deleted rows results in duplicate mappings being created for existing instance mappings after an upgrade, and throws off the entire EC2 instance ID to UUID mapping. Fixes LP: #1061166 Change-Id: I8893954fcae94a71dcc284c1b3b23b53901437eb (cherry picked from commit 1d0402cf65458c941639f01334a996c11e592018) ** Tags added: in-stable-folsom -- 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/1061166 Title: ec2 instance IDs are broken after folsom upgrade To manage notifications about this bug go to: https://bugs.launchpad.net/nova/+bug/1061166/+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 1061166] Re: ec2 instance IDs are broken after folsom upgrade
** Branch linked: lp:~openstack-ubuntu-testing/nova/quantal-folsom -- 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/1061166 Title: ec2 instance IDs are broken after folsom upgrade To manage notifications about this bug go to: https://bugs.launchpad.net/nova/+bug/1061166/+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 1061166] Re: ec2 instance IDs are broken after folsom upgrade
Reviewed: https://review.openstack.org/14063 Committed: http://github.com/openstack/nova/commit/1d0402cf65458c941639f01334a996c11e592018 Submitter: Jenkins Branch:master commit 1d0402cf65458c941639f01334a996c11e592018 Author: Adam Gandelman adam.gandel...@canonical.com Date: Thu Oct 4 14:10:32 2012 -0700 Set read_deleted='yes' for instance_id_mappings. Since the migration that creates the instance_id_mappings does not populated the 'deleted' column, queries to this table should not limit results to 'deleted=0'. Limiting to non-deleted rows results in duplicate mappings being created for existing instance mappings after an upgrade, and throws off the entire EC2 instance ID to UUID mapping. Fixes LP: #1061166 Change-Id: I8893954fcae94a71dcc284c1b3b23b53901437eb ** Changed in: nova Status: In Progress = Fix Committed -- 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/1061166 Title: ec2 instance IDs are broken after folsom upgrade To manage notifications about this bug go to: https://bugs.launchpad.net/nova/+bug/1061166/+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 1061166] Re: ec2 instance IDs are broken after folsom upgrade
** 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/1061166 Title: ec2 instance IDs are broken after folsom upgrade To manage notifications about this bug go to: https://bugs.launchpad.net/nova/+bug/1061166/+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 1061166] Re: ec2 instance IDs are broken after folsom upgrade
Status changed to 'Confirmed' because the bug affects multiple users. ** 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/1061166 Title: ec2 instance IDs are broken after folsom upgrade To manage notifications about this bug go to: https://bugs.launchpad.net/nova/+bug/1061166/+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 1061166] Re: ec2 instance IDs are broken after folsom upgrade
** Tags added: ec2 -- 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/1061166 Title: ec2 instance IDs are broken after folsom upgrade To manage notifications about this bug go to: https://bugs.launchpad.net/nova/+bug/1061166/+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 1061166] Re: ec2 instance IDs are broken after folsom upgrade
I upgraded today and found that I had this issue. Not all of my instances had duplicate entries in the `instance_id_mappings` table, however I did have more entries within the `instance_id_mappings` than within the `instances` table. It seems that the `id` column in the `instances` table is still being used somewhere. In order to work around the problem I needed to set the auto_increment integer to be the same for each table. Example: -- grab the auto_increment integer for `instances` table SELECT Auto_increment FROM information_schema.tables WHERE table_name='instances' AND table_schema='nova'; -- grab the auto_increment integer for `instances` table SELECT Auto_increment FROM information_schema.tables WHERE table_name='instance_id_mappings' AND table_schema='nova'; -- raise the lowest number returned to the same as the highest for the relevant table. ALTER TABLE instances AUTO_INCREMENT = 1769801923; -- 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/1061166 Title: ec2 instance IDs are broken after folsom upgrade To manage notifications about this bug go to: https://bugs.launchpad.net/nova/+bug/1061166/+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 1061166] Re: ec2 instance IDs are broken after folsom upgrade
This looks like a broken migration to me, based on the above comment: https://github.com/openstack/nova/blob/master/nova/db/sqlalchemy/migrate_repo/versions/107_add_instance_id_mappings.py -- 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/1061166 Title: ec2 instance IDs are broken after folsom upgrade To manage notifications about this bug go to: https://bugs.launchpad.net/nova/+bug/1061166/+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 1061166] Re: ec2 instance IDs are broken after folsom upgrade
It looks like the id column should have been set to auto-increment after the data copy was done -- 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/1061166 Title: ec2 instance IDs are broken after folsom upgrade To manage notifications about this bug go to: https://bugs.launchpad.net/nova/+bug/1061166/+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 1061166] Re: ec2 instance IDs are broken after folsom upgrade
From what I can gather the 107 migration only copies the instance's ID and UUID to the new mapping table, but leaves the other columns NULL, specifically 'deleted'. In Folsom, an ec2 describe instances call will check that the instances.id - uuid mapping exists in the instances_id_mapping table and create one if it does not find one. The query that checks the instances_id_mapping table has a 'deleted=0' constraint. In this case, all of the copied mappings have a NULL value here. Finding no mapping, it creates a new one and throws the whole thing off. It makes sense that this works fine on fresh Folsom installs, because new instances get a new mapping created in this empty table with the appropriate columns filled. There is still a relationship between instances.id and instance_id_mappings.id, and the duplicate entries being created in the mapping table throws that relationship off (after the table has duplicate entires created, new instances EC2 IDs are also off). I'm not sure if there needs to be a FK constraint between instances.id and instance_id_mappings.id to ensure that relationship is in-tact, even if the mappings table is being polluted with duplicates. -- 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/1061166 Title: ec2 instance IDs are broken after folsom upgrade To manage notifications about this bug go to: https://bugs.launchpad.net/nova/+bug/1061166/+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 1061166] Re: ec2 instance IDs are broken after folsom upgrade
Fix proposed to branch: master Review: https://review.openstack.org/14063 ** Changed in: nova Status: New = In Progress ** Changed in: nova Assignee: (unassigned) = Adam Gandelman (gandelman-a) -- 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/1061166 Title: ec2 instance IDs are broken after folsom upgrade To manage notifications about this bug go to: https://bugs.launchpad.net/nova/+bug/1061166/+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 1061166] Re: ec2 instance IDs are broken after folsom upgrade
The loose relationship between two auto_incrementing `id` columns of different tables is insanely brittle. I am not convinced that the intention was for the relation to work this way. It may simple be a problem with part of the code referencing `id` instead of `uuid`. The uuid's in the `instances_id_mapping` should, at the minimum, include a unique constraint. -- 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/1061166 Title: ec2 instance IDs are broken after folsom upgrade To manage notifications about this bug go to: https://bugs.launchpad.net/nova/+bug/1061166/+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 1061166] Re: ec2 instance IDs are broken after folsom upgrade
** Changed in: nova (Ubuntu) Importance: Undecided = High -- 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/1061166 Title: ec2 instance IDs are broken after folsom upgrade To manage notifications about this bug go to: https://bugs.launchpad.net/nova/+bug/1061166/+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 1061166] Re: ec2 instance IDs are broken after folsom upgrade
After taking another look at this, EC2 instance IDs appear to change during an upgrade. Did an upgrade with two running instances, i-0003 and i-0004. After upgrade, they show change to i-0003 and i-0004, respecively. Any EC2 action (terminate, get-console-output, etc) on these new IDs fail with InstanceNotFound. AFAICS: In essex, these IDs appear mapped to IDs and UUIDs in the instances table: mysql select id, uuid from instances where id=3 or id=4; ++--+ | id | uuid | ++--+ | 3 | 7ca30bdc-46f3-4a2d-a0fb-f7657d60e8a8 | | 4 | bf7ecf97-0814-4b5e-b5f1-4a7cecd8a43f | ++--+ 2 rows in set (0.00 sec) In Folsom, much has been converted to use UUIDs instead. the EC2 describe instances call gets a list of instances, and queries the instance_id_mappings for the corresponding instance ID (which will later get converted to an ec2 ID). However, after upgrade this table has duplicate entries for these instances, causing later queries on these instances to yield a new, incorrect ID. mysql select * from instance_id_mappings where uuid='bf7ecf97-0814-4b5e-b5f1-4a7cecd8a43f' or uuid='7ca30bdc-46f3-4a2d-a0fb-f7657d60e8a8'; +-+++-++--+ | created_at | updated_at | deleted_at | deleted | id | uuid | +-+++-++--+ | NULL| NULL | NULL |NULL | 3 | 7ca30bdc-46f3-4a2d-a0fb-f7657d60e8a8 | | NULL| NULL | NULL |NULL | 4 | bf7ecf97-0814-4b5e-b5f1-4a7cecd8a43f | | 2012-10-04 01:50:23 | NULL | NULL | 0 | 5 | 7ca30bdc-46f3-4a2d-a0fb-f7657d60e8a8 | | 2012-10-04 01:50:23 | NULL | NULL | 0 | 6 | bf7ecf97-0814-4b5e-b5f1-4a7cecd8a43f | +-+++-++--+ This can be worked around by change the EC2 layer to convert all incoming IDs to UUIDs, but the issue of instance IDs changing during a migration to Folsom is critical and needs to be resolved as an upgrade issue. -- 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/1061166 Title: ec2 instance IDs are broken after folsom upgrade To manage notifications about this bug go to: https://bugs.launchpad.net/nova/+bug/1061166/+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 1061166] Re: ec2 instance IDs are broken after folsom upgrade
Oops: should have read that instances i-0003 and i-0004 changed post-upgrade to i-0005 and i-0006 -- 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/1061166 Title: ec2 instance IDs are broken after folsom upgrade To manage notifications about this bug go to: https://bugs.launchpad.net/nova/+bug/1061166/+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
