This discussion is archived
3 Replies Latest reply: Mar 14, 2002 3:38 AM by 807581 RSS

Deadlock in Fusion database.

807581 Newbie
Currently Being Moderated
We sometimes experience a deadlock in the fusion system database. The lock is on the WFHSessionRole table. Has anyone experienced the same problems?
  • 1. Re: Deadlock in Fusion database.
    807581 Newbie
    Currently Being Moderated
    This sounds very unusual; I've certainly never heard of such a problem.

    You should open a support case up with iPlanet, and get their help.
  • 2. Re: Deadlock in Fusion database.
    807581 Newbie
    Currently Being Moderated
    Ah, I see you are using Microsoft SQL Server 7.0. All I can think is that you should open a case with tech support...and perhaps trace activity in the database services to see what is happening when the deadlock occurs. The trace flag you need to activate for DBSession partitions is trc:cr:7:4, which will trace all database service operations.
  • 3. Re: Deadlock in Fusion database.
    807581 Newbie
    Currently Being Moderated
    When a client connects to the process engine and creates a new session, and state logging is active for the engine, then session info is inserted into the WFSession and WFSessionRoles tables. When the session is terminated, then the rows are deleted from the tables.

    The tables are accessed in the same order during session creation and deletion, so it is hard to see how a deadlock can happen. We always access WFSession before WFSessionRoles, and they are both keyed by Session Identifier.
    Ron's question is a good one. What database product are you using?