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"
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
