#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2008
    Posts
    10
    Rep Power
    0

    Dealing with limbo transactions


    Dears,

    We are using FB 2.5 (x64, W2k3, 20GB) and periodically get the situation where one or several tables get stuck at a specific record and fetching records after the given record takes hours to complete. But once it fetches to the end of the table, the table gets functional.

    What we observed to be the cause of this were stuck transactions, which we terminated by end-tasking windows processes behind them.

    Would you suggest a way to terminate limbo transactions (deleting mon$statements doesn't help) without having to terminate corresponding processes?

    Is there a way that we could auto-terminate all transactions that are taking longer than the specific duration?

    Thank you.
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jan 2006
    Location
    Carlsbad, CA
    Posts
    2,057
    Rep Power
    383
    we terminated by end-tasking windows processes behind them.
    Without laboring the obvious, you need to fix whatever is requiring this trauma.

    Presumably this drastic action is leaving your session in limbo until it times out.
    I am doubtful that any global setting to ease this situation is going to be ideal for normal processing.

    If it is really taking hours I suggest you try asking all users to exit and stop and start the server - or just do it. At least try it to see if that fixes the situation in which case it is (presumably) an open session issue.

    Just some (educated) guesses.

    Clive

IMN logo majestic logo threadwatch logo seochat tools logo