[one-users] image pool duplicate key

Ionut Popovici ionut at hackaserver.com
Thu Mar 13 06:34:34 PDT 2014


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.


More information about the Users mailing list