Archives of the TeradataForum

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

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

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>>