Fixes to allow cursors to be open during flush_tier

There's no architectural reason to requires cursors to close during a flush_tier (also it would be impractical).  For unknown reasons, it doesn't currently work to keep a cursor open, do a flush_tier and then use the open cursor.  The test for this skips this functionality, there is a FIXME comment.