Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 01 Jan 2010 @ 19:54:38 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: Row Hash Deadlock in Active D/W due to concurrent MSR
From:   Devulapally, Kalyana

Hi Sohail,

1. Are the MSR updates in a transaction?

2. If yes, is more than one such "update" MSR sent in the same transaction?

3. If possible, please provide the "explain" for the update of the complete MSR request, not just the "update" to .

4. Please also include "show" sql of the MSR, to get the index and RI information, if any.

5. Does the deadlock error happen with just two parallel runs of the "update" sql?



  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016