[one-users] One and MySQL deadlocks and primary key reuse

[Carlos Martín Sánchez]

Hi,

Can you send the relevant section of oned.log? It will be useful to know
the operations that oned was trying to do when this happens.

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>


On Wed, Apr 9, 2014 at 12:13 AM, Hamada, Ondrej
<ondrej.hamada at acision.com>wrote:

> Hi everyone,
>
> my opennebula 4.4 reports problems when issuing sql commands. It reports
> mainly:
>
> "error 1213 : Deadlock found when trying to get lock; try restarting
> transaction"
> and occasionally also:
> "error 1062 : Duplicate entry '19608-1396968279' for key 'PRIMARY'"
>
> I'm using mysql 5.5 as db. One seems to continue working, but I'm afraid
> I've missed something.
>
> Do you have any idea what might be wrong and how to fix it?
>
> Thank you in advance
>
> Ondra
>
> This e-mail and any attachment is for authorised use by the intended
> recipient(s) only. It may contain proprietary material, confidential
> information and/or be subject to legal privilege. It should not be copied,
> disclosed to, retained or used by, any other party. If you are not an
> intended recipient then please promptly delete this e-mail and any
> attachment and all copies and inform the sender. Thank you for
> understanding.
>
>
> _______________________________________________
> Users mailing list
> Users at lists.opennebula.org
> http://lists.opennebula.org/listinfo.cgi/users-opennebula.org
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opennebula.org/pipermail/users-opennebula.org/attachments/20140410/62fd78c4/attachment.htm>