registry team mailing list archive

[Sandy Walsh <677475@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

Ubuntu 10.10-64

% euca-run-instances ami-tiny --kernel aki-lucid --ramdisk ari-lucid -k
nova_key

if this fails due to networking problems or insufficient disk space (the
two conditions I hit) I cannot re-run the command due to a duplicate
instance-id database error (mysql). The nova db must be dropped and
recreated to get past this.

Doing euca-terminate-instance does not resolve the problem.

% euca-run-instances ami-tiny --kernel aki-lucid --ramdisk ari-lucid -k nova_key
IntegrityError: (IntegrityError) (1062, "Duplicate entry '2147483647' for key 'internal_id'") 'INSERT INTO instances (created_at, updated_at, deleted_at, deleted, internal_id, admin_pass, user_id, project_id, image_id, kernel_id, ramdisk_id, server_name, launch_index, key_name, key_data, state, state_description, memory_mb, vcpus, local_gb, hostname, host, instance_type, user_data, reservation_id, mac_address, scheduled_at, launched_at, terminated_at, display_name, display_description) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)' (datetime.datetime(2010, 11, 19, 14, 3, 40, 3977), None, None, False, 2874477778, None, 'sandy', 'darksecret', u'ami-tiny', u'aki-lucid', u'ari-lucid', None, 0, u'nova_key', 'ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAAAgQDYCSAjjqr3mlEvS7f8tu9GGd+hVOQO2c4U/BvFNeWJmdisXr122u3SWsqTGfzyU7067oqIiGvXCipnEi6AyPE5PKfRK68MQLb52jYMI5fHGWapb4I/hS6LKfbt0NXa8ZGnjCmvM5y6P1eJvs0W1+6/NAU31/MHkn2QcT3IFXahaw== swalsh@novadev\n', None, 'scheduling', 2048, 1, 20, None, None, u'm1.small', '', 'r-ahpmyjce', '02:16:3e:64:05:7b', None, None, None, None, None)

PS> in some situations ./instances/instance#### was not removed either,
but I can't consistently repo this.

** Affects: nova
     Importance: Undecided
         Status: New

-- 
Database not cleaned up when run-instances fails
https://bugs.launchpad.net/bugs/677475
You received this bug notification because you are a member of Registry
Administrators, which is subscribed to OpenStack.