[one-users] image pool duplicate key

[Javier Fontan]

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
> (0,'testasd','<IMAGE><ID>0</ID><UID>0</UID><GID>0</GID><UNAME>oneadmin</UNAME><GNAME>oneadmin</GNAME><NAME>testasd</NAME><PERMISSIONS><OWNER_U>1</OWNER_U><OWNER_M>1</OWNER_M><OWNER_A>0</OWNER_A><GROUP_U>0</GROUP_U><GROUP_M>0</GROUP_M><GROUP_A>0</GROUP_A><OTHER_U>0</OTHER_U><OTHER_M>0</OTHER_M><OTHER_A>0</OTHER_A></PERMISSIONS><TYPE>0</TYPE><DISK_TYPE>0</DISK_TYPE><PERSISTENT>1</PERSISTENT><REGTIME>1394716874</REGTIME><SOURCE></SOURCE><PATH>/var/lib/one/datastores/1/1870e708127c10e3a81f4bc62c5afdd6</PATH><FSTYPE></FSTYPE><SIZE>8192</SIZE><STATE>4</STATE><RUNNING_VMS>0</RUNNING_VMS><CLONING_OPS>0</CLONING_OPS><CLONING_ID>119</CLONING_ID><DATASTORE_ID>1</DATASTORE_ID><DATASTORE>default</DATASTORE><VMS></VMS><CLONES></CLONES><TEMPLATE><DEV_PREFIX><![CDATA[hd]]></DEV_PREFIX><FSTYPE><![CDATA[]]></FSTYPE></TEMPLATE></IMAGE>',0,0,1,0,0),
> 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
Developer
OpenNebula - The Open Source Toolkit for Data Center Virtualization
www.OpenNebula.org | @OpenNebula | github.com/jfontan