Reply to: Subprocess Hanging: PIPE is your enemy

Thank you very much, Mr. Pearson! I have run into the same issue. I am writing a python script using subprocess to call oracle sqlplus. Everything worked perfect in development environment. When I ran my script in prod, it’s hanging. The sqlplus will return over 1 million records from prod database and the size is over 1.5 Gb. I have spent one week debugging and I couldn’t figure out why until I read your post. Thanks for sharing your investigation on this subprocess issue, you saved me tons of time! Btw, I am using Python 2.4.3 on RH linux 2.6.

formatting is with Markdown syntax. Comments are not displayed until they are approved by a moderator. Moderators will not approve unless the comment contributes value to the discussion.

remember info?