plainblack.com
Username Password
search
Bookmark and Share
View All Tickets
pbworkflow000000000007 Hanging  (#10189)
Issue

pbworkflow000000000007 hangs in the WorkflowInstance table without a currentActivityId indefinitely until spectre is restarted and then mail operations work again processing all queued messages since the hang.

At first it appeared that it was the result of the upgrade to 7.6.15 and a one-time-only problem, but it has since reoccurred, working fine for a while, then hanging again.

Solution Summary
Comments
perlDreamer
0
4/15/2009 12:23 pm
There's quite a bit of code in Workflow, Workflow::Instance and Workflow::Activity for handling the case of a non-existant currentActivityId.  Could you dump the whole row for that instance?
David
0
4/17/2009 1:21 pm
Sure:

$ date
Wed Apr 16 08:22:21 CDT 2009

mysql> SELECT * FROM WorkflowInstance WHERE workflowId='pbworkflow000000000007';

instanceId => l6bLtYYnDunbfRmhIvBceg
workflowId => pbworkflow000000000007
currentActivityId =>
priority => 3
className => NULL
methodName => NULL
parameters => {"parameters":{}}
runningSince => 1239300911
lastUpdate => 1239300911
lastStatus => NULL
noSession => 0

1 row in set (0.01 sec)

mysql>

# To save you some effort:
1239300911 ---> Thu Apr  9 14:15:11 2009

I believe that delikat has been looking at this as well.

-Thx
pvanthony
3
4/17/2009 2:26 pm
I too am experiencing the same problem.

Currently there is a cron job that restarts the spectre every 6 hours.

Will stop the cron job and see if the problem still there.

Using 7.6.20 with wre 0.8.5
perlDreamer
0
4/20/2009 10:12 pm
did a pretty extensive debug into 1 site with this problem.  It was 1 install running multiple sites, and when one of the sites requested spectreGetSiteData, apache was resolving to another site.  This caused two sets of cron data to be run on one site, which made the singleton workflows to clash.
perlDreamer
0
3/1/2010 11:35 am
New developments in this bug:

http://www.webgui.org/use/bugs/tracker/11444
perlDreamer
0
4/19/2010 10:07 am
Fixed in 7.8.18 (18b679d)
Fixed in 7.9.3 (ea5e82b)
Details
Ticket Status Resolved  
Rating3.0 
Submitted Bydhuggins 
Date Submitted2009-04-15 
Assigned To perlDreamer  
Date Assigned2009-11-30 
Assigned ByperlDreamer 
Severity Critical (mostly not working)  
What's the bug in? WebGUI Stable  
WebGUI / WRE Version 7.6.15 stable  
URLbugs/tracker/10189
Keywords
Ticket History
4/19/2010
3:07 PM
Resolved perlDreamer
12/1/2009
5:22 AM
Assigned to perlDreamer perlDreamer
4/15/2009
3:54 PM
Ticket created dhuggins
© 2019 Plain Black Corporation | All Rights Reserved