Avid tutorial: 'upstream pipe stall' error

"Upstream pipe stall" is not a common error, but can be a tricky one to solve when you encounter it since there are multiple possible causes, and there's not a lot of good info on the Avid forums about it. Here're some of the possibilities and how I solved it when it cropped up while transcoding raw footage on a project last year.