Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2003
    Posts
    70

    Question Unanswered: Dead Lock Error in Replication

    Hello All,
    As I was going trough the log file generated (as a result of -Output <filepath> -OutputVerboseLevel 2). I saw some error lines which I would like to share:

    Percent Complete: 4
    Downloading data changes to the Subscriber
    The process could not enumerate changes at the 'Publisher'.
    Percent Complete: 0
    The process could not enumerate changes at the 'Publisher'.
    Percent Complete: 0
    Category:NULL
    Source: Merge Replication Provider
    Number: -2147200999
    Message: The process could not enumerate changes at the 'Publisher'.
    Percent Complete: 0
    Category:COMMAND
    Source: Failed Command
    Number: 0
    Message: {call sp_MSenumchanges(?,?,?,?,?,?,?,?)}
    Percent Complete: 0
    CategoryQLSERVER
    Source: SERVER_PUBLISHER
    Number: 1205
    Message: Transaction (Process ID 54) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
    Disconnecting from Publisher 'SERVER_PUBLISHER'
    Disconnecting from Subscriber 'SERVER_SUBS'
    Disconnecting from Publisher 'SERVER_PUBLISHER'
    Disconnecting from Publisher 'SERVER_PUBLISHER'
    Disconnecting from Publisher 'SERVER_PUBLISHER'
    Disconnecting from Publisher 'SERVER_PUBLISHER'
    Disconnecting from Subscriber 'SERVER_SUBS'
    Disconnecting from Subscriber 'SERVER_SUBS'
    Disconnecting from Subscriber 'SERVER_SUBS'
    Disconnecting from Subscriber 'SERVER_SUBS'
    Disconnecting from Publisher 'SERVER_PUBLISHER'
    Disconnecting from Distributor 'SERVER_PUBLISHER'


    I am using Merge Replication. I understand the process failed due to some DeadLocking. How do I further investigate this process and avoid it happening again in the future.

    Thanks
    Anand

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Try restarting the Merge Agent and check the query timeout value.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    Aug 2003
    Posts
    2
    I have encountered the same problem. Could you tell me how to set the query timeout value? Run command "sp_configure 'remote query timeout', 0" ?

  4. #4
    Join Date
    Jun 2003
    Location
    Malaysia
    Posts
    12
    Hi,

    1.Open SQL Enterprise Manager
    2.Expand the SQL Server Group > Select your server
    3.Right click on your server > Properties
    4.Go to the Connections Tab
    5.Enter the Query Timeout Value ( bottom ).
    Regards,

    Andy

    I hear and I forget. I see and I remember. I do and I understand

Posting Permissions

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