[one-users] image pool duplicate key

Javier Fontan jfontan at opennebula.org
Thu Mar 13 08:07:19 PDT 2014

Indices are controlled by OpenNebula and the last id is saved to table
"pool_control". Modify it so the ID is greater that the latest image
and start oned again.

On Thu, Mar 13, 2014 at 2:34 PM, Ionut Popovici <ionut at hackaserver.com> wrote:
> Hello i had some hardware failure .. but i had some backup made .. so after
> installed full system back .. i had to recopy database from old backup ..
> and files .. added manualy in database the images .. to match the old
> configs and info .. but now if try to clone any image .. i get duplicate key
> .. i have try to change autoincrement for image_pool index but is not
> working any ideea ?
> SQL command was: INSERT INTO image_pool (oid, name, body, uid, gid, owner_u,
> group_u, other_u) VALUES
> error 1062 : Duplicate entry '0' for key 'PRIMARY'
> Thu Mar 13 14:21:14 2014 [ReM][E]: Req:9424 UID:0 ImageClone result FAILURE
> [ImageClone] Error allocating a new image.
> _______________________________________________
> Users mailing list
> Users at lists.opennebula.org
> http://lists.opennebula.org/listinfo.cgi/users-opennebula.org

Javier Fontán Muiños
OpenNebula - The Open Source Toolkit for Data Center Virtualization
www.OpenNebula.org | @OpenNebula | github.com/jfontan

More information about the Users mailing list