Fix fallback from sse to long polling to avoid infinite reconnecting loop.

- Abort the SSE request when timing it out.
- Updated tests to detect this condition.
- Updated MemoryHost to throw OperationCancelledException to mimic iis.

#1121