GrailsFlow

Execution of multiple Processes lead to Deadlock

Details

  • Type: Bug Bug
  • Status: Closed Closed
  • Priority: Blocker Blocker
  • Resolution: Fixed
  • Affects Version/s: 1.0
  • Fix Version/s: 1.0.12
  • Component/s: None
  • Labels:
    None
  • External Supervisor:
    Antonicheva, July
  • Executing Programmer:
    Please select
  • Ext Project Id:
    JCGFW-01

Description

In case of application is loaded with big number of started Processes (in depends of resources we started up to 300 workflow processes in one time) we detected DeadLocks on DB level in the logs.

How to reproduce problem:

  • we reproduce this under MSSQL 2005
  • please take Process and Action from attachment (grailsflow-app.zip) and apply to grailsflow test app
  • reduce the timeout for NodeActivator Job up to 0.5 secs
  • run Process many times from UI, when History of Processes will big enough (we reproduced this when about 1000 Processes were already executed) you can see deadlock in Logs.

Additionally we attached logs from the real applications with the same Exception (see deadlock.ZIP)

  1. deadlock.ZIP
    19/Dec/11 5:40 PM
    470 kB
    Staskov, Ivan
  2. grailsflow-app.zip
    19/Dec/11 5:39 PM
    209 kB
    Staskov, Ivan

Activity

Hide
Staskov, Ivan added a comment - 19/Dec/11 5:39 PM

Fake Process script, Action and log from grailsflow application.

Show
Staskov, Ivan added a comment - 19/Dec/11 5:39 PM Fake Process script, Action and log from grailsflow application.
Hide
Staskov, Ivan added a comment - 19/Dec/11 5:40 PM

Logs from the real application with deadlock.

Show
Staskov, Ivan added a comment - 19/Dec/11 5:40 PM Logs from the real application with deadlock.
Hide
Staskov, Ivan added a comment - 08/Feb/12 9:59 AM

Problem has been fixed after enable READ_COMMITTED_SNAPSHOT mode for MSSQL DB. It was tested in the real application.
Ticket can be closed.

Show
Staskov, Ivan added a comment - 08/Feb/12 9:59 AM Problem has been fixed after enable READ_COMMITTED_SNAPSHOT mode for MSSQL DB. It was tested in the real application. Ticket can be closed.

People

Vote (0)
Watch (0)

Dates

  • Created:
    19/Dec/11 4:25 PM
    Updated:
    24/Feb/12 8:46 AM
    Resolved:
    24/Feb/12 8:46 AM