Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 11 Mar 2003 @ 07:07:40 GMT


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


Subj:   Re: Dispatcher has timed out the transaction
 
From:   Manoj Varghese

Hi Rohit,

This error happened on a system when all of the AMP worker tasks are busy and there is only one available AMP worker tasks left. At this time, if the Dispatcher sends a transaction with an AMP step doing row redistribution to the mailbox, the only available AWT will become a sender task. However, since it is the last available AWT, the receiver does not get spawned, and the sender gets stuck waiting for the receiver. This transaction does not get CPU time, it also not being blocked and subjected to being aborted by the Dispatcher.


Regards,

Manoj



     
  <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: 15 Jun 2023