Fix fallback from sse to longpolling 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.