Deleteing from sys_mutex problems
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-03-2012 02:22 AM
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
- Labels:
-
Service Mapping
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-21-2012 03:07 AM
Mark, did you get an answer on this? It's actually a known bug, under PRB574901, fixed in Berlin Patch 1 and newer.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-21-2012 03:19 AM
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