Fix test_failpoints to close queries after cancel

Change-Id: I4f272ccec84030d8b4f85d0e1554a042ee26be30
Reviewed-on: http://gerrit.ent.cloudera.com:8080/2092
Reviewed-by: Ishaan Joshi <ishaan@cloudera.com>
Tested-by: jenkins