Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2013
    Posts
    10

    Unanswered: How to avoid Deadlocks...

    Hi,

    I have two tables, table A and B.Table A is Master table and table B is child table.They are having foreign key between them.

    There is Application X which updates/insertes in thse tables.
    And there is Application Y which uses joins with table A, B and other tables and uses the data.

    Now I am getting deadlocks and timeout in Application X and Y both.

    How can I remove the deadlocks and timeout in the above case and both Application X and Y can use the tables effectively.

  2. #2
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746
    application X and Y must commit more frequently. As simple as that
    Somewhere between " too small" and " too large" lies the size that is just right.
    - Scott Hayes

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Deadlock or timeout???

    What is the reason code in the message -911

    2 - Deadlock
    68 - Timeout


    ---
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  4. #4
    Join Date
    Feb 2013
    Posts
    10
    Hi,

    Both timeouts and deadlocks are happening.

    Also, as there are two tables, we do a commit only in the end of all updates/inserts, so that data in both the tables is in sunc.
    Last edited by prat31; 03-16-13 at 04:02.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •