I have been getting errors while running syncs, and I finally tracked down what is causing the error, but I am not sure why the wait locks are happening.
Here is the SQL results for the query (show the active query list):
SELECT sqltext.TEXT, req.session_id, req.status, req.start_time, req.command, req.cpu_time, req.total_elapsed_time, req.wait_type FROM sys.dm_exec_requests req
CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS sqltext
TEXT session_id status start_time command cpu_time total_elapsed_time wait_type
(@1 varchar(8000))DELETE [txnitemlinedetail] WHERE [IDKEY]=@1 86 suspended 2020-01-28 10:59:35.537 DELETE 0 59695 LCK_M_IX
corresponding Opensync Log File
2020-01-28 10:59:34 0 ModAccess Refresh Table: bill
2020-01-28 11:00:36 -2147217871 ModAccess ERROR: Query timeout expired(UpdateEntryDB TxnID in table bill 674FC0-1580166824 674FC0-1580166824)
2020-01-28 11:00:36 -2147217871 ModAccess ERROR: Query timeout expired TxnID(RefreshDatabase TxnID in table bill 674FC0-1580166824 674FC0-1580166824)
2020-01-28 11:00:36 0 ModAccess ERROR: (GenMakeDBRecs: Query timeout expired TxnID err#:-2147217871 field:TxnID: in table bill 674FC0-1580166824 – )
I am wondering if there are any suggestions as to why the wait lock is happening?
Any help is very much appreciated.
You must be logged in to reply to this topic.