Re: Duplicate entry for key guid

[Dag Sonstebo]

Hi Christian,

First place to check is your vm_instance table and host tables:

SELECT * FROM cloud.vm_instance where name like ''s-2032-VM%".
SELECT * FROM cloud.host where name like ''s-2032-VM%".

Obviously also do a global search across all tables for 
"'s-2032-VM-PremiumSecondaryStorageResource".

Let us know what you find.

Regards,
Dag Sonstebo
Cloud Architect
ShapeBlue
 

On 11/02/2019, 23:23, "cristian.c@istream.today" <cristian.c@istream.today> 
wrote:

    Hello folks,
    
     
    
       I need some help on this issue :
    
     
    
    Caused by:
    com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException:
    Duplicate entry 's-2032-VM-PremiumSecondaryStorageResource' for key 'guid'
    
            at sun.reflect.GeneratedConstructorAccessor293.newInstance(Unknown
    Source)
    
            at
    sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstruc
    torAccessorImpl.java:45)
    
            at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
    
            ... 52 more
    
    2019-02-11 17:43:12,515 WARN  [c.c.a.m.AgentManagerImpl]
    (AgentConnectTaskPool-97:ctx-e446350c) (logid:614a489d) Unable to create
    attache for agent: Seq 0-0:  { Cmd , MgmtId: -1, via: 0, Ver: v1, Flags:
    101,
    [{"com.cloud.agent.api.StartupSecondaryStorageCommand":{"type":"SecondarySto
    rage","dataCenter":"1","pod":"1","guid":"s-2032-VM-PremiumSecondaryStorageRe
    source","name":"s-2032-
    
     
    
     
    
    I try to find this in database to check what is wrong and fix but I'm not
    sure where is located this duplicated entry.  
    
     
    
    This issue occurred after my VMware crashed because of the SQL server, after
    I fixed the vCenter I found this issue in cloudstack.
    
     
    
     
    
    Thank you,
    
    Regards.
    
     
    
       
    
    


dag.sonst...@shapeblue.com 
www.shapeblue.com
Amadeus House, Floral Street, London  WC2E 9DPUK
@shapeblue