Could you check the reason for the deadlock?
mysql SHOW ENGINE INNODB STATUS\G
It probably refers to a next-lock issue, could you try setting:
mysql SET GLOBAL TRANSACTION ISOLATION LEVEL READ COMMITTED;
And check if the deadlocks are gone?
On Thu, Sep 11, 2014 at 9:39 PM, Galimba
Hi,
no workarounds so far. But my mysql db is using default options and also runs
in a virtual machine – so I suspect it just needs some tweaking. I’m going to
change few parameters during this week. I’ll post the results to mailing list
if it works.
Ondra
From: Galimba
uppon closer examination, we figured out that the deadlocks were not
related to the image problem.
I was able to fix the uploading problem using this [1], but the random
deadlock issue persists. I tried to onedb fsck, backup it and restore it...
but it's all the same.
[1] -
I found this [1] mail and I believe the deadlock issue is the same I'm
having.
Any pointers on a workaround?
Best regards
galimba
[1]
http://lists.opennebula.org/pipermail/users-opennebula.org/2014-April/044546.html
On Tue, Sep 9, 2014 at 5:53 PM, Galimba gali...@gmail.com wrote:
Greetings!
Greetings!
I've recently upgraded from v4.4 to 4.6. As part of the upgrade, we decided
to create a new db using MySQL. The configurations ran smooth, all nodes
and datastores are being monitored without issues but when I tried to
upload a ttylinux image for testing, sunstone didn't show the image