Sometimes query cancellation did not work immediately with multiple file reads from S3 or HDFS

Sometimes query cancellation did not work immediately when we were reading multiple files from s3 or HDFS. Fixes #34301 Relates to #34397. #34539 (Dmitry Novik).