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

Hamada, Ondrej ondrej.hamada at acision.com
Tue Apr 8 15:13:34 PDT 2014


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.




More information about the Users mailing list