[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