[one-users] image pool duplicate key

[Carlos Martín Sánchez]

Hi,

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.


OpenNebula includes the onedb fsck tool to check and fix DB consistency
problems:
http://docs.opennebula.org/stable/administration/references/onedb.html

Regards
--
Carlos Martín, MSc
Project Engineer
OpenNebula - Flexible Enterprise Cloud Made Simple
www.OpenNebula.org | cmartin at opennebula.org |
@OpenNebula<http://twitter.com/opennebula><cmartin at opennebula.org>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opennebula.org/pipermail/users-opennebula.org/attachments/20140313/97aadbe7/attachment-0002.htm>