Deleteing from sys_mutex problems

MarkGlen
Kilo Contributor

We have been using execution plans for all our Service Catalog items and we are now chaging over to WorkFlow for our items.

However we have encoutered a problem, under execution plan when you have closed off the final task it automatically closes off the parent item and then the parent request, it does this in about 2 seconds.

Since we have moved to the WF this process now takes about 60secs to complete.

I enabled logging and found 58 seconds of the following log message over and over

DELETE FROM sys_mutex WHERE sys_mutex.`name` = 'wf_context_5a5fb29e87f0700035f283bb89434dac' AND (sys_mutex.`touched` < '2012-10-03 09:04:45' OR sys_mutex.`touched` IS NULL

There were 1 of these log message every second for 58 seconds and the only difference is the time against the "touched" query changed to match the time of the log

Can anyone shed some light on what this means, i will be raising this with support but wondered if anyone had seen it before?

Thanks,
Mark

2 REPLIES 2

alex_wells
Kilo Contributor

Mark, did you get an answer on this? It's actually a known bug, under PRB574901, fixed in Berlin Patch 1 and newer.


MarkGlen
Kilo Contributor

You got in there just before me. We have just upgraded our instances this last week to hotfix 4 and been testing.

This has now been solved.

Thanks,
mark